PREVIEW / etf_5min / 2020-03-26
file: by_date/etf_5min/2020/2020-03-26.parquet size: 2.0 MB rows: 88,554
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-26 04:00:00 | SPY | ETF | 242.23 | 243.06 | 241.12 | 242.87 | 46135.0 |
| 2020-03-26 04:05:00 | SPY | ETF | 242.99 | 243.85 | 242.99 | 243.35 | 16028.0 |
| 2020-03-26 04:10:00 | SPY | ETF | 243.14 | 243.34 | 242.18 | 242.19 | 55633.0 |
| 2020-03-26 04:15:00 | SPY | ETF | 242.48 | 242.67 | 241.71 | 241.78 | 33334.0 |
| 2020-03-26 04:20:00 | SPY | ETF | 241.83 | 242.41 | 241.52 | 241.86 | 19908.0 |
| 2020-03-26 04:25:00 | SPY | ETF | 242.0 | 242.5 | 241.54 | 241.88 | 15500.0 |
| 2020-03-26 04:30:00 | SPY | ETF | 241.89 | 242.64 | 241.87 | 242.64 | 23659.0 |
| 2020-03-26 04:35:00 | SPY | ETF | 242.72 | 242.72 | 241.91 | 241.91 | 6330.0 |
| 2020-03-26 04:40:00 | SPY | ETF | 241.76 | 242.0 | 241.43 | 241.77 | 9155.0 |
| 2020-03-26 04:45:00 | SPY | ETF | 241.66 | 242.41 | 241.66 | 242.41 | 25682.0 |
| 2020-03-26 04:50:00 | SPY | ETF | 242.33 | 242.38 | 241.76 | 242.22 | 10910.0 |
| 2020-03-26 04:55:00 | SPY | ETF | 242.03 | 242.77 | 241.81 | 242.77 | 19432.0 |
| 2020-03-26 05:00:00 | SPY | ETF | 242.85 | 243.68 | 242.65 | 243.61 | 33016.0 |
| 2020-03-26 05:05:00 | SPY | ETF | 243.64 | 243.73 | 243.0 | 243.03 | 10319.0 |
| 2020-03-26 05:10:00 | SPY | ETF | 242.96 | 243.25 | 242.19 | 242.19 | 50546.0 |
| 2020-03-26 05:15:00 | SPY | ETF | 242.0 | 242.32 | 242.0 | 242.3 | 6780.0 |
| 2020-03-26 05:20:00 | SPY | ETF | 242.15 | 242.63 | 241.96 | 242.63 | 5269.0 |
| 2020-03-26 05:25:00 | SPY | ETF | 242.71 | 242.93 | 242.38 | 242.38 | 4875.0 |
| 2020-03-26 05:30:00 | SPY | ETF | 242.25 | 242.73 | 242.25 | 242.47 | 1515.0 |
| 2020-03-26 05:35:00 | SPY | ETF | 242.5 | 242.5 | 242.03 | 242.41 | 58337.0 |
| 2020-03-26 05:40:00 | SPY | ETF | 242.61 | 243.75 | 242.59 | 242.77 | 87071.0 |
| 2020-03-26 05:45:00 | SPY | ETF | 242.75 | 243.59 | 242.75 | 243.51 | 13088.0 |
| 2020-03-26 05:50:00 | SPY | ETF | 243.6 | 243.64 | 242.82 | 242.82 | 4558.0 |
| 2020-03-26 05:55:00 | SPY | ETF | 242.72 | 243.37 | 242.72 | 243.37 | 12065.0 |
| 2020-03-26 06:00:00 | SPY | ETF | 243.37 | 243.45 | 243.1 | 243.25 | 8477.0 |
| 2020-03-26 06:05:00 | SPY | ETF | 243.2 | 243.67 | 243.2 | 243.55 | 45902.0 |
| 2020-03-26 06:10:00 | SPY | ETF | 243.55 | 243.7 | 243.46 | 243.59 | 49997.0 |
| 2020-03-26 06:15:00 | SPY | ETF | 243.51 | 243.51 | 242.9 | 243.3 | 74151.0 |
| 2020-03-26 06:20:00 | SPY | ETF | 243.38 | 243.54 | 243.27 | 243.42 | 7474.0 |
| 2020-03-26 06:25:00 | SPY | ETF | 243.67 | 244.01 | 243.51 | 244.0 | 6057.0 |
| 2020-03-26 06:30:00 | SPY | ETF | 244.29 | 244.5 | 244.21 | 244.41 | 8379.0 |
| 2020-03-26 06:35:00 | SPY | ETF | 244.78 | 245.19 | 244.74 | 245.1 | 24847.0 |
| 2020-03-26 06:40:00 | SPY | ETF | 245.0 | 245.31 | 244.67 | 244.72 | 46586.0 |
| 2020-03-26 06:45:00 | SPY | ETF | 244.68 | 245.35 | 244.65 | 245.17 | 61191.0 |
| 2020-03-26 06:50:00 | SPY | ETF | 245.19 | 245.22 | 244.61 | 244.7 | 13015.0 |
| 2020-03-26 06:55:00 | SPY | ETF | 244.5 | 244.54 | 244.0 | 244.36 | 61745.0 |
| 2020-03-26 07:00:00 | SPY | ETF | 244.45 | 244.75 | 243.89 | 244.35 | 234565.0 |
| 2020-03-26 07:05:00 | SPY | ETF | 244.24 | 244.37 | 243.89 | 244.2 | 107161.0 |
| 2020-03-26 07:10:00 | SPY | ETF | 244.31 | 244.65 | 244.16 | 244.3 | 188556.0 |
| 2020-03-26 07:15:00 | SPY | ETF | 244.27 | 244.7 | 243.93 | 244.15 | 102013.0 |
| 2020-03-26 07:20:00 | SPY | ETF | 244.3 | 244.7 | 244.26 | 244.4 | 61260.0 |
| 2020-03-26 07:25:00 | SPY | ETF | 244.54 | 244.72 | 243.96 | 243.96 | 74674.0 |
| 2020-03-26 07:30:00 | SPY | ETF | 243.93 | 244.33 | 243.9 | 244.31 | 51686.0 |
| 2020-03-26 07:35:00 | SPY | ETF | 244.21 | 244.33 | 244.15 | 244.3 | 20893.0 |
| 2020-03-26 07:40:00 | SPY | ETF | 244.22 | 244.32 | 243.92 | 243.92 | 111929.0 |
| 2020-03-26 07:45:00 | SPY | ETF | 243.91 | 243.95 | 242.82 | 242.99 | 128480.0 |
| 2020-03-26 07:50:00 | SPY | ETF | 242.98 | 242.98 | 242.11 | 242.64 | 165201.0 |
| 2020-03-26 07:55:00 | SPY | ETF | 242.65 | 242.9 | 242.3 | 242.3 | 237663.0 |
| 2020-03-26 08:00:00 | SPY | ETF | 242.41 | 246.07 | 241.55 | 242.0 | 307855.0 |
| 2020-03-26 08:05:00 | SPY | ETF | 242.0 | 242.15 | 241.61 | 241.61 | 253542.0 |
> showing 50 of 88,554 rows — these rows as CSV