PREVIEW / futures_30min / 2010-02-28
file: by_date/futures_30min/2010/2010-02-28.parquet size: 17 KB rows: 424
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-02-28 18:00:00 | ES | Futures | 1075.69 | 1080.31 | 1075.69 | 1078.85 | 11661.0 |
| 2010-02-28 18:30:00 | ES | Futures | 1078.85 | 1079.1 | 1078.61 | 1079.1 | 1834.0 |
| 2010-02-28 19:00:00 | ES | Futures | 1078.85 | 1079.34 | 1078.37 | 1079.34 | 1293.0 |
| 2010-02-28 19:30:00 | ES | Futures | 1079.34 | 1079.58 | 1078.12 | 1078.37 | 3575.0 |
| 2010-02-28 20:00:00 | ES | Futures | 1078.37 | 1078.37 | 1075.69 | 1075.93 | 9201.0 |
| 2010-02-28 20:30:00 | ES | Futures | 1075.93 | 1077.15 | 1075.45 | 1076.66 | 3829.0 |
| 2010-02-28 21:00:00 | ES | Futures | 1076.66 | 1077.64 | 1075.93 | 1075.93 | 3043.0 |
| 2010-02-28 21:30:00 | ES | Futures | 1075.93 | 1076.91 | 1075.93 | 1076.91 | 1856.0 |
| 2010-02-28 22:00:00 | ES | Futures | 1076.66 | 1077.64 | 1076.66 | 1077.39 | 1118.0 |
| 2010-02-28 22:30:00 | ES | Futures | 1077.39 | 1078.37 | 1077.39 | 1077.88 | 2115.0 |
| 2010-02-28 23:00:00 | ES | Futures | 1077.88 | 1078.61 | 1077.64 | 1078.37 | 1445.0 |
| 2010-02-28 23:30:00 | ES | Futures | 1078.12 | 1078.61 | 1078.12 | 1078.37 | 432.0 |
| 2010-02-28 18:00:00 | NQ | Futures | 2080.81 | 2090.52 | 2080.81 | 2088.81 | 900.0 |
| 2010-02-28 18:30:00 | NQ | Futures | 2088.81 | 2089.09 | 2087.38 | 2088.81 | 304.0 |
| 2010-02-28 19:00:00 | NQ | Futures | 2088.81 | 2089.38 | 2087.95 | 2089.38 | 136.0 |
| 2010-02-28 19:30:00 | NQ | Futures | 2089.66 | 2089.95 | 2087.38 | 2087.66 | 227.0 |
| 2010-02-28 20:00:00 | NQ | Futures | 2087.38 | 2087.38 | 2084.52 | 2085.66 | 1033.0 |
| 2010-02-28 20:30:00 | NQ | Futures | 2085.38 | 2086.81 | 2084.52 | 2086.52 | 533.0 |
| 2010-02-28 21:00:00 | NQ | Futures | 2086.52 | 2087.38 | 2085.09 | 2085.09 | 287.0 |
| 2010-02-28 21:30:00 | NQ | Futures | 2084.81 | 2086.81 | 2084.81 | 2086.81 | 102.0 |
| 2010-02-28 22:00:00 | NQ | Futures | 2087.09 | 2087.95 | 2086.81 | 2087.09 | 171.0 |
| 2010-02-28 22:30:00 | NQ | Futures | 2087.09 | 2088.52 | 2087.09 | 2088.23 | 106.0 |
| 2010-02-28 23:00:00 | NQ | Futures | 2088.52 | 2089.09 | 2087.66 | 2088.52 | 82.0 |
| 2010-02-28 23:30:00 | NQ | Futures | 2088.23 | 2088.81 | 2088.23 | 2088.81 | 50.0 |
| 2010-02-28 18:00:00 | YM | Futures | 9661.3 | 9701.6 | 9661.3 | 9695.0 | 586.0 |
| 2010-02-28 18:30:00 | YM | Futures | 9693.1 | 9694.1 | 9688.5 | 9688.5 | 73.0 |
| 2010-02-28 19:00:00 | YM | Futures | 9692.2 | 9695.0 | 9687.5 | 9695.0 | 129.0 |
| 2010-02-28 19:30:00 | YM | Futures | 9695.0 | 9698.8 | 9689.4 | 9690.3 | 242.0 |
| 2010-02-28 20:00:00 | YM | Futures | 9691.3 | 9691.3 | 9669.7 | 9671.6 | 416.0 |
| 2010-02-28 20:30:00 | YM | Futures | 9670.7 | 9680.0 | 9665.1 | 9678.2 | 250.0 |
| 2010-02-28 21:00:00 | YM | Futures | 9679.1 | 9682.8 | 9673.5 | 9673.5 | 211.0 |
| 2010-02-28 21:30:00 | YM | Futures | 9672.5 | 9682.8 | 9671.6 | 9681.0 | 101.0 |
| 2010-02-28 22:00:00 | YM | Futures | 9681.0 | 9686.6 | 9681.0 | 9684.7 | 96.0 |
| 2010-02-28 22:30:00 | YM | Futures | 9683.8 | 9692.2 | 9683.8 | 9690.3 | 107.0 |
| 2010-02-28 23:00:00 | YM | Futures | 9689.4 | 9693.1 | 9686.6 | 9692.2 | 71.0 |
| 2010-02-28 23:30:00 | YM | Futures | 9692.2 | 9694.1 | 9689.4 | 9692.2 | 31.0 |
| 2010-02-28 18:00:00 | CL | Futures | 169.88 | 170.56 | 169.5 | 170.42 | 1271.0 |
| 2010-02-28 18:30:00 | CL | Futures | 170.44 | 170.69 | 170.44 | 170.69 | 694.0 |
| 2010-02-28 19:00:00 | CL | Futures | 170.67 | 171.44 | 170.52 | 171.37 | 1728.0 |
| 2010-02-28 19:30:00 | CL | Futures | 171.33 | 171.52 | 170.95 | 171.05 | 1031.0 |
| 2010-02-28 20:00:00 | CL | Futures | 171.05 | 171.22 | 170.59 | 170.65 | 1573.0 |
| 2010-02-28 20:30:00 | CL | Futures | 170.65 | 171.01 | 170.42 | 170.46 | 637.0 |
| 2010-02-28 21:00:00 | CL | Futures | 170.48 | 170.71 | 170.33 | 170.42 | 488.0 |
| 2010-02-28 21:30:00 | CL | Futures | 170.39 | 170.61 | 170.39 | 170.59 | 189.0 |
| 2010-02-28 22:00:00 | CL | Futures | 170.59 | 170.61 | 170.44 | 170.54 | 117.0 |
| 2010-02-28 22:30:00 | CL | Futures | 170.54 | 170.63 | 170.37 | 170.54 | 214.0 |
| 2010-02-28 23:00:00 | CL | Futures | 170.52 | 170.69 | 170.35 | 170.67 | 294.0 |
| 2010-02-28 23:30:00 | CL | Futures | 170.67 | 170.71 | 170.61 | 170.67 | 81.0 |
| 2010-02-28 18:00:00 | GC | Futures | 1575.4 | 1577.8 | 1573.7 | 1575.0 | 2119.0 |
| 2010-02-28 18:30:00 | GC | Futures | 1575.0 | 1575.4 | 1572.2 | 1573.8 | 688.0 |
> showing 50 of 424 rows — these rows as CSV