PREVIEW / etf_5min / 2010-01-14
file: by_date/etf_5min/2010/2010-01-14.parquet size: 722 KB rows: 31,430
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-14 05:00:00 | SPY | ETF | 114.67 | 114.67 | 114.67 | 114.67 | 100.0 |
| 2010-01-14 05:10:00 | SPY | ETF | 114.59 | 114.59 | 114.59 | 114.59 | 800.0 |
| 2010-01-14 05:20:00 | SPY | ETF | 114.6 | 114.6 | 114.6 | 114.6 | 2000.0 |
| 2010-01-14 06:15:00 | SPY | ETF | 114.55 | 114.55 | 114.55 | 114.55 | 200.0 |
| 2010-01-14 06:45:00 | SPY | ETF | 114.53 | 114.53 | 114.53 | 114.53 | 600.0 |
| 2010-01-14 06:55:00 | SPY | ETF | 114.6 | 114.6 | 114.6 | 114.6 | 500.0 |
| 2010-01-14 07:00:00 | SPY | ETF | 114.61 | 114.64 | 114.61 | 114.64 | 5890.0 |
| 2010-01-14 07:05:00 | SPY | ETF | 114.63 | 114.63 | 114.63 | 114.63 | 6700.0 |
| 2010-01-14 07:20:00 | SPY | ETF | 114.62 | 114.62 | 114.62 | 114.62 | 300.0 |
| 2010-01-14 07:25:00 | SPY | ETF | 114.62 | 114.62 | 114.55 | 114.56 | 2300.0 |
| 2010-01-14 07:30:00 | SPY | ETF | 114.57 | 114.57 | 114.55 | 114.55 | 2500.0 |
| 2010-01-14 07:35:00 | SPY | ETF | 114.55 | 114.58 | 114.55 | 114.58 | 200.0 |
| 2010-01-14 07:40:00 | SPY | ETF | 114.58 | 114.6 | 114.58 | 114.6 | 25400.0 |
| 2010-01-14 07:45:00 | SPY | ETF | 114.6 | 114.6 | 114.55 | 114.55 | 2900.0 |
| 2010-01-14 07:50:00 | SPY | ETF | 114.54 | 114.54 | 114.41 | 114.54 | 76900.0 |
| 2010-01-14 07:55:00 | SPY | ETF | 114.54 | 114.63 | 114.54 | 114.63 | 29900.0 |
| 2010-01-14 08:00:00 | SPY | ETF | 114.62 | 114.79 | 114.59 | 114.76 | 299439.0 |
| 2010-01-14 08:05:00 | SPY | ETF | 114.77 | 114.79 | 114.75 | 114.77 | 74274.0 |
| 2010-01-14 08:10:00 | SPY | ETF | 114.77 | 114.78 | 114.74 | 114.76 | 20000.0 |
| 2010-01-14 08:15:00 | SPY | ETF | 114.76 | 114.79 | 114.73 | 114.77 | 42811.0 |
| 2010-01-14 08:20:00 | SPY | ETF | 114.78 | 114.78 | 114.75 | 114.77 | 17991.0 |
| 2010-01-14 08:25:00 | SPY | ETF | 114.77 | 114.79 | 114.7 | 114.7 | 231929.0 |
| 2010-01-14 08:30:00 | SPY | ETF | 114.69 | 114.7 | 114.46 | 114.64 | 908377.0 |
| 2010-01-14 08:35:00 | SPY | ETF | 114.63 | 114.65 | 114.59 | 114.6 | 119436.0 |
| 2010-01-14 08:40:00 | SPY | ETF | 114.6 | 114.61 | 114.52 | 114.53 | 195834.0 |
| 2010-01-14 08:45:00 | SPY | ETF | 114.53 | 114.53 | 114.39 | 114.43 | 862529.0 |
| 2010-01-14 08:50:00 | SPY | ETF | 114.41 | 114.42 | 114.35 | 114.37 | 441542.0 |
| 2010-01-14 08:55:00 | SPY | ETF | 114.37 | 114.37 | 114.27 | 114.31 | 264585.0 |
| 2010-01-14 09:00:00 | SPY | ETF | 114.32 | 114.38 | 114.31 | 114.35 | 114294.0 |
| 2010-01-14 09:05:00 | SPY | ETF | 114.36 | 114.44 | 114.35 | 114.43 | 150329.0 |
| 2010-01-14 09:10:00 | SPY | ETF | 114.43 | 114.46 | 114.4 | 114.4 | 242568.0 |
| 2010-01-14 09:15:00 | SPY | ETF | 114.4 | 114.44 | 114.39 | 114.42 | 65058.0 |
| 2010-01-14 09:20:00 | SPY | ETF | 114.42 | 114.45 | 114.36 | 114.43 | 177324.0 |
| 2010-01-14 09:25:00 | SPY | ETF | 114.44 | 114.5 | 114.44 | 114.49 | 255507.0 |
| 2010-01-14 09:30:00 | SPY | ETF | 114.49 | 114.53 | 114.42 | 114.52 | 2435986.0 |
| 2010-01-14 09:35:00 | SPY | ETF | 114.53 | 114.59 | 114.47 | 114.48 | 3531689.0 |
| 2010-01-14 09:40:00 | SPY | ETF | 114.48 | 114.64 | 114.48 | 114.61 | 2124335.0 |
| 2010-01-14 09:45:00 | SPY | ETF | 114.61 | 114.71 | 114.56 | 114.6783 | 2600853.0 |
| 2010-01-14 09:50:00 | SPY | ETF | 114.67 | 114.695 | 114.6 | 114.66 | 1369299.0 |
| 2010-01-14 09:55:00 | SPY | ETF | 114.65 | 114.68 | 114.57 | 114.62 | 1498417.0 |
| 2010-01-14 10:00:00 | SPY | ETF | 114.61 | 114.71 | 114.6 | 114.66 | 2026261.0 |
| 2010-01-14 10:05:00 | SPY | ETF | 114.67 | 114.87 | 114.65 | 114.82 | 2471923.0 |
| 2010-01-14 10:10:00 | SPY | ETF | 114.8201 | 114.99 | 114.82 | 114.97 | 2915543.0 |
| 2010-01-14 10:15:00 | SPY | ETF | 114.97 | 114.99 | 114.8 | 114.835 | 1212922.0 |
| 2010-01-14 10:20:00 | SPY | ETF | 114.83 | 114.88 | 114.8 | 114.8225 | 911558.0 |
| 2010-01-14 10:25:00 | SPY | ETF | 114.82 | 114.91 | 114.79 | 114.83 | 1165026.0 |
| 2010-01-14 10:30:00 | SPY | ETF | 114.81 | 114.88 | 114.81 | 114.8474 | 1131819.0 |
| 2010-01-14 10:35:00 | SPY | ETF | 114.84 | 114.9 | 114.84 | 114.9 | 892756.0 |
| 2010-01-14 10:40:00 | SPY | ETF | 114.9 | 114.93 | 114.74 | 114.74 | 2453749.0 |
| 2010-01-14 10:45:00 | SPY | ETF | 114.745 | 114.75 | 114.65 | 114.7 | 2285020.0 |
> showing 50 of 31,430 rows — these rows as CSV