PREVIEW / futures_30min / 2008-04-20
file: by_date/futures_30min/2008/2008-04-20.parquet size: 17 KB rows: 392
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-20 18:00:00 | ES | Futures | 1293.68 | 1294.15 | 1292.05 | 1292.75 | 3556.0 |
| 2008-04-20 18:30:00 | ES | Futures | 1292.75 | 1293.68 | 1292.52 | 1292.98 | 1908.0 |
| 2008-04-20 19:00:00 | ES | Futures | 1292.98 | 1294.15 | 1292.98 | 1293.21 | 492.0 |
| 2008-04-20 19:30:00 | ES | Futures | 1293.21 | 1294.15 | 1293.21 | 1294.15 | 609.0 |
| 2008-04-20 20:00:00 | ES | Futures | 1293.91 | 1294.61 | 1293.45 | 1294.61 | 745.0 |
| 2008-04-20 20:30:00 | ES | Futures | 1294.38 | 1294.61 | 1293.45 | 1294.15 | 484.0 |
| 2008-04-20 21:00:00 | ES | Futures | 1294.15 | 1294.61 | 1293.68 | 1293.91 | 635.0 |
| 2008-04-20 21:30:00 | ES | Futures | 1293.91 | 1294.15 | 1293.68 | 1294.15 | 306.0 |
| 2008-04-20 22:00:00 | ES | Futures | 1293.91 | 1294.61 | 1293.91 | 1294.38 | 424.0 |
| 2008-04-20 22:30:00 | ES | Futures | 1294.38 | 1296.01 | 1294.15 | 1295.31 | 1493.0 |
| 2008-04-20 23:00:00 | ES | Futures | 1295.31 | 1295.78 | 1295.08 | 1295.31 | 159.0 |
| 2008-04-20 23:30:00 | ES | Futures | 1295.31 | 1296.24 | 1294.84 | 1295.08 | 643.0 |
| 2008-04-20 18:00:00 | NQ | Futures | 2152.89 | 2156.0 | 2151.19 | 2152.33 | 332.0 |
| 2008-04-20 18:30:00 | NQ | Futures | 2152.61 | 2153.46 | 2152.04 | 2152.89 | 59.0 |
| 2008-04-20 19:00:00 | NQ | Futures | 2153.46 | 2154.87 | 2152.61 | 2153.46 | 90.0 |
| 2008-04-20 19:30:00 | NQ | Futures | 2154.31 | 2154.59 | 2154.02 | 2154.02 | 32.0 |
| 2008-04-20 20:00:00 | NQ | Futures | 2153.74 | 2155.44 | 2152.89 | 2153.74 | 9.0 |
| 2008-04-20 20:30:00 | NQ | Futures | 2154.02 | 2154.87 | 2153.17 | 2154.02 | 27.0 |
| 2008-04-20 21:00:00 | NQ | Futures | 2153.46 | 2154.87 | 2153.46 | 2154.87 | 29.0 |
| 2008-04-20 21:30:00 | NQ | Futures | 2153.74 | 2154.59 | 2153.46 | 2154.59 | 14.0 |
| 2008-04-20 22:00:00 | NQ | Futures | 2154.59 | 2154.87 | 2154.59 | 2154.87 | 2.0 |
| 2008-04-20 22:30:00 | NQ | Futures | 2155.15 | 2158.55 | 2155.15 | 2158.27 | 242.0 |
| 2008-04-20 23:00:00 | NQ | Futures | 2158.27 | 2159.68 | 2157.42 | 2157.98 | 85.0 |
| 2008-04-20 23:30:00 | NQ | Futures | 2157.98 | 2158.83 | 2157.7 | 2157.98 | 20.0 |
| 2008-04-20 18:00:00 | YM | Futures | 11647.1 | 11653.5 | 11639.8 | 11644.4 | 102.0 |
| 2008-04-20 18:30:00 | YM | Futures | 11646.2 | 11655.3 | 11646.2 | 11648.0 | 16.0 |
| 2008-04-20 19:00:00 | YM | Futures | 11648.0 | 11658.9 | 11646.2 | 11651.6 | 38.0 |
| 2008-04-20 19:30:00 | YM | Futures | 11653.5 | 11658.0 | 11650.7 | 11658.0 | 38.0 |
| 2008-04-20 20:00:00 | YM | Futures | 11653.5 | 11658.9 | 11650.7 | 11658.9 | 40.0 |
| 2008-04-20 20:30:00 | YM | Futures | 11658.9 | 11658.9 | 11649.8 | 11657.1 | 106.0 |
| 2008-04-20 21:00:00 | YM | Futures | 11655.3 | 11658.0 | 11652.5 | 11652.5 | 23.0 |
| 2008-04-20 21:30:00 | YM | Futures | 11652.5 | 11657.1 | 11652.5 | 11655.3 | 26.0 |
| 2008-04-20 22:00:00 | YM | Futures | 11656.2 | 11658.0 | 11652.5 | 11656.2 | 17.0 |
| 2008-04-20 22:30:00 | YM | Futures | 11654.4 | 11667.1 | 11654.4 | 11661.6 | 99.0 |
| 2008-04-20 23:00:00 | YM | Futures | 11664.4 | 11664.4 | 11658.9 | 11662.5 | 41.0 |
| 2008-04-20 23:30:00 | YM | Futures | 11661.6 | 11666.2 | 11658.9 | 11659.8 | 55.0 |
| 2008-04-20 18:00:00 | CL | Futures | 443.26 | 443.26 | 441.59 | 442.35 | 294.0 |
| 2008-04-20 18:30:00 | CL | Futures | 442.46 | 442.46 | 442.12 | 442.2 | 49.0 |
| 2008-04-20 19:00:00 | CL | Futures | 442.2 | 442.54 | 441.85 | 442.08 | 83.0 |
| 2008-04-20 19:30:00 | CL | Futures | 442.04 | 442.04 | 441.74 | 441.93 | 102.0 |
| 2008-04-20 20:00:00 | CL | Futures | 441.93 | 442.2 | 441.28 | 441.47 | 117.0 |
| 2008-04-20 20:30:00 | CL | Futures | 441.36 | 441.85 | 441.32 | 441.85 | 196.0 |
| 2008-04-20 21:00:00 | CL | Futures | 441.85 | 442.08 | 441.59 | 441.7 | 90.0 |
| 2008-04-20 21:30:00 | CL | Futures | 441.89 | 442.2 | 441.89 | 442.08 | 71.0 |
| 2008-04-20 22:00:00 | CL | Futures | 441.89 | 442.12 | 441.44 | 441.59 | 145.0 |
| 2008-04-20 22:30:00 | CL | Futures | 441.74 | 441.82 | 441.59 | 441.74 | 67.0 |
| 2008-04-20 23:00:00 | CL | Futures | 441.74 | 441.74 | 441.47 | 441.47 | 75.0 |
| 2008-04-20 23:30:00 | CL | Futures | 441.47 | 441.66 | 441.4 | 441.66 | 68.0 |
| 2008-04-20 18:00:00 | GC | Futures | 1333.1 | 1335.1 | 1333.1 | 1334.4 | 246.0 |
| 2008-04-20 18:30:00 | GC | Futures | 1334.2 | 1336.8 | 1333.9 | 1335.7 | 249.0 |
> showing 50 of 392 rows — these rows as CSV