PREVIEW / futures_30min / 2010-09-10
file: by_date/futures_30min/2010/2010-09-10.parquet size: 59 KB rows: 2,019
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-09-10 00:00:00 | ES | Futures | 1080.65 | 1081.14 | 1080.41 | 1081.14 | 784.0 |
| 2010-09-10 00:30:00 | ES | Futures | 1081.39 | 1082.12 | 1080.65 | 1081.39 | 883.0 |
| 2010-09-10 01:00:00 | ES | Futures | 1081.39 | 1082.12 | 1080.65 | 1081.88 | 1952.0 |
| 2010-09-10 01:30:00 | ES | Futures | 1081.88 | 1083.84 | 1081.63 | 1083.6 | 1753.0 |
| 2010-09-10 02:00:00 | ES | Futures | 1083.6 | 1083.84 | 1081.63 | 1082.86 | 3065.0 |
| 2010-09-10 02:30:00 | ES | Futures | 1082.61 | 1083.6 | 1082.12 | 1082.86 | 2285.0 |
| 2010-09-10 03:00:00 | ES | Futures | 1083.11 | 1086.05 | 1082.61 | 1085.07 | 11744.0 |
| 2010-09-10 03:30:00 | ES | Futures | 1084.82 | 1086.54 | 1084.58 | 1085.31 | 6662.0 |
| 2010-09-10 04:00:00 | ES | Futures | 1085.07 | 1086.05 | 1082.61 | 1083.11 | 4930.0 |
| 2010-09-10 04:30:00 | ES | Futures | 1083.11 | 1085.31 | 1083.11 | 1085.07 | 4688.0 |
| 2010-09-10 05:00:00 | ES | Futures | 1084.82 | 1085.31 | 1083.6 | 1084.33 | 4019.0 |
| 2010-09-10 05:30:00 | ES | Futures | 1084.33 | 1084.58 | 1083.11 | 1083.11 | 2651.0 |
| 2010-09-10 06:00:00 | ES | Futures | 1083.35 | 1085.07 | 1083.11 | 1085.07 | 2135.0 |
| 2010-09-10 06:30:00 | ES | Futures | 1085.07 | 1085.56 | 1084.33 | 1085.31 | 2621.0 |
| 2010-09-10 07:00:00 | ES | Futures | 1085.31 | 1087.28 | 1085.07 | 1086.79 | 6814.0 |
| 2010-09-10 07:30:00 | ES | Futures | 1086.79 | 1087.03 | 1085.56 | 1086.3 | 4841.0 |
| 2010-09-10 08:00:00 | ES | Futures | 1086.3 | 1086.54 | 1085.31 | 1085.8 | 7227.0 |
| 2010-09-10 08:30:00 | ES | Futures | 1085.8 | 1086.3 | 1084.58 | 1084.82 | 7556.0 |
| 2010-09-10 09:00:00 | ES | Futures | 1084.82 | 1086.05 | 1084.58 | 1085.31 | 7872.0 |
| 2010-09-10 09:30:00 | ES | Futures | 1085.31 | 1088.01 | 1082.61 | 1086.54 | 59256.0 |
| 2010-09-10 10:00:00 | ES | Futures | 1086.3 | 1088.75 | 1085.31 | 1088.01 | 30566.0 |
| 2010-09-10 10:30:00 | ES | Futures | 1088.26 | 1089.49 | 1087.52 | 1088.5 | 25734.0 |
| 2010-09-10 11:00:00 | ES | Futures | 1088.75 | 1088.99 | 1086.54 | 1088.26 | 22800.0 |
| 2010-09-10 11:30:00 | ES | Futures | 1088.26 | 1088.5 | 1084.33 | 1085.31 | 17811.0 |
| 2010-09-10 12:00:00 | ES | Futures | 1085.31 | 1086.3 | 1083.84 | 1085.56 | 13548.0 |
| 2010-09-10 12:30:00 | ES | Futures | 1085.56 | 1087.28 | 1084.33 | 1086.3 | 8301.0 |
| 2010-09-10 13:00:00 | ES | Futures | 1086.05 | 1087.52 | 1086.05 | 1087.28 | 7600.0 |
| 2010-09-10 13:30:00 | ES | Futures | 1087.28 | 1088.26 | 1086.54 | 1087.28 | 9419.0 |
| 2010-09-10 14:00:00 | ES | Futures | 1087.03 | 1088.99 | 1086.79 | 1088.26 | 10957.0 |
| 2010-09-10 14:30:00 | ES | Futures | 1088.5 | 1089.49 | 1087.77 | 1088.5 | 11881.0 |
| 2010-09-10 15:00:00 | ES | Futures | 1088.5 | 1089.73 | 1087.77 | 1089.49 | 17324.0 |
| 2010-09-10 15:30:00 | ES | Futures | 1089.73 | 1089.98 | 1087.52 | 1089.24 | 31462.0 |
| 2010-09-10 16:00:00 | ES | Futures | 1088.99 | 1089.49 | 1088.75 | 1088.99 | 22085.0 |
| 2010-09-10 00:00:00 | NQ | Futures | 2158.99 | 2160.42 | 2158.7 | 2160.42 | 56.0 |
| 2010-09-10 00:30:00 | NQ | Futures | 2159.85 | 2161.57 | 2159.85 | 2160.42 | 16.0 |
| 2010-09-10 01:00:00 | NQ | Futures | 2160.71 | 2161.57 | 2159.56 | 2161.57 | 67.0 |
| 2010-09-10 01:30:00 | NQ | Futures | 2161.85 | 2165.29 | 2161.85 | 2165.01 | 93.0 |
| 2010-09-10 02:00:00 | NQ | Futures | 2164.43 | 2164.43 | 2160.99 | 2163.0 | 220.0 |
| 2010-09-10 02:30:00 | NQ | Futures | 2163.29 | 2164.72 | 2163.0 | 2164.15 | 101.0 |
| 2010-09-10 03:00:00 | NQ | Futures | 2164.15 | 2169.59 | 2163.0 | 2167.59 | 539.0 |
| 2010-09-10 03:30:00 | NQ | Futures | 2168.16 | 2171.02 | 2167.01 | 2169.02 | 455.0 |
| 2010-09-10 04:00:00 | NQ | Futures | 2169.02 | 2169.88 | 2163.86 | 2164.43 | 409.0 |
| 2010-09-10 04:30:00 | NQ | Futures | 2164.15 | 2169.02 | 2164.15 | 2168.45 | 407.0 |
| 2010-09-10 05:00:00 | NQ | Futures | 2168.45 | 2169.3 | 2165.29 | 2167.3 | 174.0 |
| 2010-09-10 05:30:00 | NQ | Futures | 2167.3 | 2167.3 | 2165.29 | 2165.29 | 126.0 |
| 2010-09-10 06:00:00 | NQ | Futures | 2165.29 | 2167.59 | 2165.29 | 2167.59 | 185.0 |
| 2010-09-10 06:30:00 | NQ | Futures | 2167.3 | 2168.45 | 2166.73 | 2168.16 | 156.0 |
| 2010-09-10 07:00:00 | NQ | Futures | 2168.45 | 2171.6 | 2167.3 | 2170.74 | 562.0 |
| 2010-09-10 07:30:00 | NQ | Futures | 2170.74 | 2171.02 | 2168.16 | 2170.45 | 261.0 |
| 2010-09-10 08:00:00 | NQ | Futures | 2170.16 | 2170.16 | 2167.3 | 2169.88 | 858.0 |
> showing 50 of 2,019 rows — these rows as CSV