PREVIEW / futures_1hour / 2008-08-08
file: by_date/futures_1hour/2008/2008-08-08.parquet size: 38 KB rows: 1,027
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-08 00:00:00 | ES | Futures | 1181.6 | 1182.53 | 1181.13 | 1182.06 | 3153.0 |
| 2008-08-08 01:00:00 | ES | Futures | 1182.06 | 1182.53 | 1181.13 | 1182.3 | 1629.0 |
| 2008-08-08 02:00:00 | ES | Futures | 1182.3 | 1182.3 | 1179.51 | 1180.44 | 5296.0 |
| 2008-08-08 03:00:00 | ES | Futures | 1180.44 | 1183.46 | 1178.81 | 1182.76 | 15464.0 |
| 2008-08-08 04:00:00 | ES | Futures | 1182.76 | 1184.39 | 1181.37 | 1181.6 | 11347.0 |
| 2008-08-08 05:00:00 | ES | Futures | 1181.6 | 1184.39 | 1181.37 | 1184.16 | 5815.0 |
| 2008-08-08 06:00:00 | ES | Futures | 1184.39 | 1184.39 | 1180.67 | 1182.99 | 11939.0 |
| 2008-08-08 07:00:00 | ES | Futures | 1183.23 | 1183.46 | 1176.72 | 1178.11 | 37865.0 |
| 2008-08-08 08:00:00 | ES | Futures | 1178.11 | 1180.9 | 1176.02 | 1177.65 | 52189.0 |
| 2008-08-08 09:00:00 | ES | Futures | 1177.65 | 1183.23 | 1173.23 | 1182.06 | 340127.0 |
| 2008-08-08 10:00:00 | ES | Futures | 1182.06 | 1196.01 | 1181.6 | 1192.99 | 477346.0 |
| 2008-08-08 11:00:00 | ES | Futures | 1192.99 | 1194.85 | 1191.36 | 1193.22 | 209899.0 |
| 2008-08-08 12:00:00 | ES | Futures | 1193.22 | 1198.57 | 1192.76 | 1197.17 | 183366.0 |
| 2008-08-08 13:00:00 | ES | Futures | 1197.17 | 1203.91 | 1196.71 | 1201.12 | 214580.0 |
| 2008-08-08 14:00:00 | ES | Futures | 1201.35 | 1205.54 | 1200.66 | 1203.21 | 178926.0 |
| 2008-08-08 15:00:00 | ES | Futures | 1203.45 | 1206.7 | 1201.82 | 1203.68 | 315553.0 |
| 2008-08-08 16:00:00 | ES | Futures | 1203.68 | 1203.91 | 1201.35 | 1201.59 | 95614.0 |
| 2008-08-08 00:00:00 | NQ | Futures | 2127.39 | 2129.92 | 2127.11 | 2128.51 | 62.0 |
| 2008-08-08 01:00:00 | NQ | Futures | 2128.51 | 2129.64 | 2127.67 | 2128.23 | 165.0 |
| 2008-08-08 02:00:00 | NQ | Futures | 2128.23 | 2128.23 | 2124.57 | 2125.42 | 510.0 |
| 2008-08-08 03:00:00 | NQ | Futures | 2125.14 | 2132.17 | 2123.45 | 2130.48 | 1770.0 |
| 2008-08-08 04:00:00 | NQ | Futures | 2130.76 | 2132.73 | 2127.11 | 2127.67 | 809.0 |
| 2008-08-08 05:00:00 | NQ | Futures | 2127.95 | 2134.7 | 2127.39 | 2134.42 | 752.0 |
| 2008-08-08 06:00:00 | NQ | Futures | 2134.7 | 2134.7 | 2127.39 | 2131.04 | 703.0 |
| 2008-08-08 07:00:00 | NQ | Futures | 2130.76 | 2131.61 | 2122.04 | 2123.73 | 3195.0 |
| 2008-08-08 08:00:00 | NQ | Futures | 2123.73 | 2128.51 | 2121.76 | 2124.86 | 7652.0 |
| 2008-08-08 09:00:00 | NQ | Futures | 2124.86 | 2141.17 | 2114.45 | 2138.36 | 67897.0 |
| 2008-08-08 10:00:00 | NQ | Futures | 2138.08 | 2156.64 | 2137.23 | 2145.95 | 86289.0 |
| 2008-08-08 11:00:00 | NQ | Futures | 2146.23 | 2156.08 | 2143.98 | 2154.95 | 37349.0 |
| 2008-08-08 12:00:00 | NQ | Futures | 2154.95 | 2163.11 | 2152.14 | 2159.74 | 37680.0 |
| 2008-08-08 13:00:00 | NQ | Futures | 2160.02 | 2169.58 | 2158.33 | 2163.67 | 39296.0 |
| 2008-08-08 14:00:00 | NQ | Futures | 2163.39 | 2172.67 | 2161.99 | 2168.74 | 44379.0 |
| 2008-08-08 15:00:00 | NQ | Futures | 2168.74 | 2173.8 | 2162.83 | 2167.61 | 59399.0 |
| 2008-08-08 16:00:00 | NQ | Futures | 2167.61 | 2170.14 | 2162.55 | 2164.52 | 15870.0 |
| 2008-08-08 00:00:00 | YM | Futures | 10411.2 | 10422.1 | 10409.3 | 10420.2 | 350.0 |
| 2008-08-08 01:00:00 | YM | Futures | 10419.3 | 10422.1 | 10409.3 | 10418.4 | 171.0 |
| 2008-08-08 02:00:00 | YM | Futures | 10415.7 | 10416.6 | 10394.8 | 10406.6 | 493.0 |
| 2008-08-08 03:00:00 | YM | Futures | 10403.9 | 10428.4 | 10393.0 | 10420.2 | 866.0 |
| 2008-08-08 04:00:00 | YM | Futures | 10422.1 | 10433.9 | 10411.2 | 10411.2 | 695.0 |
| 2008-08-08 05:00:00 | YM | Futures | 10413.0 | 10438.4 | 10411.2 | 10438.4 | 529.0 |
| 2008-08-08 06:00:00 | YM | Futures | 10438.4 | 10438.4 | 10416.6 | 10430.2 | 680.0 |
| 2008-08-08 07:00:00 | YM | Futures | 10430.2 | 10433.9 | 10385.7 | 10392.1 | 1950.0 |
| 2008-08-08 08:00:00 | YM | Futures | 10393.0 | 10415.7 | 10380.3 | 10391.2 | 3099.0 |
| 2008-08-08 09:00:00 | YM | Futures | 10390.2 | 10440.2 | 10342.1 | 10435.7 | 30196.0 |
| 2008-08-08 10:00:00 | YM | Futures | 10433.9 | 10572.9 | 10428.4 | 10548.4 | 58889.0 |
| 2008-08-08 11:00:00 | YM | Futures | 10548.4 | 10574.8 | 10534.8 | 10552.9 | 28492.0 |
| 2008-08-08 12:00:00 | YM | Futures | 10552.9 | 10601.1 | 10546.6 | 10588.4 | 23503.0 |
| 2008-08-08 13:00:00 | YM | Futures | 10589.3 | 10662.0 | 10581.1 | 10641.1 | 30235.0 |
| 2008-08-08 14:00:00 | YM | Futures | 10641.1 | 10673.8 | 10638.4 | 10655.6 | 22097.0 |
| 2008-08-08 15:00:00 | YM | Futures | 10656.5 | 10677.5 | 10633.8 | 10642.0 | 25421.0 |
> showing 50 of 1,027 rows — these rows as CSV