PREVIEW / futures_30min / 2015-03-10
file: by_date/futures_30min/2015/2015-03-10.parquet size: 75 KB rows: 2,722
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-10 00:00:00 | ES | Futures | 2185.21 | 2185.48 | 2181.79 | 2182.32 | 4869.0 |
| 2015-03-10 00:30:00 | ES | Futures | 2182.32 | 2183.11 | 2181.79 | 2182.06 | 1780.0 |
| 2015-03-10 01:00:00 | ES | Futures | 2182.06 | 2182.84 | 2182.06 | 2182.06 | 1239.0 |
| 2015-03-10 01:30:00 | ES | Futures | 2182.32 | 2182.84 | 2181.53 | 2181.53 | 1438.0 |
| 2015-03-10 02:00:00 | ES | Futures | 2181.53 | 2182.84 | 2181.53 | 2182.84 | 1230.0 |
| 2015-03-10 02:30:00 | ES | Futures | 2182.58 | 2183.11 | 2182.06 | 2182.58 | 828.0 |
| 2015-03-10 03:00:00 | ES | Futures | 2182.58 | 2182.58 | 2181.79 | 2182.06 | 2438.0 |
| 2015-03-10 03:30:00 | ES | Futures | 2182.06 | 2183.11 | 2182.06 | 2182.58 | 2228.0 |
| 2015-03-10 04:00:00 | ES | Futures | 2182.84 | 2184.16 | 2178.37 | 2178.37 | 17085.0 |
| 2015-03-10 04:30:00 | ES | Futures | 2178.37 | 2179.42 | 2177.32 | 2177.58 | 9843.0 |
| 2015-03-10 05:00:00 | ES | Futures | 2177.58 | 2178.37 | 2176.27 | 2176.53 | 8285.0 |
| 2015-03-10 05:30:00 | ES | Futures | 2176.79 | 2176.79 | 2174.95 | 2175.48 | 8055.0 |
| 2015-03-10 06:00:00 | ES | Futures | 2175.48 | 2175.74 | 2170.48 | 2171.79 | 15997.0 |
| 2015-03-10 06:30:00 | ES | Futures | 2171.53 | 2174.42 | 2171.27 | 2173.37 | 11185.0 |
| 2015-03-10 07:00:00 | ES | Futures | 2173.37 | 2174.16 | 2167.58 | 2168.37 | 24237.0 |
| 2015-03-10 07:30:00 | ES | Futures | 2168.37 | 2169.69 | 2167.06 | 2168.37 | 17732.0 |
| 2015-03-10 08:00:00 | ES | Futures | 2168.37 | 2168.63 | 2163.63 | 2165.48 | 37561.0 |
| 2015-03-10 08:30:00 | ES | Futures | 2165.48 | 2170.48 | 2164.95 | 2168.63 | 38500.0 |
| 2015-03-10 09:00:00 | ES | Futures | 2168.37 | 2171.53 | 2168.11 | 2170.21 | 23525.0 |
| 2015-03-10 09:30:00 | ES | Futures | 2170.21 | 2171.27 | 2162.58 | 2165.74 | 224841.0 |
| 2015-03-10 10:00:00 | ES | Futures | 2165.74 | 2167.84 | 2160.21 | 2163.37 | 164052.0 |
| 2015-03-10 10:30:00 | ES | Futures | 2163.11 | 2165.48 | 2159.16 | 2163.37 | 129546.0 |
| 2015-03-10 11:00:00 | ES | Futures | 2163.37 | 2169.42 | 2163.11 | 2166.53 | 94122.0 |
| 2015-03-10 11:30:00 | ES | Futures | 2166.53 | 2167.84 | 2157.85 | 2157.85 | 97664.0 |
| 2015-03-10 12:00:00 | ES | Futures | 2158.11 | 2160.48 | 2155.21 | 2156.27 | 129796.0 |
| 2015-03-10 12:30:00 | ES | Futures | 2156.27 | 2160.21 | 2155.21 | 2157.58 | 95849.0 |
| 2015-03-10 13:00:00 | ES | Futures | 2157.85 | 2162.32 | 2156.79 | 2160.21 | 65453.0 |
| 2015-03-10 13:30:00 | ES | Futures | 2159.95 | 2160.48 | 2157.58 | 2159.16 | 51533.0 |
| 2015-03-10 14:00:00 | ES | Futures | 2159.16 | 2161.53 | 2154.16 | 2154.69 | 70518.0 |
| 2015-03-10 14:30:00 | ES | Futures | 2154.69 | 2157.85 | 2154.16 | 2154.42 | 57007.0 |
| 2015-03-10 15:00:00 | ES | Futures | 2154.42 | 2159.69 | 2153.63 | 2156.27 | 101295.0 |
| 2015-03-10 15:30:00 | ES | Futures | 2156.53 | 2157.58 | 2151.53 | 2151.79 | 154093.0 |
| 2015-03-10 16:00:00 | ES | Futures | 2151.79 | 2152.32 | 2148.63 | 2149.42 | 118098.0 |
| 2015-03-10 16:30:00 | ES | Futures | 2149.95 | 2151.53 | 2149.95 | 2151.27 | 12327.0 |
| 2015-03-10 17:00:00 | ES | Futures | 2151.53 | 2151.79 | 2151.0 | 2151.53 | 3250.0 |
| 2015-03-10 18:00:00 | ES | Futures | 2151.79 | 2152.06 | 2150.21 | 2151.0 | 3445.0 |
| 2015-03-10 18:30:00 | ES | Futures | 2151.0 | 2152.32 | 2150.74 | 2151.79 | 1536.0 |
| 2015-03-10 19:00:00 | ES | Futures | 2151.79 | 2153.11 | 2150.74 | 2153.11 | 2372.0 |
| 2015-03-10 19:30:00 | ES | Futures | 2152.85 | 2154.42 | 2152.58 | 2154.16 | 3249.0 |
| 2015-03-10 20:00:00 | ES | Futures | 2154.16 | 2154.69 | 2152.58 | 2153.9 | 3866.0 |
| 2015-03-10 20:30:00 | ES | Futures | 2154.16 | 2154.69 | 2153.63 | 2154.69 | 1741.0 |
| 2015-03-10 21:00:00 | ES | Futures | 2154.69 | 2156.0 | 2154.42 | 2155.74 | 4380.0 |
| 2015-03-10 21:30:00 | ES | Futures | 2155.74 | 2156.53 | 2155.48 | 2155.48 | 3503.0 |
| 2015-03-10 22:00:00 | ES | Futures | 2155.74 | 2156.0 | 2155.21 | 2156.0 | 1499.0 |
| 2015-03-10 22:30:00 | ES | Futures | 2156.0 | 2156.79 | 2155.74 | 2156.79 | 2645.0 |
| 2015-03-10 23:00:00 | ES | Futures | 2156.79 | 2157.06 | 2155.48 | 2155.48 | 2109.0 |
| 2015-03-10 23:30:00 | ES | Futures | 2155.48 | 2156.53 | 2155.21 | 2156.27 | 1372.0 |
| 2015-03-10 00:00:00 | NQ | Futures | 5181.84 | 5182.43 | 5175.38 | 5176.26 | 636.0 |
| 2015-03-10 00:30:00 | NQ | Futures | 5176.55 | 5178.61 | 5175.08 | 5175.08 | 420.0 |
| 2015-03-10 01:00:00 | NQ | Futures | 5175.08 | 5177.14 | 5175.08 | 5175.38 | 162.0 |
> showing 50 of 2,722 rows — these rows as CSV