PREVIEW / etf_5min / 2017-04-10
file: by_date/etf_5min/2017/2017-04-10.parquet size: 1.2 MB rows: 52,639
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-04-10 04:05:00 | SPY | ETF | 235.26 | 235.26 | 235.26 | 235.26 | 400.0 |
| 2017-04-10 04:10:00 | SPY | ETF | 235.4 | 235.4 | 235.4 | 235.4 | 100.0 |
| 2017-04-10 04:35:00 | SPY | ETF | 235.39 | 235.42 | 235.39 | 235.42 | 3500.0 |
| 2017-04-10 04:55:00 | SPY | ETF | 235.29 | 235.29 | 235.29 | 235.29 | 500.0 |
| 2017-04-10 05:00:00 | SPY | ETF | 235.35 | 235.35 | 235.35 | 235.35 | 289.0 |
| 2017-04-10 05:15:00 | SPY | ETF | 235.34 | 235.34 | 235.34 | 235.34 | 500.0 |
| 2017-04-10 05:30:00 | SPY | ETF | 235.29 | 235.29 | 235.29 | 235.29 | 401.0 |
| 2017-04-10 05:40:00 | SPY | ETF | 235.19 | 235.19 | 235.19 | 235.19 | 101.0 |
| 2017-04-10 06:00:00 | SPY | ETF | 235.0 | 235.0 | 234.99 | 234.99 | 665.0 |
| 2017-04-10 06:10:00 | SPY | ETF | 234.93 | 234.93 | 234.92 | 234.92 | 2000.0 |
| 2017-04-10 06:15:00 | SPY | ETF | 235.02 | 235.02 | 235.02 | 235.02 | 500.0 |
| 2017-04-10 06:25:00 | SPY | ETF | 235.07 | 235.14 | 235.07 | 235.09 | 9502.0 |
| 2017-04-10 06:30:00 | SPY | ETF | 235.08 | 235.08 | 235.08 | 235.08 | 16000.0 |
| 2017-04-10 06:35:00 | SPY | ETF | 235.16 | 235.18 | 235.16 | 235.18 | 2025.0 |
| 2017-04-10 06:40:00 | SPY | ETF | 235.2 | 235.2 | 235.15 | 235.15 | 1302.0 |
| 2017-04-10 06:45:00 | SPY | ETF | 235.15 | 235.17 | 235.15 | 235.17 | 800.0 |
| 2017-04-10 06:50:00 | SPY | ETF | 235.18 | 235.18 | 235.18 | 235.18 | 300.0 |
| 2017-04-10 06:55:00 | SPY | ETF | 235.18 | 235.18 | 235.13 | 235.13 | 1250.0 |
| 2017-04-10 07:00:00 | SPY | ETF | 235.22 | 235.22 | 235.22 | 235.22 | 3100.0 |
| 2017-04-10 07:05:00 | SPY | ETF | 235.25 | 235.3 | 235.22 | 235.3 | 22981.0 |
| 2017-04-10 07:10:00 | SPY | ETF | 235.32 | 235.33 | 235.21 | 235.25 | 6828.0 |
| 2017-04-10 07:15:00 | SPY | ETF | 235.29 | 235.29 | 235.29 | 235.29 | 501.0 |
| 2017-04-10 07:20:00 | SPY | ETF | 235.29 | 235.29 | 235.28 | 235.28 | 5821.0 |
| 2017-04-10 07:25:00 | SPY | ETF | 235.28 | 235.35 | 235.28 | 235.35 | 954.0 |
| 2017-04-10 07:30:00 | SPY | ETF | 235.38 | 235.42 | 235.38 | 235.42 | 85403.0 |
| 2017-04-10 07:35:00 | SPY | ETF | 235.44 | 235.48 | 235.44 | 235.48 | 32633.0 |
| 2017-04-10 07:40:00 | SPY | ETF | 235.46 | 235.46 | 235.46 | 235.46 | 6100.0 |
| 2017-04-10 07:45:00 | SPY | ETF | 235.41 | 235.41 | 235.4 | 235.4 | 1540.0 |
| 2017-04-10 07:50:00 | SPY | ETF | 235.41 | 235.47 | 235.41 | 235.43 | 23501.0 |
| 2017-04-10 07:55:00 | SPY | ETF | 235.45 | 235.45 | 235.45 | 235.45 | 300.0 |
| 2017-04-10 08:00:00 | SPY | ETF | 235.45 | 235.49 | 235.13 | 235.49 | 51436.0 |
| 2017-04-10 08:05:00 | SPY | ETF | 235.45 | 235.45 | 235.4 | 235.4 | 5259.0 |
| 2017-04-10 08:10:00 | SPY | ETF | 235.4 | 235.41 | 235.4 | 235.41 | 6999.0 |
| 2017-04-10 08:15:00 | SPY | ETF | 235.41 | 235.43 | 235.41 | 235.43 | 21453.0 |
| 2017-04-10 08:20:00 | SPY | ETF | 235.45 | 235.49 | 235.43 | 235.48 | 3501.0 |
| 2017-04-10 08:25:00 | SPY | ETF | 235.45 | 235.45 | 235.41 | 235.41 | 26138.0 |
| 2017-04-10 08:30:00 | SPY | ETF | 235.41 | 235.42 | 235.37 | 235.37 | 9575.0 |
| 2017-04-10 08:35:00 | SPY | ETF | 235.39 | 235.4 | 235.35 | 235.35 | 8850.0 |
| 2017-04-10 08:40:00 | SPY | ETF | 235.35 | 235.35 | 235.31 | 235.31 | 23745.0 |
| 2017-04-10 08:45:00 | SPY | ETF | 235.32 | 235.32 | 235.27 | 235.27 | 12676.0 |
| 2017-04-10 08:50:00 | SPY | ETF | 235.29 | 235.29 | 235.25 | 235.27 | 6064.0 |
| 2017-04-10 08:55:00 | SPY | ETF | 235.26 | 235.26 | 235.21 | 235.21 | 11070.0 |
| 2017-04-10 09:00:00 | SPY | ETF | 235.22 | 235.35 | 235.22 | 235.32 | 9405.0 |
| 2017-04-10 09:05:00 | SPY | ETF | 235.34 | 235.38 | 235.33 | 235.35 | 24654.0 |
| 2017-04-10 09:10:00 | SPY | ETF | 235.37 | 235.38 | 235.35 | 235.35 | 18285.0 |
| 2017-04-10 09:15:00 | SPY | ETF | 235.35 | 235.38 | 235.32 | 235.38 | 10478.0 |
| 2017-04-10 09:20:00 | SPY | ETF | 235.37 | 235.38 | 235.35 | 235.36 | 15852.0 |
| 2017-04-10 09:25:00 | SPY | ETF | 235.35 | 235.38 | 235.33 | 235.35 | 39598.0 |
| 2017-04-10 09:30:00 | SPY | ETF | 235.36 | 235.56 | 235.28 | 235.56 | 1226711.0 |
| 2017-04-10 09:35:00 | SPY | ETF | 235.55 | 235.76 | 235.48 | 235.73 | 894230.0 |
> showing 50 of 52,639 rows — these rows as CSV