PREVIEW / futures_30min / 2013-09-08
file: by_date/futures_30min/2013/2013-09-08.parquet size: 19 KB rows: 489
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-08 18:00:00 | ES | Futures | 1708.13 | 1713.82 | 1708.13 | 1712.79 | 7850.0 |
| 2013-09-08 18:30:00 | ES | Futures | 1712.79 | 1714.34 | 1712.27 | 1712.27 | 2657.0 |
| 2013-09-08 19:00:00 | ES | Futures | 1712.27 | 1712.79 | 1711.75 | 1712.27 | 856.0 |
| 2013-09-08 19:30:00 | ES | Futures | 1712.27 | 1713.56 | 1711.75 | 1712.79 | 1509.0 |
| 2013-09-08 20:00:00 | ES | Futures | 1712.79 | 1713.3 | 1711.49 | 1711.49 | 2383.0 |
| 2013-09-08 20:30:00 | ES | Futures | 1711.75 | 1712.01 | 1710.98 | 1711.75 | 2155.0 |
| 2013-09-08 21:00:00 | ES | Futures | 1711.49 | 1712.79 | 1710.98 | 1711.24 | 1912.0 |
| 2013-09-08 21:30:00 | ES | Futures | 1711.24 | 1713.05 | 1711.24 | 1712.27 | 1811.0 |
| 2013-09-08 22:00:00 | ES | Futures | 1712.27 | 1712.53 | 1710.98 | 1712.01 | 2071.0 |
| 2013-09-08 22:30:00 | ES | Futures | 1712.27 | 1713.05 | 1712.01 | 1712.79 | 726.0 |
| 2013-09-08 23:00:00 | ES | Futures | 1713.05 | 1715.37 | 1712.79 | 1715.37 | 3093.0 |
| 2013-09-08 23:30:00 | ES | Futures | 1715.11 | 1715.63 | 1714.08 | 1714.08 | 2557.0 |
| 2013-09-08 18:00:00 | NQ | Futures | 3662.01 | 3669.9 | 3659.38 | 3668.14 | 918.0 |
| 2013-09-08 18:30:00 | NQ | Futures | 3668.14 | 3670.19 | 3666.98 | 3666.98 | 114.0 |
| 2013-09-08 19:00:00 | NQ | Futures | 3666.68 | 3668.14 | 3666.1 | 3667.85 | 180.0 |
| 2013-09-08 19:30:00 | NQ | Futures | 3667.56 | 3669.9 | 3666.98 | 3669.02 | 210.0 |
| 2013-09-08 20:00:00 | NQ | Futures | 3669.31 | 3669.61 | 3666.1 | 3666.39 | 346.0 |
| 2013-09-08 20:30:00 | NQ | Futures | 3666.68 | 3667.27 | 3665.51 | 3666.39 | 195.0 |
| 2013-09-08 21:00:00 | NQ | Futures | 3666.98 | 3668.73 | 3665.51 | 3666.39 | 202.0 |
| 2013-09-08 21:30:00 | NQ | Futures | 3666.39 | 3669.31 | 3666.39 | 3668.14 | 214.0 |
| 2013-09-08 22:00:00 | NQ | Futures | 3667.85 | 3667.85 | 3665.51 | 3667.27 | 156.0 |
| 2013-09-08 22:30:00 | NQ | Futures | 3667.27 | 3669.9 | 3667.27 | 3669.31 | 281.0 |
| 2013-09-08 23:00:00 | NQ | Futures | 3669.31 | 3673.7 | 3669.02 | 3673.4 | 585.0 |
| 2013-09-08 23:30:00 | NQ | Futures | 3672.82 | 3673.7 | 3671.36 | 3671.65 | 263.0 |
| 2013-09-08 18:00:00 | YM | Futures | 15141.8 | 15173.3 | 15125.5 | 15164.1 | 1255.0 |
| 2013-09-08 18:30:00 | YM | Futures | 15164.1 | 15173.3 | 15162.1 | 15163.1 | 435.0 |
| 2013-09-08 19:00:00 | YM | Futures | 15163.1 | 15166.2 | 15160.1 | 15164.1 | 55.0 |
| 2013-09-08 19:30:00 | YM | Futures | 15164.1 | 15170.2 | 15160.1 | 15169.2 | 209.0 |
| 2013-09-08 20:00:00 | YM | Futures | 15168.2 | 15169.2 | 15156.0 | 15158.0 | 355.0 |
| 2013-09-08 20:30:00 | YM | Futures | 15159.0 | 15162.1 | 15155.0 | 15160.1 | 302.0 |
| 2013-09-08 21:00:00 | YM | Futures | 15161.1 | 15169.2 | 15156.0 | 15160.1 | 435.0 |
| 2013-09-08 21:30:00 | YM | Futures | 15160.1 | 15170.2 | 15160.1 | 15166.2 | 446.0 |
| 2013-09-08 22:00:00 | YM | Futures | 15166.2 | 15166.2 | 15156.0 | 15163.1 | 408.0 |
| 2013-09-08 22:30:00 | YM | Futures | 15164.1 | 15168.2 | 15163.1 | 15168.2 | 141.0 |
| 2013-09-08 23:00:00 | YM | Futures | 15168.2 | 15185.5 | 15167.2 | 15184.4 | 423.0 |
| 2013-09-08 23:30:00 | YM | Futures | 15183.4 | 15186.5 | 15176.3 | 15179.4 | 342.0 |
| 2013-09-08 18:00:00 | CL | Futures | 174.1 | 174.1 | 173.28 | 173.56 | 1705.0 |
| 2013-09-08 18:30:00 | CL | Futures | 173.56 | 173.56 | 173.42 | 173.52 | 233.0 |
| 2013-09-08 19:00:00 | CL | Futures | 173.55 | 173.77 | 173.49 | 173.75 | 370.0 |
| 2013-09-08 19:30:00 | CL | Futures | 173.74 | 173.75 | 173.38 | 173.53 | 403.0 |
| 2013-09-08 20:00:00 | CL | Futures | 173.53 | 173.72 | 173.5 | 173.71 | 557.0 |
| 2013-09-08 20:30:00 | CL | Futures | 173.71 | 174.26 | 173.61 | 173.93 | 1443.0 |
| 2013-09-08 21:00:00 | CL | Futures | 173.94 | 174.09 | 173.77 | 174.02 | 491.0 |
| 2013-09-08 21:30:00 | CL | Futures | 174.01 | 174.12 | 173.98 | 174.07 | 277.0 |
| 2013-09-08 22:00:00 | CL | Futures | 174.05 | 174.13 | 173.93 | 174.09 | 438.0 |
| 2013-09-08 22:30:00 | CL | Futures | 174.12 | 174.26 | 174.02 | 174.2 | 329.0 |
| 2013-09-08 23:00:00 | CL | Futures | 174.16 | 174.21 | 174.09 | 174.15 | 224.0 |
| 2013-09-08 23:30:00 | CL | Futures | 174.15 | 174.2 | 174.1 | 174.15 | 103.0 |
| 2013-09-08 18:00:00 | GC | Futures | 1906.9 | 1912.2 | 1898.5 | 1904.1 | 1636.0 |
| 2013-09-08 18:30:00 | GC | Futures | 1904.0 | 1904.0 | 1901.1 | 1901.5 | 229.0 |
> showing 50 of 489 rows — these rows as CSV