PREVIEW / etf_1min / 2020-03-12
file: by_date/etf_1min/2020/2020-03-12.parquet size: 5.6 MB rows: 285,964
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-12 04:00:00 | SPY | ETF | 263.95 | 263.96 | 263.03 | 263.33 | 28661.0 |
| 2020-03-12 04:01:00 | SPY | ETF | 263.35 | 263.65 | 263.2 | 263.65 | 7555.0 |
| 2020-03-12 04:02:00 | SPY | ETF | 263.79 | 264.02 | 263.73 | 264.02 | 3584.0 |
| 2020-03-12 04:03:00 | SPY | ETF | 264.14 | 264.22 | 263.92 | 264.04 | 4475.0 |
| 2020-03-12 04:04:00 | SPY | ETF | 264.02 | 264.02 | 263.77 | 263.98 | 3420.0 |
| 2020-03-12 04:05:00 | SPY | ETF | 264.02 | 264.67 | 264.02 | 264.65 | 6145.0 |
| 2020-03-12 04:06:00 | SPY | ETF | 264.65 | 265.0 | 264.64 | 265.0 | 3654.0 |
| 2020-03-12 04:07:00 | SPY | ETF | 264.81 | 264.81 | 264.29 | 264.41 | 3091.0 |
| 2020-03-12 04:08:00 | SPY | ETF | 264.25 | 264.3 | 264.03 | 264.03 | 3245.0 |
| 2020-03-12 04:09:00 | SPY | ETF | 263.92 | 263.94 | 263.58 | 263.58 | 8587.0 |
| 2020-03-12 04:10:00 | SPY | ETF | 263.5 | 263.57 | 263.36 | 263.49 | 10176.0 |
| 2020-03-12 04:11:00 | SPY | ETF | 263.74 | 263.91 | 263.74 | 263.86 | 1620.0 |
| 2020-03-12 04:12:00 | SPY | ETF | 264.01 | 264.01 | 263.56 | 263.56 | 1851.0 |
| 2020-03-12 04:13:00 | SPY | ETF | 263.49 | 263.72 | 263.36 | 263.39 | 13256.0 |
| 2020-03-12 04:14:00 | SPY | ETF | 263.44 | 263.74 | 263.44 | 263.74 | 1781.0 |
| 2020-03-12 04:15:00 | SPY | ETF | 263.9 | 263.9 | 263.74 | 263.76 | 2025.0 |
| 2020-03-12 04:16:00 | SPY | ETF | 263.78 | 264.1 | 263.48 | 264.1 | 4256.0 |
| 2020-03-12 04:17:00 | SPY | ETF | 264.2 | 264.46 | 264.2 | 264.46 | 1724.0 |
| 2020-03-12 04:18:00 | SPY | ETF | 264.41 | 264.88 | 264.41 | 264.68 | 6475.0 |
| 2020-03-12 04:19:00 | SPY | ETF | 264.44 | 264.44 | 264.3 | 264.37 | 2018.0 |
| 2020-03-12 04:20:00 | SPY | ETF | 264.26 | 264.26 | 264.16 | 264.25 | 1636.0 |
| 2020-03-12 04:21:00 | SPY | ETF | 264.21 | 264.24 | 263.82 | 263.9 | 1939.0 |
| 2020-03-12 04:22:00 | SPY | ETF | 263.86 | 264.08 | 263.86 | 264.01 | 1365.0 |
| 2020-03-12 04:23:00 | SPY | ETF | 264.05 | 264.05 | 263.8 | 264.01 | 1653.0 |
| 2020-03-12 04:24:00 | SPY | ETF | 264.01 | 264.01 | 263.83 | 263.84 | 1592.0 |
| 2020-03-12 04:25:00 | SPY | ETF | 263.71 | 263.71 | 263.49 | 263.49 | 955.0 |
| 2020-03-12 04:26:00 | SPY | ETF | 263.43 | 263.43 | 263.2 | 263.26 | 2750.0 |
| 2020-03-12 04:27:00 | SPY | ETF | 263.23 | 263.23 | 262.9 | 263.1 | 6273.0 |
| 2020-03-12 04:28:00 | SPY | ETF | 263.14 | 263.14 | 263.04 | 263.06 | 2323.0 |
| 2020-03-12 04:29:00 | SPY | ETF | 263.01 | 263.01 | 262.75 | 262.75 | 2098.0 |
| 2020-03-12 04:30:00 | SPY | ETF | 262.74 | 263.06 | 262.74 | 263.04 | 2207.0 |
| 2020-03-12 04:31:00 | SPY | ETF | 263.18 | 263.18 | 263.03 | 263.09 | 2560.0 |
| 2020-03-12 04:32:00 | SPY | ETF | 262.86 | 262.86 | 262.74 | 262.74 | 1048.0 |
| 2020-03-12 04:33:00 | SPY | ETF | 262.54 | 263.0 | 262.52 | 262.8 | 1172.0 |
| 2020-03-12 04:34:00 | SPY | ETF | 262.78 | 262.78 | 262.78 | 262.78 | 424.0 |
| 2020-03-12 04:35:00 | SPY | ETF | 262.5 | 262.5 | 262.35 | 262.35 | 788.0 |
| 2020-03-12 04:36:00 | SPY | ETF | 262.47 | 262.47 | 261.9 | 261.91 | 5829.0 |
| 2020-03-12 04:37:00 | SPY | ETF | 261.87 | 262.16 | 261.75 | 262.12 | 7247.0 |
| 2020-03-12 04:38:00 | SPY | ETF | 262.06 | 262.06 | 261.86 | 261.94 | 13160.0 |
| 2020-03-12 04:40:00 | SPY | ETF | 262.05 | 262.26 | 261.81 | 261.81 | 2271.0 |
| 2020-03-12 04:41:00 | SPY | ETF | 261.97 | 262.1 | 261.91 | 262.1 | 1730.0 |
| 2020-03-12 04:42:00 | SPY | ETF | 262.1 | 262.28 | 261.73 | 261.73 | 3737.0 |
| 2020-03-12 04:43:00 | SPY | ETF | 261.66 | 261.78 | 261.52 | 261.77 | 9890.0 |
| 2020-03-12 04:44:00 | SPY | ETF | 261.84 | 262.14 | 261.8 | 261.8 | 2970.0 |
| 2020-03-12 04:45:00 | SPY | ETF | 261.55 | 261.55 | 261.33 | 261.35 | 3007.0 |
| 2020-03-12 04:46:00 | SPY | ETF | 261.37 | 261.42 | 261.11 | 261.11 | 3062.0 |
| 2020-03-12 04:47:00 | SPY | ETF | 261.11 | 261.21 | 261.1 | 261.14 | 6826.0 |
| 2020-03-12 04:48:00 | SPY | ETF | 261.2 | 261.42 | 261.12 | 261.42 | 1294.0 |
| 2020-03-12 04:49:00 | SPY | ETF | 261.3 | 261.42 | 261.1 | 261.1 | 4095.0 |
| 2020-03-12 04:50:00 | SPY | ETF | 261.29 | 261.38 | 261.06 | 261.06 | 3700.0 |
> showing 50 of 285,964 rows — these rows as CSV