PREVIEW / futures_1hour / 2009-02-01
file: by_date/futures_1hour/2009/2009-02-01.parquet size: 13 KB rows: 234
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-01 18:00:00 | ES | Futures | 781.53 | 783.9 | 780.81 | 781.05 | 6592.0 |
| 2009-02-01 19:00:00 | ES | Futures | 781.05 | 782.24 | 780.34 | 780.58 | 2890.0 |
| 2009-02-01 20:00:00 | ES | Futures | 780.81 | 783.19 | 780.34 | 783.19 | 3851.0 |
| 2009-02-01 21:00:00 | ES | Futures | 783.19 | 783.42 | 781.53 | 782.0 | 1749.0 |
| 2009-02-01 22:00:00 | ES | Futures | 782.0 | 782.95 | 779.15 | 779.39 | 2813.0 |
| 2009-02-01 23:00:00 | ES | Futures | 779.63 | 780.1 | 776.54 | 776.78 | 4671.0 |
| 2009-02-01 18:00:00 | NQ | Futures | 1333.97 | 1335.66 | 1329.17 | 1333.12 | 318.0 |
| 2009-02-01 19:00:00 | NQ | Futures | 1332.84 | 1334.53 | 1331.99 | 1331.99 | 71.0 |
| 2009-02-01 20:00:00 | NQ | Futures | 1332.55 | 1334.53 | 1332.27 | 1334.53 | 96.0 |
| 2009-02-01 21:00:00 | NQ | Futures | 1335.66 | 1335.94 | 1333.97 | 1334.81 | 22.0 |
| 2009-02-01 22:00:00 | NQ | Futures | 1334.25 | 1335.66 | 1329.73 | 1330.58 | 116.0 |
| 2009-02-01 23:00:00 | NQ | Futures | 1331.14 | 1331.14 | 1326.06 | 1326.34 | 108.0 |
| 2009-02-01 18:00:00 | YM | Futures | 7252.8 | 7269.2 | 7240.1 | 7251.0 | 628.0 |
| 2009-02-01 19:00:00 | YM | Futures | 7250.1 | 7256.5 | 7241.0 | 7242.8 | 345.0 |
| 2009-02-01 20:00:00 | YM | Futures | 7241.9 | 7267.4 | 7241.0 | 7266.5 | 357.0 |
| 2009-02-01 21:00:00 | YM | Futures | 7266.5 | 7268.3 | 7251.9 | 7254.7 | 147.0 |
| 2009-02-01 22:00:00 | YM | Futures | 7254.7 | 7261.9 | 7232.8 | 7232.8 | 297.0 |
| 2009-02-01 23:00:00 | YM | Futures | 7234.6 | 7237.3 | 7210.0 | 7213.6 | 637.0 |
| 2009-02-01 18:00:00 | CL | Futures | 125.12 | 126.8 | 125.06 | 125.96 | 498.0 |
| 2009-02-01 19:00:00 | CL | Futures | 125.99 | 126.08 | 125.18 | 125.42 | 136.0 |
| 2009-02-01 20:00:00 | CL | Futures | 125.39 | 125.87 | 125.27 | 125.42 | 89.0 |
| 2009-02-01 21:00:00 | CL | Futures | 125.42 | 125.87 | 125.33 | 125.66 | 60.0 |
| 2009-02-01 22:00:00 | CL | Futures | 125.66 | 126.02 | 125.57 | 125.75 | 97.0 |
| 2009-02-01 23:00:00 | CL | Futures | 125.78 | 125.81 | 124.55 | 124.67 | 503.0 |
| 2009-02-01 18:00:00 | GC | Futures | 1318.8 | 1321.6 | 1313.2 | 1318.6 | 1212.0 |
| 2009-02-01 19:00:00 | GC | Futures | 1318.8 | 1319.6 | 1315.2 | 1318.6 | 653.0 |
| 2009-02-01 20:00:00 | GC | Futures | 1318.3 | 1318.3 | 1307.4 | 1308.2 | 2273.0 |
| 2009-02-01 21:00:00 | GC | Futures | 1308.2 | 1309.2 | 1303.4 | 1303.8 | 2273.0 |
| 2009-02-01 22:00:00 | GC | Futures | 1303.8 | 1305.0 | 1302.1 | 1302.4 | 1563.0 |
| 2009-02-01 23:00:00 | GC | Futures | 1302.4 | 1304.3 | 1300.7 | 1302.3 | 1822.0 |
| 2009-02-01 18:00:00 | ZN | Futures | 94.642172 | 94.786848 | 94.606003 | 94.678341 | 266.0 |
| 2009-02-01 19:00:00 | ZN | Futures | 94.726567 | 94.750679 | 94.642172 | 94.750679 | 484.0 |
| 2009-02-01 20:00:00 | ZN | Futures | 94.738623 | 94.774792 | 94.726567 | 94.750679 | 1002.0 |
| 2009-02-01 21:00:00 | ZN | Futures | 94.750679 | 94.750679 | 94.702454 | 94.702454 | 293.0 |
| 2009-02-01 22:00:00 | ZN | Futures | 94.71451 | 94.859186 | 94.702454 | 94.859186 | 1259.0 |
| 2009-02-01 23:00:00 | ZN | Futures | 94.84713 | 94.907412 | 94.798905 | 94.907412 | 934.0 |
> showing 36 of 234 rows — these rows as CSV