PREVIEW / etf_1min / 2015-09-30
file: by_date/etf_1min/2015/2015-09-30.parquet size: 2.6 MB rows: 139,428
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-30 04:00:00 | SPY | ETF | 189.58 | 189.66 | 189.58 | 189.65 | 4055.0 |
| 2015-09-30 04:01:00 | SPY | ETF | 189.69 | 189.7 | 189.66 | 189.7 | 642.0 |
| 2015-09-30 04:02:00 | SPY | ETF | 189.61 | 189.61 | 189.61 | 189.61 | 150.0 |
| 2015-09-30 04:03:00 | SPY | ETF | 189.61 | 189.61 | 189.61 | 189.61 | 300.0 |
| 2015-09-30 04:04:00 | SPY | ETF | 189.6 | 189.6 | 189.6 | 189.6 | 100.0 |
| 2015-09-30 04:05:00 | SPY | ETF | 189.67 | 189.75 | 189.67 | 189.75 | 802.0 |
| 2015-09-30 04:06:00 | SPY | ETF | 189.53 | 189.53 | 189.53 | 189.53 | 1000.0 |
| 2015-09-30 04:13:00 | SPY | ETF | 189.7 | 189.7 | 189.7 | 189.7 | 125.0 |
| 2015-09-30 04:14:00 | SPY | ETF | 189.76 | 189.79 | 189.76 | 189.79 | 250.0 |
| 2015-09-30 04:15:00 | SPY | ETF | 189.86 | 189.86 | 189.86 | 189.86 | 120.0 |
| 2015-09-30 04:18:00 | SPY | ETF | 190.0 | 190.0 | 190.0 | 190.0 | 3051.0 |
| 2015-09-30 04:20:00 | SPY | ETF | 189.9 | 189.97 | 189.9 | 189.97 | 900.0 |
| 2015-09-30 04:22:00 | SPY | ETF | 189.93 | 189.96 | 189.93 | 189.96 | 300.0 |
| 2015-09-30 04:25:00 | SPY | ETF | 189.93 | 189.93 | 189.93 | 189.93 | 300.0 |
| 2015-09-30 04:29:00 | SPY | ETF | 190.0 | 190.0 | 190.0 | 190.0 | 100.0 |
| 2015-09-30 04:30:00 | SPY | ETF | 190.0 | 190.0 | 190.0 | 190.0 | 110000.0 |
| 2015-09-30 04:31:00 | SPY | ETF | 190.04 | 190.04 | 190.04 | 190.04 | 525.0 |
| 2015-09-30 04:32:00 | SPY | ETF | 190.07 | 190.07 | 190.02 | 190.02 | 4900.0 |
| 2015-09-30 04:36:00 | SPY | ETF | 190.0 | 190.02 | 190.0 | 190.02 | 600.0 |
| 2015-09-30 04:41:00 | SPY | ETF | 190.13 | 190.2 | 190.13 | 190.2 | 831.0 |
| 2015-09-30 04:42:00 | SPY | ETF | 190.21 | 190.21 | 190.19 | 190.19 | 465.0 |
| 2015-09-30 04:48:00 | SPY | ETF | 190.33 | 190.34 | 190.33 | 190.34 | 619.0 |
| 2015-09-30 04:49:00 | SPY | ETF | 190.28 | 190.28 | 190.28 | 190.28 | 210.0 |
| 2015-09-30 04:53:00 | SPY | ETF | 190.25 | 190.25 | 190.25 | 190.25 | 300.0 |
| 2015-09-30 04:54:00 | SPY | ETF | 190.35 | 190.35 | 190.35 | 190.35 | 178.0 |
| 2015-09-30 04:55:00 | SPY | ETF | 190.35 | 190.35 | 190.33 | 190.33 | 250.0 |
| 2015-09-30 04:56:00 | SPY | ETF | 190.27 | 190.27 | 190.27 | 190.27 | 700.0 |
| 2015-09-30 05:00:00 | SPY | ETF | 190.25 | 190.25 | 190.25 | 190.25 | 1500.0 |
| 2015-09-30 05:02:00 | SPY | ETF | 190.38 | 190.38 | 190.38 | 190.38 | 100.0 |
| 2015-09-30 05:03:00 | SPY | ETF | 190.31 | 190.31 | 190.27 | 190.27 | 600.0 |
| 2015-09-30 05:04:00 | SPY | ETF | 190.33 | 190.33 | 190.33 | 190.33 | 200.0 |
| 2015-09-30 05:06:00 | SPY | ETF | 190.37 | 190.37 | 190.37 | 190.37 | 100.0 |
| 2015-09-30 05:07:00 | SPY | ETF | 190.37 | 190.38 | 190.37 | 190.38 | 225.0 |
| 2015-09-30 05:10:00 | SPY | ETF | 190.36 | 190.36 | 190.36 | 190.36 | 150.0 |
| 2015-09-30 05:12:00 | SPY | ETF | 190.35 | 190.35 | 190.35 | 190.35 | 125.0 |
| 2015-09-30 05:13:00 | SPY | ETF | 190.38 | 190.38 | 190.38 | 190.38 | 300.0 |
| 2015-09-30 05:14:00 | SPY | ETF | 190.44 | 190.44 | 190.44 | 190.44 | 100.0 |
| 2015-09-30 05:16:00 | SPY | ETF | 190.45 | 190.48 | 190.45 | 190.48 | 800.0 |
| 2015-09-30 05:17:00 | SPY | ETF | 190.5 | 190.51 | 190.5 | 190.51 | 389.0 |
| 2015-09-30 05:18:00 | SPY | ETF | 190.39 | 190.45 | 190.39 | 190.45 | 1600.0 |
| 2015-09-30 05:19:00 | SPY | ETF | 190.4 | 190.42 | 190.4 | 190.42 | 500.0 |
| 2015-09-30 05:21:00 | SPY | ETF | 190.33 | 190.35 | 190.33 | 190.33 | 6869.0 |
| 2015-09-30 05:22:00 | SPY | ETF | 190.34 | 190.37 | 190.34 | 190.37 | 1600.0 |
| 2015-09-30 05:23:00 | SPY | ETF | 190.34 | 190.34 | 190.34 | 190.34 | 100.0 |
| 2015-09-30 05:26:00 | SPY | ETF | 190.3 | 190.3 | 190.3 | 190.3 | 3500.0 |
| 2015-09-30 05:27:00 | SPY | ETF | 190.33 | 190.33 | 190.33 | 190.33 | 3530.0 |
| 2015-09-30 05:28:00 | SPY | ETF | 190.39 | 190.39 | 190.39 | 190.39 | 100.0 |
| 2015-09-30 05:32:00 | SPY | ETF | 190.4 | 190.4 | 190.4 | 190.4 | 200.0 |
| 2015-09-30 05:33:00 | SPY | ETF | 190.35 | 190.35 | 190.35 | 190.35 | 2500.0 |
| 2015-09-30 05:36:00 | SPY | ETF | 190.37 | 190.4 | 190.37 | 190.4 | 1925.0 |
> showing 50 of 139,428 rows — these rows as CSV