PREVIEW / etf_5min / 2016-03-30
file: by_date/etf_5min/2016/2016-03-30.parquet size: 1.2 MB rows: 50,423
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-30 04:00:00 | SPY | ETF | 205.92 | 206.2 | 205.92 | 206.17 | 7617.0 |
| 2016-03-30 04:05:00 | SPY | ETF | 206.15 | 206.18 | 206.12 | 206.13 | 2437.0 |
| 2016-03-30 04:10:00 | SPY | ETF | 206.09 | 206.12 | 206.09 | 206.12 | 3135.0 |
| 2016-03-30 04:15:00 | SPY | ETF | 206.14 | 206.18 | 206.12 | 206.17 | 1720.0 |
| 2016-03-30 04:20:00 | SPY | ETF | 206.19 | 206.3 | 206.19 | 206.25 | 26618.0 |
| 2016-03-30 04:25:00 | SPY | ETF | 206.22 | 206.22 | 206.14 | 206.17 | 970.0 |
| 2016-03-30 04:30:00 | SPY | ETF | 206.17 | 206.18 | 206.12 | 206.14 | 2409.0 |
| 2016-03-30 04:35:00 | SPY | ETF | 206.12 | 206.15 | 206.12 | 206.13 | 3913.0 |
| 2016-03-30 04:40:00 | SPY | ETF | 206.12 | 206.18 | 206.12 | 206.14 | 12583.0 |
| 2016-03-30 04:45:00 | SPY | ETF | 206.18 | 206.22 | 206.18 | 206.2 | 1178.0 |
| 2016-03-30 04:50:00 | SPY | ETF | 206.13 | 206.15 | 206.12 | 206.13 | 714.0 |
| 2016-03-30 04:55:00 | SPY | ETF | 206.17 | 206.17 | 206.17 | 206.17 | 100.0 |
| 2016-03-30 05:00:00 | SPY | ETF | 206.14 | 206.19 | 206.14 | 206.19 | 1260.0 |
| 2016-03-30 05:05:00 | SPY | ETF | 206.13 | 206.2 | 206.13 | 206.2 | 1608.0 |
| 2016-03-30 05:10:00 | SPY | ETF | 206.2 | 206.22 | 206.19 | 206.2 | 3698.0 |
| 2016-03-30 05:15:00 | SPY | ETF | 206.17 | 206.2 | 206.14 | 206.14 | 5867.0 |
| 2016-03-30 05:20:00 | SPY | ETF | 206.17 | 206.22 | 206.17 | 206.22 | 501.0 |
| 2016-03-30 05:25:00 | SPY | ETF | 206.22 | 206.3 | 206.19 | 206.3 | 26051.0 |
| 2016-03-30 05:30:00 | SPY | ETF | 206.31 | 206.31 | 206.23 | 206.24 | 3124.0 |
| 2016-03-30 05:35:00 | SPY | ETF | 206.2 | 206.2 | 206.18 | 206.18 | 1515.0 |
| 2016-03-30 05:40:00 | SPY | ETF | 206.15 | 206.15 | 206.15 | 206.15 | 1300.0 |
| 2016-03-30 05:45:00 | SPY | ETF | 206.15 | 206.15 | 206.14 | 206.15 | 338.0 |
| 2016-03-30 05:50:00 | SPY | ETF | 206.18 | 206.18 | 206.15 | 206.15 | 543.0 |
| 2016-03-30 05:55:00 | SPY | ETF | 206.24 | 206.24 | 206.24 | 206.24 | 196.0 |
| 2016-03-30 06:00:00 | SPY | ETF | 206.25 | 206.3 | 206.25 | 206.3 | 2926.0 |
| 2016-03-30 06:05:00 | SPY | ETF | 206.28 | 206.34 | 206.28 | 206.29 | 6025.0 |
| 2016-03-30 06:10:00 | SPY | ETF | 206.35 | 206.41 | 206.34 | 206.39 | 70407.0 |
| 2016-03-30 06:15:00 | SPY | ETF | 206.41 | 206.41 | 206.39 | 206.39 | 7916.0 |
| 2016-03-30 06:20:00 | SPY | ETF | 206.4 | 206.44 | 206.4 | 206.4 | 2268.0 |
| 2016-03-30 06:25:00 | SPY | ETF | 206.41 | 206.5 | 206.39 | 206.5 | 2209.0 |
| 2016-03-30 06:30:00 | SPY | ETF | 206.46 | 206.54 | 206.45 | 206.53 | 52251.0 |
| 2016-03-30 06:35:00 | SPY | ETF | 206.57 | 206.57 | 206.43 | 206.44 | 15493.0 |
| 2016-03-30 06:40:00 | SPY | ETF | 206.43 | 206.49 | 206.43 | 206.46 | 3503.0 |
| 2016-03-30 06:45:00 | SPY | ETF | 206.47 | 206.49 | 206.38 | 206.49 | 8313.0 |
| 2016-03-30 06:50:00 | SPY | ETF | 206.43 | 206.44 | 206.31 | 206.31 | 2429.0 |
| 2016-03-30 06:55:00 | SPY | ETF | 206.32 | 206.38 | 206.32 | 206.33 | 3820.0 |
| 2016-03-30 07:00:00 | SPY | ETF | 206.38 | 206.41 | 206.36 | 206.41 | 7248.0 |
| 2016-03-30 07:05:00 | SPY | ETF | 206.41 | 206.46 | 206.4 | 206.42 | 5329.0 |
| 2016-03-30 07:10:00 | SPY | ETF | 206.39 | 206.39 | 206.25 | 206.29 | 13432.0 |
| 2016-03-30 07:15:00 | SPY | ETF | 206.32 | 206.33 | 206.3 | 206.33 | 15901.0 |
| 2016-03-30 07:20:00 | SPY | ETF | 206.28 | 206.36 | 206.28 | 206.33 | 2657.0 |
| 2016-03-30 07:25:00 | SPY | ETF | 206.34 | 206.41 | 206.34 | 206.41 | 8684.0 |
| 2016-03-30 07:30:00 | SPY | ETF | 206.41 | 206.44 | 206.33 | 206.38 | 19836.0 |
| 2016-03-30 07:35:00 | SPY | ETF | 206.36 | 206.42 | 206.35 | 206.41 | 36068.0 |
| 2016-03-30 07:40:00 | SPY | ETF | 206.41 | 206.44 | 206.39 | 206.39 | 92872.0 |
| 2016-03-30 07:45:00 | SPY | ETF | 206.44 | 206.45 | 206.36 | 206.36 | 47109.0 |
| 2016-03-30 07:50:00 | SPY | ETF | 206.36 | 206.41 | 206.36 | 206.41 | 15715.0 |
| 2016-03-30 07:55:00 | SPY | ETF | 206.42 | 206.42 | 206.31 | 206.31 | 70609.0 |
| 2016-03-30 08:00:00 | SPY | ETF | 206.31 | 206.43 | 205.34 | 205.34 | 161902.0 |
| 2016-03-30 08:05:00 | SPY | ETF | 206.29 | 206.31 | 206.23 | 206.29 | 26861.0 |
> showing 50 of 50,423 rows — these rows as CSV