PREVIEW / etf_5min / 2020-11-10
file: by_date/etf_5min/2020/2020-11-10.parquet size: 1.8 MB rows: 81,912
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-10 04:00:00 | SPY | ETF | 354.42 | 354.81 | 354.35 | 354.8 | 15238.0 |
| 2020-11-10 04:05:00 | SPY | ETF | 354.63 | 354.73 | 354.28 | 354.73 | 4458.0 |
| 2020-11-10 04:10:00 | SPY | ETF | 354.73 | 355.16 | 354.73 | 355.0 | 12962.0 |
| 2020-11-10 04:15:00 | SPY | ETF | 355.0 | 355.2 | 354.88 | 355.0 | 29515.0 |
| 2020-11-10 04:20:00 | SPY | ETF | 355.0 | 355.12 | 354.64 | 355.08 | 25347.0 |
| 2020-11-10 04:25:00 | SPY | ETF | 355.11 | 355.35 | 354.92 | 355.35 | 3963.0 |
| 2020-11-10 04:30:00 | SPY | ETF | 355.23 | 355.5 | 355.2 | 355.2 | 4165.0 |
| 2020-11-10 04:35:00 | SPY | ETF | 355.19 | 355.45 | 355.16 | 355.44 | 2707.0 |
| 2020-11-10 04:40:00 | SPY | ETF | 355.55 | 355.56 | 354.95 | 354.96 | 8603.0 |
| 2020-11-10 04:45:00 | SPY | ETF | 355.45 | 355.77 | 355.4 | 355.66 | 10583.0 |
| 2020-11-10 04:50:00 | SPY | ETF | 355.75 | 355.77 | 355.32 | 355.52 | 7181.0 |
| 2020-11-10 04:55:00 | SPY | ETF | 355.6 | 355.73 | 355.19 | 355.19 | 5563.0 |
| 2020-11-10 05:00:00 | SPY | ETF | 355.12 | 355.18 | 355.12 | 355.13 | 1214.0 |
| 2020-11-10 05:05:00 | SPY | ETF | 354.81 | 354.81 | 354.3 | 354.35 | 7545.0 |
| 2020-11-10 05:10:00 | SPY | ETF | 354.29 | 354.34 | 353.88 | 353.88 | 3147.0 |
| 2020-11-10 05:15:00 | SPY | ETF | 353.92 | 353.92 | 353.47 | 353.47 | 4028.0 |
| 2020-11-10 05:20:00 | SPY | ETF | 353.41 | 353.44 | 353.13 | 353.13 | 2613.0 |
| 2020-11-10 05:25:00 | SPY | ETF | 353.04 | 353.25 | 352.98 | 353.11 | 38248.0 |
| 2020-11-10 05:30:00 | SPY | ETF | 353.09 | 353.81 | 353.09 | 353.73 | 16181.0 |
| 2020-11-10 05:35:00 | SPY | ETF | 353.61 | 353.74 | 353.4 | 353.4 | 33775.0 |
| 2020-11-10 05:40:00 | SPY | ETF | 353.57 | 353.57 | 352.9 | 352.9 | 12435.0 |
| 2020-11-10 05:45:00 | SPY | ETF | 352.92 | 353.21 | 352.6 | 352.67 | 8811.0 |
| 2020-11-10 05:50:00 | SPY | ETF | 352.59 | 352.67 | 352.4 | 352.55 | 10186.0 |
| 2020-11-10 05:55:00 | SPY | ETF | 352.61 | 352.86 | 352.42 | 352.45 | 41536.0 |
| 2020-11-10 06:00:00 | SPY | ETF | 352.26 | 352.57 | 351.96 | 352.57 | 12688.0 |
| 2020-11-10 06:05:00 | SPY | ETF | 352.82 | 352.91 | 352.6 | 352.9 | 13954.0 |
| 2020-11-10 06:10:00 | SPY | ETF | 352.9 | 353.24 | 352.9 | 353.24 | 24085.0 |
| 2020-11-10 06:15:00 | SPY | ETF | 353.23 | 353.56 | 353.11 | 353.16 | 18094.0 |
| 2020-11-10 06:20:00 | SPY | ETF | 353.17 | 353.19 | 352.85 | 352.99 | 41570.0 |
| 2020-11-10 06:25:00 | SPY | ETF | 352.99 | 353.18 | 352.99 | 353.15 | 4077.0 |
| 2020-11-10 06:30:00 | SPY | ETF | 353.06 | 353.86 | 353.04 | 353.83 | 12794.0 |
| 2020-11-10 06:35:00 | SPY | ETF | 353.72 | 354.26 | 353.72 | 354.11 | 34657.0 |
| 2020-11-10 06:40:00 | SPY | ETF | 354.11 | 354.25 | 353.9 | 353.9 | 19278.0 |
| 2020-11-10 06:45:00 | SPY | ETF | 353.75 | 353.85 | 353.55 | 353.57 | 8071.0 |
| 2020-11-10 06:50:00 | SPY | ETF | 353.24 | 353.92 | 353.1 | 353.86 | 26895.0 |
| 2020-11-10 06:55:00 | SPY | ETF | 353.96 | 354.44 | 353.63 | 354.38 | 22316.0 |
| 2020-11-10 07:00:00 | SPY | ETF | 354.41 | 354.59 | 354.26 | 354.5 | 27076.0 |
| 2020-11-10 07:05:00 | SPY | ETF | 354.59 | 355.0 | 354.14 | 354.14 | 61920.0 |
| 2020-11-10 07:10:00 | SPY | ETF | 354.201 | 354.24 | 353.78 | 353.91 | 30821.0 |
| 2020-11-10 07:15:00 | SPY | ETF | 353.86 | 354.03 | 353.75 | 353.78 | 115385.0 |
| 2020-11-10 07:20:00 | SPY | ETF | 353.78 | 353.94 | 353.39 | 353.48 | 62091.0 |
| 2020-11-10 07:25:00 | SPY | ETF | 353.5 | 354.17 | 353.5 | 353.96 | 33540.0 |
| 2020-11-10 07:30:00 | SPY | ETF | 354.04 | 354.3 | 353.88 | 354.0 | 23249.0 |
| 2020-11-10 07:35:00 | SPY | ETF | 354.04 | 354.15 | 353.75 | 354.01 | 37133.0 |
| 2020-11-10 07:40:00 | SPY | ETF | 354.05 | 354.13 | 353.71 | 353.93 | 25317.0 |
| 2020-11-10 07:45:00 | SPY | ETF | 353.93 | 354.0 | 353.65 | 353.72 | 25484.0 |
| 2020-11-10 07:50:00 | SPY | ETF | 353.7 | 354.19 | 353.7 | 354.15 | 33970.0 |
| 2020-11-10 07:55:00 | SPY | ETF | 354.1 | 354.1 | 353.4 | 353.47 | 44147.0 |
| 2020-11-10 08:00:00 | SPY | ETF | 353.6801 | 355.05 | 351.99 | 353.56 | 53963.0 |
| 2020-11-10 08:05:00 | SPY | ETF | 353.5 | 353.56 | 351.69 | 353.35 | 79529.0 |
> showing 50 of 81,912 rows — these rows as CSV