PREVIEW / futures_30min / 2010-03-08
file: by_date/futures_30min/2010/2010-03-08.parquet size: 64 KB rows: 2,459
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-03-08 00:00:00 | ES | Futures | 1107.8 | 1107.8 | 1106.34 | 1106.58 | 1999.0 |
| 2010-03-08 00:30:00 | ES | Futures | 1106.83 | 1107.56 | 1106.83 | 1107.31 | 1174.0 |
| 2010-03-08 01:00:00 | ES | Futures | 1107.07 | 1107.8 | 1107.07 | 1107.56 | 1092.0 |
| 2010-03-08 01:30:00 | ES | Futures | 1107.56 | 1108.77 | 1107.56 | 1108.53 | 3147.0 |
| 2010-03-08 02:00:00 | ES | Futures | 1108.53 | 1109.02 | 1108.04 | 1108.77 | 3481.0 |
| 2010-03-08 02:30:00 | ES | Futures | 1108.77 | 1108.77 | 1107.07 | 1107.8 | 4750.0 |
| 2010-03-08 03:00:00 | ES | Futures | 1107.56 | 1107.8 | 1105.61 | 1106.34 | 10708.0 |
| 2010-03-08 03:30:00 | ES | Futures | 1106.1 | 1106.34 | 1105.12 | 1105.61 | 7940.0 |
| 2010-03-08 04:00:00 | ES | Futures | 1105.37 | 1106.83 | 1105.37 | 1106.34 | 6078.0 |
| 2010-03-08 04:30:00 | ES | Futures | 1106.34 | 1107.07 | 1104.88 | 1105.12 | 7694.0 |
| 2010-03-08 05:00:00 | ES | Futures | 1105.12 | 1105.61 | 1104.64 | 1104.88 | 4344.0 |
| 2010-03-08 05:30:00 | ES | Futures | 1104.88 | 1105.61 | 1104.64 | 1104.88 | 5214.0 |
| 2010-03-08 06:00:00 | ES | Futures | 1105.12 | 1105.12 | 1104.39 | 1104.64 | 4559.0 |
| 2010-03-08 06:30:00 | ES | Futures | 1104.88 | 1106.1 | 1104.64 | 1105.85 | 4546.0 |
| 2010-03-08 07:00:00 | ES | Futures | 1105.61 | 1107.56 | 1105.37 | 1107.31 | 7371.0 |
| 2010-03-08 07:30:00 | ES | Futures | 1107.07 | 1108.04 | 1106.58 | 1107.56 | 12038.0 |
| 2010-03-08 08:00:00 | ES | Futures | 1107.56 | 1108.53 | 1106.34 | 1106.58 | 16734.0 |
| 2010-03-08 08:30:00 | ES | Futures | 1106.58 | 1107.31 | 1105.85 | 1106.1 | 13423.0 |
| 2010-03-08 09:00:00 | ES | Futures | 1106.1 | 1107.56 | 1106.1 | 1107.31 | 14826.0 |
| 2010-03-08 09:30:00 | ES | Futures | 1107.07 | 1109.75 | 1106.58 | 1106.83 | 169817.0 |
| 2010-03-08 10:00:00 | ES | Futures | 1106.83 | 1109.26 | 1106.34 | 1108.29 | 91676.0 |
| 2010-03-08 10:30:00 | ES | Futures | 1108.04 | 1108.77 | 1106.34 | 1108.29 | 104125.0 |
| 2010-03-08 11:00:00 | ES | Futures | 1108.29 | 1108.77 | 1105.37 | 1105.85 | 85541.0 |
| 2010-03-08 11:30:00 | ES | Futures | 1106.1 | 1106.83 | 1105.37 | 1105.85 | 56770.0 |
| 2010-03-08 12:00:00 | ES | Futures | 1106.1 | 1107.56 | 1105.61 | 1107.56 | 58217.0 |
| 2010-03-08 12:30:00 | ES | Futures | 1107.56 | 1107.8 | 1105.61 | 1107.8 | 45506.0 |
| 2010-03-08 13:00:00 | ES | Futures | 1107.56 | 1108.77 | 1107.56 | 1108.04 | 42316.0 |
| 2010-03-08 13:30:00 | ES | Futures | 1108.29 | 1109.26 | 1108.04 | 1108.53 | 41547.0 |
| 2010-03-08 14:00:00 | ES | Futures | 1108.77 | 1109.26 | 1107.56 | 1108.29 | 38787.0 |
| 2010-03-08 14:30:00 | ES | Futures | 1108.29 | 1108.77 | 1107.31 | 1107.8 | 35829.0 |
| 2010-03-08 15:00:00 | ES | Futures | 1107.8 | 1108.29 | 1106.83 | 1107.8 | 44262.0 |
| 2010-03-08 15:30:00 | ES | Futures | 1108.04 | 1108.53 | 1106.83 | 1107.07 | 89976.0 |
| 2010-03-08 16:00:00 | ES | Futures | 1107.31 | 1107.56 | 1105.85 | 1106.34 | 75979.0 |
| 2010-03-08 16:30:00 | ES | Futures | 1106.58 | 1106.58 | 1105.85 | 1106.58 | 3669.0 |
| 2010-03-08 17:00:00 | ES | Futures | 1106.34 | 1106.34 | 1105.37 | 1105.61 | 1868.0 |
| 2010-03-08 18:00:00 | ES | Futures | 1105.61 | 1106.1 | 1105.37 | 1105.85 | 1057.0 |
| 2010-03-08 18:30:00 | ES | Futures | 1105.85 | 1105.85 | 1104.88 | 1105.12 | 1444.0 |
| 2010-03-08 19:00:00 | ES | Futures | 1105.12 | 1105.37 | 1104.39 | 1104.88 | 3113.0 |
| 2010-03-08 19:30:00 | ES | Futures | 1104.88 | 1105.37 | 1104.64 | 1104.88 | 1296.0 |
| 2010-03-08 20:00:00 | ES | Futures | 1105.12 | 1105.12 | 1104.64 | 1104.88 | 846.0 |
| 2010-03-08 20:30:00 | ES | Futures | 1105.12 | 1105.61 | 1104.88 | 1105.12 | 1385.0 |
| 2010-03-08 21:00:00 | ES | Futures | 1104.88 | 1105.61 | 1104.88 | 1104.88 | 1292.0 |
| 2010-03-08 21:30:00 | ES | Futures | 1104.88 | 1105.12 | 1103.67 | 1104.39 | 2388.0 |
| 2010-03-08 22:00:00 | ES | Futures | 1104.39 | 1105.12 | 1104.15 | 1105.12 | 1197.0 |
| 2010-03-08 22:30:00 | ES | Futures | 1105.12 | 1105.37 | 1104.15 | 1104.88 | 2357.0 |
| 2010-03-08 23:00:00 | ES | Futures | 1104.88 | 1105.37 | 1104.64 | 1105.12 | 905.0 |
| 2010-03-08 23:30:00 | ES | Futures | 1105.37 | 1105.37 | 1104.39 | 1104.88 | 406.0 |
| 2010-03-08 00:00:00 | NQ | Futures | 2155.64 | 2156.21 | 2154.5 | 2154.79 | 121.0 |
| 2010-03-08 00:30:00 | NQ | Futures | 2155.07 | 2156.21 | 2155.07 | 2155.93 | 56.0 |
| 2010-03-08 01:00:00 | NQ | Futures | 2155.64 | 2156.5 | 2155.64 | 2156.21 | 100.0 |
> showing 50 of 2,459 rows — these rows as CSV