PREVIEW / etf_5min / 2020-03-30
file: by_date/etf_5min/2020/2020-03-30.parquet size: 1.8 MB rows: 81,054
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-30 04:00:00 | SPY | ETF | 250.25 | 251.42 | 250.2 | 251.38 | 34469.0 |
| 2020-03-30 04:05:00 | SPY | ETF | 251.28 | 252.0 | 251.0 | 251.88 | 87720.0 |
| 2020-03-30 04:10:00 | SPY | ETF | 251.81 | 252.03 | 251.6 | 251.87 | 37310.0 |
| 2020-03-30 04:15:00 | SPY | ETF | 251.83 | 252.08 | 251.15 | 251.15 | 29844.0 |
| 2020-03-30 04:20:00 | SPY | ETF | 251.14 | 251.31 | 250.36 | 250.6 | 31627.0 |
| 2020-03-30 04:25:00 | SPY | ETF | 250.58 | 251.87 | 250.58 | 251.6 | 31593.0 |
| 2020-03-30 04:30:00 | SPY | ETF | 251.51 | 252.52 | 251.47 | 252.23 | 31650.0 |
| 2020-03-30 04:35:00 | SPY | ETF | 252.26 | 252.3 | 251.34 | 252.23 | 10376.0 |
| 2020-03-30 04:40:00 | SPY | ETF | 252.22 | 253.25 | 252.14 | 253.25 | 26933.0 |
| 2020-03-30 04:45:00 | SPY | ETF | 253.31 | 253.66 | 253.01 | 253.01 | 35155.0 |
| 2020-03-30 04:50:00 | SPY | ETF | 253.01 | 253.01 | 252.57 | 252.67 | 15265.0 |
| 2020-03-30 04:55:00 | SPY | ETF | 252.69 | 252.82 | 251.8 | 252.46 | 14358.0 |
| 2020-03-30 05:00:00 | SPY | ETF | 252.55 | 252.55 | 251.24 | 251.24 | 14587.0 |
| 2020-03-30 05:05:00 | SPY | ETF | 251.46 | 252.49 | 251.46 | 252.2 | 12063.0 |
| 2020-03-30 05:10:00 | SPY | ETF | 252.2 | 252.2 | 251.7 | 251.77 | 3355.0 |
| 2020-03-30 05:15:00 | SPY | ETF | 251.67 | 251.88 | 251.44 | 251.8 | 6781.0 |
| 2020-03-30 05:20:00 | SPY | ETF | 252.15 | 253.75 | 252.15 | 253.48 | 23135.0 |
| 2020-03-30 05:25:00 | SPY | ETF | 253.69 | 253.82 | 253.28 | 253.75 | 15353.0 |
| 2020-03-30 05:30:00 | SPY | ETF | 253.74 | 253.76 | 253.35 | 253.69 | 10146.0 |
| 2020-03-30 05:35:00 | SPY | ETF | 253.75 | 253.89 | 253.21 | 253.27 | 15386.0 |
| 2020-03-30 05:40:00 | SPY | ETF | 253.28 | 253.81 | 253.23 | 253.37 | 8489.0 |
| 2020-03-30 05:45:00 | SPY | ETF | 253.3 | 253.53 | 252.68 | 253.33 | 16001.0 |
| 2020-03-30 05:50:00 | SPY | ETF | 253.2 | 253.44 | 251.88 | 251.99 | 42831.0 |
| 2020-03-30 05:55:00 | SPY | ETF | 251.93 | 252.4 | 251.75 | 251.94 | 22418.0 |
| 2020-03-30 06:00:00 | SPY | ETF | 251.93 | 253.7 | 251.93 | 253.38 | 43639.0 |
| 2020-03-30 06:05:00 | SPY | ETF | 253.38 | 253.6 | 253.04 | 253.35 | 35288.0 |
| 2020-03-30 06:10:00 | SPY | ETF | 253.25 | 253.72 | 253.0 | 253.0 | 62419.0 |
| 2020-03-30 06:15:00 | SPY | ETF | 253.1 | 253.35 | 252.47 | 252.62 | 44196.0 |
| 2020-03-30 06:20:00 | SPY | ETF | 252.5 | 252.67 | 252.25 | 252.44 | 20697.0 |
| 2020-03-30 06:25:00 | SPY | ETF | 252.23 | 252.73 | 252.15 | 252.73 | 12340.0 |
| 2020-03-30 06:30:00 | SPY | ETF | 252.98 | 253.3 | 252.8 | 253.0 | 15613.0 |
| 2020-03-30 06:35:00 | SPY | ETF | 252.99 | 253.81 | 252.5 | 253.46 | 43083.0 |
| 2020-03-30 06:40:00 | SPY | ETF | 253.64 | 253.78 | 253.43 | 253.78 | 9469.0 |
| 2020-03-30 06:45:00 | SPY | ETF | 253.7 | 253.7 | 253.25 | 253.25 | 79065.0 |
| 2020-03-30 06:50:00 | SPY | ETF | 253.26 | 253.65 | 253.03 | 253.34 | 28775.0 |
| 2020-03-30 06:55:00 | SPY | ETF | 253.28 | 253.78 | 253.19 | 253.5 | 22149.0 |
| 2020-03-30 07:00:00 | SPY | ETF | 253.44 | 253.5 | 252.8 | 253.11 | 83700.0 |
| 2020-03-30 07:05:00 | SPY | ETF | 253.06 | 254.1 | 253.04 | 253.95 | 146822.0 |
| 2020-03-30 07:10:00 | SPY | ETF | 254.0 | 254.05 | 253.5 | 253.51 | 148791.0 |
| 2020-03-30 07:15:00 | SPY | ETF | 253.59 | 254.12 | 253.44 | 254.12 | 91682.0 |
| 2020-03-30 07:20:00 | SPY | ETF | 254.17 | 254.2 | 253.9 | 254.18 | 45382.0 |
| 2020-03-30 07:25:00 | SPY | ETF | 254.12 | 254.2 | 253.62 | 253.68 | 24184.0 |
| 2020-03-30 07:30:00 | SPY | ETF | 253.64 | 253.74 | 253.23 | 253.25 | 80345.0 |
| 2020-03-30 07:35:00 | SPY | ETF | 253.25 | 253.74 | 253.12 | 253.27 | 162760.0 |
| 2020-03-30 07:40:00 | SPY | ETF | 253.21 | 253.32 | 252.6 | 252.74 | 82439.0 |
| 2020-03-30 07:45:00 | SPY | ETF | 252.7 | 254.09 | 252.61 | 254.06 | 105895.0 |
| 2020-03-30 07:50:00 | SPY | ETF | 253.98 | 254.26 | 253.78 | 254.14 | 139542.0 |
| 2020-03-30 07:55:00 | SPY | ETF | 254.12 | 254.26 | 253.65 | 253.8 | 132463.0 |
| 2020-03-30 08:00:00 | SPY | ETF | 253.7101 | 256.96 | 250.15 | 252.95 | 309123.0 |
| 2020-03-30 08:05:00 | SPY | ETF | 253.47 | 254.02 | 250.09 | 253.88 | 183960.0 |
> showing 50 of 81,054 rows — these rows as CSV