PREVIEW / futures_30min / 2010-06-03
file: by_date/futures_30min/2010/2010-06-03.parquet size: 70 KB rows: 2,496
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-03 00:00:00 | ES | Futures | 1075.72 | 1076.45 | 1074.25 | 1076.45 | 1872.0 |
| 2010-06-03 00:30:00 | ES | Futures | 1076.21 | 1077.43 | 1076.21 | 1077.19 | 2820.0 |
| 2010-06-03 01:00:00 | ES | Futures | 1077.19 | 1079.14 | 1076.7 | 1078.9 | 2988.0 |
| 2010-06-03 01:30:00 | ES | Futures | 1078.9 | 1080.12 | 1078.41 | 1078.9 | 6131.0 |
| 2010-06-03 02:00:00 | ES | Futures | 1078.65 | 1079.63 | 1077.43 | 1077.68 | 7809.0 |
| 2010-06-03 02:30:00 | ES | Futures | 1077.68 | 1078.41 | 1076.21 | 1076.94 | 9352.0 |
| 2010-06-03 03:00:00 | ES | Futures | 1076.7 | 1079.39 | 1075.96 | 1078.16 | 20678.0 |
| 2010-06-03 03:30:00 | ES | Futures | 1077.92 | 1078.41 | 1076.94 | 1077.92 | 11749.0 |
| 2010-06-03 04:00:00 | ES | Futures | 1077.92 | 1079.88 | 1077.43 | 1079.14 | 9584.0 |
| 2010-06-03 04:30:00 | ES | Futures | 1078.9 | 1080.12 | 1078.16 | 1079.14 | 9023.0 |
| 2010-06-03 05:00:00 | ES | Futures | 1079.39 | 1079.88 | 1076.45 | 1078.41 | 8466.0 |
| 2010-06-03 05:30:00 | ES | Futures | 1078.41 | 1079.14 | 1078.16 | 1078.41 | 6342.0 |
| 2010-06-03 06:00:00 | ES | Futures | 1078.41 | 1078.41 | 1075.72 | 1076.7 | 11824.0 |
| 2010-06-03 06:30:00 | ES | Futures | 1076.7 | 1077.68 | 1074.5 | 1074.74 | 13364.0 |
| 2010-06-03 07:00:00 | ES | Futures | 1074.99 | 1077.19 | 1074.5 | 1075.23 | 12130.0 |
| 2010-06-03 07:30:00 | ES | Futures | 1075.23 | 1077.19 | 1074.74 | 1076.21 | 14705.0 |
| 2010-06-03 08:00:00 | ES | Futures | 1076.21 | 1077.43 | 1074.25 | 1076.94 | 31214.0 |
| 2010-06-03 08:30:00 | ES | Futures | 1076.7 | 1078.41 | 1075.72 | 1077.43 | 34632.0 |
| 2010-06-03 09:00:00 | ES | Futures | 1077.19 | 1077.92 | 1075.96 | 1076.7 | 26539.0 |
| 2010-06-03 09:30:00 | ES | Futures | 1076.94 | 1080.61 | 1074.74 | 1080.61 | 215770.0 |
| 2010-06-03 10:00:00 | ES | Futures | 1080.36 | 1080.36 | 1073.76 | 1074.01 | 194157.0 |
| 2010-06-03 10:30:00 | ES | Futures | 1074.01 | 1076.94 | 1072.05 | 1076.21 | 165853.0 |
| 2010-06-03 11:00:00 | ES | Futures | 1076.45 | 1078.41 | 1073.52 | 1074.25 | 104241.0 |
| 2010-06-03 11:30:00 | ES | Futures | 1074.01 | 1076.45 | 1073.52 | 1074.99 | 85084.0 |
| 2010-06-03 12:00:00 | ES | Futures | 1074.74 | 1075.23 | 1066.43 | 1068.39 | 157698.0 |
| 2010-06-03 12:30:00 | ES | Futures | 1068.14 | 1070.83 | 1066.92 | 1069.36 | 89190.0 |
| 2010-06-03 13:00:00 | ES | Futures | 1069.61 | 1071.08 | 1067.9 | 1069.12 | 55941.0 |
| 2010-06-03 13:30:00 | ES | Futures | 1068.88 | 1073.03 | 1068.39 | 1070.83 | 80053.0 |
| 2010-06-03 14:00:00 | ES | Futures | 1071.08 | 1075.23 | 1069.85 | 1072.79 | 108508.0 |
| 2010-06-03 14:30:00 | ES | Futures | 1073.03 | 1077.19 | 1072.54 | 1075.96 | 93862.0 |
| 2010-06-03 15:00:00 | ES | Futures | 1075.96 | 1078.41 | 1072.79 | 1078.16 | 106718.0 |
| 2010-06-03 15:30:00 | ES | Futures | 1078.41 | 1078.9 | 1074.5 | 1077.43 | 147794.0 |
| 2010-06-03 16:00:00 | ES | Futures | 1077.19 | 1079.63 | 1076.45 | 1079.63 | 70755.0 |
| 2010-06-03 16:30:00 | ES | Futures | 1079.39 | 1079.63 | 1076.7 | 1077.43 | 11228.0 |
| 2010-06-03 17:00:00 | ES | Futures | 1077.68 | 1077.92 | 1075.48 | 1076.7 | 4378.0 |
| 2010-06-03 18:00:00 | ES | Futures | 1076.94 | 1077.43 | 1075.96 | 1076.7 | 1501.0 |
| 2010-06-03 18:30:00 | ES | Futures | 1076.7 | 1077.43 | 1076.45 | 1076.7 | 819.0 |
| 2010-06-03 19:00:00 | ES | Futures | 1076.94 | 1077.43 | 1076.45 | 1077.19 | 851.0 |
| 2010-06-03 19:30:00 | ES | Futures | 1077.19 | 1077.92 | 1076.7 | 1077.43 | 1446.0 |
| 2010-06-03 20:00:00 | ES | Futures | 1077.43 | 1079.14 | 1076.7 | 1077.19 | 4142.0 |
| 2010-06-03 20:30:00 | ES | Futures | 1077.19 | 1079.39 | 1077.19 | 1078.65 | 3288.0 |
| 2010-06-03 21:00:00 | ES | Futures | 1078.65 | 1079.14 | 1078.41 | 1078.41 | 1029.0 |
| 2010-06-03 21:30:00 | ES | Futures | 1078.65 | 1079.14 | 1077.92 | 1078.41 | 1572.0 |
| 2010-06-03 22:00:00 | ES | Futures | 1078.65 | 1078.9 | 1075.72 | 1076.45 | 5164.0 |
| 2010-06-03 22:30:00 | ES | Futures | 1076.45 | 1077.43 | 1076.21 | 1077.19 | 1631.0 |
| 2010-06-03 23:00:00 | ES | Futures | 1077.43 | 1077.92 | 1077.19 | 1077.92 | 883.0 |
| 2010-06-03 23:30:00 | ES | Futures | 1077.92 | 1077.92 | 1076.94 | 1077.43 | 994.0 |
| 2010-06-03 00:00:00 | NQ | Futures | 2156.96 | 2157.82 | 2154.67 | 2157.82 | 238.0 |
| 2010-06-03 00:30:00 | NQ | Futures | 2158.1 | 2160.39 | 2158.1 | 2158.96 | 299.0 |
| 2010-06-03 01:00:00 | NQ | Futures | 2158.96 | 2163.54 | 2158.68 | 2163.26 | 483.0 |
> showing 50 of 2,496 rows — these rows as CSV