PREVIEW / etf_1min / 2023-08-28
file: by_date/etf_1min/2023/2023-08-28.parquet size: 4.2 MB rows: 245,649
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-28 04:00:00 | SPY | ETF | 437.3 | 440.25 | 437.3 | 440.25 | 500.0 |
| 2023-08-28 04:01:00 | SPY | ETF | 440.29 | 440.29 | 440.28 | 440.28 | 521.0 |
| 2023-08-28 04:03:00 | SPY | ETF | 440.43 | 440.43 | 440.43 | 440.43 | 500.0 |
| 2023-08-28 04:04:00 | SPY | ETF | 440.44 | 440.44 | 440.44 | 440.44 | 143.0 |
| 2023-08-28 04:05:00 | SPY | ETF | 440.42 | 440.42 | 440.42 | 440.42 | 109.0 |
| 2023-08-28 04:06:00 | SPY | ETF | 440.42 | 440.46 | 440.42 | 440.46 | 232.0 |
| 2023-08-28 04:08:00 | SPY | ETF | 440.62 | 440.62 | 440.62 | 440.62 | 100.0 |
| 2023-08-28 04:12:00 | SPY | ETF | 440.64 | 440.64 | 440.64 | 440.64 | 180.0 |
| 2023-08-28 04:14:00 | SPY | ETF | 440.49 | 440.49 | 440.49 | 440.49 | 243.0 |
| 2023-08-28 04:27:00 | SPY | ETF | 440.88 | 440.88 | 440.88 | 440.88 | 200.0 |
| 2023-08-28 04:30:00 | SPY | ETF | 440.86 | 440.86 | 440.86 | 440.86 | 100.0 |
| 2023-08-28 04:31:00 | SPY | ETF | 440.84 | 440.89 | 440.84 | 440.89 | 1700.0 |
| 2023-08-28 04:32:00 | SPY | ETF | 440.86 | 440.86 | 440.75 | 440.75 | 600.0 |
| 2023-08-28 04:33:00 | SPY | ETF | 440.8 | 440.8 | 440.8 | 440.8 | 100.0 |
| 2023-08-28 04:34:00 | SPY | ETF | 440.87 | 440.88 | 440.87 | 440.88 | 210.0 |
| 2023-08-28 04:35:00 | SPY | ETF | 440.92 | 440.92 | 440.92 | 440.92 | 123.0 |
| 2023-08-28 04:38:00 | SPY | ETF | 440.93 | 440.93 | 440.89 | 440.89 | 201.0 |
| 2023-08-28 04:41:00 | SPY | ETF | 440.85 | 440.85 | 440.85 | 440.85 | 140.0 |
| 2023-08-28 04:44:00 | SPY | ETF | 440.78 | 440.78 | 440.78 | 440.78 | 101.0 |
| 2023-08-28 04:45:00 | SPY | ETF | 440.8 | 440.82 | 440.8 | 440.82 | 800.0 |
| 2023-08-28 04:47:00 | SPY | ETF | 440.79 | 440.79 | 440.79 | 440.79 | 175.0 |
| 2023-08-28 04:48:00 | SPY | ETF | 440.7 | 440.7 | 440.7 | 440.7 | 100.0 |
| 2023-08-28 04:49:00 | SPY | ETF | 440.65 | 440.65 | 440.65 | 440.65 | 100.0 |
| 2023-08-28 04:51:00 | SPY | ETF | 440.64 | 440.64 | 440.64 | 440.64 | 400.0 |
| 2023-08-28 04:54:00 | SPY | ETF | 440.68 | 440.68 | 440.68 | 440.68 | 100.0 |
| 2023-08-28 04:56:00 | SPY | ETF | 440.61 | 440.61 | 440.61 | 440.61 | 1199.0 |
| 2023-08-28 04:59:00 | SPY | ETF | 440.64 | 440.64 | 440.64 | 440.64 | 289.0 |
| 2023-08-28 05:07:00 | SPY | ETF | 440.54 | 440.54 | 440.54 | 440.54 | 120.0 |
| 2023-08-28 05:09:00 | SPY | ETF | 440.4 | 440.4 | 440.38 | 440.38 | 1000.0 |
| 2023-08-28 05:14:00 | SPY | ETF | 440.36 | 440.37 | 440.36 | 440.37 | 278.0 |
| 2023-08-28 05:18:00 | SPY | ETF | 440.26 | 440.26 | 440.26 | 440.26 | 100.0 |
| 2023-08-28 05:24:00 | SPY | ETF | 440.4 | 440.41 | 440.4 | 440.41 | 1500.0 |
| 2023-08-28 05:27:00 | SPY | ETF | 440.47 | 440.47 | 440.47 | 440.47 | 400.0 |
| 2023-08-28 05:35:00 | SPY | ETF | 440.71 | 440.71 | 440.71 | 440.71 | 100.0 |
| 2023-08-28 05:36:00 | SPY | ETF | 440.82 | 440.82 | 440.8 | 440.8 | 249.0 |
| 2023-08-28 05:37:00 | SPY | ETF | 440.77 | 440.77 | 440.76 | 440.77 | 1110.0 |
| 2023-08-28 05:40:00 | SPY | ETF | 440.61 | 440.66 | 440.61 | 440.66 | 312.0 |
| 2023-08-28 05:41:00 | SPY | ETF | 440.61 | 440.61 | 440.61 | 440.61 | 188.0 |
| 2023-08-28 05:43:00 | SPY | ETF | 440.61 | 440.61 | 440.61 | 440.61 | 1210.0 |
| 2023-08-28 05:50:00 | SPY | ETF | 440.55 | 440.55 | 440.55 | 440.55 | 225.0 |
| 2023-08-28 05:53:00 | SPY | ETF | 440.71 | 440.71 | 440.57 | 440.57 | 2450.0 |
| 2023-08-28 06:00:00 | SPY | ETF | 440.58 | 440.58 | 440.57 | 440.57 | 1300.0 |
| 2023-08-28 06:01:00 | SPY | ETF | 440.57 | 440.57 | 440.57 | 440.57 | 106.0 |
| 2023-08-28 06:05:00 | SPY | ETF | 440.37 | 440.37 | 440.37 | 440.37 | 700.0 |
| 2023-08-28 06:07:00 | SPY | ETF | 440.35 | 440.35 | 440.3 | 440.3 | 350.0 |
| 2023-08-28 06:11:00 | SPY | ETF | 440.15 | 440.15 | 440.15 | 440.15 | 160.0 |
| 2023-08-28 06:13:00 | SPY | ETF | 440.25 | 440.25 | 440.25 | 440.25 | 100.0 |
| 2023-08-28 06:14:00 | SPY | ETF | 440.31 | 440.31 | 440.26 | 440.31 | 602.0 |
| 2023-08-28 06:16:00 | SPY | ETF | 440.25 | 440.25 | 440.25 | 440.25 | 100.0 |
| 2023-08-28 06:17:00 | SPY | ETF | 440.26 | 440.26 | 440.26 | 440.26 | 100.0 |
> showing 50 of 245,649 rows — these rows as CSV