PREVIEW / futures_30min / 2010-04-20
file: by_date/futures_30min/2010/2010-04-20.parquet size: 68 KB rows: 2,525
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-04-20 00:00:00 | ES | Futures | 1169.34 | 1170.07 | 1169.09 | 1169.34 | 2047.0 |
| 2010-04-20 00:30:00 | ES | Futures | 1169.58 | 1170.31 | 1169.34 | 1169.58 | 983.0 |
| 2010-04-20 01:00:00 | ES | Futures | 1169.58 | 1169.58 | 1168.85 | 1168.85 | 675.0 |
| 2010-04-20 01:30:00 | ES | Futures | 1169.09 | 1169.09 | 1168.11 | 1168.11 | 2951.0 |
| 2010-04-20 02:00:00 | ES | Futures | 1168.11 | 1168.36 | 1167.62 | 1167.87 | 5575.0 |
| 2010-04-20 02:30:00 | ES | Futures | 1167.87 | 1168.6 | 1167.62 | 1168.6 | 4834.0 |
| 2010-04-20 03:00:00 | ES | Futures | 1168.6 | 1170.07 | 1168.11 | 1169.58 | 13458.0 |
| 2010-04-20 03:30:00 | ES | Futures | 1169.58 | 1171.05 | 1169.09 | 1170.31 | 12089.0 |
| 2010-04-20 04:00:00 | ES | Futures | 1170.31 | 1170.8 | 1169.82 | 1170.07 | 10108.0 |
| 2010-04-20 04:30:00 | ES | Futures | 1170.31 | 1170.56 | 1168.6 | 1170.07 | 10436.0 |
| 2010-04-20 05:00:00 | ES | Futures | 1169.82 | 1171.05 | 1167.38 | 1170.07 | 24752.0 |
| 2010-04-20 05:30:00 | ES | Futures | 1170.31 | 1171.54 | 1169.82 | 1171.05 | 8815.0 |
| 2010-04-20 06:00:00 | ES | Futures | 1170.8 | 1173.49 | 1170.8 | 1173.49 | 20474.0 |
| 2010-04-20 06:30:00 | ES | Futures | 1173.25 | 1175.2 | 1173.0 | 1175.2 | 21168.0 |
| 2010-04-20 07:00:00 | ES | Futures | 1175.2 | 1176.18 | 1172.27 | 1173.25 | 31522.0 |
| 2010-04-20 07:30:00 | ES | Futures | 1173.25 | 1174.47 | 1172.76 | 1173.0 | 14661.0 |
| 2010-04-20 08:00:00 | ES | Futures | 1173.25 | 1174.22 | 1172.76 | 1173.73 | 17942.0 |
| 2010-04-20 08:30:00 | ES | Futures | 1173.73 | 1173.73 | 1172.02 | 1172.76 | 22399.0 |
| 2010-04-20 09:00:00 | ES | Futures | 1173.0 | 1174.22 | 1172.51 | 1173.98 | 28486.0 |
| 2010-04-20 09:30:00 | ES | Futures | 1174.22 | 1175.45 | 1171.78 | 1173.98 | 243757.0 |
| 2010-04-20 10:00:00 | ES | Futures | 1173.73 | 1174.47 | 1170.31 | 1171.05 | 144504.0 |
| 2010-04-20 10:30:00 | ES | Futures | 1171.29 | 1173.73 | 1170.31 | 1173.0 | 111520.0 |
| 2010-04-20 11:00:00 | ES | Futures | 1173.0 | 1174.96 | 1172.76 | 1174.22 | 87515.0 |
| 2010-04-20 11:30:00 | ES | Futures | 1174.47 | 1175.93 | 1173.73 | 1175.45 | 67689.0 |
| 2010-04-20 12:00:00 | ES | Futures | 1175.69 | 1178.13 | 1175.45 | 1176.91 | 100541.0 |
| 2010-04-20 12:30:00 | ES | Futures | 1176.91 | 1177.16 | 1175.45 | 1175.93 | 50303.0 |
| 2010-04-20 13:00:00 | ES | Futures | 1176.18 | 1176.91 | 1175.69 | 1176.67 | 31960.0 |
| 2010-04-20 13:30:00 | ES | Futures | 1176.67 | 1176.91 | 1175.45 | 1175.93 | 30753.0 |
| 2010-04-20 14:00:00 | ES | Futures | 1175.93 | 1176.67 | 1174.47 | 1175.69 | 58674.0 |
| 2010-04-20 14:30:00 | ES | Futures | 1175.69 | 1177.65 | 1174.96 | 1177.4 | 56986.0 |
| 2010-04-20 15:00:00 | ES | Futures | 1177.16 | 1177.89 | 1175.2 | 1176.18 | 59268.0 |
| 2010-04-20 15:30:00 | ES | Futures | 1176.18 | 1177.4 | 1175.93 | 1176.91 | 104176.0 |
| 2010-04-20 16:00:00 | ES | Futures | 1176.91 | 1178.87 | 1176.42 | 1178.38 | 98044.0 |
| 2010-04-20 16:30:00 | ES | Futures | 1178.13 | 1181.56 | 1177.89 | 1180.58 | 34195.0 |
| 2010-04-20 17:00:00 | ES | Futures | 1180.58 | 1180.58 | 1179.36 | 1179.85 | 4985.0 |
| 2010-04-20 18:00:00 | ES | Futures | 1179.85 | 1180.33 | 1178.87 | 1179.6 | 3375.0 |
| 2010-04-20 18:30:00 | ES | Futures | 1179.36 | 1180.09 | 1179.11 | 1179.85 | 1029.0 |
| 2010-04-20 19:00:00 | ES | Futures | 1179.85 | 1180.09 | 1179.11 | 1179.36 | 631.0 |
| 2010-04-20 19:30:00 | ES | Futures | 1179.11 | 1179.6 | 1178.87 | 1179.6 | 1211.0 |
| 2010-04-20 20:00:00 | ES | Futures | 1179.36 | 1180.33 | 1179.36 | 1179.85 | 1762.0 |
| 2010-04-20 20:30:00 | ES | Futures | 1179.85 | 1180.33 | 1179.36 | 1180.09 | 2284.0 |
| 2010-04-20 21:00:00 | ES | Futures | 1180.09 | 1181.56 | 1180.09 | 1181.07 | 3472.0 |
| 2010-04-20 21:30:00 | ES | Futures | 1181.07 | 1182.53 | 1181.07 | 1182.05 | 6514.0 |
| 2010-04-20 22:00:00 | ES | Futures | 1182.05 | 1182.29 | 1181.31 | 1181.31 | 1892.0 |
| 2010-04-20 22:30:00 | ES | Futures | 1181.31 | 1181.56 | 1180.33 | 1180.82 | 2540.0 |
| 2010-04-20 23:00:00 | ES | Futures | 1180.82 | 1182.05 | 1180.58 | 1181.8 | 1033.0 |
| 2010-04-20 23:30:00 | ES | Futures | 1182.05 | 1182.05 | 1181.07 | 1181.31 | 1198.0 |
| 2010-04-20 00:00:00 | NQ | Futures | 2304.73 | 2305.59 | 2304.44 | 2304.73 | 121.0 |
| 2010-04-20 00:30:00 | NQ | Futures | 2305.3 | 2306.16 | 2305.01 | 2305.87 | 79.0 |
| 2010-04-20 01:00:00 | NQ | Futures | 2305.59 | 2305.59 | 2304.44 | 2305.01 | 31.0 |
> showing 50 of 2,525 rows — these rows as CSV