PREVIEW / etf_5min / 2008-07-28
file: by_date/etf_5min/2008/2008-07-28.parquet size: 484 KB rows: 22,263
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-07-28 04:15:00 | SPY | ETF | 125.34 | 125.34 | 125.34 | 125.34 | 100.0 |
| 2008-07-28 04:25:00 | SPY | ETF | 125.3 | 125.3 | 125.3 | 125.3 | 200.0 |
| 2008-07-28 04:45:00 | SPY | ETF | 125.45 | 125.45 | 125.45 | 125.45 | 800.0 |
| 2008-07-28 05:25:00 | SPY | ETF | 125.35 | 125.35 | 125.35 | 125.35 | 1000.0 |
| 2008-07-28 05:30:00 | SPY | ETF | 125.38 | 125.38 | 125.38 | 125.38 | 1000.0 |
| 2008-07-28 05:55:00 | SPY | ETF | 125.11 | 125.11 | 125.11 | 125.11 | 200.0 |
| 2008-07-28 06:10:00 | SPY | ETF | 125.11 | 125.11 | 125.1 | 125.1 | 10000.0 |
| 2008-07-28 06:15:00 | SPY | ETF | 125.12 | 125.12 | 125.12 | 125.12 | 130.0 |
| 2008-07-28 06:30:00 | SPY | ETF | 125.21 | 125.21 | 125.18 | 125.18 | 1500.0 |
| 2008-07-28 07:00:00 | SPY | ETF | 125.24 | 125.25 | 125.18 | 125.2 | 89800.0 |
| 2008-07-28 07:05:00 | SPY | ETF | 125.18 | 125.26 | 125.18 | 125.25 | 66600.0 |
| 2008-07-28 07:10:00 | SPY | ETF | 125.25 | 125.25 | 125.13 | 125.15 | 31320.0 |
| 2008-07-28 07:15:00 | SPY | ETF | 125.2 | 125.2 | 125.2 | 125.2 | 1000.0 |
| 2008-07-28 07:20:00 | SPY | ETF | 125.3 | 125.47 | 125.29 | 125.4 | 79100.0 |
| 2008-07-28 07:25:00 | SPY | ETF | 125.36 | 125.36 | 125.32 | 125.35 | 31600.0 |
| 2008-07-28 07:30:00 | SPY | ETF | 125.35 | 125.45 | 125.35 | 125.41 | 56800.0 |
| 2008-07-28 07:35:00 | SPY | ETF | 125.41 | 125.42 | 125.34 | 125.36 | 22600.0 |
| 2008-07-28 07:40:00 | SPY | ETF | 125.36 | 125.49 | 125.36 | 125.47 | 44200.0 |
| 2008-07-28 07:45:00 | SPY | ETF | 125.47 | 125.55 | 125.47 | 125.52 | 59853.0 |
| 2008-07-28 07:50:00 | SPY | ETF | 125.51 | 125.57 | 125.51 | 125.57 | 102200.0 |
| 2008-07-28 07:55:00 | SPY | ETF | 125.57 | 125.6 | 125.55 | 125.6 | 66596.0 |
| 2008-07-28 08:00:00 | SPY | ETF | 125.59 | 125.64 | 125.47 | 125.5 | 94778.0 |
| 2008-07-28 08:05:00 | SPY | ETF | 125.52 | 125.53 | 125.45 | 125.45 | 37100.0 |
| 2008-07-28 08:10:00 | SPY | ETF | 125.5 | 125.54 | 125.48 | 125.51 | 30500.0 |
| 2008-07-28 08:15:00 | SPY | ETF | 125.5 | 125.5 | 125.47 | 125.49 | 15400.0 |
| 2008-07-28 08:20:00 | SPY | ETF | 125.5 | 125.51 | 125.44 | 125.45 | 122604.0 |
| 2008-07-28 08:25:00 | SPY | ETF | 125.46 | 125.51 | 125.44 | 125.46 | 55453.0 |
| 2008-07-28 08:30:00 | SPY | ETF | 125.46 | 125.55 | 125.44 | 125.5 | 82300.0 |
| 2008-07-28 08:35:00 | SPY | ETF | 125.49 | 125.5 | 125.35 | 125.36 | 192442.0 |
| 2008-07-28 08:40:00 | SPY | ETF | 125.36 | 125.37 | 125.3 | 125.37 | 85000.0 |
| 2008-07-28 08:45:00 | SPY | ETF | 125.37 | 125.38 | 125.33 | 125.38 | 26403.0 |
| 2008-07-28 08:50:00 | SPY | ETF | 125.37 | 125.48 | 125.37 | 125.42 | 59486.0 |
| 2008-07-28 08:55:00 | SPY | ETF | 125.42 | 125.49 | 125.42 | 125.44 | 63802.0 |
| 2008-07-28 09:00:00 | SPY | ETF | 125.43 | 125.49 | 125.43 | 125.43 | 57801.0 |
| 2008-07-28 09:05:00 | SPY | ETF | 125.43 | 125.5 | 125.42 | 125.49 | 49326.0 |
| 2008-07-28 09:10:00 | SPY | ETF | 125.5 | 125.54 | 125.42 | 125.45 | 109777.0 |
| 2008-07-28 09:15:00 | SPY | ETF | 125.44 | 125.45 | 125.4 | 125.43 | 76594.0 |
| 2008-07-28 09:20:00 | SPY | ETF | 125.41 | 125.41 | 125.37 | 125.41 | 41857.0 |
| 2008-07-28 09:25:00 | SPY | ETF | 125.4 | 125.48 | 125.39 | 125.48 | 132135.0 |
| 2008-07-28 09:30:00 | SPY | ETF | 125.51 | 125.66 | 125.43 | 125.65 | 3377817.0 |
| 2008-07-28 09:35:00 | SPY | ETF | 125.64 | 125.9299 | 125.6 | 125.83 | 5166301.0 |
| 2008-07-28 09:40:00 | SPY | ETF | 125.83 | 125.95 | 125.72 | 125.87 | 3561321.0 |
| 2008-07-28 09:45:00 | SPY | ETF | 125.88 | 125.98 | 125.68 | 125.81 | 3328264.0 |
| 2008-07-28 09:50:00 | SPY | ETF | 125.81 | 125.84 | 125.65 | 125.65 | 2350872.0 |
| 2008-07-28 09:55:00 | SPY | ETF | 125.65 | 125.76 | 125.6 | 125.68 | 2101646.0 |
| 2008-07-28 10:00:00 | SPY | ETF | 125.68 | 125.97 | 125.68 | 125.92 | 2805273.0 |
| 2008-07-28 10:05:00 | SPY | ETF | 125.92 | 126.06 | 125.83 | 125.93 | 2680832.0 |
| 2008-07-28 10:10:00 | SPY | ETF | 125.93 | 126.0 | 125.75 | 125.78 | 1786337.0 |
| 2008-07-28 10:15:00 | SPY | ETF | 125.78 | 125.83 | 125.7 | 125.82 | 1885408.0 |
| 2008-07-28 10:20:00 | SPY | ETF | 125.83 | 125.85 | 125.62 | 125.63 | 1949375.0 |
> showing 50 of 22,263 rows — these rows as CSV