PREVIEW / futures_30min / 2013-04-28
file: by_date/futures_30min/2013/2013-04-28.parquet size: 19 KB rows: 501
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-04-28 18:00:00 | ES | Futures | 1624.07 | 1624.84 | 1623.3 | 1623.55 | 3383.0 |
| 2013-04-28 18:30:00 | ES | Futures | 1623.55 | 1624.07 | 1623.3 | 1624.07 | 611.0 |
| 2013-04-28 19:00:00 | ES | Futures | 1624.07 | 1624.07 | 1622.78 | 1622.78 | 695.0 |
| 2013-04-28 19:30:00 | ES | Futures | 1622.78 | 1623.81 | 1622.52 | 1623.3 | 1513.0 |
| 2013-04-28 20:00:00 | ES | Futures | 1623.3 | 1623.3 | 1621.49 | 1622.27 | 2781.0 |
| 2013-04-28 20:30:00 | ES | Futures | 1622.27 | 1623.3 | 1622.01 | 1623.3 | 2815.0 |
| 2013-04-28 21:00:00 | ES | Futures | 1623.3 | 1624.33 | 1623.04 | 1623.81 | 2081.0 |
| 2013-04-28 21:30:00 | ES | Futures | 1624.07 | 1624.33 | 1623.3 | 1623.81 | 1266.0 |
| 2013-04-28 22:00:00 | ES | Futures | 1623.81 | 1625.61 | 1623.81 | 1624.33 | 3012.0 |
| 2013-04-28 22:30:00 | ES | Futures | 1624.58 | 1624.84 | 1623.3 | 1623.55 | 2183.0 |
| 2013-04-28 23:00:00 | ES | Futures | 1623.3 | 1623.81 | 1623.04 | 1623.55 | 1059.0 |
| 2013-04-28 23:30:00 | ES | Futures | 1623.55 | 1623.81 | 1623.3 | 1623.81 | 468.0 |
| 2013-04-28 18:00:00 | NQ | Futures | 3306.06 | 3306.93 | 3302.85 | 3303.14 | 527.0 |
| 2013-04-28 18:30:00 | NQ | Futures | 3303.14 | 3304.01 | 3302.56 | 3304.01 | 65.0 |
| 2013-04-28 19:00:00 | NQ | Futures | 3304.01 | 3304.01 | 3302.26 | 3302.26 | 75.0 |
| 2013-04-28 19:30:00 | NQ | Futures | 3302.56 | 3303.72 | 3301.39 | 3302.56 | 124.0 |
| 2013-04-28 20:00:00 | NQ | Futures | 3302.26 | 3302.26 | 3298.76 | 3300.51 | 275.0 |
| 2013-04-28 20:30:00 | NQ | Futures | 3300.81 | 3302.56 | 3300.22 | 3301.97 | 218.0 |
| 2013-04-28 21:00:00 | NQ | Futures | 3302.56 | 3303.72 | 3302.56 | 3303.72 | 154.0 |
| 2013-04-28 21:30:00 | NQ | Futures | 3303.72 | 3304.31 | 3302.26 | 3304.01 | 107.0 |
| 2013-04-28 22:00:00 | NQ | Futures | 3304.01 | 3307.52 | 3304.01 | 3305.47 | 292.0 |
| 2013-04-28 22:30:00 | NQ | Futures | 3305.77 | 3306.06 | 3303.43 | 3303.43 | 212.0 |
| 2013-04-28 23:00:00 | NQ | Futures | 3303.43 | 3304.01 | 3302.85 | 3303.43 | 93.0 |
| 2013-04-28 23:30:00 | NQ | Futures | 3303.43 | 3305.18 | 3303.14 | 3304.89 | 118.0 |
| 2013-04-28 18:00:00 | YM | Futures | 14808.3 | 14813.4 | 14801.2 | 14804.3 | 307.0 |
| 2013-04-28 18:30:00 | YM | Futures | 14804.3 | 14807.3 | 14804.3 | 14806.3 | 37.0 |
| 2013-04-28 19:00:00 | YM | Futures | 14805.3 | 14805.3 | 14800.2 | 14801.2 | 121.0 |
| 2013-04-28 19:30:00 | YM | Futures | 14801.2 | 14808.3 | 14799.2 | 14802.3 | 240.0 |
| 2013-04-28 20:00:00 | YM | Futures | 14802.3 | 14803.3 | 14791.1 | 14795.2 | 339.0 |
| 2013-04-28 20:30:00 | YM | Futures | 14795.2 | 14804.3 | 14795.2 | 14804.3 | 319.0 |
| 2013-04-28 21:00:00 | YM | Futures | 14805.3 | 14812.4 | 14805.3 | 14810.3 | 278.0 |
| 2013-04-28 21:30:00 | YM | Futures | 14810.3 | 14811.4 | 14804.3 | 14809.3 | 190.0 |
| 2013-04-28 22:00:00 | YM | Futures | 14811.4 | 14822.5 | 14811.4 | 14816.4 | 418.0 |
| 2013-04-28 22:30:00 | YM | Futures | 14816.4 | 14817.4 | 14806.3 | 14806.3 | 235.0 |
| 2013-04-28 23:00:00 | YM | Futures | 14806.3 | 14810.3 | 14804.3 | 14808.3 | 182.0 |
| 2013-04-28 23:30:00 | YM | Futures | 14809.3 | 14810.3 | 14806.3 | 14808.3 | 64.0 |
| 2013-04-28 18:00:00 | CL | Futures | 145.57 | 145.9 | 145.4 | 145.51 | 664.0 |
| 2013-04-28 18:30:00 | CL | Futures | 145.51 | 145.6 | 145.48 | 145.48 | 148.0 |
| 2013-04-28 19:00:00 | CL | Futures | 145.49 | 145.79 | 145.49 | 145.59 | 210.0 |
| 2013-04-28 19:30:00 | CL | Futures | 145.57 | 145.57 | 145.43 | 145.48 | 230.0 |
| 2013-04-28 20:00:00 | CL | Futures | 145.49 | 145.51 | 145.29 | 145.34 | 318.0 |
| 2013-04-28 20:30:00 | CL | Futures | 145.32 | 145.53 | 145.29 | 145.49 | 271.0 |
| 2013-04-28 21:00:00 | CL | Futures | 145.51 | 145.56 | 145.32 | 145.38 | 181.0 |
| 2013-04-28 21:30:00 | CL | Futures | 145.38 | 145.6 | 145.15 | 145.4 | 692.0 |
| 2013-04-28 22:00:00 | CL | Futures | 145.4 | 145.49 | 145.38 | 145.45 | 253.0 |
| 2013-04-28 22:30:00 | CL | Futures | 145.45 | 145.68 | 145.4 | 145.53 | 676.0 |
| 2013-04-28 23:00:00 | CL | Futures | 145.54 | 145.56 | 145.48 | 145.49 | 98.0 |
| 2013-04-28 23:30:00 | CL | Futures | 145.48 | 145.53 | 145.29 | 145.46 | 385.0 |
| 2013-04-28 18:00:00 | GC | Futures | 2013.8 | 2015.4 | 2009.5 | 2011.9 | 1129.0 |
| 2013-04-28 18:30:00 | GC | Futures | 2012.0 | 2012.0 | 2008.7 | 2010.9 | 415.0 |
> showing 50 of 501 rows — these rows as CSV