PREVIEW / etf_5min / 2013-01-23
file: by_date/etf_5min/2013/2013-01-23.parquet size: 935 KB rows: 40,866
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-01-23 04:00:00 | SPY | ETF | 149.21 | 149.21 | 148.94 | 148.95 | 6567.0 |
| 2013-01-23 04:05:00 | SPY | ETF | 148.99 | 148.99 | 148.96 | 148.99 | 1917.0 |
| 2013-01-23 04:10:00 | SPY | ETF | 148.99 | 148.99 | 148.99 | 148.99 | 200.0 |
| 2013-01-23 04:15:00 | SPY | ETF | 149.05 | 149.05 | 149.05 | 149.05 | 600.0 |
| 2013-01-23 04:25:00 | SPY | ETF | 149.11 | 149.11 | 149.1 | 149.1 | 400.0 |
| 2013-01-23 04:30:00 | SPY | ETF | 149.13 | 149.13 | 149.13 | 149.13 | 200.0 |
| 2013-01-23 04:35:00 | SPY | ETF | 149.16 | 149.16 | 149.16 | 149.16 | 200.0 |
| 2013-01-23 04:50:00 | SPY | ETF | 149.2 | 149.2 | 149.2 | 149.2 | 100.0 |
| 2013-01-23 05:05:00 | SPY | ETF | 149.18 | 149.18 | 149.18 | 149.18 | 3300.0 |
| 2013-01-23 05:10:00 | SPY | ETF | 149.17 | 149.17 | 149.17 | 149.17 | 200.0 |
| 2013-01-23 05:25:00 | SPY | ETF | 149.18 | 149.18 | 149.18 | 149.18 | 1220.0 |
| 2013-01-23 05:30:00 | SPY | ETF | 149.22 | 149.22 | 149.22 | 149.22 | 7000.0 |
| 2013-01-23 05:35:00 | SPY | ETF | 149.17 | 149.17 | 149.15 | 149.15 | 300.0 |
| 2013-01-23 05:40:00 | SPY | ETF | 149.14 | 149.14 | 149.14 | 149.14 | 9900.0 |
| 2013-01-23 05:45:00 | SPY | ETF | 149.15 | 149.17 | 149.15 | 149.17 | 300.0 |
| 2013-01-23 06:05:00 | SPY | ETF | 149.17 | 149.17 | 149.15 | 149.15 | 200.0 |
| 2013-01-23 06:10:00 | SPY | ETF | 149.15 | 149.15 | 149.14 | 149.14 | 2600.0 |
| 2013-01-23 06:20:00 | SPY | ETF | 149.15 | 149.15 | 149.15 | 149.15 | 900.0 |
| 2013-01-23 06:25:00 | SPY | ETF | 149.15 | 149.17 | 149.15 | 149.17 | 13400.0 |
| 2013-01-23 06:35:00 | SPY | ETF | 149.17 | 149.17 | 149.17 | 149.17 | 100.0 |
| 2013-01-23 06:40:00 | SPY | ETF | 149.18 | 149.18 | 149.18 | 149.18 | 100.0 |
| 2013-01-23 06:50:00 | SPY | ETF | 149.17 | 149.17 | 149.17 | 149.17 | 1000.0 |
| 2013-01-23 06:55:00 | SPY | ETF | 149.17 | 149.17 | 149.17 | 149.17 | 10638.0 |
| 2013-01-23 07:00:00 | SPY | ETF | 149.16 | 149.16 | 149.16 | 149.16 | 1000.0 |
| 2013-01-23 07:05:00 | SPY | ETF | 149.21 | 149.25 | 149.21 | 149.24 | 15800.0 |
| 2013-01-23 07:10:00 | SPY | ETF | 149.23 | 149.23 | 149.2 | 149.21 | 16500.0 |
| 2013-01-23 07:15:00 | SPY | ETF | 149.2 | 149.22 | 149.19 | 149.22 | 17413.0 |
| 2013-01-23 07:20:00 | SPY | ETF | 149.24 | 149.29 | 149.24 | 149.27 | 5005.0 |
| 2013-01-23 07:25:00 | SPY | ETF | 149.3 | 149.3 | 149.28 | 149.3 | 14200.0 |
| 2013-01-23 07:30:00 | SPY | ETF | 149.27 | 149.27 | 149.21 | 149.21 | 5600.0 |
| 2013-01-23 07:35:00 | SPY | ETF | 149.24 | 149.24 | 149.24 | 149.24 | 2500.0 |
| 2013-01-23 07:40:00 | SPY | ETF | 149.25 | 149.25 | 149.24 | 149.25 | 12600.0 |
| 2013-01-23 07:45:00 | SPY | ETF | 149.25 | 149.25 | 149.25 | 149.25 | 100.0 |
| 2013-01-23 07:50:00 | SPY | ETF | 149.25 | 149.25 | 149.19 | 149.19 | 5205.0 |
| 2013-01-23 07:55:00 | SPY | ETF | 149.19 | 149.22 | 149.14 | 149.14 | 73003.0 |
| 2013-01-23 08:00:00 | SPY | ETF | 149.14 | 149.3 | 149.1 | 149.11 | 261744.0 |
| 2013-01-23 08:05:00 | SPY | ETF | 149.12 | 149.17 | 149.12 | 149.17 | 11480.0 |
| 2013-01-23 08:10:00 | SPY | ETF | 149.15 | 149.15 | 149.08 | 149.08 | 57733.0 |
| 2013-01-23 08:15:00 | SPY | ETF | 149.08 | 149.12 | 149.03 | 149.05 | 47518.0 |
| 2013-01-23 08:20:00 | SPY | ETF | 149.02 | 149.09 | 149.01 | 149.09 | 51348.0 |
| 2013-01-23 08:25:00 | SPY | ETF | 149.1 | 149.1 | 149.04 | 149.07 | 21735.0 |
| 2013-01-23 08:30:00 | SPY | ETF | 149.07 | 149.1 | 149.07 | 149.08 | 21080.0 |
| 2013-01-23 08:35:00 | SPY | ETF | 149.08 | 149.14 | 149.08 | 149.14 | 48148.0 |
| 2013-01-23 08:40:00 | SPY | ETF | 149.12 | 149.14 | 149.11 | 149.13 | 9030.0 |
| 2013-01-23 08:45:00 | SPY | ETF | 149.13 | 149.16 | 149.12 | 149.14 | 36497.0 |
| 2013-01-23 08:50:00 | SPY | ETF | 149.14 | 149.17 | 149.12 | 149.15 | 33585.0 |
| 2013-01-23 08:55:00 | SPY | ETF | 149.15 | 149.17 | 149.08 | 149.09 | 64659.0 |
| 2013-01-23 09:00:00 | SPY | ETF | 149.09 | 149.12 | 149.02 | 149.04 | 38753.0 |
| 2013-01-23 09:05:00 | SPY | ETF | 149.03 | 149.06 | 149.03 | 149.05 | 21850.0 |
| 2013-01-23 09:10:00 | SPY | ETF | 149.05 | 149.1 | 149.04 | 149.09 | 17500.0 |
> showing 50 of 40,866 rows — these rows as CSV