PREVIEW / etf_5min / 2008-12-30
file: by_date/etf_5min/2008/2008-12-30.parquet size: 663 KB rows: 27,882
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-12-30 04:15:00 | SPY | ETF | 88.04 | 88.05 | 88.04 | 88.05 | 1140.0 |
| 2008-12-30 04:20:00 | SPY | ETF | 88.05 | 88.06 | 88.05 | 88.06 | 200.0 |
| 2008-12-30 04:25:00 | SPY | ETF | 88.07 | 88.07 | 88.07 | 88.07 | 874.0 |
| 2008-12-30 04:40:00 | SPY | ETF | 88.0 | 88.0 | 88.0 | 88.0 | 400.0 |
| 2008-12-30 04:50:00 | SPY | ETF | 87.99 | 87.99 | 87.99 | 87.99 | 300.0 |
| 2008-12-30 05:10:00 | SPY | ETF | 87.98 | 87.98 | 87.98 | 87.98 | 100.0 |
| 2008-12-30 05:25:00 | SPY | ETF | 88.02 | 88.02 | 88.02 | 88.02 | 285.0 |
| 2008-12-30 05:55:00 | SPY | ETF | 87.93 | 87.93 | 87.93 | 87.93 | 100.0 |
| 2008-12-30 06:15:00 | SPY | ETF | 87.79 | 87.79 | 87.79 | 87.79 | 100.0 |
| 2008-12-30 06:25:00 | SPY | ETF | 87.73 | 87.76 | 87.73 | 87.73 | 685.0 |
| 2008-12-30 06:45:00 | SPY | ETF | 87.66 | 87.66 | 87.5 | 87.5 | 800.0 |
| 2008-12-30 06:50:00 | SPY | ETF | 87.5 | 87.5 | 87.5 | 87.5 | 500.0 |
| 2008-12-30 06:55:00 | SPY | ETF | 87.66 | 87.66 | 87.66 | 87.66 | 1000.0 |
| 2008-12-30 07:00:00 | SPY | ETF | 87.68 | 87.69 | 87.65 | 87.69 | 1200.0 |
| 2008-12-30 07:05:00 | SPY | ETF | 87.68 | 87.7 | 87.63 | 87.7 | 3300.0 |
| 2008-12-30 07:10:00 | SPY | ETF | 87.73 | 87.81 | 87.73 | 87.81 | 32800.0 |
| 2008-12-30 07:15:00 | SPY | ETF | 87.8 | 87.8 | 87.77 | 87.77 | 14900.0 |
| 2008-12-30 07:20:00 | SPY | ETF | 87.72 | 87.72 | 87.71 | 87.71 | 15500.0 |
| 2008-12-30 07:25:00 | SPY | ETF | 87.66 | 87.7 | 87.62 | 87.7 | 10900.0 |
| 2008-12-30 07:30:00 | SPY | ETF | 87.7 | 87.7 | 87.65 | 87.65 | 5700.0 |
| 2008-12-30 07:35:00 | SPY | ETF | 87.71 | 87.71 | 87.7 | 87.7 | 1700.0 |
| 2008-12-30 07:40:00 | SPY | ETF | 87.71 | 87.71 | 87.55 | 87.69 | 246200.0 |
| 2008-12-30 07:45:00 | SPY | ETF | 87.67 | 87.7 | 87.63 | 87.7 | 15600.0 |
| 2008-12-30 07:50:00 | SPY | ETF | 87.7 | 87.75 | 87.69 | 87.72 | 70204.0 |
| 2008-12-30 07:55:00 | SPY | ETF | 87.7 | 87.75 | 87.69 | 87.71 | 7504.0 |
| 2008-12-30 08:00:00 | SPY | ETF | 87.71 | 87.85 | 87.7 | 87.84 | 216907.0 |
| 2008-12-30 08:05:00 | SPY | ETF | 87.84 | 87.87 | 87.76 | 87.86 | 82307.0 |
| 2008-12-30 08:10:00 | SPY | ETF | 87.87 | 87.88 | 87.8 | 87.83 | 52823.0 |
| 2008-12-30 08:15:00 | SPY | ETF | 87.82 | 87.84 | 87.75 | 87.81 | 129000.0 |
| 2008-12-30 08:20:00 | SPY | ETF | 87.82 | 88.06 | 87.78 | 87.78 | 19797.0 |
| 2008-12-30 08:25:00 | SPY | ETF | 87.77 | 87.86 | 87.77 | 87.82 | 32436.0 |
| 2008-12-30 08:30:00 | SPY | ETF | 87.82 | 87.82 | 87.74 | 87.74 | 135051.0 |
| 2008-12-30 08:35:00 | SPY | ETF | 87.75 | 87.78 | 87.73 | 87.76 | 55511.0 |
| 2008-12-30 08:40:00 | SPY | ETF | 87.77 | 87.77 | 87.73 | 87.74 | 149375.0 |
| 2008-12-30 08:45:00 | SPY | ETF | 87.74 | 87.77 | 87.74 | 87.74 | 28098.0 |
| 2008-12-30 08:50:00 | SPY | ETF | 87.73 | 87.78 | 87.65 | 87.67 | 128660.0 |
| 2008-12-30 08:55:00 | SPY | ETF | 87.68 | 87.72 | 87.65 | 87.67 | 81274.0 |
| 2008-12-30 09:00:00 | SPY | ETF | 87.67 | 87.73 | 87.63 | 87.72 | 99118.0 |
| 2008-12-30 09:05:00 | SPY | ETF | 87.73 | 87.73 | 87.67 | 87.67 | 80938.0 |
| 2008-12-30 09:10:00 | SPY | ETF | 87.67 | 87.67 | 87.58 | 87.59 | 90405.0 |
| 2008-12-30 09:15:00 | SPY | ETF | 87.58 | 87.59 | 87.5 | 87.5 | 159524.0 |
| 2008-12-30 09:20:00 | SPY | ETF | 87.51 | 87.59 | 87.49 | 87.55 | 311382.0 |
| 2008-12-30 09:25:00 | SPY | ETF | 87.54 | 87.8 | 87.41 | 87.48 | 319101.0 |
| 2008-12-30 09:30:00 | SPY | ETF | 87.51 | 87.67 | 87.33 | 87.37 | 3316353.0 |
| 2008-12-30 09:35:00 | SPY | ETF | 87.37 | 87.47 | 87.33 | 87.37 | 2105805.0 |
| 2008-12-30 09:40:00 | SPY | ETF | 87.38 | 87.56 | 87.33 | 87.49 | 3031191.0 |
| 2008-12-30 09:45:00 | SPY | ETF | 87.49 | 87.63 | 87.43 | 87.47 | 2864757.0 |
| 2008-12-30 09:50:00 | SPY | ETF | 87.4675 | 87.51 | 87.44 | 87.44 | 1197104.0 |
| 2008-12-30 09:55:00 | SPY | ETF | 87.44 | 87.49 | 87.25 | 87.28 | 3041757.0 |
| 2008-12-30 10:00:00 | SPY | ETF | 87.28 | 87.41 | 87.09 | 87.38 | 4331229.0 |
> showing 50 of 27,882 rows — these rows as CSV