PREVIEW / futures_30min / 2010-11-21
file: by_date/futures_30min/2010/2010-11-21.parquet size: 19 KB rows: 472
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-11-21 18:00:00 | ES | Futures | 1185.81 | 1187.54 | 1184.58 | 1187.04 | 19791.0 |
| 2010-11-21 18:30:00 | ES | Futures | 1187.04 | 1187.78 | 1186.8 | 1187.29 | 5632.0 |
| 2010-11-21 19:00:00 | ES | Futures | 1187.54 | 1187.78 | 1186.8 | 1187.54 | 3727.0 |
| 2010-11-21 19:30:00 | ES | Futures | 1187.78 | 1188.03 | 1187.04 | 1187.78 | 5689.0 |
| 2010-11-21 20:00:00 | ES | Futures | 1188.03 | 1189.01 | 1187.29 | 1188.77 | 7412.0 |
| 2010-11-21 20:30:00 | ES | Futures | 1188.77 | 1188.77 | 1187.54 | 1187.78 | 4318.0 |
| 2010-11-21 21:00:00 | ES | Futures | 1188.03 | 1188.77 | 1187.78 | 1188.77 | 1590.0 |
| 2010-11-21 21:30:00 | ES | Futures | 1188.77 | 1188.77 | 1187.29 | 1188.52 | 6801.0 |
| 2010-11-21 22:00:00 | ES | Futures | 1188.52 | 1188.77 | 1187.29 | 1187.78 | 5519.0 |
| 2010-11-21 22:30:00 | ES | Futures | 1187.78 | 1188.27 | 1187.29 | 1188.03 | 2542.0 |
| 2010-11-21 23:00:00 | ES | Futures | 1187.78 | 1188.03 | 1187.29 | 1187.78 | 970.0 |
| 2010-11-21 23:30:00 | ES | Futures | 1187.78 | 1187.78 | 1187.04 | 1187.54 | 1184.0 |
| 2010-11-21 18:00:00 | NQ | Futures | 2454.74 | 2461.91 | 2454.16 | 2461.05 | 394.0 |
| 2010-11-21 18:30:00 | NQ | Futures | 2460.76 | 2463.34 | 2460.48 | 2462.77 | 163.0 |
| 2010-11-21 19:00:00 | NQ | Futures | 2461.91 | 2463.06 | 2460.76 | 2462.48 | 155.0 |
| 2010-11-21 19:30:00 | NQ | Futures | 2462.77 | 2463.06 | 2461.34 | 2462.77 | 201.0 |
| 2010-11-21 20:00:00 | NQ | Futures | 2462.48 | 2465.93 | 2461.62 | 2464.49 | 402.0 |
| 2010-11-21 20:30:00 | NQ | Futures | 2464.78 | 2465.07 | 2462.77 | 2462.77 | 110.0 |
| 2010-11-21 21:00:00 | NQ | Futures | 2463.06 | 2465.07 | 2463.06 | 2464.78 | 131.0 |
| 2010-11-21 21:30:00 | NQ | Futures | 2464.78 | 2465.35 | 2462.48 | 2463.92 | 303.0 |
| 2010-11-21 22:00:00 | NQ | Futures | 2463.63 | 2463.92 | 2461.62 | 2462.2 | 213.0 |
| 2010-11-21 22:30:00 | NQ | Futures | 2462.48 | 2463.92 | 2461.62 | 2463.06 | 77.0 |
| 2010-11-21 23:00:00 | NQ | Futures | 2462.77 | 2463.63 | 2462.2 | 2462.48 | 30.0 |
| 2010-11-21 23:30:00 | NQ | Futures | 2462.2 | 2463.06 | 2461.91 | 2462.48 | 18.0 |
| 2010-11-21 18:00:00 | YM | Futures | 10696.3 | 10706.8 | 10676.3 | 10699.2 | 467.0 |
| 2010-11-21 18:30:00 | YM | Futures | 10699.2 | 10704.9 | 10696.3 | 10696.3 | 219.0 |
| 2010-11-21 19:00:00 | YM | Futures | 10697.3 | 10702.1 | 10695.4 | 10700.2 | 128.0 |
| 2010-11-21 19:30:00 | YM | Futures | 10702.1 | 10703.0 | 10696.3 | 10701.1 | 154.0 |
| 2010-11-21 20:00:00 | YM | Futures | 10700.2 | 10710.6 | 10697.3 | 10705.9 | 241.0 |
| 2010-11-21 20:30:00 | YM | Futures | 10707.8 | 10707.8 | 10701.1 | 10704.0 | 118.0 |
| 2010-11-21 21:00:00 | YM | Futures | 10703.0 | 10707.8 | 10703.0 | 10705.9 | 103.0 |
| 2010-11-21 21:30:00 | YM | Futures | 10706.8 | 10708.7 | 10696.3 | 10704.9 | 290.0 |
| 2010-11-21 22:00:00 | YM | Futures | 10704.9 | 10705.9 | 10696.3 | 10700.2 | 273.0 |
| 2010-11-21 22:30:00 | YM | Futures | 10701.1 | 10703.0 | 10697.3 | 10700.2 | 128.0 |
| 2010-11-21 23:00:00 | YM | Futures | 10700.2 | 10701.1 | 10696.3 | 10696.3 | 55.0 |
| 2010-11-21 23:30:00 | YM | Futures | 10696.3 | 10697.3 | 10692.5 | 10693.5 | 37.0 |
| 2010-11-21 18:00:00 | CL | Futures | 153.31 | 153.57 | 153.09 | 153.5 | 1912.0 |
| 2010-11-21 18:30:00 | CL | Futures | 153.5 | 153.7 | 153.5 | 153.7 | 805.0 |
| 2010-11-21 19:00:00 | CL | Futures | 153.68 | 153.78 | 153.5 | 153.59 | 791.0 |
| 2010-11-21 19:30:00 | CL | Futures | 153.57 | 153.76 | 153.52 | 153.76 | 333.0 |
| 2010-11-21 20:00:00 | CL | Futures | 153.76 | 153.96 | 153.68 | 153.89 | 780.0 |
| 2010-11-21 20:30:00 | CL | Futures | 153.89 | 154.0 | 153.83 | 153.94 | 619.0 |
| 2010-11-21 21:00:00 | CL | Futures | 153.96 | 154.0 | 153.85 | 153.94 | 354.0 |
| 2010-11-21 21:30:00 | CL | Futures | 153.94 | 154.02 | 153.89 | 153.98 | 439.0 |
| 2010-11-21 22:00:00 | CL | Futures | 153.98 | 154.09 | 153.87 | 154.08 | 526.0 |
| 2010-11-21 22:30:00 | CL | Futures | 154.08 | 154.19 | 154.06 | 154.13 | 350.0 |
| 2010-11-21 23:00:00 | CL | Futures | 154.15 | 154.15 | 153.76 | 153.93 | 342.0 |
| 2010-11-21 23:30:00 | CL | Futures | 153.93 | 154.17 | 153.91 | 154.15 | 499.0 |
| 2010-11-21 18:00:00 | GC | Futures | 1898.5 | 1902.1 | 1898.5 | 1900.7 | 1504.0 |
| 2010-11-21 18:30:00 | GC | Futures | 1900.9 | 1901.6 | 1900.0 | 1901.0 | 540.0 |
> showing 50 of 472 rows — these rows as CSV