PREVIEW / etf_5min / 2010-01-29
file: by_date/etf_5min/2010/2010-01-29.parquet size: 833 KB rows: 33,763
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-29 04:15:00 | SPY | ETF | 108.52 | 108.52 | 108.44 | 108.47 | 700.0 |
| 2010-01-29 04:20:00 | SPY | ETF | 108.44 | 108.44 | 108.44 | 108.44 | 200.0 |
| 2010-01-29 04:45:00 | SPY | ETF | 108.46 | 108.46 | 108.46 | 108.46 | 458.0 |
| 2010-01-29 04:55:00 | SPY | ETF | 108.35 | 108.35 | 108.33 | 108.33 | 600.0 |
| 2010-01-29 05:00:00 | SPY | ETF | 108.37 | 108.37 | 108.35 | 108.35 | 3000.0 |
| 2010-01-29 05:05:00 | SPY | ETF | 108.37 | 108.37 | 108.37 | 108.37 | 500.0 |
| 2010-01-29 05:10:00 | SPY | ETF | 108.39 | 108.4 | 108.3 | 108.3 | 1300.0 |
| 2010-01-29 05:15:00 | SPY | ETF | 108.25 | 108.25 | 108.24 | 108.24 | 2500.0 |
| 2010-01-29 05:20:00 | SPY | ETF | 108.19 | 108.25 | 108.19 | 108.25 | 500.0 |
| 2010-01-29 05:35:00 | SPY | ETF | 108.33 | 108.39 | 108.33 | 108.39 | 700.0 |
| 2010-01-29 05:45:00 | SPY | ETF | 108.46 | 108.5 | 108.46 | 108.5 | 89900.0 |
| 2010-01-29 05:50:00 | SPY | ETF | 108.5 | 108.6 | 108.5 | 108.58 | 1200.0 |
| 2010-01-29 05:55:00 | SPY | ETF | 108.65 | 108.67 | 108.63 | 108.63 | 10000.0 |
| 2010-01-29 06:00:00 | SPY | ETF | 108.55 | 108.55 | 108.55 | 108.55 | 600.0 |
| 2010-01-29 06:05:00 | SPY | ETF | 108.6 | 108.6 | 108.6 | 108.6 | 1500.0 |
| 2010-01-29 06:10:00 | SPY | ETF | 108.63 | 108.67 | 108.63 | 108.67 | 1100.0 |
| 2010-01-29 06:20:00 | SPY | ETF | 108.62 | 108.76 | 108.62 | 108.76 | 300.0 |
| 2010-01-29 06:25:00 | SPY | ETF | 108.8 | 108.8 | 108.8 | 108.8 | 100.0 |
| 2010-01-29 06:30:00 | SPY | ETF | 108.78 | 108.85 | 108.78 | 108.82 | 12800.0 |
| 2010-01-29 06:35:00 | SPY | ETF | 108.82 | 108.85 | 108.79 | 108.85 | 9100.0 |
| 2010-01-29 06:40:00 | SPY | ETF | 108.82 | 108.82 | 108.78 | 108.78 | 27900.0 |
| 2010-01-29 06:45:00 | SPY | ETF | 108.78 | 108.78 | 108.78 | 108.78 | 300.0 |
| 2010-01-29 06:50:00 | SPY | ETF | 108.72 | 108.72 | 108.72 | 108.72 | 1800.0 |
| 2010-01-29 06:55:00 | SPY | ETF | 108.7 | 108.7 | 108.7 | 108.7 | 200.0 |
| 2010-01-29 07:00:00 | SPY | ETF | 108.65 | 108.67 | 108.62 | 108.64 | 57418.0 |
| 2010-01-29 07:05:00 | SPY | ETF | 108.66 | 108.68 | 108.6 | 108.65 | 27100.0 |
| 2010-01-29 07:10:00 | SPY | ETF | 108.61 | 108.71 | 108.61 | 108.71 | 19465.0 |
| 2010-01-29 07:15:00 | SPY | ETF | 108.75 | 108.75 | 108.68 | 108.71 | 148635.0 |
| 2010-01-29 07:20:00 | SPY | ETF | 108.71 | 108.71 | 108.64 | 108.65 | 13068.0 |
| 2010-01-29 07:25:00 | SPY | ETF | 108.64 | 108.68 | 108.59 | 108.59 | 6500.0 |
| 2010-01-29 07:30:00 | SPY | ETF | 108.61 | 108.66 | 108.6 | 108.6 | 17905.0 |
| 2010-01-29 07:35:00 | SPY | ETF | 108.65 | 108.7 | 108.59 | 108.63 | 118724.0 |
| 2010-01-29 07:40:00 | SPY | ETF | 108.65 | 108.75 | 108.63 | 108.75 | 40300.0 |
| 2010-01-29 07:45:00 | SPY | ETF | 108.76 | 108.78 | 108.71 | 108.78 | 10302.0 |
| 2010-01-29 07:50:00 | SPY | ETF | 108.8 | 108.84 | 108.79 | 108.84 | 119967.0 |
| 2010-01-29 07:55:00 | SPY | ETF | 108.85 | 108.85 | 108.8 | 108.8 | 28150.0 |
| 2010-01-29 08:00:00 | SPY | ETF | 108.77 | 108.85 | 108.73 | 108.8 | 84160.0 |
| 2010-01-29 08:05:00 | SPY | ETF | 108.82 | 108.85 | 108.81 | 108.85 | 57598.0 |
| 2010-01-29 08:10:00 | SPY | ETF | 108.86 | 108.88 | 108.83 | 108.83 | 72233.0 |
| 2010-01-29 08:15:00 | SPY | ETF | 108.84 | 108.88 | 108.83 | 108.87 | 95275.0 |
| 2010-01-29 08:20:00 | SPY | ETF | 108.86 | 108.94 | 108.84 | 108.9 | 566776.0 |
| 2010-01-29 08:25:00 | SPY | ETF | 108.91 | 109.01 | 108.9 | 108.97 | 431441.0 |
| 2010-01-29 08:30:00 | SPY | ETF | 108.97 | 109.33 | 108.85 | 109.22 | 3463848.0 |
| 2010-01-29 08:35:00 | SPY | ETF | 109.23 | 109.34 | 109.14 | 109.18 | 645768.0 |
| 2010-01-29 08:40:00 | SPY | ETF | 109.19 | 109.31 | 109.17 | 109.26 | 423129.0 |
| 2010-01-29 08:45:00 | SPY | ETF | 109.26 | 109.32 | 109.23 | 109.3 | 471402.0 |
| 2010-01-29 08:50:00 | SPY | ETF | 109.29 | 109.29 | 109.07 | 109.1 | 759666.0 |
| 2010-01-29 08:55:00 | SPY | ETF | 109.1 | 109.18 | 109.08 | 109.13 | 331759.0 |
| 2010-01-29 09:00:00 | SPY | ETF | 109.13 | 109.19 | 109.09 | 109.18 | 143839.0 |
| 2010-01-29 09:05:00 | SPY | ETF | 109.16 | 109.26 | 109.16 | 109.21 | 170210.0 |
> showing 50 of 33,763 rows — these rows as CSV