PREVIEW / futures_30min / 2010-11-29
file: by_date/futures_30min/2010/2010-11-29.parquet size: 75 KB rows: 2,587
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-11-29 00:00:00 | ES | Futures | 1172.75 | 1173.49 | 1172.01 | 1172.75 | 2146.0 |
| 2010-11-29 00:30:00 | ES | Futures | 1172.75 | 1173.49 | 1171.76 | 1173.24 | 2674.0 |
| 2010-11-29 01:00:00 | ES | Futures | 1173.24 | 1173.98 | 1172.5 | 1172.75 | 1732.0 |
| 2010-11-29 01:30:00 | ES | Futures | 1172.99 | 1172.99 | 1172.25 | 1172.25 | 804.0 |
| 2010-11-29 02:00:00 | ES | Futures | 1172.25 | 1174.96 | 1171.76 | 1174.23 | 8195.0 |
| 2010-11-29 02:30:00 | ES | Futures | 1174.23 | 1175.95 | 1174.23 | 1175.46 | 6704.0 |
| 2010-11-29 03:00:00 | ES | Futures | 1175.46 | 1176.94 | 1174.47 | 1176.2 | 27002.0 |
| 2010-11-29 03:30:00 | ES | Futures | 1176.2 | 1176.44 | 1173.98 | 1174.96 | 19003.0 |
| 2010-11-29 04:00:00 | ES | Futures | 1174.72 | 1176.44 | 1174.23 | 1176.2 | 17320.0 |
| 2010-11-29 04:30:00 | ES | Futures | 1176.2 | 1176.2 | 1170.77 | 1172.99 | 37546.0 |
| 2010-11-29 05:00:00 | ES | Futures | 1172.99 | 1172.99 | 1168.31 | 1170.77 | 34948.0 |
| 2010-11-29 05:30:00 | ES | Futures | 1170.53 | 1171.02 | 1167.57 | 1169.05 | 27867.0 |
| 2010-11-29 06:00:00 | ES | Futures | 1169.05 | 1169.3 | 1167.57 | 1168.56 | 13977.0 |
| 2010-11-29 06:30:00 | ES | Futures | 1168.31 | 1171.51 | 1168.06 | 1170.53 | 15611.0 |
| 2010-11-29 07:00:00 | ES | Futures | 1170.28 | 1170.77 | 1166.34 | 1167.08 | 27214.0 |
| 2010-11-29 07:30:00 | ES | Futures | 1167.08 | 1167.32 | 1162.89 | 1165.35 | 38228.0 |
| 2010-11-29 08:00:00 | ES | Futures | 1165.6 | 1166.58 | 1163.87 | 1166.58 | 27174.0 |
| 2010-11-29 08:30:00 | ES | Futures | 1166.34 | 1166.58 | 1163.63 | 1163.87 | 20094.0 |
| 2010-11-29 09:00:00 | ES | Futures | 1163.87 | 1163.87 | 1161.41 | 1163.13 | 56637.0 |
| 2010-11-29 09:30:00 | ES | Futures | 1163.13 | 1165.85 | 1156.73 | 1158.45 | 304050.0 |
| 2010-11-29 10:00:00 | ES | Futures | 1158.45 | 1160.67 | 1155.74 | 1158.45 | 224114.0 |
| 2010-11-29 10:30:00 | ES | Futures | 1158.7 | 1163.38 | 1158.2 | 1159.68 | 186275.0 |
| 2010-11-29 11:00:00 | ES | Futures | 1159.68 | 1162.64 | 1158.94 | 1160.92 | 172011.0 |
| 2010-11-29 11:30:00 | ES | Futures | 1161.16 | 1161.9 | 1156.97 | 1158.7 | 146719.0 |
| 2010-11-29 12:00:00 | ES | Futures | 1158.94 | 1162.64 | 1158.45 | 1161.41 | 96359.0 |
| 2010-11-29 12:30:00 | ES | Futures | 1161.41 | 1162.89 | 1160.67 | 1162.15 | 72687.0 |
| 2010-11-29 13:00:00 | ES | Futures | 1162.15 | 1162.15 | 1159.44 | 1160.18 | 59080.0 |
| 2010-11-29 13:30:00 | ES | Futures | 1160.18 | 1161.65 | 1158.7 | 1160.67 | 59241.0 |
| 2010-11-29 14:00:00 | ES | Futures | 1160.92 | 1164.86 | 1160.42 | 1164.61 | 94048.0 |
| 2010-11-29 14:30:00 | ES | Futures | 1164.61 | 1169.79 | 1164.37 | 1169.54 | 189622.0 |
| 2010-11-29 15:00:00 | ES | Futures | 1169.54 | 1172.25 | 1169.3 | 1171.76 | 152641.0 |
| 2010-11-29 15:30:00 | ES | Futures | 1172.01 | 1173.24 | 1170.04 | 1170.04 | 174379.0 |
| 2010-11-29 16:00:00 | ES | Futures | 1170.28 | 1170.28 | 1168.8 | 1169.79 | 83990.0 |
| 2010-11-29 16:30:00 | ES | Futures | 1169.79 | 1170.53 | 1168.8 | 1170.28 | 7261.0 |
| 2010-11-29 17:00:00 | ES | Futures | 1170.28 | 1170.77 | 1169.79 | 1170.04 | 1811.0 |
| 2010-11-29 17:30:00 | ES | Futures | 1170.04 | 1170.04 | 1170.04 | 1170.04 | 1.0 |
| 2010-11-29 18:00:00 | ES | Futures | 1170.04 | 1170.77 | 1169.54 | 1170.28 | 2421.0 |
| 2010-11-29 18:30:00 | ES | Futures | 1170.28 | 1170.53 | 1169.05 | 1169.3 | 2792.0 |
| 2010-11-29 19:00:00 | ES | Futures | 1169.3 | 1169.54 | 1168.8 | 1169.05 | 2264.0 |
| 2010-11-29 19:30:00 | ES | Futures | 1169.05 | 1171.27 | 1169.05 | 1170.28 | 3957.0 |
| 2010-11-29 20:00:00 | ES | Futures | 1170.28 | 1171.02 | 1169.54 | 1170.77 | 2860.0 |
| 2010-11-29 20:30:00 | ES | Futures | 1170.77 | 1171.02 | 1170.28 | 1171.02 | 1403.0 |
| 2010-11-29 21:00:00 | ES | Futures | 1171.02 | 1171.51 | 1170.77 | 1171.02 | 1740.0 |
| 2010-11-29 21:30:00 | ES | Futures | 1171.02 | 1171.51 | 1168.06 | 1168.06 | 4493.0 |
| 2010-11-29 22:00:00 | ES | Futures | 1168.06 | 1168.31 | 1167.32 | 1167.32 | 3798.0 |
| 2010-11-29 22:30:00 | ES | Futures | 1167.32 | 1167.32 | 1166.34 | 1167.08 | 5127.0 |
| 2010-11-29 23:00:00 | ES | Futures | 1166.83 | 1167.08 | 1165.35 | 1166.34 | 4989.0 |
| 2010-11-29 23:30:00 | ES | Futures | 1166.09 | 1166.83 | 1165.6 | 1165.85 | 2323.0 |
| 2010-11-29 00:00:00 | NQ | Futures | 2471.09 | 2473.39 | 2470.52 | 2471.67 | 110.0 |
| 2010-11-29 00:30:00 | NQ | Futures | 2471.67 | 2473.1 | 2470.8 | 2472.81 | 128.0 |
> showing 50 of 2,587 rows — these rows as CSV