PREVIEW / etf_5min / 2001-04-09
file: by_date/etf_5min/2001/2001-04-09.parquet size: 30 KB rows: 1,112
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-09 09:30:00 | SPY | ETF | 114.0 | 114.09 | 113.75 | 113.89 | 530500.0 |
| 2001-04-09 09:35:00 | SPY | ETF | 113.9 | 113.99 | 113.62 | 113.68 | 180700.0 |
| 2001-04-09 09:40:00 | SPY | ETF | 113.71 | 114.35 | 113.7 | 114.26 | 244400.0 |
| 2001-04-09 09:45:00 | SPY | ETF | 114.26 | 114.59 | 114.04 | 114.54 | 236700.0 |
| 2001-04-09 09:50:00 | SPY | ETF | 114.5 | 114.65 | 114.25 | 114.43 | 299800.0 |
| 2001-04-09 09:55:00 | SPY | ETF | 114.3 | 114.5 | 114.1 | 114.31 | 147100.0 |
| 2001-04-09 10:00:00 | SPY | ETF | 114.34 | 114.59 | 114.15 | 114.45 | 84200.0 |
| 2001-04-09 10:05:00 | SPY | ETF | 114.47 | 114.94 | 114.25 | 114.85 | 366200.0 |
| 2001-04-09 10:10:00 | SPY | ETF | 114.82 | 114.87 | 114.51 | 114.73 | 142600.0 |
| 2001-04-09 10:15:00 | SPY | ETF | 114.65 | 114.99 | 114.65 | 114.8 | 291100.0 |
| 2001-04-09 10:20:00 | SPY | ETF | 114.92 | 114.92 | 114.6 | 114.71 | 132200.0 |
| 2001-04-09 10:25:00 | SPY | ETF | 114.75 | 114.8 | 114.55 | 114.66 | 170200.0 |
| 2001-04-09 10:30:00 | SPY | ETF | 114.77 | 114.77 | 114.5 | 114.65 | 68600.0 |
| 2001-04-09 10:35:00 | SPY | ETF | 114.68 | 114.8 | 114.52 | 114.6 | 54800.0 |
| 2001-04-09 10:40:00 | SPY | ETF | 114.72 | 114.9 | 114.61 | 114.89 | 309300.0 |
| 2001-04-09 10:45:00 | SPY | ETF | 114.89 | 114.95 | 114.61 | 114.61 | 316900.0 |
| 2001-04-09 10:50:00 | SPY | ETF | 114.67 | 114.75 | 114.53 | 114.59 | 162200.0 |
| 2001-04-09 10:55:00 | SPY | ETF | 114.58 | 114.6 | 114.31 | 114.4 | 129900.0 |
| 2001-04-09 11:00:00 | SPY | ETF | 114.35 | 114.5 | 114.21 | 114.27 | 152400.0 |
| 2001-04-09 11:05:00 | SPY | ETF | 114.16 | 114.29 | 113.88 | 114.08 | 166200.0 |
| 2001-04-09 11:10:00 | SPY | ETF | 113.98 | 114.21 | 113.98 | 114.21 | 34800.0 |
| 2001-04-09 11:15:00 | SPY | ETF | 114.24 | 114.24 | 113.86 | 114.0 | 38900.0 |
| 2001-04-09 11:20:00 | SPY | ETF | 113.95 | 114.2 | 113.95 | 114.05 | 25500.0 |
| 2001-04-09 11:25:00 | SPY | ETF | 114.03 | 114.08 | 113.8 | 113.82 | 112200.0 |
| 2001-04-09 11:30:00 | SPY | ETF | 113.94 | 114.03 | 113.72 | 113.72 | 173300.0 |
| 2001-04-09 11:35:00 | SPY | ETF | 113.65 | 113.92 | 113.64 | 113.9 | 200000.0 |
| 2001-04-09 11:40:00 | SPY | ETF | 113.82 | 114.0 | 113.79 | 113.9 | 53800.0 |
| 2001-04-09 11:45:00 | SPY | ETF | 113.91 | 113.98 | 113.71 | 113.77 | 43300.0 |
| 2001-04-09 11:50:00 | SPY | ETF | 113.86 | 113.9 | 113.72 | 113.9 | 19600.0 |
| 2001-04-09 11:55:00 | SPY | ETF | 113.9 | 114.08 | 113.87 | 114.08 | 12500.0 |
| 2001-04-09 12:00:00 | SPY | ETF | 114.12 | 114.14 | 113.95 | 114.02 | 103900.0 |
| 2001-04-09 12:05:00 | SPY | ETF | 114.06 | 114.28 | 114.05 | 114.11 | 24300.0 |
| 2001-04-09 12:10:00 | SPY | ETF | 114.08 | 114.2 | 113.96 | 114.06 | 15100.0 |
| 2001-04-09 12:15:00 | SPY | ETF | 114.19 | 114.26 | 114.0 | 114.0 | 76200.0 |
| 2001-04-09 12:20:00 | SPY | ETF | 114.01 | 114.1 | 114.01 | 114.1 | 19500.0 |
| 2001-04-09 12:25:00 | SPY | ETF | 114.01 | 114.05 | 113.8 | 113.8 | 17800.0 |
| 2001-04-09 12:30:00 | SPY | ETF | 113.72 | 113.82 | 113.7 | 113.75 | 57200.0 |
| 2001-04-09 12:35:00 | SPY | ETF | 113.78 | 113.84 | 113.5 | 113.5 | 40500.0 |
| 2001-04-09 12:40:00 | SPY | ETF | 113.51 | 113.62 | 113.28 | 113.61 | 120000.0 |
| 2001-04-09 12:45:00 | SPY | ETF | 113.6 | 113.8 | 113.55 | 113.71 | 71400.0 |
| 2001-04-09 12:50:00 | SPY | ETF | 113.61 | 113.83 | 113.5 | 113.63 | 19100.0 |
| 2001-04-09 12:55:00 | SPY | ETF | 113.61 | 113.68 | 113.51 | 113.6 | 41900.0 |
| 2001-04-09 13:00:00 | SPY | ETF | 113.51 | 113.73 | 113.36 | 113.41 | 63600.0 |
| 2001-04-09 13:05:00 | SPY | ETF | 113.38 | 113.59 | 113.3 | 113.55 | 35600.0 |
| 2001-04-09 13:10:00 | SPY | ETF | 113.46 | 113.56 | 113.34 | 113.35 | 232700.0 |
| 2001-04-09 13:15:00 | SPY | ETF | 113.3 | 113.35 | 113.19 | 113.31 | 58300.0 |
| 2001-04-09 13:20:00 | SPY | ETF | 113.2 | 113.34 | 113.1 | 113.34 | 51300.0 |
| 2001-04-09 13:25:00 | SPY | ETF | 113.31 | 113.43 | 113.24 | 113.25 | 41100.0 |
| 2001-04-09 13:30:00 | SPY | ETF | 113.2 | 113.2 | 112.96 | 112.96 | 39500.0 |
| 2001-04-09 13:35:00 | SPY | ETF | 112.97 | 113.09 | 112.81 | 112.97 | 145300.0 |
> showing 50 of 1,112 rows — these rows as CSV