PREVIEW / etf_5min / 2009-12-28
file: by_date/etf_5min/2009/2009-12-28.parquet size: 684 KB rows: 30,310
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-28 04:20:00 | SPY | ETF | 112.64 | 112.65 | 112.64 | 112.65 | 400.0 |
| 2009-12-28 04:30:00 | SPY | ETF | 112.65 | 112.65 | 112.65 | 112.65 | 1976.0 |
| 2009-12-28 05:25:00 | SPY | ETF | 112.7 | 112.7 | 112.7 | 112.7 | 1000.0 |
| 2009-12-28 05:45:00 | SPY | ETF | 112.7 | 112.7 | 112.7 | 112.7 | 1000.0 |
| 2009-12-28 06:10:00 | SPY | ETF | 112.7 | 112.7 | 112.7 | 112.7 | 2500.0 |
| 2009-12-28 06:20:00 | SPY | ETF | 112.7 | 112.7 | 112.67 | 112.67 | 1700.0 |
| 2009-12-28 06:50:00 | SPY | ETF | 112.7 | 112.7 | 112.7 | 112.7 | 7500.0 |
| 2009-12-28 07:00:00 | SPY | ETF | 112.74 | 112.76 | 112.73 | 112.76 | 7115.0 |
| 2009-12-28 07:05:00 | SPY | ETF | 112.7 | 112.7 | 112.7 | 112.7 | 500.0 |
| 2009-12-28 07:10:00 | SPY | ETF | 112.72 | 112.72 | 112.69 | 112.69 | 600.0 |
| 2009-12-28 07:20:00 | SPY | ETF | 112.65 | 112.65 | 112.59 | 112.59 | 1300.0 |
| 2009-12-28 07:30:00 | SPY | ETF | 112.71 | 112.71 | 112.69 | 112.7 | 4000.0 |
| 2009-12-28 07:35:00 | SPY | ETF | 112.66 | 112.68 | 112.66 | 112.68 | 5100.0 |
| 2009-12-28 07:40:00 | SPY | ETF | 112.69 | 112.69 | 112.69 | 112.69 | 3200.0 |
| 2009-12-28 07:45:00 | SPY | ETF | 112.68 | 112.68 | 112.68 | 112.68 | 1000.0 |
| 2009-12-28 07:50:00 | SPY | ETF | 112.7 | 112.71 | 112.7 | 112.7 | 6230.0 |
| 2009-12-28 07:55:00 | SPY | ETF | 112.7 | 112.73 | 112.7 | 112.73 | 16111.0 |
| 2009-12-28 08:00:00 | SPY | ETF | 112.72 | 112.74 | 112.45 | 112.71 | 139720.0 |
| 2009-12-28 08:05:00 | SPY | ETF | 112.71 | 112.73 | 112.7 | 112.73 | 8473.0 |
| 2009-12-28 08:10:00 | SPY | ETF | 112.73 | 112.79 | 112.73 | 112.77 | 28141.0 |
| 2009-12-28 08:15:00 | SPY | ETF | 112.77 | 112.77 | 112.75 | 112.75 | 11586.0 |
| 2009-12-28 08:20:00 | SPY | ETF | 112.75 | 112.79 | 112.74 | 112.78 | 22901.0 |
| 2009-12-28 08:25:00 | SPY | ETF | 112.78 | 112.78 | 112.71 | 112.73 | 21948.0 |
| 2009-12-28 08:30:00 | SPY | ETF | 112.72 | 112.74 | 112.69 | 112.74 | 32278.0 |
| 2009-12-28 08:35:00 | SPY | ETF | 112.74 | 112.8 | 112.74 | 112.78 | 26265.0 |
| 2009-12-28 08:40:00 | SPY | ETF | 112.78 | 112.79 | 112.75 | 112.78 | 13764.0 |
| 2009-12-28 08:45:00 | SPY | ETF | 112.79 | 112.83 | 112.77 | 112.8 | 73742.0 |
| 2009-12-28 08:50:00 | SPY | ETF | 112.8 | 112.81 | 112.8 | 112.81 | 9747.0 |
| 2009-12-28 08:55:00 | SPY | ETF | 112.81 | 112.85 | 112.81 | 112.84 | 69883.0 |
| 2009-12-28 09:00:00 | SPY | ETF | 112.8 | 112.83 | 112.77 | 112.81 | 531669.0 |
| 2009-12-28 09:05:00 | SPY | ETF | 112.8 | 112.82 | 112.79 | 112.79 | 28866.0 |
| 2009-12-28 09:10:00 | SPY | ETF | 112.8 | 112.81 | 112.8 | 112.81 | 3505.0 |
| 2009-12-28 09:15:00 | SPY | ETF | 112.81 | 112.85 | 112.79 | 112.84 | 41357.0 |
| 2009-12-28 09:20:00 | SPY | ETF | 112.84 | 112.84 | 112.81 | 112.81 | 20269.0 |
| 2009-12-28 09:25:00 | SPY | ETF | 112.81 | 112.91 | 112.81 | 112.9 | 372910.0 |
| 2009-12-28 09:30:00 | SPY | ETF | 112.9 | 112.95 | 112.78 | 112.87 | 2785081.0 |
| 2009-12-28 09:35:00 | SPY | ETF | 112.86 | 112.99 | 112.85 | 112.9 | 1209757.0 |
| 2009-12-28 09:40:00 | SPY | ETF | 112.9 | 112.97 | 112.87 | 112.9 | 2052457.0 |
| 2009-12-28 09:45:00 | SPY | ETF | 112.8901 | 112.95 | 112.87 | 112.9 | 997796.0 |
| 2009-12-28 09:50:00 | SPY | ETF | 112.9 | 112.92 | 112.89 | 112.89 | 399107.0 |
| 2009-12-28 09:55:00 | SPY | ETF | 112.89 | 112.89 | 112.82 | 112.83 | 1061797.0 |
| 2009-12-28 10:00:00 | SPY | ETF | 112.83 | 112.86 | 112.78 | 112.832 | 836044.0 |
| 2009-12-28 10:05:00 | SPY | ETF | 112.8399 | 112.86 | 112.82 | 112.84 | 380339.0 |
| 2009-12-28 10:10:00 | SPY | ETF | 112.85 | 112.85 | 112.72 | 112.72 | 6732857.0 |
| 2009-12-28 10:15:00 | SPY | ETF | 112.72 | 112.7288 | 112.67 | 112.719 | 941356.0 |
| 2009-12-28 10:20:00 | SPY | ETF | 112.71 | 112.72 | 112.63 | 112.63 | 610638.0 |
| 2009-12-28 10:25:00 | SPY | ETF | 112.63 | 112.73 | 112.63 | 112.7078 | 930578.0 |
| 2009-12-28 10:30:00 | SPY | ETF | 112.7 | 112.71 | 112.65 | 112.6583 | 333847.0 |
| 2009-12-28 10:35:00 | SPY | ETF | 112.66 | 112.66 | 112.6 | 112.61 | 725251.0 |
| 2009-12-28 10:40:00 | SPY | ETF | 112.61 | 112.65 | 112.59 | 112.62 | 516298.0 |
> showing 50 of 30,310 rows — these rows as CSV