PREVIEW / futures_1hour / 2011-05-15
file: by_date/futures_1hour/2011/2011-05-15.parquet size: 14 KB rows: 264
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-15 18:00:00 | ES | Futures | 1323.64 | 1323.64 | 1320.16 | 1321.65 | 13870.0 |
| 2011-05-15 19:00:00 | ES | Futures | 1321.65 | 1323.39 | 1318.42 | 1319.41 | 11528.0 |
| 2011-05-15 20:00:00 | ES | Futures | 1319.41 | 1321.4 | 1318.92 | 1319.17 | 9865.0 |
| 2011-05-15 21:00:00 | ES | Futures | 1318.92 | 1321.65 | 1318.92 | 1320.91 | 10523.0 |
| 2011-05-15 22:00:00 | ES | Futures | 1320.91 | 1321.4 | 1319.17 | 1319.91 | 3538.0 |
| 2011-05-15 23:00:00 | ES | Futures | 1320.16 | 1320.16 | 1318.67 | 1319.91 | 4808.0 |
| 2011-05-15 18:00:00 | NQ | Futures | 2719.15 | 2722.02 | 2713.69 | 2717.42 | 2738.0 |
| 2011-05-15 19:00:00 | NQ | Futures | 2717.14 | 2720.3 | 2711.68 | 2713.69 | 1133.0 |
| 2011-05-15 20:00:00 | NQ | Futures | 2713.69 | 2717.14 | 2712.25 | 2712.54 | 794.0 |
| 2011-05-15 21:00:00 | NQ | Futures | 2713.11 | 2717.71 | 2712.54 | 2716.85 | 728.0 |
| 2011-05-15 22:00:00 | NQ | Futures | 2716.56 | 2718.0 | 2713.69 | 2714.84 | 428.0 |
| 2011-05-15 23:00:00 | NQ | Futures | 2714.84 | 2716.27 | 2713.11 | 2715.12 | 543.0 |
| 2011-05-15 18:00:00 | YM | Futures | 12073.6 | 12088.0 | 12050.4 | 12055.3 | 577.0 |
| 2011-05-15 19:00:00 | YM | Futures | 12060.1 | 12075.5 | 12029.3 | 12046.6 | 821.0 |
| 2011-05-15 20:00:00 | YM | Futures | 12045.6 | 12059.1 | 12040.8 | 12040.8 | 335.0 |
| 2011-05-15 21:00:00 | YM | Futures | 12040.8 | 12060.1 | 12039.8 | 12055.3 | 308.0 |
| 2011-05-15 22:00:00 | YM | Futures | 12052.4 | 12061.0 | 12041.8 | 12048.5 | 143.0 |
| 2011-05-15 23:00:00 | YM | Futures | 12049.5 | 12050.4 | 12040.8 | 12049.5 | 154.0 |
| 2011-05-15 18:00:00 | CL | Futures | 172.15 | 172.18 | 170.53 | 170.6 | 418.0 |
| 2011-05-15 19:00:00 | CL | Futures | 170.77 | 171.27 | 170.5 | 170.58 | 372.0 |
| 2011-05-15 20:00:00 | CL | Futures | 170.58 | 171.24 | 170.32 | 170.39 | 231.0 |
| 2011-05-15 21:00:00 | CL | Futures | 170.5 | 170.77 | 170.22 | 170.75 | 142.0 |
| 2011-05-15 22:00:00 | CL | Futures | 170.65 | 171.34 | 170.63 | 170.91 | 158.0 |
| 2011-05-15 23:00:00 | CL | Futures | 170.87 | 171.27 | 170.84 | 170.98 | 91.0 |
| 2011-05-15 18:00:00 | GC | Futures | 2086.1 | 2086.4 | 2074.1 | 2077.7 | 1347.0 |
| 2011-05-15 19:00:00 | GC | Futures | 2077.7 | 2083.9 | 2077.6 | 2082.2 | 962.0 |
| 2011-05-15 20:00:00 | GC | Futures | 2082.0 | 2084.8 | 2078.1 | 2078.1 | 1891.0 |
| 2011-05-15 21:00:00 | GC | Futures | 2078.6 | 2080.5 | 2077.2 | 2079.0 | 1973.0 |
| 2011-05-15 22:00:00 | GC | Futures | 2079.0 | 2081.8 | 2078.6 | 2080.9 | 1028.0 |
| 2011-05-15 23:00:00 | GC | Futures | 2080.8 | 2082.3 | 2080.1 | 2081.5 | 595.0 |
| 2011-05-15 18:00:00 | ZN | Futures | 104.430518 | 104.497034 | 104.403911 | 104.497034 | 4821.0 |
| 2011-05-15 19:00:00 | ZN | Futures | 104.497034 | 104.510337 | 104.457124 | 104.497034 | 6547.0 |
| 2011-05-15 20:00:00 | ZN | Futures | 104.497034 | 104.523641 | 104.470428 | 104.523641 | 6111.0 |
| 2011-05-15 21:00:00 | ZN | Futures | 104.510337 | 104.536944 | 104.483731 | 104.483731 | 4750.0 |
| 2011-05-15 22:00:00 | ZN | Futures | 104.497034 | 104.523641 | 104.470428 | 104.523641 | 3645.0 |
| 2011-05-15 23:00:00 | ZN | Futures | 104.523641 | 104.523641 | 104.497034 | 104.523641 | 1587.0 |
> showing 36 of 264 rows — these rows as CSV