PREVIEW / futures_30min / 2011-10-07
file: by_date/futures_30min/2011/2011-10-07.parquet size: 67 KB rows: 2,204
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-07 00:00:00 | ES | Futures | 1162.77 | 1162.77 | 1161.51 | 1162.01 | 1915.0 |
| 2011-10-07 00:30:00 | ES | Futures | 1162.01 | 1162.26 | 1160.76 | 1161.01 | 1657.0 |
| 2011-10-07 01:00:00 | ES | Futures | 1160.76 | 1161.51 | 1158.5 | 1160.01 | 4146.0 |
| 2011-10-07 01:30:00 | ES | Futures | 1160.26 | 1160.76 | 1158.75 | 1159.25 | 2155.0 |
| 2011-10-07 02:00:00 | ES | Futures | 1159.25 | 1162.01 | 1158.5 | 1160.51 | 8616.0 |
| 2011-10-07 02:30:00 | ES | Futures | 1160.51 | 1163.27 | 1159.76 | 1160.76 | 8973.0 |
| 2011-10-07 03:00:00 | ES | Futures | 1160.76 | 1162.26 | 1158.25 | 1160.51 | 24172.0 |
| 2011-10-07 03:30:00 | ES | Futures | 1160.76 | 1163.27 | 1160.76 | 1162.51 | 14569.0 |
| 2011-10-07 04:00:00 | ES | Futures | 1162.51 | 1163.77 | 1161.01 | 1163.02 | 13737.0 |
| 2011-10-07 04:30:00 | ES | Futures | 1162.77 | 1163.02 | 1156.75 | 1157.25 | 17294.0 |
| 2011-10-07 05:00:00 | ES | Futures | 1157.5 | 1158.5 | 1155.99 | 1158.0 | 12477.0 |
| 2011-10-07 05:30:00 | ES | Futures | 1157.75 | 1159.76 | 1156.75 | 1159.0 | 11470.0 |
| 2011-10-07 06:00:00 | ES | Futures | 1159.25 | 1160.01 | 1157.0 | 1158.75 | 9785.0 |
| 2011-10-07 06:30:00 | ES | Futures | 1159.0 | 1159.0 | 1157.0 | 1158.25 | 6163.0 |
| 2011-10-07 07:00:00 | ES | Futures | 1158.5 | 1160.76 | 1156.5 | 1157.0 | 29505.0 |
| 2011-10-07 07:30:00 | ES | Futures | 1157.0 | 1158.0 | 1155.99 | 1157.25 | 15408.0 |
| 2011-10-07 08:00:00 | ES | Futures | 1157.25 | 1161.01 | 1157.0 | 1157.75 | 33239.0 |
| 2011-10-07 08:30:00 | ES | Futures | 1157.5 | 1177.31 | 1157.5 | 1171.54 | 217030.0 |
| 2011-10-07 09:00:00 | ES | Futures | 1171.54 | 1172.29 | 1167.03 | 1169.28 | 66534.0 |
| 2011-10-07 09:30:00 | ES | Futures | 1169.28 | 1169.54 | 1161.01 | 1166.02 | 294091.0 |
| 2011-10-07 10:00:00 | ES | Futures | 1166.02 | 1170.04 | 1161.51 | 1167.78 | 244046.0 |
| 2011-10-07 10:30:00 | ES | Futures | 1167.78 | 1169.28 | 1161.76 | 1162.01 | 154732.0 |
| 2011-10-07 11:00:00 | ES | Futures | 1162.01 | 1162.51 | 1156.5 | 1161.01 | 194308.0 |
| 2011-10-07 11:30:00 | ES | Futures | 1161.26 | 1163.27 | 1158.5 | 1163.02 | 117303.0 |
| 2011-10-07 12:00:00 | ES | Futures | 1163.02 | 1164.02 | 1151.23 | 1155.74 | 294635.0 |
| 2011-10-07 12:30:00 | ES | Futures | 1155.49 | 1157.0 | 1149.98 | 1151.23 | 168027.0 |
| 2011-10-07 13:00:00 | ES | Futures | 1151.23 | 1154.99 | 1148.22 | 1153.24 | 109042.0 |
| 2011-10-07 13:30:00 | ES | Futures | 1152.99 | 1154.99 | 1148.22 | 1153.74 | 81490.0 |
| 2011-10-07 14:00:00 | ES | Futures | 1153.99 | 1159.76 | 1152.23 | 1155.24 | 95881.0 |
| 2011-10-07 14:30:00 | ES | Futures | 1155.24 | 1159.25 | 1153.74 | 1158.0 | 79032.0 |
| 2011-10-07 15:00:00 | ES | Futures | 1158.0 | 1167.53 | 1155.74 | 1166.78 | 131203.0 |
| 2011-10-07 15:30:00 | ES | Futures | 1167.03 | 1168.03 | 1152.23 | 1154.74 | 269303.0 |
| 2011-10-07 16:00:00 | ES | Futures | 1154.74 | 1160.26 | 1153.74 | 1159.25 | 93292.0 |
| 2011-10-07 00:00:00 | NQ | Futures | 2547.62 | 2547.62 | 2545.6 | 2547.33 | 72.0 |
| 2011-10-07 00:30:00 | NQ | Futures | 2546.46 | 2546.46 | 2544.16 | 2544.16 | 104.0 |
| 2011-10-07 01:00:00 | NQ | Futures | 2544.16 | 2545.31 | 2539.54 | 2541.56 | 275.0 |
| 2011-10-07 01:30:00 | NQ | Futures | 2542.14 | 2544.16 | 2540.7 | 2540.99 | 116.0 |
| 2011-10-07 02:00:00 | NQ | Futures | 2540.99 | 2546.18 | 2539.83 | 2543.29 | 631.0 |
| 2011-10-07 02:30:00 | NQ | Futures | 2543.29 | 2549.35 | 2541.56 | 2544.16 | 412.0 |
| 2011-10-07 03:00:00 | NQ | Futures | 2544.16 | 2546.75 | 2538.97 | 2544.16 | 2182.0 |
| 2011-10-07 03:30:00 | NQ | Futures | 2544.16 | 2549.06 | 2544.16 | 2547.62 | 1270.0 |
| 2011-10-07 04:00:00 | NQ | Futures | 2547.62 | 2550.21 | 2544.73 | 2547.91 | 1055.0 |
| 2011-10-07 04:30:00 | NQ | Futures | 2547.62 | 2547.62 | 2533.2 | 2534.07 | 2130.0 |
| 2011-10-07 05:00:00 | NQ | Futures | 2534.07 | 2536.95 | 2530.89 | 2535.22 | 1216.0 |
| 2011-10-07 05:30:00 | NQ | Futures | 2535.51 | 2539.26 | 2533.2 | 2537.81 | 747.0 |
| 2011-10-07 06:00:00 | NQ | Futures | 2537.81 | 2539.26 | 2534.64 | 2538.1 | 948.0 |
| 2011-10-07 06:30:00 | NQ | Futures | 2538.1 | 2538.68 | 2534.35 | 2537.24 | 627.0 |
| 2011-10-07 07:00:00 | NQ | Futures | 2537.53 | 2542.43 | 2532.05 | 2532.91 | 2361.0 |
| 2011-10-07 07:30:00 | NQ | Futures | 2533.2 | 2534.64 | 2531.47 | 2533.78 | 2884.0 |
| 2011-10-07 08:00:00 | NQ | Futures | 2534.07 | 2538.68 | 2533.2 | 2534.64 | 4839.0 |
> showing 50 of 2,204 rows — these rows as CSV