PREVIEW / futures_30min / 2010-07-19
file: by_date/futures_30min/2010/2010-07-19.parquet size: 69 KB rows: 2,454
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-07-19 00:00:00 | ES | Futures | 1044.58 | 1045.07 | 1044.34 | 1044.34 | 394.0 |
| 2010-07-19 00:30:00 | ES | Futures | 1044.34 | 1045.32 | 1044.34 | 1044.83 | 730.0 |
| 2010-07-19 01:00:00 | ES | Futures | 1044.83 | 1046.3 | 1044.58 | 1046.3 | 1571.0 |
| 2010-07-19 01:30:00 | ES | Futures | 1046.05 | 1046.3 | 1045.07 | 1046.05 | 2931.0 |
| 2010-07-19 02:00:00 | ES | Futures | 1045.81 | 1046.79 | 1044.09 | 1044.34 | 7753.0 |
| 2010-07-19 02:30:00 | ES | Futures | 1044.58 | 1045.81 | 1043.35 | 1043.6 | 5206.0 |
| 2010-07-19 03:00:00 | ES | Futures | 1043.6 | 1045.32 | 1042.62 | 1044.09 | 21659.0 |
| 2010-07-19 03:30:00 | ES | Futures | 1043.84 | 1045.81 | 1042.86 | 1045.07 | 16578.0 |
| 2010-07-19 04:00:00 | ES | Futures | 1045.07 | 1047.77 | 1044.09 | 1047.03 | 16214.0 |
| 2010-07-19 04:30:00 | ES | Futures | 1047.03 | 1048.26 | 1046.79 | 1048.02 | 10860.0 |
| 2010-07-19 05:00:00 | ES | Futures | 1048.02 | 1049.24 | 1047.53 | 1047.77 | 13014.0 |
| 2010-07-19 05:30:00 | ES | Futures | 1047.77 | 1048.02 | 1046.05 | 1047.28 | 7854.0 |
| 2010-07-19 06:00:00 | ES | Futures | 1047.28 | 1049.24 | 1047.28 | 1049.0 | 9220.0 |
| 2010-07-19 06:30:00 | ES | Futures | 1049.0 | 1049.49 | 1048.51 | 1048.51 | 9469.0 |
| 2010-07-19 07:00:00 | ES | Futures | 1048.75 | 1049.24 | 1047.53 | 1047.53 | 9289.0 |
| 2010-07-19 07:30:00 | ES | Futures | 1047.77 | 1048.02 | 1046.54 | 1047.28 | 10684.0 |
| 2010-07-19 08:00:00 | ES | Futures | 1047.03 | 1047.77 | 1045.32 | 1047.53 | 20554.0 |
| 2010-07-19 08:30:00 | ES | Futures | 1047.53 | 1047.53 | 1046.05 | 1046.3 | 16616.0 |
| 2010-07-19 09:00:00 | ES | Futures | 1046.3 | 1046.79 | 1045.56 | 1045.56 | 22871.0 |
| 2010-07-19 09:30:00 | ES | Futures | 1045.56 | 1049.49 | 1045.07 | 1047.28 | 185645.0 |
| 2010-07-19 10:00:00 | ES | Futures | 1047.03 | 1047.77 | 1039.43 | 1039.43 | 204585.0 |
| 2010-07-19 10:30:00 | ES | Futures | 1039.43 | 1041.88 | 1037.46 | 1039.92 | 169771.0 |
| 2010-07-19 11:00:00 | ES | Futures | 1040.16 | 1044.09 | 1039.18 | 1042.86 | 106537.0 |
| 2010-07-19 11:30:00 | ES | Futures | 1042.86 | 1043.84 | 1040.65 | 1043.6 | 65617.0 |
| 2010-07-19 12:00:00 | ES | Futures | 1043.6 | 1044.58 | 1040.65 | 1044.34 | 72734.0 |
| 2010-07-19 12:30:00 | ES | Futures | 1044.34 | 1047.03 | 1042.86 | 1044.83 | 72685.0 |
| 2010-07-19 13:00:00 | ES | Futures | 1045.07 | 1045.32 | 1042.13 | 1042.86 | 41528.0 |
| 2010-07-19 13:30:00 | ES | Futures | 1042.86 | 1044.09 | 1041.39 | 1042.13 | 56180.0 |
| 2010-07-19 14:00:00 | ES | Futures | 1041.88 | 1046.05 | 1041.88 | 1045.07 | 63627.0 |
| 2010-07-19 14:30:00 | ES | Futures | 1045.32 | 1049.73 | 1044.58 | 1047.77 | 93790.0 |
| 2010-07-19 15:00:00 | ES | Futures | 1047.77 | 1051.21 | 1046.05 | 1046.54 | 123227.0 |
| 2010-07-19 15:30:00 | ES | Futures | 1046.54 | 1048.75 | 1044.83 | 1048.51 | 145817.0 |
| 2010-07-19 16:00:00 | ES | Futures | 1048.26 | 1048.75 | 1042.62 | 1044.58 | 94294.0 |
| 2010-07-19 16:30:00 | ES | Futures | 1043.6 | 1043.84 | 1040.16 | 1040.41 | 12774.0 |
| 2010-07-19 17:00:00 | ES | Futures | 1040.41 | 1040.9 | 1040.16 | 1040.16 | 3246.0 |
| 2010-07-19 18:00:00 | ES | Futures | 1039.67 | 1039.67 | 1038.94 | 1039.18 | 3971.0 |
| 2010-07-19 18:30:00 | ES | Futures | 1039.18 | 1040.16 | 1038.94 | 1039.43 | 1957.0 |
| 2010-07-19 19:00:00 | ES | Futures | 1039.43 | 1040.65 | 1038.94 | 1040.41 | 1845.0 |
| 2010-07-19 19:30:00 | ES | Futures | 1040.41 | 1041.88 | 1039.67 | 1041.39 | 2840.0 |
| 2010-07-19 20:00:00 | ES | Futures | 1041.64 | 1042.62 | 1040.9 | 1042.37 | 4922.0 |
| 2010-07-19 20:30:00 | ES | Futures | 1042.37 | 1044.09 | 1042.37 | 1042.86 | 5111.0 |
| 2010-07-19 21:00:00 | ES | Futures | 1042.62 | 1044.09 | 1042.37 | 1042.62 | 3700.0 |
| 2010-07-19 21:30:00 | ES | Futures | 1042.62 | 1043.6 | 1042.13 | 1042.62 | 2724.0 |
| 2010-07-19 22:00:00 | ES | Futures | 1042.37 | 1044.83 | 1042.13 | 1044.34 | 3954.0 |
| 2010-07-19 22:30:00 | ES | Futures | 1044.34 | 1046.3 | 1044.34 | 1044.58 | 5833.0 |
| 2010-07-19 23:00:00 | ES | Futures | 1044.83 | 1045.56 | 1043.84 | 1045.32 | 1812.0 |
| 2010-07-19 23:30:00 | ES | Futures | 1045.32 | 1046.79 | 1045.32 | 1046.05 | 4740.0 |
| 2010-07-19 00:00:00 | NQ | Futures | 2067.86 | 2068.43 | 2067.57 | 2067.57 | 22.0 |
| 2010-07-19 00:30:00 | NQ | Futures | 2068.15 | 2068.43 | 2067.86 | 2068.43 | 30.0 |
| 2010-07-19 01:00:00 | NQ | Futures | 2068.72 | 2071.59 | 2068.43 | 2071.3 | 70.0 |
> showing 50 of 2,454 rows — these rows as CSV