PREVIEW / etf_5min / 2010-07-13
file: by_date/etf_5min/2010/2010-07-13.parquet size: 818 KB rows: 34,077
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-07-13 04:15:00 | SPY | ETF | 108.08 | 108.08 | 108.03 | 108.03 | 3050.0 |
| 2010-07-13 04:20:00 | SPY | ETF | 108.07 | 108.1 | 108.07 | 108.1 | 200.0 |
| 2010-07-13 04:30:00 | SPY | ETF | 108.29 | 108.29 | 108.29 | 108.29 | 1100.0 |
| 2010-07-13 04:35:00 | SPY | ETF | 108.44 | 108.51 | 108.44 | 108.51 | 200.0 |
| 2010-07-13 04:40:00 | SPY | ETF | 108.64 | 108.64 | 108.64 | 108.64 | 200.0 |
| 2010-07-13 04:45:00 | SPY | ETF | 108.6 | 108.6 | 108.6 | 108.6 | 100.0 |
| 2010-07-13 05:00:00 | SPY | ETF | 108.6 | 108.6 | 108.6 | 108.6 | 100.0 |
| 2010-07-13 05:05:00 | SPY | ETF | 108.62 | 108.62 | 108.62 | 108.62 | 100.0 |
| 2010-07-13 05:10:00 | SPY | ETF | 108.62 | 108.65 | 108.6 | 108.65 | 1000.0 |
| 2010-07-13 05:15:00 | SPY | ETF | 108.71 | 108.81 | 108.66 | 108.81 | 1300.0 |
| 2010-07-13 05:20:00 | SPY | ETF | 108.82 | 108.91 | 108.82 | 108.91 | 700.0 |
| 2010-07-13 05:25:00 | SPY | ETF | 108.88 | 108.93 | 108.88 | 108.93 | 300.0 |
| 2010-07-13 05:30:00 | SPY | ETF | 108.9 | 108.93 | 108.9 | 108.93 | 200.0 |
| 2010-07-13 05:35:00 | SPY | ETF | 108.77 | 108.77 | 108.75 | 108.75 | 15000.0 |
| 2010-07-13 05:50:00 | SPY | ETF | 108.82 | 108.85 | 108.82 | 108.85 | 1200.0 |
| 2010-07-13 05:55:00 | SPY | ETF | 108.87 | 108.88 | 108.87 | 108.88 | 300.0 |
| 2010-07-13 06:00:00 | SPY | ETF | 108.86 | 108.86 | 108.86 | 108.86 | 100.0 |
| 2010-07-13 06:15:00 | SPY | ETF | 108.8 | 108.8 | 108.79 | 108.79 | 1500.0 |
| 2010-07-13 06:20:00 | SPY | ETF | 108.82 | 108.82 | 108.77 | 108.77 | 11500.0 |
| 2010-07-13 06:25:00 | SPY | ETF | 108.77 | 108.85 | 108.77 | 108.85 | 2600.0 |
| 2010-07-13 06:30:00 | SPY | ETF | 108.79 | 108.79 | 108.79 | 108.79 | 100.0 |
| 2010-07-13 06:35:00 | SPY | ETF | 108.85 | 108.88 | 108.85 | 108.88 | 20000.0 |
| 2010-07-13 06:40:00 | SPY | ETF | 108.85 | 108.85 | 108.85 | 108.85 | 100.0 |
| 2010-07-13 06:45:00 | SPY | ETF | 108.85 | 108.85 | 108.85 | 108.85 | 100.0 |
| 2010-07-13 06:50:00 | SPY | ETF | 108.85 | 108.85 | 108.82 | 108.82 | 4300.0 |
| 2010-07-13 06:55:00 | SPY | ETF | 108.79 | 108.79 | 108.79 | 108.79 | 7700.0 |
| 2010-07-13 07:00:00 | SPY | ETF | 108.79 | 108.81 | 108.77 | 108.81 | 35425.0 |
| 2010-07-13 07:05:00 | SPY | ETF | 108.8 | 108.82 | 108.75 | 108.79 | 45000.0 |
| 2010-07-13 07:10:00 | SPY | ETF | 108.78 | 108.78 | 108.75 | 108.77 | 6200.0 |
| 2010-07-13 07:15:00 | SPY | ETF | 108.77 | 108.84 | 108.77 | 108.81 | 63000.0 |
| 2010-07-13 07:20:00 | SPY | ETF | 108.83 | 108.88 | 108.83 | 108.88 | 72625.0 |
| 2010-07-13 07:25:00 | SPY | ETF | 108.89 | 109.0 | 108.89 | 108.99 | 156251.0 |
| 2010-07-13 07:30:00 | SPY | ETF | 108.99 | 109.0 | 108.95 | 108.95 | 100751.0 |
| 2010-07-13 07:35:00 | SPY | ETF | 108.95 | 109.05 | 108.95 | 109.01 | 37400.0 |
| 2010-07-13 07:40:00 | SPY | ETF | 109.01 | 109.04 | 109.01 | 109.01 | 61325.0 |
| 2010-07-13 07:45:00 | SPY | ETF | 108.98 | 109.02 | 108.93 | 108.97 | 49701.0 |
| 2010-07-13 07:50:00 | SPY | ETF | 108.96 | 108.97 | 108.93 | 108.96 | 20950.0 |
| 2010-07-13 07:55:00 | SPY | ETF | 108.96 | 109.0 | 108.94 | 108.99 | 92543.0 |
| 2010-07-13 08:00:00 | SPY | ETF | 108.97 | 109.02 | 108.56 | 109.02 | 276050.0 |
| 2010-07-13 08:05:00 | SPY | ETF | 109.01 | 109.03 | 108.97 | 108.97 | 198255.0 |
| 2010-07-13 08:10:00 | SPY | ETF | 108.97 | 109.04 | 108.96 | 108.98 | 36450.0 |
| 2010-07-13 08:15:00 | SPY | ETF | 108.97 | 109.07 | 108.97 | 109.06 | 63767.0 |
| 2010-07-13 08:20:00 | SPY | ETF | 109.04 | 109.08 | 109.04 | 109.06 | 85448.0 |
| 2010-07-13 08:25:00 | SPY | ETF | 109.07 | 109.08 | 109.05 | 109.06 | 32640.0 |
| 2010-07-13 08:30:00 | SPY | ETF | 109.05 | 109.13 | 109.01 | 109.11 | 131057.0 |
| 2010-07-13 08:35:00 | SPY | ETF | 109.1 | 109.18 | 109.09 | 109.13 | 174135.0 |
| 2010-07-13 08:40:00 | SPY | ETF | 109.14 | 109.16 | 109.1 | 109.15 | 45050.0 |
| 2010-07-13 08:45:00 | SPY | ETF | 109.16 | 109.16 | 109.09 | 109.12 | 106460.0 |
| 2010-07-13 08:50:00 | SPY | ETF | 109.11 | 109.18 | 109.11 | 109.12 | 192744.0 |
| 2010-07-13 08:55:00 | SPY | ETF | 109.13 | 109.16 | 109.11 | 109.12 | 137526.0 |
> showing 50 of 34,077 rows — these rows as CSV