PREVIEW / etf_5min / 2012-11-05
file: by_date/etf_5min/2012/2012-11-05.parquet size: 832 KB rows: 35,089
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-05 04:10:00 | SPY | ETF | 141.16 | 141.16 | 141.14 | 141.14 | 2300.0 |
| 2012-11-05 04:15:00 | SPY | ETF | 141.16 | 141.17 | 141.16 | 141.17 | 400.0 |
| 2012-11-05 04:20:00 | SPY | ETF | 141.18 | 141.18 | 141.18 | 141.18 | 100.0 |
| 2012-11-05 04:30:00 | SPY | ETF | 141.23 | 141.23 | 141.23 | 141.23 | 100.0 |
| 2012-11-05 04:35:00 | SPY | ETF | 141.26 | 141.26 | 141.18 | 141.18 | 2240.0 |
| 2012-11-05 04:40:00 | SPY | ETF | 141.14 | 141.14 | 141.12 | 141.12 | 1500.0 |
| 2012-11-05 05:00:00 | SPY | ETF | 141.09 | 141.09 | 141.05 | 141.05 | 600.0 |
| 2012-11-05 05:05:00 | SPY | ETF | 141.02 | 141.02 | 141.0 | 141.02 | 5600.0 |
| 2012-11-05 05:10:00 | SPY | ETF | 141.03 | 141.06 | 141.03 | 141.06 | 3260.0 |
| 2012-11-05 05:15:00 | SPY | ETF | 141.07 | 141.07 | 141.07 | 141.07 | 5000.0 |
| 2012-11-05 05:25:00 | SPY | ETF | 141.04 | 141.07 | 141.04 | 141.07 | 15100.0 |
| 2012-11-05 05:30:00 | SPY | ETF | 141.07 | 141.09 | 141.07 | 141.07 | 8400.0 |
| 2012-11-05 05:35:00 | SPY | ETF | 141.07 | 141.09 | 141.07 | 141.09 | 5200.0 |
| 2012-11-05 05:40:00 | SPY | ETF | 141.13 | 141.13 | 141.12 | 141.12 | 13000.0 |
| 2012-11-05 05:45:00 | SPY | ETF | 141.19 | 141.25 | 141.19 | 141.22 | 29691.0 |
| 2012-11-05 05:50:00 | SPY | ETF | 141.22 | 141.22 | 141.22 | 141.22 | 1475.0 |
| 2012-11-05 05:55:00 | SPY | ETF | 141.3 | 141.3 | 141.3 | 141.3 | 15000.0 |
| 2012-11-05 06:00:00 | SPY | ETF | 141.34 | 141.35 | 141.32 | 141.32 | 8000.0 |
| 2012-11-05 06:05:00 | SPY | ETF | 141.35 | 141.35 | 141.35 | 141.35 | 5000.0 |
| 2012-11-05 06:15:00 | SPY | ETF | 141.32 | 141.32 | 141.31 | 141.31 | 5000.0 |
| 2012-11-05 06:20:00 | SPY | ETF | 141.28 | 141.3 | 141.2 | 141.2 | 600.0 |
| 2012-11-05 06:25:00 | SPY | ETF | 141.15 | 141.18 | 141.14 | 141.14 | 5600.0 |
| 2012-11-05 06:30:00 | SPY | ETF | 141.17 | 141.22 | 141.17 | 141.22 | 200.0 |
| 2012-11-05 06:35:00 | SPY | ETF | 141.29 | 141.29 | 141.27 | 141.27 | 200.0 |
| 2012-11-05 06:40:00 | SPY | ETF | 141.23 | 141.23 | 141.15 | 141.15 | 750.0 |
| 2012-11-05 06:45:00 | SPY | ETF | 141.13 | 141.15 | 141.13 | 141.13 | 5560.0 |
| 2012-11-05 06:50:00 | SPY | ETF | 141.09 | 141.09 | 141.09 | 141.09 | 1199.0 |
| 2012-11-05 06:55:00 | SPY | ETF | 141.15 | 141.19 | 141.15 | 141.19 | 600.0 |
| 2012-11-05 07:00:00 | SPY | ETF | 141.22 | 141.22 | 141.19 | 141.22 | 2200.0 |
| 2012-11-05 07:05:00 | SPY | ETF | 141.23 | 141.23 | 141.19 | 141.19 | 1800.0 |
| 2012-11-05 07:10:00 | SPY | ETF | 141.15 | 141.18 | 141.12 | 141.15 | 13350.0 |
| 2012-11-05 07:15:00 | SPY | ETF | 141.13 | 141.13 | 141.07 | 141.07 | 6444.0 |
| 2012-11-05 07:20:00 | SPY | ETF | 141.06 | 141.09 | 141.02 | 141.09 | 10026.0 |
| 2012-11-05 07:25:00 | SPY | ETF | 141.1 | 141.1 | 141.08 | 141.08 | 16290.0 |
| 2012-11-05 07:30:00 | SPY | ETF | 141.1 | 141.1 | 140.94 | 140.98 | 11089.0 |
| 2012-11-05 07:35:00 | SPY | ETF | 140.98 | 141.01 | 140.93 | 141.0 | 21059.0 |
| 2012-11-05 07:40:00 | SPY | ETF | 141.01 | 141.01 | 141.0 | 141.0 | 5550.0 |
| 2012-11-05 07:45:00 | SPY | ETF | 141.02 | 141.08 | 141.02 | 141.04 | 34490.0 |
| 2012-11-05 07:50:00 | SPY | ETF | 141.06 | 141.08 | 141.04 | 141.08 | 28700.0 |
| 2012-11-05 07:55:00 | SPY | ETF | 141.08 | 141.1 | 141.05 | 141.1 | 12720.0 |
| 2012-11-05 08:00:00 | SPY | ETF | 141.1 | 141.12 | 141.05 | 141.09 | 51730.0 |
| 2012-11-05 08:05:00 | SPY | ETF | 141.1 | 141.1 | 141.07 | 141.09 | 14370.0 |
| 2012-11-05 08:10:00 | SPY | ETF | 141.1 | 141.13 | 141.08 | 141.11 | 14750.0 |
| 2012-11-05 08:15:00 | SPY | ETF | 141.13 | 141.15 | 141.08 | 141.1 | 87243.0 |
| 2012-11-05 08:20:00 | SPY | ETF | 141.08 | 141.1 | 140.96 | 140.98 | 49716.0 |
| 2012-11-05 08:25:00 | SPY | ETF | 140.98 | 141.05 | 140.98 | 141.02 | 27540.0 |
| 2012-11-05 08:30:00 | SPY | ETF | 141.0 | 141.23 | 141.0 | 141.11 | 167628.0 |
| 2012-11-05 08:35:00 | SPY | ETF | 141.1 | 141.2 | 141.09 | 141.18 | 91301.0 |
| 2012-11-05 08:40:00 | SPY | ETF | 141.15 | 141.31 | 141.15 | 141.28 | 190385.0 |
| 2012-11-05 08:45:00 | SPY | ETF | 141.28 | 141.37 | 141.28 | 141.31 | 155758.0 |
> showing 50 of 35,089 rows — these rows as CSV