PREVIEW / futures_30min / 2010-04-04
file: by_date/futures_30min/2010/2010-04-04.parquet size: 17 KB rows: 431
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-04 18:00:00 | ES | Futures | 1152.47 | 1154.18 | 1151.98 | 1153.2 | 8065.0 |
| 2010-04-04 18:30:00 | ES | Futures | 1153.2 | 1153.45 | 1152.96 | 1153.45 | 821.0 |
| 2010-04-04 19:00:00 | ES | Futures | 1153.69 | 1153.69 | 1152.96 | 1153.45 | 540.0 |
| 2010-04-04 19:30:00 | ES | Futures | 1153.45 | 1153.45 | 1152.23 | 1152.96 | 1259.0 |
| 2010-04-04 20:00:00 | ES | Futures | 1152.71 | 1153.2 | 1152.71 | 1152.96 | 903.0 |
| 2010-04-04 20:30:00 | ES | Futures | 1152.71 | 1153.45 | 1152.71 | 1153.2 | 1297.0 |
| 2010-04-04 21:00:00 | ES | Futures | 1153.45 | 1153.45 | 1152.71 | 1152.96 | 806.0 |
| 2010-04-04 21:30:00 | ES | Futures | 1153.2 | 1153.2 | 1152.96 | 1152.96 | 379.0 |
| 2010-04-04 22:00:00 | ES | Futures | 1152.96 | 1153.2 | 1152.71 | 1152.71 | 336.0 |
| 2010-04-04 22:30:00 | ES | Futures | 1152.71 | 1152.96 | 1152.47 | 1152.71 | 408.0 |
| 2010-04-04 23:00:00 | ES | Futures | 1152.47 | 1152.96 | 1152.47 | 1152.47 | 274.0 |
| 2010-04-04 23:30:00 | ES | Futures | 1152.71 | 1152.71 | 1152.23 | 1152.47 | 303.0 |
| 2010-04-04 18:00:00 | NQ | Futures | 2249.74 | 2252.03 | 2248.02 | 2250.32 | 594.0 |
| 2010-04-04 18:30:00 | NQ | Futures | 2250.32 | 2250.6 | 2248.88 | 2250.03 | 140.0 |
| 2010-04-04 19:00:00 | NQ | Futures | 2250.32 | 2250.6 | 2249.17 | 2250.03 | 70.0 |
| 2010-04-04 19:30:00 | NQ | Futures | 2250.32 | 2250.32 | 2248.6 | 2249.17 | 51.0 |
| 2010-04-04 20:00:00 | NQ | Futures | 2249.74 | 2250.32 | 2249.17 | 2249.17 | 84.0 |
| 2010-04-04 20:30:00 | NQ | Futures | 2249.17 | 2250.03 | 2248.6 | 2249.46 | 105.0 |
| 2010-04-04 21:00:00 | NQ | Futures | 2249.46 | 2250.32 | 2249.17 | 2250.03 | 56.0 |
| 2010-04-04 21:30:00 | NQ | Futures | 2249.74 | 2250.03 | 2249.46 | 2249.74 | 105.0 |
| 2010-04-04 22:00:00 | NQ | Futures | 2249.74 | 2249.74 | 2248.6 | 2248.88 | 54.0 |
| 2010-04-04 22:30:00 | NQ | Futures | 2248.6 | 2249.46 | 2248.31 | 2249.17 | 42.0 |
| 2010-04-04 23:00:00 | NQ | Futures | 2248.88 | 2249.74 | 2248.88 | 2249.46 | 23.0 |
| 2010-04-04 23:30:00 | NQ | Futures | 2249.46 | 2250.03 | 2249.17 | 2249.74 | 96.0 |
| 2010-04-04 18:00:00 | YM | Futures | 10254.8 | 10273.6 | 10254.8 | 10266.1 | 359.0 |
| 2010-04-04 18:30:00 | YM | Futures | 10266.1 | 10268.0 | 10263.3 | 10263.3 | 26.0 |
| 2010-04-04 19:00:00 | YM | Futures | 10264.2 | 10267.0 | 10264.2 | 10267.0 | 16.0 |
| 2010-04-04 19:30:00 | YM | Futures | 10268.0 | 10268.0 | 10259.5 | 10260.4 | 90.0 |
| 2010-04-04 20:00:00 | YM | Futures | 10261.4 | 10264.2 | 10260.4 | 10261.4 | 185.0 |
| 2010-04-04 20:30:00 | YM | Futures | 10261.4 | 10267.0 | 10259.5 | 10263.3 | 190.0 |
| 2010-04-04 21:00:00 | YM | Futures | 10263.3 | 10266.1 | 10262.3 | 10264.2 | 67.0 |
| 2010-04-04 21:30:00 | YM | Futures | 10264.2 | 10265.1 | 10263.3 | 10264.2 | 30.0 |
| 2010-04-04 22:00:00 | YM | Futures | 10264.2 | 10265.1 | 10261.4 | 10263.3 | 35.0 |
| 2010-04-04 22:30:00 | YM | Futures | 10261.4 | 10263.3 | 10259.5 | 10259.5 | 49.0 |
| 2010-04-04 23:00:00 | YM | Futures | 10259.5 | 10263.3 | 10257.6 | 10258.6 | 69.0 |
| 2010-04-04 23:30:00 | YM | Futures | 10258.6 | 10262.3 | 10257.6 | 10261.4 | 36.0 |
| 2010-04-04 18:00:00 | CL | Futures | 180.57 | 181.12 | 180.54 | 181.01 | 1014.0 |
| 2010-04-04 18:30:00 | CL | Futures | 181.01 | 181.35 | 181.01 | 181.14 | 593.0 |
| 2010-04-04 19:00:00 | CL | Futures | 181.12 | 181.28 | 181.07 | 181.16 | 240.0 |
| 2010-04-04 19:30:00 | CL | Futures | 181.14 | 181.31 | 181.01 | 181.07 | 225.0 |
| 2010-04-04 20:00:00 | CL | Futures | 181.07 | 181.26 | 181.03 | 181.2 | 368.0 |
| 2010-04-04 20:30:00 | CL | Futures | 181.22 | 181.79 | 181.2 | 181.52 | 1021.0 |
| 2010-04-04 21:00:00 | CL | Futures | 181.52 | 181.58 | 181.35 | 181.39 | 273.0 |
| 2010-04-04 21:30:00 | CL | Futures | 181.37 | 181.43 | 181.2 | 181.31 | 472.0 |
| 2010-04-04 22:00:00 | CL | Futures | 181.28 | 181.28 | 180.92 | 181.2 | 608.0 |
| 2010-04-04 22:30:00 | CL | Futures | 181.22 | 181.39 | 181.2 | 181.35 | 365.0 |
| 2010-04-04 23:00:00 | CL | Futures | 181.35 | 181.41 | 181.28 | 181.28 | 133.0 |
| 2010-04-04 23:30:00 | CL | Futures | 181.31 | 181.41 | 181.31 | 181.39 | 152.0 |
| 2010-04-04 18:00:00 | GC | Futures | 1577.6 | 1582.2 | 1575.9 | 1580.7 | 1624.0 |
| 2010-04-04 18:30:00 | GC | Futures | 1580.8 | 1584.8 | 1580.8 | 1583.2 | 739.0 |
> showing 50 of 431 rows — these rows as CSV