PREVIEW / etf_1hour / 2008-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-09.parquet
  size:    111 KB
  rows:    3,534

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
2008-07-09 04:00:00	SPY	ETF	126.8	126.8	126.8	126.8	100.0
2008-07-09 05:00:00	SPY	ETF	126.93	127.1	126.9	127.1	27000.0
2008-07-09 06:00:00	SPY	ETF	127.1	127.1	126.77	126.92	175300.0
2008-07-09 07:00:00	SPY	ETF	126.94	127.58	126.79	127.51	3134617.0
2008-07-09 08:00:00	SPY	ETF	127.53	127.75	126.95	127.62	6120871.0
2008-07-09 09:00:00	SPY	ETF	127.63	127.74	126.92	127.16	38430767.0
2008-07-09 10:00:00	SPY	ETF	127.16	127.63	126.79	127.45	64772813.0
2008-07-09 11:00:00	SPY	ETF	127.45	127.74	127.06	127.23	37746431.0
2008-07-09 12:00:00	SPY	ETF	127.232	127.39	126.7	126.78	24850584.0
2008-07-09 13:00:00	SPY	ETF	126.78	126.89	126.39	126.61	27211094.0
2008-07-09 14:00:00	SPY	ETF	126.6	127.3346	125.53	125.64	51817826.0
2008-07-09 15:00:00	SPY	ETF	125.65	125.67	124.39	124.45	66180086.0
2008-07-09 16:00:00	SPY	ETF	124.468	127.3346	124.44	124.5	9497193.0
2008-07-09 17:00:00	SPY	ETF	124.45	126.5292	124.39	124.39	293709.0
2008-07-09 18:00:00	SPY	ETF	124.4	124.47	124.37	124.41	85138.0
2008-07-09 19:00:00	SPY	ETF	124.42	124.47	124.38	124.45	57303.0
2008-07-09 04:00:00	QQQ	ETF	45.66	45.67	45.66	45.67	10000.0
2008-07-09 05:00:00	QQQ	ETF	45.74	45.74	45.74	45.74	5000.0
2008-07-09 06:00:00	QQQ	ETF	45.8	45.8	45.8	45.8	2000.0
2008-07-09 07:00:00	QQQ	ETF	45.77	45.97	45.68	45.97	567403.0
2008-07-09 08:00:00	QQQ	ETF	45.97	46.03	45.95	45.95	1825903.0
2008-07-09 09:00:00	QQQ	ETF	45.94	45.98	45.58	45.72	20003932.0
2008-07-09 10:00:00	QQQ	ETF	45.72	45.94	45.58	45.85	24436140.0
2008-07-09 11:00:00	QQQ	ETF	45.8499	46.03	45.73	45.78	20606241.0
2008-07-09 12:00:00	QQQ	ETF	45.78	45.81	45.54	45.64	16303705.0
2008-07-09 13:00:00	QQQ	ETF	45.63	45.7	45.45	45.63	11573160.0
2008-07-09 14:00:00	QQQ	ETF	45.63	45.74	45.25	45.35	21777379.0
2008-07-09 15:00:00	QQQ	ETF	45.34	45.34	44.73	44.75	32079522.0
2008-07-09 16:00:00	QQQ	ETF	44.75	45.97	44.73	44.81	9748350.0
2008-07-09 17:00:00	QQQ	ETF	44.8	44.85	44.79	44.84	177469.0
2008-07-09 18:00:00	QQQ	ETF	44.83	44.84	44.8	44.82	130875.0
2008-07-09 19:00:00	QQQ	ETF	44.82	44.84	44.79	44.84	72402.0
2008-07-09 04:00:00	IWM	ETF	67.85	67.85	67.85	67.85	300.0
2008-07-09 07:00:00	IWM	ETF	67.97	68.25	67.97	68.24	97728.0
2008-07-09 08:00:00	IWM	ETF	68.25	68.33	68.15	68.22	413184.0
2008-07-09 09:00:00	IWM	ETF	68.21	68.23	67.5	67.73	11154513.0
2008-07-09 10:00:00	IWM	ETF	67.73	68.09	67.48	67.95	16509544.0
2008-07-09 11:00:00	IWM	ETF	67.95	68.27	67.86	67.93	13467786.0
2008-07-09 12:00:00	IWM	ETF	67.92	67.98	67.48	67.54	9706734.0
2008-07-09 13:00:00	IWM	ETF	67.54	67.66	67.26	67.6	10653956.0
2008-07-09 14:00:00	IWM	ETF	67.6	68.55	66.92	67.03	13749765.0
2008-07-09 15:00:00	IWM	ETF	67.03	68.4	66.0	66.04	29396356.0
2008-07-09 16:00:00	IWM	ETF	66.04	68.07	66.02	66.21	14375337.0
2008-07-09 17:00:00	IWM	ETF	66.13	66.18	66.13	66.18	5205.0
2008-07-09 18:00:00	IWM	ETF	66.13	66.13	66.13	66.13	400.0
2008-07-09 19:00:00	IWM	ETF	66.23	66.23	66.23	66.23	2800.0
2008-07-09 07:00:00	DIA	ETF	113.86	114.06	113.8	114.05	8301.0
2008-07-09 08:00:00	DIA	ETF	114.06	114.21	114.04	114.13	45323.0
2008-07-09 09:00:00	DIA	ETF	114.07	114.2	113.36	113.54	2916409.0
2008-07-09 10:00:00	DIA	ETF	113.51	113.91	113.2	113.79	5396234.0

> showing 50 of 3,534 rows — these rows as CSV

> unlock the full archive -- $79 one-time