PREVIEW / etf_5min / 2004-03-19
file: by_date/etf_5min/2004/2004-03-19.parquet size: 90 KB rows: 4,448
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-19 08:00:00 | SPY | ETF | 112.8 | 112.8 | 112.8 | 112.8 | 3100.0 |
| 2004-03-19 08:10:00 | SPY | ETF | 112.78 | 112.8 | 112.78 | 112.8 | 2400.0 |
| 2004-03-19 08:15:00 | SPY | ETF | 112.76 | 112.8 | 112.76 | 112.8 | 11800.0 |
| 2004-03-19 08:20:00 | SPY | ETF | 112.8 | 112.8 | 112.8 | 112.8 | 200.0 |
| 2004-03-19 08:25:00 | SPY | ETF | 112.76 | 112.76 | 112.71 | 112.71 | 4600.0 |
| 2004-03-19 08:30:00 | SPY | ETF | 112.76 | 112.77 | 112.76 | 112.77 | 200.0 |
| 2004-03-19 08:35:00 | SPY | ETF | 112.73 | 112.75 | 112.73 | 112.75 | 2500.0 |
| 2004-03-19 08:40:00 | SPY | ETF | 112.77 | 112.77 | 112.73 | 112.73 | 14800.0 |
| 2004-03-19 08:45:00 | SPY | ETF | 112.75 | 112.75 | 112.72 | 112.72 | 500.0 |
| 2004-03-19 08:50:00 | SPY | ETF | 112.75 | 112.8 | 112.75 | 112.76 | 31600.0 |
| 2004-03-19 08:55:00 | SPY | ETF | 112.77 | 112.77 | 112.75 | 112.75 | 5500.0 |
| 2004-03-19 09:00:00 | SPY | ETF | 112.79 | 112.79 | 112.77 | 112.77 | 10200.0 |
| 2004-03-19 09:05:00 | SPY | ETF | 112.8 | 112.8 | 112.77 | 112.78 | 5200.0 |
| 2004-03-19 09:10:00 | SPY | ETF | 112.79 | 112.79 | 112.66 | 112.67 | 23000.0 |
| 2004-03-19 09:15:00 | SPY | ETF | 112.66 | 112.66 | 112.6 | 112.61 | 7600.0 |
| 2004-03-19 09:20:00 | SPY | ETF | 112.63 | 112.63 | 112.51 | 112.51 | 15700.0 |
| 2004-03-19 09:25:00 | SPY | ETF | 112.54 | 112.56 | 112.4 | 112.4 | 39000.0 |
| 2004-03-19 09:30:00 | SPY | ETF | 112.41 | 112.45 | 112.25 | 112.32 | 1043400.0 |
| 2004-03-19 09:35:00 | SPY | ETF | 112.34 | 112.49 | 112.28 | 112.45 | 1027000.0 |
| 2004-03-19 09:40:00 | SPY | ETF | 112.45 | 112.47 | 112.15 | 112.17 | 1055000.0 |
| 2004-03-19 09:45:00 | SPY | ETF | 112.18 | 112.21 | 112.07 | 112.18 | 1452300.0 |
| 2004-03-19 09:50:00 | SPY | ETF | 112.15 | 112.18 | 111.94 | 112.01 | 947700.0 |
| 2004-03-19 09:55:00 | SPY | ETF | 112.0 | 112.2 | 112.0 | 112.15 | 639000.0 |
| 2004-03-19 10:00:00 | SPY | ETF | 112.15 | 112.21 | 112.05 | 112.14 | 292300.0 |
| 2004-03-19 10:05:00 | SPY | ETF | 112.13 | 112.17 | 111.93 | 111.97 | 338200.0 |
| 2004-03-19 10:10:00 | SPY | ETF | 111.98 | 112.24 | 111.96 | 112.14 | 957900.0 |
| 2004-03-19 10:15:00 | SPY | ETF | 112.16 | 112.16 | 112.01 | 112.09 | 631300.0 |
| 2004-03-19 10:20:00 | SPY | ETF | 112.08 | 112.14 | 111.97 | 112.04 | 280900.0 |
| 2004-03-19 10:25:00 | SPY | ETF | 112.05 | 112.14 | 112.0 | 112.06 | 268200.0 |
| 2004-03-19 10:30:00 | SPY | ETF | 112.06 | 112.12 | 112.01 | 112.1 | 387500.0 |
| 2004-03-19 10:35:00 | SPY | ETF | 112.11 | 112.29 | 112.07 | 112.29 | 658400.0 |
| 2004-03-19 10:40:00 | SPY | ETF | 112.3 | 112.4 | 112.25 | 112.296 | 584300.0 |
| 2004-03-19 10:45:00 | SPY | ETF | 112.3 | 112.35 | 112.24 | 112.24 | 1165900.0 |
| 2004-03-19 10:50:00 | SPY | ETF | 112.26 | 112.27 | 112.16 | 112.22 | 1309800.0 |
| 2004-03-19 10:55:00 | SPY | ETF | 112.24 | 112.28 | 112.22 | 112.27 | 156200.0 |
| 2004-03-19 11:00:00 | SPY | ETF | 112.27 | 112.28 | 112.16 | 112.21 | 176900.0 |
| 2004-03-19 11:05:00 | SPY | ETF | 112.2 | 112.3 | 112.16 | 112.3 | 199500.0 |
| 2004-03-19 11:10:00 | SPY | ETF | 112.29 | 112.31 | 112.21 | 112.28 | 174600.0 |
| 2004-03-19 11:15:00 | SPY | ETF | 112.27 | 112.31 | 112.19 | 112.21 | 170300.0 |
| 2004-03-19 11:20:00 | SPY | ETF | 112.22 | 112.3 | 112.2 | 112.29 | 127700.0 |
| 2004-03-19 11:25:00 | SPY | ETF | 112.28 | 112.28 | 112.14 | 112.21 | 194800.0 |
| 2004-03-19 11:30:00 | SPY | ETF | 112.21 | 112.28 | 112.19 | 112.28 | 219300.0 |
| 2004-03-19 11:35:00 | SPY | ETF | 112.26 | 112.41 | 112.26 | 112.39 | 777700.0 |
| 2004-03-19 11:40:00 | SPY | ETF | 112.38 | 112.57 | 112.36 | 112.36 | 670000.0 |
| 2004-03-19 11:45:00 | SPY | ETF | 112.36 | 112.41 | 112.29 | 112.31 | 425300.0 |
| 2004-03-19 11:50:00 | SPY | ETF | 112.32 | 112.37 | 112.22 | 112.3 | 497800.0 |
| 2004-03-19 11:55:00 | SPY | ETF | 112.27 | 112.32 | 112.22 | 112.26 | 146600.0 |
| 2004-03-19 12:00:00 | SPY | ETF | 112.26 | 112.31 | 112.24 | 112.25 | 278800.0 |
| 2004-03-19 12:05:00 | SPY | ETF | 112.22 | 112.38 | 112.22 | 112.34 | 393500.0 |
| 2004-03-19 12:10:00 | SPY | ETF | 112.34 | 112.35 | 112.22 | 112.25 | 112800.0 |
> showing 50 of 4,448 rows — these rows as CSV