PREVIEW / etf_1min / 2017-01-30
file: by_date/etf_1min/2017/2017-01-30.parquet size: 3.0 MB rows: 152,348
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-01-30 04:00:00 | SPY | ETF | 228.59 | 228.59 | 228.41 | 228.41 | 1125.0 |
| 2017-01-30 04:01:00 | SPY | ETF | 228.41 | 228.44 | 228.35 | 228.44 | 1029.0 |
| 2017-01-30 04:03:00 | SPY | ETF | 228.29 | 228.29 | 228.29 | 228.29 | 100.0 |
| 2017-01-30 04:04:00 | SPY | ETF | 228.39 | 228.47 | 228.39 | 228.39 | 500.0 |
| 2017-01-30 04:05:00 | SPY | ETF | 228.39 | 228.39 | 228.39 | 228.39 | 500.0 |
| 2017-01-30 04:06:00 | SPY | ETF | 228.34 | 228.34 | 228.32 | 228.32 | 300.0 |
| 2017-01-30 04:07:00 | SPY | ETF | 228.32 | 228.32 | 228.32 | 228.32 | 8750.0 |
| 2017-01-30 04:21:00 | SPY | ETF | 228.48 | 228.48 | 228.48 | 228.48 | 300.0 |
| 2017-01-30 04:25:00 | SPY | ETF | 228.38 | 228.38 | 228.38 | 228.38 | 300.0 |
| 2017-01-30 04:27:00 | SPY | ETF | 228.38 | 228.38 | 228.38 | 228.38 | 300.0 |
| 2017-01-30 04:28:00 | SPY | ETF | 228.4 | 228.4 | 228.4 | 228.4 | 200.0 |
| 2017-01-30 04:30:00 | SPY | ETF | 228.43 | 228.43 | 228.43 | 228.43 | 300.0 |
| 2017-01-30 04:43:00 | SPY | ETF | 228.43 | 228.43 | 228.43 | 228.43 | 100.0 |
| 2017-01-30 04:46:00 | SPY | ETF | 228.37 | 228.37 | 228.37 | 228.37 | 100.0 |
| 2017-01-30 04:50:00 | SPY | ETF | 228.32 | 228.32 | 228.31 | 228.31 | 2003.0 |
| 2017-01-30 04:52:00 | SPY | ETF | 228.31 | 228.31 | 228.31 | 228.31 | 600.0 |
| 2017-01-30 04:59:00 | SPY | ETF | 228.36 | 228.36 | 228.36 | 228.36 | 500.0 |
| 2017-01-30 05:00:00 | SPY | ETF | 228.35 | 228.35 | 228.33 | 228.33 | 1000.0 |
| 2017-01-30 05:01:00 | SPY | ETF | 228.33 | 228.33 | 228.33 | 228.33 | 100.0 |
| 2017-01-30 05:02:00 | SPY | ETF | 228.33 | 228.33 | 228.33 | 228.33 | 700.0 |
| 2017-01-30 05:03:00 | SPY | ETF | 228.36 | 228.36 | 228.36 | 228.36 | 201.0 |
| 2017-01-30 05:07:00 | SPY | ETF | 228.35 | 228.35 | 228.33 | 228.33 | 700.0 |
| 2017-01-30 05:08:00 | SPY | ETF | 228.31 | 228.31 | 228.31 | 228.31 | 210.0 |
| 2017-01-30 05:09:00 | SPY | ETF | 228.31 | 228.31 | 228.31 | 228.31 | 300.0 |
| 2017-01-30 05:10:00 | SPY | ETF | 228.31 | 228.31 | 228.31 | 228.31 | 1000.0 |
| 2017-01-30 05:11:00 | SPY | ETF | 228.34 | 228.34 | 228.34 | 228.34 | 400.0 |
| 2017-01-30 05:15:00 | SPY | ETF | 228.35 | 228.35 | 228.35 | 228.35 | 100.0 |
| 2017-01-30 05:24:00 | SPY | ETF | 228.33 | 228.33 | 228.33 | 228.33 | 301.0 |
| 2017-01-30 05:29:00 | SPY | ETF | 228.38 | 228.38 | 228.38 | 228.38 | 379.0 |
| 2017-01-30 05:35:00 | SPY | ETF | 228.4 | 228.4 | 228.4 | 228.4 | 100.0 |
| 2017-01-30 05:36:00 | SPY | ETF | 228.38 | 228.38 | 228.38 | 228.38 | 400.0 |
| 2017-01-30 05:38:00 | SPY | ETF | 228.33 | 228.33 | 228.33 | 228.33 | 410.0 |
| 2017-01-30 05:50:00 | SPY | ETF | 228.38 | 228.38 | 228.38 | 228.38 | 500.0 |
| 2017-01-30 05:52:00 | SPY | ETF | 228.38 | 228.38 | 228.38 | 228.38 | 500.0 |
| 2017-01-30 05:56:00 | SPY | ETF | 228.4 | 228.4 | 228.34 | 228.34 | 700.0 |
| 2017-01-30 05:57:00 | SPY | ETF | 228.34 | 228.34 | 228.34 | 228.34 | 500.0 |
| 2017-01-30 05:59:00 | SPY | ETF | 228.31 | 228.31 | 228.31 | 228.31 | 300.0 |
| 2017-01-30 06:00:00 | SPY | ETF | 228.35 | 228.35 | 228.35 | 228.35 | 200.0 |
| 2017-01-30 06:01:00 | SPY | ETF | 228.31 | 228.31 | 228.31 | 228.31 | 300.0 |
| 2017-01-30 06:06:00 | SPY | ETF | 228.32 | 228.32 | 228.31 | 228.31 | 500.0 |
| 2017-01-30 06:11:00 | SPY | ETF | 228.32 | 228.32 | 228.32 | 228.32 | 2051.0 |
| 2017-01-30 06:13:00 | SPY | ETF | 228.35 | 228.35 | 228.35 | 228.35 | 200.0 |
| 2017-01-30 06:21:00 | SPY | ETF | 228.39 | 228.4 | 228.39 | 228.4 | 3501.0 |
| 2017-01-30 06:23:00 | SPY | ETF | 228.39 | 228.39 | 228.39 | 228.39 | 500.0 |
| 2017-01-30 06:25:00 | SPY | ETF | 228.39 | 228.39 | 228.39 | 228.39 | 999.0 |
| 2017-01-30 06:31:00 | SPY | ETF | 228.37 | 228.37 | 228.36 | 228.36 | 746.0 |
| 2017-01-30 06:36:00 | SPY | ETF | 228.4 | 228.4 | 228.38 | 228.38 | 300.0 |
| 2017-01-30 06:41:00 | SPY | ETF | 228.37 | 228.37 | 228.33 | 228.33 | 905.0 |
| 2017-01-30 06:42:00 | SPY | ETF | 228.35 | 228.35 | 228.35 | 228.35 | 300.0 |
| 2017-01-30 06:43:00 | SPY | ETF | 228.33 | 228.33 | 228.33 | 228.33 | 4500.0 |
> showing 50 of 152,348 rows — these rows as CSV