PREVIEW / etf_5min / 2014-05-22
file: by_date/etf_5min/2014/2014-05-22.parquet size: 937 KB rows: 40,344
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-05-22 04:00:00 | SPY | ETF | 189.23 | 189.28 | 189.22 | 189.28 | 2590.0 |
| 2014-05-22 04:15:00 | SPY | ETF | 189.25 | 189.25 | 189.25 | 189.25 | 500.0 |
| 2014-05-22 04:20:00 | SPY | ETF | 189.25 | 189.25 | 189.25 | 189.25 | 100.0 |
| 2014-05-22 04:30:00 | SPY | ETF | 189.31 | 189.31 | 189.31 | 189.31 | 243.0 |
| 2014-05-22 04:35:00 | SPY | ETF | 189.36 | 189.37 | 189.36 | 189.36 | 1200.0 |
| 2014-05-22 04:40:00 | SPY | ETF | 189.35 | 189.35 | 189.35 | 189.35 | 200.0 |
| 2014-05-22 04:50:00 | SPY | ETF | 189.29 | 189.29 | 189.29 | 189.29 | 100.0 |
| 2014-05-22 04:55:00 | SPY | ETF | 189.27 | 189.29 | 189.27 | 189.29 | 513.0 |
| 2014-05-22 05:10:00 | SPY | ETF | 189.19 | 189.19 | 189.19 | 189.19 | 200.0 |
| 2014-05-22 05:15:00 | SPY | ETF | 189.17 | 189.19 | 189.17 | 189.19 | 2050.0 |
| 2014-05-22 05:25:00 | SPY | ETF | 189.24 | 189.24 | 189.24 | 189.24 | 200.0 |
| 2014-05-22 05:35:00 | SPY | ETF | 189.16 | 189.39 | 189.16 | 189.27 | 2700.0 |
| 2014-05-22 05:50:00 | SPY | ETF | 189.23 | 189.23 | 189.23 | 189.23 | 600.0 |
| 2014-05-22 06:00:00 | SPY | ETF | 189.19 | 189.19 | 189.15 | 189.15 | 1000.0 |
| 2014-05-22 06:05:00 | SPY | ETF | 189.19 | 189.19 | 189.19 | 189.19 | 700.0 |
| 2014-05-22 06:10:00 | SPY | ETF | 189.23 | 189.31 | 189.23 | 189.31 | 1399.0 |
| 2014-05-22 06:15:00 | SPY | ETF | 189.3 | 189.3 | 189.3 | 189.3 | 200.0 |
| 2014-05-22 06:20:00 | SPY | ETF | 189.27 | 189.27 | 189.27 | 189.27 | 400.0 |
| 2014-05-22 06:25:00 | SPY | ETF | 189.27 | 189.27 | 189.27 | 189.27 | 200.0 |
| 2014-05-22 06:30:00 | SPY | ETF | 189.24 | 189.24 | 189.2 | 189.2 | 862.0 |
| 2014-05-22 06:35:00 | SPY | ETF | 189.22 | 189.22 | 189.18 | 189.19 | 1088.0 |
| 2014-05-22 06:40:00 | SPY | ETF | 189.23 | 189.25 | 189.23 | 189.25 | 2400.0 |
| 2014-05-22 06:45:00 | SPY | ETF | 189.25 | 189.26 | 189.25 | 189.26 | 1449.0 |
| 2014-05-22 06:50:00 | SPY | ETF | 189.27 | 189.3 | 189.19 | 189.22 | 54590.0 |
| 2014-05-22 06:55:00 | SPY | ETF | 189.21 | 189.22 | 189.17 | 189.17 | 598.0 |
| 2014-05-22 07:00:00 | SPY | ETF | 189.17 | 189.17 | 189.16 | 189.17 | 1525.0 |
| 2014-05-22 07:05:00 | SPY | ETF | 189.18 | 189.18 | 189.12 | 189.12 | 3721.0 |
| 2014-05-22 07:10:00 | SPY | ETF | 189.15 | 189.16 | 189.11 | 189.11 | 1201.0 |
| 2014-05-22 07:15:00 | SPY | ETF | 189.14 | 189.14 | 189.14 | 189.14 | 353.0 |
| 2014-05-22 07:20:00 | SPY | ETF | 189.12 | 189.15 | 189.1 | 189.1 | 5700.0 |
| 2014-05-22 07:25:00 | SPY | ETF | 189.1 | 189.12 | 189.08 | 189.12 | 26576.0 |
| 2014-05-22 07:30:00 | SPY | ETF | 189.12 | 189.14 | 189.12 | 189.14 | 6500.0 |
| 2014-05-22 07:35:00 | SPY | ETF | 189.15 | 189.17 | 189.12 | 189.12 | 11912.0 |
| 2014-05-22 07:40:00 | SPY | ETF | 189.11 | 189.11 | 189.03 | 189.04 | 4552.0 |
| 2014-05-22 07:45:00 | SPY | ETF | 189.02 | 189.07 | 189.01 | 189.07 | 6212.0 |
| 2014-05-22 07:50:00 | SPY | ETF | 189.07 | 189.11 | 189.05 | 189.11 | 61768.0 |
| 2014-05-22 07:55:00 | SPY | ETF | 189.1 | 189.15 | 189.1 | 189.15 | 9200.0 |
| 2014-05-22 08:00:00 | SPY | ETF | 189.12 | 189.14 | 189.04 | 189.11 | 15891.0 |
| 2014-05-22 08:05:00 | SPY | ETF | 189.11 | 189.13 | 189.1 | 189.11 | 12300.0 |
| 2014-05-22 08:10:00 | SPY | ETF | 189.13 | 189.14 | 189.11 | 189.14 | 9505.0 |
| 2014-05-22 08:15:00 | SPY | ETF | 189.14 | 189.27 | 189.12 | 189.24 | 81050.0 |
| 2014-05-22 08:20:00 | SPY | ETF | 189.25 | 189.27 | 189.2 | 189.22 | 16067.0 |
| 2014-05-22 08:25:00 | SPY | ETF | 189.23 | 189.47 | 189.23 | 189.29 | 111979.0 |
| 2014-05-22 08:30:00 | SPY | ETF | 189.28 | 189.28 | 189.11 | 189.12 | 79679.0 |
| 2014-05-22 08:35:00 | SPY | ETF | 189.12 | 189.19 | 189.12 | 189.18 | 15861.0 |
| 2014-05-22 08:40:00 | SPY | ETF | 189.19 | 189.19 | 189.12 | 189.14 | 19342.0 |
| 2014-05-22 08:45:00 | SPY | ETF | 189.15 | 189.18 | 189.08 | 189.13 | 23944.0 |
| 2014-05-22 08:50:00 | SPY | ETF | 189.14 | 189.16 | 189.09 | 189.16 | 8698.0 |
| 2014-05-22 08:55:00 | SPY | ETF | 189.16 | 189.21 | 189.14 | 189.2 | 92364.0 |
| 2014-05-22 09:00:00 | SPY | ETF | 189.18 | 189.18 | 189.14 | 189.14 | 117538.0 |
> showing 50 of 40,344 rows — these rows as CSV