PREVIEW / etf_1min / 2001-06-01
file: by_date/etf_1min/2001/2001-06-01.parquet size: 55 KB rows: 2,869
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-06-01 09:30:00 | SPY | ETF | 126.2 | 126.2 | 126.2 | 126.2 | 25000.0 |
| 2001-06-01 09:31:00 | SPY | ETF | 126.2 | 126.3 | 126.2 | 126.3 | 48100.0 |
| 2001-06-01 09:32:00 | SPY | ETF | 126.34 | 126.39 | 126.25 | 126.26 | 12400.0 |
| 2001-06-01 09:33:00 | SPY | ETF | 126.26 | 126.38 | 126.26 | 126.32 | 10500.0 |
| 2001-06-01 09:34:00 | SPY | ETF | 126.25 | 126.3 | 126.15 | 126.25 | 114300.0 |
| 2001-06-01 09:35:00 | SPY | ETF | 126.11 | 126.29 | 125.93 | 125.98 | 234700.0 |
| 2001-06-01 09:36:00 | SPY | ETF | 125.9 | 126.09 | 125.9 | 126.09 | 24000.0 |
| 2001-06-01 09:37:00 | SPY | ETF | 126.0 | 126.04 | 125.75 | 125.75 | 23100.0 |
| 2001-06-01 09:38:00 | SPY | ETF | 125.82 | 126.05 | 125.71 | 125.8 | 13800.0 |
| 2001-06-01 09:39:00 | SPY | ETF | 125.86 | 125.86 | 125.71 | 125.84 | 136400.0 |
| 2001-06-01 09:40:00 | SPY | ETF | 125.83 | 125.87 | 125.75 | 125.85 | 12700.0 |
| 2001-06-01 09:41:00 | SPY | ETF | 125.8 | 125.99 | 125.8 | 125.92 | 20900.0 |
| 2001-06-01 09:42:00 | SPY | ETF | 125.9 | 126.05 | 125.88 | 126.01 | 35300.0 |
| 2001-06-01 09:43:00 | SPY | ETF | 126.06 | 126.08 | 125.95 | 126.08 | 14000.0 |
| 2001-06-01 09:44:00 | SPY | ETF | 126.02 | 126.13 | 126.0 | 126.08 | 70400.0 |
| 2001-06-01 09:45:00 | SPY | ETF | 126.04 | 126.08 | 126.0 | 126.08 | 25800.0 |
| 2001-06-01 09:46:00 | SPY | ETF | 126.1 | 126.16 | 126.06 | 126.16 | 9800.0 |
| 2001-06-01 09:47:00 | SPY | ETF | 126.2 | 126.24 | 126.06 | 126.06 | 14900.0 |
| 2001-06-01 09:48:00 | SPY | ETF | 126.05 | 126.1 | 125.92 | 125.92 | 23500.0 |
| 2001-06-01 09:49:00 | SPY | ETF | 125.88 | 125.88 | 125.83 | 125.85 | 7400.0 |
| 2001-06-01 09:50:00 | SPY | ETF | 125.85 | 125.9 | 125.8 | 125.87 | 20800.0 |
| 2001-06-01 09:51:00 | SPY | ETF | 125.91 | 126.04 | 125.88 | 126.04 | 45900.0 |
| 2001-06-01 09:52:00 | SPY | ETF | 125.92 | 126.01 | 125.87 | 125.88 | 66100.0 |
| 2001-06-01 09:53:00 | SPY | ETF | 125.9 | 125.9 | 125.8 | 125.8 | 14600.0 |
| 2001-06-01 09:54:00 | SPY | ETF | 125.77 | 125.88 | 125.74 | 125.81 | 16000.0 |
| 2001-06-01 09:55:00 | SPY | ETF | 125.93 | 125.93 | 125.81 | 125.89 | 8000.0 |
| 2001-06-01 09:56:00 | SPY | ETF | 125.8 | 126.03 | 125.8 | 126.0 | 12100.0 |
| 2001-06-01 09:57:00 | SPY | ETF | 125.99 | 126.1 | 125.92 | 126.1 | 10300.0 |
| 2001-06-01 09:58:00 | SPY | ETF | 126.07 | 126.14 | 126.0 | 126.14 | 4600.0 |
| 2001-06-01 09:59:00 | SPY | ETF | 126.14 | 126.14 | 126.04 | 126.04 | 84900.0 |
| 2001-06-01 10:00:00 | SPY | ETF | 126.14 | 126.25 | 126.01 | 126.24 | 40900.0 |
| 2001-06-01 10:01:00 | SPY | ETF | 126.25 | 126.25 | 125.89 | 126.0 | 123100.0 |
| 2001-06-01 10:02:00 | SPY | ETF | 126.02 | 126.14 | 125.89 | 126.0 | 107300.0 |
| 2001-06-01 10:03:00 | SPY | ETF | 126.01 | 126.03 | 125.81 | 125.85 | 70700.0 |
| 2001-06-01 10:04:00 | SPY | ETF | 125.99 | 125.99 | 125.51 | 125.51 | 60700.0 |
| 2001-06-01 10:05:00 | SPY | ETF | 125.69 | 125.85 | 125.41 | 125.55 | 539100.0 |
| 2001-06-01 10:06:00 | SPY | ETF | 125.55 | 125.55 | 125.35 | 125.45 | 62300.0 |
| 2001-06-01 10:07:00 | SPY | ETF | 125.41 | 125.54 | 125.3 | 125.42 | 133800.0 |
| 2001-06-01 10:08:00 | SPY | ETF | 125.36 | 125.5 | 125.35 | 125.41 | 44000.0 |
| 2001-06-01 10:09:00 | SPY | ETF | 125.4 | 125.56 | 125.4 | 125.56 | 42400.0 |
| 2001-06-01 10:10:00 | SPY | ETF | 125.46 | 125.5 | 125.4 | 125.4 | 20000.0 |
| 2001-06-01 10:11:00 | SPY | ETF | 125.38 | 125.49 | 125.37 | 125.41 | 28400.0 |
| 2001-06-01 10:12:00 | SPY | ETF | 125.49 | 125.49 | 125.37 | 125.45 | 26100.0 |
| 2001-06-01 10:13:00 | SPY | ETF | 125.5 | 125.57 | 125.41 | 125.5 | 39400.0 |
| 2001-06-01 10:14:00 | SPY | ETF | 125.49 | 125.55 | 125.49 | 125.55 | 31600.0 |
| 2001-06-01 10:15:00 | SPY | ETF | 125.58 | 125.65 | 125.55 | 125.59 | 46000.0 |
| 2001-06-01 10:16:00 | SPY | ETF | 125.64 | 125.64 | 125.53 | 125.59 | 257300.0 |
| 2001-06-01 10:17:00 | SPY | ETF | 125.5 | 125.58 | 125.49 | 125.5 | 8800.0 |
| 2001-06-01 10:18:00 | SPY | ETF | 125.55 | 125.55 | 125.4 | 125.4 | 34700.0 |
| 2001-06-01 10:19:00 | SPY | ETF | 125.48 | 125.48 | 125.3 | 125.3 | 22000.0 |
> showing 50 of 2,869 rows — these rows as CSV