PREVIEW / etf_1hour / 2009-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-21.parquet
  size:    148 KB
  rows:    4,630

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
2009-12-21 04:00:00	SPY	ETF	110.34	110.34	110.34	110.34	100.0
2009-12-21 05:00:00	SPY	ETF	110.35	110.35	110.34	110.34	1300.0
2009-12-21 06:00:00	SPY	ETF	110.48	110.61	110.45	110.58	24200.0
2009-12-21 07:00:00	SPY	ETF	110.58	110.83	110.58	110.8	147406.0
2009-12-21 08:00:00	SPY	ETF	110.82	110.82	110.66	110.68	1047525.0
2009-12-21 09:00:00	SPY	ETF	110.68	111.35	110.67	111.18	22185813.0
2009-12-21 10:00:00	SPY	ETF	111.19	111.58	111.18	111.35	21881469.0
2009-12-21 11:00:00	SPY	ETF	111.35	111.54	111.3	111.49	11028427.0
2009-12-21 12:00:00	SPY	ETF	111.49	111.7	111.39	111.49	14505229.0
2009-12-21 13:00:00	SPY	ETF	111.49	111.4999	111.3	111.42	9484491.0
2009-12-21 14:00:00	SPY	ETF	111.405	111.53	111.34	111.4	8358274.0
2009-12-21 15:00:00	SPY	ETF	111.4	111.4	111.14	111.34	18525171.0
2009-12-21 16:00:00	SPY	ETF	111.33	111.65	110.1563	111.2	10118156.0
2009-12-21 17:00:00	SPY	ETF	111.2	111.22	111.15	111.19	44102.0
2009-12-21 18:00:00	SPY	ETF	111.19	111.35	111.18	111.34	138423.0
2009-12-21 19:00:00	SPY	ETF	111.32	111.36	111.3	111.32	25888.0
2009-12-21 06:00:00	QQQ	ETF	44.62	44.63	44.62	44.63	1300.0
2009-12-21 07:00:00	QQQ	ETF	44.63	44.76	44.63	44.76	112872.0
2009-12-21 08:00:00	QQQ	ETF	44.76	44.77	44.68	44.68	628094.0
2009-12-21 09:00:00	QQQ	ETF	44.68	44.93	44.62	44.8983	12113035.0
2009-12-21 10:00:00	QQQ	ETF	44.9	45.06	44.87	44.97	13904887.0
2009-12-21 11:00:00	QQQ	ETF	44.97	45.06	44.8257	45.0	6250081.0
2009-12-21 12:00:00	QQQ	ETF	45.015	45.13	44.93	45.01	8120317.0
2009-12-21 13:00:00	QQQ	ETF	45.01	45.03	44.91	45.01	8067484.0
2009-12-21 14:00:00	QQQ	ETF	45.0	45.07	44.97	45.024	5664437.0
2009-12-21 15:00:00	QQQ	ETF	45.02	45.03	44.88	44.97	10537400.0
2009-12-21 16:00:00	QQQ	ETF	44.96	45.0	44.4351	44.93	6840130.0
2009-12-21 17:00:00	QQQ	ETF	44.92	44.96	44.4351	44.95	4021517.0
2009-12-21 18:00:00	QQQ	ETF	44.95	44.96	44.93	44.94	5200.0
2009-12-21 19:00:00	QQQ	ETF	44.97	44.99	44.94	44.95	23522.0
2009-12-21 06:00:00	IWM	ETF	61.5	61.5	61.5	61.5	700.0
2009-12-21 07:00:00	IWM	ETF	61.59	61.6	61.59	61.6	4186.0
2009-12-21 08:00:00	IWM	ETF	61.46	61.64	61.46	61.61	95604.0
2009-12-21 09:00:00	IWM	ETF	61.61	62.11	61.18	61.728	10013184.0
2009-12-21 10:00:00	IWM	ETF	61.72	62.01	61.7	61.79	7321232.0
2009-12-21 11:00:00	IWM	ETF	61.8	61.96	61.78	61.95	2603328.0
2009-12-21 12:00:00	IWM	ETF	61.95	62.07	61.76	61.94	7220512.0
2009-12-21 13:00:00	IWM	ETF	61.94	62.0	61.81	61.96	4407929.0
2009-12-21 14:00:00	IWM	ETF	61.95	62.08	61.89	61.98	2572109.0
2009-12-21 15:00:00	IWM	ETF	61.98	62.08	61.79	61.97	9176972.0
2009-12-21 16:00:00	IWM	ETF	61.97	61.991	61.8	61.9	3461052.0
2009-12-21 17:00:00	IWM	ETF	61.92	61.92	61.91	61.91	1916.0
2009-12-21 18:00:00	IWM	ETF	61.98	62.02	61.98	62.02	4800.0
2009-12-21 19:00:00	IWM	ETF	62.02	62.02	62.01	62.02	2400.0
2009-12-21 07:00:00	DIA	ETF	102.34	103.64	102.34	103.51	2700.0
2009-12-21 08:00:00	DIA	ETF	103.65	103.65	103.5	103.54	11570.0
2009-12-21 09:00:00	DIA	ETF	103.51	104.09	103.51	103.93	1231496.0
2009-12-21 10:00:00	DIA	ETF	103.93	104.39	103.93	104.1099	1539790.0
2009-12-21 11:00:00	DIA	ETF	104.11	104.24	104.055	104.19	628772.0
2009-12-21 12:00:00	DIA	ETF	104.18	104.36	104.12	104.18	540384.0

> showing 50 of 4,630 rows — these rows as CSV

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