PREVIEW / futures_30min / 2010-02-08
file: by_date/futures_30min/2010/2010-02-08.parquet size: 70 KB rows: 2,548
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-08 00:00:00 | ES | Futures | 1031.66 | 1032.39 | 1030.69 | 1031.17 | 2376.0 |
| 2010-02-08 00:30:00 | ES | Futures | 1031.17 | 1031.42 | 1030.44 | 1030.93 | 1767.0 |
| 2010-02-08 01:00:00 | ES | Futures | 1030.69 | 1031.17 | 1029.47 | 1030.2 | 3242.0 |
| 2010-02-08 01:30:00 | ES | Futures | 1030.2 | 1030.44 | 1028.98 | 1029.47 | 3417.0 |
| 2010-02-08 02:00:00 | ES | Futures | 1029.23 | 1032.88 | 1028.74 | 1032.15 | 8231.0 |
| 2010-02-08 02:30:00 | ES | Futures | 1032.39 | 1034.58 | 1031.9 | 1032.63 | 9193.0 |
| 2010-02-08 03:00:00 | ES | Futures | 1032.88 | 1035.8 | 1031.9 | 1035.8 | 19705.0 |
| 2010-02-08 03:30:00 | ES | Futures | 1035.55 | 1037.99 | 1035.55 | 1036.53 | 19572.0 |
| 2010-02-08 04:00:00 | ES | Futures | 1036.53 | 1037.26 | 1035.07 | 1036.04 | 11763.0 |
| 2010-02-08 04:30:00 | ES | Futures | 1036.04 | 1037.01 | 1033.61 | 1035.07 | 13735.0 |
| 2010-02-08 05:00:00 | ES | Futures | 1035.07 | 1035.55 | 1032.63 | 1035.07 | 9786.0 |
| 2010-02-08 05:30:00 | ES | Futures | 1035.07 | 1035.55 | 1030.69 | 1031.42 | 16845.0 |
| 2010-02-08 06:00:00 | ES | Futures | 1031.42 | 1032.88 | 1029.96 | 1032.39 | 14783.0 |
| 2010-02-08 06:30:00 | ES | Futures | 1032.39 | 1032.39 | 1029.96 | 1030.44 | 8068.0 |
| 2010-02-08 07:00:00 | ES | Futures | 1030.2 | 1031.17 | 1028.74 | 1028.74 | 20377.0 |
| 2010-02-08 07:30:00 | ES | Futures | 1028.74 | 1034.09 | 1027.53 | 1033.12 | 37696.0 |
| 2010-02-08 08:00:00 | ES | Futures | 1033.36 | 1034.58 | 1032.63 | 1032.88 | 26539.0 |
| 2010-02-08 08:30:00 | ES | Futures | 1032.88 | 1034.09 | 1031.42 | 1033.61 | 25731.0 |
| 2010-02-08 09:00:00 | ES | Futures | 1033.61 | 1035.55 | 1033.12 | 1033.85 | 36237.0 |
| 2010-02-08 09:30:00 | ES | Futures | 1033.85 | 1034.09 | 1027.53 | 1031.17 | 251699.0 |
| 2010-02-08 10:00:00 | ES | Futures | 1031.17 | 1035.55 | 1030.2 | 1033.61 | 171064.0 |
| 2010-02-08 10:30:00 | ES | Futures | 1033.61 | 1036.53 | 1031.9 | 1036.53 | 136868.0 |
| 2010-02-08 11:00:00 | ES | Futures | 1036.53 | 1039.69 | 1036.28 | 1037.26 | 130608.0 |
| 2010-02-08 11:30:00 | ES | Futures | 1037.26 | 1039.2 | 1036.28 | 1037.01 | 85585.0 |
| 2010-02-08 12:00:00 | ES | Futures | 1037.26 | 1037.99 | 1035.07 | 1037.99 | 75262.0 |
| 2010-02-08 12:30:00 | ES | Futures | 1037.99 | 1038.23 | 1036.28 | 1036.77 | 41515.0 |
| 2010-02-08 13:00:00 | ES | Futures | 1036.77 | 1037.01 | 1031.66 | 1033.36 | 99017.0 |
| 2010-02-08 13:30:00 | ES | Futures | 1033.12 | 1033.85 | 1030.93 | 1032.15 | 73573.0 |
| 2010-02-08 14:00:00 | ES | Futures | 1032.39 | 1035.07 | 1032.15 | 1033.36 | 66420.0 |
| 2010-02-08 14:30:00 | ES | Futures | 1033.36 | 1034.09 | 1030.93 | 1031.66 | 83362.0 |
| 2010-02-08 15:00:00 | ES | Futures | 1031.9 | 1032.39 | 1027.77 | 1029.96 | 140348.0 |
| 2010-02-08 15:30:00 | ES | Futures | 1029.96 | 1031.17 | 1024.61 | 1025.58 | 254756.0 |
| 2010-02-08 16:00:00 | ES | Futures | 1025.58 | 1027.77 | 1025.34 | 1027.53 | 110666.0 |
| 2010-02-08 16:30:00 | ES | Futures | 1027.04 | 1027.53 | 1026.07 | 1026.55 | 7164.0 |
| 2010-02-08 17:00:00 | ES | Futures | 1026.55 | 1026.8 | 1025.58 | 1026.07 | 2522.0 |
| 2010-02-08 18:00:00 | ES | Futures | 1026.31 | 1028.01 | 1025.82 | 1026.55 | 3423.0 |
| 2010-02-08 18:30:00 | ES | Futures | 1026.55 | 1027.53 | 1025.82 | 1027.04 | 1916.0 |
| 2010-02-08 19:00:00 | ES | Futures | 1027.04 | 1028.74 | 1026.55 | 1028.25 | 4093.0 |
| 2010-02-08 19:30:00 | ES | Futures | 1028.5 | 1028.74 | 1026.07 | 1027.28 | 2834.0 |
| 2010-02-08 20:00:00 | ES | Futures | 1027.28 | 1027.77 | 1026.07 | 1026.8 | 2156.0 |
| 2010-02-08 20:30:00 | ES | Futures | 1027.04 | 1028.74 | 1026.55 | 1028.5 | 2608.0 |
| 2010-02-08 21:00:00 | ES | Futures | 1028.5 | 1029.23 | 1028.25 | 1028.5 | 2887.0 |
| 2010-02-08 21:30:00 | ES | Futures | 1028.5 | 1028.5 | 1027.77 | 1028.01 | 1657.0 |
| 2010-02-08 22:00:00 | ES | Futures | 1028.01 | 1028.25 | 1027.28 | 1027.77 | 1480.0 |
| 2010-02-08 22:30:00 | ES | Futures | 1027.53 | 1028.25 | 1027.04 | 1028.01 | 1270.0 |
| 2010-02-08 23:00:00 | ES | Futures | 1028.25 | 1028.98 | 1027.77 | 1028.01 | 1668.0 |
| 2010-02-08 23:30:00 | ES | Futures | 1028.25 | 1029.23 | 1027.77 | 1029.23 | 1555.0 |
| 2010-02-08 00:00:00 | NQ | Futures | 1994.26 | 1995.12 | 1993.12 | 1993.69 | 112.0 |
| 2010-02-08 00:30:00 | NQ | Futures | 1993.41 | 1993.69 | 1992.26 | 1992.83 | 86.0 |
| 2010-02-08 01:00:00 | NQ | Futures | 1992.83 | 1993.41 | 1991.41 | 1992.55 | 85.0 |
> showing 50 of 2,548 rows — these rows as CSV