PREVIEW / futures_30min / 2010-04-08
file: by_date/futures_30min/2010/2010-04-08.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-08 00:00:00 | ES | Futures | 1149.54 | 1150.27 | 1149.05 | 1150.03 | 2849.0 |
| 2010-04-08 00:30:00 | ES | Futures | 1150.03 | 1150.27 | 1149.54 | 1150.27 | 548.0 |
| 2010-04-08 01:00:00 | ES | Futures | 1150.27 | 1151.0 | 1149.78 | 1150.76 | 621.0 |
| 2010-04-08 01:30:00 | ES | Futures | 1150.76 | 1151.0 | 1150.27 | 1150.27 | 1099.0 |
| 2010-04-08 02:00:00 | ES | Futures | 1150.51 | 1150.51 | 1149.29 | 1149.54 | 2628.0 |
| 2010-04-08 02:30:00 | ES | Futures | 1149.78 | 1150.03 | 1148.8 | 1149.54 | 3962.0 |
| 2010-04-08 03:00:00 | ES | Futures | 1149.78 | 1150.51 | 1148.07 | 1148.31 | 9623.0 |
| 2010-04-08 03:30:00 | ES | Futures | 1148.07 | 1148.8 | 1147.83 | 1147.83 | 17245.0 |
| 2010-04-08 04:00:00 | ES | Futures | 1147.83 | 1148.31 | 1146.36 | 1146.85 | 15578.0 |
| 2010-04-08 04:30:00 | ES | Futures | 1146.6 | 1148.31 | 1146.6 | 1148.07 | 9726.0 |
| 2010-04-08 05:00:00 | ES | Futures | 1148.07 | 1148.8 | 1146.36 | 1146.6 | 11562.0 |
| 2010-04-08 05:30:00 | ES | Futures | 1146.6 | 1147.83 | 1146.6 | 1147.58 | 8188.0 |
| 2010-04-08 06:00:00 | ES | Futures | 1147.58 | 1149.54 | 1147.09 | 1149.29 | 9495.0 |
| 2010-04-08 06:30:00 | ES | Futures | 1149.29 | 1149.54 | 1148.8 | 1149.05 | 4800.0 |
| 2010-04-08 07:00:00 | ES | Futures | 1149.05 | 1149.29 | 1147.83 | 1148.07 | 6627.0 |
| 2010-04-08 07:30:00 | ES | Futures | 1148.07 | 1148.31 | 1146.36 | 1146.6 | 22747.0 |
| 2010-04-08 08:00:00 | ES | Futures | 1146.85 | 1149.29 | 1146.6 | 1148.07 | 27492.0 |
| 2010-04-08 08:30:00 | ES | Futures | 1148.07 | 1149.05 | 1145.87 | 1149.05 | 53336.0 |
| 2010-04-08 09:00:00 | ES | Futures | 1148.8 | 1149.29 | 1147.09 | 1148.8 | 39192.0 |
| 2010-04-08 09:30:00 | ES | Futures | 1148.8 | 1148.8 | 1144.89 | 1146.36 | 226730.0 |
| 2010-04-08 10:00:00 | ES | Futures | 1146.11 | 1149.29 | 1145.38 | 1148.8 | 152128.0 |
| 2010-04-08 10:30:00 | ES | Futures | 1148.8 | 1150.27 | 1148.31 | 1149.05 | 130990.0 |
| 2010-04-08 11:00:00 | ES | Futures | 1149.05 | 1151.0 | 1148.8 | 1149.05 | 93464.0 |
| 2010-04-08 11:30:00 | ES | Futures | 1148.8 | 1152.47 | 1148.8 | 1152.23 | 110293.0 |
| 2010-04-08 12:00:00 | ES | Futures | 1152.23 | 1154.43 | 1151.74 | 1153.94 | 130312.0 |
| 2010-04-08 12:30:00 | ES | Futures | 1153.69 | 1155.4 | 1153.45 | 1155.4 | 107184.0 |
| 2010-04-08 13:00:00 | ES | Futures | 1155.16 | 1156.63 | 1154.91 | 1155.4 | 112828.0 |
| 2010-04-08 13:30:00 | ES | Futures | 1155.4 | 1157.11 | 1154.91 | 1155.4 | 95402.0 |
| 2010-04-08 14:00:00 | ES | Futures | 1155.65 | 1157.11 | 1155.16 | 1156.87 | 59140.0 |
| 2010-04-08 14:30:00 | ES | Futures | 1156.87 | 1158.58 | 1156.14 | 1157.6 | 101322.0 |
| 2010-04-08 15:00:00 | ES | Futures | 1157.6 | 1158.34 | 1156.63 | 1157.36 | 69636.0 |
| 2010-04-08 15:30:00 | ES | Futures | 1157.36 | 1158.58 | 1156.14 | 1156.63 | 154187.0 |
| 2010-04-08 16:00:00 | ES | Futures | 1156.38 | 1157.36 | 1156.14 | 1157.36 | 83421.0 |
| 2010-04-08 16:30:00 | ES | Futures | 1157.11 | 1157.85 | 1157.11 | 1157.6 | 4824.0 |
| 2010-04-08 17:00:00 | ES | Futures | 1157.6 | 1157.85 | 1157.36 | 1157.6 | 678.0 |
| 2010-04-08 18:00:00 | ES | Futures | 1157.36 | 1158.09 | 1156.87 | 1157.6 | 4649.0 |
| 2010-04-08 18:30:00 | ES | Futures | 1157.6 | 1157.85 | 1157.6 | 1157.6 | 371.0 |
| 2010-04-08 19:00:00 | ES | Futures | 1157.6 | 1158.09 | 1157.6 | 1157.6 | 758.0 |
| 2010-04-08 19:30:00 | ES | Futures | 1157.6 | 1158.09 | 1157.36 | 1157.6 | 2020.0 |
| 2010-04-08 20:00:00 | ES | Futures | 1157.6 | 1158.09 | 1157.6 | 1157.85 | 950.0 |
| 2010-04-08 20:30:00 | ES | Futures | 1157.85 | 1158.09 | 1157.11 | 1157.11 | 2354.0 |
| 2010-04-08 21:00:00 | ES | Futures | 1157.11 | 1157.36 | 1156.63 | 1157.11 | 2456.0 |
| 2010-04-08 21:30:00 | ES | Futures | 1156.87 | 1157.6 | 1156.63 | 1157.11 | 1503.0 |
| 2010-04-08 22:00:00 | ES | Futures | 1157.36 | 1157.36 | 1156.63 | 1156.87 | 918.0 |
| 2010-04-08 22:30:00 | ES | Futures | 1156.87 | 1157.11 | 1156.63 | 1156.63 | 639.0 |
| 2010-04-08 23:00:00 | ES | Futures | 1156.87 | 1157.11 | 1156.63 | 1157.11 | 1035.0 |
| 2010-04-08 23:30:00 | ES | Futures | 1156.87 | 1157.6 | 1156.87 | 1157.36 | 1123.0 |
| 2010-04-08 00:00:00 | NQ | Futures | 2258.62 | 2258.91 | 2258.05 | 2258.91 | 139.0 |
| 2010-04-08 00:30:00 | NQ | Futures | 2258.62 | 2258.91 | 2258.05 | 2258.91 | 72.0 |
| 2010-04-08 01:00:00 | NQ | Futures | 2258.91 | 2261.2 | 2258.62 | 2260.91 | 147.0 |
> showing 50 of 2,525 rows — these rows as CSV