PREVIEW / futures_1hour / 2009-06-14
file: by_date/futures_1hour/2009/2009-06-14.parquet size: 12 KB rows: 212
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-06-14 18:00:00 | ES | Futures | 905.34 | 905.58 | 902.92 | 903.65 | 4354.0 |
| 2009-06-14 19:00:00 | ES | Futures | 903.65 | 904.61 | 903.17 | 904.13 | 1335.0 |
| 2009-06-14 20:00:00 | ES | Futures | 904.37 | 904.37 | 901.96 | 902.68 | 3034.0 |
| 2009-06-14 21:00:00 | ES | Futures | 902.68 | 903.65 | 901.72 | 902.68 | 2436.0 |
| 2009-06-14 22:00:00 | ES | Futures | 902.68 | 903.41 | 902.44 | 902.68 | 815.0 |
| 2009-06-14 23:00:00 | ES | Futures | 902.92 | 902.92 | 901.96 | 902.2 | 1160.0 |
| 2009-06-14 18:00:00 | NQ | Futures | 1689.5 | 1689.5 | 1683.51 | 1684.94 | 229.0 |
| 2009-06-14 19:00:00 | NQ | Futures | 1684.65 | 1686.93 | 1683.8 | 1686.08 | 98.0 |
| 2009-06-14 20:00:00 | NQ | Futures | 1686.65 | 1686.65 | 1682.09 | 1683.8 | 228.0 |
| 2009-06-14 21:00:00 | NQ | Futures | 1683.8 | 1684.94 | 1682.66 | 1683.51 | 77.0 |
| 2009-06-14 22:00:00 | NQ | Futures | 1683.8 | 1684.94 | 1683.23 | 1683.23 | 74.0 |
| 2009-06-14 23:00:00 | NQ | Futures | 1683.8 | 1684.94 | 1682.66 | 1683.23 | 115.0 |
| 2009-06-14 18:00:00 | YM | Futures | 8061.0 | 8062.8 | 8035.1 | 8047.1 | 223.0 |
| 2009-06-14 19:00:00 | YM | Futures | 8045.3 | 8056.4 | 8044.4 | 8050.8 | 58.0 |
| 2009-06-14 20:00:00 | YM | Futures | 8051.8 | 8051.8 | 8035.1 | 8041.6 | 133.0 |
| 2009-06-14 21:00:00 | YM | Futures | 8040.7 | 8045.3 | 8035.1 | 8040.7 | 169.0 |
| 2009-06-14 22:00:00 | YM | Futures | 8041.6 | 8045.3 | 8038.8 | 8038.8 | 79.0 |
| 2009-06-14 23:00:00 | YM | Futures | 8040.7 | 8042.5 | 8035.1 | 8038.8 | 57.0 |
| 2009-06-14 18:00:00 | CL | Futures | 172.604 | 172.699 | 171.894 | 172.154 | 199.0 |
| 2009-06-14 19:00:00 | CL | Futures | 172.273 | 172.486 | 172.178 | 172.178 | 53.0 |
| 2009-06-14 20:00:00 | CL | Futures | 172.273 | 172.273 | 171.231 | 171.539 | 151.0 |
| 2009-06-14 21:00:00 | CL | Futures | 171.562 | 171.562 | 171.065 | 171.207 | 128.0 |
| 2009-06-14 22:00:00 | CL | Futures | 171.16 | 171.633 | 171.136 | 171.136 | 44.0 |
| 2009-06-14 23:00:00 | CL | Futures | 171.136 | 171.397 | 170.591 | 170.781 | 95.0 |
| 2009-06-14 18:00:00 | GC | Futures | 1332.2 | 1332.2 | 1325.7 | 1326.4 | 2364.0 |
| 2009-06-14 19:00:00 | GC | Futures | 1326.2 | 1330.2 | 1326.2 | 1330.2 | 702.0 |
| 2009-06-14 20:00:00 | GC | Futures | 1330.1 | 1330.3 | 1327.1 | 1328.9 | 1082.0 |
| 2009-06-14 21:00:00 | GC | Futures | 1328.9 | 1330.3 | 1328.9 | 1330.2 | 715.0 |
| 2009-06-14 22:00:00 | GC | Futures | 1330.2 | 1331.3 | 1329.6 | 1331.0 | 339.0 |
| 2009-06-14 23:00:00 | GC | Futures | 1331.0 | 1331.0 | 1328.9 | 1329.5 | 596.0 |
| 2009-06-14 18:00:00 | ZN | Futures | 90.745523 | 90.857126 | 90.571919 | 90.832325 | 1265.0 |
| 2009-06-14 19:00:00 | ZN | Futures | 90.844726 | 90.869526 | 90.757923 | 90.770324 | 1174.0 |
| 2009-06-14 20:00:00 | ZN | Futures | 90.757923 | 90.869526 | 90.757923 | 90.869526 | 1283.0 |
| 2009-06-14 21:00:00 | ZN | Futures | 90.869526 | 90.869526 | 90.807525 | 90.844726 | 1299.0 |
| 2009-06-14 22:00:00 | ZN | Futures | 90.844726 | 90.857126 | 90.832325 | 90.844726 | 962.0 |
| 2009-06-14 23:00:00 | ZN | Futures | 90.844726 | 90.857126 | 90.819925 | 90.844726 | 903.0 |
> showing 36 of 212 rows — these rows as CSV