PREVIEW / etf_5min / 2021-04-15
file: by_date/etf_5min/2021/2021-04-15.parquet size: 1.8 MB rows: 83,939
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-15 04:00:00 | SPY | ETF | 413.19 | 413.28 | 413.16 | 413.26 | 6971.0 |
| 2021-04-15 04:05:00 | SPY | ETF | 413.25 | 413.25 | 413.25 | 413.25 | 100.0 |
| 2021-04-15 04:15:00 | SPY | ETF | 413.26 | 413.32 | 413.26 | 413.31 | 1394.0 |
| 2021-04-15 04:20:00 | SPY | ETF | 413.27 | 413.27 | 413.26 | 413.27 | 600.0 |
| 2021-04-15 04:30:00 | SPY | ETF | 413.12 | 413.24 | 413.11 | 413.24 | 1700.0 |
| 2021-04-15 04:35:00 | SPY | ETF | 413.24 | 413.33 | 413.24 | 413.33 | 200.0 |
| 2021-04-15 04:40:00 | SPY | ETF | 413.31 | 413.34 | 413.29 | 413.29 | 4189.0 |
| 2021-04-15 04:45:00 | SPY | ETF | 413.32 | 413.32 | 413.32 | 413.32 | 100.0 |
| 2021-04-15 04:50:00 | SPY | ETF | 413.32 | 413.32 | 413.3 | 413.3 | 400.0 |
| 2021-04-15 04:55:00 | SPY | ETF | 413.31 | 413.31 | 413.29 | 413.31 | 2600.0 |
| 2021-04-15 05:00:00 | SPY | ETF | 413.31 | 413.33 | 413.26 | 413.33 | 3699.0 |
| 2021-04-15 05:05:00 | SPY | ETF | 413.37 | 413.4 | 413.29 | 413.29 | 1400.0 |
| 2021-04-15 05:10:00 | SPY | ETF | 413.24 | 413.28 | 413.21 | 413.22 | 7700.0 |
| 2021-04-15 05:15:00 | SPY | ETF | 413.29 | 413.29 | 413.29 | 413.29 | 100.0 |
| 2021-04-15 05:20:00 | SPY | ETF | 413.32 | 413.39 | 413.32 | 413.39 | 300.0 |
| 2021-04-15 05:25:00 | SPY | ETF | 413.35 | 413.35 | 413.32 | 413.32 | 798.0 |
| 2021-04-15 05:30:00 | SPY | ETF | 413.31 | 413.31 | 413.28 | 413.28 | 1583.0 |
| 2021-04-15 05:40:00 | SPY | ETF | 413.29 | 413.29 | 413.29 | 413.29 | 100.0 |
| 2021-04-15 05:45:00 | SPY | ETF | 413.25 | 413.25 | 413.13 | 413.13 | 2900.0 |
| 2021-04-15 05:50:00 | SPY | ETF | 413.14 | 413.14 | 413.14 | 413.14 | 100.0 |
| 2021-04-15 06:05:00 | SPY | ETF | 413.09 | 413.09 | 413.05 | 413.09 | 2600.0 |
| 2021-04-15 06:15:00 | SPY | ETF | 413.19 | 413.19 | 413.19 | 413.19 | 400.0 |
| 2021-04-15 06:25:00 | SPY | ETF | 413.26 | 413.28 | 413.26 | 413.27 | 1000.0 |
| 2021-04-15 06:35:00 | SPY | ETF | 413.19 | 413.19 | 413.19 | 413.19 | 499.0 |
| 2021-04-15 06:40:00 | SPY | ETF | 413.24 | 413.24 | 413.24 | 413.24 | 500.0 |
| 2021-04-15 06:50:00 | SPY | ETF | 413.36 | 413.38 | 413.36 | 413.38 | 1400.0 |
| 2021-04-15 06:55:00 | SPY | ETF | 413.36 | 413.5 | 413.36 | 413.5 | 5750.0 |
| 2021-04-15 07:00:00 | SPY | ETF | 413.44 | 413.46 | 413.34 | 413.34 | 25354.0 |
| 2021-04-15 07:05:00 | SPY | ETF | 413.33 | 413.33 | 413.25 | 413.32 | 7688.0 |
| 2021-04-15 07:10:00 | SPY | ETF | 413.29 | 413.29 | 413.2 | 413.2 | 2700.0 |
| 2021-04-15 07:15:00 | SPY | ETF | 413.2 | 413.2 | 413.12 | 413.18 | 4933.0 |
| 2021-04-15 07:20:00 | SPY | ETF | 413.2 | 413.23 | 413.19 | 413.19 | 3390.0 |
| 2021-04-15 07:25:00 | SPY | ETF | 413.19 | 413.19 | 413.13 | 413.19 | 5904.0 |
| 2021-04-15 07:30:00 | SPY | ETF | 413.19 | 413.22 | 413.12 | 413.13 | 36601.0 |
| 2021-04-15 07:35:00 | SPY | ETF | 413.13 | 413.15 | 413.08 | 413.12 | 35009.0 |
| 2021-04-15 07:40:00 | SPY | ETF | 413.13 | 413.39 | 413.13 | 413.39 | 11484.0 |
| 2021-04-15 07:45:00 | SPY | ETF | 413.35 | 413.58 | 413.3 | 413.58 | 32678.0 |
| 2021-04-15 07:50:00 | SPY | ETF | 413.58 | 413.64 | 413.49 | 413.52 | 36186.0 |
| 2021-04-15 07:55:00 | SPY | ETF | 413.58 | 413.67 | 413.55 | 413.67 | 13182.0 |
| 2021-04-15 08:00:00 | SPY | ETF | 413.4001 | 413.69 | 412.24 | 413.62 | 40859.0 |
| 2021-04-15 08:05:00 | SPY | ETF | 413.61 | 413.71 | 413.6 | 413.7 | 79059.0 |
| 2021-04-15 08:10:00 | SPY | ETF | 413.68 | 413.78 | 413.66 | 413.77 | 15290.0 |
| 2021-04-15 08:15:00 | SPY | ETF | 413.76 | 413.96 | 413.76 | 413.88 | 21908.0 |
| 2021-04-15 08:20:00 | SPY | ETF | 413.88 | 413.88 | 413.72 | 413.78 | 4710.0 |
| 2021-04-15 08:25:00 | SPY | ETF | 413.78 | 413.81 | 413.73 | 413.73 | 14720.0 |
| 2021-04-15 08:30:00 | SPY | ETF | 413.88 | 414.12 | 413.77 | 414.03 | 123227.0 |
| 2021-04-15 08:35:00 | SPY | ETF | 414.03 | 414.07 | 413.74 | 413.86 | 40836.0 |
| 2021-04-15 08:40:00 | SPY | ETF | 413.85 | 413.88 | 413.76 | 413.84 | 21628.0 |
| 2021-04-15 08:45:00 | SPY | ETF | 413.84 | 413.9 | 413.7304 | 413.77 | 14875.0 |
| 2021-04-15 08:50:00 | SPY | ETF | 413.79 | 413.81 | 413.69 | 413.77 | 17411.0 |
> showing 50 of 83,939 rows — these rows as CSV