PREVIEW / etf_5min / 2009-12-31
file: by_date/etf_5min/2009/2009-12-31.parquet size: 674 KB rows: 29,296
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-12-31 04:15:00 | SPY | ETF | 112.6 | 112.6 | 112.6 | 112.6 | 100.0 |
| 2009-12-31 05:10:00 | SPY | ETF | 112.74 | 112.74 | 112.74 | 112.74 | 100.0 |
| 2009-12-31 06:35:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 200.0 |
| 2009-12-31 07:05:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 400.0 |
| 2009-12-31 07:10:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 300.0 |
| 2009-12-31 07:15:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 500.0 |
| 2009-12-31 07:20:00 | SPY | ETF | 112.9 | 112.9 | 112.89 | 112.89 | 1960.0 |
| 2009-12-31 07:25:00 | SPY | ETF | 112.87 | 112.87 | 112.84 | 112.87 | 1600.0 |
| 2009-12-31 07:35:00 | SPY | ETF | 112.82 | 112.87 | 112.82 | 112.87 | 2400.0 |
| 2009-12-31 07:40:00 | SPY | ETF | 112.85 | 112.87 | 112.85 | 112.87 | 35810.0 |
| 2009-12-31 07:45:00 | SPY | ETF | 112.82 | 112.85 | 112.8 | 112.85 | 16313.0 |
| 2009-12-31 07:50:00 | SPY | ETF | 112.85 | 112.85 | 112.85 | 112.85 | 8505.0 |
| 2009-12-31 07:55:00 | SPY | ETF | 112.84 | 112.84 | 112.84 | 112.84 | 600.0 |
| 2009-12-31 08:00:00 | SPY | ETF | 112.84 | 112.84 | 112.8 | 112.81 | 58781.0 |
| 2009-12-31 08:05:00 | SPY | ETF | 112.82 | 112.86 | 112.81 | 112.82 | 21790.0 |
| 2009-12-31 08:10:00 | SPY | ETF | 112.82 | 112.84 | 112.82 | 112.84 | 16388.0 |
| 2009-12-31 08:15:00 | SPY | ETF | 112.82 | 112.86 | 112.82 | 112.85 | 52401.0 |
| 2009-12-31 08:20:00 | SPY | ETF | 112.84 | 112.84 | 112.82 | 112.82 | 18900.0 |
| 2009-12-31 08:25:00 | SPY | ETF | 112.82 | 112.82 | 112.71 | 112.76 | 619581.0 |
| 2009-12-31 08:30:00 | SPY | ETF | 112.77 | 112.89 | 112.75 | 112.76 | 353758.0 |
| 2009-12-31 08:35:00 | SPY | ETF | 112.76 | 112.8 | 112.73 | 112.79 | 80392.0 |
| 2009-12-31 08:40:00 | SPY | ETF | 112.79 | 112.81 | 112.78 | 112.79 | 49335.0 |
| 2009-12-31 08:45:00 | SPY | ETF | 112.78 | 112.92 | 112.76 | 112.86 | 360638.0 |
| 2009-12-31 08:50:00 | SPY | ETF | 112.85 | 112.86 | 112.83 | 112.84 | 27469.0 |
| 2009-12-31 08:55:00 | SPY | ETF | 112.83 | 112.87 | 112.81 | 112.86 | 121855.0 |
| 2009-12-31 09:00:00 | SPY | ETF | 112.85 | 112.86 | 112.83 | 112.84 | 118235.0 |
| 2009-12-31 09:05:00 | SPY | ETF | 112.84 | 112.85 | 112.84 | 112.84 | 11364.0 |
| 2009-12-31 09:10:00 | SPY | ETF | 112.85 | 112.86 | 112.78 | 112.81 | 80553.0 |
| 2009-12-31 09:15:00 | SPY | ETF | 112.81 | 112.82 | 112.77 | 112.79 | 69910.0 |
| 2009-12-31 09:20:00 | SPY | ETF | 112.79 | 112.79 | 112.77 | 112.78 | 158360.0 |
| 2009-12-31 09:25:00 | SPY | ETF | 112.78 | 112.79 | 112.76 | 112.77 | 86857.0 |
| 2009-12-31 09:30:00 | SPY | ETF | 112.77 | 112.8 | 112.7 | 112.74 | 1782594.0 |
| 2009-12-31 09:35:00 | SPY | ETF | 112.74 | 112.77 | 112.67 | 112.68 | 1086136.0 |
| 2009-12-31 09:40:00 | SPY | ETF | 112.68 | 112.68 | 112.62 | 112.63 | 983759.0 |
| 2009-12-31 09:45:00 | SPY | ETF | 112.62 | 112.68 | 112.62 | 112.67 | 888451.0 |
| 2009-12-31 09:50:00 | SPY | ETF | 112.669 | 112.75 | 112.66 | 112.69 | 1061994.0 |
| 2009-12-31 09:55:00 | SPY | ETF | 112.6899 | 112.69 | 112.61 | 112.62 | 458748.0 |
| 2009-12-31 10:00:00 | SPY | ETF | 112.6174 | 112.62 | 112.59 | 112.6 | 767558.0 |
| 2009-12-31 10:05:00 | SPY | ETF | 112.6 | 112.61 | 112.5 | 112.61 | 1058475.0 |
| 2009-12-31 10:10:00 | SPY | ETF | 112.6 | 112.61 | 112.41 | 112.47 | 1541365.0 |
| 2009-12-31 10:15:00 | SPY | ETF | 112.48 | 112.52 | 112.46 | 112.48 | 661069.0 |
| 2009-12-31 10:20:00 | SPY | ETF | 112.48 | 112.51 | 112.45 | 112.51 | 524679.0 |
| 2009-12-31 10:25:00 | SPY | ETF | 112.505 | 112.51 | 112.44 | 112.46 | 386021.0 |
| 2009-12-31 10:30:00 | SPY | ETF | 112.45 | 112.46 | 112.39 | 112.4 | 1156366.0 |
| 2009-12-31 10:35:00 | SPY | ETF | 112.39 | 112.4 | 112.35 | 112.35 | 752903.0 |
| 2009-12-31 10:40:00 | SPY | ETF | 112.365 | 112.4 | 112.33 | 112.38 | 543801.0 |
| 2009-12-31 10:45:00 | SPY | ETF | 112.39 | 112.43 | 112.3881 | 112.41 | 497785.0 |
| 2009-12-31 10:50:00 | SPY | ETF | 112.42 | 112.44 | 112.41 | 112.42 | 367006.0 |
| 2009-12-31 10:55:00 | SPY | ETF | 112.42 | 112.43 | 112.4 | 112.4 | 1144445.0 |
| 2009-12-31 11:00:00 | SPY | ETF | 112.4 | 112.41 | 112.35 | 112.35 | 487204.0 |
> showing 50 of 29,296 rows — these rows as CSV