PREVIEW / etf_5min / 2008-06-19
file: by_date/etf_5min/2008/2008-06-19.parquet size: 496 KB rows: 22,480
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-19 04:15:00 | SPY | ETF | 133.96 | 133.96 | 133.96 | 133.96 | 1000.0 |
| 2008-06-19 04:55:00 | SPY | ETF | 134.3 | 134.3 | 134.22 | 134.22 | 1100.0 |
| 2008-06-19 05:25:00 | SPY | ETF | 134.29 | 134.29 | 134.29 | 134.29 | 100.0 |
| 2008-06-19 05:30:00 | SPY | ETF | 134.31 | 134.32 | 134.22 | 134.22 | 1500.0 |
| 2008-06-19 06:05:00 | SPY | ETF | 134.23 | 134.23 | 134.23 | 134.23 | 500.0 |
| 2008-06-19 06:20:00 | SPY | ETF | 134.26 | 134.27 | 134.26 | 134.27 | 3000.0 |
| 2008-06-19 06:50:00 | SPY | ETF | 134.24 | 134.24 | 134.24 | 134.24 | 3000.0 |
| 2008-06-19 07:00:00 | SPY | ETF | 134.24 | 134.25 | 134.2 | 134.2 | 26700.0 |
| 2008-06-19 07:05:00 | SPY | ETF | 134.25 | 134.31 | 134.25 | 134.31 | 54700.0 |
| 2008-06-19 07:10:00 | SPY | ETF | 134.25 | 134.32 | 134.25 | 134.31 | 55400.0 |
| 2008-06-19 07:15:00 | SPY | ETF | 134.31 | 134.36 | 134.31 | 134.33 | 10694.0 |
| 2008-06-19 07:20:00 | SPY | ETF | 134.39 | 134.41 | 134.38 | 134.38 | 14300.0 |
| 2008-06-19 07:25:00 | SPY | ETF | 134.38 | 134.39 | 134.35 | 134.39 | 40900.0 |
| 2008-06-19 07:30:00 | SPY | ETF | 134.39 | 134.48 | 134.38 | 134.48 | 37331.0 |
| 2008-06-19 07:35:00 | SPY | ETF | 134.45 | 134.49 | 134.4 | 134.4 | 36100.0 |
| 2008-06-19 07:40:00 | SPY | ETF | 134.43 | 134.43 | 134.43 | 134.43 | 4300.0 |
| 2008-06-19 07:45:00 | SPY | ETF | 134.47 | 134.49 | 134.44 | 134.44 | 66100.0 |
| 2008-06-19 07:50:00 | SPY | ETF | 134.46 | 134.5 | 134.42 | 134.49 | 137583.0 |
| 2008-06-19 07:55:00 | SPY | ETF | 134.5 | 134.58 | 134.49 | 134.55 | 165200.0 |
| 2008-06-19 08:00:00 | SPY | ETF | 134.54 | 134.6 | 134.26 | 134.59 | 804260.0 |
| 2008-06-19 08:05:00 | SPY | ETF | 134.59 | 134.6 | 134.5 | 134.51 | 379851.0 |
| 2008-06-19 08:10:00 | SPY | ETF | 134.51 | 134.51 | 134.48 | 134.48 | 21354.0 |
| 2008-06-19 08:15:00 | SPY | ETF | 134.46 | 134.49 | 134.45 | 134.48 | 20274.0 |
| 2008-06-19 08:20:00 | SPY | ETF | 134.49 | 134.58 | 134.49 | 134.54 | 75707.0 |
| 2008-06-19 08:25:00 | SPY | ETF | 134.55 | 134.58 | 134.43 | 134.44 | 130687.0 |
| 2008-06-19 08:30:00 | SPY | ETF | 134.43 | 134.63 | 134.23 | 134.45 | 1777259.0 |
| 2008-06-19 08:35:00 | SPY | ETF | 134.45 | 134.54 | 134.43 | 134.5 | 365858.0 |
| 2008-06-19 08:40:00 | SPY | ETF | 134.48 | 134.5 | 134.39 | 134.4 | 43460.0 |
| 2008-06-19 08:45:00 | SPY | ETF | 134.4 | 134.42 | 134.31 | 134.33 | 215932.0 |
| 2008-06-19 08:50:00 | SPY | ETF | 134.34 | 134.44 | 134.34 | 134.42 | 92188.0 |
| 2008-06-19 08:55:00 | SPY | ETF | 134.4 | 134.41 | 134.25 | 134.29 | 92829.0 |
| 2008-06-19 09:00:00 | SPY | ETF | 134.3 | 134.33 | 134.2 | 134.2 | 490208.0 |
| 2008-06-19 09:05:00 | SPY | ETF | 134.21 | 134.21 | 134.13 | 134.14 | 180210.0 |
| 2008-06-19 09:10:00 | SPY | ETF | 134.17 | 134.21 | 134.12 | 134.17 | 136450.0 |
| 2008-06-19 09:15:00 | SPY | ETF | 134.16 | 134.19 | 134.12 | 134.14 | 70284.0 |
| 2008-06-19 09:20:00 | SPY | ETF | 134.15 | 134.21 | 134.12 | 134.21 | 307199.0 |
| 2008-06-19 09:25:00 | SPY | ETF | 134.2 | 134.23 | 134.13 | 134.15 | 215351.0 |
| 2008-06-19 09:30:00 | SPY | ETF | 134.15 | 134.55 | 134.15 | 134.43 | 4699651.0 |
| 2008-06-19 09:35:00 | SPY | ETF | 134.44 | 134.67 | 134.3601 | 134.48 | 3607658.0 |
| 2008-06-19 09:40:00 | SPY | ETF | 134.47 | 134.56 | 134.12 | 134.12 | 4184351.0 |
| 2008-06-19 09:45:00 | SPY | ETF | 134.12 | 134.14 | 133.94 | 134.07 | 4861738.0 |
| 2008-06-19 09:50:00 | SPY | ETF | 134.08 | 134.18 | 133.85 | 134.18 | 4665178.0 |
| 2008-06-19 09:55:00 | SPY | ETF | 134.18 | 134.32 | 133.96 | 134.11 | 4236213.0 |
| 2008-06-19 10:00:00 | SPY | ETF | 134.12 | 134.12 | 133.6199 | 133.96 | 7901898.0 |
| 2008-06-19 10:05:00 | SPY | ETF | 133.97 | 133.9799 | 133.65 | 133.71 | 4778638.0 |
| 2008-06-19 10:10:00 | SPY | ETF | 133.71 | 134.31 | 133.57 | 133.81 | 6825773.0 |
| 2008-06-19 10:15:00 | SPY | ETF | 133.8 | 133.81 | 133.55 | 133.64 | 4277038.0 |
| 2008-06-19 10:20:00 | SPY | ETF | 133.64 | 134.0 | 133.6 | 133.92 | 5088427.0 |
| 2008-06-19 10:25:00 | SPY | ETF | 133.93 | 134.1 | 133.84 | 134.05 | 3066395.0 |
| 2008-06-19 10:30:00 | SPY | ETF | 134.05 | 134.16 | 133.98 | 134.09 | 3378354.0 |
> showing 50 of 22,480 rows — these rows as CSV