PREVIEW / etf_1hour / 2005-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-06-30.parquet
  size:    30 KB
  rows:    902

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
2005-06-30 07:00:00	SPY	ETF	120.08	120.12	120.08	120.11	11500.0
2005-06-30 08:00:00	SPY	ETF	120.12	120.29	120.1	120.29	89800.0
2005-06-30 09:00:00	SPY	ETF	120.29	120.32	120.15	120.23	5366300.0
2005-06-30 10:00:00	SPY	ETF	120.23	120.25	120.01	120.04	5724200.0
2005-06-30 11:00:00	SPY	ETF	120.03	120.04	119.87	119.98	4083900.0
2005-06-30 12:00:00	SPY	ETF	119.97	120.02	119.9	119.93	2228000.0
2005-06-30 13:00:00	SPY	ETF	119.92	120.06	119.75	120.03	4782800.0
2005-06-30 14:00:00	SPY	ETF	120.03	120.2	119.29	119.59	21180800.0
2005-06-30 15:00:00	SPY	ETF	119.6	119.99	118.95	119.06	14859300.0
2005-06-30 16:00:00	SPY	ETF	119.06	119.18	119.06	119.17	2417000.0
2005-06-30 17:00:00	SPY	ETF	119.14	119.19	119.14	119.19	8400.0
2005-06-30 18:00:00	SPY	ETF	119.14	119.16	119.13	119.16	4900.0
2005-06-30 19:00:00	SPY	ETF	119.17	119.17	119.17	119.17	1600.0
2005-06-30 09:00:00	QQQ	ETF	37.14	37.21	37.1	37.12	7257800.0
2005-06-30 10:00:00	QQQ	ETF	37.12	37.17	37.06	37.09	7275100.0
2005-06-30 11:00:00	QQQ	ETF	37.09	37.09	36.96	37.01	11361200.0
2005-06-30 12:00:00	QQQ	ETF	37.01	37.04	36.99	37.0	2988200.0
2005-06-30 13:00:00	QQQ	ETF	37.01	37.15	36.99	37.13	4224200.0
2005-06-30 14:00:00	QQQ	ETF	37.14	37.21	36.84	36.94	24386100.0
2005-06-30 15:00:00	QQQ	ETF	36.94	37.03	36.75	36.78	21381800.0
2005-06-30 08:00:00	IWM	ETF	63.96	64.1	63.96	64.1	2200.0
2005-06-30 09:00:00	IWM	ETF	64.08	64.17	64.0	64.07	3809900.0
2005-06-30 10:00:00	IWM	ETF	64.09	64.11	63.91	63.93	2970200.0
2005-06-30 11:00:00	IWM	ETF	63.92	64.0	63.84	63.93	1895000.0
2005-06-30 12:00:00	IWM	ETF	63.94	64.01	63.92	63.99	1139900.0
2005-06-30 13:00:00	IWM	ETF	63.98	64.17	63.94	64.14	1460800.0
2005-06-30 14:00:00	IWM	ETF	64.15	64.29	63.72	63.96	6536400.0
2005-06-30 15:00:00	IWM	ETF	63.97	64.02	63.44	63.44	8181400.0
2005-06-30 16:00:00	IWM	ETF	63.43	63.7	63.43	63.57	1047200.0
2005-06-30 17:00:00	IWM	ETF	63.71	63.71	63.71	63.71	3900.0
2005-06-30 08:00:00	DIA	ETF	103.87	104.04	103.87	104.04	38800.0
2005-06-30 09:00:00	DIA	ETF	104.04	104.07	103.82	103.99	627100.0
2005-06-30 10:00:00	DIA	ETF	103.99	104.0	103.81	103.83	711700.0
2005-06-30 11:00:00	DIA	ETF	103.82	103.83	103.6	103.68	723800.0
2005-06-30 12:00:00	DIA	ETF	103.67	103.68	103.51	103.52	615400.0
2005-06-30 13:00:00	DIA	ETF	103.52	103.66	103.42	103.64	539500.0
2005-06-30 14:00:00	DIA	ETF	103.65	103.79	102.98	103.26	2985000.0
2005-06-30 15:00:00	DIA	ETF	103.26	103.32	102.56	102.6315	2922900.0
2005-06-30 16:00:00	DIA	ETF	102.68	102.77	102.61	102.73	217900.0
2005-06-30 17:00:00	DIA	ETF	102.77	102.78	102.76	102.76	15800.0
2005-06-30 18:00:00	DIA	ETF	102.69	102.69	102.69	102.69	100.0
2005-06-30 08:00:00	GLD	ETF	43.62	43.62	43.62	43.62	300.0
2005-06-30 09:00:00	GLD	ETF	43.65	43.65	43.58	43.62	76600.0
2005-06-30 10:00:00	GLD	ETF	43.62	43.7	43.59	43.69	85700.0
2005-06-30 11:00:00	GLD	ETF	43.7	43.77	43.65	43.69	129300.0
2005-06-30 12:00:00	GLD	ETF	43.67	43.69	43.42	43.45	230600.0
2005-06-30 13:00:00	GLD	ETF	43.46	43.46	43.38	43.38	124100.0
2005-06-30 14:00:00	GLD	ETF	43.38	43.55	43.36	43.45	198300.0
2005-06-30 15:00:00	GLD	ETF	43.44	43.45	43.38	43.42	123200.0
2005-06-30 16:00:00	GLD	ETF	43.42	43.46	43.42	43.45	100200.0

> showing 50 of 902 rows — these rows as CSV

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