PREVIEW / etf_5min / 2001-03-27
file: by_date/etf_5min/2001/2001-03-27.parquet size: 32 KB rows: 1,219
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-03-27 09:30:00 | SPY | ETF | 115.62 | 115.7 | 115.45 | 115.69 | 451000.0 |
| 2001-03-27 09:35:00 | SPY | ETF | 115.7 | 115.9 | 115.5 | 115.56 | 193300.0 |
| 2001-03-27 09:40:00 | SPY | ETF | 115.53 | 115.74 | 115.28 | 115.4 | 294200.0 |
| 2001-03-27 09:45:00 | SPY | ETF | 115.36 | 115.59 | 115.36 | 115.58 | 220000.0 |
| 2001-03-27 09:50:00 | SPY | ETF | 115.58 | 116.0 | 115.56 | 116.0 | 268500.0 |
| 2001-03-27 09:55:00 | SPY | ETF | 115.95 | 115.98 | 115.71 | 115.93 | 102500.0 |
| 2001-03-27 10:00:00 | SPY | ETF | 115.88 | 116.4 | 115.7 | 115.73 | 742500.0 |
| 2001-03-27 10:05:00 | SPY | ETF | 115.85 | 115.98 | 115.52 | 115.9 | 242900.0 |
| 2001-03-27 10:10:00 | SPY | ETF | 115.9 | 116.23 | 115.8 | 116.15 | 281300.0 |
| 2001-03-27 10:15:00 | SPY | ETF | 116.18 | 116.49 | 116.15 | 116.2 | 311400.0 |
| 2001-03-27 10:20:00 | SPY | ETF | 116.2 | 116.41 | 116.06 | 116.09 | 175000.0 |
| 2001-03-27 10:25:00 | SPY | ETF | 116.17 | 116.4 | 116.1 | 116.4 | 119500.0 |
| 2001-03-27 10:30:00 | SPY | ETF | 116.42 | 116.56 | 116.4 | 116.53 | 372300.0 |
| 2001-03-27 10:35:00 | SPY | ETF | 116.53 | 116.67 | 116.5 | 116.55 | 106900.0 |
| 2001-03-27 10:40:00 | SPY | ETF | 116.51 | 116.99 | 116.51 | 116.94 | 289600.0 |
| 2001-03-27 10:45:00 | SPY | ETF | 116.99 | 117.44 | 116.89 | 117.26 | 413700.0 |
| 2001-03-27 10:50:00 | SPY | ETF | 117.42 | 117.42 | 117.14 | 117.35 | 170000.0 |
| 2001-03-27 10:55:00 | SPY | ETF | 117.44 | 117.5 | 117.07 | 117.16 | 188000.0 |
| 2001-03-27 11:00:00 | SPY | ETF | 117.16 | 117.31 | 117.02 | 117.1 | 173100.0 |
| 2001-03-27 11:05:00 | SPY | ETF | 117.1 | 117.24 | 116.85 | 117.07 | 147800.0 |
| 2001-03-27 11:10:00 | SPY | ETF | 117.1 | 117.19 | 117.01 | 117.08 | 66500.0 |
| 2001-03-27 11:15:00 | SPY | ETF | 117.09 | 117.35 | 117.01 | 117.29 | 226600.0 |
| 2001-03-27 11:20:00 | SPY | ETF | 117.2 | 117.35 | 117.0 | 117.08 | 57700.0 |
| 2001-03-27 11:25:00 | SPY | ETF | 117.06 | 117.22 | 116.94 | 117.07 | 95500.0 |
| 2001-03-27 11:30:00 | SPY | ETF | 117.05 | 117.05 | 116.86 | 117.0 | 178900.0 |
| 2001-03-27 11:35:00 | SPY | ETF | 116.99 | 117.03 | 116.85 | 116.9 | 123600.0 |
| 2001-03-27 11:40:00 | SPY | ETF | 116.9 | 117.15 | 116.87 | 117.1 | 60000.0 |
| 2001-03-27 11:45:00 | SPY | ETF | 117.05 | 117.28 | 116.95 | 117.14 | 81300.0 |
| 2001-03-27 11:50:00 | SPY | ETF | 117.25 | 117.25 | 117.07 | 117.18 | 9500.0 |
| 2001-03-27 11:55:00 | SPY | ETF | 117.22 | 117.38 | 117.1 | 117.12 | 44000.0 |
| 2001-03-27 12:00:00 | SPY | ETF | 117.05 | 117.34 | 117.05 | 117.31 | 87000.0 |
| 2001-03-27 12:05:00 | SPY | ETF | 117.21 | 117.37 | 117.08 | 117.17 | 126800.0 |
| 2001-03-27 12:10:00 | SPY | ETF | 117.14 | 117.21 | 117.06 | 117.21 | 43300.0 |
| 2001-03-27 12:15:00 | SPY | ETF | 117.26 | 117.5 | 117.22 | 117.4 | 58900.0 |
| 2001-03-27 12:20:00 | SPY | ETF | 117.28 | 117.44 | 117.26 | 117.41 | 169000.0 |
| 2001-03-27 12:25:00 | SPY | ETF | 117.31 | 117.57 | 117.31 | 117.55 | 101900.0 |
| 2001-03-27 12:30:00 | SPY | ETF | 117.55 | 117.7 | 117.45 | 117.55 | 306200.0 |
| 2001-03-27 12:35:00 | SPY | ETF | 117.55 | 117.75 | 117.44 | 117.68 | 116400.0 |
| 2001-03-27 12:40:00 | SPY | ETF | 117.63 | 117.74 | 117.55 | 117.67 | 120700.0 |
| 2001-03-27 12:45:00 | SPY | ETF | 117.7 | 117.93 | 117.63 | 117.88 | 107600.0 |
| 2001-03-27 12:50:00 | SPY | ETF | 117.83 | 117.85 | 117.72 | 117.72 | 49400.0 |
| 2001-03-27 12:55:00 | SPY | ETF | 117.72 | 117.79 | 117.7 | 117.71 | 122000.0 |
| 2001-03-27 13:00:00 | SPY | ETF | 117.72 | 117.83 | 117.61 | 117.83 | 75000.0 |
| 2001-03-27 13:05:00 | SPY | ETF | 117.82 | 117.83 | 117.61 | 117.72 | 44800.0 |
| 2001-03-27 13:10:00 | SPY | ETF | 117.69 | 117.69 | 117.51 | 117.61 | 36600.0 |
| 2001-03-27 13:15:00 | SPY | ETF | 117.59 | 117.79 | 117.53 | 117.77 | 78400.0 |
| 2001-03-27 13:20:00 | SPY | ETF | 117.78 | 117.78 | 117.54 | 117.73 | 18400.0 |
| 2001-03-27 13:25:00 | SPY | ETF | 117.75 | 117.82 | 117.64 | 117.79 | 72500.0 |
| 2001-03-27 13:30:00 | SPY | ETF | 117.76 | 117.84 | 117.64 | 117.74 | 97700.0 |
| 2001-03-27 13:35:00 | SPY | ETF | 117.7 | 117.84 | 117.46 | 117.48 | 76700.0 |
> showing 50 of 1,219 rows — these rows as CSV