PREVIEW / etf_5min / 2017-05-10
file: by_date/etf_5min/2017/2017-05-10.parquet size: 1.2 MB rows: 52,808
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-05-10 04:05:00 | SPY | ETF | 239.02 | 239.02 | 239.0 | 239.0 | 975.0 |
| 2017-05-10 04:15:00 | SPY | ETF | 239.0 | 239.0 | 239.0 | 239.0 | 810.0 |
| 2017-05-10 04:20:00 | SPY | ETF | 239.0 | 239.0 | 239.0 | 239.0 | 100.0 |
| 2017-05-10 04:25:00 | SPY | ETF | 239.0 | 239.0 | 239.0 | 239.0 | 936.0 |
| 2017-05-10 04:35:00 | SPY | ETF | 239.05 | 239.05 | 239.05 | 239.05 | 1000.0 |
| 2017-05-10 04:50:00 | SPY | ETF | 239.08 | 239.08 | 239.08 | 239.08 | 500.0 |
| 2017-05-10 05:00:00 | SPY | ETF | 239.08 | 239.08 | 239.03 | 239.03 | 300.0 |
| 2017-05-10 05:10:00 | SPY | ETF | 239.07 | 239.07 | 239.07 | 239.07 | 300.0 |
| 2017-05-10 05:15:00 | SPY | ETF | 239.12 | 239.14 | 239.12 | 239.14 | 2602.0 |
| 2017-05-10 05:25:00 | SPY | ETF | 239.13 | 239.14 | 239.13 | 239.14 | 201.0 |
| 2017-05-10 05:30:00 | SPY | ETF | 239.07 | 239.07 | 239.05 | 239.07 | 613.0 |
| 2017-05-10 05:55:00 | SPY | ETF | 239.11 | 239.11 | 239.11 | 239.11 | 400.0 |
| 2017-05-10 06:00:00 | SPY | ETF | 239.13 | 239.13 | 239.13 | 239.13 | 100.0 |
| 2017-05-10 06:10:00 | SPY | ETF | 239.17 | 239.17 | 239.17 | 239.17 | 2634.0 |
| 2017-05-10 06:15:00 | SPY | ETF | 239.14 | 239.14 | 239.14 | 239.14 | 300.0 |
| 2017-05-10 06:30:00 | SPY | ETF | 239.12 | 239.12 | 239.1 | 239.1 | 2050.0 |
| 2017-05-10 06:40:00 | SPY | ETF | 239.11 | 239.12 | 239.1 | 239.12 | 2901.0 |
| 2017-05-10 06:45:00 | SPY | ETF | 239.09 | 239.09 | 239.09 | 239.09 | 400.0 |
| 2017-05-10 06:50:00 | SPY | ETF | 239.08 | 239.08 | 239.08 | 239.08 | 2000.0 |
| 2017-05-10 06:55:00 | SPY | ETF | 239.08 | 239.08 | 239.05 | 239.05 | 3500.0 |
| 2017-05-10 07:00:00 | SPY | ETF | 239.12 | 239.12 | 239.05 | 239.08 | 4304.0 |
| 2017-05-10 07:05:00 | SPY | ETF | 239.09 | 239.09 | 239.08 | 239.09 | 21900.0 |
| 2017-05-10 07:10:00 | SPY | ETF | 239.09 | 239.1 | 239.05 | 239.07 | 11846.0 |
| 2017-05-10 07:15:00 | SPY | ETF | 239.1 | 239.1 | 239.1 | 239.1 | 300.0 |
| 2017-05-10 07:20:00 | SPY | ETF | 239.12 | 239.12 | 239.12 | 239.12 | 1477.0 |
| 2017-05-10 07:25:00 | SPY | ETF | 239.14 | 239.17 | 239.14 | 239.17 | 2814.0 |
| 2017-05-10 07:30:00 | SPY | ETF | 239.2 | 239.2 | 239.2 | 239.2 | 820.0 |
| 2017-05-10 07:35:00 | SPY | ETF | 239.18 | 239.2 | 239.18 | 239.2 | 2520.0 |
| 2017-05-10 07:40:00 | SPY | ETF | 239.2 | 239.23 | 239.2 | 239.23 | 4140.0 |
| 2017-05-10 07:45:00 | SPY | ETF | 239.23 | 239.31 | 239.23 | 239.3 | 64812.0 |
| 2017-05-10 07:50:00 | SPY | ETF | 239.3 | 239.3 | 239.24 | 239.25 | 89433.0 |
| 2017-05-10 07:55:00 | SPY | ETF | 239.27 | 239.28 | 239.26 | 239.28 | 1100.0 |
| 2017-05-10 08:00:00 | SPY | ETF | 239.26 | 239.28 | 239.08 | 239.28 | 29830.0 |
| 2017-05-10 08:05:00 | SPY | ETF | 239.28 | 239.3 | 239.28 | 239.29 | 1602.0 |
| 2017-05-10 08:10:00 | SPY | ETF | 239.29 | 239.34 | 239.29 | 239.3 | 8300.0 |
| 2017-05-10 08:15:00 | SPY | ETF | 239.3 | 239.38 | 239.3 | 239.36 | 19067.0 |
| 2017-05-10 08:20:00 | SPY | ETF | 239.36 | 239.39 | 239.35 | 239.36 | 17565.0 |
| 2017-05-10 08:25:00 | SPY | ETF | 239.36 | 239.36 | 239.34 | 239.36 | 12128.0 |
| 2017-05-10 08:30:00 | SPY | ETF | 239.36 | 239.43 | 239.36 | 239.43 | 129342.0 |
| 2017-05-10 08:35:00 | SPY | ETF | 239.43 | 239.43 | 239.37 | 239.39 | 7279.0 |
| 2017-05-10 08:40:00 | SPY | ETF | 239.39 | 239.43 | 239.39 | 239.43 | 12868.0 |
| 2017-05-10 08:45:00 | SPY | ETF | 239.41 | 239.41 | 239.37 | 239.37 | 17026.0 |
| 2017-05-10 08:50:00 | SPY | ETF | 239.37 | 239.4 | 239.37 | 239.37 | 4923.0 |
| 2017-05-10 08:55:00 | SPY | ETF | 239.4 | 239.4 | 239.33 | 239.33 | 4566.0 |
| 2017-05-10 09:00:00 | SPY | ETF | 239.33 | 239.34 | 239.24 | 239.24 | 21979.0 |
| 2017-05-10 09:05:00 | SPY | ETF | 239.25 | 239.29 | 239.24 | 239.25 | 1867982.0 |
| 2017-05-10 09:10:00 | SPY | ETF | 239.25 | 239.29 | 239.24 | 239.27 | 30228.0 |
| 2017-05-10 09:15:00 | SPY | ETF | 239.26 | 239.34 | 239.24 | 239.34 | 11883.0 |
| 2017-05-10 09:20:00 | SPY | ETF | 239.34 | 239.35 | 239.32 | 239.34 | 15793.0 |
| 2017-05-10 09:25:00 | SPY | ETF | 239.35 | 239.38 | 239.35 | 239.38 | 40169.0 |
> showing 50 of 52,808 rows — these rows as CSV