PREVIEW / futures_30min / 2013-09-01
file: by_date/futures_30min/2013/2013-09-01.parquet size: 17 KB rows: 407
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 |
|---|---|---|---|---|---|---|---|
| 2013-09-01 18:00:00 | ES | Futures | 1695.98 | 1697.79 | 1694.69 | 1696.24 | 14589.0 |
| 2013-09-01 18:30:00 | ES | Futures | 1695.98 | 1697.79 | 1695.73 | 1697.54 | 5203.0 |
| 2013-09-01 19:00:00 | ES | Futures | 1697.28 | 1697.54 | 1696.24 | 1696.76 | 2305.0 |
| 2013-09-01 19:30:00 | ES | Futures | 1696.5 | 1697.02 | 1695.73 | 1696.24 | 1390.0 |
| 2013-09-01 20:00:00 | ES | Futures | 1695.98 | 1697.79 | 1695.47 | 1697.28 | 4318.0 |
| 2013-09-01 20:30:00 | ES | Futures | 1697.54 | 1699.34 | 1697.28 | 1698.31 | 6387.0 |
| 2013-09-01 21:00:00 | ES | Futures | 1698.31 | 1698.57 | 1697.54 | 1698.05 | 3299.0 |
| 2013-09-01 21:30:00 | ES | Futures | 1698.05 | 1698.57 | 1697.79 | 1698.57 | 2180.0 |
| 2013-09-01 22:00:00 | ES | Futures | 1698.31 | 1698.57 | 1697.28 | 1697.28 | 2471.0 |
| 2013-09-01 22:30:00 | ES | Futures | 1697.28 | 1697.28 | 1695.98 | 1696.76 | 1918.0 |
| 2013-09-01 23:00:00 | ES | Futures | 1696.5 | 1698.05 | 1696.5 | 1697.79 | 1053.0 |
| 2013-09-01 23:30:00 | ES | Futures | 1698.05 | 1699.09 | 1698.05 | 1698.57 | 1957.0 |
| 2013-09-01 18:00:00 | NQ | Futures | 3610.57 | 3625.77 | 3610.57 | 3617.88 | 2632.0 |
| 2013-09-01 18:30:00 | NQ | Futures | 3617.3 | 3621.68 | 3617.0 | 3621.09 | 715.0 |
| 2013-09-01 19:00:00 | NQ | Futures | 3621.09 | 3621.39 | 3619.93 | 3620.51 | 457.0 |
| 2013-09-01 19:30:00 | NQ | Futures | 3620.51 | 3620.8 | 3619.34 | 3620.22 | 255.0 |
| 2013-09-01 20:00:00 | NQ | Futures | 3620.22 | 3621.68 | 3619.34 | 3621.09 | 450.0 |
| 2013-09-01 20:30:00 | NQ | Futures | 3621.39 | 3622.56 | 3620.51 | 3620.51 | 670.0 |
| 2013-09-01 21:00:00 | NQ | Futures | 3620.8 | 3621.97 | 3619.05 | 3620.8 | 755.0 |
| 2013-09-01 21:30:00 | NQ | Futures | 3620.8 | 3621.97 | 3620.22 | 3621.68 | 942.0 |
| 2013-09-01 22:00:00 | NQ | Futures | 3621.39 | 3621.68 | 3619.05 | 3619.34 | 342.0 |
| 2013-09-01 22:30:00 | NQ | Futures | 3619.63 | 3619.63 | 3617.0 | 3618.46 | 375.0 |
| 2013-09-01 23:00:00 | NQ | Futures | 3618.46 | 3620.8 | 3618.17 | 3620.8 | 134.0 |
| 2013-09-01 23:30:00 | NQ | Futures | 3620.8 | 3622.56 | 3620.8 | 3621.39 | 190.0 |
| 2013-09-01 18:00:00 | YM | Futures | 15082.9 | 15102.2 | 15081.9 | 15097.1 | 1055.0 |
| 2013-09-01 18:30:00 | YM | Futures | 15095.1 | 15109.3 | 15095.1 | 15106.2 | 405.0 |
| 2013-09-01 19:00:00 | YM | Futures | 15103.2 | 15104.2 | 15096.1 | 15098.1 | 124.0 |
| 2013-09-01 19:30:00 | YM | Futures | 15098.1 | 15098.1 | 15086.9 | 15089.0 | 314.0 |
| 2013-09-01 20:00:00 | YM | Futures | 15089.0 | 15102.2 | 15084.9 | 15099.1 | 340.0 |
| 2013-09-01 20:30:00 | YM | Futures | 15099.1 | 15112.3 | 15099.1 | 15108.3 | 479.0 |
| 2013-09-01 21:00:00 | YM | Futures | 15109.3 | 15109.3 | 15099.1 | 15105.2 | 311.0 |
| 2013-09-01 21:30:00 | YM | Futures | 15105.2 | 15108.3 | 15102.2 | 15107.2 | 405.0 |
| 2013-09-01 22:00:00 | YM | Futures | 15107.2 | 15107.2 | 15098.1 | 15100.1 | 338.0 |
| 2013-09-01 22:30:00 | YM | Futures | 15101.1 | 15101.1 | 15090.0 | 15094.0 | 276.0 |
| 2013-09-01 23:00:00 | YM | Futures | 15094.0 | 15105.2 | 15093.0 | 15103.2 | 133.0 |
| 2013-09-01 23:30:00 | YM | Futures | 15104.2 | 15113.3 | 15103.2 | 15108.3 | 319.0 |
| 2013-09-01 18:00:00 | CL | Futures | 169.03 | 169.16 | 164.52 | 167.88 | 4890.0 |
| 2013-09-01 18:30:00 | CL | Futures | 167.85 | 167.9 | 166.86 | 166.92 | 1178.0 |
| 2013-09-01 19:00:00 | CL | Futures | 166.87 | 167.19 | 166.6 | 167.12 | 1296.0 |
| 2013-09-01 19:30:00 | CL | Futures | 167.12 | 167.64 | 167.08 | 167.27 | 1121.0 |
| 2013-09-01 20:00:00 | CL | Futures | 167.23 | 167.5 | 167.09 | 167.12 | 629.0 |
| 2013-09-01 20:30:00 | CL | Futures | 167.14 | 167.5 | 167.14 | 167.25 | 588.0 |
| 2013-09-01 21:00:00 | CL | Futures | 167.27 | 168.31 | 167.27 | 168.28 | 1664.0 |
| 2013-09-01 21:30:00 | CL | Futures | 168.26 | 168.31 | 167.5 | 167.74 | 1305.0 |
| 2013-09-01 22:00:00 | CL | Futures | 167.69 | 167.9 | 167.3 | 167.53 | 1025.0 |
| 2013-09-01 22:30:00 | CL | Futures | 167.52 | 167.57 | 167.19 | 167.34 | 670.0 |
| 2013-09-01 23:00:00 | CL | Futures | 167.33 | 167.42 | 167.19 | 167.41 | 406.0 |
| 2013-09-01 23:30:00 | CL | Futures | 167.42 | 167.69 | 167.42 | 167.49 | 303.0 |
| 2013-09-01 18:00:00 | GC | Futures | 1910.9 | 1910.9 | 1882.9 | 1889.7 | 6489.0 |
| 2013-09-01 18:30:00 | GC | Futures | 1890.0 | 1896.9 | 1889.7 | 1894.9 | 1350.0 |
> showing 50 of 407 rows — these rows as CSV