PREVIEW / etf_5min / 2004-01-06
file: by_date/etf_5min/2004/2004-01-06.parquet size: 89 KB rows: 5,052
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-06 08:00:00 | SPY | ETF | 112.25 | 112.25 | 112.22 | 112.22 | 1400.0 |
| 2004-01-06 08:20:00 | SPY | ETF | 112.24 | 112.29 | 112.24 | 112.29 | 7800.0 |
| 2004-01-06 08:25:00 | SPY | ETF | 112.25 | 112.26 | 112.24 | 112.26 | 600.0 |
| 2004-01-06 08:30:00 | SPY | ETF | 112.24 | 112.24 | 112.17 | 112.18 | 6200.0 |
| 2004-01-06 08:35:00 | SPY | ETF | 112.2 | 112.2 | 112.2 | 112.2 | 200.0 |
| 2004-01-06 08:40:00 | SPY | ETF | 112.2 | 112.2 | 112.17 | 112.17 | 1800.0 |
| 2004-01-06 08:45:00 | SPY | ETF | 112.17 | 112.17 | 112.15 | 112.16 | 5000.0 |
| 2004-01-06 08:50:00 | SPY | ETF | 112.16 | 112.17 | 112.16 | 112.17 | 4000.0 |
| 2004-01-06 08:55:00 | SPY | ETF | 112.21 | 112.21 | 112.17 | 112.17 | 1000.0 |
| 2004-01-06 09:00:00 | SPY | ETF | 112.22 | 112.22 | 112.2 | 112.21 | 5700.0 |
| 2004-01-06 09:05:00 | SPY | ETF | 112.21 | 112.22 | 112.21 | 112.21 | 3700.0 |
| 2004-01-06 09:10:00 | SPY | ETF | 112.2 | 112.2 | 112.2 | 112.2 | 6100.0 |
| 2004-01-06 09:15:00 | SPY | ETF | 112.18 | 112.2 | 112.18 | 112.2 | 3100.0 |
| 2004-01-06 09:20:00 | SPY | ETF | 112.18 | 112.18 | 112.18 | 112.18 | 500.0 |
| 2004-01-06 09:25:00 | SPY | ETF | 112.16 | 112.22 | 112.16 | 112.19 | 15200.0 |
| 2004-01-06 09:30:00 | SPY | ETF | 112.16 | 112.25 | 112.16 | 112.19 | 647200.0 |
| 2004-01-06 09:35:00 | SPY | ETF | 112.27 | 112.27 | 112.1 | 112.2 | 548500.0 |
| 2004-01-06 09:40:00 | SPY | ETF | 112.17 | 112.24 | 112.12 | 112.24 | 353800.0 |
| 2004-01-06 09:45:00 | SPY | ETF | 112.24 | 112.31 | 112.18 | 112.29 | 459800.0 |
| 2004-01-06 09:50:00 | SPY | ETF | 112.28 | 112.32 | 112.21 | 112.23 | 390700.0 |
| 2004-01-06 09:55:00 | SPY | ETF | 112.22 | 112.33 | 112.19 | 112.33 | 228500.0 |
| 2004-01-06 10:00:00 | SPY | ETF | 112.31 | 112.35 | 112.1 | 112.19 | 949200.0 |
| 2004-01-06 10:05:00 | SPY | ETF | 112.17 | 112.27 | 112.1 | 112.22 | 517100.0 |
| 2004-01-06 10:10:00 | SPY | ETF | 112.21 | 112.3 | 112.15 | 112.27 | 1155600.0 |
| 2004-01-06 10:15:00 | SPY | ETF | 112.27 | 112.31 | 112.11 | 112.16 | 316100.0 |
| 2004-01-06 10:20:00 | SPY | ETF | 112.17 | 112.25 | 112.12 | 112.219 | 248000.0 |
| 2004-01-06 10:25:00 | SPY | ETF | 112.24 | 112.3 | 112.17 | 112.26 | 282200.0 |
| 2004-01-06 10:30:00 | SPY | ETF | 112.22 | 112.32 | 112.19 | 112.26 | 164000.0 |
| 2004-01-06 10:35:00 | SPY | ETF | 112.25 | 112.36 | 112.22 | 112.29 | 512600.0 |
| 2004-01-06 10:40:00 | SPY | ETF | 112.29 | 112.31 | 112.19 | 112.24 | 199200.0 |
| 2004-01-06 10:45:00 | SPY | ETF | 112.24 | 112.35 | 112.22 | 112.3 | 88800.0 |
| 2004-01-06 10:50:00 | SPY | ETF | 112.31 | 112.33 | 112.25 | 112.28 | 382900.0 |
| 2004-01-06 10:55:00 | SPY | ETF | 112.26 | 112.43 | 112.26 | 112.4 | 183500.0 |
| 2004-01-06 11:00:00 | SPY | ETF | 112.4 | 112.46 | 112.39 | 112.42 | 393300.0 |
| 2004-01-06 11:05:00 | SPY | ETF | 112.41 | 112.46 | 112.34 | 112.38 | 193200.0 |
| 2004-01-06 11:10:00 | SPY | ETF | 112.35 | 112.41 | 112.33 | 112.37 | 147300.0 |
| 2004-01-06 11:15:00 | SPY | ETF | 112.37 | 112.39 | 112.35 | 112.37 | 38600.0 |
| 2004-01-06 11:20:00 | SPY | ETF | 112.37 | 112.37 | 112.28 | 112.28 | 113500.0 |
| 2004-01-06 11:25:00 | SPY | ETF | 112.28 | 112.32 | 112.23 | 112.27 | 216900.0 |
| 2004-01-06 11:30:00 | SPY | ETF | 112.27 | 112.3 | 112.24 | 112.29 | 142200.0 |
| 2004-01-06 11:35:00 | SPY | ETF | 112.27 | 112.31 | 112.24 | 112.26 | 89600.0 |
| 2004-01-06 11:40:00 | SPY | ETF | 112.26 | 112.34 | 112.26 | 112.3 | 74200.0 |
| 2004-01-06 11:45:00 | SPY | ETF | 112.3 | 112.34 | 112.27 | 112.27 | 104100.0 |
| 2004-01-06 11:50:00 | SPY | ETF | 112.29 | 112.34 | 112.27 | 112.3 | 58400.0 |
| 2004-01-06 11:55:00 | SPY | ETF | 112.3 | 112.3 | 112.23 | 112.26 | 84100.0 |
| 2004-01-06 12:00:00 | SPY | ETF | 112.25 | 112.27 | 112.17 | 112.26 | 184700.0 |
| 2004-01-06 12:05:00 | SPY | ETF | 112.25 | 112.27 | 112.22 | 112.25 | 192400.0 |
| 2004-01-06 12:10:00 | SPY | ETF | 112.22 | 112.3 | 112.22 | 112.27 | 165500.0 |
| 2004-01-06 12:15:00 | SPY | ETF | 112.27 | 112.33 | 112.26 | 112.3 | 75700.0 |
| 2004-01-06 12:20:00 | SPY | ETF | 112.3 | 112.33 | 112.25 | 112.26 | 89100.0 |
> showing 50 of 5,052 rows — these rows as CSV