PREVIEW / etf_5min / 2017-03-22
file: by_date/etf_5min/2017/2017-03-22.parquet size: 1.3 MB rows: 56,341
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-22 04:00:00 | SPY | ETF | 233.33 | 233.33 | 233.2 | 233.2 | 1689.0 |
| 2017-03-22 04:05:00 | SPY | ETF | 233.3 | 233.3 | 233.17 | 233.17 | 5115.0 |
| 2017-03-22 04:10:00 | SPY | ETF | 233.14 | 233.21 | 233.13 | 233.21 | 3074.0 |
| 2017-03-22 04:15:00 | SPY | ETF | 233.38 | 233.76 | 233.38 | 233.65 | 13787.0 |
| 2017-03-22 04:20:00 | SPY | ETF | 233.63 | 233.63 | 233.63 | 233.63 | 1500.0 |
| 2017-03-22 04:25:00 | SPY | ETF | 233.61 | 233.61 | 233.53 | 233.54 | 1708.0 |
| 2017-03-22 04:30:00 | SPY | ETF | 233.52 | 233.52 | 233.47 | 233.47 | 3311.0 |
| 2017-03-22 04:35:00 | SPY | ETF | 233.41 | 233.41 | 233.37 | 233.37 | 2102.0 |
| 2017-03-22 04:40:00 | SPY | ETF | 233.36 | 233.38 | 233.25 | 233.25 | 1115.0 |
| 2017-03-22 04:45:00 | SPY | ETF | 233.27 | 233.27 | 233.2 | 233.24 | 908.0 |
| 2017-03-22 04:50:00 | SPY | ETF | 233.24 | 233.25 | 233.23 | 233.25 | 1209.0 |
| 2017-03-22 04:55:00 | SPY | ETF | 233.46 | 233.46 | 233.46 | 233.46 | 104.0 |
| 2017-03-22 05:00:00 | SPY | ETF | 233.33 | 233.33 | 233.2 | 233.2 | 602.0 |
| 2017-03-22 05:05:00 | SPY | ETF | 233.21 | 233.55 | 233.21 | 233.55 | 912.0 |
| 2017-03-22 05:10:00 | SPY | ETF | 233.47 | 233.55 | 233.46 | 233.48 | 4320.0 |
| 2017-03-22 05:15:00 | SPY | ETF | 233.57 | 233.6 | 233.57 | 233.58 | 2604.0 |
| 2017-03-22 05:20:00 | SPY | ETF | 233.59 | 233.59 | 233.58 | 233.58 | 306.0 |
| 2017-03-22 05:25:00 | SPY | ETF | 233.53 | 233.53 | 233.53 | 233.53 | 1503.0 |
| 2017-03-22 05:30:00 | SPY | ETF | 233.64 | 233.64 | 233.61 | 233.62 | 1900.0 |
| 2017-03-22 05:35:00 | SPY | ETF | 233.58 | 233.6 | 233.58 | 233.6 | 506.0 |
| 2017-03-22 05:40:00 | SPY | ETF | 233.63 | 233.75 | 233.63 | 233.73 | 916.0 |
| 2017-03-22 05:45:00 | SPY | ETF | 233.68 | 233.79 | 233.68 | 233.79 | 1203.0 |
| 2017-03-22 05:50:00 | SPY | ETF | 233.78 | 233.87 | 233.78 | 233.86 | 4651.0 |
| 2017-03-22 05:55:00 | SPY | ETF | 233.85 | 233.9 | 233.82 | 233.84 | 14505.0 |
| 2017-03-22 06:00:00 | SPY | ETF | 233.84 | 233.88 | 233.77 | 233.77 | 6310.0 |
| 2017-03-22 06:05:00 | SPY | ETF | 233.81 | 233.81 | 233.81 | 233.81 | 1401.0 |
| 2017-03-22 06:10:00 | SPY | ETF | 233.76 | 233.76 | 233.72 | 233.72 | 1216.0 |
| 2017-03-22 06:15:00 | SPY | ETF | 233.72 | 233.72 | 233.72 | 233.72 | 400.0 |
| 2017-03-22 06:20:00 | SPY | ETF | 233.67 | 233.67 | 233.63 | 233.63 | 1222.0 |
| 2017-03-22 06:25:00 | SPY | ETF | 233.67 | 233.7 | 233.67 | 233.7 | 4370.0 |
| 2017-03-22 06:30:00 | SPY | ETF | 233.77 | 233.77 | 233.77 | 233.77 | 302.0 |
| 2017-03-22 06:35:00 | SPY | ETF | 233.8 | 233.8 | 233.76 | 233.76 | 618.0 |
| 2017-03-22 06:40:00 | SPY | ETF | 233.79 | 233.82 | 233.78 | 233.78 | 2685.0 |
| 2017-03-22 06:45:00 | SPY | ETF | 233.79 | 233.79 | 233.76 | 233.79 | 2900.0 |
| 2017-03-22 06:50:00 | SPY | ETF | 233.8 | 233.8 | 233.8 | 233.8 | 1051.0 |
| 2017-03-22 06:55:00 | SPY | ETF | 233.82 | 233.88 | 233.81 | 233.88 | 1501.0 |
| 2017-03-22 07:00:00 | SPY | ETF | 233.81 | 233.86 | 233.8 | 233.86 | 26878.0 |
| 2017-03-22 07:05:00 | SPY | ETF | 233.86 | 233.9 | 233.84 | 233.9 | 27608.0 |
| 2017-03-22 07:10:00 | SPY | ETF | 233.91 | 233.95 | 233.87 | 233.88 | 109834.0 |
| 2017-03-22 07:15:00 | SPY | ETF | 233.9 | 233.9 | 233.86 | 233.9 | 10127.0 |
| 2017-03-22 07:20:00 | SPY | ETF | 233.9 | 233.91 | 233.86 | 233.87 | 77251.0 |
| 2017-03-22 07:25:00 | SPY | ETF | 233.85 | 233.85 | 233.79 | 233.84 | 54103.0 |
| 2017-03-22 07:30:00 | SPY | ETF | 233.83 | 233.86 | 233.75 | 233.79 | 82332.0 |
| 2017-03-22 07:35:00 | SPY | ETF | 233.79 | 233.82 | 233.66 | 233.66 | 44484.0 |
| 2017-03-22 07:40:00 | SPY | ETF | 233.62 | 233.73 | 233.58 | 233.64 | 64118.0 |
| 2017-03-22 07:45:00 | SPY | ETF | 233.61 | 233.64 | 233.61 | 233.62 | 13417.0 |
| 2017-03-22 07:50:00 | SPY | ETF | 233.67 | 233.72 | 233.67 | 233.71 | 1141.0 |
| 2017-03-22 07:55:00 | SPY | ETF | 233.73 | 233.77 | 233.73 | 233.77 | 4233.0 |
| 2017-03-22 08:00:00 | SPY | ETF | 233.74 | 233.95 | 233.6 | 233.67 | 26341.0 |
| 2017-03-22 08:05:00 | SPY | ETF | 233.67 | 233.78 | 233.65 | 233.78 | 81414.0 |
> showing 50 of 56,341 rows — these rows as CSV