PREVIEW / etf_1min / 2020-03-30
file: by_date/etf_1min/2020/2020-03-30.parquet size: 4.5 MB rows: 237,179
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 |
|---|---|---|---|---|---|---|---|
| 2020-03-30 04:00:00 | SPY | ETF | 250.25 | 250.8 | 250.2 | 250.8 | 12158.0 |
| 2020-03-30 04:01:00 | SPY | ETF | 250.88 | 251.13 | 250.84 | 251.13 | 3894.0 |
| 2020-03-30 04:02:00 | SPY | ETF | 251.13 | 251.13 | 251.0 | 251.04 | 5189.0 |
| 2020-03-30 04:03:00 | SPY | ETF | 251.25 | 251.4 | 251.19 | 251.19 | 6202.0 |
| 2020-03-30 04:04:00 | SPY | ETF | 251.3 | 251.42 | 251.3 | 251.38 | 7026.0 |
| 2020-03-30 04:05:00 | SPY | ETF | 251.28 | 251.35 | 251.0 | 251.0 | 34496.0 |
| 2020-03-30 04:06:00 | SPY | ETF | 251.0 | 251.27 | 251.0 | 251.27 | 15182.0 |
| 2020-03-30 04:07:00 | SPY | ETF | 251.6 | 252.0 | 251.5 | 251.8 | 13221.0 |
| 2020-03-30 04:08:00 | SPY | ETF | 251.75 | 251.85 | 251.56 | 251.56 | 751.0 |
| 2020-03-30 04:09:00 | SPY | ETF | 251.8 | 251.9 | 251.75 | 251.88 | 24070.0 |
| 2020-03-30 04:10:00 | SPY | ETF | 251.81 | 251.95 | 251.6 | 251.63 | 2593.0 |
| 2020-03-30 04:11:00 | SPY | ETF | 251.74 | 251.93 | 251.74 | 251.88 | 13968.0 |
| 2020-03-30 04:12:00 | SPY | ETF | 252.0 | 252.03 | 251.63 | 251.73 | 10350.0 |
| 2020-03-30 04:13:00 | SPY | ETF | 251.83 | 251.97 | 251.78 | 251.81 | 5732.0 |
| 2020-03-30 04:14:00 | SPY | ETF | 251.83 | 251.9 | 251.63 | 251.87 | 4667.0 |
| 2020-03-30 04:15:00 | SPY | ETF | 251.83 | 252.05 | 251.76 | 252.05 | 2359.0 |
| 2020-03-30 04:16:00 | SPY | ETF | 252.08 | 252.08 | 251.71 | 251.71 | 5805.0 |
| 2020-03-30 04:17:00 | SPY | ETF | 251.63 | 251.66 | 251.15 | 251.15 | 9570.0 |
| 2020-03-30 04:18:00 | SPY | ETF | 251.23 | 251.3 | 251.17 | 251.2 | 3106.0 |
| 2020-03-30 04:19:00 | SPY | ETF | 251.35 | 251.35 | 251.15 | 251.15 | 9004.0 |
| 2020-03-30 04:20:00 | SPY | ETF | 251.14 | 251.31 | 250.81 | 250.85 | 6102.0 |
| 2020-03-30 04:21:00 | SPY | ETF | 250.94 | 250.94 | 250.74 | 250.76 | 8145.0 |
| 2020-03-30 04:22:00 | SPY | ETF | 250.72 | 250.82 | 250.6 | 250.62 | 5877.0 |
| 2020-03-30 04:23:00 | SPY | ETF | 250.64 | 250.66 | 250.36 | 250.41 | 3793.0 |
| 2020-03-30 04:24:00 | SPY | ETF | 250.48 | 250.64 | 250.48 | 250.6 | 7710.0 |
| 2020-03-30 04:25:00 | SPY | ETF | 250.58 | 250.78 | 250.58 | 250.77 | 1767.0 |
| 2020-03-30 04:26:00 | SPY | ETF | 250.78 | 250.81 | 250.62 | 250.62 | 3297.0 |
| 2020-03-30 04:27:00 | SPY | ETF | 250.69 | 251.07 | 250.69 | 251.05 | 16256.0 |
| 2020-03-30 04:28:00 | SPY | ETF | 251.05 | 251.87 | 251.05 | 251.69 | 8213.0 |
| 2020-03-30 04:29:00 | SPY | ETF | 251.73 | 251.74 | 251.6 | 251.6 | 2060.0 |
| 2020-03-30 04:30:00 | SPY | ETF | 251.51 | 251.51 | 251.47 | 251.47 | 665.0 |
| 2020-03-30 04:31:00 | SPY | ETF | 251.67 | 252.2 | 251.67 | 252.2 | 12007.0 |
| 2020-03-30 04:32:00 | SPY | ETF | 252.27 | 252.52 | 252.27 | 252.34 | 14965.0 |
| 2020-03-30 04:33:00 | SPY | ETF | 252.39 | 252.39 | 252.26 | 252.26 | 3321.0 |
| 2020-03-30 04:34:00 | SPY | ETF | 252.16 | 252.23 | 252.16 | 252.23 | 692.0 |
| 2020-03-30 04:35:00 | SPY | ETF | 252.26 | 252.26 | 252.0 | 252.0 | 326.0 |
| 2020-03-30 04:36:00 | SPY | ETF | 251.86 | 251.86 | 251.67 | 251.67 | 389.0 |
| 2020-03-30 04:37:00 | SPY | ETF | 251.6 | 251.81 | 251.34 | 251.34 | 8421.0 |
| 2020-03-30 04:38:00 | SPY | ETF | 251.55 | 251.92 | 251.55 | 251.92 | 385.0 |
| 2020-03-30 04:39:00 | SPY | ETF | 252.23 | 252.3 | 252.23 | 252.23 | 855.0 |
| 2020-03-30 04:40:00 | SPY | ETF | 252.22 | 252.48 | 252.14 | 252.48 | 1587.0 |
| 2020-03-30 04:41:00 | SPY | ETF | 252.47 | 252.65 | 252.33 | 252.33 | 7351.0 |
| 2020-03-30 04:42:00 | SPY | ETF | 252.43 | 252.69 | 252.43 | 252.66 | 5201.0 |
| 2020-03-30 04:43:00 | SPY | ETF | 252.75 | 253.09 | 252.75 | 252.91 | 8629.0 |
| 2020-03-30 04:44:00 | SPY | ETF | 252.96 | 253.25 | 252.91 | 253.25 | 4165.0 |
| 2020-03-30 04:45:00 | SPY | ETF | 253.31 | 253.51 | 253.24 | 253.24 | 10333.0 |
| 2020-03-30 04:46:00 | SPY | ETF | 253.38 | 253.53 | 253.3 | 253.36 | 6349.0 |
| 2020-03-30 04:47:00 | SPY | ETF | 253.45 | 253.49 | 253.34 | 253.41 | 8450.0 |
| 2020-03-30 04:48:00 | SPY | ETF | 253.54 | 253.66 | 253.3 | 253.33 | 5702.0 |
| 2020-03-30 04:49:00 | SPY | ETF | 253.31 | 253.31 | 253.01 | 253.01 | 4321.0 |
> showing 50 of 237,179 rows — these rows as CSV