PREVIEW / futures_30min / 2010-08-15
file: by_date/futures_30min/2010/2010-08-15.parquet size: 18 KB rows: 418
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-08-15 18:00:00 | ES | Futures | 1057.59 | 1057.59 | 1055.87 | 1056.85 | 2253.0 |
| 2010-08-15 18:30:00 | ES | Futures | 1056.85 | 1057.34 | 1056.85 | 1057.34 | 430.0 |
| 2010-08-15 19:00:00 | ES | Futures | 1057.34 | 1057.59 | 1057.09 | 1057.09 | 410.0 |
| 2010-08-15 19:30:00 | ES | Futures | 1057.09 | 1057.34 | 1053.66 | 1054.64 | 4524.0 |
| 2010-08-15 20:00:00 | ES | Futures | 1054.64 | 1054.89 | 1051.45 | 1052.19 | 8800.0 |
| 2010-08-15 20:30:00 | ES | Futures | 1051.94 | 1051.94 | 1050.22 | 1050.96 | 9075.0 |
| 2010-08-15 21:00:00 | ES | Futures | 1050.96 | 1051.45 | 1048.75 | 1049.24 | 7729.0 |
| 2010-08-15 21:30:00 | ES | Futures | 1049.49 | 1053.66 | 1049.49 | 1053.17 | 6343.0 |
| 2010-08-15 22:00:00 | ES | Futures | 1053.41 | 1054.64 | 1052.43 | 1053.17 | 4125.0 |
| 2010-08-15 22:30:00 | ES | Futures | 1053.17 | 1054.64 | 1052.68 | 1054.15 | 3556.0 |
| 2010-08-15 23:00:00 | ES | Futures | 1054.15 | 1054.64 | 1053.41 | 1054.15 | 1806.0 |
| 2010-08-15 23:30:00 | ES | Futures | 1054.15 | 1054.4 | 1051.94 | 1052.19 | 2743.0 |
| 2010-08-15 18:00:00 | NQ | Futures | 2083.62 | 2085.05 | 2081.33 | 2082.48 | 168.0 |
| 2010-08-15 18:30:00 | NQ | Futures | 2082.76 | 2083.91 | 2082.76 | 2083.34 | 73.0 |
| 2010-08-15 19:00:00 | NQ | Futures | 2083.62 | 2084.48 | 2083.05 | 2083.05 | 66.0 |
| 2010-08-15 19:30:00 | NQ | Futures | 2083.34 | 2083.34 | 2078.75 | 2080.18 | 1033.0 |
| 2010-08-15 20:00:00 | NQ | Futures | 2079.9 | 2080.18 | 2072.73 | 2075.02 | 675.0 |
| 2010-08-15 20:30:00 | NQ | Futures | 2074.74 | 2074.74 | 2071.01 | 2072.45 | 367.0 |
| 2010-08-15 21:00:00 | NQ | Futures | 2072.45 | 2073.59 | 2069.01 | 2070.15 | 483.0 |
| 2010-08-15 21:30:00 | NQ | Futures | 2070.44 | 2077.6 | 2070.44 | 2076.74 | 452.0 |
| 2010-08-15 22:00:00 | NQ | Futures | 2077.03 | 2079.61 | 2075.02 | 2076.74 | 327.0 |
| 2010-08-15 22:30:00 | NQ | Futures | 2076.74 | 2079.32 | 2076.17 | 2079.04 | 263.0 |
| 2010-08-15 23:00:00 | NQ | Futures | 2078.75 | 2079.9 | 2077.89 | 2079.32 | 164.0 |
| 2010-08-15 23:30:00 | NQ | Futures | 2079.04 | 2079.04 | 2075.31 | 2075.88 | 222.0 |
| 2010-08-15 18:00:00 | YM | Futures | 9723.5 | 9730.2 | 9716.0 | 9723.5 | 148.0 |
| 2010-08-15 18:30:00 | YM | Futures | 9724.5 | 9729.2 | 9724.5 | 9725.4 | 120.0 |
| 2010-08-15 19:00:00 | YM | Futures | 9726.4 | 9731.1 | 9726.4 | 9728.3 | 54.0 |
| 2010-08-15 19:30:00 | YM | Futures | 9728.3 | 9730.2 | 9698.9 | 9708.4 | 268.0 |
| 2010-08-15 20:00:00 | YM | Futures | 9708.4 | 9708.4 | 9680.0 | 9686.6 | 412.0 |
| 2010-08-15 20:30:00 | YM | Futures | 9683.8 | 9683.8 | 9672.4 | 9676.2 | 308.0 |
| 2010-08-15 21:00:00 | YM | Futures | 9680.0 | 9680.9 | 9661.1 | 9664.9 | 305.0 |
| 2010-08-15 21:30:00 | YM | Futures | 9667.7 | 9698.9 | 9666.7 | 9696.1 | 368.0 |
| 2010-08-15 22:00:00 | YM | Futures | 9697.0 | 9706.5 | 9692.3 | 9696.1 | 272.0 |
| 2010-08-15 22:30:00 | YM | Futures | 9696.1 | 9708.4 | 9694.2 | 9704.6 | 299.0 |
| 2010-08-15 23:00:00 | YM | Futures | 9704.6 | 9705.6 | 9698.9 | 9704.6 | 160.0 |
| 2010-08-15 23:30:00 | YM | Futures | 9703.7 | 9704.6 | 9687.6 | 9688.5 | 171.0 |
| 2010-08-15 18:00:00 | CL | Futures | 145.04 | 145.57 | 145.04 | 145.27 | 285.0 |
| 2010-08-15 18:30:00 | CL | Futures | 145.4 | 145.52 | 145.38 | 145.52 | 7.0 |
| 2010-08-15 19:00:00 | CL | Futures | 145.52 | 145.52 | 145.33 | 145.36 | 18.0 |
| 2010-08-15 19:30:00 | CL | Futures | 145.4 | 145.4 | 144.89 | 144.92 | 126.0 |
| 2010-08-15 20:00:00 | CL | Futures | 144.92 | 144.92 | 144.56 | 144.66 | 183.0 |
| 2010-08-15 20:30:00 | CL | Futures | 144.58 | 144.66 | 144.43 | 144.56 | 99.0 |
| 2010-08-15 21:00:00 | CL | Futures | 144.62 | 144.79 | 144.43 | 144.43 | 92.0 |
| 2010-08-15 21:30:00 | CL | Futures | 144.5 | 144.73 | 144.48 | 144.66 | 83.0 |
| 2010-08-15 22:00:00 | CL | Futures | 144.68 | 144.98 | 144.62 | 144.9 | 243.0 |
| 2010-08-15 22:30:00 | CL | Futures | 144.92 | 145.27 | 144.92 | 145.25 | 220.0 |
| 2010-08-15 23:00:00 | CL | Futures | 145.27 | 145.42 | 145.19 | 145.4 | 167.0 |
| 2010-08-15 23:30:00 | CL | Futures | 145.4 | 145.42 | 145.19 | 145.19 | 104.0 |
| 2010-08-15 18:00:00 | GC | Futures | 1701.9 | 1702.5 | 1701.5 | 1701.9 | 345.0 |
| 2010-08-15 18:30:00 | GC | Futures | 1702.1 | 1702.5 | 1701.8 | 1702.3 | 35.0 |
> showing 50 of 418 rows — these rows as CSV