PREVIEW / etf_5min / 2012-09-10
file: by_date/etf_5min/2012/2012-09-10.parquet size: 852 KB rows: 36,067
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-09-10 04:05:00 | SPY | ETF | 143.99 | 144.1 | 143.98 | 144.1 | 2965.0 |
| 2012-09-10 04:15:00 | SPY | ETF | 144.01 | 144.08 | 144.01 | 144.08 | 24000.0 |
| 2012-09-10 04:20:00 | SPY | ETF | 144.08 | 144.08 | 144.08 | 144.08 | 11078.0 |
| 2012-09-10 04:30:00 | SPY | ETF | 144.11 | 144.15 | 144.11 | 144.15 | 400.0 |
| 2012-09-10 04:35:00 | SPY | ETF | 144.12 | 144.12 | 144.12 | 144.12 | 250.0 |
| 2012-09-10 05:25:00 | SPY | ETF | 144.12 | 144.12 | 144.12 | 144.12 | 100.0 |
| 2012-09-10 05:35:00 | SPY | ETF | 144.2 | 144.2 | 144.2 | 144.2 | 158.0 |
| 2012-09-10 05:55:00 | SPY | ETF | 144.19 | 144.19 | 144.19 | 144.19 | 100.0 |
| 2012-09-10 06:20:00 | SPY | ETF | 144.2 | 144.2 | 144.2 | 144.2 | 725.0 |
| 2012-09-10 06:35:00 | SPY | ETF | 144.16 | 144.16 | 144.16 | 144.16 | 12880.0 |
| 2012-09-10 06:40:00 | SPY | ETF | 144.16 | 144.16 | 144.16 | 144.16 | 1000.0 |
| 2012-09-10 06:45:00 | SPY | ETF | 144.18 | 144.18 | 144.18 | 144.18 | 5000.0 |
| 2012-09-10 07:00:00 | SPY | ETF | 144.2 | 144.2 | 144.19 | 144.19 | 700.0 |
| 2012-09-10 07:05:00 | SPY | ETF | 144.16 | 144.16 | 144.16 | 144.16 | 3900.0 |
| 2012-09-10 07:15:00 | SPY | ETF | 144.17 | 144.17 | 144.17 | 144.17 | 300.0 |
| 2012-09-10 07:20:00 | SPY | ETF | 144.16 | 144.16 | 144.16 | 144.16 | 800.0 |
| 2012-09-10 07:25:00 | SPY | ETF | 144.1 | 144.12 | 144.09 | 144.1 | 34600.0 |
| 2012-09-10 07:30:00 | SPY | ETF | 144.1 | 144.15 | 144.1 | 144.15 | 9300.0 |
| 2012-09-10 07:35:00 | SPY | ETF | 144.2 | 144.2 | 144.13 | 144.13 | 3000.0 |
| 2012-09-10 07:40:00 | SPY | ETF | 144.15 | 144.16 | 144.13 | 144.13 | 37600.0 |
| 2012-09-10 07:45:00 | SPY | ETF | 144.12 | 144.13 | 144.1 | 144.11 | 7100.0 |
| 2012-09-10 07:50:00 | SPY | ETF | 144.15 | 144.17 | 144.14 | 144.17 | 28300.0 |
| 2012-09-10 07:55:00 | SPY | ETF | 144.18 | 144.18 | 144.16 | 144.16 | 3450.0 |
| 2012-09-10 08:00:00 | SPY | ETF | 144.2 | 144.22 | 144.17 | 144.18 | 80237.0 |
| 2012-09-10 08:05:00 | SPY | ETF | 144.18 | 144.21 | 144.17 | 144.18 | 3000.0 |
| 2012-09-10 08:10:00 | SPY | ETF | 144.18 | 144.18 | 144.11 | 144.12 | 10852.0 |
| 2012-09-10 08:15:00 | SPY | ETF | 144.12 | 144.12 | 144.11 | 144.12 | 2590.0 |
| 2012-09-10 08:20:00 | SPY | ETF | 144.13 | 144.15 | 144.11 | 144.13 | 54518.0 |
| 2012-09-10 08:25:00 | SPY | ETF | 144.12 | 144.13 | 144.07 | 144.11 | 103950.0 |
| 2012-09-10 08:30:00 | SPY | ETF | 144.13 | 144.14 | 144.11 | 144.13 | 75400.0 |
| 2012-09-10 08:35:00 | SPY | ETF | 144.12 | 144.15 | 144.09 | 144.14 | 25936.0 |
| 2012-09-10 08:40:00 | SPY | ETF | 144.11 | 144.14 | 144.08 | 144.13 | 75771.0 |
| 2012-09-10 08:45:00 | SPY | ETF | 144.12 | 144.14 | 144.1 | 144.14 | 29677.0 |
| 2012-09-10 08:50:00 | SPY | ETF | 144.13 | 144.16 | 144.07 | 144.07 | 29572.0 |
| 2012-09-10 08:55:00 | SPY | ETF | 144.06 | 144.1 | 144.04 | 144.07 | 132114.0 |
| 2012-09-10 09:00:00 | SPY | ETF | 144.08 | 144.09 | 144.04 | 144.06 | 52601.0 |
| 2012-09-10 09:05:00 | SPY | ETF | 144.08 | 144.1 | 144.05 | 144.07 | 44935.0 |
| 2012-09-10 09:10:00 | SPY | ETF | 144.07 | 144.09 | 144.06 | 144.09 | 78595.0 |
| 2012-09-10 09:15:00 | SPY | ETF | 144.09 | 144.12 | 144.09 | 144.12 | 37994.0 |
| 2012-09-10 09:20:00 | SPY | ETF | 144.12 | 144.16 | 144.12 | 144.16 | 99482.0 |
| 2012-09-10 09:25:00 | SPY | ETF | 144.15 | 144.21 | 144.15 | 144.19 | 425560.0 |
| 2012-09-10 09:30:00 | SPY | ETF | 144.19 | 144.26 | 144.12 | 144.182 | 2969825.0 |
| 2012-09-10 09:35:00 | SPY | ETF | 144.18 | 144.28 | 144.16 | 144.19 | 1909643.0 |
| 2012-09-10 09:40:00 | SPY | ETF | 144.19 | 144.19 | 144.0 | 144.04 | 2895669.0 |
| 2012-09-10 09:45:00 | SPY | ETF | 144.04 | 144.17 | 144.03 | 144.14 | 1613213.0 |
| 2012-09-10 09:50:00 | SPY | ETF | 144.13 | 144.24 | 144.11 | 144.21 | 2409759.0 |
| 2012-09-10 09:55:00 | SPY | ETF | 144.2 | 144.28 | 144.17 | 144.21 | 1527717.0 |
| 2012-09-10 10:00:00 | SPY | ETF | 144.2 | 144.32 | 144.155 | 144.23 | 2319999.0 |
| 2012-09-10 10:05:00 | SPY | ETF | 144.22 | 144.33 | 144.18 | 144.27 | 2678039.0 |
| 2012-09-10 10:10:00 | SPY | ETF | 144.27 | 144.28 | 144.17 | 144.22 | 817681.0 |
> showing 50 of 36,067 rows — these rows as CSV