PREVIEW / etf_1min / 2021-10-18
file: by_date/etf_1min/2021/2021-10-18.parquet size: 3.9 MB rows: 222,393
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-18 04:00:00 | SPY | ETF | 445.1 | 445.62 | 444.35 | 444.35 | 19051.0 |
| 2021-10-18 04:01:00 | SPY | ETF | 444.4 | 444.48 | 444.4 | 444.48 | 9975.0 |
| 2021-10-18 04:02:00 | SPY | ETF | 444.55 | 444.62 | 444.55 | 444.59 | 2600.0 |
| 2021-10-18 04:03:00 | SPY | ETF | 444.77 | 444.81 | 444.75 | 444.75 | 2192.0 |
| 2021-10-18 04:04:00 | SPY | ETF | 444.86 | 444.89 | 444.81 | 444.81 | 5089.0 |
| 2021-10-18 04:05:00 | SPY | ETF | 444.81 | 444.81 | 444.77 | 444.77 | 200.0 |
| 2021-10-18 04:06:00 | SPY | ETF | 444.77 | 444.79 | 444.75 | 444.76 | 3120.0 |
| 2021-10-18 04:07:00 | SPY | ETF | 444.74 | 444.76 | 444.71 | 444.76 | 2600.0 |
| 2021-10-18 04:10:00 | SPY | ETF | 444.94 | 445.0 | 444.93 | 444.98 | 3146.0 |
| 2021-10-18 04:12:00 | SPY | ETF | 444.84 | 444.91 | 444.75 | 444.91 | 15199.0 |
| 2021-10-18 04:13:00 | SPY | ETF | 444.92 | 444.92 | 444.85 | 444.92 | 500.0 |
| 2021-10-18 04:14:00 | SPY | ETF | 444.9 | 444.91 | 444.9 | 444.9 | 900.0 |
| 2021-10-18 04:15:00 | SPY | ETF | 444.85 | 444.85 | 444.85 | 444.85 | 100.0 |
| 2021-10-18 04:16:00 | SPY | ETF | 444.83 | 444.83 | 444.83 | 444.83 | 100.0 |
| 2021-10-18 04:17:00 | SPY | ETF | 444.83 | 444.89 | 444.83 | 444.87 | 300.0 |
| 2021-10-18 04:20:00 | SPY | ETF | 444.86 | 444.86 | 444.86 | 444.86 | 199.0 |
| 2021-10-18 04:21:00 | SPY | ETF | 444.87 | 444.87 | 444.87 | 444.87 | 300.0 |
| 2021-10-18 04:22:00 | SPY | ETF | 444.87 | 444.87 | 444.87 | 444.87 | 100.0 |
| 2021-10-18 04:23:00 | SPY | ETF | 444.86 | 445.01 | 444.85 | 445.01 | 897.0 |
| 2021-10-18 04:24:00 | SPY | ETF | 444.87 | 444.87 | 444.87 | 444.87 | 241.0 |
| 2021-10-18 04:25:00 | SPY | ETF | 444.81 | 444.81 | 444.75 | 444.75 | 700.0 |
| 2021-10-18 04:26:00 | SPY | ETF | 444.71 | 444.71 | 444.71 | 444.71 | 245.0 |
| 2021-10-18 04:27:00 | SPY | ETF | 444.81 | 444.81 | 444.81 | 444.81 | 250.0 |
| 2021-10-18 04:29:00 | SPY | ETF | 444.75 | 444.75 | 444.75 | 444.75 | 100.0 |
| 2021-10-18 04:30:00 | SPY | ETF | 444.76 | 444.76 | 444.76 | 444.76 | 100.0 |
| 2021-10-18 04:32:00 | SPY | ETF | 444.71 | 444.71 | 444.71 | 444.71 | 100.0 |
| 2021-10-18 04:33:00 | SPY | ETF | 444.63 | 444.63 | 444.59 | 444.59 | 1100.0 |
| 2021-10-18 04:34:00 | SPY | ETF | 444.64 | 444.64 | 444.62 | 444.62 | 200.0 |
| 2021-10-18 04:37:00 | SPY | ETF | 444.58 | 444.58 | 444.58 | 444.58 | 100.0 |
| 2021-10-18 04:39:00 | SPY | ETF | 444.58 | 444.58 | 444.52 | 444.52 | 300.0 |
| 2021-10-18 04:40:00 | SPY | ETF | 444.5 | 444.5 | 444.5 | 444.5 | 300.0 |
| 2021-10-18 04:41:00 | SPY | ETF | 444.5 | 444.5 | 444.5 | 444.5 | 100.0 |
| 2021-10-18 04:42:00 | SPY | ETF | 444.5 | 444.5 | 444.5 | 444.5 | 5850.0 |
| 2021-10-18 04:45:00 | SPY | ETF | 444.58 | 444.58 | 444.54 | 444.54 | 600.0 |
| 2021-10-18 04:46:00 | SPY | ETF | 444.62 | 444.63 | 444.62 | 444.63 | 300.0 |
| 2021-10-18 04:47:00 | SPY | ETF | 444.65 | 444.67 | 444.65 | 444.66 | 700.0 |
| 2021-10-18 04:48:00 | SPY | ETF | 444.68 | 444.68 | 444.6 | 444.6 | 1200.0 |
| 2021-10-18 04:52:00 | SPY | ETF | 444.52 | 444.52 | 444.52 | 444.52 | 200.0 |
| 2021-10-18 04:53:00 | SPY | ETF | 444.5 | 444.5 | 444.5 | 444.5 | 1000.0 |
| 2021-10-18 04:56:00 | SPY | ETF | 444.49 | 444.49 | 444.49 | 444.49 | 199.0 |
| 2021-10-18 04:58:00 | SPY | ETF | 444.38 | 444.38 | 444.38 | 444.38 | 122.0 |
| 2021-10-18 04:59:00 | SPY | ETF | 444.41 | 444.41 | 444.41 | 444.41 | 100.0 |
| 2021-10-18 05:01:00 | SPY | ETF | 444.37 | 444.41 | 444.37 | 444.41 | 451.0 |
| 2021-10-18 05:02:00 | SPY | ETF | 444.28 | 444.28 | 444.28 | 444.28 | 100.0 |
| 2021-10-18 05:03:00 | SPY | ETF | 444.14 | 444.14 | 444.14 | 444.14 | 100.0 |
| 2021-10-18 05:04:00 | SPY | ETF | 444.1 | 444.12 | 444.08 | 444.11 | 8375.0 |
| 2021-10-18 05:05:00 | SPY | ETF | 444.19 | 444.19 | 444.19 | 444.19 | 119.0 |
| 2021-10-18 05:06:00 | SPY | ETF | 444.18 | 444.18 | 444.18 | 444.18 | 300.0 |
| 2021-10-18 05:08:00 | SPY | ETF | 444.34 | 444.34 | 444.33 | 444.33 | 200.0 |
| 2021-10-18 05:09:00 | SPY | ETF | 444.26 | 444.26 | 444.26 | 444.26 | 200.0 |
> showing 50 of 222,393 rows — these rows as CSV