PREVIEW / etf_5min / 2010-03-16
file: by_date/etf_5min/2010/2010-03-16.parquet size: 748 KB rows: 31,744
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-03-16 04:15:00 | SPY | ETF | 115.48 | 115.48 | 115.48 | 115.48 | 665.0 |
| 2010-03-16 04:45:00 | SPY | ETF | 115.55 | 115.55 | 115.55 | 115.55 | 100.0 |
| 2010-03-16 05:00:00 | SPY | ETF | 115.64 | 115.64 | 115.64 | 115.64 | 100.0 |
| 2010-03-16 05:10:00 | SPY | ETF | 115.68 | 115.68 | 115.68 | 115.68 | 200.0 |
| 2010-03-16 05:20:00 | SPY | ETF | 115.68 | 115.68 | 115.68 | 115.68 | 100.0 |
| 2010-03-16 05:50:00 | SPY | ETF | 115.74 | 115.74 | 115.74 | 115.74 | 100.0 |
| 2010-03-16 05:55:00 | SPY | ETF | 115.68 | 115.68 | 115.68 | 115.68 | 700.0 |
| 2010-03-16 06:00:00 | SPY | ETF | 115.74 | 115.74 | 115.71 | 115.71 | 500.0 |
| 2010-03-16 06:05:00 | SPY | ETF | 115.7 | 115.7 | 115.7 | 115.7 | 100.0 |
| 2010-03-16 06:25:00 | SPY | ETF | 115.7 | 115.7 | 115.7 | 115.7 | 2500.0 |
| 2010-03-16 06:30:00 | SPY | ETF | 115.65 | 115.65 | 115.65 | 115.65 | 2000.0 |
| 2010-03-16 06:35:00 | SPY | ETF | 115.65 | 115.65 | 115.65 | 115.65 | 500.0 |
| 2010-03-16 06:40:00 | SPY | ETF | 115.67 | 115.71 | 115.67 | 115.71 | 1025.0 |
| 2010-03-16 07:00:00 | SPY | ETF | 115.76 | 115.79 | 115.76 | 115.79 | 23300.0 |
| 2010-03-16 07:05:00 | SPY | ETF | 115.79 | 115.79 | 115.78 | 115.78 | 2100.0 |
| 2010-03-16 07:20:00 | SPY | ETF | 115.75 | 115.75 | 115.72 | 115.72 | 21800.0 |
| 2010-03-16 07:25:00 | SPY | ETF | 115.76 | 115.78 | 115.76 | 115.78 | 7225.0 |
| 2010-03-16 07:30:00 | SPY | ETF | 115.8 | 115.8 | 115.75 | 115.76 | 27500.0 |
| 2010-03-16 07:35:00 | SPY | ETF | 115.76 | 115.78 | 115.72 | 115.75 | 60100.0 |
| 2010-03-16 07:40:00 | SPY | ETF | 115.73 | 115.74 | 115.73 | 115.74 | 4800.0 |
| 2010-03-16 07:45:00 | SPY | ETF | 115.72 | 115.72 | 115.7 | 115.71 | 22170.0 |
| 2010-03-16 07:50:00 | SPY | ETF | 115.71 | 115.71 | 115.7 | 115.7 | 13400.0 |
| 2010-03-16 07:55:00 | SPY | ETF | 115.71 | 115.71 | 115.69 | 115.7 | 2800.0 |
| 2010-03-16 08:00:00 | SPY | ETF | 115.71 | 115.74 | 115.71 | 115.73 | 55300.0 |
| 2010-03-16 08:05:00 | SPY | ETF | 115.71 | 115.75 | 115.7 | 115.74 | 103418.0 |
| 2010-03-16 08:10:00 | SPY | ETF | 115.75 | 115.77 | 115.7 | 115.7 | 80247.0 |
| 2010-03-16 08:15:00 | SPY | ETF | 115.7 | 115.71 | 115.69 | 115.7 | 33025.0 |
| 2010-03-16 08:20:00 | SPY | ETF | 115.69 | 115.71 | 115.69 | 115.7 | 49625.0 |
| 2010-03-16 08:25:00 | SPY | ETF | 115.71 | 115.72 | 115.65 | 115.65 | 355460.0 |
| 2010-03-16 08:30:00 | SPY | ETF | 115.66 | 115.83 | 115.64 | 115.75 | 265445.0 |
| 2010-03-16 08:35:00 | SPY | ETF | 115.74 | 115.81 | 115.74 | 115.78 | 376459.0 |
| 2010-03-16 08:40:00 | SPY | ETF | 115.78 | 115.78 | 115.7 | 115.71 | 73660.0 |
| 2010-03-16 08:45:00 | SPY | ETF | 115.71 | 115.72 | 115.7 | 115.7 | 141673.0 |
| 2010-03-16 08:50:00 | SPY | ETF | 115.71 | 115.72 | 115.7 | 115.72 | 29607.0 |
| 2010-03-16 08:55:00 | SPY | ETF | 115.72 | 115.73 | 115.7 | 115.73 | 31680.0 |
| 2010-03-16 09:00:00 | SPY | ETF | 115.72 | 115.75 | 115.72 | 115.75 | 48941.0 |
| 2010-03-16 09:05:00 | SPY | ETF | 115.76 | 115.8 | 115.73 | 115.77 | 64887.0 |
| 2010-03-16 09:10:00 | SPY | ETF | 115.78 | 115.88 | 115.77 | 115.84 | 112514.0 |
| 2010-03-16 09:15:00 | SPY | ETF | 115.84 | 115.85 | 115.73 | 115.73 | 515104.0 |
| 2010-03-16 09:20:00 | SPY | ETF | 115.73 | 115.83 | 115.73 | 115.79 | 424387.0 |
| 2010-03-16 09:25:00 | SPY | ETF | 115.79 | 115.84 | 115.79 | 115.81 | 254050.0 |
| 2010-03-16 09:30:00 | SPY | ETF | 115.81 | 115.84 | 115.66 | 115.69 | 3953971.0 |
| 2010-03-16 09:35:00 | SPY | ETF | 115.69 | 115.79 | 115.67 | 115.7 | 2753339.0 |
| 2010-03-16 09:40:00 | SPY | ETF | 115.7 | 115.7 | 115.54 | 115.64 | 3822543.0 |
| 2010-03-16 09:45:00 | SPY | ETF | 115.64 | 115.69 | 115.58 | 115.6 | 1285086.0 |
| 2010-03-16 09:50:00 | SPY | ETF | 115.6 | 115.61 | 115.49 | 115.5599 | 2658331.0 |
| 2010-03-16 09:55:00 | SPY | ETF | 115.55 | 115.72 | 115.52 | 115.72 | 1673598.0 |
| 2010-03-16 10:00:00 | SPY | ETF | 115.71 | 115.79 | 115.65 | 115.73 | 1988643.0 |
| 2010-03-16 10:05:00 | SPY | ETF | 115.73 | 115.82 | 115.7 | 115.76 | 1539363.0 |
| 2010-03-16 10:10:00 | SPY | ETF | 115.755 | 115.82 | 115.71 | 115.81 | 1747034.0 |
> showing 50 of 31,744 rows — these rows as CSV