PREVIEW / etf_5min / 2007-06-14
file: by_date/etf_5min/2007/2007-06-14.parquet size: 295 KB rows: 16,511
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-14 06:05:00 | SPY | ETF | 151.95 | 151.95 | 151.95 | 151.95 | 15000.0 |
| 2007-06-14 06:30:00 | SPY | ETF | 151.91 | 151.91 | 151.91 | 151.91 | 200.0 |
| 2007-06-14 06:50:00 | SPY | ETF | 152.0 | 152.0 | 152.0 | 152.0 | 2000.0 |
| 2007-06-14 06:55:00 | SPY | ETF | 151.99 | 151.99 | 151.99 | 151.99 | 4000.0 |
| 2007-06-14 07:00:00 | SPY | ETF | 151.92 | 151.98 | 151.91 | 151.91 | 24100.0 |
| 2007-06-14 07:05:00 | SPY | ETF | 151.95 | 151.95 | 151.95 | 151.95 | 2500.0 |
| 2007-06-14 07:15:00 | SPY | ETF | 151.95 | 151.97 | 151.95 | 151.95 | 8200.0 |
| 2007-06-14 07:20:00 | SPY | ETF | 151.97 | 151.98 | 151.96 | 151.96 | 15100.0 |
| 2007-06-14 07:25:00 | SPY | ETF | 151.97 | 152.07 | 151.97 | 152.06 | 42800.0 |
| 2007-06-14 07:30:00 | SPY | ETF | 152.07 | 152.14 | 152.02 | 152.1 | 57400.0 |
| 2007-06-14 07:35:00 | SPY | ETF | 152.13 | 152.15 | 152.13 | 152.15 | 3600.0 |
| 2007-06-14 07:40:00 | SPY | ETF | 152.19 | 152.19 | 152.13 | 152.16 | 48800.0 |
| 2007-06-14 07:45:00 | SPY | ETF | 152.19 | 152.25 | 152.15 | 152.25 | 50300.0 |
| 2007-06-14 07:50:00 | SPY | ETF | 152.26 | 152.3 | 152.25 | 152.25 | 55000.0 |
| 2007-06-14 07:55:00 | SPY | ETF | 152.25 | 152.25 | 152.22 | 152.24 | 53700.0 |
| 2007-06-14 08:00:00 | SPY | ETF | 152.28 | 152.33 | 151.94 | 152.33 | 490500.0 |
| 2007-06-14 08:05:00 | SPY | ETF | 152.32 | 152.35 | 152.29 | 152.35 | 48900.0 |
| 2007-06-14 08:10:00 | SPY | ETF | 152.36 | 152.36 | 152.29 | 152.3 | 52100.0 |
| 2007-06-14 08:15:00 | SPY | ETF | 152.3 | 152.37 | 152.26 | 152.34 | 290200.0 |
| 2007-06-14 08:20:00 | SPY | ETF | 152.35 | 152.37 | 152.25 | 152.29 | 264700.0 |
| 2007-06-14 08:25:00 | SPY | ETF | 152.29 | 152.33 | 152.18 | 152.3 | 879500.0 |
| 2007-06-14 08:30:00 | SPY | ETF | 152.27 | 152.32 | 151.85 | 151.85 | 2922400.0 |
| 2007-06-14 08:35:00 | SPY | ETF | 151.87 | 152.06 | 151.86 | 152.01 | 995400.0 |
| 2007-06-14 08:40:00 | SPY | ETF | 152.01 | 152.21 | 151.96 | 152.21 | 320600.0 |
| 2007-06-14 08:45:00 | SPY | ETF | 152.2 | 152.27 | 152.16 | 152.21 | 1070300.0 |
| 2007-06-14 08:50:00 | SPY | ETF | 152.23 | 152.26 | 152.21 | 152.21 | 445900.0 |
| 2007-06-14 08:55:00 | SPY | ETF | 152.21 | 152.21 | 151.99 | 152.03 | 228400.0 |
| 2007-06-14 09:00:00 | SPY | ETF | 152.06 | 152.1 | 151.98 | 152.1 | 803200.0 |
| 2007-06-14 09:05:00 | SPY | ETF | 152.1 | 152.1 | 152.01 | 152.05 | 80500.0 |
| 2007-06-14 09:10:00 | SPY | ETF | 152.05 | 152.06 | 151.98 | 152.01 | 151907.0 |
| 2007-06-14 09:15:00 | SPY | ETF | 152.0 | 152.07 | 152.0 | 152.07 | 59300.0 |
| 2007-06-14 09:20:00 | SPY | ETF | 152.07 | 152.09 | 152.06 | 152.08 | 98479.0 |
| 2007-06-14 09:25:00 | SPY | ETF | 152.07 | 152.09 | 152.05 | 152.06 | 275200.0 |
| 2007-06-14 09:30:00 | SPY | ETF | 152.08 | 152.2664 | 152.03 | 152.19 | 1522660.0 |
| 2007-06-14 09:35:00 | SPY | ETF | 152.2 | 152.4 | 152.12 | 152.29 | 4004083.0 |
| 2007-06-14 09:40:00 | SPY | ETF | 152.28 | 152.49 | 152.25 | 152.44 | 5040735.0 |
| 2007-06-14 09:45:00 | SPY | ETF | 152.43 | 152.61 | 152.26 | 152.6 | 4496974.0 |
| 2007-06-14 09:50:00 | SPY | ETF | 152.59 | 152.67 | 152.54 | 152.65 | 5237636.0 |
| 2007-06-14 09:55:00 | SPY | ETF | 152.65 | 152.81 | 152.59 | 152.77 | 3332580.0 |
| 2007-06-14 10:00:00 | SPY | ETF | 152.77 | 152.77 | 152.64 | 152.72 | 2783093.0 |
| 2007-06-14 10:05:00 | SPY | ETF | 152.72 | 152.78 | 152.65 | 152.69 | 2117442.0 |
| 2007-06-14 10:10:00 | SPY | ETF | 152.68 | 152.72 | 152.65 | 152.66 | 897165.0 |
| 2007-06-14 10:15:00 | SPY | ETF | 152.655 | 152.75 | 152.58 | 152.5902 | 1080544.0 |
| 2007-06-14 10:20:00 | SPY | ETF | 152.59 | 152.74 | 152.59 | 152.67 | 1216400.0 |
| 2007-06-14 10:25:00 | SPY | ETF | 152.67 | 152.72 | 152.61 | 152.68 | 1100500.0 |
| 2007-06-14 10:30:00 | SPY | ETF | 152.69 | 152.99 | 152.68 | 152.96 | 3135805.0 |
| 2007-06-14 10:35:00 | SPY | ETF | 152.96 | 153.02 | 152.85 | 152.89 | 1909914.0 |
| 2007-06-14 10:40:00 | SPY | ETF | 152.9 | 153.12 | 152.66 | 152.95 | 2632523.0 |
| 2007-06-14 10:45:00 | SPY | ETF | 152.96 | 153.0 | 152.83 | 152.87 | 2105097.0 |
| 2007-06-14 10:50:00 | SPY | ETF | 152.87 | 152.87 | 152.77 | 152.811 | 2327466.0 |
> showing 50 of 16,511 rows — these rows as CSV