PREVIEW / futures_30min / 2010-04-21
file: by_date/futures_30min/2010/2010-04-21.parquet size: 69 KB rows: 2,551
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-21 00:00:00 | ES | Futures | 1181.31 | 1182.29 | 1181.07 | 1181.8 | 1089.0 |
| 2010-04-21 00:30:00 | ES | Futures | 1181.8 | 1182.29 | 1181.31 | 1182.05 | 922.0 |
| 2010-04-21 01:00:00 | ES | Futures | 1182.05 | 1182.53 | 1181.8 | 1182.29 | 1377.0 |
| 2010-04-21 01:30:00 | ES | Futures | 1182.05 | 1182.53 | 1181.8 | 1181.8 | 1812.0 |
| 2010-04-21 02:00:00 | ES | Futures | 1182.05 | 1182.05 | 1180.82 | 1181.07 | 6873.0 |
| 2010-04-21 02:30:00 | ES | Futures | 1181.07 | 1181.8 | 1180.82 | 1181.07 | 2964.0 |
| 2010-04-21 03:00:00 | ES | Futures | 1180.82 | 1181.07 | 1179.11 | 1179.36 | 14139.0 |
| 2010-04-21 03:30:00 | ES | Futures | 1179.36 | 1179.85 | 1178.87 | 1179.36 | 9259.0 |
| 2010-04-21 04:00:00 | ES | Futures | 1179.36 | 1180.09 | 1178.62 | 1179.36 | 6220.0 |
| 2010-04-21 04:30:00 | ES | Futures | 1179.36 | 1179.6 | 1178.62 | 1178.87 | 5323.0 |
| 2010-04-21 05:00:00 | ES | Futures | 1178.87 | 1179.36 | 1178.38 | 1179.11 | 5909.0 |
| 2010-04-21 05:30:00 | ES | Futures | 1179.11 | 1179.36 | 1178.38 | 1178.87 | 5008.0 |
| 2010-04-21 06:00:00 | ES | Futures | 1178.87 | 1179.11 | 1176.67 | 1176.67 | 16903.0 |
| 2010-04-21 06:30:00 | ES | Futures | 1176.91 | 1177.4 | 1175.69 | 1176.18 | 21744.0 |
| 2010-04-21 07:00:00 | ES | Futures | 1175.93 | 1176.91 | 1175.69 | 1176.18 | 12337.0 |
| 2010-04-21 07:30:00 | ES | Futures | 1176.18 | 1177.16 | 1174.96 | 1176.91 | 24556.0 |
| 2010-04-21 08:00:00 | ES | Futures | 1176.67 | 1177.65 | 1175.93 | 1176.91 | 33783.0 |
| 2010-04-21 08:30:00 | ES | Futures | 1176.91 | 1178.13 | 1176.42 | 1177.16 | 32314.0 |
| 2010-04-21 09:00:00 | ES | Futures | 1177.16 | 1178.38 | 1176.91 | 1177.89 | 28355.0 |
| 2010-04-21 09:30:00 | ES | Futures | 1177.89 | 1180.58 | 1176.67 | 1180.09 | 191454.0 |
| 2010-04-21 10:00:00 | ES | Futures | 1180.33 | 1180.33 | 1176.42 | 1176.91 | 143137.0 |
| 2010-04-21 10:30:00 | ES | Futures | 1176.67 | 1179.11 | 1175.45 | 1176.42 | 165777.0 |
| 2010-04-21 11:00:00 | ES | Futures | 1176.18 | 1177.4 | 1173.25 | 1173.98 | 170924.0 |
| 2010-04-21 11:30:00 | ES | Futures | 1173.98 | 1175.45 | 1171.54 | 1174.96 | 143327.0 |
| 2010-04-21 12:00:00 | ES | Futures | 1175.2 | 1176.67 | 1174.47 | 1175.93 | 63231.0 |
| 2010-04-21 12:30:00 | ES | Futures | 1176.18 | 1178.13 | 1175.69 | 1175.69 | 94478.0 |
| 2010-04-21 13:00:00 | ES | Futures | 1175.93 | 1176.67 | 1173.98 | 1174.96 | 83134.0 |
| 2010-04-21 13:30:00 | ES | Futures | 1174.96 | 1176.91 | 1174.96 | 1176.67 | 50843.0 |
| 2010-04-21 14:00:00 | ES | Futures | 1176.67 | 1176.67 | 1170.07 | 1170.8 | 159429.0 |
| 2010-04-21 14:30:00 | ES | Futures | 1170.56 | 1171.78 | 1168.36 | 1171.54 | 159911.0 |
| 2010-04-21 15:00:00 | ES | Futures | 1171.54 | 1173.25 | 1171.29 | 1172.27 | 122067.0 |
| 2010-04-21 15:30:00 | ES | Futures | 1172.27 | 1176.18 | 1172.02 | 1174.96 | 213930.0 |
| 2010-04-21 16:00:00 | ES | Futures | 1174.96 | 1175.2 | 1172.76 | 1172.76 | 88972.0 |
| 2010-04-21 16:30:00 | ES | Futures | 1171.78 | 1172.02 | 1169.58 | 1170.8 | 23033.0 |
| 2010-04-21 17:00:00 | ES | Futures | 1170.8 | 1171.29 | 1170.31 | 1170.56 | 2956.0 |
| 2010-04-21 18:00:00 | ES | Futures | 1170.8 | 1171.05 | 1170.56 | 1170.8 | 1002.0 |
| 2010-04-21 18:30:00 | ES | Futures | 1170.8 | 1171.29 | 1170.8 | 1171.05 | 839.0 |
| 2010-04-21 19:00:00 | ES | Futures | 1171.05 | 1171.29 | 1170.56 | 1170.56 | 913.0 |
| 2010-04-21 19:30:00 | ES | Futures | 1170.8 | 1171.54 | 1170.31 | 1171.54 | 2452.0 |
| 2010-04-21 20:00:00 | ES | Futures | 1171.54 | 1171.78 | 1170.07 | 1170.07 | 2552.0 |
| 2010-04-21 20:30:00 | ES | Futures | 1170.31 | 1170.8 | 1169.58 | 1170.8 | 2421.0 |
| 2010-04-21 21:00:00 | ES | Futures | 1170.8 | 1171.05 | 1169.82 | 1170.07 | 1594.0 |
| 2010-04-21 21:30:00 | ES | Futures | 1169.82 | 1170.31 | 1169.09 | 1170.07 | 3015.0 |
| 2010-04-21 22:00:00 | ES | Futures | 1170.31 | 1170.31 | 1169.34 | 1169.82 | 2433.0 |
| 2010-04-21 22:30:00 | ES | Futures | 1169.82 | 1170.31 | 1169.58 | 1170.07 | 1817.0 |
| 2010-04-21 23:00:00 | ES | Futures | 1170.31 | 1170.56 | 1170.07 | 1170.07 | 2516.0 |
| 2010-04-21 23:30:00 | ES | Futures | 1170.31 | 1170.56 | 1169.82 | 1170.56 | 1482.0 |
| 2010-04-21 00:00:00 | NQ | Futures | 2334.8 | 2335.37 | 2334.22 | 2334.8 | 48.0 |
| 2010-04-21 00:30:00 | NQ | Futures | 2334.22 | 2335.65 | 2334.22 | 2335.37 | 51.0 |
| 2010-04-21 01:00:00 | NQ | Futures | 2335.08 | 2335.94 | 2334.8 | 2335.65 | 58.0 |
> showing 50 of 2,551 rows — these rows as CSV