PREVIEW / etf_1min / 2001-09-24
file: by_date/etf_1min/2001/2001-09-24.parquet size: 71 KB rows: 4,014
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-09-24 09:30:00 | SPY | ETF | 99.72 | 99.83 | 99.5 | 99.8 | 513700.0 |
| 2001-09-24 09:31:00 | SPY | ETF | 99.8 | 99.8 | 99.45 | 99.6 | 165300.0 |
| 2001-09-24 09:32:00 | SPY | ETF | 99.55 | 99.8 | 99.5 | 99.8 | 150100.0 |
| 2001-09-24 09:33:00 | SPY | ETF | 99.64 | 99.8 | 99.5 | 99.71 | 176700.0 |
| 2001-09-24 09:34:00 | SPY | ETF | 99.74 | 99.8 | 99.5 | 99.72 | 106500.0 |
| 2001-09-24 09:35:00 | SPY | ETF | 99.8 | 99.83 | 99.67 | 99.83 | 62600.0 |
| 2001-09-24 09:36:00 | SPY | ETF | 99.82 | 99.85 | 99.61 | 99.85 | 86600.0 |
| 2001-09-24 09:37:00 | SPY | ETF | 99.72 | 99.8 | 99.5 | 99.56 | 113900.0 |
| 2001-09-24 09:38:00 | SPY | ETF | 99.58 | 99.72 | 99.5 | 99.67 | 165000.0 |
| 2001-09-24 09:39:00 | SPY | ETF | 99.65 | 99.79 | 99.56 | 99.6 | 134500.0 |
| 2001-09-24 09:40:00 | SPY | ETF | 99.67 | 99.76 | 99.59 | 99.68 | 240300.0 |
| 2001-09-24 09:41:00 | SPY | ETF | 99.68 | 99.75 | 99.5 | 99.56 | 181900.0 |
| 2001-09-24 09:42:00 | SPY | ETF | 99.56 | 99.73 | 99.51 | 99.56 | 248300.0 |
| 2001-09-24 09:43:00 | SPY | ETF | 99.51 | 99.72 | 99.5 | 99.6 | 74400.0 |
| 2001-09-24 09:44:00 | SPY | ETF | 99.5 | 100.06 | 99.5 | 100.0 | 192900.0 |
| 2001-09-24 09:45:00 | SPY | ETF | 100.0 | 100.04 | 99.67 | 99.77 | 155200.0 |
| 2001-09-24 09:46:00 | SPY | ETF | 99.7 | 99.77 | 99.65 | 99.67 | 303500.0 |
| 2001-09-24 09:47:00 | SPY | ETF | 99.7 | 99.85 | 99.65 | 99.85 | 85400.0 |
| 2001-09-24 09:48:00 | SPY | ETF | 99.85 | 99.85 | 99.7 | 99.8 | 93900.0 |
| 2001-09-24 09:49:00 | SPY | ETF | 99.73 | 99.85 | 99.67 | 99.8 | 28700.0 |
| 2001-09-24 09:50:00 | SPY | ETF | 99.81 | 99.9 | 99.72 | 99.82 | 66900.0 |
| 2001-09-24 09:51:00 | SPY | ETF | 99.8 | 99.85 | 99.65 | 99.67 | 56900.0 |
| 2001-09-24 09:52:00 | SPY | ETF | 99.74 | 99.74 | 99.55 | 99.55 | 39200.0 |
| 2001-09-24 09:53:00 | SPY | ETF | 99.55 | 99.65 | 99.45 | 99.59 | 56300.0 |
| 2001-09-24 09:54:00 | SPY | ETF | 99.45 | 99.65 | 99.45 | 99.62 | 64600.0 |
| 2001-09-24 09:55:00 | SPY | ETF | 99.51 | 99.59 | 99.3 | 99.31 | 42500.0 |
| 2001-09-24 09:56:00 | SPY | ETF | 99.37 | 99.45 | 99.3 | 99.35 | 77000.0 |
| 2001-09-24 09:57:00 | SPY | ETF | 99.33 | 99.45 | 99.31 | 99.41 | 110000.0 |
| 2001-09-24 09:58:00 | SPY | ETF | 99.45 | 99.45 | 99.25 | 99.29 | 28600.0 |
| 2001-09-24 09:59:00 | SPY | ETF | 99.35 | 99.4 | 99.26 | 99.4 | 68000.0 |
| 2001-09-24 10:00:00 | SPY | ETF | 99.3 | 99.4 | 99.2 | 99.24 | 50600.0 |
| 2001-09-24 10:01:00 | SPY | ETF | 99.33 | 99.35 | 99.06 | 99.2 | 73400.0 |
| 2001-09-24 10:02:00 | SPY | ETF | 99.27 | 99.31 | 99.12 | 99.31 | 267400.0 |
| 2001-09-24 10:03:00 | SPY | ETF | 99.31 | 99.34 | 99.22 | 99.32 | 30700.0 |
| 2001-09-24 10:04:00 | SPY | ETF | 99.3 | 99.45 | 99.27 | 99.39 | 47200.0 |
| 2001-09-24 10:05:00 | SPY | ETF | 99.39 | 99.45 | 99.21 | 99.39 | 167000.0 |
| 2001-09-24 10:06:00 | SPY | ETF | 99.35 | 99.42 | 99.18 | 99.2 | 33500.0 |
| 2001-09-24 10:07:00 | SPY | ETF | 99.3 | 99.4 | 99.12 | 99.24 | 171500.0 |
| 2001-09-24 10:08:00 | SPY | ETF | 99.3 | 99.6 | 99.3 | 99.6 | 147500.0 |
| 2001-09-24 10:09:00 | SPY | ETF | 99.57 | 99.59 | 99.18 | 99.52 | 118300.0 |
| 2001-09-24 10:10:00 | SPY | ETF | 99.52 | 99.58 | 99.45 | 99.52 | 65200.0 |
| 2001-09-24 10:11:00 | SPY | ETF | 99.5 | 99.6 | 99.44 | 99.44 | 77900.0 |
| 2001-09-24 10:12:00 | SPY | ETF | 99.5 | 99.59 | 99.41 | 99.52 | 129500.0 |
| 2001-09-24 10:13:00 | SPY | ETF | 99.5 | 99.56 | 99.29 | 99.32 | 31100.0 |
| 2001-09-24 10:14:00 | SPY | ETF | 99.3 | 99.58 | 99.25 | 99.32 | 37000.0 |
| 2001-09-24 10:15:00 | SPY | ETF | 99.3 | 99.42 | 99.2 | 99.26 | 27300.0 |
| 2001-09-24 10:16:00 | SPY | ETF | 99.31 | 99.35 | 99.15 | 99.26 | 118200.0 |
| 2001-09-24 10:17:00 | SPY | ETF | 99.17 | 99.44 | 99.17 | 99.44 | 32400.0 |
| 2001-09-24 10:18:00 | SPY | ETF | 99.39 | 99.42 | 99.29 | 99.29 | 31700.0 |
| 2001-09-24 10:19:00 | SPY | ETF | 99.28 | 99.48 | 99.28 | 99.4 | 20900.0 |
> showing 50 of 4,014 rows — these rows as CSV