PREVIEW / futures_1hour / 2011-01-30
file: by_date/futures_1hour/2011/2011-01-30.parquet size: 14 KB rows: 278
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-30 18:00:00 | ES | Futures | 1256.43 | 1258.17 | 1249.26 | 1252.72 | 46534.0 |
| 2011-01-30 19:00:00 | ES | Futures | 1252.48 | 1255.44 | 1252.23 | 1254.7 | 15665.0 |
| 2011-01-30 20:00:00 | ES | Futures | 1254.7 | 1259.16 | 1254.7 | 1258.17 | 18971.0 |
| 2011-01-30 21:00:00 | ES | Futures | 1258.17 | 1260.89 | 1257.42 | 1260.64 | 11149.0 |
| 2011-01-30 22:00:00 | ES | Futures | 1260.64 | 1260.89 | 1258.17 | 1258.91 | 6012.0 |
| 2011-01-30 23:00:00 | ES | Futures | 1258.91 | 1261.88 | 1258.41 | 1261.38 | 6153.0 |
| 2011-01-30 18:00:00 | NQ | Futures | 2601.09 | 2601.95 | 2581.57 | 2592.19 | 2845.0 |
| 2011-01-30 19:00:00 | NQ | Futures | 2591.62 | 2596.78 | 2591.62 | 2594.49 | 1160.0 |
| 2011-01-30 20:00:00 | NQ | Futures | 2594.77 | 2602.81 | 2594.49 | 2601.09 | 1836.0 |
| 2011-01-30 21:00:00 | NQ | Futures | 2600.51 | 2605.39 | 2599.94 | 2605.39 | 909.0 |
| 2011-01-30 22:00:00 | NQ | Futures | 2605.39 | 2605.97 | 2601.38 | 2602.52 | 597.0 |
| 2011-01-30 23:00:00 | NQ | Futures | 2602.81 | 2607.4 | 2601.95 | 2606.25 | 434.0 |
| 2011-01-30 18:00:00 | YM | Futures | 11254.9 | 11270.2 | 11196.5 | 11221.4 | 1132.0 |
| 2011-01-30 19:00:00 | YM | Futures | 11220.4 | 11235.7 | 11217.5 | 11231.9 | 1470.0 |
| 2011-01-30 20:00:00 | YM | Futures | 11233.8 | 11266.4 | 11231.0 | 11260.6 | 1166.0 |
| 2011-01-30 21:00:00 | YM | Futures | 11258.7 | 11276.9 | 11253.9 | 11276.9 | 619.0 |
| 2011-01-30 22:00:00 | YM | Futures | 11276.9 | 11277.9 | 11260.6 | 11265.4 | 595.0 |
| 2011-01-30 23:00:00 | YM | Futures | 11264.5 | 11291.3 | 11263.5 | 11283.6 | 544.0 |
| 2011-01-30 18:00:00 | CL | Futures | 165.0 | 165.9 | 164.28 | 165.84 | 7246.0 |
| 2011-01-30 19:00:00 | CL | Futures | 165.88 | 166.65 | 165.44 | 165.5 | 5190.0 |
| 2011-01-30 20:00:00 | CL | Futures | 165.5 | 165.53 | 164.63 | 164.67 | 3049.0 |
| 2011-01-30 21:00:00 | CL | Futures | 164.67 | 165.72 | 164.3 | 165.55 | 3203.0 |
| 2011-01-30 22:00:00 | CL | Futures | 165.53 | 165.55 | 164.78 | 164.95 | 1172.0 |
| 2011-01-30 23:00:00 | CL | Futures | 164.91 | 165.13 | 164.39 | 164.54 | 1650.0 |
| 2011-01-30 18:00:00 | GC | Futures | 1868.8 | 1880.2 | 1868.5 | 1878.0 | 4373.0 |
| 2011-01-30 19:00:00 | GC | Futures | 1878.0 | 1880.5 | 1872.3 | 1873.4 | 3724.0 |
| 2011-01-30 20:00:00 | GC | Futures | 1873.2 | 1873.7 | 1868.8 | 1868.9 | 2658.0 |
| 2011-01-30 21:00:00 | GC | Futures | 1869.0 | 1871.8 | 1867.8 | 1870.7 | 1823.0 |
| 2011-01-30 22:00:00 | GC | Futures | 1870.7 | 1871.6 | 1869.6 | 1869.6 | 842.0 |
| 2011-01-30 23:00:00 | GC | Futures | 1869.7 | 1869.9 | 1858.0 | 1860.0 | 5862.0 |
| 2011-01-30 18:00:00 | ZN | Futures | 102.021427 | 102.13969 | 101.995147 | 102.073989 | 9903.0 |
| 2011-01-30 19:00:00 | ZN | Futures | 102.047708 | 102.047708 | 101.955726 | 101.968866 | 10915.0 |
| 2011-01-30 20:00:00 | ZN | Futures | 101.968866 | 101.995147 | 101.850603 | 101.890024 | 9866.0 |
| 2011-01-30 21:00:00 | ZN | Futures | 101.890024 | 101.916305 | 101.850603 | 101.876884 | 4502.0 |
| 2011-01-30 22:00:00 | ZN | Futures | 101.876884 | 101.903164 | 101.863744 | 101.890024 | 2292.0 |
| 2011-01-30 23:00:00 | ZN | Futures | 101.890024 | 101.916305 | 101.876884 | 101.876884 | 1851.0 |
> showing 36 of 278 rows — these rows as CSV