PREVIEW / futures_30min / 2013-03-24
file: by_date/futures_30min/2013/2013-03-24.parquet size: 20 KB rows: 518
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-03-24 18:00:00 | ES | Futures | 1597.02 | 1599.6 | 1595.48 | 1598.57 | 11384.0 |
| 2013-03-24 18:30:00 | ES | Futures | 1598.83 | 1599.34 | 1598.57 | 1598.83 | 769.0 |
| 2013-03-24 19:00:00 | ES | Futures | 1598.57 | 1602.95 | 1598.57 | 1601.4 | 7469.0 |
| 2013-03-24 19:30:00 | ES | Futures | 1601.4 | 1605.52 | 1600.63 | 1603.46 | 14741.0 |
| 2013-03-24 20:00:00 | ES | Futures | 1603.46 | 1604.75 | 1603.2 | 1603.98 | 6539.0 |
| 2013-03-24 20:30:00 | ES | Futures | 1603.72 | 1604.75 | 1602.69 | 1604.49 | 5040.0 |
| 2013-03-24 21:00:00 | ES | Futures | 1604.75 | 1605.52 | 1604.49 | 1605.01 | 5804.0 |
| 2013-03-24 21:30:00 | ES | Futures | 1605.01 | 1606.81 | 1605.01 | 1606.3 | 7071.0 |
| 2013-03-24 22:00:00 | ES | Futures | 1606.55 | 1606.81 | 1605.01 | 1605.52 | 4307.0 |
| 2013-03-24 22:30:00 | ES | Futures | 1605.27 | 1606.81 | 1605.01 | 1606.55 | 5454.0 |
| 2013-03-24 23:00:00 | ES | Futures | 1606.81 | 1607.07 | 1606.3 | 1606.55 | 3185.0 |
| 2013-03-24 23:30:00 | ES | Futures | 1606.81 | 1606.81 | 1605.52 | 1605.78 | 1314.0 |
| 2013-03-24 18:00:00 | NQ | Futures | 3259.1 | 3263.76 | 3258.22 | 3263.18 | 724.0 |
| 2013-03-24 18:30:00 | NQ | Futures | 3262.89 | 3263.47 | 3262.6 | 3263.47 | 74.0 |
| 2013-03-24 19:00:00 | NQ | Futures | 3263.47 | 3269.31 | 3263.18 | 3268.72 | 929.0 |
| 2013-03-24 19:30:00 | NQ | Futures | 3268.43 | 3278.06 | 3266.97 | 3274.26 | 1697.0 |
| 2013-03-24 20:00:00 | NQ | Futures | 3274.26 | 3275.72 | 3272.81 | 3273.39 | 502.0 |
| 2013-03-24 20:30:00 | NQ | Futures | 3273.68 | 3276.31 | 3271.93 | 3276.01 | 454.0 |
| 2013-03-24 21:00:00 | NQ | Futures | 3276.31 | 3277.47 | 3274.56 | 3275.14 | 442.0 |
| 2013-03-24 21:30:00 | NQ | Futures | 3276.01 | 3277.76 | 3275.72 | 3277.18 | 353.0 |
| 2013-03-24 22:00:00 | NQ | Futures | 3277.18 | 3277.76 | 3273.97 | 3274.85 | 258.0 |
| 2013-03-24 22:30:00 | NQ | Futures | 3274.85 | 3277.76 | 3274.26 | 3277.47 | 309.0 |
| 2013-03-24 23:00:00 | NQ | Futures | 3277.47 | 3278.35 | 3276.6 | 3277.47 | 250.0 |
| 2013-03-24 23:30:00 | NQ | Futures | 3277.18 | 3277.18 | 3275.43 | 3275.72 | 127.0 |
| 2013-03-24 18:00:00 | YM | Futures | 14609.2 | 14617.3 | 14587.9 | 14611.2 | 514.0 |
| 2013-03-24 18:30:00 | YM | Futures | 14613.2 | 14615.2 | 14610.2 | 14611.2 | 44.0 |
| 2013-03-24 19:00:00 | YM | Futures | 14610.2 | 14638.5 | 14610.2 | 14628.4 | 572.0 |
| 2013-03-24 19:30:00 | YM | Futures | 14626.4 | 14663.8 | 14622.3 | 14647.6 | 1745.0 |
| 2013-03-24 20:00:00 | YM | Futures | 14646.6 | 14654.7 | 14645.6 | 14650.6 | 915.0 |
| 2013-03-24 20:30:00 | YM | Futures | 14651.6 | 14654.7 | 14641.5 | 14652.6 | 678.0 |
| 2013-03-24 21:00:00 | YM | Futures | 14651.6 | 14662.7 | 14651.6 | 14656.7 | 717.0 |
| 2013-03-24 21:30:00 | YM | Futures | 14658.7 | 14671.8 | 14657.7 | 14666.8 | 862.0 |
| 2013-03-24 22:00:00 | YM | Futures | 14666.8 | 14668.8 | 14656.7 | 14660.7 | 396.0 |
| 2013-03-24 22:30:00 | YM | Futures | 14659.7 | 14668.8 | 14656.7 | 14666.8 | 499.0 |
| 2013-03-24 23:00:00 | YM | Futures | 14667.8 | 14669.8 | 14665.8 | 14667.8 | 190.0 |
| 2013-03-24 23:30:00 | YM | Futures | 14666.8 | 14667.8 | 14658.7 | 14660.7 | 230.0 |
| 2013-03-24 18:00:00 | CL | Futures | 148.31 | 148.42 | 148.3 | 148.33 | 477.0 |
| 2013-03-24 18:30:00 | CL | Futures | 148.33 | 148.34 | 148.28 | 148.3 | 120.0 |
| 2013-03-24 19:00:00 | CL | Futures | 148.28 | 148.42 | 148.28 | 148.39 | 161.0 |
| 2013-03-24 19:30:00 | CL | Futures | 148.37 | 148.71 | 148.34 | 148.69 | 698.0 |
| 2013-03-24 20:00:00 | CL | Futures | 148.68 | 148.8 | 148.58 | 148.75 | 822.0 |
| 2013-03-24 20:30:00 | CL | Futures | 148.74 | 148.83 | 148.68 | 148.82 | 598.0 |
| 2013-03-24 21:00:00 | CL | Futures | 148.82 | 148.98 | 148.8 | 148.88 | 662.0 |
| 2013-03-24 21:30:00 | CL | Futures | 148.87 | 148.98 | 148.82 | 148.94 | 393.0 |
| 2013-03-24 22:00:00 | CL | Futures | 148.96 | 148.98 | 148.8 | 148.8 | 436.0 |
| 2013-03-24 22:30:00 | CL | Futures | 148.8 | 148.98 | 148.8 | 148.87 | 439.0 |
| 2013-03-24 23:00:00 | CL | Futures | 148.87 | 148.98 | 148.87 | 148.93 | 143.0 |
| 2013-03-24 23:30:00 | CL | Futures | 148.94 | 148.98 | 148.83 | 148.83 | 300.0 |
| 2013-03-24 18:00:00 | GC | Futures | 2212.4 | 2213.6 | 2209.6 | 2209.9 | 736.0 |
| 2013-03-24 18:30:00 | GC | Futures | 2210.5 | 2210.9 | 2209.8 | 2210.7 | 83.0 |
> showing 50 of 518 rows — these rows as CSV