PREVIEW / etf_1min / 2022-03-18
file: by_date/etf_1min/2022/2022-03-18.parquet size: 4.6 MB rows: 256,449
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-18 04:00:00 | SPY | ETF | 438.0 | 438.05 | 437.93 | 437.93 | 1350.0 |
| 2022-03-18 04:01:00 | SPY | ETF | 437.86 | 437.94 | 437.86 | 437.94 | 200.0 |
| 2022-03-18 04:02:00 | SPY | ETF | 437.84 | 437.84 | 437.64 | 437.64 | 1507.0 |
| 2022-03-18 04:03:00 | SPY | ETF | 437.65 | 437.65 | 437.51 | 437.56 | 1400.0 |
| 2022-03-18 04:04:00 | SPY | ETF | 437.49 | 437.59 | 437.49 | 437.59 | 448.0 |
| 2022-03-18 04:05:00 | SPY | ETF | 437.6 | 437.6 | 437.56 | 437.56 | 553.0 |
| 2022-03-18 04:06:00 | SPY | ETF | 437.47 | 437.51 | 437.47 | 437.51 | 206.0 |
| 2022-03-18 04:07:00 | SPY | ETF | 437.45 | 437.45 | 437.45 | 437.45 | 100.0 |
| 2022-03-18 04:08:00 | SPY | ETF | 437.53 | 437.53 | 437.53 | 437.53 | 102.0 |
| 2022-03-18 04:09:00 | SPY | ETF | 437.63 | 437.63 | 437.63 | 437.63 | 100.0 |
| 2022-03-18 04:10:00 | SPY | ETF | 437.55 | 437.55 | 437.54 | 437.54 | 470.0 |
| 2022-03-18 04:11:00 | SPY | ETF | 437.55 | 437.55 | 437.55 | 437.55 | 600.0 |
| 2022-03-18 04:12:00 | SPY | ETF | 437.63 | 437.63 | 437.63 | 437.63 | 500.0 |
| 2022-03-18 04:13:00 | SPY | ETF | 437.67 | 437.88 | 437.67 | 437.88 | 200.0 |
| 2022-03-18 04:15:00 | SPY | ETF | 437.81 | 437.81 | 437.66 | 437.66 | 200.0 |
| 2022-03-18 04:17:00 | SPY | ETF | 437.77 | 437.8 | 437.77 | 437.8 | 913.0 |
| 2022-03-18 04:18:00 | SPY | ETF | 437.76 | 437.76 | 437.46 | 437.46 | 473.0 |
| 2022-03-18 04:19:00 | SPY | ETF | 437.4 | 437.4 | 437.4 | 437.4 | 110.0 |
| 2022-03-18 04:21:00 | SPY | ETF | 437.65 | 437.65 | 437.65 | 437.65 | 100.0 |
| 2022-03-18 04:23:00 | SPY | ETF | 437.79 | 437.89 | 437.79 | 437.89 | 200.0 |
| 2022-03-18 04:26:00 | SPY | ETF | 437.73 | 437.89 | 437.73 | 437.89 | 2700.0 |
| 2022-03-18 04:27:00 | SPY | ETF | 437.66 | 437.67 | 437.66 | 437.66 | 1000.0 |
| 2022-03-18 04:29:00 | SPY | ETF | 437.49 | 437.49 | 437.49 | 437.49 | 500.0 |
| 2022-03-18 04:31:00 | SPY | ETF | 437.28 | 437.28 | 437.28 | 437.28 | 100.0 |
| 2022-03-18 04:33:00 | SPY | ETF | 437.05 | 437.17 | 436.87 | 437.17 | 3724.0 |
| 2022-03-18 04:34:00 | SPY | ETF | 437.07 | 437.11 | 437.0 | 437.11 | 1950.0 |
| 2022-03-18 04:36:00 | SPY | ETF | 437.27 | 437.39 | 437.26 | 437.39 | 1600.0 |
| 2022-03-18 04:39:00 | SPY | ETF | 437.35 | 437.35 | 437.35 | 437.35 | 600.0 |
| 2022-03-18 04:43:00 | SPY | ETF | 437.17 | 437.17 | 437.17 | 437.17 | 1500.0 |
| 2022-03-18 04:44:00 | SPY | ETF | 436.99 | 437.15 | 436.99 | 437.15 | 400.0 |
| 2022-03-18 04:48:00 | SPY | ETF | 436.81 | 436.81 | 436.57 | 436.73 | 6562.0 |
| 2022-03-18 04:49:00 | SPY | ETF | 436.74 | 436.74 | 436.74 | 436.74 | 100.0 |
| 2022-03-18 04:50:00 | SPY | ETF | 436.76 | 436.9 | 436.75 | 436.82 | 800.0 |
| 2022-03-18 04:51:00 | SPY | ETF | 436.83 | 436.83 | 436.83 | 436.83 | 452.0 |
| 2022-03-18 04:52:00 | SPY | ETF | 436.8 | 436.8 | 436.8 | 436.8 | 300.0 |
| 2022-03-18 04:53:00 | SPY | ETF | 436.79 | 436.79 | 436.79 | 436.79 | 280.0 |
| 2022-03-18 04:54:00 | SPY | ETF | 436.8 | 436.8 | 436.8 | 436.8 | 100.0 |
| 2022-03-18 04:55:00 | SPY | ETF | 436.88 | 436.88 | 436.88 | 436.88 | 100.0 |
| 2022-03-18 04:57:00 | SPY | ETF | 437.0 | 437.0 | 437.0 | 437.0 | 600.0 |
| 2022-03-18 04:58:00 | SPY | ETF | 437.09 | 437.09 | 437.05 | 437.08 | 635.0 |
| 2022-03-18 05:00:00 | SPY | ETF | 437.2 | 437.23 | 437.05 | 437.05 | 1075.0 |
| 2022-03-18 05:01:00 | SPY | ETF | 437.03 | 437.03 | 436.8 | 436.8 | 2500.0 |
| 2022-03-18 05:03:00 | SPY | ETF | 437.09 | 437.09 | 437.09 | 437.09 | 500.0 |
| 2022-03-18 05:05:00 | SPY | ETF | 436.97 | 436.97 | 436.97 | 436.97 | 100.0 |
| 2022-03-18 05:08:00 | SPY | ETF | 437.08 | 437.08 | 437.08 | 437.08 | 10980.0 |
| 2022-03-18 05:13:00 | SPY | ETF | 436.97 | 436.97 | 436.97 | 436.97 | 300.0 |
| 2022-03-18 05:14:00 | SPY | ETF | 436.85 | 436.85 | 436.85 | 436.85 | 300.0 |
| 2022-03-18 05:15:00 | SPY | ETF | 436.68 | 436.68 | 436.59 | 436.6 | 1300.0 |
| 2022-03-18 05:16:00 | SPY | ETF | 436.68 | 436.69 | 436.68 | 436.69 | 200.0 |
| 2022-03-18 05:17:00 | SPY | ETF | 436.68 | 436.68 | 436.62 | 436.62 | 500.0 |
> showing 50 of 256,449 rows — these rows as CSV