PREVIEW / futures_30min / 2013-11-10
file: by_date/futures_30min/2013/2013-11-10.parquet size: 19 KB rows: 514
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-11-10 18:00:00 | ES | Futures | 1823.26 | 1823.52 | 1820.43 | 1820.94 | 6724.0 |
| 2013-11-10 18:30:00 | ES | Futures | 1820.94 | 1821.72 | 1819.39 | 1821.72 | 2788.0 |
| 2013-11-10 19:00:00 | ES | Futures | 1821.97 | 1823.01 | 1820.68 | 1821.46 | 3776.0 |
| 2013-11-10 19:30:00 | ES | Futures | 1821.2 | 1821.72 | 1820.68 | 1821.46 | 1453.0 |
| 2013-11-10 20:00:00 | ES | Futures | 1821.46 | 1821.72 | 1820.17 | 1820.43 | 1989.0 |
| 2013-11-10 20:30:00 | ES | Futures | 1820.43 | 1820.94 | 1819.39 | 1820.17 | 3606.0 |
| 2013-11-10 21:00:00 | ES | Futures | 1819.91 | 1820.68 | 1819.65 | 1820.17 | 1292.0 |
| 2013-11-10 21:30:00 | ES | Futures | 1820.43 | 1820.43 | 1819.65 | 1819.91 | 973.0 |
| 2013-11-10 22:00:00 | ES | Futures | 1820.17 | 1820.68 | 1819.91 | 1820.17 | 1027.0 |
| 2013-11-10 22:30:00 | ES | Futures | 1819.91 | 1819.91 | 1819.14 | 1819.14 | 1939.0 |
| 2013-11-10 23:00:00 | ES | Futures | 1819.39 | 1819.65 | 1818.88 | 1819.39 | 1362.0 |
| 2013-11-10 23:30:00 | ES | Futures | 1819.65 | 1820.68 | 1819.39 | 1819.91 | 2337.0 |
| 2013-11-10 18:00:00 | NQ | Futures | 3905.16 | 3905.45 | 3899.35 | 3900.22 | 824.0 |
| 2013-11-10 18:30:00 | NQ | Futures | 3900.22 | 3903.12 | 3897.02 | 3903.12 | 551.0 |
| 2013-11-10 19:00:00 | NQ | Futures | 3902.83 | 3903.99 | 3899.64 | 3899.93 | 633.0 |
| 2013-11-10 19:30:00 | NQ | Futures | 3899.93 | 3901.38 | 3899.06 | 3900.51 | 603.0 |
| 2013-11-10 20:00:00 | NQ | Futures | 3900.51 | 3900.51 | 3897.6 | 3897.6 | 412.0 |
| 2013-11-10 20:30:00 | NQ | Futures | 3897.89 | 3898.77 | 3895.86 | 3897.02 | 659.0 |
| 2013-11-10 21:00:00 | NQ | Futures | 3897.02 | 3898.19 | 3896.15 | 3897.89 | 300.0 |
| 2013-11-10 21:30:00 | NQ | Futures | 3897.6 | 3898.19 | 3895.86 | 3896.44 | 199.0 |
| 2013-11-10 22:00:00 | NQ | Futures | 3896.44 | 3897.6 | 3896.44 | 3896.44 | 376.0 |
| 2013-11-10 22:30:00 | NQ | Futures | 3896.44 | 3896.44 | 3895.57 | 3895.86 | 234.0 |
| 2013-11-10 23:00:00 | NQ | Futures | 3895.57 | 3896.44 | 3895.28 | 3896.15 | 121.0 |
| 2013-11-10 23:30:00 | NQ | Futures | 3896.73 | 3897.6 | 3896.15 | 3897.6 | 189.0 |
| 2013-11-10 18:00:00 | YM | Futures | 16041.7 | 16049.9 | 16021.3 | 16025.4 | 620.0 |
| 2013-11-10 18:30:00 | YM | Futures | 16025.4 | 16034.6 | 16018.3 | 16034.6 | 361.0 |
| 2013-11-10 19:00:00 | YM | Futures | 16034.6 | 16037.7 | 16017.2 | 16024.4 | 752.0 |
| 2013-11-10 19:30:00 | YM | Futures | 16024.4 | 16029.5 | 16022.3 | 16026.4 | 209.0 |
| 2013-11-10 20:00:00 | YM | Futures | 16026.4 | 16027.5 | 16017.2 | 16019.3 | 476.0 |
| 2013-11-10 20:30:00 | YM | Futures | 16018.3 | 16026.4 | 16013.2 | 16021.3 | 660.0 |
| 2013-11-10 21:00:00 | YM | Futures | 16020.3 | 16024.4 | 16016.2 | 16022.3 | 302.0 |
| 2013-11-10 21:30:00 | YM | Futures | 16020.3 | 16020.3 | 16013.2 | 16018.3 | 219.0 |
| 2013-11-10 22:00:00 | YM | Futures | 16018.3 | 16021.3 | 16014.2 | 16015.2 | 150.0 |
| 2013-11-10 22:30:00 | YM | Futures | 16015.2 | 16015.2 | 16010.1 | 16012.1 | 301.0 |
| 2013-11-10 23:00:00 | YM | Futures | 16012.1 | 16015.2 | 16010.1 | 16014.2 | 177.0 |
| 2013-11-10 23:30:00 | YM | Futures | 16015.2 | 16020.3 | 16014.2 | 16020.3 | 244.0 |
| 2013-11-10 18:00:00 | CL | Futures | 150.07 | 150.57 | 150.06 | 150.36 | 899.0 |
| 2013-11-10 18:30:00 | CL | Futures | 150.34 | 150.52 | 150.34 | 150.52 | 159.0 |
| 2013-11-10 19:00:00 | CL | Futures | 150.49 | 150.52 | 150.39 | 150.5 | 262.0 |
| 2013-11-10 19:30:00 | CL | Futures | 150.52 | 150.63 | 150.52 | 150.6 | 373.0 |
| 2013-11-10 20:00:00 | CL | Futures | 150.6 | 150.74 | 150.55 | 150.61 | 422.0 |
| 2013-11-10 20:30:00 | CL | Futures | 150.57 | 150.66 | 150.47 | 150.49 | 362.0 |
| 2013-11-10 21:00:00 | CL | Futures | 150.49 | 150.55 | 150.36 | 150.37 | 463.0 |
| 2013-11-10 21:30:00 | CL | Futures | 150.39 | 150.47 | 150.39 | 150.41 | 83.0 |
| 2013-11-10 22:00:00 | CL | Futures | 150.41 | 150.44 | 150.33 | 150.39 | 179.0 |
| 2013-11-10 22:30:00 | CL | Futures | 150.39 | 150.44 | 150.37 | 150.41 | 51.0 |
| 2013-11-10 23:00:00 | CL | Futures | 150.39 | 150.49 | 150.39 | 150.45 | 121.0 |
| 2013-11-10 23:30:00 | CL | Futures | 150.44 | 150.55 | 150.42 | 150.52 | 291.0 |
| 2013-11-10 18:00:00 | GC | Futures | 1766.0 | 1766.6 | 1762.4 | 1762.8 | 1240.0 |
| 2013-11-10 18:30:00 | GC | Futures | 1762.8 | 1764.3 | 1762.7 | 1763.8 | 420.0 |
> showing 50 of 514 rows — these rows as CSV