PREVIEW / etf_5min / 2011-12-16
file: by_date/etf_5min/2011/2011-12-16.parquet size: 877 KB rows: 36,828
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-16 04:00:00 | SPY | ETF | 122.76 | 122.76 | 122.31 | 122.51 | 56047.0 |
| 2011-12-16 04:05:00 | SPY | ETF | 122.48 | 122.48 | 122.4 | 122.48 | 9400.0 |
| 2011-12-16 04:10:00 | SPY | ETF | 122.41 | 122.41 | 122.41 | 122.41 | 2000.0 |
| 2011-12-16 04:15:00 | SPY | ETF | 122.42 | 122.43 | 122.42 | 122.43 | 200.0 |
| 2011-12-16 04:20:00 | SPY | ETF | 122.43 | 122.5 | 122.43 | 122.47 | 1150.0 |
| 2011-12-16 04:25:00 | SPY | ETF | 122.35 | 122.35 | 122.3 | 122.3 | 700.0 |
| 2011-12-16 04:30:00 | SPY | ETF | 122.37 | 122.45 | 122.37 | 122.45 | 2800.0 |
| 2011-12-16 04:35:00 | SPY | ETF | 122.38 | 122.38 | 122.38 | 122.38 | 100.0 |
| 2011-12-16 04:50:00 | SPY | ETF | 122.36 | 122.36 | 122.26 | 122.26 | 800.0 |
| 2011-12-16 05:00:00 | SPY | ETF | 122.27 | 122.27 | 122.2 | 122.2 | 300.0 |
| 2011-12-16 05:05:00 | SPY | ETF | 122.18 | 122.29 | 122.18 | 122.29 | 5600.0 |
| 2011-12-16 05:10:00 | SPY | ETF | 122.29 | 122.29 | 122.29 | 122.29 | 2100.0 |
| 2011-12-16 05:20:00 | SPY | ETF | 122.3 | 122.3 | 122.3 | 122.3 | 1922.0 |
| 2011-12-16 05:25:00 | SPY | ETF | 122.29 | 122.38 | 122.29 | 122.32 | 39900.0 |
| 2011-12-16 05:30:00 | SPY | ETF | 122.33 | 122.35 | 122.3 | 122.3 | 52200.0 |
| 2011-12-16 05:35:00 | SPY | ETF | 122.4 | 122.4 | 122.4 | 122.4 | 100.0 |
| 2011-12-16 05:40:00 | SPY | ETF | 122.42 | 122.55 | 122.42 | 122.5 | 6700.0 |
| 2011-12-16 05:45:00 | SPY | ETF | 122.39 | 122.45 | 122.39 | 122.45 | 2100.0 |
| 2011-12-16 05:50:00 | SPY | ETF | 122.62 | 122.64 | 122.55 | 122.55 | 2500.0 |
| 2011-12-16 05:55:00 | SPY | ETF | 122.53 | 122.53 | 122.41 | 122.41 | 10100.0 |
| 2011-12-16 06:00:00 | SPY | ETF | 122.42 | 122.42 | 122.37 | 122.37 | 2400.0 |
| 2011-12-16 06:05:00 | SPY | ETF | 122.35 | 122.35 | 122.35 | 122.35 | 1000.0 |
| 2011-12-16 06:10:00 | SPY | ETF | 122.33 | 122.33 | 122.22 | 122.22 | 10700.0 |
| 2011-12-16 06:15:00 | SPY | ETF | 122.26 | 122.26 | 122.2 | 122.26 | 9700.0 |
| 2011-12-16 06:20:00 | SPY | ETF | 122.25 | 122.35 | 122.25 | 122.35 | 300.0 |
| 2011-12-16 06:30:00 | SPY | ETF | 122.31 | 122.31 | 122.31 | 122.31 | 100.0 |
| 2011-12-16 06:35:00 | SPY | ETF | 122.35 | 122.35 | 122.35 | 122.35 | 100.0 |
| 2011-12-16 06:40:00 | SPY | ETF | 122.29 | 122.29 | 122.26 | 122.29 | 20350.0 |
| 2011-12-16 06:45:00 | SPY | ETF | 122.29 | 122.32 | 122.27 | 122.28 | 8900.0 |
| 2011-12-16 06:50:00 | SPY | ETF | 122.25 | 122.26 | 122.25 | 122.26 | 2200.0 |
| 2011-12-16 06:55:00 | SPY | ETF | 122.3 | 122.43 | 122.3 | 122.39 | 23700.0 |
| 2011-12-16 07:00:00 | SPY | ETF | 122.38 | 122.38 | 122.27 | 122.37 | 37399.0 |
| 2011-12-16 07:05:00 | SPY | ETF | 122.35 | 122.38 | 122.22 | 122.25 | 118850.0 |
| 2011-12-16 07:10:00 | SPY | ETF | 122.28 | 122.36 | 122.25 | 122.25 | 11294.0 |
| 2011-12-16 07:15:00 | SPY | ETF | 122.31 | 122.35 | 122.3 | 122.3 | 3700.0 |
| 2011-12-16 07:20:00 | SPY | ETF | 122.37 | 122.44 | 122.37 | 122.44 | 34032.0 |
| 2011-12-16 07:25:00 | SPY | ETF | 122.44 | 122.5 | 122.4 | 122.45 | 46267.0 |
| 2011-12-16 07:30:00 | SPY | ETF | 122.45 | 122.64 | 122.45 | 122.63 | 72300.0 |
| 2011-12-16 07:35:00 | SPY | ETF | 122.65 | 122.65 | 122.54 | 122.57 | 25406.0 |
| 2011-12-16 07:40:00 | SPY | ETF | 122.58 | 122.58 | 122.46 | 122.47 | 10610.0 |
| 2011-12-16 07:45:00 | SPY | ETF | 122.5 | 122.51 | 122.42 | 122.49 | 66400.0 |
| 2011-12-16 07:50:00 | SPY | ETF | 122.49 | 122.58 | 122.48 | 122.57 | 22500.0 |
| 2011-12-16 07:55:00 | SPY | ETF | 122.57 | 122.57 | 122.47 | 122.51 | 78032.0 |
| 2011-12-16 08:00:00 | SPY | ETF | 122.54 | 122.58 | 122.49 | 122.53 | 1283960.0 |
| 2011-12-16 08:05:00 | SPY | ETF | 122.52 | 122.68 | 122.52 | 122.63 | 343755.0 |
| 2011-12-16 08:10:00 | SPY | ETF | 122.63 | 122.67 | 122.55 | 122.58 | 43455.0 |
| 2011-12-16 08:15:00 | SPY | ETF | 122.58 | 122.6 | 122.56 | 122.57 | 82973.0 |
| 2011-12-16 08:20:00 | SPY | ETF | 122.56 | 122.65 | 122.54 | 122.62 | 252604.0 |
| 2011-12-16 08:25:00 | SPY | ETF | 122.63 | 122.68 | 122.53 | 122.54 | 268440.0 |
| 2011-12-16 08:30:00 | SPY | ETF | 122.54 | 122.59 | 122.4 | 122.43 | 763361.0 |
> showing 50 of 36,828 rows — these rows as CSV