PREVIEW / futures_30min / 2010-02-23
file: by_date/futures_30min/2010/2010-02-23.parquet size: 73 KB rows: 2,535
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-02-23 00:00:00 | ES | Futures | 1078.12 | 1078.61 | 1078.12 | 1078.61 | 1604.0 |
| 2010-02-23 00:30:00 | ES | Futures | 1078.85 | 1078.85 | 1078.37 | 1078.37 | 521.0 |
| 2010-02-23 01:00:00 | ES | Futures | 1078.37 | 1078.85 | 1077.88 | 1078.12 | 967.0 |
| 2010-02-23 01:30:00 | ES | Futures | 1078.12 | 1078.61 | 1077.39 | 1078.61 | 1253.0 |
| 2010-02-23 02:00:00 | ES | Futures | 1078.37 | 1080.07 | 1078.12 | 1079.34 | 8149.0 |
| 2010-02-23 02:30:00 | ES | Futures | 1079.34 | 1081.77 | 1079.1 | 1081.04 | 9530.0 |
| 2010-02-23 03:00:00 | ES | Futures | 1080.8 | 1082.74 | 1080.8 | 1082.5 | 14248.0 |
| 2010-02-23 03:30:00 | ES | Futures | 1082.26 | 1082.5 | 1080.8 | 1081.29 | 9368.0 |
| 2010-02-23 04:00:00 | ES | Futures | 1081.29 | 1081.29 | 1079.58 | 1079.83 | 12106.0 |
| 2010-02-23 04:30:00 | ES | Futures | 1079.83 | 1081.04 | 1079.34 | 1080.31 | 6247.0 |
| 2010-02-23 05:00:00 | ES | Futures | 1080.07 | 1080.07 | 1076.18 | 1076.42 | 17888.0 |
| 2010-02-23 05:30:00 | ES | Futures | 1076.66 | 1076.66 | 1074.47 | 1075.2 | 23153.0 |
| 2010-02-23 06:00:00 | ES | Futures | 1075.2 | 1075.93 | 1073.01 | 1073.99 | 22074.0 |
| 2010-02-23 06:30:00 | ES | Futures | 1073.99 | 1074.72 | 1072.53 | 1073.99 | 12436.0 |
| 2010-02-23 07:00:00 | ES | Futures | 1073.99 | 1075.69 | 1073.5 | 1074.47 | 11164.0 |
| 2010-02-23 07:30:00 | ES | Futures | 1074.72 | 1075.69 | 1072.77 | 1074.96 | 16777.0 |
| 2010-02-23 08:00:00 | ES | Futures | 1074.96 | 1075.93 | 1073.74 | 1073.99 | 18027.0 |
| 2010-02-23 08:30:00 | ES | Futures | 1074.23 | 1074.23 | 1072.28 | 1074.23 | 26848.0 |
| 2010-02-23 09:00:00 | ES | Futures | 1074.23 | 1074.47 | 1073.01 | 1074.23 | 20840.0 |
| 2010-02-23 09:30:00 | ES | Futures | 1073.99 | 1077.64 | 1073.01 | 1076.18 | 186423.0 |
| 2010-02-23 10:00:00 | ES | Futures | 1075.93 | 1075.93 | 1064.5 | 1066.2 | 360996.0 |
| 2010-02-23 10:30:00 | ES | Futures | 1065.96 | 1067.66 | 1064.01 | 1067.42 | 148238.0 |
| 2010-02-23 11:00:00 | ES | Futures | 1067.18 | 1068.39 | 1065.23 | 1066.2 | 110328.0 |
| 2010-02-23 11:30:00 | ES | Futures | 1065.96 | 1067.66 | 1065.47 | 1065.96 | 84016.0 |
| 2010-02-23 12:00:00 | ES | Futures | 1065.96 | 1066.2 | 1062.8 | 1063.53 | 124537.0 |
| 2010-02-23 12:30:00 | ES | Futures | 1063.53 | 1064.5 | 1061.58 | 1063.77 | 121049.0 |
| 2010-02-23 13:00:00 | ES | Futures | 1063.77 | 1065.23 | 1062.55 | 1064.99 | 77481.0 |
| 2010-02-23 13:30:00 | ES | Futures | 1064.74 | 1065.23 | 1061.82 | 1062.55 | 96776.0 |
| 2010-02-23 14:00:00 | ES | Futures | 1062.55 | 1064.5 | 1060.85 | 1063.28 | 111720.0 |
| 2010-02-23 14:30:00 | ES | Futures | 1063.04 | 1066.69 | 1062.31 | 1065.72 | 125483.0 |
| 2010-02-23 15:00:00 | ES | Futures | 1065.96 | 1067.66 | 1064.74 | 1066.93 | 92389.0 |
| 2010-02-23 15:30:00 | ES | Futures | 1066.93 | 1066.93 | 1062.8 | 1063.53 | 188273.0 |
| 2010-02-23 16:00:00 | ES | Futures | 1063.53 | 1067.91 | 1063.28 | 1067.66 | 130022.0 |
| 2010-02-23 16:30:00 | ES | Futures | 1067.18 | 1067.66 | 1066.69 | 1067.18 | 6444.0 |
| 2010-02-23 17:00:00 | ES | Futures | 1066.93 | 1067.18 | 1066.45 | 1066.69 | 2063.0 |
| 2010-02-23 18:00:00 | ES | Futures | 1066.69 | 1067.18 | 1066.2 | 1066.45 | 2478.0 |
| 2010-02-23 18:30:00 | ES | Futures | 1066.45 | 1066.93 | 1065.96 | 1066.2 | 1892.0 |
| 2010-02-23 19:00:00 | ES | Futures | 1066.45 | 1066.45 | 1065.72 | 1066.2 | 1556.0 |
| 2010-02-23 19:30:00 | ES | Futures | 1066.2 | 1066.45 | 1065.72 | 1066.2 | 1179.0 |
| 2010-02-23 20:00:00 | ES | Futures | 1065.96 | 1066.93 | 1065.72 | 1066.93 | 1853.0 |
| 2010-02-23 20:30:00 | ES | Futures | 1066.69 | 1067.66 | 1066.2 | 1067.18 | 3087.0 |
| 2010-02-23 21:00:00 | ES | Futures | 1067.42 | 1068.39 | 1067.18 | 1067.42 | 3691.0 |
| 2010-02-23 21:30:00 | ES | Futures | 1067.66 | 1068.15 | 1066.93 | 1067.42 | 1730.0 |
| 2010-02-23 22:00:00 | ES | Futures | 1067.66 | 1068.39 | 1066.93 | 1068.39 | 2089.0 |
| 2010-02-23 22:30:00 | ES | Futures | 1068.15 | 1069.12 | 1067.91 | 1068.39 | 3767.0 |
| 2010-02-23 23:00:00 | ES | Futures | 1068.39 | 1068.88 | 1067.91 | 1068.15 | 1401.0 |
| 2010-02-23 23:30:00 | ES | Futures | 1068.15 | 1068.39 | 1066.93 | 1067.42 | 1749.0 |
| 2010-02-23 00:00:00 | NQ | Futures | 2081.67 | 2081.95 | 2081.38 | 2081.67 | 87.0 |
| 2010-02-23 00:30:00 | NQ | Futures | 2081.67 | 2082.81 | 2081.38 | 2082.52 | 176.0 |
| 2010-02-23 01:00:00 | NQ | Futures | 2082.24 | 2082.81 | 2081.09 | 2081.67 | 96.0 |
> showing 50 of 2,535 rows — these rows as CSV