PREVIEW / futures_30min / 2009-12-02
file: by_date/futures_30min/2009/2009-12-02.parquet size: 67 KB rows: 2,463
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-02 00:00:00 | ES | Futures | 1073.77 | 1074.01 | 1073.04 | 1074.01 | 722.0 |
| 2009-12-02 00:30:00 | ES | Futures | 1073.77 | 1074.5 | 1073.53 | 1074.25 | 1421.0 |
| 2009-12-02 01:00:00 | ES | Futures | 1074.25 | 1074.25 | 1073.77 | 1074.01 | 796.0 |
| 2009-12-02 01:30:00 | ES | Futures | 1074.01 | 1074.5 | 1073.77 | 1074.25 | 794.0 |
| 2009-12-02 02:00:00 | ES | Futures | 1074.25 | 1074.5 | 1072.56 | 1073.04 | 4275.0 |
| 2009-12-02 02:30:00 | ES | Futures | 1073.28 | 1074.01 | 1072.32 | 1073.53 | 5325.0 |
| 2009-12-02 03:00:00 | ES | Futures | 1073.53 | 1076.43 | 1072.56 | 1076.43 | 15863.0 |
| 2009-12-02 03:30:00 | ES | Futures | 1076.43 | 1076.43 | 1072.8 | 1073.53 | 11899.0 |
| 2009-12-02 04:00:00 | ES | Futures | 1073.28 | 1074.01 | 1071.59 | 1072.56 | 11684.0 |
| 2009-12-02 04:30:00 | ES | Futures | 1072.56 | 1074.25 | 1072.32 | 1074.01 | 5860.0 |
| 2009-12-02 05:00:00 | ES | Futures | 1074.01 | 1075.22 | 1073.04 | 1074.74 | 6671.0 |
| 2009-12-02 05:30:00 | ES | Futures | 1074.74 | 1074.74 | 1073.04 | 1074.01 | 3724.0 |
| 2009-12-02 06:00:00 | ES | Futures | 1073.77 | 1074.25 | 1070.86 | 1071.59 | 12209.0 |
| 2009-12-02 06:30:00 | ES | Futures | 1071.59 | 1073.28 | 1071.1 | 1072.56 | 6730.0 |
| 2009-12-02 07:00:00 | ES | Futures | 1072.8 | 1074.74 | 1072.07 | 1073.53 | 7841.0 |
| 2009-12-02 07:30:00 | ES | Futures | 1073.53 | 1074.98 | 1073.04 | 1074.74 | 10903.0 |
| 2009-12-02 08:00:00 | ES | Futures | 1074.74 | 1076.43 | 1072.32 | 1073.77 | 40009.0 |
| 2009-12-02 08:30:00 | ES | Futures | 1073.77 | 1074.74 | 1072.56 | 1073.04 | 16474.0 |
| 2009-12-02 09:00:00 | ES | Futures | 1073.04 | 1073.77 | 1072.32 | 1073.77 | 16214.0 |
| 2009-12-02 09:30:00 | ES | Futures | 1073.77 | 1076.43 | 1072.8 | 1074.74 | 184148.0 |
| 2009-12-02 10:00:00 | ES | Futures | 1074.98 | 1080.79 | 1074.74 | 1079.1 | 221685.0 |
| 2009-12-02 10:30:00 | ES | Futures | 1079.1 | 1079.1 | 1077.4 | 1077.89 | 129980.0 |
| 2009-12-02 11:00:00 | ES | Futures | 1077.89 | 1078.13 | 1072.8 | 1074.01 | 166165.0 |
| 2009-12-02 11:30:00 | ES | Futures | 1074.01 | 1075.46 | 1073.77 | 1074.25 | 61913.0 |
| 2009-12-02 12:00:00 | ES | Futures | 1074.25 | 1074.98 | 1069.89 | 1071.35 | 109813.0 |
| 2009-12-02 12:30:00 | ES | Futures | 1071.1 | 1072.56 | 1070.86 | 1072.56 | 44468.0 |
| 2009-12-02 13:00:00 | ES | Futures | 1072.32 | 1073.04 | 1071.35 | 1072.07 | 42463.0 |
| 2009-12-02 13:30:00 | ES | Futures | 1072.32 | 1073.53 | 1071.59 | 1072.8 | 41652.0 |
| 2009-12-02 14:00:00 | ES | Futures | 1073.04 | 1074.25 | 1070.62 | 1072.56 | 109091.0 |
| 2009-12-02 14:30:00 | ES | Futures | 1072.56 | 1073.77 | 1071.83 | 1072.56 | 62477.0 |
| 2009-12-02 15:00:00 | ES | Futures | 1072.32 | 1073.28 | 1071.59 | 1073.04 | 59894.0 |
| 2009-12-02 15:30:00 | ES | Futures | 1072.8 | 1075.22 | 1071.83 | 1073.53 | 161600.0 |
| 2009-12-02 16:00:00 | ES | Futures | 1073.77 | 1074.01 | 1073.04 | 1073.28 | 59447.0 |
| 2009-12-02 16:30:00 | ES | Futures | 1073.28 | 1073.77 | 1073.04 | 1073.28 | 3066.0 |
| 2009-12-02 17:00:00 | ES | Futures | 1073.28 | 1074.25 | 1071.59 | 1073.28 | 7385.0 |
| 2009-12-02 18:00:00 | ES | Futures | 1074.25 | 1075.95 | 1074.25 | 1075.22 | 7128.0 |
| 2009-12-02 18:30:00 | ES | Futures | 1074.98 | 1076.92 | 1074.98 | 1076.19 | 5457.0 |
| 2009-12-02 19:00:00 | ES | Futures | 1076.19 | 1076.43 | 1074.5 | 1074.98 | 6729.0 |
| 2009-12-02 19:30:00 | ES | Futures | 1074.98 | 1075.71 | 1074.74 | 1075.46 | 2043.0 |
| 2009-12-02 20:00:00 | ES | Futures | 1075.71 | 1076.43 | 1075.22 | 1076.19 | 3592.0 |
| 2009-12-02 20:30:00 | ES | Futures | 1076.19 | 1076.19 | 1075.22 | 1075.46 | 1839.0 |
| 2009-12-02 21:00:00 | ES | Futures | 1075.71 | 1075.71 | 1074.98 | 1074.98 | 1156.0 |
| 2009-12-02 21:30:00 | ES | Futures | 1075.22 | 1076.68 | 1074.98 | 1076.43 | 4598.0 |
| 2009-12-02 22:00:00 | ES | Futures | 1076.68 | 1076.92 | 1075.95 | 1076.43 | 1902.0 |
| 2009-12-02 22:30:00 | ES | Futures | 1076.43 | 1076.92 | 1076.43 | 1076.43 | 2147.0 |
| 2009-12-02 23:00:00 | ES | Futures | 1076.68 | 1076.68 | 1075.71 | 1076.68 | 1497.0 |
| 2009-12-02 23:30:00 | ES | Futures | 1076.68 | 1078.13 | 1076.68 | 1077.89 | 4798.0 |
| 2009-12-02 00:00:00 | NQ | Futures | 2041.99 | 2042.85 | 2041.7 | 2042.85 | 42.0 |
| 2009-12-02 00:30:00 | NQ | Futures | 2042.56 | 2043.42 | 2042.28 | 2043.42 | 36.0 |
| 2009-12-02 01:00:00 | NQ | Futures | 2043.13 | 2043.42 | 2042.85 | 2043.13 | 113.0 |
> showing 50 of 2,463 rows — these rows as CSV