PREVIEW / etf_5min / 2008-11-10
file: by_date/etf_5min/2008/2008-11-10.parquet size: 533 KB rows: 24,588
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-11-10 04:10:00 | SPY | ETF | 95.81 | 95.81 | 95.73 | 95.73 | 3000.0 |
| 2008-11-10 04:15:00 | SPY | ETF | 95.69 | 95.77 | 95.69 | 95.77 | 3257.0 |
| 2008-11-10 04:20:00 | SPY | ETF | 95.74 | 95.8 | 95.74 | 95.8 | 1700.0 |
| 2008-11-10 04:25:00 | SPY | ETF | 95.79 | 95.88 | 95.79 | 95.88 | 300.0 |
| 2008-11-10 04:35:00 | SPY | ETF | 95.86 | 95.86 | 95.86 | 95.86 | 1000.0 |
| 2008-11-10 04:40:00 | SPY | ETF | 95.91 | 95.91 | 95.91 | 95.91 | 100.0 |
| 2008-11-10 04:45:00 | SPY | ETF | 96.0 | 96.0 | 96.0 | 96.0 | 400.0 |
| 2008-11-10 04:50:00 | SPY | ETF | 96.0 | 96.03 | 96.0 | 96.02 | 500.0 |
| 2008-11-10 04:55:00 | SPY | ETF | 95.92 | 95.93 | 95.92 | 95.93 | 2000.0 |
| 2008-11-10 05:05:00 | SPY | ETF | 95.85 | 95.85 | 95.85 | 95.85 | 550.0 |
| 2008-11-10 05:10:00 | SPY | ETF | 96.0 | 96.03 | 96.0 | 96.03 | 248.0 |
| 2008-11-10 05:20:00 | SPY | ETF | 96.06 | 96.24 | 96.06 | 96.24 | 625.0 |
| 2008-11-10 05:25:00 | SPY | ETF | 96.32 | 96.34 | 96.31 | 96.32 | 10100.0 |
| 2008-11-10 05:30:00 | SPY | ETF | 96.36 | 96.5 | 96.36 | 96.5 | 400.0 |
| 2008-11-10 05:35:00 | SPY | ETF | 96.55 | 96.55 | 96.52 | 96.52 | 500.0 |
| 2008-11-10 05:40:00 | SPY | ETF | 96.45 | 96.45 | 96.36 | 96.36 | 200.0 |
| 2008-11-10 05:50:00 | SPY | ETF | 96.41 | 96.41 | 96.34 | 96.34 | 5500.0 |
| 2008-11-10 05:55:00 | SPY | ETF | 96.34 | 96.35 | 96.3 | 96.35 | 20600.0 |
| 2008-11-10 06:05:00 | SPY | ETF | 96.33 | 96.33 | 96.33 | 96.33 | 100.0 |
| 2008-11-10 06:10:00 | SPY | ETF | 96.24 | 96.39 | 96.24 | 96.39 | 2100.0 |
| 2008-11-10 06:15:00 | SPY | ETF | 96.46 | 96.46 | 96.31 | 96.31 | 1000.0 |
| 2008-11-10 06:20:00 | SPY | ETF | 96.33 | 96.41 | 96.27 | 96.27 | 26900.0 |
| 2008-11-10 06:25:00 | SPY | ETF | 96.24 | 96.24 | 96.24 | 96.24 | 300.0 |
| 2008-11-10 06:30:00 | SPY | ETF | 96.2 | 96.2 | 96.19 | 96.2 | 5200.0 |
| 2008-11-10 06:40:00 | SPY | ETF | 96.3 | 96.3 | 96.2 | 96.3 | 7800.0 |
| 2008-11-10 06:45:00 | SPY | ETF | 96.37 | 96.37 | 96.12 | 96.14 | 14000.0 |
| 2008-11-10 06:50:00 | SPY | ETF | 96.17 | 96.17 | 96.17 | 96.17 | 500.0 |
| 2008-11-10 06:55:00 | SPY | ETF | 96.1 | 96.1 | 95.96 | 95.96 | 2200.0 |
| 2008-11-10 07:00:00 | SPY | ETF | 95.96 | 96.0 | 95.88 | 95.91 | 24835.0 |
| 2008-11-10 07:05:00 | SPY | ETF | 95.88 | 95.9 | 95.8 | 95.85 | 127625.0 |
| 2008-11-10 07:10:00 | SPY | ETF | 95.87 | 95.94 | 95.82 | 95.83 | 34852.0 |
| 2008-11-10 07:15:00 | SPY | ETF | 95.83 | 95.83 | 95.63 | 95.72 | 75100.0 |
| 2008-11-10 07:20:00 | SPY | ETF | 95.69 | 95.75 | 95.64 | 95.64 | 56125.0 |
| 2008-11-10 07:25:00 | SPY | ETF | 95.63 | 95.69 | 95.43 | 95.54 | 196960.0 |
| 2008-11-10 07:30:00 | SPY | ETF | 95.48 | 95.62 | 95.48 | 95.6 | 42010.0 |
| 2008-11-10 07:35:00 | SPY | ETF | 95.6 | 95.74 | 95.58 | 95.67 | 79900.0 |
| 2008-11-10 07:40:00 | SPY | ETF | 95.62 | 95.75 | 95.6 | 95.75 | 38100.0 |
| 2008-11-10 07:45:00 | SPY | ETF | 95.77 | 95.8 | 95.73 | 95.78 | 23282.0 |
| 2008-11-10 07:50:00 | SPY | ETF | 95.8 | 95.81 | 95.7 | 95.79 | 284273.0 |
| 2008-11-10 07:55:00 | SPY | ETF | 95.79 | 95.9 | 95.74 | 95.89 | 183991.0 |
| 2008-11-10 08:00:00 | SPY | ETF | 95.9 | 96.3 | 95.6 | 95.9 | 1816083.0 |
| 2008-11-10 08:05:00 | SPY | ETF | 95.9 | 95.95 | 95.87 | 95.9 | 132322.0 |
| 2008-11-10 08:10:00 | SPY | ETF | 95.91 | 95.91 | 95.8 | 95.81 | 66379.0 |
| 2008-11-10 08:15:00 | SPY | ETF | 95.8 | 95.8 | 95.63 | 95.64 | 153842.0 |
| 2008-11-10 08:20:00 | SPY | ETF | 95.64 | 95.69 | 95.56 | 95.58 | 388662.0 |
| 2008-11-10 08:25:00 | SPY | ETF | 95.58 | 95.76 | 95.53 | 95.72 | 152322.0 |
| 2008-11-10 08:30:00 | SPY | ETF | 95.71 | 95.75 | 95.6 | 95.66 | 167941.0 |
| 2008-11-10 08:35:00 | SPY | ETF | 95.68 | 95.69 | 95.52 | 95.58 | 220695.0 |
| 2008-11-10 08:40:00 | SPY | ETF | 95.58 | 95.84 | 95.58 | 95.83 | 238123.0 |
| 2008-11-10 08:45:00 | SPY | ETF | 95.82 | 95.91 | 95.74 | 95.9 | 253388.0 |
> showing 50 of 24,588 rows — these rows as CSV