PREVIEW / etf_5min / 2012-09-18
file: by_date/etf_5min/2012/2012-09-18.parquet size: 864 KB rows: 36,439
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-18 04:00:00 | SPY | ETF | 146.57 | 146.57 | 146.46 | 146.46 | 37240.0 |
| 2012-09-18 04:05:00 | SPY | ETF | 146.43 | 146.43 | 146.43 | 146.43 | 4916.0 |
| 2012-09-18 04:10:00 | SPY | ETF | 146.42 | 146.45 | 146.42 | 146.43 | 10750.0 |
| 2012-09-18 04:15:00 | SPY | ETF | 146.4 | 146.4 | 146.31 | 146.31 | 5300.0 |
| 2012-09-18 04:20:00 | SPY | ETF | 146.29 | 146.35 | 146.29 | 146.35 | 600.0 |
| 2012-09-18 04:25:00 | SPY | ETF | 146.32 | 146.32 | 146.32 | 146.32 | 9450.0 |
| 2012-09-18 04:30:00 | SPY | ETF | 146.32 | 146.32 | 146.3 | 146.3 | 1492.0 |
| 2012-09-18 04:35:00 | SPY | ETF | 146.34 | 146.34 | 146.33 | 146.33 | 1242.0 |
| 2012-09-18 04:40:00 | SPY | ETF | 146.36 | 146.36 | 146.36 | 146.36 | 750.0 |
| 2012-09-18 04:55:00 | SPY | ETF | 146.42 | 146.42 | 146.42 | 146.42 | 100.0 |
| 2012-09-18 05:10:00 | SPY | ETF | 146.32 | 146.32 | 146.32 | 146.32 | 500.0 |
| 2012-09-18 05:25:00 | SPY | ETF | 146.38 | 146.38 | 146.38 | 146.38 | 9200.0 |
| 2012-09-18 05:30:00 | SPY | ETF | 146.33 | 146.33 | 146.29 | 146.29 | 5350.0 |
| 2012-09-18 05:35:00 | SPY | ETF | 146.31 | 146.31 | 146.31 | 146.31 | 9950.0 |
| 2012-09-18 05:40:00 | SPY | ETF | 146.31 | 146.31 | 146.29 | 146.29 | 900.0 |
| 2012-09-18 05:45:00 | SPY | ETF | 146.26 | 146.26 | 146.22 | 146.22 | 865.0 |
| 2012-09-18 05:50:00 | SPY | ETF | 146.24 | 146.24 | 146.24 | 146.24 | 1000.0 |
| 2012-09-18 06:00:00 | SPY | ETF | 146.25 | 146.25 | 146.25 | 146.25 | 200.0 |
| 2012-09-18 06:15:00 | SPY | ETF | 146.26 | 146.26 | 146.26 | 146.26 | 300.0 |
| 2012-09-18 06:20:00 | SPY | ETF | 146.26 | 146.26 | 146.26 | 146.26 | 400.0 |
| 2012-09-18 06:25:00 | SPY | ETF | 146.31 | 146.31 | 146.31 | 146.31 | 12200.0 |
| 2012-09-18 06:30:00 | SPY | ETF | 146.31 | 146.32 | 146.3 | 146.32 | 7900.0 |
| 2012-09-18 06:35:00 | SPY | ETF | 146.32 | 146.39 | 146.32 | 146.38 | 1300.0 |
| 2012-09-18 06:40:00 | SPY | ETF | 146.39 | 146.39 | 146.39 | 146.39 | 400.0 |
| 2012-09-18 06:45:00 | SPY | ETF | 146.39 | 146.39 | 146.39 | 146.39 | 300.0 |
| 2012-09-18 06:50:00 | SPY | ETF | 146.39 | 146.41 | 146.39 | 146.41 | 500.0 |
| 2012-09-18 06:55:00 | SPY | ETF | 146.43 | 146.45 | 146.43 | 146.45 | 500.0 |
| 2012-09-18 07:00:00 | SPY | ETF | 146.44 | 146.44 | 146.39 | 146.4 | 6400.0 |
| 2012-09-18 07:05:00 | SPY | ETF | 146.43 | 146.43 | 146.4 | 146.4 | 400.0 |
| 2012-09-18 07:10:00 | SPY | ETF | 146.4 | 146.42 | 146.38 | 146.39 | 13300.0 |
| 2012-09-18 07:15:00 | SPY | ETF | 146.44 | 146.44 | 146.42 | 146.43 | 7900.0 |
| 2012-09-18 07:20:00 | SPY | ETF | 146.46 | 146.53 | 146.45 | 146.52 | 24220.0 |
| 2012-09-18 07:25:00 | SPY | ETF | 146.52 | 146.6 | 146.51 | 146.58 | 98700.0 |
| 2012-09-18 07:30:00 | SPY | ETF | 146.58 | 146.6 | 146.49 | 146.49 | 157397.0 |
| 2012-09-18 07:35:00 | SPY | ETF | 146.49 | 146.54 | 146.49 | 146.52 | 78300.0 |
| 2012-09-18 07:40:00 | SPY | ETF | 146.51 | 146.53 | 146.5 | 146.5 | 600.0 |
| 2012-09-18 07:45:00 | SPY | ETF | 146.5 | 146.53 | 146.5 | 146.53 | 3300.0 |
| 2012-09-18 07:50:00 | SPY | ETF | 146.5 | 146.53 | 146.5 | 146.53 | 505.0 |
| 2012-09-18 07:55:00 | SPY | ETF | 146.55 | 146.59 | 146.55 | 146.58 | 16500.0 |
| 2012-09-18 08:00:00 | SPY | ETF | 146.59 | 146.99 | 146.5 | 146.54 | 609645.0 |
| 2012-09-18 08:05:00 | SPY | ETF | 146.5 | 146.55 | 146.5 | 146.53 | 225660.0 |
| 2012-09-18 08:10:00 | SPY | ETF | 146.53 | 146.54 | 146.5 | 146.53 | 53630.0 |
| 2012-09-18 08:15:00 | SPY | ETF | 146.53 | 146.53 | 146.42 | 146.45 | 79380.0 |
| 2012-09-18 08:20:00 | SPY | ETF | 146.45 | 146.45 | 146.4 | 146.43 | 19353.0 |
| 2012-09-18 08:25:00 | SPY | ETF | 146.44 | 146.46 | 146.42 | 146.43 | 29900.0 |
| 2012-09-18 08:30:00 | SPY | ETF | 146.44 | 146.49 | 146.43 | 146.47 | 25574.0 |
| 2012-09-18 08:35:00 | SPY | ETF | 146.48 | 146.54 | 146.48 | 146.53 | 42870.0 |
| 2012-09-18 08:40:00 | SPY | ETF | 146.54 | 146.58 | 146.51 | 146.56 | 75028.0 |
| 2012-09-18 08:45:00 | SPY | ETF | 146.56 | 146.76 | 146.56 | 146.73 | 123769.0 |
| 2012-09-18 08:50:00 | SPY | ETF | 146.74 | 146.74 | 146.65 | 146.7 | 70796.0 |
> showing 50 of 36,439 rows — these rows as CSV