PREVIEW / etf_5min / 2004-03-18
file: by_date/etf_5min/2004/2004-03-18.parquet size: 94 KB rows: 4,654
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-03-18 08:00:00 | SPY | ETF | 112.71 | 112.72 | 112.71 | 112.72 | 1000.0 |
| 2004-03-18 08:05:00 | SPY | ETF | 112.7 | 112.71 | 112.7 | 112.7 | 25900.0 |
| 2004-03-18 08:10:00 | SPY | ETF | 112.71 | 112.73 | 112.71 | 112.73 | 12800.0 |
| 2004-03-18 08:15:00 | SPY | ETF | 112.71 | 112.71 | 112.65 | 112.66 | 22500.0 |
| 2004-03-18 08:20:00 | SPY | ETF | 112.73 | 112.73 | 112.68 | 112.69 | 8000.0 |
| 2004-03-18 08:25:00 | SPY | ETF | 112.69 | 112.69 | 112.65 | 112.65 | 32700.0 |
| 2004-03-18 08:30:00 | SPY | ETF | 112.66 | 112.71 | 112.63 | 112.71 | 71800.0 |
| 2004-03-18 08:35:00 | SPY | ETF | 112.75 | 112.78 | 112.75 | 112.78 | 48500.0 |
| 2004-03-18 08:40:00 | SPY | ETF | 112.75 | 112.75 | 112.71 | 112.71 | 5700.0 |
| 2004-03-18 08:45:00 | SPY | ETF | 112.69 | 112.72 | 112.65 | 112.69 | 14100.0 |
| 2004-03-18 08:50:00 | SPY | ETF | 112.67 | 112.67 | 112.59 | 112.63 | 23800.0 |
| 2004-03-18 08:55:00 | SPY | ETF | 112.63 | 112.63 | 112.59 | 112.59 | 10800.0 |
| 2004-03-18 09:00:00 | SPY | ETF | 112.58 | 112.58 | 112.58 | 112.58 | 800.0 |
| 2004-03-18 09:05:00 | SPY | ETF | 112.58 | 112.63 | 112.58 | 112.6 | 20900.0 |
| 2004-03-18 09:10:00 | SPY | ETF | 112.64 | 112.65 | 112.61 | 112.63 | 6500.0 |
| 2004-03-18 09:15:00 | SPY | ETF | 112.66 | 112.68 | 112.65 | 112.65 | 1800.0 |
| 2004-03-18 09:20:00 | SPY | ETF | 112.65 | 112.65 | 112.65 | 112.65 | 200.0 |
| 2004-03-18 09:25:00 | SPY | ETF | 112.67 | 112.68 | 112.67 | 112.68 | 600.0 |
| 2004-03-18 09:30:00 | SPY | ETF | 112.7 | 112.71 | 112.6 | 112.7 | 1573100.0 |
| 2004-03-18 09:35:00 | SPY | ETF | 112.7 | 112.75 | 112.65 | 112.67 | 605400.0 |
| 2004-03-18 09:40:00 | SPY | ETF | 112.67 | 112.78 | 112.65 | 112.78 | 744300.0 |
| 2004-03-18 09:45:00 | SPY | ETF | 112.78 | 112.81 | 112.74 | 112.76 | 333500.0 |
| 2004-03-18 09:50:00 | SPY | ETF | 112.76 | 112.8 | 112.65 | 112.73 | 507600.0 |
| 2004-03-18 09:55:00 | SPY | ETF | 112.72 | 112.83 | 112.7 | 112.77 | 450400.0 |
| 2004-03-18 10:00:00 | SPY | ETF | 112.78 | 112.8 | 112.45 | 112.46 | 1325300.0 |
| 2004-03-18 10:05:00 | SPY | ETF | 112.45 | 112.62 | 112.42 | 112.48 | 1336600.0 |
| 2004-03-18 10:10:00 | SPY | ETF | 112.48 | 112.52 | 112.37 | 112.46 | 534500.0 |
| 2004-03-18 10:15:00 | SPY | ETF | 112.47 | 112.51 | 112.35 | 112.4 | 364500.0 |
| 2004-03-18 10:20:00 | SPY | ETF | 112.4 | 112.48 | 112.37 | 112.47 | 264400.0 |
| 2004-03-18 10:25:00 | SPY | ETF | 112.47 | 112.58 | 112.45 | 112.58 | 767700.0 |
| 2004-03-18 10:30:00 | SPY | ETF | 112.58 | 112.61 | 112.34 | 112.43 | 712900.0 |
| 2004-03-18 10:35:00 | SPY | ETF | 112.45 | 112.53 | 112.35 | 112.52 | 169600.0 |
| 2004-03-18 10:40:00 | SPY | ETF | 112.54 | 112.54 | 112.34 | 112.37 | 110200.0 |
| 2004-03-18 10:45:00 | SPY | ETF | 112.38 | 112.39 | 112.25 | 112.33 | 605900.0 |
| 2004-03-18 10:50:00 | SPY | ETF | 112.33 | 112.41 | 112.31 | 112.37 | 255900.0 |
| 2004-03-18 10:55:00 | SPY | ETF | 112.37 | 112.39 | 112.32 | 112.36 | 103500.0 |
| 2004-03-18 11:00:00 | SPY | ETF | 112.36 | 112.36 | 112.28 | 112.35 | 208600.0 |
| 2004-03-18 11:05:00 | SPY | ETF | 112.35 | 112.36 | 112.17 | 112.21 | 736700.0 |
| 2004-03-18 11:10:00 | SPY | ETF | 112.22 | 112.28 | 112.2 | 112.27 | 334500.0 |
| 2004-03-18 11:15:00 | SPY | ETF | 112.21 | 112.3 | 112.2 | 112.25 | 158100.0 |
| 2004-03-18 11:20:00 | SPY | ETF | 112.24 | 112.271 | 112.09 | 112.15 | 312600.0 |
| 2004-03-18 11:25:00 | SPY | ETF | 112.15 | 112.24 | 112.09 | 112.22 | 216700.0 |
| 2004-03-18 11:30:00 | SPY | ETF | 112.22 | 112.34 | 112.2 | 112.33 | 790800.0 |
| 2004-03-18 11:35:00 | SPY | ETF | 112.33 | 112.37 | 112.296 | 112.35 | 922400.0 |
| 2004-03-18 11:40:00 | SPY | ETF | 112.36 | 112.39 | 112.31 | 112.34 | 470100.0 |
| 2004-03-18 11:45:00 | SPY | ETF | 112.33 | 112.36 | 112.27 | 112.27 | 191500.0 |
| 2004-03-18 11:50:00 | SPY | ETF | 112.3 | 112.34 | 112.28 | 112.3 | 151100.0 |
| 2004-03-18 11:55:00 | SPY | ETF | 112.3 | 112.39 | 112.29 | 112.36 | 190100.0 |
| 2004-03-18 12:00:00 | SPY | ETF | 112.33 | 112.37 | 112.17 | 112.28 | 1151500.0 |
| 2004-03-18 12:05:00 | SPY | ETF | 112.3 | 112.32 | 112.15 | 112.2 | 267300.0 |
> showing 50 of 4,654 rows — these rows as CSV