PREVIEW / etf_1min / 2023-04-28
file: by_date/etf_1min/2023/2023-04-28.parquet size: 4.3 MB rows: 247,144
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-04-28 04:00:00 | SPY | ETF | 411.51 | 411.51 | 411.17 | 411.17 | 1900.0 |
| 2023-04-28 04:01:00 | SPY | ETF | 411.16 | 411.16 | 411.05 | 411.07 | 2500.0 |
| 2023-04-28 04:02:00 | SPY | ETF | 411.01 | 411.01 | 411.0 | 411.0 | 1433.0 |
| 2023-04-28 04:03:00 | SPY | ETF | 411.08 | 411.19 | 411.02 | 411.19 | 1176.0 |
| 2023-04-28 04:04:00 | SPY | ETF | 411.1 | 411.1 | 411.1 | 411.1 | 300.0 |
| 2023-04-28 04:05:00 | SPY | ETF | 411.02 | 411.02 | 411.02 | 411.02 | 3700.0 |
| 2023-04-28 04:06:00 | SPY | ETF | 411.11 | 411.11 | 411.07 | 411.07 | 858.0 |
| 2023-04-28 04:07:00 | SPY | ETF | 411.1 | 411.11 | 411.1 | 411.11 | 200.0 |
| 2023-04-28 04:09:00 | SPY | ETF | 411.03 | 411.03 | 411.03 | 411.03 | 400.0 |
| 2023-04-28 04:10:00 | SPY | ETF | 411.02 | 411.02 | 411.0 | 411.0 | 5230.0 |
| 2023-04-28 04:11:00 | SPY | ETF | 411.05 | 411.1 | 411.05 | 411.1 | 2600.0 |
| 2023-04-28 04:14:00 | SPY | ETF | 411.0 | 411.0 | 411.0 | 411.0 | 200.0 |
| 2023-04-28 04:15:00 | SPY | ETF | 410.99 | 410.99 | 410.91 | 410.91 | 1400.0 |
| 2023-04-28 04:18:00 | SPY | ETF | 411.2 | 411.21 | 411.2 | 411.21 | 400.0 |
| 2023-04-28 04:20:00 | SPY | ETF | 411.16 | 411.16 | 411.16 | 411.16 | 200.0 |
| 2023-04-28 04:21:00 | SPY | ETF | 411.12 | 411.12 | 411.11 | 411.11 | 200.0 |
| 2023-04-28 04:22:00 | SPY | ETF | 410.99 | 411.01 | 410.99 | 411.01 | 200.0 |
| 2023-04-28 04:23:00 | SPY | ETF | 410.99 | 410.99 | 410.99 | 410.99 | 500.0 |
| 2023-04-28 04:24:00 | SPY | ETF | 410.94 | 410.94 | 410.94 | 410.94 | 9700.0 |
| 2023-04-28 04:25:00 | SPY | ETF | 410.89 | 410.89 | 410.89 | 410.89 | 100.0 |
| 2023-04-28 04:26:00 | SPY | ETF | 410.84 | 410.84 | 410.79 | 410.79 | 678.0 |
| 2023-04-28 04:27:00 | SPY | ETF | 410.79 | 410.8 | 410.79 | 410.8 | 1040.0 |
| 2023-04-28 04:29:00 | SPY | ETF | 410.78 | 410.78 | 410.78 | 410.78 | 400.0 |
| 2023-04-28 04:30:00 | SPY | ETF | 410.75 | 410.75 | 410.69 | 410.69 | 500.0 |
| 2023-04-28 04:33:00 | SPY | ETF | 410.85 | 410.85 | 410.85 | 410.85 | 100.0 |
| 2023-04-28 04:35:00 | SPY | ETF | 410.68 | 410.68 | 410.67 | 410.67 | 500.0 |
| 2023-04-28 04:36:00 | SPY | ETF | 410.69 | 410.69 | 410.69 | 410.69 | 162.0 |
| 2023-04-28 04:37:00 | SPY | ETF | 410.67 | 410.7 | 410.59 | 410.59 | 888.0 |
| 2023-04-28 04:38:00 | SPY | ETF | 410.67 | 410.67 | 410.67 | 410.67 | 100.0 |
| 2023-04-28 04:39:00 | SPY | ETF | 410.77 | 410.79 | 410.77 | 410.79 | 1000.0 |
| 2023-04-28 04:41:00 | SPY | ETF | 410.7 | 410.7 | 410.7 | 410.7 | 100.0 |
| 2023-04-28 04:44:00 | SPY | ETF | 410.65 | 410.65 | 410.65 | 410.65 | 113.0 |
| 2023-04-28 04:45:00 | SPY | ETF | 410.65 | 410.68 | 410.65 | 410.65 | 3197.0 |
| 2023-04-28 04:46:00 | SPY | ETF | 410.63 | 410.65 | 410.62 | 410.64 | 1800.0 |
| 2023-04-28 04:47:00 | SPY | ETF | 410.61 | 410.61 | 410.55 | 410.55 | 4900.0 |
| 2023-04-28 04:48:00 | SPY | ETF | 410.54 | 410.59 | 410.54 | 410.59 | 1603.0 |
| 2023-04-28 04:50:00 | SPY | ETF | 410.68 | 410.7 | 410.68 | 410.7 | 8495.0 |
| 2023-04-28 04:51:00 | SPY | ETF | 410.64 | 410.65 | 410.5 | 410.5 | 1900.0 |
| 2023-04-28 04:52:00 | SPY | ETF | 410.52 | 410.52 | 410.52 | 410.52 | 400.0 |
| 2023-04-28 04:53:00 | SPY | ETF | 410.53 | 410.58 | 410.53 | 410.58 | 850.0 |
| 2023-04-28 04:54:00 | SPY | ETF | 410.57 | 410.57 | 410.54 | 410.54 | 400.0 |
| 2023-04-28 04:55:00 | SPY | ETF | 410.55 | 410.55 | 410.5 | 410.53 | 16700.0 |
| 2023-04-28 04:56:00 | SPY | ETF | 410.53 | 410.53 | 410.46 | 410.5 | 21730.0 |
| 2023-04-28 04:57:00 | SPY | ETF | 410.58 | 410.58 | 410.58 | 410.58 | 230.0 |
| 2023-04-28 05:01:00 | SPY | ETF | 410.53 | 410.53 | 410.51 | 410.51 | 1450.0 |
| 2023-04-28 05:02:00 | SPY | ETF | 410.51 | 410.51 | 410.45 | 410.47 | 13795.0 |
| 2023-04-28 05:03:00 | SPY | ETF | 410.47 | 410.47 | 410.42 | 410.45 | 10405.0 |
| 2023-04-28 05:04:00 | SPY | ETF | 410.45 | 410.47 | 410.45 | 410.47 | 4000.0 |
| 2023-04-28 05:05:00 | SPY | ETF | 410.45 | 410.46 | 410.41 | 410.41 | 350.0 |
| 2023-04-28 05:06:00 | SPY | ETF | 410.4 | 410.4 | 410.4 | 410.4 | 10500.0 |
> showing 50 of 247,144 rows — these rows as CSV