PREVIEW / futures_30min / 2010-05-02
file: by_date/futures_30min/2010/2010-05-02.parquet size: 18 KB rows: 450
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.05 | 1157.6 | 1159.56 | 9967.0 |
| 2010-05-02 18:30:00 | ES | Futures | 1159.56 | 1160.29 | 1158.58 | 1160.29 | 3122.0 |
| 2010-05-02 19:00:00 | ES | Futures | 1160.29 | 1162.25 | 1160.05 | 1161.02 | 4406.0 |
| 2010-05-02 19:30:00 | ES | Futures | 1161.02 | 1162.74 | 1161.02 | 1161.51 | 3662.0 |
| 2010-05-02 20:00:00 | ES | Futures | 1161.27 | 1161.51 | 1160.05 | 1160.78 | 3108.0 |
| 2010-05-02 20:30:00 | ES | Futures | 1160.78 | 1161.02 | 1159.07 | 1159.8 | 2860.0 |
| 2010-05-02 21:00:00 | ES | Futures | 1159.8 | 1161.02 | 1159.07 | 1159.07 | 3330.0 |
| 2010-05-02 21:30:00 | ES | Futures | 1159.31 | 1159.31 | 1158.09 | 1158.58 | 3946.0 |
| 2010-05-02 22:00:00 | ES | Futures | 1158.34 | 1159.07 | 1158.09 | 1159.07 | 3272.0 |
| 2010-05-02 22:30:00 | ES | Futures | 1159.07 | 1159.56 | 1158.82 | 1158.82 | 1022.0 |
| 2010-05-02 23:00:00 | ES | Futures | 1158.82 | 1159.07 | 1158.34 | 1158.34 | 997.0 |
| 2010-05-02 23:30:00 | ES | Futures | 1158.58 | 1158.58 | 1157.85 | 1157.85 | 1820.0 |
| 2010-05-02 18:00:00 | NQ | Futures | 2293.56 | 2295.56 | 2290.98 | 2294.7 | 540.0 |
| 2010-05-02 18:30:00 | NQ | Futures | 2294.7 | 2297.85 | 2293.27 | 2297.57 | 392.0 |
| 2010-05-02 19:00:00 | NQ | Futures | 2297.85 | 2300.14 | 2297.57 | 2298.14 | 474.0 |
| 2010-05-02 19:30:00 | NQ | Futures | 2298.14 | 2300.43 | 2297.85 | 2299.0 | 278.0 |
| 2010-05-02 20:00:00 | NQ | Futures | 2299.0 | 2299.0 | 2295.85 | 2298.43 | 299.0 |
| 2010-05-02 20:30:00 | NQ | Futures | 2298.43 | 2298.43 | 2294.99 | 2296.42 | 233.0 |
| 2010-05-02 21:00:00 | NQ | Futures | 2296.71 | 2298.14 | 2295.85 | 2295.85 | 217.0 |
| 2010-05-02 21:30:00 | NQ | Futures | 2295.56 | 2295.56 | 2293.84 | 2294.13 | 264.0 |
| 2010-05-02 22:00:00 | NQ | Futures | 2294.42 | 2295.56 | 2294.42 | 2295.56 | 123.0 |
| 2010-05-02 22:30:00 | NQ | Futures | 2295.56 | 2298.43 | 2294.99 | 2295.85 | 187.0 |
| 2010-05-02 23:00:00 | NQ | Futures | 2295.85 | 2295.85 | 2294.42 | 2294.99 | 74.0 |
| 2010-05-02 23:30:00 | NQ | Futures | 2294.99 | 2294.99 | 2293.27 | 2293.56 | 81.0 |
| 2010-05-02 18:00:00 | YM | Futures | 10324.4 | 10335.7 | 10318.8 | 10330.1 | 209.0 |
| 2010-05-02 18:30:00 | YM | Futures | 10331.0 | 10341.4 | 10322.5 | 10338.5 | 218.0 |
| 2010-05-02 19:00:00 | YM | Futures | 10341.4 | 10356.4 | 10338.5 | 10348.0 | 166.0 |
| 2010-05-02 19:30:00 | YM | Futures | 10348.9 | 10356.4 | 10348.9 | 10348.9 | 174.0 |
| 2010-05-02 20:00:00 | YM | Futures | 10347.0 | 10348.9 | 10337.6 | 10346.1 | 220.0 |
| 2010-05-02 20:30:00 | YM | Futures | 10347.0 | 10347.0 | 10332.0 | 10337.6 | 197.0 |
| 2010-05-02 21:00:00 | YM | Futures | 10337.6 | 10346.1 | 10335.7 | 10336.7 | 265.0 |
| 2010-05-02 21:30:00 | YM | Futures | 10335.7 | 10335.7 | 10328.2 | 10331.0 | 153.0 |
| 2010-05-02 22:00:00 | YM | Futures | 10331.0 | 10335.7 | 10328.2 | 10335.7 | 94.0 |
| 2010-05-02 22:30:00 | YM | Futures | 10335.7 | 10337.6 | 10332.9 | 10333.8 | 85.0 |
| 2010-05-02 23:00:00 | YM | Futures | 10333.8 | 10333.8 | 10329.1 | 10329.1 | 68.0 |
| 2010-05-02 23:30:00 | YM | Futures | 10329.1 | 10330.1 | 10322.5 | 10323.5 | 139.0 |
| 2010-05-02 18:00:00 | CL | Futures | 180.28 | 181.22 | 180.28 | 181.14 | 1786.0 |
| 2010-05-02 18:30:00 | CL | Futures | 181.1 | 181.22 | 180.91 | 181.18 | 364.0 |
| 2010-05-02 19:00:00 | CL | Futures | 181.12 | 181.52 | 181.12 | 181.43 | 585.0 |
| 2010-05-02 19:30:00 | CL | Futures | 181.43 | 181.52 | 181.37 | 181.37 | 161.0 |
| 2010-05-02 20:00:00 | CL | Futures | 181.37 | 181.41 | 180.89 | 181.04 | 669.0 |
| 2010-05-02 20:30:00 | CL | Futures | 181.02 | 181.08 | 180.76 | 180.95 | 478.0 |
| 2010-05-02 21:00:00 | CL | Futures | 180.95 | 181.04 | 180.6 | 180.62 | 559.0 |
| 2010-05-02 21:30:00 | CL | Futures | 180.6 | 180.72 | 180.28 | 180.56 | 758.0 |
| 2010-05-02 22:00:00 | CL | Futures | 180.58 | 180.64 | 180.33 | 180.35 | 376.0 |
| 2010-05-02 22:30:00 | CL | Futures | 180.35 | 180.56 | 180.3 | 180.37 | 294.0 |
| 2010-05-02 23:00:00 | CL | Futures | 180.37 | 180.43 | 180.01 | 180.16 | 657.0 |
| 2010-05-02 23:30:00 | CL | Futures | 180.14 | 180.22 | 179.89 | 180.01 | 399.0 |
| 2010-05-02 18:00:00 | GC | Futures | 1660.6 | 1660.8 | 1656.6 | 1658.0 | 589.0 |
| 2010-05-02 18:30:00 | GC | Futures | 1658.5 | 1658.6 | 1655.1 | 1656.1 | 435.0 |
> showing 50 of 450 rows — these rows as CSV