PREVIEW / etf_5min / 2012-02-22
file: by_date/etf_5min/2012/2012-02-22.parquet size: 857 KB rows: 36,284
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-02-22 04:00:00 | SPY | ETF | 136.5 | 136.5 | 136.5 | 136.5 | 380.0 |
| 2012-02-22 04:05:00 | SPY | ETF | 136.43 | 136.43 | 136.43 | 136.43 | 25000.0 |
| 2012-02-22 04:10:00 | SPY | ETF | 136.43 | 136.43 | 136.43 | 136.43 | 100.0 |
| 2012-02-22 04:15:00 | SPY | ETF | 136.35 | 136.35 | 136.35 | 136.35 | 100.0 |
| 2012-02-22 04:25:00 | SPY | ETF | 136.47 | 136.47 | 136.47 | 136.47 | 1800.0 |
| 2012-02-22 05:20:00 | SPY | ETF | 136.34 | 136.42 | 136.34 | 136.42 | 5340.0 |
| 2012-02-22 05:50:00 | SPY | ETF | 136.42 | 136.42 | 136.42 | 136.42 | 10000.0 |
| 2012-02-22 06:00:00 | SPY | ETF | 136.35 | 136.35 | 136.35 | 136.35 | 200.0 |
| 2012-02-22 06:05:00 | SPY | ETF | 136.3 | 136.3 | 136.27 | 136.27 | 36200.0 |
| 2012-02-22 06:10:00 | SPY | ETF | 136.28 | 136.28 | 136.25 | 136.27 | 64200.0 |
| 2012-02-22 06:20:00 | SPY | ETF | 136.35 | 136.35 | 136.35 | 136.35 | 10000.0 |
| 2012-02-22 06:30:00 | SPY | ETF | 136.28 | 136.28 | 136.28 | 136.28 | 200.0 |
| 2012-02-22 06:35:00 | SPY | ETF | 136.23 | 136.24 | 136.23 | 136.24 | 300.0 |
| 2012-02-22 06:40:00 | SPY | ETF | 136.17 | 136.19 | 136.17 | 136.19 | 20000.0 |
| 2012-02-22 06:45:00 | SPY | ETF | 136.2 | 136.2 | 136.19 | 136.19 | 1200.0 |
| 2012-02-22 06:55:00 | SPY | ETF | 136.19 | 136.2 | 136.14 | 136.17 | 19575.0 |
| 2012-02-22 07:00:00 | SPY | ETF | 136.17 | 136.2 | 136.16 | 136.16 | 700.0 |
| 2012-02-22 07:05:00 | SPY | ETF | 136.19 | 136.21 | 136.19 | 136.21 | 475.0 |
| 2012-02-22 07:10:00 | SPY | ETF | 136.2 | 136.21 | 136.16 | 136.21 | 5300.0 |
| 2012-02-22 07:15:00 | SPY | ETF | 136.21 | 136.21 | 136.15 | 136.17 | 3060.0 |
| 2012-02-22 07:20:00 | SPY | ETF | 136.2 | 136.31 | 136.2 | 136.31 | 13800.0 |
| 2012-02-22 07:25:00 | SPY | ETF | 136.29 | 136.33 | 136.28 | 136.28 | 5400.0 |
| 2012-02-22 07:30:00 | SPY | ETF | 136.28 | 136.28 | 136.28 | 136.28 | 900.0 |
| 2012-02-22 07:35:00 | SPY | ETF | 136.28 | 136.32 | 136.27 | 136.32 | 63600.0 |
| 2012-02-22 07:40:00 | SPY | ETF | 136.32 | 136.39 | 136.32 | 136.35 | 24900.0 |
| 2012-02-22 07:45:00 | SPY | ETF | 136.4 | 136.45 | 136.38 | 136.38 | 12100.0 |
| 2012-02-22 07:50:00 | SPY | ETF | 136.42 | 136.43 | 136.34 | 136.35 | 102800.0 |
| 2012-02-22 07:55:00 | SPY | ETF | 136.35 | 136.35 | 136.28 | 136.33 | 33695.0 |
| 2012-02-22 08:00:00 | SPY | ETF | 136.33 | 136.36 | 136.28 | 136.32 | 54979.0 |
| 2012-02-22 08:05:00 | SPY | ETF | 136.3 | 136.4716 | 136.25 | 136.28 | 521385.0 |
| 2012-02-22 08:10:00 | SPY | ETF | 136.27 | 136.28 | 136.25 | 136.25 | 9540.0 |
| 2012-02-22 08:15:00 | SPY | ETF | 136.25 | 136.3 | 136.18 | 136.19 | 64920.0 |
| 2012-02-22 08:20:00 | SPY | ETF | 136.18 | 136.21 | 136.15 | 136.15 | 79205.0 |
| 2012-02-22 08:25:00 | SPY | ETF | 136.16 | 136.23 | 136.12 | 136.23 | 121600.0 |
| 2012-02-22 08:30:00 | SPY | ETF | 136.23 | 136.25 | 136.17 | 136.23 | 71550.0 |
| 2012-02-22 08:35:00 | SPY | ETF | 136.22 | 136.23 | 136.15 | 136.17 | 87166.0 |
| 2012-02-22 08:40:00 | SPY | ETF | 136.2 | 136.26 | 136.2 | 136.22 | 74616.0 |
| 2012-02-22 08:45:00 | SPY | ETF | 136.23 | 136.32 | 136.21 | 136.3 | 156042.0 |
| 2012-02-22 08:50:00 | SPY | ETF | 136.31 | 136.36 | 136.31 | 136.36 | 121503.0 |
| 2012-02-22 08:55:00 | SPY | ETF | 136.36 | 136.38 | 136.35 | 136.38 | 51076.0 |
| 2012-02-22 09:00:00 | SPY | ETF | 136.37 | 136.41 | 136.37 | 136.39 | 151817.0 |
| 2012-02-22 09:05:00 | SPY | ETF | 136.39 | 136.41 | 136.37 | 136.37 | 68434.0 |
| 2012-02-22 09:10:00 | SPY | ETF | 136.37 | 136.38 | 136.3 | 136.34 | 71808.0 |
| 2012-02-22 09:15:00 | SPY | ETF | 136.35 | 136.36 | 136.31 | 136.33 | 857700.0 |
| 2012-02-22 09:20:00 | SPY | ETF | 136.33 | 136.35 | 136.27 | 136.31 | 93170.0 |
| 2012-02-22 09:25:00 | SPY | ETF | 136.3 | 136.3 | 136.19 | 136.25 | 576610.0 |
| 2012-02-22 09:30:00 | SPY | ETF | 136.26 | 136.39 | 136.18 | 136.39 | 4206260.0 |
| 2012-02-22 09:35:00 | SPY | ETF | 136.38 | 136.42 | 136.17 | 136.26 | 3819029.0 |
| 2012-02-22 09:40:00 | SPY | ETF | 136.26 | 136.45 | 136.2 | 136.4499 | 2184548.0 |
| 2012-02-22 09:45:00 | SPY | ETF | 136.44 | 136.46 | 136.34 | 136.34 | 2462987.0 |
> showing 50 of 36,284 rows — these rows as CSV