PREVIEW / futures_1hour / 2010-05-02
file: by_date/futures_1hour/2010/2010-05-02.parquet size: 13 KB rows: 247
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-05-02 18:00:00 | ES | Futures | 1158.09 | 1160.29 | 1157.6 | 1160.29 | 13089.0 |
| 2010-05-02 19:00:00 | ES | Futures | 1160.29 | 1162.74 | 1160.05 | 1161.51 | 8068.0 |
| 2010-05-02 20:00:00 | ES | Futures | 1161.27 | 1161.51 | 1159.07 | 1159.8 | 5968.0 |
| 2010-05-02 21:00:00 | ES | Futures | 1159.8 | 1161.02 | 1158.09 | 1158.58 | 7276.0 |
| 2010-05-02 22:00:00 | ES | Futures | 1158.34 | 1159.56 | 1158.09 | 1158.82 | 4294.0 |
| 2010-05-02 23:00:00 | ES | Futures | 1158.82 | 1159.07 | 1157.85 | 1157.85 | 2817.0 |
| 2010-05-02 18:00:00 | NQ | Futures | 2293.56 | 2297.85 | 2290.98 | 2297.57 | 932.0 |
| 2010-05-02 19:00:00 | NQ | Futures | 2297.85 | 2300.43 | 2297.57 | 2299.0 | 752.0 |
| 2010-05-02 20:00:00 | NQ | Futures | 2299.0 | 2299.0 | 2294.99 | 2296.42 | 532.0 |
| 2010-05-02 21:00:00 | NQ | Futures | 2296.71 | 2298.14 | 2293.84 | 2294.13 | 481.0 |
| 2010-05-02 22:00:00 | NQ | Futures | 2294.42 | 2298.43 | 2294.42 | 2295.85 | 310.0 |
| 2010-05-02 23:00:00 | NQ | Futures | 2295.85 | 2295.85 | 2293.27 | 2293.56 | 155.0 |
| 2010-05-02 18:00:00 | YM | Futures | 10324.4 | 10341.4 | 10318.8 | 10338.5 | 427.0 |
| 2010-05-02 19:00:00 | YM | Futures | 10341.4 | 10356.4 | 10338.5 | 10348.9 | 340.0 |
| 2010-05-02 20:00:00 | YM | Futures | 10347.0 | 10348.9 | 10332.0 | 10337.6 | 417.0 |
| 2010-05-02 21:00:00 | YM | Futures | 10337.6 | 10346.1 | 10328.2 | 10331.0 | 418.0 |
| 2010-05-02 22:00:00 | YM | Futures | 10331.0 | 10337.6 | 10328.2 | 10333.8 | 179.0 |
| 2010-05-02 23:00:00 | YM | Futures | 10333.8 | 10333.8 | 10322.5 | 10323.5 | 207.0 |
| 2010-05-02 18:00:00 | CL | Futures | 180.28 | 181.22 | 180.28 | 181.18 | 2150.0 |
| 2010-05-02 19:00:00 | CL | Futures | 181.12 | 181.52 | 181.12 | 181.37 | 746.0 |
| 2010-05-02 20:00:00 | CL | Futures | 181.37 | 181.41 | 180.76 | 180.95 | 1147.0 |
| 2010-05-02 21:00:00 | CL | Futures | 180.95 | 181.04 | 180.28 | 180.56 | 1317.0 |
| 2010-05-02 22:00:00 | CL | Futures | 180.58 | 180.64 | 180.3 | 180.37 | 670.0 |
| 2010-05-02 23:00:00 | CL | Futures | 180.37 | 180.43 | 179.89 | 180.01 | 1056.0 |
| 2010-05-02 18:00:00 | GC | Futures | 1660.6 | 1660.8 | 1655.1 | 1656.1 | 1024.0 |
| 2010-05-02 19:00:00 | GC | Futures | 1656.1 | 1659.4 | 1655.9 | 1656.6 | 629.0 |
| 2010-05-02 20:00:00 | GC | Futures | 1656.9 | 1659.6 | 1656.2 | 1657.5 | 993.0 |
| 2010-05-02 21:00:00 | GC | Futures | 1657.5 | 1657.9 | 1655.1 | 1656.3 | 1078.0 |
| 2010-05-02 22:00:00 | GC | Futures | 1656.5 | 1658.3 | 1655.4 | 1657.0 | 674.0 |
| 2010-05-02 23:00:00 | GC | Futures | 1656.9 | 1657.5 | 1655.8 | 1656.2 | 191.0 |
| 2010-05-02 18:00:00 | ZN | Futures | 96.871459 | 96.871459 | 96.794373 | 96.820068 | 3122.0 |
| 2010-05-02 19:00:00 | ZN | Futures | 96.80722 | 96.80722 | 96.678744 | 96.717287 | 6100.0 |
| 2010-05-02 20:00:00 | ZN | Futures | 96.717287 | 96.794373 | 96.691591 | 96.794373 | 4548.0 |
| 2010-05-02 21:00:00 | ZN | Futures | 96.794373 | 96.80722 | 96.781525 | 96.781525 | 1875.0 |
| 2010-05-02 22:00:00 | ZN | Futures | 96.794373 | 96.80722 | 96.781525 | 96.80722 | 1022.0 |
| 2010-05-02 23:00:00 | ZN | Futures | 96.794373 | 96.820068 | 96.794373 | 96.80722 | 391.0 |
> showing 36 of 247 rows — these rows as CSV