PREVIEW / futures_1hour / 2009-03-08
file: by_date/futures_1hour/2009/2009-03-08.parquet size: 12 KB rows: 218
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-03-08 18:00:00 | ES | Futures | 653.45 | 654.39 | 652.02 | 652.97 | 7178.0 |
| 2009-03-08 19:00:00 | ES | Futures | 652.97 | 656.53 | 652.26 | 656.29 | 5783.0 |
| 2009-03-08 20:00:00 | ES | Futures | 656.53 | 657.48 | 654.87 | 655.34 | 4541.0 |
| 2009-03-08 21:00:00 | ES | Futures | 655.34 | 655.58 | 652.73 | 653.68 | 4096.0 |
| 2009-03-08 22:00:00 | ES | Futures | 653.68 | 654.39 | 652.02 | 652.97 | 4665.0 |
| 2009-03-08 23:00:00 | ES | Futures | 653.21 | 653.21 | 649.89 | 651.07 | 3689.0 |
| 2009-03-08 18:00:00 | NQ | Futures | 1216.21 | 1218.75 | 1213.11 | 1215.93 | 939.0 |
| 2009-03-08 19:00:00 | NQ | Futures | 1217.06 | 1222.43 | 1214.8 | 1222.43 | 393.0 |
| 2009-03-08 20:00:00 | NQ | Futures | 1222.43 | 1224.97 | 1220.45 | 1221.01 | 274.0 |
| 2009-03-08 21:00:00 | NQ | Futures | 1220.45 | 1221.01 | 1216.5 | 1218.19 | 136.0 |
| 2009-03-08 22:00:00 | NQ | Futures | 1219.6 | 1219.6 | 1215.08 | 1216.5 | 203.0 |
| 2009-03-08 23:00:00 | NQ | Futures | 1215.65 | 1216.21 | 1210.85 | 1213.11 | 156.0 |
| 2009-03-08 18:00:00 | YM | Futures | 6088.2 | 6091.0 | 6072.7 | 6080.0 | 489.0 |
| 2009-03-08 19:00:00 | YM | Futures | 6082.8 | 6109.2 | 6073.6 | 6106.4 | 640.0 |
| 2009-03-08 20:00:00 | YM | Futures | 6106.4 | 6117.4 | 6096.4 | 6098.2 | 379.0 |
| 2009-03-08 21:00:00 | YM | Futures | 6097.3 | 6100.1 | 6078.2 | 6087.3 | 373.0 |
| 2009-03-08 22:00:00 | YM | Futures | 6085.5 | 6089.1 | 6068.2 | 6081.8 | 307.0 |
| 2009-03-08 23:00:00 | YM | Futures | 6078.2 | 6080.0 | 6055.4 | 6060.0 | 244.0 |
| 2009-03-08 18:00:00 | CL | Futures | 118.4 | 119.67 | 118.38 | 119.67 | 415.0 |
| 2009-03-08 19:00:00 | CL | Futures | 119.62 | 120.96 | 119.28 | 120.71 | 817.0 |
| 2009-03-08 20:00:00 | CL | Futures | 120.73 | 120.99 | 120.39 | 120.47 | 525.0 |
| 2009-03-08 21:00:00 | CL | Futures | 120.42 | 120.81 | 120.34 | 120.55 | 458.0 |
| 2009-03-08 22:00:00 | CL | Futures | 120.58 | 120.65 | 119.85 | 120.14 | 299.0 |
| 2009-03-08 23:00:00 | CL | Futures | 120.19 | 120.34 | 119.67 | 119.9 | 311.0 |
| 2009-03-08 18:00:00 | GC | Futures | 1339.0 | 1339.7 | 1330.2 | 1333.4 | 696.0 |
| 2009-03-08 19:00:00 | GC | Futures | 1333.1 | 1337.3 | 1331.7 | 1336.8 | 482.0 |
| 2009-03-08 20:00:00 | GC | Futures | 1336.7 | 1341.3 | 1336.6 | 1338.0 | 1471.0 |
| 2009-03-08 21:00:00 | GC | Futures | 1337.8 | 1338.3 | 1335.8 | 1336.3 | 609.0 |
| 2009-03-08 22:00:00 | GC | Futures | 1336.1 | 1336.4 | 1332.3 | 1332.4 | 538.0 |
| 2009-03-08 23:00:00 | GC | Futures | 1332.9 | 1336.4 | 1332.6 | 1336.0 | 623.0 |
| 2009-03-08 18:00:00 | ZN | Futures | 95.003867 | 95.016077 | 94.918399 | 94.930609 | 963.0 |
| 2009-03-08 19:00:00 | ZN | Futures | 94.930609 | 95.028286 | 94.930609 | 95.003867 | 725.0 |
| 2009-03-08 20:00:00 | ZN | Futures | 95.016077 | 95.125964 | 94.991657 | 95.101545 | 1203.0 |
| 2009-03-08 21:00:00 | ZN | Futures | 95.113754 | 95.125964 | 95.028286 | 95.064916 | 1972.0 |
| 2009-03-08 22:00:00 | ZN | Futures | 95.064916 | 95.113754 | 95.052706 | 95.101545 | 767.0 |
| 2009-03-08 23:00:00 | ZN | Futures | 95.089335 | 95.113754 | 95.052706 | 95.113754 | 1212.0 |
> showing 36 of 218 rows — these rows as CSV