Skip to content

Instantly share code, notes, and snippets.

@mikedouglas
Created April 25, 2014 06:23
Show Gist options
  • Save mikedouglas/11279480 to your computer and use it in GitHub Desktop.
Save mikedouglas/11279480 to your computer and use it in GitHub Desktop.
btdx::NAVY=> SELECT * FROM market_btchistoricalrates WHERE date_trunc('second', timestamp) = '2014-02-15 00:58:00+00';
id | timestamp | bid_rate | ask_rate
-----+-------------------------------+--------------+--------------
161 | 2014-02-15 00:58:00.658727+00 | 655.05330000 | 668.67050000
162 | 2014-02-15 00:58:00.767935+00 | 655.05330000 | 668.67050000
163 | 2014-02-15 00:58:00.676315+00 | 655.05330000 | 668.67050000
164 | 2014-02-15 00:58:00.759772+00 | 655.05330000 | 668.67050000
165 | 2014-02-15 00:58:00.662886+00 | 655.05330000 | 668.67050000
166 | 2014-02-15 00:58:00.772852+00 | 655.05330000 | 668.67050000
167 | 2014-02-15 00:58:00.704243+00 | 655.03350000 | 668.67050000
168 | 2014-02-15 00:58:00.803234+00 | 655.03350000 | 668.67050000
169 | 2014-02-15 00:58:00.664675+00 | 653.30100000 | 666.60000000
170 | 2014-02-15 00:58:00.754501+00 | 653.30100000 | 666.60000000
171 | 2014-02-15 00:58:00.661023+00 | 653.30100000 | 666.60000000
172 | 2014-02-15 00:58:00.749775+00 | 653.30100000 | 666.60000000
173 | 2014-02-15 00:58:00.703154+00 | 653.30100000 | 666.60000000
174 | 2014-02-15 00:58:00.792042+00 | 653.30100000 | 666.60000000
175 | 2014-02-15 00:58:00.665455+00 | 653.30100000 | 666.60000000
176 | 2014-02-15 00:58:00.754975+00 | 653.30100000 | 666.60000000
177 | 2014-02-15 00:58:00.776396+00 | 653.30100000 | 666.60000000
178 | 2014-02-15 00:58:00.865175+00 | 653.30100000 | 666.60000000
179 | 2014-02-15 00:58:00.775225+00 | 653.30100000 | 666.60000000
180 | 2014-02-15 00:58:00.867361+00 | 653.30100000 | 666.60000000
181 | 2014-02-15 00:58:00.779629+00 | 652.70700000 | 666.60000000
182 | 2014-02-15 00:58:00.866482+00 | 652.70700000 | 666.60000000
183 | 2014-02-15 00:58:00.784245+00 | 652.70700000 | 666.60000000
184 | 2014-02-15 00:58:00.878504+00 | 652.70700000 | 666.60000000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment