PREVIEW / etf_5min / 2020-03-13
file: by_date/etf_5min/2020/2020-03-13.parquet size: 2.1 MB rows: 91,971
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-13 04:00:00 | SPY | ETF | 257.99 | 260.14 | 257.5 | 260.1 | 80838.0 |
| 2020-03-13 04:05:00 | SPY | ETF | 260.08 | 260.1 | 258.03 | 258.1 | 28660.0 |
| 2020-03-13 04:10:00 | SPY | ETF | 257.52 | 257.94 | 256.19 | 256.86 | 17695.0 |
| 2020-03-13 04:15:00 | SPY | ETF | 256.74 | 257.02 | 255.46 | 255.46 | 26892.0 |
| 2020-03-13 04:20:00 | SPY | ETF | 255.35 | 258.0 | 255.35 | 255.88 | 29468.0 |
| 2020-03-13 04:25:00 | SPY | ETF | 255.93 | 257.0 | 255.93 | 256.65 | 5525.0 |
| 2020-03-13 04:30:00 | SPY | ETF | 256.59 | 256.59 | 254.08 | 254.76 | 20047.0 |
| 2020-03-13 04:35:00 | SPY | ETF | 254.78 | 255.42 | 254.6 | 254.61 | 25714.0 |
| 2020-03-13 04:40:00 | SPY | ETF | 254.72 | 254.72 | 253.35 | 254.24 | 34148.0 |
| 2020-03-13 04:45:00 | SPY | ETF | 254.46 | 254.97 | 253.8 | 253.8 | 11222.0 |
| 2020-03-13 04:50:00 | SPY | ETF | 253.56 | 255.44 | 253.56 | 255.04 | 7567.0 |
| 2020-03-13 04:55:00 | SPY | ETF | 254.73 | 255.14 | 254.32 | 254.4 | 6216.0 |
| 2020-03-13 05:00:00 | SPY | ETF | 254.8 | 254.8 | 253.75 | 253.75 | 22516.0 |
| 2020-03-13 05:05:00 | SPY | ETF | 253.66 | 254.92 | 253.28 | 254.37 | 18309.0 |
| 2020-03-13 05:10:00 | SPY | ETF | 254.48 | 255.77 | 254.13 | 255.36 | 34966.0 |
| 2020-03-13 05:15:00 | SPY | ETF | 255.6 | 256.1 | 255.13 | 255.49 | 24262.0 |
| 2020-03-13 05:20:00 | SPY | ETF | 255.23 | 257.18 | 255.1 | 256.94 | 39515.0 |
| 2020-03-13 05:25:00 | SPY | ETF | 256.95 | 256.95 | 256.25 | 256.27 | 33184.0 |
| 2020-03-13 05:30:00 | SPY | ETF | 256.47 | 256.56 | 255.86 | 255.89 | 13588.0 |
| 2020-03-13 05:35:00 | SPY | ETF | 255.84 | 256.5 | 255.79 | 256.5 | 16594.0 |
| 2020-03-13 05:40:00 | SPY | ETF | 256.31 | 256.53 | 256.29 | 256.53 | 18861.0 |
| 2020-03-13 05:45:00 | SPY | ETF | 256.55 | 256.83 | 256.47 | 256.77 | 23173.0 |
| 2020-03-13 05:50:00 | SPY | ETF | 256.86 | 257.29 | 256.7 | 257.18 | 13935.0 |
| 2020-03-13 05:55:00 | SPY | ETF | 257.32 | 258.56 | 257.32 | 258.41 | 53370.0 |
| 2020-03-13 06:00:00 | SPY | ETF | 258.41 | 258.7 | 257.9 | 258.37 | 31236.0 |
| 2020-03-13 06:05:00 | SPY | ETF | 258.4 | 258.4 | 256.82 | 257.69 | 49083.0 |
| 2020-03-13 06:10:00 | SPY | ETF | 257.73 | 258.14 | 257.5 | 258.11 | 8744.0 |
| 2020-03-13 06:15:00 | SPY | ETF | 258.17 | 258.91 | 258.06 | 258.91 | 24168.0 |
| 2020-03-13 06:20:00 | SPY | ETF | 258.9 | 259.05 | 258.0 | 258.48 | 34106.0 |
| 2020-03-13 06:25:00 | SPY | ETF | 258.21 | 258.42 | 257.01 | 257.64 | 28666.0 |
| 2020-03-13 06:30:00 | SPY | ETF | 257.56 | 257.84 | 256.94 | 257.0 | 39164.0 |
| 2020-03-13 06:35:00 | SPY | ETF | 256.9 | 257.45 | 256.79 | 257.3 | 54176.0 |
| 2020-03-13 06:40:00 | SPY | ETF | 257.37 | 257.88 | 257.22 | 257.63 | 13753.0 |
| 2020-03-13 06:45:00 | SPY | ETF | 257.68 | 257.81 | 257.45 | 257.72 | 20617.0 |
| 2020-03-13 06:50:00 | SPY | ETF | 257.65 | 258.2 | 257.35 | 258.2 | 22638.0 |
| 2020-03-13 06:55:00 | SPY | ETF | 258.21 | 258.74 | 258.17 | 258.72 | 60153.0 |
| 2020-03-13 07:00:00 | SPY | ETF | 258.64 | 259.5 | 258.42 | 259.5 | 144592.0 |
| 2020-03-13 07:05:00 | SPY | ETF | 259.61 | 260.25 | 259.45 | 260.1 | 124467.0 |
| 2020-03-13 07:10:00 | SPY | ETF | 260.12 | 260.83 | 260.09 | 260.4 | 72180.0 |
| 2020-03-13 07:15:00 | SPY | ETF | 260.5 | 260.9 | 260.27 | 260.68 | 70078.0 |
| 2020-03-13 07:20:00 | SPY | ETF | 260.63 | 260.75 | 260.45 | 260.73 | 129854.0 |
| 2020-03-13 07:25:00 | SPY | ETF | 260.74 | 260.75 | 260.2 | 260.64 | 101150.0 |
| 2020-03-13 07:30:00 | SPY | ETF | 260.51 | 260.74 | 260.27 | 260.3 | 157257.0 |
| 2020-03-13 07:35:00 | SPY | ETF | 260.31 | 260.65 | 258.25 | 260.3 | 309057.0 |
| 2020-03-13 07:40:00 | SPY | ETF | 260.3 | 260.75 | 260.27 | 260.55 | 223452.0 |
| 2020-03-13 07:45:00 | SPY | ETF | 260.55 | 260.65 | 260.0 | 260.35 | 244694.0 |
| 2020-03-13 07:50:00 | SPY | ETF | 260.35 | 260.6 | 260.3 | 260.54 | 161057.0 |
| 2020-03-13 07:55:00 | SPY | ETF | 260.56 | 260.7 | 260.4 | 260.53 | 170698.0 |
| 2020-03-13 08:00:00 | SPY | ETF | 260.41 | 260.9 | 245.0 | 260.25 | 815389.0 |
| 2020-03-13 08:05:00 | SPY | ETF | 260.25 | 260.4 | 260.17 | 260.37 | 610011.0 |
> showing 50 of 91,971 rows — these rows as CSV