PREVIEW / futures_30min / 2009-12-07
file: by_date/futures_30min/2009/2009-12-07.parquet size: 70 KB rows: 2,465
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-07 00:00:00 | ES | Futures | 1072.56 | 1073.77 | 1072.32 | 1073.28 | 1125.0 |
| 2009-12-07 00:30:00 | ES | Futures | 1073.53 | 1073.53 | 1071.1 | 1071.35 | 3149.0 |
| 2009-12-07 01:00:00 | ES | Futures | 1071.35 | 1072.07 | 1070.86 | 1071.59 | 1776.0 |
| 2009-12-07 01:30:00 | ES | Futures | 1071.59 | 1072.07 | 1071.1 | 1071.35 | 1051.0 |
| 2009-12-07 02:00:00 | ES | Futures | 1071.1 | 1071.59 | 1069.89 | 1070.38 | 4504.0 |
| 2009-12-07 02:30:00 | ES | Futures | 1070.62 | 1070.86 | 1070.14 | 1070.38 | 1657.0 |
| 2009-12-07 03:00:00 | ES | Futures | 1070.38 | 1070.62 | 1067.47 | 1068.44 | 19581.0 |
| 2009-12-07 03:30:00 | ES | Futures | 1068.44 | 1068.44 | 1064.81 | 1065.29 | 22028.0 |
| 2009-12-07 04:00:00 | ES | Futures | 1065.53 | 1067.71 | 1064.56 | 1067.47 | 12656.0 |
| 2009-12-07 04:30:00 | ES | Futures | 1067.47 | 1070.62 | 1067.47 | 1070.38 | 10162.0 |
| 2009-12-07 05:00:00 | ES | Futures | 1070.14 | 1071.83 | 1069.41 | 1071.35 | 9549.0 |
| 2009-12-07 05:30:00 | ES | Futures | 1071.35 | 1072.07 | 1068.92 | 1069.17 | 8877.0 |
| 2009-12-07 06:00:00 | ES | Futures | 1068.92 | 1070.38 | 1068.44 | 1069.65 | 5612.0 |
| 2009-12-07 06:30:00 | ES | Futures | 1069.65 | 1070.86 | 1069.41 | 1069.65 | 3696.0 |
| 2009-12-07 07:00:00 | ES | Futures | 1069.89 | 1070.14 | 1068.68 | 1069.17 | 5643.0 |
| 2009-12-07 07:30:00 | ES | Futures | 1068.92 | 1071.83 | 1068.92 | 1071.1 | 13215.0 |
| 2009-12-07 08:00:00 | ES | Futures | 1071.1 | 1071.35 | 1070.14 | 1070.62 | 9984.0 |
| 2009-12-07 08:30:00 | ES | Futures | 1070.86 | 1071.59 | 1070.14 | 1070.86 | 15915.0 |
| 2009-12-07 09:00:00 | ES | Futures | 1070.86 | 1071.35 | 1069.41 | 1070.38 | 14375.0 |
| 2009-12-07 09:30:00 | ES | Futures | 1070.14 | 1075.95 | 1069.65 | 1074.5 | 204541.0 |
| 2009-12-07 10:00:00 | ES | Futures | 1074.5 | 1075.22 | 1070.62 | 1073.77 | 146106.0 |
| 2009-12-07 10:30:00 | ES | Futures | 1074.01 | 1074.98 | 1072.32 | 1073.04 | 96839.0 |
| 2009-12-07 11:00:00 | ES | Futures | 1072.8 | 1073.04 | 1071.1 | 1071.35 | 85811.0 |
| 2009-12-07 11:30:00 | ES | Futures | 1071.35 | 1073.04 | 1071.35 | 1072.8 | 38876.0 |
| 2009-12-07 12:00:00 | ES | Futures | 1072.56 | 1072.8 | 1071.1 | 1071.83 | 30188.0 |
| 2009-12-07 12:30:00 | ES | Futures | 1071.83 | 1074.98 | 1071.59 | 1074.01 | 101827.0 |
| 2009-12-07 13:00:00 | ES | Futures | 1074.01 | 1075.71 | 1073.28 | 1074.74 | 68785.0 |
| 2009-12-07 13:30:00 | ES | Futures | 1074.74 | 1074.98 | 1072.32 | 1073.04 | 55389.0 |
| 2009-12-07 14:00:00 | ES | Futures | 1073.04 | 1073.53 | 1071.1 | 1071.35 | 52802.0 |
| 2009-12-07 14:30:00 | ES | Futures | 1071.1 | 1071.35 | 1065.78 | 1067.71 | 170213.0 |
| 2009-12-07 15:00:00 | ES | Futures | 1067.71 | 1069.17 | 1066.26 | 1066.99 | 88699.0 |
| 2009-12-07 15:30:00 | ES | Futures | 1066.99 | 1070.38 | 1066.99 | 1068.44 | 129324.0 |
| 2009-12-07 16:00:00 | ES | Futures | 1068.68 | 1069.65 | 1068.2 | 1069.41 | 69227.0 |
| 2009-12-07 16:30:00 | ES | Futures | 1070.38 | 1071.59 | 1070.38 | 1071.1 | 8053.0 |
| 2009-12-07 17:00:00 | ES | Futures | 1071.35 | 1072.32 | 1071.1 | 1071.83 | 4501.0 |
| 2009-12-07 18:00:00 | ES | Futures | 1071.59 | 1072.07 | 1071.35 | 1071.83 | 1055.0 |
| 2009-12-07 18:30:00 | ES | Futures | 1071.83 | 1072.07 | 1071.1 | 1071.1 | 1164.0 |
| 2009-12-07 19:00:00 | ES | Futures | 1071.1 | 1071.59 | 1071.1 | 1071.59 | 1758.0 |
| 2009-12-07 19:30:00 | ES | Futures | 1071.83 | 1073.04 | 1071.35 | 1072.56 | 3945.0 |
| 2009-12-07 20:00:00 | ES | Futures | 1072.56 | 1072.56 | 1072.07 | 1072.32 | 402.0 |
| 2009-12-07 20:30:00 | ES | Futures | 1072.32 | 1072.8 | 1072.07 | 1072.07 | 1017.0 |
| 2009-12-07 21:00:00 | ES | Futures | 1072.07 | 1072.32 | 1070.86 | 1070.86 | 1808.0 |
| 2009-12-07 21:30:00 | ES | Futures | 1070.86 | 1071.1 | 1070.14 | 1071.1 | 1973.0 |
| 2009-12-07 22:00:00 | ES | Futures | 1071.1 | 1071.35 | 1070.62 | 1070.86 | 700.0 |
| 2009-12-07 22:30:00 | ES | Futures | 1070.86 | 1071.35 | 1070.38 | 1070.86 | 1467.0 |
| 2009-12-07 23:00:00 | ES | Futures | 1070.86 | 1071.35 | 1070.86 | 1071.35 | 883.0 |
| 2009-12-07 23:30:00 | ES | Futures | 1071.35 | 1071.35 | 1070.62 | 1070.86 | 970.0 |
| 2009-12-07 00:00:00 | NQ | Futures | 2045.41 | 2047.41 | 2045.41 | 2047.12 | 55.0 |
| 2009-12-07 00:30:00 | NQ | Futures | 2046.84 | 2046.84 | 2042.56 | 2043.13 | 183.0 |
| 2009-12-07 01:00:00 | NQ | Futures | 2043.42 | 2044.56 | 2042.85 | 2043.99 | 47.0 |
> showing 50 of 2,465 rows — these rows as CSV