PREVIEW / futures_30min / 2010-11-26
file: by_date/futures_30min/2010/2010-11-26.parquet size: 53 KB rows: 1,751
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-26 00:00:00 | ES | Futures | 1179.89 | 1179.89 | 1177.92 | 1178.42 | 3202.0 |
| 2010-11-26 00:30:00 | ES | Futures | 1178.66 | 1178.66 | 1177.18 | 1177.43 | 2015.0 |
| 2010-11-26 01:00:00 | ES | Futures | 1177.68 | 1177.92 | 1176.2 | 1176.94 | 3032.0 |
| 2010-11-26 01:30:00 | ES | Futures | 1176.94 | 1177.92 | 1174.72 | 1175.21 | 7342.0 |
| 2010-11-26 02:00:00 | ES | Futures | 1175.46 | 1177.68 | 1175.21 | 1177.43 | 5386.0 |
| 2010-11-26 02:30:00 | ES | Futures | 1177.18 | 1177.92 | 1175.46 | 1175.7 | 5919.0 |
| 2010-11-26 03:00:00 | ES | Futures | 1175.46 | 1177.43 | 1174.23 | 1176.69 | 15837.0 |
| 2010-11-26 03:30:00 | ES | Futures | 1176.69 | 1178.91 | 1176.2 | 1176.44 | 8911.0 |
| 2010-11-26 04:00:00 | ES | Futures | 1176.69 | 1177.18 | 1173.98 | 1173.98 | 16809.0 |
| 2010-11-26 04:30:00 | ES | Futures | 1173.98 | 1174.47 | 1169.05 | 1170.53 | 33105.0 |
| 2010-11-26 05:00:00 | ES | Futures | 1170.53 | 1171.76 | 1167.82 | 1170.77 | 22427.0 |
| 2010-11-26 05:30:00 | ES | Futures | 1170.77 | 1171.27 | 1168.56 | 1170.04 | 5938.0 |
| 2010-11-26 06:00:00 | ES | Futures | 1170.04 | 1170.04 | 1166.09 | 1168.56 | 21126.0 |
| 2010-11-26 06:30:00 | ES | Futures | 1168.56 | 1169.05 | 1165.85 | 1168.8 | 26249.0 |
| 2010-11-26 07:00:00 | ES | Futures | 1168.8 | 1168.8 | 1165.85 | 1167.08 | 23713.0 |
| 2010-11-26 07:30:00 | ES | Futures | 1167.08 | 1170.77 | 1166.83 | 1170.53 | 22950.0 |
| 2010-11-26 08:00:00 | ES | Futures | 1170.53 | 1171.02 | 1167.82 | 1168.8 | 21034.0 |
| 2010-11-26 08:30:00 | ES | Futures | 1168.8 | 1170.77 | 1167.57 | 1170.53 | 23669.0 |
| 2010-11-26 09:00:00 | ES | Futures | 1170.53 | 1172.5 | 1169.79 | 1170.04 | 35991.0 |
| 2010-11-26 09:30:00 | ES | Futures | 1169.79 | 1174.23 | 1168.56 | 1173.98 | 146013.0 |
| 2010-11-26 10:00:00 | ES | Futures | 1174.23 | 1176.44 | 1172.75 | 1174.72 | 79510.0 |
| 2010-11-26 10:30:00 | ES | Futures | 1174.47 | 1175.7 | 1172.25 | 1172.5 | 52374.0 |
| 2010-11-26 11:00:00 | ES | Futures | 1172.25 | 1173.49 | 1171.76 | 1172.5 | 42015.0 |
| 2010-11-26 11:30:00 | ES | Futures | 1172.5 | 1172.75 | 1170.04 | 1172.25 | 41618.0 |
| 2010-11-26 12:00:00 | ES | Futures | 1172.01 | 1173.24 | 1170.53 | 1172.5 | 36686.0 |
| 2010-11-26 12:30:00 | ES | Futures | 1172.75 | 1173.49 | 1171.02 | 1171.27 | 45912.0 |
| 2010-11-26 13:00:00 | ES | Futures | 1171.27 | 1171.27 | 1166.34 | 1166.58 | 68301.0 |
| 2010-11-26 00:00:00 | NQ | Futures | 2475.39 | 2475.39 | 2472.24 | 2472.81 | 248.0 |
| 2010-11-26 00:30:00 | NQ | Futures | 2472.81 | 2472.81 | 2470.52 | 2470.52 | 191.0 |
| 2010-11-26 01:00:00 | NQ | Futures | 2471.09 | 2471.67 | 2468.51 | 2469.94 | 255.0 |
| 2010-11-26 01:30:00 | NQ | Futures | 2470.23 | 2471.09 | 2466.5 | 2466.79 | 399.0 |
| 2010-11-26 02:00:00 | NQ | Futures | 2467.36 | 2471.67 | 2467.07 | 2471.38 | 410.0 |
| 2010-11-26 02:30:00 | NQ | Futures | 2471.95 | 2472.24 | 2468.51 | 2469.08 | 205.0 |
| 2010-11-26 03:00:00 | NQ | Futures | 2468.8 | 2472.24 | 2467.07 | 2469.37 | 1015.0 |
| 2010-11-26 03:30:00 | NQ | Futures | 2469.37 | 2473.67 | 2468.8 | 2469.94 | 749.0 |
| 2010-11-26 04:00:00 | NQ | Futures | 2469.66 | 2470.8 | 2463.06 | 2463.34 | 1487.0 |
| 2010-11-26 04:30:00 | NQ | Futures | 2463.06 | 2463.63 | 2453.88 | 2455.89 | 2130.0 |
| 2010-11-26 05:00:00 | NQ | Futures | 2455.89 | 2458.47 | 2451.01 | 2456.75 | 1788.0 |
| 2010-11-26 05:30:00 | NQ | Futures | 2456.75 | 2457.32 | 2453.88 | 2456.17 | 685.0 |
| 2010-11-26 06:00:00 | NQ | Futures | 2456.17 | 2456.17 | 2449.86 | 2454.16 | 1339.0 |
| 2010-11-26 06:30:00 | NQ | Futures | 2454.16 | 2454.45 | 2450.15 | 2453.88 | 1004.0 |
| 2010-11-26 07:00:00 | NQ | Futures | 2453.59 | 2454.16 | 2451.01 | 2452.44 | 908.0 |
| 2010-11-26 07:30:00 | NQ | Futures | 2452.44 | 2457.61 | 2452.44 | 2457.03 | 1284.0 |
| 2010-11-26 08:00:00 | NQ | Futures | 2457.32 | 2459.62 | 2453.02 | 2455.02 | 2028.0 |
| 2010-11-26 08:30:00 | NQ | Futures | 2455.02 | 2460.19 | 2453.3 | 2459.62 | 2460.0 |
| 2010-11-26 09:00:00 | NQ | Futures | 2459.62 | 2467.94 | 2458.75 | 2463.63 | 4919.0 |
| 2010-11-26 09:30:00 | NQ | Futures | 2463.63 | 2474.53 | 2457.61 | 2472.81 | 24568.0 |
| 2010-11-26 10:00:00 | NQ | Futures | 2472.53 | 2479.12 | 2469.94 | 2476.26 | 11267.0 |
| 2010-11-26 10:30:00 | NQ | Futures | 2476.26 | 2479.12 | 2469.37 | 2470.52 | 8405.0 |
| 2010-11-26 11:00:00 | NQ | Futures | 2470.52 | 2475.68 | 2469.66 | 2472.81 | 6349.0 |
> showing 50 of 1,751 rows — these rows as CSV