PREVIEW / etf_5min / 2012-08-10
file: by_date/etf_5min/2012/2012-08-10.parquet size: 772 KB rows: 32,776
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-08-10 04:00:00 | SPY | ETF | 140.19 | 140.33 | 140.14 | 140.17 | 6923.0 |
| 2012-08-10 04:10:00 | SPY | ETF | 140.22 | 140.26 | 140.22 | 140.26 | 433.0 |
| 2012-08-10 04:35:00 | SPY | ETF | 140.33 | 140.33 | 140.33 | 140.33 | 1000.0 |
| 2012-08-10 04:45:00 | SPY | ETF | 140.31 | 140.31 | 140.24 | 140.24 | 800.0 |
| 2012-08-10 05:05:00 | SPY | ETF | 140.23 | 140.23 | 140.23 | 140.23 | 500.0 |
| 2012-08-10 05:10:00 | SPY | ETF | 140.23 | 140.23 | 140.23 | 140.23 | 2000.0 |
| 2012-08-10 05:15:00 | SPY | ETF | 140.31 | 140.31 | 140.31 | 140.31 | 1000.0 |
| 2012-08-10 05:20:00 | SPY | ETF | 140.31 | 140.31 | 140.31 | 140.31 | 100.0 |
| 2012-08-10 05:30:00 | SPY | ETF | 140.24 | 140.24 | 140.24 | 140.24 | 100.0 |
| 2012-08-10 05:35:00 | SPY | ETF | 140.18 | 140.23 | 140.18 | 140.23 | 2600.0 |
| 2012-08-10 05:40:00 | SPY | ETF | 140.19 | 140.19 | 140.18 | 140.18 | 3000.0 |
| 2012-08-10 05:45:00 | SPY | ETF | 140.16 | 140.18 | 140.16 | 140.18 | 3400.0 |
| 2012-08-10 05:50:00 | SPY | ETF | 140.14 | 140.14 | 140.14 | 140.14 | 3000.0 |
| 2012-08-10 05:55:00 | SPY | ETF | 140.21 | 140.21 | 140.21 | 140.21 | 20000.0 |
| 2012-08-10 06:10:00 | SPY | ETF | 140.22 | 140.22 | 140.2 | 140.2 | 500.0 |
| 2012-08-10 06:20:00 | SPY | ETF | 140.23 | 140.25 | 140.21 | 140.25 | 10500.0 |
| 2012-08-10 06:25:00 | SPY | ETF | 140.23 | 140.23 | 140.23 | 140.23 | 100.0 |
| 2012-08-10 06:30:00 | SPY | ETF | 140.23 | 140.23 | 140.17 | 140.17 | 1400.0 |
| 2012-08-10 06:35:00 | SPY | ETF | 140.21 | 140.21 | 140.13 | 140.13 | 104900.0 |
| 2012-08-10 06:40:00 | SPY | ETF | 140.1 | 140.1 | 140.1 | 140.1 | 15000.0 |
| 2012-08-10 06:45:00 | SPY | ETF | 140.03 | 140.08 | 140.03 | 140.08 | 37950.0 |
| 2012-08-10 06:50:00 | SPY | ETF | 140.06 | 140.07 | 140.05 | 140.05 | 10000.0 |
| 2012-08-10 06:55:00 | SPY | ETF | 140.05 | 140.05 | 140.01 | 140.02 | 1652.0 |
| 2012-08-10 07:00:00 | SPY | ETF | 140.05 | 140.07 | 139.98 | 140.01 | 20009.0 |
| 2012-08-10 07:05:00 | SPY | ETF | 140.05 | 140.09 | 140.05 | 140.05 | 20025.0 |
| 2012-08-10 07:10:00 | SPY | ETF | 140.05 | 140.06 | 140.0 | 140.06 | 32778.0 |
| 2012-08-10 07:15:00 | SPY | ETF | 140.07 | 140.07 | 140.06 | 140.06 | 700.0 |
| 2012-08-10 07:20:00 | SPY | ETF | 140.08 | 140.1 | 140.06 | 140.06 | 23705.0 |
| 2012-08-10 07:25:00 | SPY | ETF | 140.04 | 140.05 | 140.03 | 140.03 | 68220.0 |
| 2012-08-10 07:30:00 | SPY | ETF | 140.05 | 140.05 | 140.05 | 140.05 | 30200.0 |
| 2012-08-10 07:35:00 | SPY | ETF | 140.05 | 140.06 | 140.05 | 140.06 | 1100.0 |
| 2012-08-10 07:40:00 | SPY | ETF | 140.06 | 140.06 | 140.04 | 140.06 | 10625.0 |
| 2012-08-10 07:45:00 | SPY | ETF | 140.05 | 140.05 | 140.05 | 140.05 | 100.0 |
| 2012-08-10 07:50:00 | SPY | ETF | 140.02 | 140.03 | 139.99 | 140.02 | 19725.0 |
| 2012-08-10 07:55:00 | SPY | ETF | 140.05 | 140.05 | 140.01 | 140.04 | 43129.0 |
| 2012-08-10 08:00:00 | SPY | ETF | 140.04 | 140.21 | 140.02 | 140.09 | 65024.0 |
| 2012-08-10 08:05:00 | SPY | ETF | 140.1 | 140.13 | 140.09 | 140.1 | 29640.0 |
| 2012-08-10 08:10:00 | SPY | ETF | 140.11 | 140.11 | 140.05 | 140.06 | 62948.0 |
| 2012-08-10 08:15:00 | SPY | ETF | 140.06 | 140.1 | 140.05 | 140.09 | 52650.0 |
| 2012-08-10 08:20:00 | SPY | ETF | 140.1 | 140.1 | 140.07 | 140.07 | 14824.0 |
| 2012-08-10 08:25:00 | SPY | ETF | 140.06 | 140.12 | 140.05 | 140.12 | 22500.0 |
| 2012-08-10 08:30:00 | SPY | ETF | 140.1 | 140.14 | 140.03 | 140.04 | 34297.0 |
| 2012-08-10 08:35:00 | SPY | ETF | 140.04 | 140.06 | 139.99 | 140.05 | 40790.0 |
| 2012-08-10 08:40:00 | SPY | ETF | 140.05 | 140.07 | 139.98 | 139.98 | 145056.0 |
| 2012-08-10 08:45:00 | SPY | ETF | 139.98 | 140.06 | 139.98 | 140.02 | 29700.0 |
| 2012-08-10 08:50:00 | SPY | ETF | 140.02 | 140.1 | 140.0 | 140.1 | 42850.0 |
| 2012-08-10 08:55:00 | SPY | ETF | 140.09 | 140.19 | 140.07 | 140.12 | 302568.0 |
| 2012-08-10 09:00:00 | SPY | ETF | 140.1 | 140.2 | 140.1 | 140.17 | 277145.0 |
| 2012-08-10 09:05:00 | SPY | ETF | 140.17 | 140.22 | 140.11 | 140.17 | 55389.0 |
| 2012-08-10 09:10:00 | SPY | ETF | 140.16 | 140.16 | 140.07 | 140.1 | 83371.0 |
> showing 50 of 32,776 rows — these rows as CSV