PREVIEW / etf_5min / 2008-07-11
file: by_date/etf_5min/2008/2008-07-11.parquet size: 556 KB rows: 25,162
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-07-11 04:15:00 | SPY | ETF | 124.99 | 124.99 | 124.99 | 124.99 | 500.0 |
| 2008-07-11 04:20:00 | SPY | ETF | 125.0 | 125.0 | 125.0 | 125.0 | 2000.0 |
| 2008-07-11 04:40:00 | SPY | ETF | 125.32 | 125.32 | 125.32 | 125.32 | 100.0 |
| 2008-07-11 04:55:00 | SPY | ETF | 125.16 | 125.16 | 125.16 | 125.16 | 100.0 |
| 2008-07-11 05:05:00 | SPY | ETF | 125.07 | 125.07 | 125.05 | 125.05 | 25000.0 |
| 2008-07-11 05:40:00 | SPY | ETF | 124.99 | 125.07 | 124.99 | 125.07 | 2000.0 |
| 2008-07-11 05:45:00 | SPY | ETF | 125.0 | 125.0 | 125.0 | 125.0 | 11300.0 |
| 2008-07-11 05:50:00 | SPY | ETF | 124.98 | 124.98 | 124.97 | 124.97 | 2500.0 |
| 2008-07-11 05:55:00 | SPY | ETF | 124.86 | 124.86 | 124.85 | 124.85 | 1400.0 |
| 2008-07-11 06:00:00 | SPY | ETF | 124.86 | 124.86 | 124.86 | 124.86 | 200.0 |
| 2008-07-11 06:05:00 | SPY | ETF | 124.59 | 124.59 | 124.48 | 124.51 | 6400.0 |
| 2008-07-11 06:10:00 | SPY | ETF | 124.38 | 124.56 | 124.38 | 124.55 | 8000.0 |
| 2008-07-11 06:15:00 | SPY | ETF | 124.53 | 124.55 | 124.47 | 124.51 | 31500.0 |
| 2008-07-11 06:20:00 | SPY | ETF | 124.52 | 124.7 | 124.52 | 124.7 | 35100.0 |
| 2008-07-11 06:25:00 | SPY | ETF | 124.72 | 124.72 | 124.56 | 124.58 | 2100.0 |
| 2008-07-11 06:30:00 | SPY | ETF | 124.72 | 125.0 | 124.63 | 124.83 | 75100.0 |
| 2008-07-11 06:35:00 | SPY | ETF | 124.84 | 125.04 | 124.79 | 124.79 | 82800.0 |
| 2008-07-11 06:40:00 | SPY | ETF | 124.74 | 124.76 | 124.49 | 124.61 | 125900.0 |
| 2008-07-11 06:45:00 | SPY | ETF | 124.51 | 124.57 | 124.46 | 124.49 | 131600.0 |
| 2008-07-11 06:50:00 | SPY | ETF | 124.53 | 124.56 | 124.3 | 124.56 | 32100.0 |
| 2008-07-11 06:55:00 | SPY | ETF | 124.55 | 124.66 | 124.44 | 124.66 | 19800.0 |
| 2008-07-11 07:00:00 | SPY | ETF | 124.63 | 124.7 | 124.59 | 124.65 | 61000.0 |
| 2008-07-11 07:05:00 | SPY | ETF | 124.65 | 124.65 | 124.44 | 124.46 | 348509.0 |
| 2008-07-11 07:10:00 | SPY | ETF | 124.49 | 124.49 | 124.1 | 124.12 | 142259.0 |
| 2008-07-11 07:15:00 | SPY | ETF | 124.14 | 124.14 | 123.92 | 124.11 | 545552.0 |
| 2008-07-11 07:20:00 | SPY | ETF | 124.11 | 124.27 | 124.09 | 124.25 | 247000.0 |
| 2008-07-11 07:25:00 | SPY | ETF | 124.19 | 124.31 | 124.1 | 124.25 | 222900.0 |
| 2008-07-11 07:30:00 | SPY | ETF | 124.27 | 124.4 | 124.1 | 124.11 | 420171.0 |
| 2008-07-11 07:35:00 | SPY | ETF | 124.16 | 124.35 | 124.14 | 124.33 | 172910.0 |
| 2008-07-11 07:40:00 | SPY | ETF | 124.33 | 124.34 | 124.05 | 124.05 | 381598.0 |
| 2008-07-11 07:45:00 | SPY | ETF | 124.07 | 124.09 | 123.74 | 123.85 | 643493.0 |
| 2008-07-11 07:50:00 | SPY | ETF | 123.85 | 124.08 | 123.84 | 124.01 | 523594.0 |
| 2008-07-11 07:55:00 | SPY | ETF | 124.0 | 124.11 | 123.89 | 124.1 | 102340.0 |
| 2008-07-11 08:00:00 | SPY | ETF | 124.1 | 125.5 | 123.75 | 124.21 | 2297072.0 |
| 2008-07-11 08:05:00 | SPY | ETF | 124.21 | 126.0 | 124.0 | 124.09 | 322136.0 |
| 2008-07-11 08:10:00 | SPY | ETF | 124.09 | 124.11 | 123.96 | 124.0 | 167801.0 |
| 2008-07-11 08:15:00 | SPY | ETF | 123.98 | 124.08 | 123.74 | 123.77 | 432794.0 |
| 2008-07-11 08:20:00 | SPY | ETF | 123.78 | 123.89 | 123.77 | 123.8 | 458022.0 |
| 2008-07-11 08:25:00 | SPY | ETF | 123.81 | 123.85 | 123.63 | 123.83 | 1033537.0 |
| 2008-07-11 08:30:00 | SPY | ETF | 123.78 | 124.0 | 123.66 | 123.75 | 771062.0 |
| 2008-07-11 08:35:00 | SPY | ETF | 123.78 | 123.94 | 123.73 | 123.77 | 235970.0 |
| 2008-07-11 08:40:00 | SPY | ETF | 123.76 | 123.9 | 123.75 | 123.82 | 482822.0 |
| 2008-07-11 08:45:00 | SPY | ETF | 123.82 | 123.97 | 123.75 | 123.97 | 596537.0 |
| 2008-07-11 08:50:00 | SPY | ETF | 123.97 | 124.03 | 123.85 | 123.9 | 473830.0 |
| 2008-07-11 08:55:00 | SPY | ETF | 123.89 | 123.9 | 123.81 | 123.83 | 285793.0 |
| 2008-07-11 09:00:00 | SPY | ETF | 123.82 | 123.82 | 123.6 | 123.73 | 874835.0 |
| 2008-07-11 09:05:00 | SPY | ETF | 123.75 | 123.78 | 123.62 | 123.75 | 377736.0 |
| 2008-07-11 09:10:00 | SPY | ETF | 123.75 | 124.1 | 123.75 | 124.02 | 1178970.0 |
| 2008-07-11 09:15:00 | SPY | ETF | 124.01 | 124.07 | 123.95 | 123.95 | 255533.0 |
| 2008-07-11 09:20:00 | SPY | ETF | 123.94 | 124.08 | 123.87 | 123.91 | 1096712.0 |
> showing 50 of 25,162 rows — these rows as CSV