PREVIEW / etf_1min / 2001-10-18
file: by_date/etf_1min/2001/2001-10-18.parquet size: 60 KB rows: 3,238
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-10-18 09:30:00 | SPY | ETF | 107.82 | 107.82 | 107.7 | 107.74 | 363300.0 |
| 2001-10-18 09:31:00 | SPY | ETF | 107.74 | 107.9 | 107.71 | 107.84 | 74000.0 |
| 2001-10-18 09:32:00 | SPY | ETF | 107.78 | 107.91 | 107.78 | 107.8 | 205700.0 |
| 2001-10-18 09:33:00 | SPY | ETF | 107.81 | 107.87 | 107.65 | 107.67 | 97100.0 |
| 2001-10-18 09:34:00 | SPY | ETF | 107.67 | 107.8 | 107.52 | 107.55 | 116600.0 |
| 2001-10-18 09:35:00 | SPY | ETF | 107.61 | 107.61 | 107.4 | 107.52 | 131500.0 |
| 2001-10-18 09:36:00 | SPY | ETF | 107.49 | 107.6 | 107.4 | 107.54 | 214500.0 |
| 2001-10-18 09:37:00 | SPY | ETF | 107.6 | 107.65 | 107.5 | 107.56 | 338900.0 |
| 2001-10-18 09:38:00 | SPY | ETF | 107.51 | 107.59 | 107.39 | 107.45 | 60500.0 |
| 2001-10-18 09:39:00 | SPY | ETF | 107.42 | 107.65 | 107.42 | 107.65 | 61500.0 |
| 2001-10-18 09:40:00 | SPY | ETF | 107.64 | 107.75 | 107.6 | 107.74 | 45400.0 |
| 2001-10-18 09:41:00 | SPY | ETF | 107.68 | 107.88 | 107.68 | 107.88 | 54100.0 |
| 2001-10-18 09:42:00 | SPY | ETF | 107.78 | 107.88 | 107.71 | 107.75 | 63200.0 |
| 2001-10-18 09:43:00 | SPY | ETF | 107.75 | 107.9 | 107.71 | 107.84 | 35500.0 |
| 2001-10-18 09:44:00 | SPY | ETF | 107.85 | 107.93 | 107.78 | 107.81 | 97800.0 |
| 2001-10-18 09:45:00 | SPY | ETF | 107.85 | 107.9 | 107.8 | 107.82 | 140700.0 |
| 2001-10-18 09:46:00 | SPY | ETF | 107.83 | 107.85 | 107.73 | 107.8 | 53300.0 |
| 2001-10-18 09:47:00 | SPY | ETF | 107.8 | 108.08 | 107.73 | 108.05 | 106400.0 |
| 2001-10-18 09:48:00 | SPY | ETF | 108.08 | 108.08 | 107.91 | 107.95 | 107500.0 |
| 2001-10-18 09:49:00 | SPY | ETF | 107.91 | 108.07 | 107.9 | 108.0 | 15700.0 |
| 2001-10-18 09:50:00 | SPY | ETF | 108.0 | 108.16 | 108.0 | 108.15 | 66100.0 |
| 2001-10-18 09:51:00 | SPY | ETF | 108.15 | 108.15 | 107.96 | 108.05 | 58000.0 |
| 2001-10-18 09:52:00 | SPY | ETF | 107.98 | 108.07 | 107.95 | 107.97 | 42300.0 |
| 2001-10-18 09:53:00 | SPY | ETF | 107.96 | 108.0 | 107.77 | 107.77 | 89400.0 |
| 2001-10-18 09:54:00 | SPY | ETF | 107.75 | 107.85 | 107.75 | 107.76 | 102900.0 |
| 2001-10-18 09:55:00 | SPY | ETF | 107.75 | 107.75 | 107.6 | 107.7 | 14400.0 |
| 2001-10-18 09:56:00 | SPY | ETF | 107.74 | 107.78 | 107.7 | 107.73 | 15200.0 |
| 2001-10-18 09:57:00 | SPY | ETF | 107.7 | 107.79 | 107.7 | 107.78 | 43300.0 |
| 2001-10-18 09:58:00 | SPY | ETF | 107.78 | 107.8 | 107.51 | 107.56 | 81600.0 |
| 2001-10-18 09:59:00 | SPY | ETF | 107.6 | 107.65 | 107.53 | 107.57 | 49800.0 |
| 2001-10-18 10:00:00 | SPY | ETF | 107.55 | 107.64 | 107.53 | 107.54 | 55800.0 |
| 2001-10-18 10:01:00 | SPY | ETF | 107.64 | 107.64 | 107.44 | 107.45 | 32600.0 |
| 2001-10-18 10:02:00 | SPY | ETF | 107.48 | 107.61 | 107.4 | 107.52 | 56200.0 |
| 2001-10-18 10:03:00 | SPY | ETF | 107.55 | 107.62 | 107.46 | 107.62 | 22300.0 |
| 2001-10-18 10:04:00 | SPY | ETF | 107.61 | 107.7 | 107.6 | 107.65 | 43800.0 |
| 2001-10-18 10:05:00 | SPY | ETF | 107.66 | 107.72 | 107.61 | 107.65 | 59800.0 |
| 2001-10-18 10:06:00 | SPY | ETF | 107.61 | 107.83 | 107.61 | 107.79 | 51700.0 |
| 2001-10-18 10:07:00 | SPY | ETF | 107.81 | 107.88 | 107.64 | 107.69 | 75400.0 |
| 2001-10-18 10:08:00 | SPY | ETF | 107.68 | 107.88 | 107.68 | 107.87 | 25500.0 |
| 2001-10-18 10:09:00 | SPY | ETF | 107.88 | 107.91 | 107.76 | 107.87 | 25100.0 |
| 2001-10-18 10:10:00 | SPY | ETF | 107.8 | 107.96 | 107.75 | 107.96 | 25900.0 |
| 2001-10-18 10:11:00 | SPY | ETF | 107.98 | 108.04 | 107.92 | 107.99 | 23900.0 |
| 2001-10-18 10:12:00 | SPY | ETF | 108.0 | 108.01 | 107.91 | 108.01 | 193200.0 |
| 2001-10-18 10:13:00 | SPY | ETF | 108.0 | 108.1 | 107.95 | 108.05 | 95800.0 |
| 2001-10-18 10:14:00 | SPY | ETF | 107.98 | 108.0 | 107.87 | 107.87 | 46600.0 |
| 2001-10-18 10:15:00 | SPY | ETF | 107.92 | 107.94 | 107.86 | 107.86 | 13100.0 |
| 2001-10-18 10:16:00 | SPY | ETF | 107.89 | 107.91 | 107.71 | 107.71 | 18300.0 |
| 2001-10-18 10:17:00 | SPY | ETF | 107.79 | 107.79 | 107.67 | 107.74 | 102800.0 |
| 2001-10-18 10:18:00 | SPY | ETF | 107.72 | 107.83 | 107.69 | 107.8 | 22600.0 |
| 2001-10-18 10:19:00 | SPY | ETF | 107.81 | 107.84 | 107.7 | 107.7 | 17300.0 |
> showing 50 of 3,238 rows — these rows as CSV