PREVIEW / etf_5min / 2009-09-11
file: by_date/etf_5min/2009/2009-09-11.parquet size: 706 KB rows: 29,992
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-09-11 04:20:00 | SPY | ETF | 104.6 | 104.6 | 104.57 | 104.57 | 300.0 |
| 2009-09-11 04:30:00 | SPY | ETF | 104.57 | 104.57 | 104.57 | 104.57 | 100.0 |
| 2009-09-11 04:35:00 | SPY | ETF | 104.6 | 104.6 | 104.6 | 104.6 | 200.0 |
| 2009-09-11 04:40:00 | SPY | ETF | 104.62 | 104.62 | 104.62 | 104.62 | 100.0 |
| 2009-09-11 04:45:00 | SPY | ETF | 104.62 | 104.62 | 104.62 | 104.62 | 400.0 |
| 2009-09-11 04:50:00 | SPY | ETF | 104.69 | 104.69 | 104.69 | 104.69 | 2000.0 |
| 2009-09-11 05:05:00 | SPY | ETF | 104.75 | 104.75 | 104.75 | 104.75 | 400.0 |
| 2009-09-11 05:20:00 | SPY | ETF | 104.85 | 104.85 | 104.85 | 104.85 | 178.0 |
| 2009-09-11 05:40:00 | SPY | ETF | 104.86 | 104.86 | 104.84 | 104.84 | 2100.0 |
| 2009-09-11 05:45:00 | SPY | ETF | 104.82 | 104.82 | 104.82 | 104.82 | 279.0 |
| 2009-09-11 05:55:00 | SPY | ETF | 104.81 | 104.81 | 104.81 | 104.81 | 1500.0 |
| 2009-09-11 06:05:00 | SPY | ETF | 104.73 | 104.76 | 104.73 | 104.76 | 5200.0 |
| 2009-09-11 06:10:00 | SPY | ETF | 104.78 | 104.82 | 104.78 | 104.82 | 10650.0 |
| 2009-09-11 06:15:00 | SPY | ETF | 104.83 | 104.83 | 104.83 | 104.83 | 200.0 |
| 2009-09-11 06:45:00 | SPY | ETF | 104.79 | 104.79 | 104.79 | 104.79 | 100.0 |
| 2009-09-11 06:50:00 | SPY | ETF | 104.83 | 104.88 | 104.83 | 104.88 | 7000.0 |
| 2009-09-11 06:55:00 | SPY | ETF | 104.86 | 104.87 | 104.86 | 104.87 | 200.0 |
| 2009-09-11 07:00:00 | SPY | ETF | 104.86 | 104.86 | 104.8 | 104.83 | 14507.0 |
| 2009-09-11 07:05:00 | SPY | ETF | 104.84 | 104.84 | 104.81 | 104.82 | 5610.0 |
| 2009-09-11 07:10:00 | SPY | ETF | 104.82 | 104.84 | 104.81 | 104.81 | 6504.0 |
| 2009-09-11 07:15:00 | SPY | ETF | 104.82 | 104.82 | 104.8 | 104.8 | 8100.0 |
| 2009-09-11 07:20:00 | SPY | ETF | 104.77 | 104.77 | 104.77 | 104.77 | 600.0 |
| 2009-09-11 07:25:00 | SPY | ETF | 104.77 | 104.78 | 104.76 | 104.78 | 19300.0 |
| 2009-09-11 07:30:00 | SPY | ETF | 104.78 | 104.79 | 104.76 | 104.79 | 6100.0 |
| 2009-09-11 07:35:00 | SPY | ETF | 104.78 | 104.78 | 104.78 | 104.78 | 500.0 |
| 2009-09-11 07:40:00 | SPY | ETF | 104.78 | 104.83 | 104.76 | 104.83 | 11692.0 |
| 2009-09-11 07:45:00 | SPY | ETF | 104.84 | 104.85 | 104.83 | 104.85 | 29886.0 |
| 2009-09-11 07:50:00 | SPY | ETF | 104.83 | 104.88 | 104.81 | 104.88 | 14365.0 |
| 2009-09-11 07:55:00 | SPY | ETF | 104.87 | 104.87 | 104.81 | 104.82 | 11119.0 |
| 2009-09-11 08:00:00 | SPY | ETF | 104.81 | 104.84 | 104.77 | 104.81 | 63589.0 |
| 2009-09-11 08:05:00 | SPY | ETF | 104.8 | 104.8 | 104.78 | 104.78 | 14459.0 |
| 2009-09-11 08:10:00 | SPY | ETF | 104.79 | 104.8 | 104.76 | 104.78 | 73061.0 |
| 2009-09-11 08:15:00 | SPY | ETF | 104.78 | 104.78 | 104.74 | 104.76 | 77418.0 |
| 2009-09-11 08:20:00 | SPY | ETF | 104.75 | 104.79 | 104.73 | 104.79 | 54682.0 |
| 2009-09-11 08:25:00 | SPY | ETF | 104.78 | 104.79 | 104.76 | 104.77 | 29460.0 |
| 2009-09-11 08:30:00 | SPY | ETF | 104.77 | 104.8 | 104.76 | 104.79 | 47298.0 |
| 2009-09-11 08:35:00 | SPY | ETF | 104.79 | 104.82 | 104.79 | 104.8 | 42350.0 |
| 2009-09-11 08:40:00 | SPY | ETF | 104.8 | 104.84 | 104.77 | 104.81 | 175975.0 |
| 2009-09-11 08:45:00 | SPY | ETF | 104.82 | 104.87 | 104.81 | 104.87 | 106750.0 |
| 2009-09-11 08:50:00 | SPY | ETF | 104.87 | 104.87 | 104.74 | 104.75 | 168352.0 |
| 2009-09-11 08:55:00 | SPY | ETF | 104.76 | 104.86 | 104.75 | 104.82 | 259104.0 |
| 2009-09-11 09:00:00 | SPY | ETF | 104.81 | 105.09 | 104.81 | 105.01 | 1377193.0 |
| 2009-09-11 09:05:00 | SPY | ETF | 105.01 | 105.03 | 104.97 | 104.99 | 395381.0 |
| 2009-09-11 09:10:00 | SPY | ETF | 104.99 | 105.03 | 104.94 | 104.95 | 604424.0 |
| 2009-09-11 09:15:00 | SPY | ETF | 104.95 | 105.0 | 104.92 | 104.94 | 212234.0 |
| 2009-09-11 09:20:00 | SPY | ETF | 104.94 | 105.04 | 104.94 | 105.03 | 303032.0 |
| 2009-09-11 09:25:00 | SPY | ETF | 105.03 | 105.09 | 104.98 | 104.99 | 320984.0 |
| 2009-09-11 09:30:00 | SPY | ETF | 104.99 | 105.03 | 104.84 | 104.88 | 4702996.0 |
| 2009-09-11 09:35:00 | SPY | ETF | 104.89 | 105.24 | 104.88 | 105.1803 | 5887503.0 |
| 2009-09-11 09:40:00 | SPY | ETF | 105.18 | 105.2 | 104.9 | 104.93 | 4854348.0 |
> showing 50 of 29,992 rows — these rows as CSV