PREVIEW / etf_5min / 2013-11-11
file: by_date/etf_5min/2013/2013-11-11.parquet size: 880 KB rows: 38,637
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-11 04:00:00 | SPY | ETF | 176.94 | 176.94 | 176.91 | 176.91 | 836.0 |
| 2013-11-11 04:05:00 | SPY | ETF | 176.91 | 176.95 | 176.91 | 176.95 | 3640.0 |
| 2013-11-11 04:10:00 | SPY | ETF | 176.99 | 176.99 | 176.99 | 176.99 | 300.0 |
| 2013-11-11 04:15:00 | SPY | ETF | 177.01 | 177.04 | 177.01 | 177.04 | 500.0 |
| 2013-11-11 04:20:00 | SPY | ETF | 177.07 | 177.1 | 177.05 | 177.1 | 1009.0 |
| 2013-11-11 04:30:00 | SPY | ETF | 177.05 | 177.05 | 177.02 | 177.02 | 800.0 |
| 2013-11-11 04:35:00 | SPY | ETF | 177.07 | 177.07 | 177.07 | 177.07 | 300.0 |
| 2013-11-11 04:40:00 | SPY | ETF | 177.06 | 177.06 | 177.06 | 177.06 | 100.0 |
| 2013-11-11 04:45:00 | SPY | ETF | 177.07 | 177.07 | 177.07 | 177.07 | 2500.0 |
| 2013-11-11 04:55:00 | SPY | ETF | 177.11 | 177.11 | 177.11 | 177.11 | 200.0 |
| 2013-11-11 05:00:00 | SPY | ETF | 177.09 | 177.1 | 177.09 | 177.1 | 202.0 |
| 2013-11-11 05:05:00 | SPY | ETF | 177.11 | 177.15 | 177.11 | 177.14 | 1158.0 |
| 2013-11-11 05:10:00 | SPY | ETF | 177.14 | 177.16 | 177.14 | 177.16 | 4400.0 |
| 2013-11-11 05:15:00 | SPY | ETF | 177.16 | 177.16 | 177.16 | 177.16 | 4000.0 |
| 2013-11-11 05:20:00 | SPY | ETF | 177.19 | 177.27 | 177.19 | 177.27 | 2400.0 |
| 2013-11-11 05:25:00 | SPY | ETF | 177.27 | 177.27 | 177.27 | 177.27 | 2800.0 |
| 2013-11-11 05:30:00 | SPY | ETF | 177.27 | 177.27 | 177.27 | 177.27 | 19120.0 |
| 2013-11-11 05:35:00 | SPY | ETF | 177.28 | 177.28 | 177.28 | 177.28 | 10000.0 |
| 2013-11-11 05:40:00 | SPY | ETF | 177.28 | 177.3 | 177.28 | 177.29 | 17150.0 |
| 2013-11-11 05:45:00 | SPY | ETF | 177.3 | 177.35 | 177.3 | 177.33 | 2580.0 |
| 2013-11-11 05:50:00 | SPY | ETF | 177.29 | 177.29 | 177.29 | 177.29 | 200.0 |
| 2013-11-11 06:00:00 | SPY | ETF | 177.26 | 177.26 | 177.26 | 177.26 | 1000.0 |
| 2013-11-11 06:05:00 | SPY | ETF | 177.24 | 177.24 | 177.24 | 177.24 | 1000.0 |
| 2013-11-11 06:10:00 | SPY | ETF | 177.25 | 177.25 | 177.25 | 177.25 | 1000.0 |
| 2013-11-11 06:30:00 | SPY | ETF | 177.24 | 177.24 | 177.21 | 177.21 | 5200.0 |
| 2013-11-11 06:35:00 | SPY | ETF | 177.19 | 177.19 | 177.17 | 177.19 | 16800.0 |
| 2013-11-11 06:40:00 | SPY | ETF | 177.17 | 177.18 | 177.17 | 177.18 | 700.0 |
| 2013-11-11 06:45:00 | SPY | ETF | 177.19 | 177.19 | 177.19 | 177.19 | 300.0 |
| 2013-11-11 06:50:00 | SPY | ETF | 177.19 | 177.24 | 177.19 | 177.21 | 12900.0 |
| 2013-11-11 06:55:00 | SPY | ETF | 177.19 | 177.19 | 177.14 | 177.18 | 13198.0 |
| 2013-11-11 07:00:00 | SPY | ETF | 177.13 | 177.19 | 177.12 | 177.19 | 18450.0 |
| 2013-11-11 07:05:00 | SPY | ETF | 177.16 | 177.16 | 177.16 | 177.16 | 6900.0 |
| 2013-11-11 07:10:00 | SPY | ETF | 177.14 | 177.14 | 177.14 | 177.14 | 400.0 |
| 2013-11-11 07:15:00 | SPY | ETF | 177.16 | 177.18 | 177.16 | 177.18 | 1100.0 |
| 2013-11-11 07:20:00 | SPY | ETF | 177.17 | 177.19 | 177.16 | 177.19 | 55500.0 |
| 2013-11-11 07:25:00 | SPY | ETF | 177.2 | 177.23 | 177.2 | 177.21 | 8560.0 |
| 2013-11-11 07:30:00 | SPY | ETF | 177.23 | 177.25 | 177.23 | 177.23 | 9200.0 |
| 2013-11-11 07:35:00 | SPY | ETF | 177.25 | 177.31 | 177.25 | 177.27 | 24880.0 |
| 2013-11-11 07:40:00 | SPY | ETF | 177.31 | 177.31 | 177.27 | 177.27 | 11300.0 |
| 2013-11-11 07:45:00 | SPY | ETF | 177.29 | 177.38 | 177.29 | 177.34 | 22317.0 |
| 2013-11-11 07:50:00 | SPY | ETF | 177.34 | 177.36 | 177.34 | 177.36 | 59200.0 |
| 2013-11-11 07:55:00 | SPY | ETF | 177.35 | 177.36 | 177.33 | 177.33 | 31500.0 |
| 2013-11-11 08:00:00 | SPY | ETF | 177.32 | 177.38 | 177.15 | 177.32 | 71353.0 |
| 2013-11-11 08:05:00 | SPY | ETF | 177.32 | 177.33 | 177.31 | 177.33 | 53900.0 |
| 2013-11-11 08:10:00 | SPY | ETF | 177.3 | 177.33 | 177.3 | 177.31 | 2500.0 |
| 2013-11-11 08:15:00 | SPY | ETF | 177.3 | 177.32 | 177.3 | 177.31 | 11017.0 |
| 2013-11-11 08:20:00 | SPY | ETF | 177.31 | 177.33 | 177.31 | 177.31 | 34533.0 |
| 2013-11-11 08:25:00 | SPY | ETF | 177.3 | 177.3 | 177.24 | 177.24 | 23211.0 |
| 2013-11-11 08:30:00 | SPY | ETF | 177.27 | 177.28 | 177.23 | 177.23 | 15100.0 |
| 2013-11-11 08:35:00 | SPY | ETF | 177.22 | 177.25 | 177.18 | 177.18 | 89850.0 |
> showing 50 of 38,637 rows — these rows as CSV