PREVIEW / etf_5min / 2001-01-29
file: by_date/etf_5min/2001/2001-01-29.parquet size: 27 KB rows: 1,098
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-01-29 09:30:00 | SPY | ETF | 135.5 | 135.6 | 135.4 | 135.53 | 286500.0 |
| 2001-01-29 09:35:00 | SPY | ETF | 135.37 | 135.64 | 135.37 | 135.64 | 116500.0 |
| 2001-01-29 09:40:00 | SPY | ETF | 135.68 | 135.8 | 135.51 | 135.51 | 280500.0 |
| 2001-01-29 09:45:00 | SPY | ETF | 135.58 | 135.9 | 135.42 | 135.8 | 43000.0 |
| 2001-01-29 09:50:00 | SPY | ETF | 135.92 | 135.97 | 135.76 | 135.88 | 74300.0 |
| 2001-01-29 09:55:00 | SPY | ETF | 135.84 | 136.1 | 135.81 | 135.87 | 68500.0 |
| 2001-01-29 10:00:00 | SPY | ETF | 135.86 | 135.96 | 135.78 | 135.83 | 30900.0 |
| 2001-01-29 10:05:00 | SPY | ETF | 135.95 | 136.0 | 135.81 | 135.89 | 240600.0 |
| 2001-01-29 10:10:00 | SPY | ETF | 135.89 | 135.97 | 135.77 | 135.94 | 78500.0 |
| 2001-01-29 10:15:00 | SPY | ETF | 135.9 | 135.97 | 135.83 | 135.86 | 18100.0 |
| 2001-01-29 10:20:00 | SPY | ETF | 135.8 | 135.8 | 135.54 | 135.72 | 75100.0 |
| 2001-01-29 10:25:00 | SPY | ETF | 135.62 | 135.72 | 135.54 | 135.72 | 241800.0 |
| 2001-01-29 10:30:00 | SPY | ETF | 135.73 | 135.84 | 135.61 | 135.76 | 163600.0 |
| 2001-01-29 10:35:00 | SPY | ETF | 135.76 | 135.96 | 135.68 | 135.96 | 62100.0 |
| 2001-01-29 10:40:00 | SPY | ETF | 135.8 | 135.97 | 135.68 | 135.69 | 31300.0 |
| 2001-01-29 10:45:00 | SPY | ETF | 135.78 | 135.88 | 135.69 | 135.82 | 23500.0 |
| 2001-01-29 10:50:00 | SPY | ETF | 135.85 | 135.93 | 135.85 | 135.93 | 66000.0 |
| 2001-01-29 10:55:00 | SPY | ETF | 135.93 | 136.0 | 135.82 | 135.98 | 7200.0 |
| 2001-01-29 11:00:00 | SPY | ETF | 135.87 | 135.87 | 135.72 | 135.75 | 25900.0 |
| 2001-01-29 11:05:00 | SPY | ETF | 135.84 | 135.84 | 135.53 | 135.64 | 23800.0 |
| 2001-01-29 11:10:00 | SPY | ETF | 135.7 | 135.86 | 135.68 | 135.85 | 27500.0 |
| 2001-01-29 11:15:00 | SPY | ETF | 135.85 | 135.88 | 135.71 | 135.85 | 6300.0 |
| 2001-01-29 11:20:00 | SPY | ETF | 135.9 | 136.1 | 135.9 | 136.03 | 356700.0 |
| 2001-01-29 11:25:00 | SPY | ETF | 136.01 | 136.03 | 135.84 | 136.03 | 220700.0 |
| 2001-01-29 11:30:00 | SPY | ETF | 136.14 | 136.15 | 135.96 | 136.11 | 32200.0 |
| 2001-01-29 11:35:00 | SPY | ETF | 136.13 | 136.35 | 136.13 | 136.16 | 242400.0 |
| 2001-01-29 11:40:00 | SPY | ETF | 136.3 | 136.3 | 136.15 | 136.15 | 23100.0 |
| 2001-01-29 11:45:00 | SPY | ETF | 136.19 | 136.24 | 136.08 | 136.21 | 5500.0 |
| 2001-01-29 11:50:00 | SPY | ETF | 136.21 | 136.25 | 136.08 | 136.2 | 36300.0 |
| 2001-01-29 11:55:00 | SPY | ETF | 136.15 | 136.18 | 136.08 | 136.16 | 114400.0 |
| 2001-01-29 12:00:00 | SPY | ETF | 136.14 | 136.2 | 136.08 | 136.15 | 112100.0 |
| 2001-01-29 12:05:00 | SPY | ETF | 136.1 | 136.15 | 136.03 | 136.03 | 13500.0 |
| 2001-01-29 12:10:00 | SPY | ETF | 136.05 | 136.14 | 136.01 | 136.07 | 34500.0 |
| 2001-01-29 12:15:00 | SPY | ETF | 136.04 | 136.12 | 135.95 | 136.05 | 52400.0 |
| 2001-01-29 12:20:00 | SPY | ETF | 136.03 | 136.16 | 135.97 | 136.05 | 25000.0 |
| 2001-01-29 12:25:00 | SPY | ETF | 136.05 | 136.14 | 136.0 | 136.14 | 18100.0 |
| 2001-01-29 12:30:00 | SPY | ETF | 136.16 | 136.18 | 136.06 | 136.06 | 5600.0 |
| 2001-01-29 12:35:00 | SPY | ETF | 136.11 | 136.21 | 136.11 | 136.16 | 36000.0 |
| 2001-01-29 12:40:00 | SPY | ETF | 136.15 | 136.2 | 136.05 | 136.14 | 9800.0 |
| 2001-01-29 12:45:00 | SPY | ETF | 136.05 | 136.16 | 136.01 | 136.03 | 60200.0 |
| 2001-01-29 12:50:00 | SPY | ETF | 136.03 | 136.18 | 136.0 | 136.18 | 73100.0 |
| 2001-01-29 12:55:00 | SPY | ETF | 136.11 | 136.19 | 136.06 | 136.14 | 12400.0 |
| 2001-01-29 13:00:00 | SPY | ETF | 136.08 | 136.3 | 136.08 | 136.24 | 188500.0 |
| 2001-01-29 13:05:00 | SPY | ETF | 136.15 | 136.23 | 136.1 | 136.1 | 26400.0 |
| 2001-01-29 13:10:00 | SPY | ETF | 136.08 | 136.18 | 136.0 | 136.15 | 38000.0 |
| 2001-01-29 13:15:00 | SPY | ETF | 136.17 | 136.26 | 136.09 | 136.25 | 38100.0 |
| 2001-01-29 13:20:00 | SPY | ETF | 136.24 | 136.4 | 136.16 | 136.27 | 66400.0 |
| 2001-01-29 13:25:00 | SPY | ETF | 136.25 | 136.42 | 136.25 | 136.27 | 79800.0 |
| 2001-01-29 13:30:00 | SPY | ETF | 136.27 | 136.3 | 136.15 | 136.3 | 44900.0 |
| 2001-01-29 13:35:00 | SPY | ETF | 136.2 | 136.24 | 136.13 | 136.24 | 11000.0 |
> showing 50 of 1,098 rows — these rows as CSV