PREVIEW / etf_1hour / 2008-04-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-04.parquet
  size:    100 KB
  rows:    3,330

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-04-04 05:00:00	SPY	ETF	137.07	137.07	137.07	137.07	10000.0
2008-04-04 07:00:00	SPY	ETF	137.04	137.83	137.04	137.72	1528200.0
2008-04-04 08:00:00	SPY	ETF	137.72	138.28	136.53	137.46	22460031.0
2008-04-04 09:00:00	SPY	ETF	137.45	137.5	136.46	136.78	26626683.0
2008-04-04 10:00:00	SPY	ETF	136.78	137.0	136.12	136.69	28261861.0
2008-04-04 11:00:00	SPY	ETF	136.69	137.25	136.66	136.84	23158653.0
2008-04-04 12:00:00	SPY	ETF	136.85	137.81	136.8	137.72	20526009.0
2008-04-04 13:00:00	SPY	ETF	137.73	137.96	137.51	137.65	16056726.0
2008-04-04 14:00:00	SPY	ETF	137.65	137.75	137.17	137.43	18992268.0
2008-04-04 15:00:00	SPY	ETF	137.43	137.58	136.55	136.97	32689155.0
2008-04-04 16:00:00	SPY	ETF	136.9199	137.42	136.28	136.86	6983300.0
2008-04-04 17:00:00	SPY	ETF	136.84	137.1	136.8	137.1	4030100.0
2008-04-04 18:00:00	SPY	ETF	137.01	137.01	136.86	136.9	28500.0
2008-04-04 19:00:00	SPY	ETF	136.88	137.04	136.88	137.04	2200.0
2008-04-04 06:00:00	QQQ	ETF	45.79	45.8	45.76	45.77	12500.0
2008-04-04 07:00:00	QQQ	ETF	45.82	45.99	45.8	45.99	466135.0
2008-04-04 08:00:00	QQQ	ETF	45.98	46.06	45.63	45.91	10190251.0
2008-04-04 09:00:00	QQQ	ETF	45.92	45.93	45.59	45.78	15940460.0
2008-04-04 10:00:00	QQQ	ETF	45.7775	45.82	45.4	45.64	23196921.0
2008-04-04 11:00:00	QQQ	ETF	45.65	45.86	45.64	45.76	13569111.0
2008-04-04 12:00:00	QQQ	ETF	45.77	46.21	45.75	46.17	21697848.0
2008-04-04 13:00:00	QQQ	ETF	46.18	46.35	46.11	46.19	11697515.0
2008-04-04 14:00:00	QQQ	ETF	46.182	46.24	46.01	46.06	15784340.0
2008-04-04 15:00:00	QQQ	ETF	46.07	46.12	45.77	45.87	24577113.0
2008-04-04 16:00:00	QQQ	ETF	45.86	45.9025	45.4293	45.82	1715082.0
2008-04-04 17:00:00	QQQ	ETF	45.81	45.84	45.75	45.82	234016.0
2008-04-04 18:00:00	QQQ	ETF	45.84	45.84	45.8	45.83	8900.0
2008-04-04 19:00:00	QQQ	ETF	45.83	45.83	45.79	45.79	9150.0
2008-04-04 06:00:00	IWM	ETF	71.44	71.44	71.44	71.44	1000.0
2008-04-04 07:00:00	IWM	ETF	71.48	71.69	71.48	71.68	131500.0
2008-04-04 08:00:00	IWM	ETF	71.66	71.9	70.96	71.46	2417814.0
2008-04-04 09:00:00	IWM	ETF	71.45	71.45	70.71	71.1	10356458.0
2008-04-04 10:00:00	IWM	ETF	71.1	71.17	70.64	71.11	8480490.0
2008-04-04 11:00:00	IWM	ETF	71.12	71.48	71.09	71.33	6876486.0
2008-04-04 12:00:00	IWM	ETF	71.34	71.81	71.29	71.75	7124510.0
2008-04-04 13:00:00	IWM	ETF	71.76	71.89	71.57	71.62	4131301.0
2008-04-04 14:00:00	IWM	ETF	71.62	71.7	71.15	71.38	7330519.0
2008-04-04 15:00:00	IWM	ETF	71.38	71.52	70.92	71.18	11172521.0
2008-04-04 16:00:00	IWM	ETF	71.19	71.82	71.03	71.04	2176700.0
2008-04-04 17:00:00	IWM	ETF	71.04	71.43	71.03	71.43	1800.0
2008-04-04 07:00:00	DIA	ETF	126.42	126.81	126.42	126.81	4900.0
2008-04-04 08:00:00	DIA	ETF	126.76	127.79	125.98	126.55	388900.0
2008-04-04 09:00:00	DIA	ETF	126.6	126.6	125.62	125.8	2061574.0
2008-04-04 10:00:00	DIA	ETF	125.82	125.89	125.2	125.71	2018389.0
2008-04-04 11:00:00	DIA	ETF	125.74	126.16	125.69	125.87	1399449.0
2008-04-04 12:00:00	DIA	ETF	125.87	126.71	125.82	126.62	1649104.0
2008-04-04 13:00:00	DIA	ETF	126.63	126.81	126.47	126.56	1117551.0
2008-04-04 14:00:00	DIA	ETF	126.55	126.69	126.2	126.41	1241739.0
2008-04-04 15:00:00	DIA	ETF	126.41	126.56	125.66	126.05	2568996.0
2008-04-04 16:00:00	DIA	ETF	126.06	126.11	125.95	126.11	54800.0

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

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