PREVIEW / etf_5min / 2007-05-30
file: by_date/etf_5min/2007/2007-05-30.parquet size: 315 KB rows: 15,756
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-30 04:15:00 | SPY | ETF | 151.78 | 151.78 | 151.78 | 151.78 | 100.0 |
| 2007-05-30 05:35:00 | SPY | ETF | 151.6 | 151.6 | 151.6 | 151.6 | 20000.0 |
| 2007-05-30 05:40:00 | SPY | ETF | 151.63 | 151.63 | 151.63 | 151.63 | 10000.0 |
| 2007-05-30 06:05:00 | SPY | ETF | 151.62 | 151.62 | 151.62 | 151.62 | 10000.0 |
| 2007-05-30 06:15:00 | SPY | ETF | 151.62 | 151.62 | 151.62 | 151.62 | 3200.0 |
| 2007-05-30 06:40:00 | SPY | ETF | 151.72 | 151.72 | 151.72 | 151.72 | 2000.0 |
| 2007-05-30 06:45:00 | SPY | ETF | 151.7 | 151.7 | 151.67 | 151.67 | 30000.0 |
| 2007-05-30 07:00:00 | SPY | ETF | 151.62 | 151.62 | 151.54 | 151.55 | 84400.0 |
| 2007-05-30 07:05:00 | SPY | ETF | 151.51 | 151.55 | 151.51 | 151.52 | 12600.0 |
| 2007-05-30 07:10:00 | SPY | ETF | 151.52 | 151.57 | 151.51 | 151.51 | 76300.0 |
| 2007-05-30 07:15:00 | SPY | ETF | 151.51 | 151.52 | 151.51 | 151.51 | 25000.0 |
| 2007-05-30 07:20:00 | SPY | ETF | 151.56 | 151.58 | 151.55 | 151.57 | 36800.0 |
| 2007-05-30 07:25:00 | SPY | ETF | 151.55 | 151.55 | 151.45 | 151.45 | 159800.0 |
| 2007-05-30 07:30:00 | SPY | ETF | 151.53 | 151.58 | 151.53 | 151.56 | 52200.0 |
| 2007-05-30 07:35:00 | SPY | ETF | 151.55 | 151.55 | 151.53 | 151.53 | 10500.0 |
| 2007-05-30 07:40:00 | SPY | ETF | 151.5 | 151.53 | 151.49 | 151.5 | 116400.0 |
| 2007-05-30 07:45:00 | SPY | ETF | 151.55 | 151.61 | 151.55 | 151.61 | 29100.0 |
| 2007-05-30 07:50:00 | SPY | ETF | 151.57 | 151.65 | 151.56 | 151.63 | 14600.0 |
| 2007-05-30 07:55:00 | SPY | ETF | 151.65 | 151.65 | 151.61 | 151.64 | 137000.0 |
| 2007-05-30 08:00:00 | SPY | ETF | 151.64 | 151.71 | 151.58 | 151.68 | 196300.0 |
| 2007-05-30 08:05:00 | SPY | ETF | 151.7 | 151.75 | 151.7 | 151.7 | 133000.0 |
| 2007-05-30 08:10:00 | SPY | ETF | 151.7 | 151.72 | 151.66 | 151.66 | 105800.0 |
| 2007-05-30 08:15:00 | SPY | ETF | 151.66 | 151.66 | 151.6 | 151.61 | 217000.0 |
| 2007-05-30 08:20:00 | SPY | ETF | 151.63 | 151.66 | 151.61 | 151.63 | 117100.0 |
| 2007-05-30 08:25:00 | SPY | ETF | 151.64 | 151.64 | 151.59 | 151.59 | 57700.0 |
| 2007-05-30 08:30:00 | SPY | ETF | 151.59 | 151.61 | 151.58 | 151.58 | 84400.0 |
| 2007-05-30 08:35:00 | SPY | ETF | 151.57 | 151.58 | 151.48 | 151.53 | 327400.0 |
| 2007-05-30 08:40:00 | SPY | ETF | 151.53 | 151.9 | 151.53 | 151.56 | 53600.0 |
| 2007-05-30 08:45:00 | SPY | ETF | 151.55 | 151.56 | 151.54 | 151.56 | 26300.0 |
| 2007-05-30 08:50:00 | SPY | ETF | 151.56 | 151.59 | 151.54 | 151.55 | 45500.0 |
| 2007-05-30 08:55:00 | SPY | ETF | 151.56 | 151.57 | 151.55 | 151.56 | 13800.0 |
| 2007-05-30 09:00:00 | SPY | ETF | 151.55 | 151.57 | 151.53 | 151.56 | 33100.0 |
| 2007-05-30 09:05:00 | SPY | ETF | 151.56 | 151.57 | 151.53 | 151.53 | 21500.0 |
| 2007-05-30 09:10:00 | SPY | ETF | 151.54 | 151.54 | 151.45 | 151.45 | 96400.0 |
| 2007-05-30 09:15:00 | SPY | ETF | 151.46 | 151.5 | 151.45 | 151.5 | 62100.0 |
| 2007-05-30 09:20:00 | SPY | ETF | 151.5 | 151.51 | 151.44 | 151.47 | 111200.0 |
| 2007-05-30 09:25:00 | SPY | ETF | 151.47 | 151.49 | 151.45 | 151.45 | 163400.0 |
| 2007-05-30 09:30:00 | SPY | ETF | 151.46 | 151.56 | 151.34 | 151.42 | 5343264.0 |
| 2007-05-30 09:35:00 | SPY | ETF | 151.43 | 151.64 | 151.41 | 151.53 | 3255600.0 |
| 2007-05-30 09:40:00 | SPY | ETF | 151.54 | 151.66 | 151.53 | 151.57 | 2315311.0 |
| 2007-05-30 09:45:00 | SPY | ETF | 151.56 | 151.65 | 151.52 | 151.57 | 1776600.0 |
| 2007-05-30 09:50:00 | SPY | ETF | 151.56 | 151.77 | 151.49 | 151.74 | 2567297.0 |
| 2007-05-30 09:55:00 | SPY | ETF | 151.74 | 151.84 | 151.65 | 151.8 | 2355000.0 |
| 2007-05-30 10:00:00 | SPY | ETF | 151.8 | 151.84 | 151.71 | 151.73 | 1422993.0 |
| 2007-05-30 10:05:00 | SPY | ETF | 151.73 | 151.87 | 151.69 | 151.87 | 1659500.0 |
| 2007-05-30 10:10:00 | SPY | ETF | 151.86 | 151.93 | 151.81 | 151.85 | 1782200.0 |
| 2007-05-30 10:15:00 | SPY | ETF | 151.85 | 152.06 | 151.85 | 151.98 | 2010708.0 |
| 2007-05-30 10:20:00 | SPY | ETF | 151.98 | 152.01 | 151.86 | 151.91 | 1340899.0 |
| 2007-05-30 10:25:00 | SPY | ETF | 151.91 | 151.97 | 151.85 | 151.94 | 1320600.0 |
| 2007-05-30 10:30:00 | SPY | ETF | 151.94 | 152.06 | 151.73 | 151.77 | 2657150.0 |
> showing 50 of 15,756 rows — these rows as CSV