PREVIEW / etf_5min / 2008-11-17
file: by_date/etf_5min/2008/2008-11-17.parquet size: 534 KB rows: 25,074
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-17 04:10:00 | SPY | ETF | 87.7 | 87.7 | 87.7 | 87.7 | 6000.0 |
| 2008-11-17 04:15:00 | SPY | ETF | 87.71 | 87.72 | 87.7 | 87.72 | 2600.0 |
| 2008-11-17 04:20:00 | SPY | ETF | 87.74 | 87.76 | 87.74 | 87.76 | 200.0 |
| 2008-11-17 04:25:00 | SPY | ETF | 87.81 | 87.81 | 87.81 | 87.81 | 400.0 |
| 2008-11-17 04:35:00 | SPY | ETF | 87.65 | 87.65 | 87.39 | 87.39 | 1200.0 |
| 2008-11-17 04:40:00 | SPY | ETF | 87.29 | 87.29 | 87.24 | 87.24 | 700.0 |
| 2008-11-17 04:45:00 | SPY | ETF | 87.12 | 87.14 | 87.12 | 87.14 | 1100.0 |
| 2008-11-17 04:50:00 | SPY | ETF | 87.13 | 87.13 | 87.13 | 87.13 | 200.0 |
| 2008-11-17 04:55:00 | SPY | ETF | 87.03 | 87.03 | 86.99 | 86.99 | 1600.0 |
| 2008-11-17 05:00:00 | SPY | ETF | 86.89 | 86.98 | 86.89 | 86.98 | 1700.0 |
| 2008-11-17 05:05:00 | SPY | ETF | 86.68 | 86.7 | 86.65 | 86.7 | 18000.0 |
| 2008-11-17 05:10:00 | SPY | ETF | 86.75 | 86.75 | 86.7 | 86.7 | 2800.0 |
| 2008-11-17 05:15:00 | SPY | ETF | 86.68 | 86.68 | 86.63 | 86.63 | 300.0 |
| 2008-11-17 05:25:00 | SPY | ETF | 86.65 | 86.69 | 86.63 | 86.69 | 3100.0 |
| 2008-11-17 05:30:00 | SPY | ETF | 86.76 | 86.76 | 86.53 | 86.53 | 1100.0 |
| 2008-11-17 05:35:00 | SPY | ETF | 86.5 | 86.5 | 86.5 | 86.5 | 1000.0 |
| 2008-11-17 05:40:00 | SPY | ETF | 86.45 | 86.45 | 86.45 | 86.45 | 200.0 |
| 2008-11-17 05:45:00 | SPY | ETF | 86.54 | 86.54 | 86.54 | 86.54 | 100.0 |
| 2008-11-17 05:55:00 | SPY | ETF | 86.47 | 86.47 | 86.25 | 86.25 | 300.0 |
| 2008-11-17 06:00:00 | SPY | ETF | 86.3 | 86.3 | 86.3 | 86.3 | 2490.0 |
| 2008-11-17 06:05:00 | SPY | ETF | 86.22 | 86.22 | 86.2 | 86.2 | 800.0 |
| 2008-11-17 06:10:00 | SPY | ETF | 86.12 | 86.12 | 86.1 | 86.12 | 4500.0 |
| 2008-11-17 06:15:00 | SPY | ETF | 86.08 | 86.1 | 86.08 | 86.1 | 2000.0 |
| 2008-11-17 06:20:00 | SPY | ETF | 86.13 | 86.13 | 85.9 | 85.9 | 5100.0 |
| 2008-11-17 06:25:00 | SPY | ETF | 85.92 | 85.92 | 85.86 | 85.86 | 6600.0 |
| 2008-11-17 06:30:00 | SPY | ETF | 85.88 | 85.88 | 85.88 | 85.88 | 1000.0 |
| 2008-11-17 06:35:00 | SPY | ETF | 85.79 | 85.85 | 85.79 | 85.85 | 200.0 |
| 2008-11-17 06:40:00 | SPY | ETF | 85.96 | 86.06 | 85.96 | 86.0 | 4381.0 |
| 2008-11-17 06:45:00 | SPY | ETF | 86.06 | 86.08 | 85.99 | 86.02 | 62800.0 |
| 2008-11-17 06:50:00 | SPY | ETF | 86.0 | 86.0 | 85.96 | 85.96 | 200.0 |
| 2008-11-17 06:55:00 | SPY | ETF | 86.0 | 86.06 | 86.0 | 86.06 | 400.0 |
| 2008-11-17 07:00:00 | SPY | ETF | 86.09 | 86.09 | 85.95 | 85.95 | 20000.0 |
| 2008-11-17 07:05:00 | SPY | ETF | 85.95 | 85.95 | 85.7 | 85.7 | 57626.0 |
| 2008-11-17 07:10:00 | SPY | ETF | 85.8 | 86.1 | 85.8 | 86.1 | 13136.0 |
| 2008-11-17 07:15:00 | SPY | ETF | 86.05 | 86.06 | 85.9 | 85.9 | 5400.0 |
| 2008-11-17 07:20:00 | SPY | ETF | 85.97 | 86.02 | 85.74 | 85.77 | 182192.0 |
| 2008-11-17 07:25:00 | SPY | ETF | 85.75 | 85.83 | 85.7 | 85.76 | 165187.0 |
| 2008-11-17 07:30:00 | SPY | ETF | 85.71 | 85.71 | 85.47 | 85.55 | 436883.0 |
| 2008-11-17 07:35:00 | SPY | ETF | 85.55 | 85.78 | 85.55 | 85.76 | 276405.0 |
| 2008-11-17 07:40:00 | SPY | ETF | 85.75 | 85.77 | 85.6 | 85.62 | 100196.0 |
| 2008-11-17 07:45:00 | SPY | ETF | 85.62 | 85.94 | 85.62 | 85.88 | 549028.0 |
| 2008-11-17 07:50:00 | SPY | ETF | 85.86 | 85.86 | 85.56 | 85.64 | 161122.0 |
| 2008-11-17 07:55:00 | SPY | ETF | 85.65 | 86.0 | 85.65 | 85.74 | 188977.0 |
| 2008-11-17 08:00:00 | SPY | ETF | 85.72 | 87.3 | 85.4 | 85.75 | 279549.0 |
| 2008-11-17 08:05:00 | SPY | ETF | 85.8 | 85.86 | 85.63 | 85.85 | 195878.0 |
| 2008-11-17 08:10:00 | SPY | ETF | 85.84 | 85.99 | 85.84 | 85.91 | 172204.0 |
| 2008-11-17 08:15:00 | SPY | ETF | 85.9 | 86.05 | 85.83 | 85.88 | 163952.0 |
| 2008-11-17 08:20:00 | SPY | ETF | 85.89 | 86.01 | 85.83 | 85.85 | 164552.0 |
| 2008-11-17 08:25:00 | SPY | ETF | 85.84 | 86.37 | 85.74 | 85.9 | 222071.0 |
| 2008-11-17 08:30:00 | SPY | ETF | 85.9 | 85.93 | 85.74 | 85.79 | 389642.0 |
> showing 50 of 25,074 rows — these rows as CSV