PREVIEW / etf_5min / 2020-04-08
file: by_date/etf_5min/2020/2020-04-08.parquet size: 1.7 MB rows: 78,349
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-04-08 04:00:00 | SPY | ETF | 265.8 | 265.88 | 265.02 | 265.32 | 24865.0 |
| 2020-04-08 04:05:00 | SPY | ETF | 265.37 | 265.51 | 265.17 | 265.18 | 21116.0 |
| 2020-04-08 04:10:00 | SPY | ETF | 265.17 | 265.18 | 264.8 | 265.02 | 27041.0 |
| 2020-04-08 04:15:00 | SPY | ETF | 264.84 | 264.84 | 264.33 | 264.52 | 10686.0 |
| 2020-04-08 04:20:00 | SPY | ETF | 264.5 | 264.51 | 264.24 | 264.45 | 4421.0 |
| 2020-04-08 04:25:00 | SPY | ETF | 264.46 | 264.51 | 263.85 | 263.85 | 5732.0 |
| 2020-04-08 04:30:00 | SPY | ETF | 263.71 | 263.71 | 263.28 | 263.5 | 10457.0 |
| 2020-04-08 04:35:00 | SPY | ETF | 263.5 | 263.5 | 263.03 | 263.38 | 11939.0 |
| 2020-04-08 04:40:00 | SPY | ETF | 263.51 | 263.78 | 263.44 | 263.74 | 8813.0 |
| 2020-04-08 04:45:00 | SPY | ETF | 263.67 | 264.09 | 263.67 | 263.94 | 5510.0 |
| 2020-04-08 04:50:00 | SPY | ETF | 263.87 | 264.2 | 263.68 | 264.2 | 7993.0 |
| 2020-04-08 04:55:00 | SPY | ETF | 264.26 | 264.26 | 263.84 | 264.12 | 4057.0 |
| 2020-04-08 05:00:00 | SPY | ETF | 264.1 | 264.24 | 263.9 | 264.24 | 2292.0 |
| 2020-04-08 05:05:00 | SPY | ETF | 264.27 | 264.45 | 264.18 | 264.18 | 4590.0 |
| 2020-04-08 05:10:00 | SPY | ETF | 264.08 | 264.1 | 263.94 | 263.94 | 2472.0 |
| 2020-04-08 05:15:00 | SPY | ETF | 263.83 | 263.95 | 263.62 | 263.95 | 8272.0 |
| 2020-04-08 05:20:00 | SPY | ETF | 264.06 | 264.15 | 263.7 | 263.7 | 5768.0 |
| 2020-04-08 05:25:00 | SPY | ETF | 263.7 | 264.09 | 263.61 | 264.06 | 8241.0 |
| 2020-04-08 05:30:00 | SPY | ETF | 264.34 | 264.38 | 264.0 | 264.0 | 7172.0 |
| 2020-04-08 05:35:00 | SPY | ETF | 263.9 | 264.32 | 263.9 | 264.32 | 11751.0 |
| 2020-04-08 05:40:00 | SPY | ETF | 264.33 | 264.38 | 264.13 | 264.31 | 2387.0 |
| 2020-04-08 05:45:00 | SPY | ETF | 264.42 | 264.78 | 264.42 | 264.62 | 5831.0 |
| 2020-04-08 05:50:00 | SPY | ETF | 264.44 | 264.44 | 263.51 | 263.51 | 24660.0 |
| 2020-04-08 05:55:00 | SPY | ETF | 263.55 | 264.06 | 263.55 | 264.03 | 5350.0 |
| 2020-04-08 06:00:00 | SPY | ETF | 264.04 | 264.63 | 264.04 | 264.26 | 8268.0 |
| 2020-04-08 06:05:00 | SPY | ETF | 264.24 | 264.62 | 264.24 | 264.43 | 8990.0 |
| 2020-04-08 06:10:00 | SPY | ETF | 264.3 | 264.3 | 263.85 | 263.95 | 5919.0 |
| 2020-04-08 06:15:00 | SPY | ETF | 264.02 | 264.56 | 264.02 | 264.47 | 7937.0 |
| 2020-04-08 06:20:00 | SPY | ETF | 264.22 | 265.02 | 264.22 | 264.7 | 14589.0 |
| 2020-04-08 06:25:00 | SPY | ETF | 264.8 | 265.1 | 264.8 | 265.1 | 8705.0 |
| 2020-04-08 06:30:00 | SPY | ETF | 265.0 | 265.49 | 265.0 | 265.35 | 19068.0 |
| 2020-04-08 06:35:00 | SPY | ETF | 265.35 | 265.51 | 265.1 | 265.23 | 10070.0 |
| 2020-04-08 06:40:00 | SPY | ETF | 265.41 | 265.41 | 264.97 | 265.13 | 11042.0 |
| 2020-04-08 06:45:00 | SPY | ETF | 265.22 | 265.26 | 264.94 | 264.94 | 17002.0 |
| 2020-04-08 06:50:00 | SPY | ETF | 264.84 | 265.15 | 264.84 | 265.14 | 5532.0 |
| 2020-04-08 06:55:00 | SPY | ETF | 265.35 | 265.87 | 265.21 | 265.73 | 22766.0 |
| 2020-04-08 07:00:00 | SPY | ETF | 265.71 | 265.84 | 265.39 | 265.6 | 51367.0 |
| 2020-04-08 07:05:00 | SPY | ETF | 265.61 | 265.92 | 265.48 | 265.78 | 48010.0 |
| 2020-04-08 07:10:00 | SPY | ETF | 265.85 | 266.53 | 265.71 | 266.43 | 36994.0 |
| 2020-04-08 07:15:00 | SPY | ETF | 266.42 | 266.65 | 266.25 | 266.58 | 28192.0 |
| 2020-04-08 07:20:00 | SPY | ETF | 266.54 | 266.96 | 266.46 | 266.73 | 43881.0 |
| 2020-04-08 07:25:00 | SPY | ETF | 266.7 | 266.74 | 266.12 | 266.32 | 56186.0 |
| 2020-04-08 07:30:00 | SPY | ETF | 266.28 | 266.28 | 265.77 | 265.9 | 67527.0 |
| 2020-04-08 07:35:00 | SPY | ETF | 266.0 | 266.27 | 265.83 | 266.17 | 22140.0 |
| 2020-04-08 07:40:00 | SPY | ETF | 266.17 | 266.25 | 265.59 | 265.67 | 38429.0 |
| 2020-04-08 07:45:00 | SPY | ETF | 265.7 | 265.93 | 265.5 | 265.84 | 67948.0 |
| 2020-04-08 07:50:00 | SPY | ETF | 265.82 | 266.39 | 265.8 | 266.2 | 48680.0 |
| 2020-04-08 07:55:00 | SPY | ETF | 266.16 | 266.67 | 266.16 | 266.66 | 63354.0 |
| 2020-04-08 08:00:00 | SPY | ETF | 266.6 | 267.61 | 263.34 | 267.1 | 216977.0 |
| 2020-04-08 08:05:00 | SPY | ETF | 267.09 | 267.66 | 267.08 | 267.43 | 186752.0 |
> showing 50 of 78,349 rows — these rows as CSV