PREVIEW / etf_5min / 2009-03-12
file: by_date/etf_5min/2009/2009-03-12.parquet size: 713 KB rows: 28,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 |
|---|---|---|---|---|---|---|---|
| 2009-03-12 04:15:00 | SPY | ETF | 72.3 | 72.39 | 72.28 | 72.39 | 3300.0 |
| 2009-03-12 04:20:00 | SPY | ETF | 72.47 | 72.47 | 72.4 | 72.4 | 700.0 |
| 2009-03-12 04:50:00 | SPY | ETF | 72.0 | 72.0 | 71.98 | 71.98 | 1500.0 |
| 2009-03-12 04:55:00 | SPY | ETF | 72.0 | 72.0 | 72.0 | 72.0 | 2000.0 |
| 2009-03-12 05:35:00 | SPY | ETF | 72.07 | 72.07 | 72.07 | 72.07 | 2500.0 |
| 2009-03-12 05:40:00 | SPY | ETF | 72.06 | 72.06 | 72.06 | 72.06 | 3500.0 |
| 2009-03-12 06:05:00 | SPY | ETF | 71.9 | 71.9 | 71.9 | 71.9 | 2600.0 |
| 2009-03-12 06:10:00 | SPY | ETF | 71.88 | 71.88 | 71.7 | 71.7 | 8400.0 |
| 2009-03-12 06:15:00 | SPY | ETF | 71.85 | 71.87 | 71.85 | 71.87 | 800.0 |
| 2009-03-12 06:20:00 | SPY | ETF | 71.87 | 71.87 | 71.87 | 71.87 | 300.0 |
| 2009-03-12 06:25:00 | SPY | ETF | 71.81 | 71.81 | 71.81 | 71.81 | 2500.0 |
| 2009-03-12 06:30:00 | SPY | ETF | 71.75 | 71.78 | 71.75 | 71.78 | 27500.0 |
| 2009-03-12 06:35:00 | SPY | ETF | 71.83 | 71.83 | 71.8 | 71.8 | 1250.0 |
| 2009-03-12 06:40:00 | SPY | ETF | 71.84 | 71.84 | 71.84 | 71.84 | 100.0 |
| 2009-03-12 06:45:00 | SPY | ETF | 71.82 | 71.83 | 71.81 | 71.81 | 10200.0 |
| 2009-03-12 06:50:00 | SPY | ETF | 71.86 | 71.89 | 71.86 | 71.89 | 40100.0 |
| 2009-03-12 06:55:00 | SPY | ETF | 71.81 | 71.81 | 71.81 | 71.81 | 1400.0 |
| 2009-03-12 07:00:00 | SPY | ETF | 71.82 | 71.82 | 71.72 | 71.72 | 45180.0 |
| 2009-03-12 07:05:00 | SPY | ETF | 71.73 | 71.76 | 71.73 | 71.75 | 6737.0 |
| 2009-03-12 07:10:00 | SPY | ETF | 71.76 | 71.76 | 71.73 | 71.75 | 19400.0 |
| 2009-03-12 07:15:00 | SPY | ETF | 71.76 | 71.84 | 71.75 | 71.81 | 67550.0 |
| 2009-03-12 07:20:00 | SPY | ETF | 71.83 | 71.9 | 71.83 | 71.83 | 55500.0 |
| 2009-03-12 07:25:00 | SPY | ETF | 71.85 | 71.95 | 71.83 | 71.95 | 12307.0 |
| 2009-03-12 07:30:00 | SPY | ETF | 71.93 | 72.06 | 71.89 | 72.05 | 54908.0 |
| 2009-03-12 07:35:00 | SPY | ETF | 72.05 | 72.07 | 72.0 | 72.07 | 100152.0 |
| 2009-03-12 07:40:00 | SPY | ETF | 72.07 | 72.09 | 72.0 | 72.04 | 82321.0 |
| 2009-03-12 07:45:00 | SPY | ETF | 72.01 | 72.03 | 71.96 | 71.97 | 37000.0 |
| 2009-03-12 07:50:00 | SPY | ETF | 71.99 | 72.01 | 71.96 | 72.0 | 18500.0 |
| 2009-03-12 07:55:00 | SPY | ETF | 71.98 | 72.08 | 71.98 | 72.06 | 134764.0 |
| 2009-03-12 08:00:00 | SPY | ETF | 72.06 | 72.41 | 72.05 | 72.28 | 452118.0 |
| 2009-03-12 08:05:00 | SPY | ETF | 72.3 | 72.32 | 72.19 | 72.21 | 369869.0 |
| 2009-03-12 08:10:00 | SPY | ETF | 72.22 | 72.25 | 72.17 | 72.17 | 50608.0 |
| 2009-03-12 08:15:00 | SPY | ETF | 72.17 | 72.18 | 72.05 | 72.08 | 414917.0 |
| 2009-03-12 08:20:00 | SPY | ETF | 72.08 | 72.13 | 71.86 | 72.1 | 124755.0 |
| 2009-03-12 08:25:00 | SPY | ETF | 72.11 | 72.4 | 72.11 | 72.28 | 526158.0 |
| 2009-03-12 08:30:00 | SPY | ETF | 72.27 | 72.61 | 72.21 | 72.45 | 2193182.0 |
| 2009-03-12 08:35:00 | SPY | ETF | 72.45 | 72.52 | 72.39 | 72.48 | 290524.0 |
| 2009-03-12 08:40:00 | SPY | ETF | 72.47 | 72.51 | 72.38 | 72.51 | 299599.0 |
| 2009-03-12 08:45:00 | SPY | ETF | 72.5 | 72.55 | 72.38 | 72.53 | 184534.0 |
| 2009-03-12 08:50:00 | SPY | ETF | 72.55 | 72.68 | 72.55 | 72.57 | 565804.0 |
| 2009-03-12 08:55:00 | SPY | ETF | 72.56 | 72.66 | 72.48 | 72.5 | 339284.0 |
| 2009-03-12 09:00:00 | SPY | ETF | 72.49 | 72.57 | 72.3 | 72.32 | 485903.0 |
| 2009-03-12 09:05:00 | SPY | ETF | 72.32 | 72.41 | 72.31 | 72.41 | 257539.0 |
| 2009-03-12 09:10:00 | SPY | ETF | 72.4 | 72.41 | 72.01 | 72.38 | 2470565.0 |
| 2009-03-12 09:15:00 | SPY | ETF | 72.39 | 72.79 | 72.39 | 72.64 | 2218370.0 |
| 2009-03-12 09:20:00 | SPY | ETF | 72.65 | 72.8 | 72.54 | 72.54 | 1064071.0 |
| 2009-03-12 09:25:00 | SPY | ETF | 72.54 | 72.64 | 72.46 | 72.62 | 762623.0 |
| 2009-03-12 09:30:00 | SPY | ETF | 72.62 | 72.81 | 72.48 | 72.77 | 8401546.0 |
| 2009-03-12 09:35:00 | SPY | ETF | 72.77 | 72.8 | 72.34 | 72.35 | 7394656.0 |
| 2009-03-12 09:40:00 | SPY | ETF | 72.35 | 72.37 | 72.07 | 72.16 | 6670876.0 |
> showing 50 of 28,977 rows — these rows as CSV