PREVIEW / etf_5min / 2012-10-10
file: by_date/etf_5min/2012/2012-10-10.parquet size: 851 KB rows: 35,667
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-10-10 04:20:00 | SPY | ETF | 144.23 | 144.23 | 144.22 | 144.22 | 3400.0 |
| 2012-10-10 04:30:00 | SPY | ETF | 144.2 | 144.2 | 144.2 | 144.2 | 200.0 |
| 2012-10-10 04:35:00 | SPY | ETF | 144.07 | 144.07 | 144.07 | 144.07 | 200.0 |
| 2012-10-10 04:45:00 | SPY | ETF | 144.15 | 144.15 | 144.15 | 144.15 | 100.0 |
| 2012-10-10 04:55:00 | SPY | ETF | 144.2 | 144.2 | 144.2 | 144.2 | 100.0 |
| 2012-10-10 05:00:00 | SPY | ETF | 144.15 | 144.15 | 144.15 | 144.15 | 20000.0 |
| 2012-10-10 05:05:00 | SPY | ETF | 144.01 | 144.01 | 144.01 | 144.01 | 1000.0 |
| 2012-10-10 05:10:00 | SPY | ETF | 143.99 | 144.01 | 143.95 | 144.01 | 43500.0 |
| 2012-10-10 05:15:00 | SPY | ETF | 144.0 | 144.0 | 143.96 | 144.0 | 31000.0 |
| 2012-10-10 05:20:00 | SPY | ETF | 144.02 | 144.02 | 143.98 | 143.98 | 10600.0 |
| 2012-10-10 05:25:00 | SPY | ETF | 143.96 | 143.97 | 143.89 | 143.89 | 1200.0 |
| 2012-10-10 05:30:00 | SPY | ETF | 143.89 | 143.89 | 143.87 | 143.87 | 12100.0 |
| 2012-10-10 05:35:00 | SPY | ETF | 143.87 | 143.89 | 143.83 | 143.88 | 17600.0 |
| 2012-10-10 05:40:00 | SPY | ETF | 143.89 | 143.89 | 143.89 | 143.89 | 500.0 |
| 2012-10-10 05:50:00 | SPY | ETF | 143.89 | 143.89 | 143.89 | 143.89 | 500.0 |
| 2012-10-10 05:55:00 | SPY | ETF | 143.89 | 143.89 | 143.89 | 143.89 | 500.0 |
| 2012-10-10 06:10:00 | SPY | ETF | 143.99 | 143.99 | 143.99 | 143.99 | 450.0 |
| 2012-10-10 06:20:00 | SPY | ETF | 143.99 | 144.0 | 143.99 | 144.0 | 6100.0 |
| 2012-10-10 06:25:00 | SPY | ETF | 144.04 | 144.04 | 144.04 | 144.04 | 100.0 |
| 2012-10-10 06:30:00 | SPY | ETF | 144.07 | 144.07 | 144.07 | 144.07 | 100.0 |
| 2012-10-10 06:35:00 | SPY | ETF | 144.06 | 144.06 | 144.06 | 144.06 | 4900.0 |
| 2012-10-10 06:45:00 | SPY | ETF | 144.07 | 144.07 | 144.07 | 144.07 | 8000.0 |
| 2012-10-10 06:50:00 | SPY | ETF | 144.09 | 144.09 | 144.09 | 144.09 | 3989.0 |
| 2012-10-10 06:55:00 | SPY | ETF | 144.11 | 144.11 | 144.08 | 144.08 | 200.0 |
| 2012-10-10 07:00:00 | SPY | ETF | 144.06 | 144.08 | 144.06 | 144.06 | 2077.0 |
| 2012-10-10 07:05:00 | SPY | ETF | 144.06 | 144.09 | 144.05 | 144.09 | 3700.0 |
| 2012-10-10 07:10:00 | SPY | ETF | 144.08 | 144.08 | 144.06 | 144.06 | 675.0 |
| 2012-10-10 07:20:00 | SPY | ETF | 144.06 | 144.16 | 144.06 | 144.16 | 4300.0 |
| 2012-10-10 07:25:00 | SPY | ETF | 144.16 | 144.17 | 144.12 | 144.12 | 4700.0 |
| 2012-10-10 07:30:00 | SPY | ETF | 144.12 | 144.16 | 144.05 | 144.05 | 2950.0 |
| 2012-10-10 07:35:00 | SPY | ETF | 144.09 | 144.14 | 144.09 | 144.09 | 2900.0 |
| 2012-10-10 07:40:00 | SPY | ETF | 144.09 | 144.12 | 144.08 | 144.12 | 7300.0 |
| 2012-10-10 07:45:00 | SPY | ETF | 144.12 | 144.12 | 144.06 | 144.06 | 17900.0 |
| 2012-10-10 07:50:00 | SPY | ETF | 144.08 | 144.19 | 144.08 | 144.16 | 64000.0 |
| 2012-10-10 07:55:00 | SPY | ETF | 144.14 | 144.29 | 144.14 | 144.25 | 35640.0 |
| 2012-10-10 08:00:00 | SPY | ETF | 144.25 | 144.29 | 144.2 | 144.24 | 54486.0 |
| 2012-10-10 08:05:00 | SPY | ETF | 144.21 | 144.27 | 144.19 | 144.27 | 19285.0 |
| 2012-10-10 08:10:00 | SPY | ETF | 144.27 | 144.3 | 144.26 | 144.29 | 52899.0 |
| 2012-10-10 08:15:00 | SPY | ETF | 144.29 | 144.29 | 144.26 | 144.28 | 30271.0 |
| 2012-10-10 08:20:00 | SPY | ETF | 144.28 | 144.31 | 144.27 | 144.3 | 6186.0 |
| 2012-10-10 08:25:00 | SPY | ETF | 144.3 | 144.32 | 144.2 | 144.21 | 20875.0 |
| 2012-10-10 08:30:00 | SPY | ETF | 144.2 | 144.22 | 144.09 | 144.1 | 56149.0 |
| 2012-10-10 08:35:00 | SPY | ETF | 144.12 | 144.12 | 144.08 | 144.1 | 57650.0 |
| 2012-10-10 08:40:00 | SPY | ETF | 144.1 | 144.1 | 144.0 | 144.02 | 75061.0 |
| 2012-10-10 08:45:00 | SPY | ETF | 144.02 | 144.09 | 144.01 | 144.04 | 51820.0 |
| 2012-10-10 08:50:00 | SPY | ETF | 144.06 | 144.11 | 144.03 | 144.11 | 74230.0 |
| 2012-10-10 08:55:00 | SPY | ETF | 144.11 | 144.13 | 144.1 | 144.12 | 30500.0 |
| 2012-10-10 09:00:00 | SPY | ETF | 144.12 | 144.25 | 144.09 | 144.11 | 42190.0 |
| 2012-10-10 09:05:00 | SPY | ETF | 144.1 | 144.14 | 144.08 | 144.14 | 42916.0 |
| 2012-10-10 09:10:00 | SPY | ETF | 144.15 | 144.22 | 144.15 | 144.21 | 51772.0 |
> showing 50 of 35,667 rows — these rows as CSV