PREVIEW / futures_1hour / 2009-03-22
file: by_date/futures_1hour/2009/2009-03-22.parquet size: 13 KB rows: 230
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-22 18:00:00 | ES | Futures | 734.96 | 738.31 | 733.76 | 738.07 | 10602.0 |
| 2009-03-22 19:00:00 | ES | Futures | 737.83 | 738.31 | 736.39 | 737.11 | 4177.0 |
| 2009-03-22 20:00:00 | ES | Futures | 736.87 | 741.91 | 735.44 | 741.19 | 13229.0 |
| 2009-03-22 21:00:00 | ES | Futures | 741.43 | 741.91 | 740.71 | 741.67 | 6371.0 |
| 2009-03-22 22:00:00 | ES | Futures | 741.67 | 743.58 | 740.95 | 742.63 | 5142.0 |
| 2009-03-22 23:00:00 | ES | Futures | 742.63 | 747.18 | 742.63 | 744.78 | 6996.0 |
| 2009-03-22 18:00:00 | NQ | Futures | 1348.53 | 1358.76 | 1348.53 | 1358.76 | 918.0 |
| 2009-03-22 19:00:00 | NQ | Futures | 1358.19 | 1359.33 | 1355.06 | 1357.62 | 274.0 |
| 2009-03-22 20:00:00 | NQ | Futures | 1357.05 | 1365.01 | 1354.78 | 1364.16 | 619.0 |
| 2009-03-22 21:00:00 | NQ | Futures | 1363.3 | 1365.01 | 1362.73 | 1365.01 | 224.0 |
| 2009-03-22 22:00:00 | NQ | Futures | 1365.01 | 1368.13 | 1363.3 | 1367.0 | 148.0 |
| 2009-03-22 23:00:00 | NQ | Futures | 1366.71 | 1374.1 | 1366.71 | 1370.12 | 323.0 |
| 2009-03-22 18:00:00 | YM | Futures | 6642.2 | 6681.7 | 6639.4 | 6678.0 | 411.0 |
| 2009-03-22 19:00:00 | YM | Futures | 6675.2 | 6679.8 | 6662.4 | 6669.7 | 207.0 |
| 2009-03-22 20:00:00 | YM | Futures | 6668.8 | 6708.3 | 6657.8 | 6703.7 | 540.0 |
| 2009-03-22 21:00:00 | YM | Futures | 6703.7 | 6708.3 | 6698.2 | 6702.8 | 330.0 |
| 2009-03-22 22:00:00 | YM | Futures | 6706.5 | 6722.1 | 6700.1 | 6716.6 | 235.0 |
| 2009-03-22 23:00:00 | YM | Futures | 6714.8 | 6751.5 | 6714.8 | 6735.9 | 447.0 |
| 2009-03-22 18:00:00 | CL | Futures | 132.99 | 134.96 | 132.84 | 134.83 | 720.0 |
| 2009-03-22 19:00:00 | CL | Futures | 134.88 | 134.88 | 134.27 | 134.3 | 167.0 |
| 2009-03-22 20:00:00 | CL | Futures | 134.37 | 134.37 | 133.94 | 134.22 | 328.0 |
| 2009-03-22 21:00:00 | CL | Futures | 134.22 | 134.22 | 133.81 | 133.84 | 244.0 |
| 2009-03-22 22:00:00 | CL | Futures | 133.81 | 134.04 | 133.58 | 133.96 | 229.0 |
| 2009-03-22 23:00:00 | CL | Futures | 133.94 | 134.3 | 133.71 | 134.22 | 274.0 |
| 2009-03-22 18:00:00 | GC | Futures | 1352.2 | 1362.2 | 1352.2 | 1359.2 | 1211.0 |
| 2009-03-22 19:00:00 | GC | Futures | 1359.2 | 1360.0 | 1355.1 | 1355.2 | 464.0 |
| 2009-03-22 20:00:00 | GC | Futures | 1355.2 | 1357.9 | 1352.9 | 1353.3 | 933.0 |
| 2009-03-22 21:00:00 | GC | Futures | 1353.2 | 1354.2 | 1350.6 | 1352.1 | 1423.0 |
| 2009-03-22 22:00:00 | GC | Futures | 1351.9 | 1354.8 | 1351.2 | 1354.1 | 539.0 |
| 2009-03-22 23:00:00 | GC | Futures | 1354.1 | 1354.2 | 1350.9 | 1352.6 | 580.0 |
| 2009-03-22 18:00:00 | ZN | Futures | 97.287085 | 97.335924 | 97.226037 | 97.262666 | 710.0 |
| 2009-03-22 19:00:00 | ZN | Futures | 97.250456 | 97.311505 | 97.238247 | 97.287085 | 816.0 |
| 2009-03-22 20:00:00 | ZN | Futures | 97.287085 | 97.335924 | 97.262666 | 97.274876 | 1131.0 |
| 2009-03-22 21:00:00 | ZN | Futures | 97.274876 | 97.335924 | 97.274876 | 97.299295 | 947.0 |
| 2009-03-22 22:00:00 | ZN | Futures | 97.299295 | 97.299295 | 97.213827 | 97.238247 | 734.0 |
| 2009-03-22 23:00:00 | ZN | Futures | 97.238247 | 97.250456 | 96.981842 | 97.116149 | 5552.0 |
> showing 36 of 230 rows — these rows as CSV