PREVIEW / futures_1hour / 2010-10-11
file: by_date/futures_1hour/2010/2010-10-11.parquet size: 43 KB rows: 1,346
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-11 00:00:00 | ES | Futures | 1146.13 | 1146.37 | 1145.63 | 1145.88 | 2022.0 |
| 2010-10-11 01:00:00 | ES | Futures | 1145.88 | 1145.88 | 1144.15 | 1144.4 | 3640.0 |
| 2010-10-11 02:00:00 | ES | Futures | 1144.15 | 1145.63 | 1143.91 | 1145.14 | 4431.0 |
| 2010-10-11 03:00:00 | ES | Futures | 1145.14 | 1146.87 | 1144.15 | 1145.14 | 26401.0 |
| 2010-10-11 04:00:00 | ES | Futures | 1145.39 | 1147.85 | 1144.89 | 1147.36 | 12550.0 |
| 2010-10-11 05:00:00 | ES | Futures | 1147.11 | 1147.85 | 1146.62 | 1147.36 | 10117.0 |
| 2010-10-11 06:00:00 | ES | Futures | 1147.36 | 1147.36 | 1146.13 | 1146.37 | 7210.0 |
| 2010-10-11 07:00:00 | ES | Futures | 1146.37 | 1147.36 | 1145.88 | 1147.11 | 8672.0 |
| 2010-10-11 08:00:00 | ES | Futures | 1147.11 | 1147.36 | 1145.63 | 1145.88 | 24636.0 |
| 2010-10-11 09:00:00 | ES | Futures | 1145.88 | 1147.36 | 1144.15 | 1145.14 | 142727.0 |
| 2010-10-11 10:00:00 | ES | Futures | 1144.89 | 1148.59 | 1144.15 | 1144.89 | 197895.0 |
| 2010-10-11 11:00:00 | ES | Futures | 1145.14 | 1147.61 | 1143.91 | 1146.37 | 112979.0 |
| 2010-10-11 12:00:00 | ES | Futures | 1146.62 | 1147.85 | 1145.88 | 1146.62 | 56901.0 |
| 2010-10-11 13:00:00 | ES | Futures | 1146.87 | 1147.85 | 1146.13 | 1147.61 | 39390.0 |
| 2010-10-11 14:00:00 | ES | Futures | 1147.61 | 1147.85 | 1146.13 | 1146.62 | 68016.0 |
| 2010-10-11 15:00:00 | ES | Futures | 1146.62 | 1147.11 | 1141.44 | 1145.63 | 206648.0 |
| 2010-10-11 16:00:00 | ES | Futures | 1145.63 | 1146.62 | 1145.14 | 1145.63 | 61927.0 |
| 2010-10-11 17:00:00 | ES | Futures | 1145.88 | 1146.37 | 1145.39 | 1145.63 | 774.0 |
| 2010-10-11 18:00:00 | ES | Futures | 1145.63 | 1146.37 | 1145.39 | 1146.13 | 959.0 |
| 2010-10-11 19:00:00 | ES | Futures | 1146.37 | 1146.37 | 1144.65 | 1145.88 | 2723.0 |
| 2010-10-11 20:00:00 | ES | Futures | 1146.13 | 1146.37 | 1143.66 | 1143.91 | 6931.0 |
| 2010-10-11 21:00:00 | ES | Futures | 1143.91 | 1144.15 | 1140.21 | 1140.46 | 16757.0 |
| 2010-10-11 22:00:00 | ES | Futures | 1140.46 | 1141.44 | 1140.21 | 1141.44 | 7007.0 |
| 2010-10-11 23:00:00 | ES | Futures | 1141.44 | 1141.44 | 1137.5 | 1137.5 | 14260.0 |
| 2010-10-11 00:00:00 | NQ | Futures | 2323.62 | 2324.48 | 2323.05 | 2323.05 | 70.0 |
| 2010-10-11 01:00:00 | NQ | Futures | 2322.76 | 2322.76 | 2319.32 | 2319.61 | 176.0 |
| 2010-10-11 02:00:00 | NQ | Futures | 2319.61 | 2322.19 | 2319.32 | 2321.04 | 696.0 |
| 2010-10-11 03:00:00 | NQ | Futures | 2321.33 | 2324.77 | 2320.47 | 2321.9 | 2060.0 |
| 2010-10-11 04:00:00 | NQ | Futures | 2322.19 | 2327.35 | 2321.62 | 2325.92 | 941.0 |
| 2010-10-11 05:00:00 | NQ | Futures | 2325.92 | 2327.07 | 2324.77 | 2325.92 | 370.0 |
| 2010-10-11 06:00:00 | NQ | Futures | 2325.34 | 2325.63 | 2323.05 | 2324.48 | 1061.0 |
| 2010-10-11 07:00:00 | NQ | Futures | 2324.48 | 2325.63 | 2323.05 | 2325.34 | 759.0 |
| 2010-10-11 08:00:00 | NQ | Futures | 2325.34 | 2325.34 | 2322.76 | 2323.34 | 2711.0 |
| 2010-10-11 09:00:00 | NQ | Futures | 2323.62 | 2331.66 | 2321.9 | 2325.63 | 33737.0 |
| 2010-10-11 10:00:00 | NQ | Futures | 2325.63 | 2335.39 | 2324.77 | 2327.07 | 35231.0 |
| 2010-10-11 11:00:00 | NQ | Futures | 2327.07 | 2332.52 | 2324.77 | 2329.65 | 23303.0 |
| 2010-10-11 12:00:00 | NQ | Futures | 2329.94 | 2334.24 | 2328.21 | 2331.37 | 13060.0 |
| 2010-10-11 13:00:00 | NQ | Futures | 2331.66 | 2334.53 | 2329.94 | 2333.38 | 9572.0 |
| 2010-10-11 14:00:00 | NQ | Futures | 2333.66 | 2333.95 | 2330.22 | 2330.8 | 12384.0 |
| 2010-10-11 15:00:00 | NQ | Futures | 2330.8 | 2332.23 | 2316.74 | 2323.91 | 32269.0 |
| 2010-10-11 16:00:00 | NQ | Futures | 2323.91 | 2326.49 | 2322.76 | 2323.91 | 6201.0 |
| 2010-10-11 17:00:00 | NQ | Futures | 2323.91 | 2324.48 | 2323.91 | 2324.2 | 81.0 |
| 2010-10-11 18:00:00 | NQ | Futures | 2323.91 | 2325.06 | 2323.91 | 2325.06 | 154.0 |
| 2010-10-11 19:00:00 | NQ | Futures | 2324.77 | 2325.06 | 2321.62 | 2324.48 | 287.0 |
| 2010-10-11 20:00:00 | NQ | Futures | 2324.48 | 2324.77 | 2319.32 | 2319.89 | 317.0 |
| 2010-10-11 21:00:00 | NQ | Futures | 2319.32 | 2319.32 | 2314.16 | 2314.44 | 1218.0 |
| 2010-10-11 22:00:00 | NQ | Futures | 2314.44 | 2315.88 | 2314.16 | 2315.88 | 550.0 |
| 2010-10-11 23:00:00 | NQ | Futures | 2315.59 | 2316.16 | 2307.84 | 2308.7 | 933.0 |
| 2010-10-11 00:00:00 | YM | Futures | 10441.1 | 10442.0 | 10435.3 | 10438.2 | 104.0 |
| 2010-10-11 01:00:00 | YM | Futures | 10436.3 | 10436.3 | 10424.9 | 10425.8 | 169.0 |
> showing 50 of 1,346 rows — these rows as CSV