PREVIEW / etf_5min / 2020-12-07
file: by_date/etf_5min/2020/2020-12-07.parquet size: 1.7 MB rows: 81,204
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-12-07 04:00:00 | SPY | ETF | 367.56 | 367.6 | 367.45 | 367.49 | 15554.0 |
| 2020-12-07 04:05:00 | SPY | ETF | 367.5 | 367.56 | 367.5 | 367.54 | 1935.0 |
| 2020-12-07 04:10:00 | SPY | ETF | 367.44 | 367.44 | 367.4 | 367.4 | 303.0 |
| 2020-12-07 04:15:00 | SPY | ETF | 367.37 | 367.78 | 367.36 | 367.74 | 6183.0 |
| 2020-12-07 04:20:00 | SPY | ETF | 367.76 | 367.84 | 367.76 | 367.84 | 4740.0 |
| 2020-12-07 04:25:00 | SPY | ETF | 367.84 | 367.87 | 367.84 | 367.87 | 5984.0 |
| 2020-12-07 04:30:00 | SPY | ETF | 367.9 | 368.09 | 367.9 | 368.02 | 5787.0 |
| 2020-12-07 04:35:00 | SPY | ETF | 367.96 | 367.96 | 367.96 | 367.96 | 200.0 |
| 2020-12-07 04:45:00 | SPY | ETF | 368.16 | 368.19 | 368.14 | 368.19 | 2951.0 |
| 2020-12-07 04:50:00 | SPY | ETF | 368.15 | 368.16 | 368.09 | 368.09 | 350.0 |
| 2020-12-07 04:55:00 | SPY | ETF | 368.14 | 368.16 | 368.1 | 368.12 | 1905.0 |
| 2020-12-07 05:00:00 | SPY | ETF | 368.06 | 368.06 | 368.06 | 368.06 | 206.0 |
| 2020-12-07 05:05:00 | SPY | ETF | 368.1 | 368.21 | 368.1 | 368.21 | 200.0 |
| 2020-12-07 05:10:00 | SPY | ETF | 368.34 | 368.34 | 368.34 | 368.34 | 171.0 |
| 2020-12-07 05:15:00 | SPY | ETF | 368.21 | 368.36 | 368.21 | 368.34 | 2746.0 |
| 2020-12-07 05:20:00 | SPY | ETF | 368.38 | 368.48 | 368.38 | 368.45 | 10325.0 |
| 2020-12-07 05:25:00 | SPY | ETF | 368.44 | 368.54 | 368.44 | 368.54 | 335.0 |
| 2020-12-07 05:30:00 | SPY | ETF | 368.6 | 368.6 | 368.31 | 368.31 | 1917.0 |
| 2020-12-07 05:35:00 | SPY | ETF | 368.29 | 368.29 | 368.24 | 368.24 | 400.0 |
| 2020-12-07 05:40:00 | SPY | ETF | 368.24 | 368.24 | 368.23 | 368.24 | 1253.0 |
| 2020-12-07 05:45:00 | SPY | ETF | 368.4 | 368.4 | 368.36 | 368.36 | 500.0 |
| 2020-12-07 05:50:00 | SPY | ETF | 368.29 | 368.31 | 368.27 | 368.29 | 1400.0 |
| 2020-12-07 05:55:00 | SPY | ETF | 368.21 | 368.21 | 368.15 | 368.15 | 900.0 |
| 2020-12-07 06:00:00 | SPY | ETF | 368.04 | 368.11 | 368.04 | 368.06 | 654.0 |
| 2020-12-07 06:05:00 | SPY | ETF | 368.29 | 368.36 | 368.27 | 368.27 | 1310.0 |
| 2020-12-07 06:20:00 | SPY | ETF | 368.36 | 368.36 | 368.3 | 368.35 | 1078.0 |
| 2020-12-07 06:25:00 | SPY | ETF | 368.34 | 368.41 | 368.33 | 368.41 | 8500.0 |
| 2020-12-07 06:35:00 | SPY | ETF | 368.5 | 368.5 | 368.42 | 368.44 | 1020.0 |
| 2020-12-07 06:40:00 | SPY | ETF | 368.41 | 368.53 | 368.4 | 368.44 | 17220.0 |
| 2020-12-07 06:45:00 | SPY | ETF | 368.31 | 368.46 | 368.31 | 368.35 | 10410.0 |
| 2020-12-07 06:50:00 | SPY | ETF | 368.5 | 368.56 | 368.5 | 368.51 | 1539.0 |
| 2020-12-07 06:55:00 | SPY | ETF | 368.62 | 368.72 | 368.62 | 368.65 | 7765.0 |
| 2020-12-07 07:00:00 | SPY | ETF | 368.66 | 368.72 | 368.52 | 368.52 | 9891.0 |
| 2020-12-07 07:05:00 | SPY | ETF | 368.56 | 368.56 | 368.51 | 368.56 | 2037.0 |
| 2020-12-07 07:10:00 | SPY | ETF | 368.55 | 368.62 | 368.55 | 368.61 | 1239.0 |
| 2020-12-07 07:15:00 | SPY | ETF | 368.51 | 368.54 | 368.5 | 368.54 | 1160.0 |
| 2020-12-07 07:20:00 | SPY | ETF | 368.49 | 368.51 | 368.48 | 368.48 | 8695.0 |
| 2020-12-07 07:25:00 | SPY | ETF | 368.45 | 368.45 | 368.4 | 368.41 | 15664.0 |
| 2020-12-07 07:30:00 | SPY | ETF | 368.42 | 368.46 | 368.29 | 368.33 | 62710.0 |
| 2020-12-07 07:35:00 | SPY | ETF | 368.34 | 368.45 | 368.32 | 368.4 | 24751.0 |
| 2020-12-07 07:40:00 | SPY | ETF | 368.42 | 368.47 | 368.24 | 368.24 | 26503.0 |
| 2020-12-07 07:45:00 | SPY | ETF | 368.25 | 368.28 | 368.25 | 368.28 | 900.0 |
| 2020-12-07 07:50:00 | SPY | ETF | 368.3 | 368.61 | 368.3 | 368.58 | 52762.0 |
| 2020-12-07 07:55:00 | SPY | ETF | 368.54 | 368.69 | 368.54 | 368.61 | 24437.0 |
| 2020-12-07 08:00:00 | SPY | ETF | 368.5201 | 369.1 | 367.54 | 368.51 | 43406.0 |
| 2020-12-07 08:05:00 | SPY | ETF | 368.5 | 368.5 | 368.42 | 368.47 | 42167.0 |
| 2020-12-07 08:10:00 | SPY | ETF | 368.44 | 368.5 | 368.4 | 368.4 | 13745.0 |
| 2020-12-07 08:15:00 | SPY | ETF | 368.39 | 368.63 | 368.35 | 368.63 | 27499.0 |
| 2020-12-07 08:20:00 | SPY | ETF | 368.67 | 368.78 | 368.6699 | 368.71 | 30756.0 |
| 2020-12-07 08:25:00 | SPY | ETF | 368.67 | 368.75 | 368.67 | 368.69 | 16746.0 |
> showing 50 of 81,204 rows — these rows as CSV