PREVIEW / futures_1hour / 2010-10-08
file: by_date/futures_1hour/2010/2010-10-08.parquet size: 39 KB rows: 1,122
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-10-08 00:00:00 | ES | Futures | 1141.94 | 1142.43 | 1140.95 | 1141.94 | 2408.0 |
| 2010-10-08 01:00:00 | ES | Futures | 1141.94 | 1141.94 | 1140.21 | 1140.46 | 3220.0 |
| 2010-10-08 02:00:00 | ES | Futures | 1140.7 | 1140.95 | 1138.24 | 1138.24 | 10457.0 |
| 2010-10-08 03:00:00 | ES | Futures | 1138.49 | 1139.72 | 1137.25 | 1138.49 | 25164.0 |
| 2010-10-08 04:00:00 | ES | Futures | 1138.24 | 1139.47 | 1136.02 | 1136.51 | 20508.0 |
| 2010-10-08 05:00:00 | ES | Futures | 1136.51 | 1137.99 | 1136.02 | 1137.25 | 10475.0 |
| 2010-10-08 06:00:00 | ES | Futures | 1137.25 | 1137.75 | 1134.79 | 1135.53 | 27850.0 |
| 2010-10-08 07:00:00 | ES | Futures | 1135.28 | 1136.27 | 1134.3 | 1135.53 | 32321.0 |
| 2010-10-08 08:00:00 | ES | Futures | 1135.28 | 1142.43 | 1129.37 | 1136.02 | 252756.0 |
| 2010-10-08 09:00:00 | ES | Futures | 1136.27 | 1141.2 | 1134.3 | 1139.72 | 261790.0 |
| 2010-10-08 10:00:00 | ES | Futures | 1139.72 | 1140.95 | 1135.28 | 1139.96 | 286068.0 |
| 2010-10-08 11:00:00 | ES | Futures | 1140.21 | 1145.14 | 1139.96 | 1143.91 | 257789.0 |
| 2010-10-08 12:00:00 | ES | Futures | 1143.91 | 1146.13 | 1142.43 | 1145.39 | 120723.0 |
| 2010-10-08 13:00:00 | ES | Futures | 1145.39 | 1145.63 | 1141.94 | 1142.92 | 117911.0 |
| 2010-10-08 14:00:00 | ES | Futures | 1142.92 | 1145.39 | 1141.2 | 1143.66 | 132155.0 |
| 2010-10-08 15:00:00 | ES | Futures | 1143.66 | 1147.61 | 1143.42 | 1144.4 | 258173.0 |
| 2010-10-08 16:00:00 | ES | Futures | 1144.4 | 1145.39 | 1143.66 | 1144.15 | 113658.0 |
| 2010-10-08 00:00:00 | NQ | Futures | 2316.16 | 2316.45 | 2314.44 | 2315.3 | 189.0 |
| 2010-10-08 01:00:00 | NQ | Futures | 2315.02 | 2315.02 | 2311.0 | 2311.29 | 212.0 |
| 2010-10-08 02:00:00 | NQ | Futures | 2311.0 | 2311.57 | 2305.84 | 2306.41 | 609.0 |
| 2010-10-08 03:00:00 | NQ | Futures | 2306.12 | 2309.85 | 2304.4 | 2307.56 | 1525.0 |
| 2010-10-08 04:00:00 | NQ | Futures | 2307.56 | 2308.99 | 2300.67 | 2301.53 | 1926.0 |
| 2010-10-08 05:00:00 | NQ | Futures | 2301.82 | 2304.97 | 2301.53 | 2303.83 | 607.0 |
| 2010-10-08 06:00:00 | NQ | Futures | 2303.83 | 2304.69 | 2301.24 | 2302.68 | 1898.0 |
| 2010-10-08 07:00:00 | NQ | Futures | 2302.68 | 2304.11 | 2300.1 | 2302.11 | 1701.0 |
| 2010-10-08 08:00:00 | NQ | Futures | 2302.39 | 2317.02 | 2274.56 | 2300.38 | 29798.0 |
| 2010-10-08 09:00:00 | NQ | Futures | 2300.67 | 2311.29 | 2297.23 | 2307.56 | 41066.0 |
| 2010-10-08 10:00:00 | NQ | Futures | 2306.98 | 2308.42 | 2291.78 | 2302.97 | 57399.0 |
| 2010-10-08 11:00:00 | NQ | Futures | 2303.25 | 2324.48 | 2302.97 | 2322.19 | 58835.0 |
| 2010-10-08 12:00:00 | NQ | Futures | 2321.9 | 2328.79 | 2315.88 | 2324.2 | 30474.0 |
| 2010-10-08 13:00:00 | NQ | Futures | 2324.48 | 2325.63 | 2316.45 | 2318.75 | 17937.0 |
| 2010-10-08 14:00:00 | NQ | Futures | 2318.75 | 2324.48 | 2314.44 | 2321.62 | 21482.0 |
| 2010-10-08 15:00:00 | NQ | Futures | 2321.62 | 2328.79 | 2321.62 | 2322.48 | 34674.0 |
| 2010-10-08 16:00:00 | NQ | Futures | 2322.76 | 2325.63 | 2319.03 | 2320.47 | 10962.0 |
| 2010-10-08 00:00:00 | YM | Futures | 10405.8 | 10408.7 | 10400.1 | 10403.9 | 76.0 |
| 2010-10-08 01:00:00 | YM | Futures | 10404.9 | 10406.8 | 10393.4 | 10393.4 | 177.0 |
| 2010-10-08 02:00:00 | YM | Futures | 10394.4 | 10394.4 | 10374.4 | 10375.3 | 503.0 |
| 2010-10-08 03:00:00 | YM | Futures | 10374.4 | 10386.8 | 10365.8 | 10378.2 | 1192.0 |
| 2010-10-08 04:00:00 | YM | Futures | 10378.2 | 10384.9 | 10356.3 | 10362.0 | 891.0 |
| 2010-10-08 05:00:00 | YM | Futures | 10360.1 | 10371.5 | 10357.2 | 10366.8 | 361.0 |
| 2010-10-08 06:00:00 | YM | Futures | 10367.7 | 10370.6 | 10348.7 | 10354.4 | 954.0 |
| 2010-10-08 07:00:00 | YM | Futures | 10354.4 | 10364.9 | 10345.8 | 10356.3 | 750.0 |
| 2010-10-08 08:00:00 | YM | Futures | 10356.3 | 10406.8 | 10297.2 | 10356.3 | 12427.0 |
| 2010-10-08 09:00:00 | YM | Futures | 10355.3 | 10408.7 | 10342.0 | 10394.4 | 21341.0 |
| 2010-10-08 10:00:00 | YM | Futures | 10393.4 | 10401.1 | 10354.4 | 10396.3 | 22190.0 |
| 2010-10-08 11:00:00 | YM | Futures | 10397.2 | 10441.1 | 10397.2 | 10429.6 | 18565.0 |
| 2010-10-08 12:00:00 | YM | Futures | 10430.6 | 10446.8 | 10418.2 | 10440.1 | 8731.0 |
| 2010-10-08 13:00:00 | YM | Futures | 10440.1 | 10442.0 | 10413.4 | 10421.1 | 8472.0 |
| 2010-10-08 14:00:00 | YM | Futures | 10422.0 | 10436.3 | 10409.6 | 10423.9 | 8772.0 |
| 2010-10-08 15:00:00 | YM | Futures | 10423.9 | 10453.4 | 10423.0 | 10426.8 | 19395.0 |
> showing 50 of 1,122 rows — these rows as CSV