PREVIEW / etf_5min / 2012-12-20
file: by_date/etf_5min/2012/2012-12-20.parquet size: 922 KB rows: 38,566
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-12-20 04:00:00 | SPY | ETF | 144.27 | 144.37 | 144.27 | 144.37 | 1138.0 |
| 2012-12-20 04:05:00 | SPY | ETF | 144.27 | 144.27 | 144.27 | 144.27 | 5000.0 |
| 2012-12-20 04:10:00 | SPY | ETF | 144.34 | 144.34 | 144.34 | 144.34 | 3000.0 |
| 2012-12-20 04:15:00 | SPY | ETF | 144.34 | 144.34 | 144.33 | 144.33 | 9000.0 |
| 2012-12-20 04:55:00 | SPY | ETF | 144.3 | 144.3 | 144.3 | 144.3 | 100.0 |
| 2012-12-20 05:10:00 | SPY | ETF | 144.3 | 144.3 | 144.28 | 144.28 | 24200.0 |
| 2012-12-20 05:15:00 | SPY | ETF | 144.25 | 144.3 | 144.25 | 144.3 | 4300.0 |
| 2012-12-20 05:25:00 | SPY | ETF | 144.36 | 144.36 | 144.36 | 144.36 | 500.0 |
| 2012-12-20 05:35:00 | SPY | ETF | 144.37 | 144.44 | 144.37 | 144.44 | 6640.0 |
| 2012-12-20 06:05:00 | SPY | ETF | 144.39 | 144.41 | 144.39 | 144.41 | 6300.0 |
| 2012-12-20 06:10:00 | SPY | ETF | 144.36 | 144.36 | 144.36 | 144.36 | 300.0 |
| 2012-12-20 06:15:00 | SPY | ETF | 144.38 | 144.44 | 144.38 | 144.38 | 25310.0 |
| 2012-12-20 06:25:00 | SPY | ETF | 144.45 | 144.5 | 144.45 | 144.5 | 6900.0 |
| 2012-12-20 06:30:00 | SPY | ETF | 144.47 | 144.5 | 144.47 | 144.47 | 981.0 |
| 2012-12-20 06:35:00 | SPY | ETF | 144.5 | 144.5 | 144.5 | 144.5 | 400.0 |
| 2012-12-20 06:40:00 | SPY | ETF | 144.45 | 144.51 | 144.45 | 144.51 | 500.0 |
| 2012-12-20 06:45:00 | SPY | ETF | 144.5 | 144.5 | 144.5 | 144.5 | 300.0 |
| 2012-12-20 06:50:00 | SPY | ETF | 144.5 | 144.51 | 144.47 | 144.51 | 2700.0 |
| 2012-12-20 06:55:00 | SPY | ETF | 144.48 | 144.48 | 144.48 | 144.48 | 1050.0 |
| 2012-12-20 07:00:00 | SPY | ETF | 144.48 | 144.51 | 144.48 | 144.51 | 13205.0 |
| 2012-12-20 07:05:00 | SPY | ETF | 144.51 | 144.58 | 144.51 | 144.58 | 26000.0 |
| 2012-12-20 07:10:00 | SPY | ETF | 144.55 | 144.58 | 144.55 | 144.55 | 34600.0 |
| 2012-12-20 07:15:00 | SPY | ETF | 144.55 | 144.6 | 144.55 | 144.6 | 36338.0 |
| 2012-12-20 07:20:00 | SPY | ETF | 144.56 | 144.58 | 144.56 | 144.56 | 3900.0 |
| 2012-12-20 07:25:00 | SPY | ETF | 144.55 | 144.58 | 144.55 | 144.56 | 6200.0 |
| 2012-12-20 07:30:00 | SPY | ETF | 144.56 | 144.61 | 144.55 | 144.61 | 37020.0 |
| 2012-12-20 07:35:00 | SPY | ETF | 144.6 | 144.6 | 144.56 | 144.58 | 3600.0 |
| 2012-12-20 07:40:00 | SPY | ETF | 144.56 | 144.58 | 144.55 | 144.55 | 36610.0 |
| 2012-12-20 07:45:00 | SPY | ETF | 144.56 | 144.58 | 144.51 | 144.51 | 47100.0 |
| 2012-12-20 07:50:00 | SPY | ETF | 144.51 | 144.54 | 144.41 | 144.44 | 43250.0 |
| 2012-12-20 07:55:00 | SPY | ETF | 144.41 | 144.49 | 144.38 | 144.49 | 122120.0 |
| 2012-12-20 08:00:00 | SPY | ETF | 144.43 | 144.58 | 144.29 | 144.45 | 143338.0 |
| 2012-12-20 08:05:00 | SPY | ETF | 144.46 | 144.52 | 144.42 | 144.52 | 153390.0 |
| 2012-12-20 08:10:00 | SPY | ETF | 144.55 | 144.55 | 144.45 | 144.49 | 96084.0 |
| 2012-12-20 08:15:00 | SPY | ETF | 144.48 | 144.48 | 144.1 | 144.41 | 96454.0 |
| 2012-12-20 08:20:00 | SPY | ETF | 144.41 | 144.42 | 144.2 | 144.25 | 1041417.0 |
| 2012-12-20 08:25:00 | SPY | ETF | 144.26 | 144.37 | 144.07 | 144.14 | 746150.0 |
| 2012-12-20 08:30:00 | SPY | ETF | 144.35 | 144.45 | 144.26 | 144.35 | 240516.0 |
| 2012-12-20 08:35:00 | SPY | ETF | 144.35 | 144.35 | 144.21 | 144.25 | 140392.0 |
| 2012-12-20 08:40:00 | SPY | ETF | 144.24 | 144.44 | 144.24 | 144.35 | 195818.0 |
| 2012-12-20 08:45:00 | SPY | ETF | 144.36 | 144.42 | 144.33 | 144.4 | 116572.0 |
| 2012-12-20 08:50:00 | SPY | ETF | 144.39 | 144.48 | 144.39 | 144.44 | 193000.0 |
| 2012-12-20 08:55:00 | SPY | ETF | 144.44 | 144.48 | 144.37 | 144.43 | 229727.0 |
| 2012-12-20 09:00:00 | SPY | ETF | 144.44 | 144.59 | 144.42 | 144.54 | 840189.0 |
| 2012-12-20 09:05:00 | SPY | ETF | 144.54 | 144.55 | 144.48 | 144.49 | 260862.0 |
| 2012-12-20 09:10:00 | SPY | ETF | 144.48 | 144.5 | 144.46 | 144.48 | 21334.0 |
| 2012-12-20 09:15:00 | SPY | ETF | 144.48 | 144.5 | 144.43 | 144.45 | 108388.0 |
| 2012-12-20 09:20:00 | SPY | ETF | 144.44 | 144.44 | 144.31 | 144.34 | 142297.0 |
| 2012-12-20 09:25:00 | SPY | ETF | 144.35 | 144.45 | 144.3 | 144.38 | 417085.0 |
| 2012-12-20 09:30:00 | SPY | ETF | 144.38 | 144.51 | 144.32 | 144.33 | 3231676.0 |
> showing 50 of 38,566 rows — these rows as CSV