PREVIEW / etf_5min / 2009-12-29
file: by_date/etf_5min/2009/2009-12-29.parquet size: 662 KB rows: 29,182
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-29 05:35:00 | SPY | ETF | 112.89 | 112.89 | 112.89 | 112.89 | 650.0 |
| 2009-12-29 06:20:00 | SPY | ETF | 112.92 | 112.92 | 112.92 | 112.92 | 3000.0 |
| 2009-12-29 06:40:00 | SPY | ETF | 112.98 | 113.0 | 112.98 | 113.0 | 600.0 |
| 2009-12-29 06:45:00 | SPY | ETF | 113.16 | 113.16 | 113.16 | 113.16 | 5000.0 |
| 2009-12-29 06:50:00 | SPY | ETF | 113.16 | 113.16 | 113.15 | 113.15 | 500.0 |
| 2009-12-29 07:00:00 | SPY | ETF | 113.12 | 113.12 | 113.1 | 113.11 | 16000.0 |
| 2009-12-29 07:05:00 | SPY | ETF | 113.06 | 113.06 | 113.06 | 113.06 | 20980.0 |
| 2009-12-29 07:10:00 | SPY | ETF | 113.06 | 113.06 | 113.06 | 113.06 | 2480.0 |
| 2009-12-29 07:15:00 | SPY | ETF | 113.08 | 113.08 | 113.08 | 113.08 | 3400.0 |
| 2009-12-29 07:20:00 | SPY | ETF | 113.06 | 113.06 | 113.06 | 113.06 | 10000.0 |
| 2009-12-29 07:25:00 | SPY | ETF | 113.06 | 113.08 | 113.06 | 113.08 | 15200.0 |
| 2009-12-29 07:30:00 | SPY | ETF | 113.08 | 113.1 | 113.06 | 113.09 | 4100.0 |
| 2009-12-29 07:35:00 | SPY | ETF | 113.1 | 113.1 | 113.08 | 113.08 | 800.0 |
| 2009-12-29 07:40:00 | SPY | ETF | 113.1 | 113.12 | 113.06 | 113.09 | 25087.0 |
| 2009-12-29 07:45:00 | SPY | ETF | 113.09 | 113.09 | 113.07 | 113.08 | 12225.0 |
| 2009-12-29 07:50:00 | SPY | ETF | 113.06 | 113.08 | 113.06 | 113.08 | 700.0 |
| 2009-12-29 07:55:00 | SPY | ETF | 113.09 | 113.11 | 113.08 | 113.1 | 86098.0 |
| 2009-12-29 08:00:00 | SPY | ETF | 113.09 | 113.11 | 113.07 | 113.11 | 45404.0 |
| 2009-12-29 08:05:00 | SPY | ETF | 113.11 | 113.11 | 113.04 | 113.04 | 67408.0 |
| 2009-12-29 08:10:00 | SPY | ETF | 113.03 | 113.08 | 113.01 | 113.02 | 166546.0 |
| 2009-12-29 08:15:00 | SPY | ETF | 113.04 | 113.05 | 113.01 | 113.05 | 15108.0 |
| 2009-12-29 08:20:00 | SPY | ETF | 113.05 | 113.05 | 112.98 | 113.0 | 68604.0 |
| 2009-12-29 08:25:00 | SPY | ETF | 112.99 | 113.08 | 112.98 | 113.08 | 68512.0 |
| 2009-12-29 08:30:00 | SPY | ETF | 113.06 | 113.08 | 113.05 | 113.07 | 37251.0 |
| 2009-12-29 08:35:00 | SPY | ETF | 113.07 | 113.08 | 113.06 | 113.07 | 50048.0 |
| 2009-12-29 08:40:00 | SPY | ETF | 113.07 | 113.08 | 113.03 | 113.04 | 107925.0 |
| 2009-12-29 08:45:00 | SPY | ETF | 113.04 | 113.05 | 113.02 | 113.02 | 74852.0 |
| 2009-12-29 08:50:00 | SPY | ETF | 113.02 | 113.06 | 113.02 | 113.05 | 59096.0 |
| 2009-12-29 08:55:00 | SPY | ETF | 113.05 | 113.06 | 112.99 | 113.02 | 71161.0 |
| 2009-12-29 09:00:00 | SPY | ETF | 113.03 | 113.12 | 113.03 | 113.08 | 300952.0 |
| 2009-12-29 09:05:00 | SPY | ETF | 113.08 | 113.1 | 113.07 | 113.09 | 51575.0 |
| 2009-12-29 09:10:00 | SPY | ETF | 113.08 | 113.09 | 113.05 | 113.07 | 68515.0 |
| 2009-12-29 09:15:00 | SPY | ETF | 113.06 | 113.08 | 113.06 | 113.06 | 27702.0 |
| 2009-12-29 09:20:00 | SPY | ETF | 113.07 | 113.07 | 113.03 | 113.04 | 42351.0 |
| 2009-12-29 09:25:00 | SPY | ETF | 113.04 | 113.05 | 112.99 | 113.01 | 144396.0 |
| 2009-12-29 09:30:00 | SPY | ETF | 113.01 | 113.03 | 112.95 | 113.02 | 2447292.0 |
| 2009-12-29 09:35:00 | SPY | ETF | 113.02 | 113.02 | 112.85 | 112.88 | 2622149.0 |
| 2009-12-29 09:40:00 | SPY | ETF | 112.89 | 112.92 | 112.82 | 112.84 | 1231006.0 |
| 2009-12-29 09:45:00 | SPY | ETF | 112.83 | 112.94 | 112.8101 | 112.88 | 890336.0 |
| 2009-12-29 09:50:00 | SPY | ETF | 112.8899 | 112.92 | 112.85 | 112.9 | 983379.0 |
| 2009-12-29 09:55:00 | SPY | ETF | 112.9 | 112.92 | 112.84 | 112.88 | 949672.0 |
| 2009-12-29 10:00:00 | SPY | ETF | 112.89 | 112.89 | 112.8 | 112.82 | 1596020.0 |
| 2009-12-29 10:05:00 | SPY | ETF | 112.82 | 112.85 | 112.76 | 112.82 | 1282587.0 |
| 2009-12-29 10:10:00 | SPY | ETF | 112.825 | 112.92 | 112.82 | 112.89 | 1180026.0 |
| 2009-12-29 10:15:00 | SPY | ETF | 112.89 | 112.96 | 112.88 | 112.95 | 1587468.0 |
| 2009-12-29 10:20:00 | SPY | ETF | 112.95 | 112.98 | 112.93 | 112.94 | 774524.0 |
| 2009-12-29 10:25:00 | SPY | ETF | 112.94 | 112.99 | 112.93 | 112.97 | 809818.0 |
| 2009-12-29 10:30:00 | SPY | ETF | 112.97 | 112.99 | 112.94 | 112.96 | 690442.0 |
| 2009-12-29 10:35:00 | SPY | ETF | 112.95 | 112.96 | 112.89 | 112.89 | 891740.0 |
| 2009-12-29 10:40:00 | SPY | ETF | 112.89 | 112.92 | 112.87 | 112.87 | 468495.0 |
> showing 50 of 29,182 rows — these rows as CSV