PREVIEW / futures_1hour / 2010-04-18
file: by_date/futures_1hour/2010/2010-04-18.parquet size: 14 KB rows: 249
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-18 18:00:00 | ES | Futures | 1159.56 | 1160.78 | 1159.31 | 1159.8 | 16387.0 |
| 2010-04-18 19:00:00 | ES | Futures | 1159.8 | 1160.54 | 1159.31 | 1160.54 | 6578.0 |
| 2010-04-18 20:00:00 | ES | Futures | 1160.54 | 1162.49 | 1160.05 | 1160.78 | 10988.0 |
| 2010-04-18 21:00:00 | ES | Futures | 1161.02 | 1161.51 | 1159.56 | 1160.29 | 6471.0 |
| 2010-04-18 22:00:00 | ES | Futures | 1160.05 | 1160.78 | 1159.8 | 1160.78 | 2621.0 |
| 2010-04-18 23:00:00 | ES | Futures | 1160.54 | 1160.78 | 1158.58 | 1158.58 | 7093.0 |
| 2010-04-18 18:00:00 | NQ | Futures | 2296.14 | 2298.14 | 2295.28 | 2296.14 | 1164.0 |
| 2010-04-18 19:00:00 | NQ | Futures | 2296.14 | 2297.28 | 2295.28 | 2296.42 | 293.0 |
| 2010-04-18 20:00:00 | NQ | Futures | 2296.71 | 2300.14 | 2296.42 | 2297.28 | 866.0 |
| 2010-04-18 21:00:00 | NQ | Futures | 2296.99 | 2298.43 | 2295.85 | 2296.71 | 561.0 |
| 2010-04-18 22:00:00 | NQ | Futures | 2296.99 | 2297.85 | 2296.14 | 2297.57 | 197.0 |
| 2010-04-18 23:00:00 | NQ | Futures | 2297.57 | 2297.57 | 2292.7 | 2293.84 | 1531.0 |
| 2010-04-18 18:00:00 | YM | Futures | 10308.4 | 10310.3 | 10270.8 | 10302.8 | 690.0 |
| 2010-04-18 19:00:00 | YM | Futures | 10301.8 | 10306.6 | 10296.2 | 10302.8 | 275.0 |
| 2010-04-18 20:00:00 | YM | Futures | 10302.8 | 10317.8 | 10301.8 | 10305.6 | 869.0 |
| 2010-04-18 21:00:00 | YM | Futures | 10305.6 | 10309.4 | 10297.1 | 10299.0 | 670.0 |
| 2010-04-18 22:00:00 | YM | Futures | 10299.0 | 10304.7 | 10297.1 | 10302.8 | 318.0 |
| 2010-04-18 23:00:00 | YM | Futures | 10302.8 | 10303.7 | 10283.0 | 10287.7 | 1184.0 |
| 2010-04-18 18:00:00 | CL | Futures | 176.67 | 176.67 | 175.22 | 175.43 | 2009.0 |
| 2010-04-18 19:00:00 | CL | Futures | 175.43 | 175.89 | 175.43 | 175.62 | 1208.0 |
| 2010-04-18 20:00:00 | CL | Futures | 175.62 | 175.77 | 175.43 | 175.43 | 1104.0 |
| 2010-04-18 21:00:00 | CL | Futures | 175.41 | 175.45 | 174.36 | 174.76 | 2921.0 |
| 2010-04-18 22:00:00 | CL | Futures | 174.74 | 174.87 | 174.24 | 174.43 | 1103.0 |
| 2010-04-18 23:00:00 | CL | Futures | 174.41 | 175.08 | 174.32 | 174.85 | 1564.0 |
| 2010-04-18 18:00:00 | GC | Futures | 1598.7 | 1598.7 | 1594.8 | 1595.7 | 1406.0 |
| 2010-04-18 19:00:00 | GC | Futures | 1595.9 | 1600.5 | 1595.7 | 1600.0 | 1265.0 |
| 2010-04-18 20:00:00 | GC | Futures | 1599.8 | 1600.8 | 1597.8 | 1598.0 | 2114.0 |
| 2010-04-18 21:00:00 | GC | Futures | 1598.0 | 1600.0 | 1596.3 | 1599.3 | 2538.0 |
| 2010-04-18 22:00:00 | GC | Futures | 1599.3 | 1599.4 | 1597.0 | 1598.3 | 990.0 |
| 2010-04-18 23:00:00 | GC | Futures | 1598.6 | 1599.0 | 1597.6 | 1598.8 | 502.0 |
| 2010-04-18 18:00:00 | ZN | Futures | 96.357552 | 96.408942 | 96.331856 | 96.383247 | 3623.0 |
| 2010-04-18 19:00:00 | ZN | Futures | 96.383247 | 96.550267 | 96.383247 | 96.460333 | 9405.0 |
| 2010-04-18 20:00:00 | ZN | Futures | 96.473181 | 96.486029 | 96.319009 | 96.344704 | 9777.0 |
| 2010-04-18 21:00:00 | ZN | Futures | 96.331856 | 96.408942 | 96.331856 | 96.383247 | 5403.0 |
| 2010-04-18 22:00:00 | ZN | Futures | 96.396095 | 96.396095 | 96.357552 | 96.370399 | 2311.0 |
| 2010-04-18 23:00:00 | ZN | Futures | 96.370399 | 96.396095 | 96.370399 | 96.383247 | 1793.0 |
> showing 36 of 249 rows — these rows as CSV