PREVIEW / futures_30min / 2010-04-18
file: by_date/futures_30min/2010/2010-04-18.parquet size: 19 KB rows: 461
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-18 18:00:00 | ES | Futures | 1159.56 | 1160.78 | 1159.31 | 1160.54 | 14423.0 |
| 2010-04-18 18:30:00 | ES | Futures | 1160.78 | 1160.78 | 1159.56 | 1159.8 | 1964.0 |
| 2010-04-18 19:00:00 | ES | Futures | 1159.8 | 1160.05 | 1159.31 | 1159.8 | 2712.0 |
| 2010-04-18 19:30:00 | ES | Futures | 1159.8 | 1160.54 | 1159.56 | 1160.54 | 3866.0 |
| 2010-04-18 20:00:00 | ES | Futures | 1160.54 | 1161.76 | 1160.05 | 1161.76 | 8088.0 |
| 2010-04-18 20:30:00 | ES | Futures | 1161.51 | 1162.49 | 1160.54 | 1160.78 | 2900.0 |
| 2010-04-18 21:00:00 | ES | Futures | 1161.02 | 1161.51 | 1160.05 | 1160.29 | 2745.0 |
| 2010-04-18 21:30:00 | ES | Futures | 1160.29 | 1161.02 | 1159.56 | 1160.29 | 3726.0 |
| 2010-04-18 22:00:00 | ES | Futures | 1160.05 | 1160.54 | 1159.8 | 1160.05 | 1258.0 |
| 2010-04-18 22:30:00 | ES | Futures | 1160.05 | 1160.78 | 1160.05 | 1160.78 | 1363.0 |
| 2010-04-18 23:00:00 | ES | Futures | 1160.54 | 1160.78 | 1159.07 | 1159.07 | 4500.0 |
| 2010-04-18 23:30:00 | ES | Futures | 1159.31 | 1159.31 | 1158.58 | 1158.58 | 2593.0 |
| 2010-04-18 18:00:00 | NQ | Futures | 2296.14 | 2298.14 | 2295.28 | 2298.14 | 1100.0 |
| 2010-04-18 18:30:00 | NQ | Futures | 2298.14 | 2298.14 | 2295.56 | 2296.14 | 64.0 |
| 2010-04-18 19:00:00 | NQ | Futures | 2296.14 | 2296.42 | 2295.28 | 2296.14 | 57.0 |
| 2010-04-18 19:30:00 | NQ | Futures | 2295.85 | 2297.28 | 2295.56 | 2296.42 | 236.0 |
| 2010-04-18 20:00:00 | NQ | Futures | 2296.71 | 2299.0 | 2296.42 | 2298.71 | 404.0 |
| 2010-04-18 20:30:00 | NQ | Futures | 2298.71 | 2300.14 | 2296.99 | 2297.28 | 462.0 |
| 2010-04-18 21:00:00 | NQ | Futures | 2296.99 | 2298.14 | 2296.14 | 2296.99 | 197.0 |
| 2010-04-18 21:30:00 | NQ | Futures | 2296.71 | 2298.43 | 2295.85 | 2296.71 | 364.0 |
| 2010-04-18 22:00:00 | NQ | Futures | 2296.99 | 2297.28 | 2296.14 | 2296.99 | 120.0 |
| 2010-04-18 22:30:00 | NQ | Futures | 2296.71 | 2297.85 | 2296.71 | 2297.57 | 77.0 |
| 2010-04-18 23:00:00 | NQ | Futures | 2297.57 | 2297.57 | 2292.7 | 2294.42 | 1166.0 |
| 2010-04-18 23:30:00 | NQ | Futures | 2294.42 | 2294.42 | 2293.56 | 2293.84 | 365.0 |
| 2010-04-18 18:00:00 | YM | Futures | 10308.4 | 10310.3 | 10270.8 | 10306.6 | 626.0 |
| 2010-04-18 18:30:00 | YM | Futures | 10307.5 | 10308.4 | 10299.0 | 10302.8 | 64.0 |
| 2010-04-18 19:00:00 | YM | Futures | 10301.8 | 10302.8 | 10296.2 | 10299.0 | 122.0 |
| 2010-04-18 19:30:00 | YM | Futures | 10300.9 | 10306.6 | 10300.0 | 10302.8 | 153.0 |
| 2010-04-18 20:00:00 | YM | Futures | 10302.8 | 10316.9 | 10301.8 | 10310.3 | 625.0 |
| 2010-04-18 20:30:00 | YM | Futures | 10311.3 | 10317.8 | 10303.7 | 10305.6 | 244.0 |
| 2010-04-18 21:00:00 | YM | Futures | 10305.6 | 10309.4 | 10300.0 | 10301.8 | 214.0 |
| 2010-04-18 21:30:00 | YM | Futures | 10301.8 | 10305.6 | 10297.1 | 10299.0 | 456.0 |
| 2010-04-18 22:00:00 | YM | Futures | 10299.0 | 10302.8 | 10297.1 | 10300.9 | 203.0 |
| 2010-04-18 22:30:00 | YM | Futures | 10300.9 | 10304.7 | 10300.0 | 10302.8 | 115.0 |
| 2010-04-18 23:00:00 | YM | Futures | 10302.8 | 10303.7 | 10286.8 | 10289.6 | 792.0 |
| 2010-04-18 23:30:00 | YM | Futures | 10289.6 | 10289.6 | 10283.0 | 10287.7 | 392.0 |
| 2010-04-18 18:00:00 | CL | Futures | 176.67 | 176.67 | 175.75 | 175.89 | 876.0 |
| 2010-04-18 18:30:00 | CL | Futures | 175.89 | 175.91 | 175.22 | 175.43 | 1133.0 |
| 2010-04-18 19:00:00 | CL | Futures | 175.43 | 175.81 | 175.43 | 175.68 | 312.0 |
| 2010-04-18 19:30:00 | CL | Futures | 175.68 | 175.89 | 175.54 | 175.62 | 896.0 |
| 2010-04-18 20:00:00 | CL | Futures | 175.62 | 175.77 | 175.43 | 175.7 | 577.0 |
| 2010-04-18 20:30:00 | CL | Futures | 175.7 | 175.72 | 175.43 | 175.43 | 527.0 |
| 2010-04-18 21:00:00 | CL | Futures | 175.41 | 175.45 | 174.72 | 174.76 | 1358.0 |
| 2010-04-18 21:30:00 | CL | Futures | 174.78 | 174.82 | 174.36 | 174.76 | 1563.0 |
| 2010-04-18 22:00:00 | CL | Futures | 174.74 | 174.87 | 174.24 | 174.34 | 819.0 |
| 2010-04-18 22:30:00 | CL | Futures | 174.32 | 174.49 | 174.28 | 174.43 | 284.0 |
| 2010-04-18 23:00:00 | CL | Futures | 174.41 | 174.68 | 174.32 | 174.57 | 522.0 |
| 2010-04-18 23:30:00 | CL | Futures | 174.57 | 175.08 | 174.55 | 174.85 | 1042.0 |
| 2010-04-18 18:00:00 | GC | Futures | 1598.7 | 1598.7 | 1594.8 | 1597.8 | 955.0 |
| 2010-04-18 18:30:00 | GC | Futures | 1597.7 | 1597.7 | 1595.5 | 1595.7 | 451.0 |
> showing 50 of 461 rows — these rows as CSV