PREVIEW / etf_5min / 2010-04-20
file: by_date/etf_5min/2010/2010-04-20.parquet size: 769 KB rows: 32,987
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-20 04:15:00 | SPY | ETF | 120.16 | 120.16 | 120.16 | 120.16 | 900.0 |
| 2010-04-20 04:20:00 | SPY | ETF | 120.16 | 120.16 | 120.16 | 120.16 | 100.0 |
| 2010-04-20 04:25:00 | SPY | ETF | 120.13 | 120.13 | 120.13 | 120.13 | 500.0 |
| 2010-04-20 04:35:00 | SPY | ETF | 120.04 | 120.04 | 120.04 | 120.04 | 1500.0 |
| 2010-04-20 05:05:00 | SPY | ETF | 119.95 | 119.95 | 119.95 | 119.95 | 1000.0 |
| 2010-04-20 05:10:00 | SPY | ETF | 120.0 | 120.0 | 120.0 | 120.0 | 20000.0 |
| 2010-04-20 05:15:00 | SPY | ETF | 120.05 | 120.05 | 120.05 | 120.05 | 700.0 |
| 2010-04-20 05:30:00 | SPY | ETF | 120.18 | 120.18 | 120.15 | 120.15 | 10700.0 |
| 2010-04-20 05:45:00 | SPY | ETF | 120.2 | 120.2 | 120.2 | 120.2 | 200.0 |
| 2010-04-20 05:55:00 | SPY | ETF | 120.23 | 120.23 | 120.23 | 120.23 | 400.0 |
| 2010-04-20 06:00:00 | SPY | ETF | 120.3 | 120.3 | 120.3 | 120.3 | 100.0 |
| 2010-04-20 06:10:00 | SPY | ETF | 120.33 | 120.33 | 120.33 | 120.33 | 100.0 |
| 2010-04-20 06:15:00 | SPY | ETF | 120.42 | 120.44 | 120.42 | 120.44 | 2000.0 |
| 2010-04-20 06:20:00 | SPY | ETF | 120.44 | 120.53 | 120.44 | 120.53 | 8900.0 |
| 2010-04-20 06:30:00 | SPY | ETF | 120.5 | 120.54 | 120.47 | 120.47 | 10300.0 |
| 2010-04-20 06:35:00 | SPY | ETF | 120.46 | 120.46 | 120.46 | 120.46 | 100.0 |
| 2010-04-20 06:40:00 | SPY | ETF | 120.53 | 120.63 | 120.53 | 120.62 | 7250.0 |
| 2010-04-20 06:45:00 | SPY | ETF | 120.59 | 120.6 | 120.59 | 120.6 | 6500.0 |
| 2010-04-20 06:50:00 | SPY | ETF | 120.6 | 120.6 | 120.58 | 120.58 | 300.0 |
| 2010-04-20 06:55:00 | SPY | ETF | 120.59 | 120.7 | 120.59 | 120.7 | 2700.0 |
| 2010-04-20 07:00:00 | SPY | ETF | 120.66 | 120.79 | 120.55 | 120.56 | 190200.0 |
| 2010-04-20 07:05:00 | SPY | ETF | 120.55 | 120.57 | 120.52 | 120.53 | 19400.0 |
| 2010-04-20 07:10:00 | SPY | ETF | 120.52 | 120.53 | 120.46 | 120.46 | 113400.0 |
| 2010-04-20 07:15:00 | SPY | ETF | 120.46 | 120.48 | 120.4 | 120.42 | 60429.0 |
| 2010-04-20 07:20:00 | SPY | ETF | 120.43 | 120.46 | 120.4 | 120.46 | 53725.0 |
| 2010-04-20 07:25:00 | SPY | ETF | 120.43 | 120.51 | 120.43 | 120.51 | 42400.0 |
| 2010-04-20 07:30:00 | SPY | ETF | 120.5 | 120.53 | 120.5 | 120.53 | 138300.0 |
| 2010-04-20 07:35:00 | SPY | ETF | 120.55 | 120.58 | 120.52 | 120.52 | 310299.0 |
| 2010-04-20 07:40:00 | SPY | ETF | 120.52 | 120.58 | 120.52 | 120.56 | 246729.0 |
| 2010-04-20 07:45:00 | SPY | ETF | 120.56 | 120.56 | 120.42 | 120.43 | 148180.0 |
| 2010-04-20 07:50:00 | SPY | ETF | 120.43 | 120.48 | 120.42 | 120.42 | 80100.0 |
| 2010-04-20 07:55:00 | SPY | ETF | 120.43 | 120.46 | 120.41 | 120.44 | 83448.0 |
| 2010-04-20 08:00:00 | SPY | ETF | 120.44 | 120.55 | 120.44 | 120.53 | 67972.0 |
| 2010-04-20 08:05:00 | SPY | ETF | 120.53 | 120.53 | 120.47 | 120.52 | 57586.0 |
| 2010-04-20 08:10:00 | SPY | ETF | 120.53 | 120.56 | 120.52 | 120.52 | 122772.0 |
| 2010-04-20 08:15:00 | SPY | ETF | 120.52 | 120.53 | 120.49 | 120.51 | 43162.0 |
| 2010-04-20 08:20:00 | SPY | ETF | 120.5 | 120.51 | 120.45 | 120.45 | 37070.0 |
| 2010-04-20 08:25:00 | SPY | ETF | 120.45 | 120.5 | 119.81 | 120.5 | 189680.0 |
| 2010-04-20 08:30:00 | SPY | ETF | 120.51 | 120.51 | 120.4 | 120.41 | 91770.0 |
| 2010-04-20 08:35:00 | SPY | ETF | 120.41 | 120.46 | 120.38 | 120.4 | 190633.0 |
| 2010-04-20 08:40:00 | SPY | ETF | 120.41 | 120.42 | 120.38 | 120.4 | 194292.0 |
| 2010-04-20 08:45:00 | SPY | ETF | 120.41 | 120.43 | 120.36 | 120.42 | 326834.0 |
| 2010-04-20 08:50:00 | SPY | ETF | 120.43 | 120.46 | 120.43 | 120.43 | 151239.0 |
| 2010-04-20 08:55:00 | SPY | ETF | 120.45 | 120.45 | 120.43 | 120.43 | 58971.0 |
| 2010-04-20 09:00:00 | SPY | ETF | 120.44 | 120.45 | 120.4 | 120.43 | 188946.0 |
| 2010-04-20 09:05:00 | SPY | ETF | 120.43 | 120.46 | 120.42 | 120.45 | 154021.0 |
| 2010-04-20 09:10:00 | SPY | ETF | 120.45 | 120.53 | 120.45 | 120.5 | 290975.0 |
| 2010-04-20 09:15:00 | SPY | ETF | 120.51 | 120.54 | 120.46 | 120.5 | 464251.0 |
| 2010-04-20 09:20:00 | SPY | ETF | 120.49 | 120.51 | 120.45 | 120.51 | 123280.0 |
| 2010-04-20 09:25:00 | SPY | ETF | 120.5 | 120.58 | 120.5 | 120.56 | 340949.0 |
> showing 50 of 32,987 rows — these rows as CSV