PREVIEW / etf_5min / 2018-12-12
file: by_date/etf_5min/2018/2018-12-12.parquet size: 1.5 MB rows: 64,992
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-12 04:00:00 | SPY | ETF | 265.5 | 265.76 | 265.5 | 265.76 | 3714.0 |
| 2018-12-12 04:05:00 | SPY | ETF | 265.77 | 266.06 | 265.77 | 266.04 | 9430.0 |
| 2018-12-12 04:10:00 | SPY | ETF | 266.11 | 266.21 | 266.11 | 266.21 | 2525.0 |
| 2018-12-12 04:15:00 | SPY | ETF | 266.12 | 266.12 | 266.01 | 266.01 | 1446.0 |
| 2018-12-12 04:20:00 | SPY | ETF | 266.2 | 266.2 | 266.16 | 266.16 | 820.0 |
| 2018-12-12 04:25:00 | SPY | ETF | 266.21 | 266.53 | 266.21 | 266.43 | 40620.0 |
| 2018-12-12 04:30:00 | SPY | ETF | 266.43 | 266.51 | 266.43 | 266.46 | 4625.0 |
| 2018-12-12 04:35:00 | SPY | ETF | 266.57 | 266.62 | 266.57 | 266.62 | 570.0 |
| 2018-12-12 04:40:00 | SPY | ETF | 266.59 | 266.62 | 266.59 | 266.62 | 970.0 |
| 2018-12-12 04:45:00 | SPY | ETF | 266.59 | 266.62 | 266.58 | 266.62 | 5516.0 |
| 2018-12-12 04:50:00 | SPY | ETF | 266.79 | 266.95 | 266.74 | 266.74 | 3972.0 |
| 2018-12-12 04:55:00 | SPY | ETF | 266.8 | 266.82 | 266.8 | 266.82 | 350.0 |
| 2018-12-12 05:00:00 | SPY | ETF | 266.72 | 266.8 | 266.67 | 266.71 | 2200.0 |
| 2018-12-12 05:05:00 | SPY | ETF | 266.7 | 266.7 | 266.7 | 266.7 | 5000.0 |
| 2018-12-12 05:10:00 | SPY | ETF | 266.72 | 266.72 | 266.65 | 266.65 | 6550.0 |
| 2018-12-12 05:15:00 | SPY | ETF | 266.6 | 266.6 | 266.45 | 266.45 | 1400.0 |
| 2018-12-12 05:20:00 | SPY | ETF | 266.48 | 266.58 | 266.45 | 266.54 | 4325.0 |
| 2018-12-12 05:25:00 | SPY | ETF | 266.54 | 266.54 | 266.45 | 266.48 | 2688.0 |
| 2018-12-12 05:30:00 | SPY | ETF | 266.44 | 266.52 | 266.44 | 266.5 | 2176.0 |
| 2018-12-12 05:35:00 | SPY | ETF | 266.54 | 266.77 | 266.54 | 266.73 | 6426.0 |
| 2018-12-12 05:40:00 | SPY | ETF | 266.73 | 266.81 | 266.73 | 266.78 | 2569.0 |
| 2018-12-12 05:45:00 | SPY | ETF | 266.78 | 266.78 | 266.78 | 266.78 | 100.0 |
| 2018-12-12 05:50:00 | SPY | ETF | 266.73 | 266.73 | 266.5 | 266.58 | 2636.0 |
| 2018-12-12 05:55:00 | SPY | ETF | 266.54 | 266.61 | 266.46 | 266.61 | 1238.0 |
| 2018-12-12 06:00:00 | SPY | ETF | 266.6 | 266.6 | 266.4 | 266.41 | 8577.0 |
| 2018-12-12 06:05:00 | SPY | ETF | 266.41 | 266.41 | 266.17 | 266.17 | 2693.0 |
| 2018-12-12 06:10:00 | SPY | ETF | 266.15 | 266.29 | 266.09 | 266.29 | 7737.0 |
| 2018-12-12 06:15:00 | SPY | ETF | 266.3 | 266.36 | 266.24 | 266.24 | 1300.0 |
| 2018-12-12 06:20:00 | SPY | ETF | 266.28 | 266.37 | 266.19 | 266.37 | 1207.0 |
| 2018-12-12 06:25:00 | SPY | ETF | 266.38 | 266.52 | 266.38 | 266.52 | 22389.0 |
| 2018-12-12 06:30:00 | SPY | ETF | 266.52 | 266.54 | 266.52 | 266.54 | 1195.0 |
| 2018-12-12 06:35:00 | SPY | ETF | 266.27 | 266.32 | 266.09 | 266.15 | 32086.0 |
| 2018-12-12 06:40:00 | SPY | ETF | 266.2 | 266.35 | 266.19 | 266.35 | 1829.0 |
| 2018-12-12 06:45:00 | SPY | ETF | 266.39 | 266.51 | 266.32 | 266.51 | 3564.0 |
| 2018-12-12 06:50:00 | SPY | ETF | 266.51 | 266.57 | 266.48 | 266.48 | 29650.0 |
| 2018-12-12 06:55:00 | SPY | ETF | 266.39 | 266.44 | 266.24 | 266.44 | 18421.0 |
| 2018-12-12 07:00:00 | SPY | ETF | 266.36 | 266.42 | 266.19 | 266.2 | 24917.0 |
| 2018-12-12 07:05:00 | SPY | ETF | 266.2 | 266.2 | 266.06 | 266.13 | 6399.0 |
| 2018-12-12 07:10:00 | SPY | ETF | 266.16 | 266.28 | 266.16 | 266.26 | 8784.0 |
| 2018-12-12 07:15:00 | SPY | ETF | 266.27 | 266.36 | 266.22 | 266.32 | 7725.0 |
| 2018-12-12 07:20:00 | SPY | ETF | 266.3 | 266.36 | 266.29 | 266.35 | 2690.0 |
| 2018-12-12 07:25:00 | SPY | ETF | 266.36 | 266.66 | 266.35 | 266.66 | 33589.0 |
| 2018-12-12 07:30:00 | SPY | ETF | 266.65 | 266.87 | 266.65 | 266.84 | 20787.0 |
| 2018-12-12 07:35:00 | SPY | ETF | 266.87 | 267.0 | 266.87 | 266.9 | 39593.0 |
| 2018-12-12 07:40:00 | SPY | ETF | 266.89 | 267.05 | 266.89 | 267.0 | 28883.0 |
| 2018-12-12 07:45:00 | SPY | ETF | 266.96 | 267.15 | 266.93 | 266.96 | 18115.0 |
| 2018-12-12 07:50:00 | SPY | ETF | 266.93 | 266.95 | 266.62 | 266.77 | 69957.0 |
| 2018-12-12 07:55:00 | SPY | ETF | 266.78 | 266.84 | 266.69 | 266.72 | 12816.0 |
| 2018-12-12 08:00:00 | SPY | ETF | 266.32 | 267.1199 | 264.96 | 266.79 | 47003.0 |
| 2018-12-12 08:05:00 | SPY | ETF | 266.75 | 266.81 | 266.62 | 266.62 | 19183.0 |
> showing 50 of 64,992 rows — these rows as CSV