PREVIEW / etf_5min / 2008-04-15
file: by_date/etf_5min/2008/2008-04-15.parquet size: 450 KB rows: 20,977
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-15 05:00:00 | SPY | ETF | 132.75 | 132.75 | 132.75 | 132.75 | 100.0 |
| 2008-04-15 06:30:00 | SPY | ETF | 132.71 | 132.71 | 132.71 | 132.71 | 2000.0 |
| 2008-04-15 06:35:00 | SPY | ETF | 132.67 | 132.7 | 132.67 | 132.7 | 16300.0 |
| 2008-04-15 07:00:00 | SPY | ETF | 132.53 | 132.63 | 132.51 | 132.61 | 168800.0 |
| 2008-04-15 07:05:00 | SPY | ETF | 132.65 | 132.7 | 132.65 | 132.66 | 186600.0 |
| 2008-04-15 07:10:00 | SPY | ETF | 132.7 | 132.75 | 132.7 | 132.75 | 50700.0 |
| 2008-04-15 07:15:00 | SPY | ETF | 132.75 | 132.81 | 132.75 | 132.77 | 36800.0 |
| 2008-04-15 07:20:00 | SPY | ETF | 132.76 | 132.91 | 132.76 | 132.86 | 158400.0 |
| 2008-04-15 07:25:00 | SPY | ETF | 132.84 | 132.9 | 132.84 | 132.89 | 66400.0 |
| 2008-04-15 07:30:00 | SPY | ETF | 132.92 | 132.96 | 132.92 | 132.96 | 26100.0 |
| 2008-04-15 07:35:00 | SPY | ETF | 132.93 | 133.1 | 132.93 | 133.01 | 151400.0 |
| 2008-04-15 07:40:00 | SPY | ETF | 132.99 | 133.09 | 132.99 | 133.0 | 29500.0 |
| 2008-04-15 07:45:00 | SPY | ETF | 132.99 | 133.13 | 132.99 | 133.13 | 317781.0 |
| 2008-04-15 07:50:00 | SPY | ETF | 133.13 | 133.18 | 133.09 | 133.17 | 169911.0 |
| 2008-04-15 07:55:00 | SPY | ETF | 133.19 | 133.2 | 133.13 | 133.13 | 166898.0 |
| 2008-04-15 08:00:00 | SPY | ETF | 133.13 | 133.17 | 132.73 | 133.08 | 636344.0 |
| 2008-04-15 08:05:00 | SPY | ETF | 133.08 | 133.11 | 133.05 | 133.09 | 523759.0 |
| 2008-04-15 08:10:00 | SPY | ETF | 133.11 | 133.15 | 133.04 | 133.04 | 119681.0 |
| 2008-04-15 08:15:00 | SPY | ETF | 133.08 | 133.37 | 133.07 | 133.16 | 222325.0 |
| 2008-04-15 08:20:00 | SPY | ETF | 133.13 | 133.49 | 133.13 | 133.16 | 171128.0 |
| 2008-04-15 08:25:00 | SPY | ETF | 133.18 | 133.21 | 132.99 | 132.99 | 188701.0 |
| 2008-04-15 08:30:00 | SPY | ETF | 133.15 | 133.54 | 132.71 | 133.5 | 3082980.0 |
| 2008-04-15 08:35:00 | SPY | ETF | 133.5 | 133.57 | 133.43 | 133.5 | 605899.0 |
| 2008-04-15 08:40:00 | SPY | ETF | 133.51 | 133.51 | 133.4 | 133.42 | 487746.0 |
| 2008-04-15 08:45:00 | SPY | ETF | 133.43 | 133.51 | 133.37 | 133.38 | 553452.0 |
| 2008-04-15 08:50:00 | SPY | ETF | 133.38 | 133.49 | 133.32 | 133.49 | 575881.0 |
| 2008-04-15 08:55:00 | SPY | ETF | 133.49 | 133.67 | 133.49 | 133.67 | 1061623.0 |
| 2008-04-15 09:00:00 | SPY | ETF | 133.65 | 133.65 | 133.56 | 133.58 | 389250.0 |
| 2008-04-15 09:05:00 | SPY | ETF | 133.58 | 133.58 | 133.48 | 133.5 | 280093.0 |
| 2008-04-15 09:10:00 | SPY | ETF | 133.51 | 133.62 | 133.51 | 133.61 | 436373.0 |
| 2008-04-15 09:15:00 | SPY | ETF | 133.61 | 133.7 | 133.61 | 133.62 | 431708.0 |
| 2008-04-15 09:20:00 | SPY | ETF | 133.62 | 133.66 | 133.6 | 133.63 | 297894.0 |
| 2008-04-15 09:25:00 | SPY | ETF | 133.64 | 133.66 | 133.57 | 133.58 | 441789.0 |
| 2008-04-15 09:30:00 | SPY | ETF | 133.58 | 133.69 | 133.48 | 133.64 | 2590733.0 |
| 2008-04-15 09:35:00 | SPY | ETF | 133.64 | 133.6599 | 133.44 | 133.52 | 2907249.0 |
| 2008-04-15 09:40:00 | SPY | ETF | 133.5201 | 133.6 | 133.39 | 133.49 | 2626695.0 |
| 2008-04-15 09:45:00 | SPY | ETF | 133.49 | 133.49 | 133.35 | 133.37 | 1744433.0 |
| 2008-04-15 09:50:00 | SPY | ETF | 133.37 | 133.38 | 133.24 | 133.26 | 2340100.0 |
| 2008-04-15 09:55:00 | SPY | ETF | 133.25 | 133.4 | 133.17 | 133.18 | 1823557.0 |
| 2008-04-15 10:00:00 | SPY | ETF | 133.19 | 133.58 | 133.18 | 133.33 | 1200052.0 |
| 2008-04-15 10:05:00 | SPY | ETF | 133.32 | 133.37 | 133.09 | 133.1501 | 1704978.0 |
| 2008-04-15 10:10:00 | SPY | ETF | 133.16 | 133.19 | 133.01 | 133.02 | 2700060.0 |
| 2008-04-15 10:15:00 | SPY | ETF | 133.02 | 133.09 | 132.89 | 133.0 | 2672826.0 |
| 2008-04-15 10:20:00 | SPY | ETF | 133.01 | 133.1 | 132.92 | 132.94 | 3146825.0 |
| 2008-04-15 10:25:00 | SPY | ETF | 132.94 | 133.0 | 132.78 | 132.79 | 4813105.0 |
| 2008-04-15 10:30:00 | SPY | ETF | 132.79 | 132.97 | 132.79 | 132.9 | 2553298.0 |
| 2008-04-15 10:35:00 | SPY | ETF | 132.92 | 133.01 | 132.82 | 132.93 | 3824508.0 |
| 2008-04-15 10:40:00 | SPY | ETF | 132.92 | 132.93 | 132.79 | 132.89 | 3030492.0 |
| 2008-04-15 10:45:00 | SPY | ETF | 132.9 | 133.05 | 132.82 | 132.98 | 2462250.0 |
| 2008-04-15 10:50:00 | SPY | ETF | 132.98 | 133.04 | 132.76 | 132.78 | 2069138.0 |
> showing 50 of 20,977 rows — these rows as CSV