PREVIEW / futures_30min / 2010-05-31
file: by_date/futures_30min/2010/2010-05-31.parquet size: 43 KB rows: 1,526
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-05-31 00:00:00 | ES | Futures | 1071.08 | 1071.08 | 1069.12 | 1069.85 | 1438.0 |
| 2010-05-31 00:30:00 | ES | Futures | 1069.61 | 1070.83 | 1069.61 | 1070.83 | 711.0 |
| 2010-05-31 01:00:00 | ES | Futures | 1070.59 | 1070.83 | 1068.88 | 1070.34 | 1237.0 |
| 2010-05-31 01:30:00 | ES | Futures | 1070.34 | 1071.56 | 1069.36 | 1070.1 | 2084.0 |
| 2010-05-31 02:00:00 | ES | Futures | 1070.1 | 1070.59 | 1068.39 | 1069.85 | 2800.0 |
| 2010-05-31 02:30:00 | ES | Futures | 1069.85 | 1070.1 | 1066.68 | 1066.92 | 2662.0 |
| 2010-05-31 03:00:00 | ES | Futures | 1066.92 | 1070.1 | 1066.43 | 1068.63 | 3790.0 |
| 2010-05-31 03:30:00 | ES | Futures | 1069.12 | 1070.34 | 1068.39 | 1070.34 | 2854.0 |
| 2010-05-31 04:00:00 | ES | Futures | 1070.1 | 1070.34 | 1068.14 | 1068.14 | 2405.0 |
| 2010-05-31 04:30:00 | ES | Futures | 1068.39 | 1068.88 | 1067.9 | 1068.39 | 1240.0 |
| 2010-05-31 05:00:00 | ES | Futures | 1068.39 | 1069.12 | 1067.65 | 1067.9 | 931.0 |
| 2010-05-31 05:30:00 | ES | Futures | 1067.9 | 1068.88 | 1067.41 | 1068.39 | 1110.0 |
| 2010-05-31 06:00:00 | ES | Futures | 1068.39 | 1069.12 | 1068.39 | 1068.63 | 881.0 |
| 2010-05-31 06:30:00 | ES | Futures | 1068.63 | 1069.36 | 1067.17 | 1067.65 | 1568.0 |
| 2010-05-31 07:00:00 | ES | Futures | 1067.41 | 1068.63 | 1067.41 | 1068.14 | 1361.0 |
| 2010-05-31 07:30:00 | ES | Futures | 1068.14 | 1068.39 | 1067.65 | 1068.39 | 1271.0 |
| 2010-05-31 08:00:00 | ES | Futures | 1068.39 | 1070.1 | 1068.14 | 1070.1 | 1954.0 |
| 2010-05-31 08:30:00 | ES | Futures | 1069.85 | 1070.34 | 1068.39 | 1068.39 | 1663.0 |
| 2010-05-31 09:00:00 | ES | Futures | 1068.39 | 1069.36 | 1068.39 | 1069.12 | 2024.0 |
| 2010-05-31 09:30:00 | ES | Futures | 1069.12 | 1069.85 | 1067.9 | 1068.63 | 3547.0 |
| 2010-05-31 10:00:00 | ES | Futures | 1068.39 | 1068.88 | 1067.41 | 1067.41 | 2966.0 |
| 2010-05-31 10:30:00 | ES | Futures | 1067.41 | 1068.39 | 1067.17 | 1067.41 | 4545.0 |
| 2010-05-31 11:00:00 | ES | Futures | 1067.41 | 1067.65 | 1064.48 | 1066.43 | 9948.0 |
| 2010-05-31 18:00:00 | ES | Futures | 1066.68 | 1067.9 | 1065.21 | 1065.7 | 4134.0 |
| 2010-05-31 18:30:00 | ES | Futures | 1065.45 | 1067.17 | 1064.72 | 1066.92 | 1330.0 |
| 2010-05-31 19:00:00 | ES | Futures | 1066.92 | 1067.17 | 1065.45 | 1065.94 | 1273.0 |
| 2010-05-31 19:30:00 | ES | Futures | 1065.94 | 1066.43 | 1064.48 | 1064.72 | 1482.0 |
| 2010-05-31 20:00:00 | ES | Futures | 1064.48 | 1064.72 | 1061.79 | 1061.79 | 6678.0 |
| 2010-05-31 20:30:00 | ES | Futures | 1061.79 | 1062.03 | 1055.19 | 1057.63 | 13045.0 |
| 2010-05-31 21:00:00 | ES | Futures | 1057.63 | 1058.61 | 1056.17 | 1057.88 | 5375.0 |
| 2010-05-31 21:30:00 | ES | Futures | 1057.88 | 1058.85 | 1055.68 | 1056.41 | 3733.0 |
| 2010-05-31 22:00:00 | ES | Futures | 1056.41 | 1060.57 | 1056.41 | 1059.59 | 4876.0 |
| 2010-05-31 22:30:00 | ES | Futures | 1059.59 | 1060.57 | 1057.63 | 1059.59 | 2920.0 |
| 2010-05-31 23:00:00 | ES | Futures | 1059.59 | 1060.32 | 1058.61 | 1059.1 | 1006.0 |
| 2010-05-31 23:30:00 | ES | Futures | 1058.85 | 1059.83 | 1057.88 | 1058.12 | 1272.0 |
| 2010-05-31 00:00:00 | NQ | Futures | 2136.91 | 2136.91 | 2134.05 | 2134.62 | 153.0 |
| 2010-05-31 00:30:00 | NQ | Futures | 2135.77 | 2136.91 | 2134.62 | 2136.91 | 83.0 |
| 2010-05-31 01:00:00 | NQ | Futures | 2136.91 | 2136.91 | 2133.76 | 2136.34 | 115.0 |
| 2010-05-31 01:30:00 | NQ | Futures | 2136.34 | 2137.49 | 2133.76 | 2134.05 | 180.0 |
| 2010-05-31 02:00:00 | NQ | Futures | 2134.62 | 2135.19 | 2131.76 | 2134.33 | 222.0 |
| 2010-05-31 02:30:00 | NQ | Futures | 2134.05 | 2135.19 | 2129.47 | 2129.75 | 347.0 |
| 2010-05-31 03:00:00 | NQ | Futures | 2129.47 | 2135.19 | 2129.47 | 2134.05 | 280.0 |
| 2010-05-31 03:30:00 | NQ | Futures | 2134.05 | 2135.19 | 2132.62 | 2134.91 | 101.0 |
| 2010-05-31 04:00:00 | NQ | Futures | 2135.19 | 2136.05 | 2132.9 | 2134.33 | 377.0 |
| 2010-05-31 04:30:00 | NQ | Futures | 2133.76 | 2134.91 | 2132.9 | 2134.33 | 66.0 |
| 2010-05-31 05:00:00 | NQ | Futures | 2133.48 | 2134.62 | 2133.19 | 2133.48 | 70.0 |
| 2010-05-31 05:30:00 | NQ | Futures | 2132.9 | 2134.05 | 2132.04 | 2132.9 | 90.0 |
| 2010-05-31 06:00:00 | NQ | Futures | 2133.19 | 2134.33 | 2132.9 | 2133.19 | 115.0 |
| 2010-05-31 06:30:00 | NQ | Futures | 2134.05 | 2134.62 | 2131.76 | 2131.76 | 160.0 |
| 2010-05-31 07:00:00 | NQ | Futures | 2132.04 | 2132.9 | 2131.76 | 2132.33 | 69.0 |
> showing 50 of 1,526 rows — these rows as CSV