PREVIEW / futures_30min / 2010-06-08
file: by_date/futures_30min/2010/2010-06-08.parquet size: 70 KB rows: 2,502
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-06-08 00:00:00 | ES | Futures | 1032.7 | 1032.95 | 1031.72 | 1032.21 | 1550.0 |
| 2010-06-08 00:30:00 | ES | Futures | 1032.21 | 1032.21 | 1030.5 | 1030.75 | 2399.0 |
| 2010-06-08 01:00:00 | ES | Futures | 1030.75 | 1031.72 | 1030.5 | 1031.72 | 2501.0 |
| 2010-06-08 01:30:00 | ES | Futures | 1031.72 | 1034.41 | 1031.72 | 1034.17 | 4846.0 |
| 2010-06-08 02:00:00 | ES | Futures | 1033.92 | 1035.88 | 1033.68 | 1034.41 | 11564.0 |
| 2010-06-08 02:30:00 | ES | Futures | 1034.41 | 1037.35 | 1034.17 | 1036.12 | 10878.0 |
| 2010-06-08 03:00:00 | ES | Futures | 1036.12 | 1036.86 | 1031.72 | 1032.95 | 29174.0 |
| 2010-06-08 03:30:00 | ES | Futures | 1032.95 | 1034.9 | 1032.21 | 1032.7 | 15366.0 |
| 2010-06-08 04:00:00 | ES | Futures | 1032.95 | 1033.92 | 1030.01 | 1030.26 | 19640.0 |
| 2010-06-08 04:30:00 | ES | Futures | 1030.26 | 1030.5 | 1024.88 | 1025.12 | 38002.0 |
| 2010-06-08 05:00:00 | ES | Futures | 1024.88 | 1026.1 | 1022.19 | 1024.88 | 38783.0 |
| 2010-06-08 05:30:00 | ES | Futures | 1024.63 | 1024.88 | 1022.44 | 1022.92 | 17066.0 |
| 2010-06-08 06:00:00 | ES | Futures | 1023.17 | 1027.08 | 1022.92 | 1026.83 | 16086.0 |
| 2010-06-08 06:30:00 | ES | Futures | 1027.08 | 1028.3 | 1024.39 | 1025.61 | 16370.0 |
| 2010-06-08 07:00:00 | ES | Futures | 1025.61 | 1029.03 | 1025.12 | 1028.3 | 18699.0 |
| 2010-06-08 07:30:00 | ES | Futures | 1028.06 | 1029.28 | 1027.08 | 1027.81 | 15921.0 |
| 2010-06-08 08:00:00 | ES | Futures | 1027.81 | 1031.23 | 1027.81 | 1030.26 | 27048.0 |
| 2010-06-08 08:30:00 | ES | Futures | 1030.01 | 1030.99 | 1027.57 | 1028.79 | 42153.0 |
| 2010-06-08 09:00:00 | ES | Futures | 1028.79 | 1030.26 | 1026.83 | 1026.83 | 29936.0 |
| 2010-06-08 09:30:00 | ES | Futures | 1026.83 | 1032.46 | 1023.17 | 1024.88 | 298547.0 |
| 2010-06-08 10:00:00 | ES | Futures | 1024.63 | 1030.26 | 1022.44 | 1026.35 | 273923.0 |
| 2010-06-08 10:30:00 | ES | Futures | 1026.1 | 1027.08 | 1018.28 | 1023.9 | 294149.0 |
| 2010-06-08 11:00:00 | ES | Futures | 1023.9 | 1029.28 | 1018.04 | 1026.35 | 325028.0 |
| 2010-06-08 11:30:00 | ES | Futures | 1026.35 | 1034.41 | 1026.1 | 1031.97 | 236065.0 |
| 2010-06-08 12:00:00 | ES | Futures | 1031.97 | 1033.43 | 1027.57 | 1028.3 | 120592.0 |
| 2010-06-08 12:30:00 | ES | Futures | 1028.55 | 1032.46 | 1028.06 | 1031.72 | 96581.0 |
| 2010-06-08 13:00:00 | ES | Futures | 1031.72 | 1032.7 | 1026.35 | 1027.08 | 98056.0 |
| 2010-06-08 13:30:00 | ES | Futures | 1027.08 | 1027.81 | 1019.75 | 1023.66 | 168764.0 |
| 2010-06-08 14:00:00 | ES | Futures | 1023.9 | 1030.26 | 1021.21 | 1028.06 | 163443.0 |
| 2010-06-08 14:30:00 | ES | Futures | 1028.3 | 1032.95 | 1026.83 | 1027.57 | 182802.0 |
| 2010-06-08 15:00:00 | ES | Futures | 1027.57 | 1033.19 | 1025.12 | 1033.19 | 178335.0 |
| 2010-06-08 15:30:00 | ES | Futures | 1033.19 | 1039.54 | 1032.21 | 1036.86 | 346300.0 |
| 2010-06-08 16:00:00 | ES | Futures | 1036.86 | 1037.1 | 1034.9 | 1035.63 | 106262.0 |
| 2010-06-08 16:30:00 | ES | Futures | 1035.39 | 1036.86 | 1034.66 | 1036.61 | 8917.0 |
| 2010-06-08 17:00:00 | ES | Futures | 1036.61 | 1037.1 | 1036.12 | 1036.86 | 2744.0 |
| 2010-06-08 18:00:00 | ES | Futures | 1036.86 | 1036.86 | 1035.39 | 1036.61 | 2503.0 |
| 2010-06-08 18:30:00 | ES | Futures | 1036.61 | 1037.1 | 1036.12 | 1036.86 | 1943.0 |
| 2010-06-08 19:00:00 | ES | Futures | 1036.86 | 1037.59 | 1036.12 | 1037.1 | 1365.0 |
| 2010-06-08 19:30:00 | ES | Futures | 1037.1 | 1037.35 | 1034.9 | 1035.15 | 2789.0 |
| 2010-06-08 20:00:00 | ES | Futures | 1035.15 | 1035.39 | 1030.5 | 1030.99 | 8675.0 |
| 2010-06-08 20:30:00 | ES | Futures | 1031.23 | 1032.95 | 1028.79 | 1031.23 | 7238.0 |
| 2010-06-08 21:00:00 | ES | Futures | 1031.23 | 1032.46 | 1029.52 | 1032.21 | 3991.0 |
| 2010-06-08 21:30:00 | ES | Futures | 1031.97 | 1033.92 | 1031.97 | 1033.19 | 4439.0 |
| 2010-06-08 22:00:00 | ES | Futures | 1033.19 | 1033.43 | 1030.99 | 1031.72 | 3129.0 |
| 2010-06-08 22:30:00 | ES | Futures | 1031.72 | 1032.21 | 1030.99 | 1032.21 | 3238.0 |
| 2010-06-08 23:00:00 | ES | Futures | 1031.97 | 1032.95 | 1031.72 | 1031.97 | 1842.0 |
| 2010-06-08 23:30:00 | ES | Futures | 1031.97 | 1032.46 | 1031.48 | 1031.97 | 2024.0 |
| 2010-06-08 00:00:00 | NQ | Futures | 2072.76 | 2073.34 | 2071.33 | 2071.33 | 132.0 |
| 2010-06-08 00:30:00 | NQ | Futures | 2070.76 | 2070.76 | 2068.76 | 2069.04 | 133.0 |
| 2010-06-08 01:00:00 | NQ | Futures | 2069.33 | 2071.91 | 2069.04 | 2071.91 | 122.0 |
> showing 50 of 2,502 rows — these rows as CSV