PREVIEW / futures_1hour / 2017-10-15
file: by_date/futures_1hour/2017/2017-10-15.parquet size: 14 KB rows: 288
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 |
|---|---|---|---|---|---|---|---|
| 2017-10-15 18:00:00 | ES | Futures | 2792.76 | 2796.04 | 2792.76 | 2795.77 | 6360.0 |
| 2017-10-15 19:00:00 | ES | Futures | 2795.77 | 2795.77 | 2794.67 | 2794.95 | 1490.0 |
| 2017-10-15 20:00:00 | ES | Futures | 2794.95 | 2796.32 | 2794.4 | 2796.04 | 6518.0 |
| 2017-10-15 21:00:00 | ES | Futures | 2796.04 | 2796.04 | 2794.95 | 2795.5 | 3714.0 |
| 2017-10-15 22:00:00 | ES | Futures | 2795.77 | 2797.41 | 2795.5 | 2796.59 | 5886.0 |
| 2017-10-15 23:00:00 | ES | Futures | 2796.59 | 2796.86 | 2796.04 | 2796.04 | 2050.0 |
| 2017-10-15 18:00:00 | NQ | Futures | 7258.75 | 7265.59 | 7255.77 | 7264.1 | 1902.0 |
| 2017-10-15 19:00:00 | NQ | Futures | 7264.1 | 7264.99 | 7262.91 | 7263.21 | 557.0 |
| 2017-10-15 20:00:00 | NQ | Futures | 7263.21 | 7268.56 | 7261.72 | 7266.78 | 1464.0 |
| 2017-10-15 21:00:00 | NQ | Futures | 7266.48 | 7268.26 | 7265.59 | 7267.67 | 1123.0 |
| 2017-10-15 22:00:00 | NQ | Futures | 7267.67 | 7274.81 | 7267.37 | 7273.02 | 1839.0 |
| 2017-10-15 23:00:00 | NQ | Futures | 7273.02 | 7273.62 | 7270.94 | 7271.24 | 778.0 |
| 2017-10-15 18:00:00 | YM | Futures | 24826.4 | 24850.3 | 24822.0 | 24844.9 | 865.0 |
| 2017-10-15 19:00:00 | YM | Futures | 24844.9 | 24849.2 | 24842.7 | 24843.8 | 644.0 |
| 2017-10-15 20:00:00 | YM | Futures | 24843.8 | 24865.6 | 24841.6 | 24855.8 | 1268.0 |
| 2017-10-15 21:00:00 | YM | Futures | 24855.8 | 24857.9 | 24851.4 | 24857.9 | 1147.0 |
| 2017-10-15 22:00:00 | YM | Futures | 24857.9 | 24873.2 | 24857.9 | 24867.7 | 1147.0 |
| 2017-10-15 23:00:00 | YM | Futures | 24867.7 | 24868.8 | 24859.0 | 24860.1 | 587.0 |
| 2017-10-15 18:00:00 | CL | Futures | 46.03 | 46.54 | 45.97 | 46.41 | 2506.0 |
| 2017-10-15 19:00:00 | CL | Futures | 46.4 | 46.46 | 46.31 | 46.44 | 1342.0 |
| 2017-10-15 20:00:00 | CL | Futures | 46.44 | 46.49 | 46.4 | 46.47 | 1339.0 |
| 2017-10-15 21:00:00 | CL | Futures | 46.47 | 46.48 | 46.39 | 46.39 | 1029.0 |
| 2017-10-15 22:00:00 | CL | Futures | 46.4 | 46.47 | 46.39 | 46.44 | 1094.0 |
| 2017-10-15 23:00:00 | CL | Futures | 46.44 | 46.48 | 46.42 | 46.44 | 1500.0 |
| 2017-10-15 18:00:00 | GC | Futures | 1739.8 | 1739.9 | 1737.3 | 1737.5 | 2604.0 |
| 2017-10-15 19:00:00 | GC | Futures | 1737.5 | 1740.7 | 1737.4 | 1740.6 | 3493.0 |
| 2017-10-15 20:00:00 | GC | Futures | 1740.6 | 1741.0 | 1738.1 | 1738.1 | 4258.0 |
| 2017-10-15 21:00:00 | GC | Futures | 1738.2 | 1738.9 | 1736.1 | 1737.1 | 8192.0 |
| 2017-10-15 22:00:00 | GC | Futures | 1737.3 | 1738.5 | 1736.6 | 1738.2 | 5245.0 |
| 2017-10-15 23:00:00 | GC | Futures | 1738.3 | 1738.5 | 1737.1 | 1738.1 | 2881.0 |
| 2017-10-15 18:00:00 | ZN | Futures | 125.201004 | 125.201004 | 125.076519 | 125.09208 | 12620.0 |
| 2017-10-15 19:00:00 | ZN | Futures | 125.09208 | 125.123201 | 125.09208 | 125.123201 | 6559.0 |
| 2017-10-15 20:00:00 | ZN | Futures | 125.123201 | 125.154323 | 125.107641 | 125.107641 | 12619.0 |
| 2017-10-15 21:00:00 | ZN | Futures | 125.107641 | 125.154323 | 125.107641 | 125.123201 | 7751.0 |
| 2017-10-15 22:00:00 | ZN | Futures | 125.123201 | 125.123201 | 125.045398 | 125.09208 | 13133.0 |
| 2017-10-15 23:00:00 | ZN | Futures | 125.09208 | 125.138762 | 125.076519 | 125.138762 | 9823.0 |
> showing 36 of 288 rows — these rows as CSV