PREVIEW / etf_1min / 2020-07-30
file: by_date/etf_1min/2020/2020-07-30.parquet size: 3.7 MB rows: 210,621
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-07-30 04:00:00 | SPY | ETF | 323.0 | 323.0 | 322.59 | 322.8 | 13523.0 |
| 2020-07-30 04:01:00 | SPY | ETF | 322.75 | 322.81 | 322.75 | 322.81 | 402.0 |
| 2020-07-30 04:02:00 | SPY | ETF | 322.8 | 322.86 | 322.8 | 322.84 | 4004.0 |
| 2020-07-30 04:03:00 | SPY | ETF | 322.9 | 322.9 | 322.89 | 322.89 | 1392.0 |
| 2020-07-30 04:04:00 | SPY | ETF | 322.9 | 322.92 | 322.9 | 322.92 | 1232.0 |
| 2020-07-30 04:05:00 | SPY | ETF | 322.99 | 322.99 | 322.84 | 322.87 | 3250.0 |
| 2020-07-30 04:06:00 | SPY | ETF | 322.74 | 322.74 | 322.74 | 322.74 | 216.0 |
| 2020-07-30 04:07:00 | SPY | ETF | 322.77 | 322.77 | 322.77 | 322.77 | 1120.0 |
| 2020-07-30 04:08:00 | SPY | ETF | 322.86 | 322.86 | 322.7 | 322.7 | 2091.0 |
| 2020-07-30 04:09:00 | SPY | ETF | 322.58 | 322.69 | 322.58 | 322.69 | 5800.0 |
| 2020-07-30 04:10:00 | SPY | ETF | 322.66 | 322.66 | 322.66 | 322.66 | 505.0 |
| 2020-07-30 04:11:00 | SPY | ETF | 322.64 | 322.64 | 322.64 | 322.64 | 160.0 |
| 2020-07-30 04:12:00 | SPY | ETF | 322.64 | 322.66 | 322.62 | 322.66 | 700.0 |
| 2020-07-30 04:13:00 | SPY | ETF | 322.61 | 322.63 | 322.61 | 322.63 | 449.0 |
| 2020-07-30 04:20:00 | SPY | ETF | 322.74 | 322.74 | 322.74 | 322.74 | 1068.0 |
| 2020-07-30 04:21:00 | SPY | ETF | 322.71 | 322.71 | 322.71 | 322.71 | 600.0 |
| 2020-07-30 04:22:00 | SPY | ETF | 322.69 | 322.69 | 322.67 | 322.67 | 205.0 |
| 2020-07-30 04:23:00 | SPY | ETF | 322.66 | 322.66 | 322.66 | 322.66 | 1000.0 |
| 2020-07-30 04:25:00 | SPY | ETF | 322.62 | 322.62 | 322.62 | 322.62 | 100.0 |
| 2020-07-30 04:26:00 | SPY | ETF | 322.59 | 322.6 | 322.59 | 322.6 | 1314.0 |
| 2020-07-30 04:27:00 | SPY | ETF | 322.52 | 322.52 | 322.32 | 322.32 | 3230.0 |
| 2020-07-30 04:29:00 | SPY | ETF | 322.39 | 322.39 | 322.39 | 322.39 | 100.0 |
| 2020-07-30 04:30:00 | SPY | ETF | 322.39 | 322.45 | 322.34 | 322.44 | 2288.0 |
| 2020-07-30 04:31:00 | SPY | ETF | 322.37 | 322.37 | 322.37 | 322.37 | 5063.0 |
| 2020-07-30 04:33:00 | SPY | ETF | 322.49 | 322.49 | 322.49 | 322.49 | 133.0 |
| 2020-07-30 04:34:00 | SPY | ETF | 322.34 | 322.34 | 322.34 | 322.34 | 1050.0 |
| 2020-07-30 04:37:00 | SPY | ETF | 322.44 | 322.47 | 322.4 | 322.47 | 2915.0 |
| 2020-07-30 04:38:00 | SPY | ETF | 322.47 | 322.47 | 322.42 | 322.42 | 2387.0 |
| 2020-07-30 04:39:00 | SPY | ETF | 322.4 | 322.4 | 322.32 | 322.32 | 1631.0 |
| 2020-07-30 04:40:00 | SPY | ETF | 322.27 | 322.3 | 322.26 | 322.3 | 863.0 |
| 2020-07-30 04:41:00 | SPY | ETF | 322.26 | 322.26 | 322.2 | 322.2 | 1167.0 |
| 2020-07-30 04:42:00 | SPY | ETF | 322.25 | 322.25 | 322.25 | 322.25 | 1139.0 |
| 2020-07-30 04:43:00 | SPY | ETF | 322.24 | 322.24 | 322.24 | 322.24 | 116.0 |
| 2020-07-30 04:44:00 | SPY | ETF | 322.24 | 322.24 | 322.24 | 322.24 | 203.0 |
| 2020-07-30 04:45:00 | SPY | ETF | 322.16 | 322.28 | 322.16 | 322.28 | 257.0 |
| 2020-07-30 04:50:00 | SPY | ETF | 322.24 | 322.24 | 322.24 | 322.24 | 1065.0 |
| 2020-07-30 04:53:00 | SPY | ETF | 322.18 | 322.18 | 322.18 | 322.18 | 140.0 |
| 2020-07-30 04:55:00 | SPY | ETF | 322.16 | 322.16 | 322.01 | 322.01 | 4058.0 |
| 2020-07-30 04:56:00 | SPY | ETF | 322.03 | 322.03 | 321.86 | 321.86 | 1396.0 |
| 2020-07-30 04:57:00 | SPY | ETF | 321.81 | 321.81 | 321.79 | 321.8 | 2041.0 |
| 2020-07-30 04:58:00 | SPY | ETF | 321.76 | 321.76 | 321.71 | 321.71 | 466.0 |
| 2020-07-30 05:00:00 | SPY | ETF | 321.66 | 321.68 | 321.65 | 321.65 | 856.0 |
| 2020-07-30 05:01:00 | SPY | ETF | 321.83 | 321.83 | 321.83 | 321.83 | 510.0 |
| 2020-07-30 05:03:00 | SPY | ETF | 321.61 | 322.0 | 321.61 | 321.98 | 2982.0 |
| 2020-07-30 05:04:00 | SPY | ETF | 321.88 | 321.93 | 321.82 | 321.82 | 1930.0 |
| 2020-07-30 05:05:00 | SPY | ETF | 321.85 | 321.88 | 321.85 | 321.88 | 794.0 |
| 2020-07-30 05:06:00 | SPY | ETF | 321.98 | 321.99 | 321.98 | 321.99 | 950.0 |
| 2020-07-30 05:07:00 | SPY | ETF | 322.05 | 322.06 | 321.98 | 321.98 | 2680.0 |
| 2020-07-30 05:09:00 | SPY | ETF | 322.06 | 322.06 | 322.06 | 322.06 | 1150.0 |
| 2020-07-30 05:10:00 | SPY | ETF | 322.08 | 322.08 | 322.06 | 322.06 | 2858.0 |
> showing 50 of 210,621 rows — these rows as CSV