PREVIEW / etf_5min / 2007-05-09
file: by_date/etf_5min/2007/2007-05-09.parquet size: 294 KB rows: 14,599
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-09 05:15:00 | SPY | ETF | 150.83 | 150.83 | 150.83 | 150.83 | 500.0 |
| 2007-05-09 06:05:00 | SPY | ETF | 150.79 | 150.79 | 150.79 | 150.79 | 7500.0 |
| 2007-05-09 06:10:00 | SPY | ETF | 150.77 | 150.79 | 150.77 | 150.79 | 10000.0 |
| 2007-05-09 06:55:00 | SPY | ETF | 150.7 | 150.7 | 150.66 | 150.66 | 5200.0 |
| 2007-05-09 07:00:00 | SPY | ETF | 150.68 | 150.68 | 150.68 | 150.68 | 1000.0 |
| 2007-05-09 07:10:00 | SPY | ETF | 150.68 | 150.69 | 150.68 | 150.69 | 11100.0 |
| 2007-05-09 07:15:00 | SPY | ETF | 150.69 | 150.69 | 150.69 | 150.69 | 1000.0 |
| 2007-05-09 07:25:00 | SPY | ETF | 150.69 | 150.69 | 150.65 | 150.65 | 10600.0 |
| 2007-05-09 07:40:00 | SPY | ETF | 150.7 | 150.7 | 150.7 | 150.7 | 200.0 |
| 2007-05-09 07:45:00 | SPY | ETF | 150.69 | 150.72 | 150.69 | 150.72 | 800.0 |
| 2007-05-09 07:50:00 | SPY | ETF | 150.71 | 150.71 | 150.7 | 150.7 | 4000.0 |
| 2007-05-09 07:55:00 | SPY | ETF | 150.69 | 150.69 | 150.64 | 150.64 | 21500.0 |
| 2007-05-09 08:00:00 | SPY | ETF | 150.61 | 150.61 | 150.56 | 150.57 | 10900.0 |
| 2007-05-09 08:05:00 | SPY | ETF | 150.59 | 150.6 | 150.55 | 150.55 | 28600.0 |
| 2007-05-09 08:10:00 | SPY | ETF | 150.55 | 150.6 | 150.51 | 150.55 | 596300.0 |
| 2007-05-09 08:15:00 | SPY | ETF | 150.58 | 150.63 | 150.53 | 150.63 | 100300.0 |
| 2007-05-09 08:20:00 | SPY | ETF | 150.63 | 150.64 | 150.62 | 150.62 | 10000.0 |
| 2007-05-09 08:25:00 | SPY | ETF | 150.65 | 150.65 | 150.59 | 150.6 | 37700.0 |
| 2007-05-09 08:30:00 | SPY | ETF | 150.58 | 150.59 | 150.55 | 150.58 | 19800.0 |
| 2007-05-09 08:35:00 | SPY | ETF | 150.63 | 150.63 | 150.61 | 150.62 | 2500.0 |
| 2007-05-09 08:40:00 | SPY | ETF | 150.6 | 150.6 | 150.58 | 150.6 | 9300.0 |
| 2007-05-09 08:45:00 | SPY | ETF | 150.6 | 150.61 | 150.58 | 150.61 | 16900.0 |
| 2007-05-09 08:50:00 | SPY | ETF | 150.62 | 150.64 | 150.56 | 150.64 | 611300.0 |
| 2007-05-09 08:55:00 | SPY | ETF | 150.64 | 150.64 | 150.59 | 150.64 | 306800.0 |
| 2007-05-09 09:00:00 | SPY | ETF | 150.65 | 150.66 | 150.56 | 150.58 | 1137100.0 |
| 2007-05-09 09:05:00 | SPY | ETF | 150.57 | 150.59 | 150.53 | 150.57 | 112800.0 |
| 2007-05-09 09:10:00 | SPY | ETF | 150.58 | 150.58 | 150.46 | 150.58 | 393500.0 |
| 2007-05-09 09:15:00 | SPY | ETF | 150.59 | 150.59 | 150.57 | 150.58 | 34500.0 |
| 2007-05-09 09:20:00 | SPY | ETF | 150.58 | 150.6 | 150.53 | 150.56 | 585400.0 |
| 2007-05-09 09:25:00 | SPY | ETF | 150.56 | 150.63 | 150.51 | 150.63 | 135900.0 |
| 2007-05-09 09:30:00 | SPY | ETF | 150.64 | 150.68 | 150.51 | 150.67 | 1215793.0 |
| 2007-05-09 09:35:00 | SPY | ETF | 150.68 | 150.73 | 150.62 | 150.64 | 788100.0 |
| 2007-05-09 09:40:00 | SPY | ETF | 150.64 | 150.64 | 150.55 | 150.6 | 979015.0 |
| 2007-05-09 09:45:00 | SPY | ETF | 150.6 | 150.77 | 150.6 | 150.63 | 1239200.0 |
| 2007-05-09 09:50:00 | SPY | ETF | 150.63 | 150.73 | 150.6 | 150.64 | 1460900.0 |
| 2007-05-09 09:55:00 | SPY | ETF | 150.65 | 150.7 | 150.63 | 150.63 | 693800.0 |
| 2007-05-09 10:00:00 | SPY | ETF | 150.64 | 150.86 | 150.63 | 150.82 | 720300.0 |
| 2007-05-09 10:05:00 | SPY | ETF | 150.81 | 150.93 | 150.79 | 150.83 | 1313400.0 |
| 2007-05-09 10:10:00 | SPY | ETF | 150.83 | 150.87 | 150.76 | 150.78 | 554900.0 |
| 2007-05-09 10:15:00 | SPY | ETF | 150.78 | 150.81 | 150.77 | 150.79 | 238600.0 |
| 2007-05-09 10:20:00 | SPY | ETF | 150.79 | 150.83 | 150.76 | 150.78 | 356400.0 |
| 2007-05-09 10:25:00 | SPY | ETF | 150.79 | 150.83 | 150.79 | 150.81 | 279600.0 |
| 2007-05-09 10:30:00 | SPY | ETF | 150.81 | 150.82 | 150.72 | 150.7215 | 806400.0 |
| 2007-05-09 10:35:00 | SPY | ETF | 150.73 | 150.77 | 150.64 | 150.69 | 1230300.0 |
| 2007-05-09 10:40:00 | SPY | ETF | 150.69 | 150.74 | 150.67 | 150.69 | 610450.0 |
| 2007-05-09 10:45:00 | SPY | ETF | 150.69 | 150.73 | 150.68 | 150.71 | 253100.0 |
| 2007-05-09 10:50:00 | SPY | ETF | 150.71 | 150.74 | 150.7 | 150.7199 | 180600.0 |
| 2007-05-09 10:55:00 | SPY | ETF | 150.7101 | 150.74 | 150.68 | 150.7115 | 170200.0 |
| 2007-05-09 11:00:00 | SPY | ETF | 150.72 | 150.84 | 150.72 | 150.82 | 772609.0 |
| 2007-05-09 11:05:00 | SPY | ETF | 150.81 | 150.83 | 150.78 | 150.8 | 579000.0 |
> showing 50 of 14,599 rows — these rows as CSV