PREVIEW / futures_1hour / 2010-03-11
file: by_date/futures_1hour/2010/2010-03-11.parquet size: 42 KB rows: 1,316
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-03-11 00:00:00 | ES | Futures | 1109.75 | 1110.72 | 1109.02 | 1110.72 | 3937.0 |
| 2010-03-11 01:00:00 | ES | Futures | 1110.48 | 1110.96 | 1109.75 | 1110.48 | 2636.0 |
| 2010-03-11 02:00:00 | ES | Futures | 1110.48 | 1111.45 | 1109.99 | 1110.96 | 5004.0 |
| 2010-03-11 03:00:00 | ES | Futures | 1110.96 | 1112.42 | 1110.48 | 1111.69 | 16246.0 |
| 2010-03-11 04:00:00 | ES | Futures | 1111.45 | 1113.88 | 1110.96 | 1113.15 | 15272.0 |
| 2010-03-11 05:00:00 | ES | Futures | 1113.15 | 1113.15 | 1111.69 | 1111.94 | 8552.0 |
| 2010-03-11 06:00:00 | ES | Futures | 1111.94 | 1113.88 | 1110.72 | 1111.21 | 14330.0 |
| 2010-03-11 07:00:00 | ES | Futures | 1111.45 | 1113.15 | 1111.21 | 1112.67 | 13999.0 |
| 2010-03-11 08:00:00 | ES | Futures | 1112.67 | 1113.64 | 1109.75 | 1110.96 | 52017.0 |
| 2010-03-11 09:00:00 | ES | Futures | 1110.96 | 1112.67 | 1107.8 | 1109.5 | 151139.0 |
| 2010-03-11 10:00:00 | ES | Futures | 1109.75 | 1115.1 | 1109.5 | 1114.37 | 135687.0 |
| 2010-03-11 11:00:00 | ES | Futures | 1114.37 | 1114.61 | 1111.94 | 1113.64 | 79625.0 |
| 2010-03-11 12:00:00 | ES | Futures | 1113.64 | 1113.64 | 1110.48 | 1112.91 | 107780.0 |
| 2010-03-11 13:00:00 | ES | Futures | 1112.91 | 1114.86 | 1112.42 | 1112.91 | 44429.0 |
| 2010-03-11 14:00:00 | ES | Futures | 1113.15 | 1114.13 | 1111.94 | 1113.4 | 58206.0 |
| 2010-03-11 15:00:00 | ES | Futures | 1113.4 | 1118.99 | 1113.4 | 1118.99 | 142469.0 |
| 2010-03-11 16:00:00 | ES | Futures | 1118.99 | 1119.96 | 1118.5 | 1119.48 | 46811.0 |
| 2010-03-11 17:00:00 | ES | Futures | 1119.48 | 1119.72 | 1119.23 | 1119.48 | 1354.0 |
| 2010-03-11 18:00:00 | ES | Futures | 1119.23 | 1119.96 | 1118.99 | 1119.48 | 2217.0 |
| 2010-03-11 19:00:00 | ES | Futures | 1119.23 | 1119.48 | 1118.5 | 1118.99 | 1665.0 |
| 2010-03-11 20:00:00 | ES | Futures | 1118.99 | 1118.99 | 1117.53 | 1118.5 | 1866.0 |
| 2010-03-11 21:00:00 | ES | Futures | 1118.26 | 1118.99 | 1118.02 | 1118.75 | 917.0 |
| 2010-03-11 22:00:00 | ES | Futures | 1118.75 | 1118.99 | 1118.26 | 1118.99 | 606.0 |
| 2010-03-11 23:00:00 | ES | Futures | 1118.75 | 1118.99 | 1118.26 | 1118.99 | 882.0 |
| 2010-03-11 00:00:00 | NQ | Futures | 2184.78 | 2185.63 | 2183.06 | 2185.35 | 320.0 |
| 2010-03-11 01:00:00 | NQ | Futures | 2185.35 | 2186.21 | 2184.49 | 2185.06 | 202.0 |
| 2010-03-11 02:00:00 | NQ | Futures | 2185.35 | 2187.92 | 2185.35 | 2187.35 | 645.0 |
| 2010-03-11 03:00:00 | NQ | Futures | 2187.06 | 2189.92 | 2186.78 | 2187.92 | 1114.0 |
| 2010-03-11 04:00:00 | NQ | Futures | 2188.2 | 2192.49 | 2186.21 | 2191.06 | 1191.0 |
| 2010-03-11 05:00:00 | NQ | Futures | 2191.06 | 2191.63 | 2187.92 | 2188.2 | 762.0 |
| 2010-03-11 06:00:00 | NQ | Futures | 2188.2 | 2191.06 | 2187.35 | 2188.78 | 1133.0 |
| 2010-03-11 07:00:00 | NQ | Futures | 2187.63 | 2189.92 | 2187.35 | 2189.06 | 1416.0 |
| 2010-03-11 08:00:00 | NQ | Futures | 2188.78 | 2190.2 | 2182.49 | 2184.49 | 5425.0 |
| 2010-03-11 09:00:00 | NQ | Futures | 2184.78 | 2187.06 | 2181.35 | 2184.49 | 26404.0 |
| 2010-03-11 10:00:00 | NQ | Futures | 2184.49 | 2193.92 | 2184.21 | 2191.63 | 20909.0 |
| 2010-03-11 11:00:00 | NQ | Futures | 2191.92 | 2192.77 | 2186.78 | 2190.2 | 15143.0 |
| 2010-03-11 12:00:00 | NQ | Futures | 2190.2 | 2190.2 | 2183.63 | 2189.06 | 16649.0 |
| 2010-03-11 13:00:00 | NQ | Futures | 2189.35 | 2190.49 | 2186.49 | 2187.06 | 7026.0 |
| 2010-03-11 14:00:00 | NQ | Futures | 2187.06 | 2189.63 | 2184.78 | 2189.06 | 8074.0 |
| 2010-03-11 15:00:00 | NQ | Futures | 2189.06 | 2197.92 | 2188.78 | 2197.92 | 16447.0 |
| 2010-03-11 16:00:00 | NQ | Futures | 2197.92 | 2201.34 | 2197.34 | 2200.2 | 6745.0 |
| 2010-03-11 17:00:00 | NQ | Futures | 2199.92 | 2200.49 | 2199.63 | 2199.63 | 18.0 |
| 2010-03-11 18:00:00 | NQ | Futures | 2199.92 | 2200.2 | 2199.06 | 2199.34 | 56.0 |
| 2010-03-11 19:00:00 | NQ | Futures | 2199.06 | 2199.63 | 2197.63 | 2197.63 | 55.0 |
| 2010-03-11 20:00:00 | NQ | Futures | 2197.92 | 2198.2 | 2196.77 | 2197.63 | 110.0 |
| 2010-03-11 21:00:00 | NQ | Futures | 2197.92 | 2198.49 | 2197.06 | 2198.49 | 40.0 |
| 2010-03-11 22:00:00 | NQ | Futures | 2197.92 | 2198.77 | 2197.92 | 2198.77 | 22.0 |
| 2010-03-11 23:00:00 | NQ | Futures | 2198.2 | 2198.2 | 2197.06 | 2197.63 | 60.0 |
| 2010-03-11 00:00:00 | YM | Futures | 9852.1 | 9859.6 | 9849.2 | 9859.6 | 19.0 |
| 2010-03-11 01:00:00 | YM | Futures | 9858.6 | 9860.5 | 9854.9 | 9854.9 | 16.0 |
> showing 50 of 1,316 rows — these rows as CSV