PREVIEW / etf_5min / 2015-01-26
file: by_date/etf_5min/2015/2015-01-26.parquet size: 1.2 MB rows: 49,845
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-26 04:00:00 | SPY | ETF | 204.23 | 204.23 | 203.36 | 203.69 | 7369.0 |
| 2015-01-26 04:05:00 | SPY | ETF | 204.01 | 204.01 | 204.01 | 204.01 | 100.0 |
| 2015-01-26 04:10:00 | SPY | ETF | 204.28 | 204.64 | 204.28 | 204.64 | 8150.0 |
| 2015-01-26 04:15:00 | SPY | ETF | 204.57 | 204.59 | 204.57 | 204.59 | 240.0 |
| 2015-01-26 04:20:00 | SPY | ETF | 204.38 | 204.38 | 204.38 | 204.38 | 500.0 |
| 2015-01-26 04:30:00 | SPY | ETF | 204.33 | 204.33 | 204.14 | 204.14 | 400.0 |
| 2015-01-26 04:35:00 | SPY | ETF | 204.01 | 204.01 | 204.01 | 204.01 | 100.0 |
| 2015-01-26 04:45:00 | SPY | ETF | 204.09 | 204.21 | 204.08 | 204.21 | 2000.0 |
| 2015-01-26 04:55:00 | SPY | ETF | 204.22 | 204.22 | 204.21 | 204.21 | 2000.0 |
| 2015-01-26 05:00:00 | SPY | ETF | 204.3 | 204.3 | 204.3 | 204.3 | 1000.0 |
| 2015-01-26 05:20:00 | SPY | ETF | 204.3 | 204.3 | 204.23 | 204.23 | 1800.0 |
| 2015-01-26 05:30:00 | SPY | ETF | 204.0 | 204.0 | 203.98 | 203.98 | 550.0 |
| 2015-01-26 05:35:00 | SPY | ETF | 204.32 | 204.32 | 204.32 | 204.32 | 300.0 |
| 2015-01-26 05:50:00 | SPY | ETF | 204.26 | 204.26 | 204.11 | 204.15 | 550.0 |
| 2015-01-26 05:55:00 | SPY | ETF | 204.15 | 204.15 | 204.15 | 204.15 | 600.0 |
| 2015-01-26 06:00:00 | SPY | ETF | 204.18 | 204.25 | 204.18 | 204.25 | 1350.0 |
| 2015-01-26 06:05:00 | SPY | ETF | 204.17 | 204.17 | 204.17 | 204.17 | 100.0 |
| 2015-01-26 06:10:00 | SPY | ETF | 204.11 | 204.11 | 204.06 | 204.08 | 3525.0 |
| 2015-01-26 06:15:00 | SPY | ETF | 204.16 | 204.16 | 204.16 | 204.16 | 100.0 |
| 2015-01-26 06:20:00 | SPY | ETF | 204.15 | 204.15 | 204.08 | 204.08 | 1100.0 |
| 2015-01-26 06:25:00 | SPY | ETF | 204.06 | 204.08 | 204.06 | 204.06 | 4944.0 |
| 2015-01-26 06:30:00 | SPY | ETF | 204.08 | 204.08 | 204.08 | 204.08 | 200.0 |
| 2015-01-26 06:40:00 | SPY | ETF | 204.08 | 204.11 | 204.08 | 204.11 | 4201.0 |
| 2015-01-26 06:45:00 | SPY | ETF | 204.12 | 204.2 | 204.12 | 204.12 | 13399.0 |
| 2015-01-26 06:50:00 | SPY | ETF | 204.12 | 204.12 | 204.1 | 204.1 | 25500.0 |
| 2015-01-26 06:55:00 | SPY | ETF | 204.16 | 204.16 | 204.16 | 204.16 | 500.0 |
| 2015-01-26 07:00:00 | SPY | ETF | 204.27 | 204.34 | 204.25 | 204.34 | 55750.0 |
| 2015-01-26 07:05:00 | SPY | ETF | 204.33 | 204.39 | 204.26 | 204.26 | 34532.0 |
| 2015-01-26 07:10:00 | SPY | ETF | 204.25 | 204.25 | 204.16 | 204.16 | 34713.0 |
| 2015-01-26 07:15:00 | SPY | ETF | 204.16 | 204.26 | 204.16 | 204.25 | 7920.0 |
| 2015-01-26 07:20:00 | SPY | ETF | 204.25 | 204.25 | 204.23 | 204.23 | 4834.0 |
| 2015-01-26 07:25:00 | SPY | ETF | 204.25 | 204.31 | 204.21 | 204.23 | 28733.0 |
| 2015-01-26 07:30:00 | SPY | ETF | 204.25 | 204.25 | 204.23 | 204.23 | 13460.0 |
| 2015-01-26 07:35:00 | SPY | ETF | 204.25 | 204.33 | 204.23 | 204.28 | 20910.0 |
| 2015-01-26 07:40:00 | SPY | ETF | 204.24 | 204.5 | 204.24 | 204.4 | 16056.0 |
| 2015-01-26 07:45:00 | SPY | ETF | 204.45 | 204.56 | 204.45 | 204.56 | 73805.0 |
| 2015-01-26 07:50:00 | SPY | ETF | 204.56 | 204.64 | 204.47 | 204.52 | 87091.0 |
| 2015-01-26 07:55:00 | SPY | ETF | 204.55 | 204.72 | 204.54 | 204.65 | 25401.0 |
| 2015-01-26 08:00:00 | SPY | ETF | 204.0378 | 204.73 | 204.0378 | 204.62 | 203670.0 |
| 2015-01-26 08:05:00 | SPY | ETF | 204.63 | 204.71 | 204.6 | 204.6 | 22295.0 |
| 2015-01-26 08:10:00 | SPY | ETF | 204.61 | 204.63 | 204.56 | 204.61 | 16186.0 |
| 2015-01-26 08:15:00 | SPY | ETF | 204.56 | 204.58 | 204.49 | 204.49 | 65003.0 |
| 2015-01-26 08:20:00 | SPY | ETF | 204.5 | 204.61 | 204.5 | 204.58 | 24841.0 |
| 2015-01-26 08:25:00 | SPY | ETF | 204.57 | 204.64 | 204.56 | 204.59 | 10385.0 |
| 2015-01-26 08:30:00 | SPY | ETF | 204.56 | 204.71 | 204.56 | 204.71 | 19622.0 |
| 2015-01-26 08:35:00 | SPY | ETF | 204.7 | 204.96 | 204.67 | 204.96 | 153245.0 |
| 2015-01-26 08:40:00 | SPY | ETF | 204.94 | 205.07 | 204.94 | 205.04 | 170561.0 |
| 2015-01-26 08:45:00 | SPY | ETF | 205.03 | 205.07 | 204.97 | 204.97 | 49195.0 |
| 2015-01-26 08:50:00 | SPY | ETF | 204.95 | 204.98 | 204.89 | 204.9 | 205308.0 |
| 2015-01-26 08:55:00 | SPY | ETF | 204.9 | 204.99 | 204.88 | 204.98 | 26780.0 |
> showing 50 of 49,845 rows — these rows as CSV