PREVIEW / etf_5min / 2013-11-19
file: by_date/etf_5min/2013/2013-11-19.parquet size: 981 KB rows: 41,436
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-19 04:00:00 | SPY | ETF | 179.22 | 179.22 | 179.09 | 179.19 | 10499.0 |
| 2013-11-19 04:05:00 | SPY | ETF | 179.19 | 179.27 | 179.19 | 179.27 | 3350.0 |
| 2013-11-19 04:10:00 | SPY | ETF | 179.28 | 179.32 | 179.24 | 179.24 | 3200.0 |
| 2013-11-19 04:20:00 | SPY | ETF | 179.22 | 179.23 | 179.22 | 179.23 | 1600.0 |
| 2013-11-19 04:25:00 | SPY | ETF | 179.19 | 179.19 | 179.19 | 179.19 | 1300.0 |
| 2013-11-19 04:35:00 | SPY | ETF | 179.2 | 179.22 | 179.17 | 179.21 | 6307.0 |
| 2013-11-19 04:40:00 | SPY | ETF | 179.18 | 179.18 | 179.17 | 179.17 | 4400.0 |
| 2013-11-19 04:45:00 | SPY | ETF | 179.15 | 179.15 | 179.14 | 179.14 | 200.0 |
| 2013-11-19 04:50:00 | SPY | ETF | 179.17 | 179.17 | 179.12 | 179.14 | 1200.0 |
| 2013-11-19 04:55:00 | SPY | ETF | 179.17 | 179.17 | 179.17 | 179.17 | 100.0 |
| 2013-11-19 05:05:00 | SPY | ETF | 179.17 | 179.18 | 179.17 | 179.18 | 549.0 |
| 2013-11-19 05:10:00 | SPY | ETF | 179.13 | 179.13 | 179.03 | 179.07 | 8820.0 |
| 2013-11-19 05:15:00 | SPY | ETF | 179.08 | 179.08 | 179.0 | 179.02 | 5409.0 |
| 2013-11-19 05:20:00 | SPY | ETF | 178.99 | 179.08 | 178.99 | 179.08 | 1800.0 |
| 2013-11-19 05:25:00 | SPY | ETF | 179.07 | 179.07 | 179.05 | 179.05 | 600.0 |
| 2013-11-19 05:30:00 | SPY | ETF | 179.06 | 179.07 | 179.05 | 179.07 | 1400.0 |
| 2013-11-19 05:35:00 | SPY | ETF | 179.1 | 179.1 | 179.09 | 179.09 | 2000.0 |
| 2013-11-19 05:40:00 | SPY | ETF | 179.1 | 179.16 | 179.1 | 179.12 | 4600.0 |
| 2013-11-19 05:45:00 | SPY | ETF | 179.14 | 179.17 | 179.14 | 179.17 | 700.0 |
| 2013-11-19 05:50:00 | SPY | ETF | 179.17 | 179.21 | 179.17 | 179.21 | 27441.0 |
| 2013-11-19 05:55:00 | SPY | ETF | 179.13 | 179.16 | 179.12 | 179.16 | 30692.0 |
| 2013-11-19 06:00:00 | SPY | ETF | 179.15 | 179.19 | 179.15 | 179.18 | 7924.0 |
| 2013-11-19 06:05:00 | SPY | ETF | 179.17 | 179.26 | 179.17 | 179.21 | 30557.0 |
| 2013-11-19 06:10:00 | SPY | ETF | 179.23 | 179.23 | 179.17 | 179.21 | 11299.0 |
| 2013-11-19 06:15:00 | SPY | ETF | 179.2 | 179.23 | 179.17 | 179.23 | 31500.0 |
| 2013-11-19 06:20:00 | SPY | ETF | 179.19 | 179.22 | 179.19 | 179.2 | 6399.0 |
| 2013-11-19 06:25:00 | SPY | ETF | 179.26 | 179.26 | 179.2 | 179.23 | 20100.0 |
| 2013-11-19 06:30:00 | SPY | ETF | 179.23 | 179.24 | 179.22 | 179.24 | 1900.0 |
| 2013-11-19 06:35:00 | SPY | ETF | 179.23 | 179.25 | 179.2 | 179.25 | 1400.0 |
| 2013-11-19 06:40:00 | SPY | ETF | 179.23 | 179.26 | 179.21 | 179.21 | 8010.0 |
| 2013-11-19 06:45:00 | SPY | ETF | 179.2 | 179.2 | 179.14 | 179.14 | 6900.0 |
| 2013-11-19 06:50:00 | SPY | ETF | 179.14 | 179.15 | 179.14 | 179.14 | 1400.0 |
| 2013-11-19 06:55:00 | SPY | ETF | 179.17 | 179.18 | 179.1 | 179.13 | 43261.0 |
| 2013-11-19 07:00:00 | SPY | ETF | 179.13 | 179.15 | 179.12 | 179.14 | 4500.0 |
| 2013-11-19 07:05:00 | SPY | ETF | 179.14 | 179.14 | 179.02 | 179.05 | 74124.0 |
| 2013-11-19 07:10:00 | SPY | ETF | 179.08 | 179.13 | 179.06 | 179.09 | 32255.0 |
| 2013-11-19 07:15:00 | SPY | ETF | 179.12 | 179.16 | 179.12 | 179.13 | 60497.0 |
| 2013-11-19 07:20:00 | SPY | ETF | 179.11 | 179.11 | 178.94 | 178.99 | 98657.0 |
| 2013-11-19 07:25:00 | SPY | ETF | 179.0 | 179.03 | 178.99 | 179.01 | 32885.0 |
| 2013-11-19 07:30:00 | SPY | ETF | 179.0 | 179.03 | 178.98 | 179.03 | 5720.0 |
| 2013-11-19 07:35:00 | SPY | ETF | 179.03 | 179.08 | 179.03 | 179.08 | 18077.0 |
| 2013-11-19 07:40:00 | SPY | ETF | 179.06 | 179.1 | 179.06 | 179.1 | 8200.0 |
| 2013-11-19 07:45:00 | SPY | ETF | 179.1 | 179.1 | 179.09 | 179.09 | 8875.0 |
| 2013-11-19 07:50:00 | SPY | ETF | 179.07 | 179.08 | 179.05 | 179.06 | 6050.0 |
| 2013-11-19 07:55:00 | SPY | ETF | 179.09 | 179.12 | 179.02 | 179.08 | 26555.0 |
| 2013-11-19 08:00:00 | SPY | ETF | 179.07 | 179.14 | 178.96 | 179.1 | 19210.0 |
| 2013-11-19 08:05:00 | SPY | ETF | 179.11 | 179.13 | 179.1 | 179.13 | 33350.0 |
| 2013-11-19 08:10:00 | SPY | ETF | 179.12 | 179.13 | 179.07 | 179.1 | 28664.0 |
| 2013-11-19 08:15:00 | SPY | ETF | 179.1 | 179.15 | 179.1 | 179.12 | 11694.0 |
| 2013-11-19 08:20:00 | SPY | ETF | 179.12 | 179.18 | 179.12 | 179.15 | 9425.0 |
> showing 50 of 41,436 rows — these rows as CSV