PREVIEW / etf_1min / 2023-06-09
file: by_date/etf_1min/2023/2023-06-09.parquet size: 4.4 MB rows: 244,912
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-06-09 04:01:00 | SPY | ETF | 428.41 | 428.41 | 428.39 | 428.4 | 950.0 |
| 2023-06-09 04:02:00 | SPY | ETF | 428.4 | 428.52 | 428.4 | 428.52 | 271.0 |
| 2023-06-09 04:03:00 | SPY | ETF | 428.52 | 428.52 | 428.47 | 428.47 | 1400.0 |
| 2023-06-09 04:04:00 | SPY | ETF | 428.45 | 428.45 | 428.45 | 428.45 | 400.0 |
| 2023-06-09 04:05:00 | SPY | ETF | 428.5 | 428.5 | 428.44 | 428.45 | 2030.0 |
| 2023-06-09 04:06:00 | SPY | ETF | 428.37 | 428.37 | 428.37 | 428.37 | 472.0 |
| 2023-06-09 04:07:00 | SPY | ETF | 428.38 | 428.38 | 428.38 | 428.38 | 300.0 |
| 2023-06-09 04:08:00 | SPY | ETF | 428.3 | 428.3 | 428.24 | 428.24 | 1975.0 |
| 2023-06-09 04:09:00 | SPY | ETF | 428.23 | 428.23 | 428.23 | 428.23 | 300.0 |
| 2023-06-09 04:10:00 | SPY | ETF | 428.24 | 428.24 | 428.24 | 428.24 | 1400.0 |
| 2023-06-09 04:13:00 | SPY | ETF | 428.31 | 428.31 | 428.31 | 428.31 | 300.0 |
| 2023-06-09 04:14:00 | SPY | ETF | 428.44 | 428.45 | 428.44 | 428.45 | 1200.0 |
| 2023-06-09 04:16:00 | SPY | ETF | 428.43 | 428.43 | 428.43 | 428.43 | 200.0 |
| 2023-06-09 04:17:00 | SPY | ETF | 428.39 | 428.39 | 428.39 | 428.39 | 100.0 |
| 2023-06-09 04:19:00 | SPY | ETF | 428.39 | 428.39 | 428.36 | 428.36 | 2286.0 |
| 2023-06-09 04:20:00 | SPY | ETF | 428.36 | 428.36 | 428.36 | 428.36 | 155.0 |
| 2023-06-09 04:22:00 | SPY | ETF | 428.34 | 428.34 | 428.34 | 428.34 | 156.0 |
| 2023-06-09 04:24:00 | SPY | ETF | 428.43 | 428.43 | 428.43 | 428.43 | 243.0 |
| 2023-06-09 04:26:00 | SPY | ETF | 428.43 | 428.45 | 428.43 | 428.45 | 497.0 |
| 2023-06-09 04:27:00 | SPY | ETF | 428.44 | 428.5 | 428.44 | 428.5 | 400.0 |
| 2023-06-09 04:29:00 | SPY | ETF | 428.53 | 428.55 | 428.53 | 428.55 | 2221.0 |
| 2023-06-09 04:30:00 | SPY | ETF | 428.62 | 428.62 | 428.58 | 428.58 | 669.0 |
| 2023-06-09 04:31:00 | SPY | ETF | 428.54 | 428.55 | 428.49 | 428.49 | 1500.0 |
| 2023-06-09 04:32:00 | SPY | ETF | 428.54 | 428.54 | 428.54 | 428.54 | 130.0 |
| 2023-06-09 04:34:00 | SPY | ETF | 428.41 | 428.41 | 428.41 | 428.41 | 108.0 |
| 2023-06-09 04:36:00 | SPY | ETF | 428.5 | 428.5 | 428.5 | 428.5 | 700.0 |
| 2023-06-09 04:38:00 | SPY | ETF | 428.54 | 428.54 | 428.54 | 428.54 | 450.0 |
| 2023-06-09 04:40:00 | SPY | ETF | 428.5 | 428.59 | 428.5 | 428.59 | 1139.0 |
| 2023-06-09 04:42:00 | SPY | ETF | 428.53 | 428.53 | 428.53 | 428.53 | 400.0 |
| 2023-06-09 04:44:00 | SPY | ETF | 428.54 | 428.54 | 428.54 | 428.54 | 200.0 |
| 2023-06-09 04:45:00 | SPY | ETF | 428.56 | 428.58 | 428.56 | 428.57 | 1700.0 |
| 2023-06-09 04:48:00 | SPY | ETF | 428.62 | 428.63 | 428.62 | 428.63 | 1400.0 |
| 2023-06-09 04:49:00 | SPY | ETF | 428.64 | 428.65 | 428.64 | 428.64 | 990.0 |
| 2023-06-09 04:50:00 | SPY | ETF | 428.67 | 428.72 | 428.67 | 428.71 | 1145.0 |
| 2023-06-09 04:51:00 | SPY | ETF | 428.77 | 428.77 | 428.77 | 428.77 | 1100.0 |
| 2023-06-09 04:53:00 | SPY | ETF | 428.74 | 428.74 | 428.74 | 428.74 | 145.0 |
| 2023-06-09 04:55:00 | SPY | ETF | 428.79 | 428.8 | 428.79 | 428.8 | 990.0 |
| 2023-06-09 04:56:00 | SPY | ETF | 428.81 | 428.82 | 428.81 | 428.81 | 1000.0 |
| 2023-06-09 04:57:00 | SPY | ETF | 428.87 | 428.87 | 428.87 | 428.87 | 367.0 |
| 2023-06-09 05:00:00 | SPY | ETF | 428.84 | 428.84 | 428.84 | 428.84 | 194.0 |
| 2023-06-09 05:01:00 | SPY | ETF | 428.89 | 428.89 | 428.89 | 428.89 | 151.0 |
| 2023-06-09 05:02:00 | SPY | ETF | 428.9 | 428.9 | 428.9 | 428.9 | 140.0 |
| 2023-06-09 05:03:00 | SPY | ETF | 429.1 | 429.1 | 429.1 | 429.1 | 998.0 |
| 2023-06-09 05:04:00 | SPY | ETF | 429.05 | 429.13 | 429.05 | 429.13 | 746.0 |
| 2023-06-09 05:06:00 | SPY | ETF | 429.14 | 429.14 | 429.14 | 429.14 | 500.0 |
| 2023-06-09 05:08:00 | SPY | ETF | 429.03 | 429.03 | 429.03 | 429.03 | 2448.0 |
| 2023-06-09 05:09:00 | SPY | ETF | 429.1 | 429.1 | 429.1 | 429.1 | 112.0 |
| 2023-06-09 05:10:00 | SPY | ETF | 429.08 | 429.08 | 429.08 | 429.08 | 500.0 |
| 2023-06-09 05:14:00 | SPY | ETF | 429.07 | 429.07 | 429.07 | 429.07 | 112.0 |
| 2023-06-09 05:17:00 | SPY | ETF | 429.07 | 429.1 | 429.07 | 429.1 | 600.0 |
> showing 50 of 244,912 rows — these rows as CSV