PREVIEW / etf_1min / 2020-11-12
file: by_date/etf_1min/2020/2020-11-12.parquet size: 4.0 MB rows: 210,528
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-11-12 04:00:00 | SPY | ETF | 354.7 | 354.7 | 354.57 | 354.67 | 2619.0 |
| 2020-11-12 04:01:00 | SPY | ETF | 354.67 | 354.84 | 354.67 | 354.84 | 1523.0 |
| 2020-11-12 04:03:00 | SPY | ETF | 354.96 | 354.97 | 354.88 | 354.88 | 2804.0 |
| 2020-11-12 04:05:00 | SPY | ETF | 354.93 | 354.93 | 354.79 | 354.79 | 6503.0 |
| 2020-11-12 04:07:00 | SPY | ETF | 354.73 | 354.81 | 354.72 | 354.81 | 4234.0 |
| 2020-11-12 04:08:00 | SPY | ETF | 354.99 | 355.02 | 354.99 | 355.02 | 1480.0 |
| 2020-11-12 04:09:00 | SPY | ETF | 354.99 | 355.01 | 354.99 | 355.01 | 1570.0 |
| 2020-11-12 04:10:00 | SPY | ETF | 355.04 | 355.04 | 355.04 | 355.04 | 145.0 |
| 2020-11-12 04:11:00 | SPY | ETF | 355.04 | 355.04 | 354.98 | 354.98 | 1268.0 |
| 2020-11-12 04:15:00 | SPY | ETF | 354.88 | 354.95 | 354.88 | 354.95 | 1400.0 |
| 2020-11-12 04:17:00 | SPY | ETF | 354.87 | 354.87 | 354.87 | 354.87 | 500.0 |
| 2020-11-12 04:18:00 | SPY | ETF | 354.99 | 355.02 | 354.99 | 355.02 | 1165.0 |
| 2020-11-12 04:19:00 | SPY | ETF | 354.99 | 354.99 | 354.99 | 354.99 | 150.0 |
| 2020-11-12 04:20:00 | SPY | ETF | 354.97 | 354.97 | 354.97 | 354.97 | 750.0 |
| 2020-11-12 04:22:00 | SPY | ETF | 355.0 | 355.0 | 355.0 | 355.0 | 800.0 |
| 2020-11-12 04:23:00 | SPY | ETF | 355.06 | 355.06 | 354.98 | 355.0 | 1200.0 |
| 2020-11-12 04:24:00 | SPY | ETF | 355.04 | 355.04 | 355.04 | 355.04 | 650.0 |
| 2020-11-12 04:25:00 | SPY | ETF | 355.17 | 355.31 | 355.17 | 355.31 | 1670.0 |
| 2020-11-12 04:26:00 | SPY | ETF | 355.21 | 355.21 | 355.21 | 355.21 | 510.0 |
| 2020-11-12 04:28:00 | SPY | ETF | 355.18 | 355.21 | 355.11 | 355.11 | 3006.0 |
| 2020-11-12 04:29:00 | SPY | ETF | 355.16 | 355.16 | 355.16 | 355.16 | 100.0 |
| 2020-11-12 04:30:00 | SPY | ETF | 355.29 | 355.29 | 355.29 | 355.29 | 537.0 |
| 2020-11-12 04:31:00 | SPY | ETF | 355.33 | 355.5 | 355.33 | 355.48 | 5010.0 |
| 2020-11-12 04:32:00 | SPY | ETF | 355.49 | 355.49 | 355.49 | 355.49 | 100.0 |
| 2020-11-12 04:33:00 | SPY | ETF | 355.47 | 355.47 | 355.47 | 355.47 | 1000.0 |
| 2020-11-12 04:40:00 | SPY | ETF | 355.51 | 355.51 | 355.5 | 355.5 | 272.0 |
| 2020-11-12 04:42:00 | SPY | ETF | 355.41 | 355.41 | 355.41 | 355.41 | 100.0 |
| 2020-11-12 04:43:00 | SPY | ETF | 355.5 | 355.5 | 355.5 | 355.5 | 1145.0 |
| 2020-11-12 04:46:00 | SPY | ETF | 355.7 | 355.7 | 355.7 | 355.7 | 155.0 |
| 2020-11-12 04:47:00 | SPY | ETF | 355.74 | 355.76 | 355.74 | 355.76 | 2205.0 |
| 2020-11-12 04:48:00 | SPY | ETF | 355.86 | 356.07 | 355.85 | 356.07 | 2542.0 |
| 2020-11-12 04:49:00 | SPY | ETF | 356.01 | 356.01 | 356.01 | 356.01 | 150.0 |
| 2020-11-12 04:50:00 | SPY | ETF | 356.06 | 356.06 | 356.06 | 356.06 | 225.0 |
| 2020-11-12 04:52:00 | SPY | ETF | 355.86 | 355.86 | 355.86 | 355.86 | 265.0 |
| 2020-11-12 04:53:00 | SPY | ETF | 355.84 | 355.84 | 355.84 | 355.84 | 421.0 |
| 2020-11-12 04:54:00 | SPY | ETF | 355.94 | 355.94 | 355.94 | 355.94 | 515.0 |
| 2020-11-12 04:57:00 | SPY | ETF | 355.95 | 356.0 | 355.95 | 356.0 | 300.0 |
| 2020-11-12 04:58:00 | SPY | ETF | 356.17 | 356.2 | 356.16 | 356.18 | 5784.0 |
| 2020-11-12 04:59:00 | SPY | ETF | 356.23 | 356.26 | 356.04 | 356.06 | 1822.0 |
| 2020-11-12 05:00:00 | SPY | ETF | 356.16 | 356.16 | 356.08 | 356.08 | 339.0 |
| 2020-11-12 05:01:00 | SPY | ETF | 356.2 | 356.21 | 356.2 | 356.21 | 586.0 |
| 2020-11-12 05:03:00 | SPY | ETF | 356.18 | 356.18 | 356.09 | 356.09 | 931.0 |
| 2020-11-12 05:06:00 | SPY | ETF | 356.08 | 356.11 | 356.06 | 356.06 | 514.0 |
| 2020-11-12 05:09:00 | SPY | ETF | 356.18 | 356.18 | 356.18 | 356.18 | 209.0 |
| 2020-11-12 05:13:00 | SPY | ETF | 356.05 | 356.05 | 356.05 | 356.05 | 321.0 |
| 2020-11-12 05:14:00 | SPY | ETF | 356.06 | 356.06 | 356.06 | 356.06 | 150.0 |
| 2020-11-12 05:16:00 | SPY | ETF | 356.23 | 356.23 | 356.23 | 356.23 | 1080.0 |
| 2020-11-12 05:17:00 | SPY | ETF | 356.19 | 356.39 | 356.19 | 356.31 | 3827.0 |
| 2020-11-12 05:18:00 | SPY | ETF | 356.36 | 356.41 | 356.36 | 356.41 | 500.0 |
| 2020-11-12 05:19:00 | SPY | ETF | 356.41 | 356.41 | 356.41 | 356.41 | 584.0 |
> showing 50 of 210,528 rows — these rows as CSV