PREVIEW / etf_5min / 2014-10-03
file: by_date/etf_5min/2014/2014-10-03.parquet size: 1.1 MB rows: 46,486
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-03 04:00:00 | SPY | ETF | 194.83 | 195.13 | 194.83 | 195.13 | 5726.0 |
| 2014-10-03 04:05:00 | SPY | ETF | 195.12 | 195.19 | 195.1 | 195.19 | 867.0 |
| 2014-10-03 04:10:00 | SPY | ETF | 195.19 | 195.22 | 195.19 | 195.22 | 981.0 |
| 2014-10-03 04:25:00 | SPY | ETF | 195.22 | 195.22 | 195.22 | 195.22 | 200.0 |
| 2014-10-03 04:30:00 | SPY | ETF | 195.3 | 195.37 | 195.3 | 195.37 | 3163.0 |
| 2014-10-03 04:35:00 | SPY | ETF | 195.42 | 195.42 | 195.42 | 195.42 | 200.0 |
| 2014-10-03 04:40:00 | SPY | ETF | 195.44 | 195.44 | 195.31 | 195.31 | 1446.0 |
| 2014-10-03 04:45:00 | SPY | ETF | 195.41 | 195.41 | 195.39 | 195.39 | 402.0 |
| 2014-10-03 04:50:00 | SPY | ETF | 195.39 | 195.46 | 195.39 | 195.42 | 2200.0 |
| 2014-10-03 05:00:00 | SPY | ETF | 195.35 | 195.35 | 195.34 | 195.34 | 276.0 |
| 2014-10-03 05:05:00 | SPY | ETF | 195.38 | 195.38 | 195.32 | 195.32 | 1340.0 |
| 2014-10-03 05:10:00 | SPY | ETF | 195.29 | 195.34 | 195.29 | 195.34 | 9400.0 |
| 2014-10-03 05:15:00 | SPY | ETF | 195.36 | 195.36 | 195.36 | 195.36 | 200.0 |
| 2014-10-03 05:20:00 | SPY | ETF | 195.38 | 195.38 | 195.38 | 195.38 | 100.0 |
| 2014-10-03 05:25:00 | SPY | ETF | 195.38 | 195.38 | 195.38 | 195.38 | 2500.0 |
| 2014-10-03 05:30:00 | SPY | ETF | 195.44 | 195.44 | 195.36 | 195.36 | 3100.0 |
| 2014-10-03 05:40:00 | SPY | ETF | 195.3 | 195.3 | 195.25 | 195.25 | 510.0 |
| 2014-10-03 05:45:00 | SPY | ETF | 195.26 | 195.26 | 195.26 | 195.26 | 140.0 |
| 2014-10-03 05:50:00 | SPY | ETF | 195.25 | 195.27 | 195.25 | 195.27 | 800.0 |
| 2014-10-03 05:55:00 | SPY | ETF | 195.27 | 195.27 | 195.2 | 195.2 | 1506.0 |
| 2014-10-03 06:00:00 | SPY | ETF | 195.17 | 195.27 | 195.17 | 195.27 | 3540.0 |
| 2014-10-03 06:05:00 | SPY | ETF | 195.27 | 195.27 | 195.24 | 195.27 | 5532.0 |
| 2014-10-03 06:10:00 | SPY | ETF | 195.25 | 195.25 | 195.24 | 195.24 | 699.0 |
| 2014-10-03 06:15:00 | SPY | ETF | 195.22 | 195.26 | 195.22 | 195.26 | 700.0 |
| 2014-10-03 06:20:00 | SPY | ETF | 195.26 | 195.26 | 195.26 | 195.26 | 600.0 |
| 2014-10-03 06:25:00 | SPY | ETF | 195.26 | 195.31 | 195.26 | 195.31 | 10600.0 |
| 2014-10-03 06:30:00 | SPY | ETF | 195.3 | 195.31 | 195.28 | 195.28 | 10216.0 |
| 2014-10-03 06:35:00 | SPY | ETF | 195.27 | 195.28 | 195.24 | 195.27 | 61500.0 |
| 2014-10-03 06:40:00 | SPY | ETF | 195.22 | 195.22 | 195.19 | 195.19 | 5300.0 |
| 2014-10-03 06:45:00 | SPY | ETF | 195.21 | 195.22 | 195.2 | 195.21 | 12423.0 |
| 2014-10-03 06:55:00 | SPY | ETF | 195.19 | 195.19 | 195.15 | 195.17 | 862.0 |
| 2014-10-03 07:00:00 | SPY | ETF | 195.21 | 195.26 | 195.21 | 195.24 | 8150.0 |
| 2014-10-03 07:05:00 | SPY | ETF | 195.22 | 195.27 | 195.22 | 195.24 | 30759.0 |
| 2014-10-03 07:10:00 | SPY | ETF | 195.24 | 195.24 | 195.19 | 195.19 | 44060.0 |
| 2014-10-03 07:15:00 | SPY | ETF | 195.19 | 195.27 | 195.19 | 195.27 | 8412.0 |
| 2014-10-03 07:20:00 | SPY | ETF | 195.27 | 195.37 | 195.27 | 195.37 | 6340.0 |
| 2014-10-03 07:25:00 | SPY | ETF | 195.37 | 195.38 | 195.22 | 195.22 | 44960.0 |
| 2014-10-03 07:30:00 | SPY | ETF | 195.24 | 195.24 | 195.19 | 195.2 | 6200.0 |
| 2014-10-03 07:35:00 | SPY | ETF | 195.23 | 195.29 | 195.23 | 195.29 | 9740.0 |
| 2014-10-03 07:40:00 | SPY | ETF | 195.27 | 195.36 | 195.27 | 195.29 | 11600.0 |
| 2014-10-03 07:45:00 | SPY | ETF | 195.29 | 195.44 | 195.29 | 195.43 | 21464.0 |
| 2014-10-03 07:50:00 | SPY | ETF | 195.42 | 195.47 | 195.38 | 195.39 | 36600.0 |
| 2014-10-03 07:55:00 | SPY | ETF | 195.42 | 195.49 | 195.42 | 195.44 | 54722.0 |
| 2014-10-03 08:00:00 | SPY | ETF | 195.19 | 195.5 | 195.19 | 195.46 | 123826.0 |
| 2014-10-03 08:05:00 | SPY | ETF | 194.69 | 195.65 | 194.69 | 195.56 | 206515.0 |
| 2014-10-03 08:10:00 | SPY | ETF | 195.56 | 195.6 | 195.53 | 195.56 | 104328.0 |
| 2014-10-03 08:15:00 | SPY | ETF | 195.55 | 195.55 | 195.36 | 195.4 | 130837.0 |
| 2014-10-03 08:20:00 | SPY | ETF | 195.37 | 195.4 | 195.35 | 195.36 | 432343.0 |
| 2014-10-03 08:25:00 | SPY | ETF | 195.39 | 195.42 | 195.33 | 195.34 | 171051.0 |
| 2014-10-03 08:30:00 | SPY | ETF | 195.4 | 195.9 | 195.13 | 195.59 | 3231636.0 |
> showing 50 of 46,486 rows — these rows as CSV