PREVIEW / futures_1hour / 2010-09-26
file: by_date/futures_1hour/2010/2010-09-26.parquet size: 13 KB rows: 247
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2010-09-26 18:00:00 | ES | Futures | 1127.89 | 1133.56 | 1127.15 | 1131.83 | 21943.0 |
| 2010-09-26 19:00:00 | ES | Futures | 1132.08 | 1132.82 | 1131.34 | 1132.32 | 3744.0 |
| 2010-09-26 20:00:00 | ES | Futures | 1132.32 | 1132.57 | 1130.85 | 1131.34 | 4739.0 |
| 2010-09-26 21:00:00 | ES | Futures | 1131.34 | 1132.32 | 1130.11 | 1130.85 | 6277.0 |
| 2010-09-26 22:00:00 | ES | Futures | 1130.85 | 1131.09 | 1128.38 | 1128.87 | 9711.0 |
| 2010-09-26 23:00:00 | ES | Futures | 1128.63 | 1129.37 | 1127.64 | 1128.13 | 4907.0 |
| 2010-09-26 18:00:00 | NQ | Futures | 2316.74 | 2331.94 | 2316.45 | 2325.92 | 2373.0 |
| 2010-09-26 19:00:00 | NQ | Futures | 2326.21 | 2327.07 | 2324.77 | 2325.63 | 366.0 |
| 2010-09-26 20:00:00 | NQ | Futures | 2326.21 | 2327.07 | 2323.34 | 2324.48 | 321.0 |
| 2010-09-26 21:00:00 | NQ | Futures | 2324.48 | 2325.92 | 2322.19 | 2323.62 | 344.0 |
| 2010-09-26 22:00:00 | NQ | Futures | 2323.62 | 2323.91 | 2319.61 | 2319.89 | 462.0 |
| 2010-09-26 23:00:00 | NQ | Futures | 2320.47 | 2321.33 | 2318.75 | 2319.32 | 346.0 |
| 2010-09-26 18:00:00 | YM | Futures | 10283.9 | 10336.3 | 10279.1 | 10317.2 | 1658.0 |
| 2010-09-26 19:00:00 | YM | Futures | 10318.2 | 10325.8 | 10314.4 | 10320.1 | 159.0 |
| 2010-09-26 20:00:00 | YM | Futures | 10322.0 | 10322.9 | 10310.6 | 10316.3 | 293.0 |
| 2010-09-26 21:00:00 | YM | Futures | 10318.2 | 10324.8 | 10305.8 | 10312.5 | 589.0 |
| 2010-09-26 22:00:00 | YM | Futures | 10312.5 | 10314.4 | 10293.4 | 10295.3 | 493.0 |
| 2010-09-26 23:00:00 | YM | Futures | 10294.4 | 10301.0 | 10288.7 | 10290.6 | 544.0 |
| 2010-09-26 18:00:00 | CL | Futures | 144.67 | 145.37 | 144.59 | 145.08 | 1095.0 |
| 2010-09-26 19:00:00 | CL | Futures | 145.1 | 145.39 | 145.1 | 145.27 | 324.0 |
| 2010-09-26 20:00:00 | CL | Futures | 145.29 | 145.39 | 145.12 | 145.37 | 611.0 |
| 2010-09-26 21:00:00 | CL | Futures | 145.31 | 145.33 | 144.82 | 144.91 | 623.0 |
| 2010-09-26 22:00:00 | CL | Futures | 144.91 | 144.99 | 144.61 | 144.67 | 649.0 |
| 2010-09-26 23:00:00 | CL | Futures | 144.65 | 144.78 | 144.63 | 144.76 | 258.0 |
| 2010-09-26 18:00:00 | GC | Futures | 1817.6 | 1818.0 | 1814.0 | 1814.7 | 603.0 |
| 2010-09-26 19:00:00 | GC | Futures | 1815.0 | 1818.0 | 1814.3 | 1816.5 | 983.0 |
| 2010-09-26 20:00:00 | GC | Futures | 1816.5 | 1817.1 | 1815.5 | 1815.7 | 558.0 |
| 2010-09-26 21:00:00 | GC | Futures | 1815.7 | 1815.8 | 1813.4 | 1814.6 | 2178.0 |
| 2010-09-26 22:00:00 | GC | Futures | 1814.3 | 1815.5 | 1814.1 | 1815.4 | 555.0 |
| 2010-09-26 23:00:00 | GC | Futures | 1815.4 | 1815.8 | 1814.8 | 1815.4 | 653.0 |
| 2010-09-26 18:00:00 | ZN | Futures | 104.403945 | 104.469076 | 104.390919 | 104.45605 | 3077.0 |
| 2010-09-26 19:00:00 | ZN | Futures | 104.45605 | 104.469076 | 104.416972 | 104.429998 | 1956.0 |
| 2010-09-26 20:00:00 | ZN | Futures | 104.429998 | 104.45605 | 104.390919 | 104.429998 | 3216.0 |
| 2010-09-26 21:00:00 | ZN | Futures | 104.429998 | 104.495128 | 104.416972 | 104.45605 | 4946.0 |
| 2010-09-26 22:00:00 | ZN | Futures | 104.45605 | 104.495128 | 104.45605 | 104.482102 | 1449.0 |
| 2010-09-26 23:00:00 | ZN | Futures | 104.495128 | 104.508154 | 104.45605 | 104.482102 | 1316.0 |
> showing 36 of 247 rows — these rows as CSV