PREVIEW / etf_1hour / 2005-06-07

all etf 1-hour files

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

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-07 06:00:00	SPY	ETF	120.32	120.33	120.32	120.33	1000.0
2005-06-07 07:00:00	SPY	ETF	120.25	120.42	120.25	120.41	178600.0
2005-06-07 08:00:00	SPY	ETF	120.39	120.45	120.36	120.41	284500.0
2005-06-07 09:00:00	SPY	ETF	120.41	120.84	120.32	120.78	7366100.0
2005-06-07 10:00:00	SPY	ETF	120.77	121.25	120.73	121.12	12321900.0
2005-06-07 11:00:00	SPY	ETF	121.09	121.25	121.0	121.21	4951500.0
2005-06-07 12:00:00	SPY	ETF	121.21	121.24	121.03	121.19	3897500.0
2005-06-07 13:00:00	SPY	ETF	121.19	121.21	120.88	120.92	6772100.0
2005-06-07 14:00:00	SPY	ETF	120.91	120.92	120.33	120.63	12776600.0
2005-06-07 15:00:00	SPY	ETF	120.63	120.67	120.05	120.07	14168000.0
2005-06-07 16:00:00	SPY	ETF	120.07	120.3	120.0	120.19	1271100.0
2005-06-07 17:00:00	SPY	ETF	120.19	120.2	120.12	120.12	94000.0
2005-06-07 18:00:00	SPY	ETF	120.12	120.17	120.08	120.16	30800.0
2005-06-07 19:00:00	SPY	ETF	120.16	120.19	120.16	120.19	1800.0
2005-06-07 09:00:00	QQQ	ETF	38.15	38.25	38.1	38.24	10226200.0
2005-06-07 10:00:00	QQQ	ETF	38.24	38.47	38.22	38.39	20103900.0
2005-06-07 11:00:00	QQQ	ETF	38.39	38.41	36.38	38.39	9406900.0
2005-06-07 12:00:00	QQQ	ETF	38.39	38.4	38.3	38.36	4566400.0
2005-06-07 13:00:00	QQQ	ETF	38.36	38.37	38.11	38.14	11253100.0
2005-06-07 14:00:00	QQQ	ETF	38.14	38.15	37.82	37.97	26763800.0
2005-06-07 15:00:00	QQQ	ETF	37.97	37.98	37.74	37.8	20379200.0
2005-06-07 08:00:00	IWM	ETF	62.175	62.24	62.175	62.21	28400.0
2005-06-07 09:00:00	IWM	ETF	62.21	62.565	62.19	62.555	5046000.0
2005-06-07 10:00:00	IWM	ETF	62.55	62.875	62.535	62.715	5930800.0
2005-06-07 11:00:00	IWM	ETF	62.715	62.755	62.61	62.74	2705000.0
2005-06-07 12:00:00	IWM	ETF	62.74	62.77	62.625	62.76	850400.0
2005-06-07 13:00:00	IWM	ETF	62.755	62.775	62.525	62.545	1796400.0
2005-06-07 14:00:00	IWM	ETF	62.54	62.62	62.245	62.435	3763600.0
2005-06-07 15:00:00	IWM	ETF	62.435	62.45	62.025	62.05	3935000.0
2005-06-07 16:00:00	IWM	ETF	62.05	62.1	61.98	62.075	499600.0
2005-06-07 17:00:00	IWM	ETF	62.075	62.11	62.055	62.11	8000.0
2005-06-07 08:00:00	DIA	ETF	104.86	104.94	104.86	104.92	8900.0
2005-06-07 09:00:00	DIA	ETF	104.9	105.28	104.81	105.22	1029500.0
2005-06-07 10:00:00	DIA	ETF	105.25	105.69	105.21	105.6	1482000.0
2005-06-07 11:00:00	DIA	ETF	105.61	105.68	105.53	105.67	475500.0
2005-06-07 12:00:00	DIA	ETF	105.68	105.74	105.58	105.69	466200.0
2005-06-07 13:00:00	DIA	ETF	105.69	105.72	105.45	105.48	541000.0
2005-06-07 14:00:00	DIA	ETF	105.48	105.48	104.98	105.26	1050800.0
2005-06-07 15:00:00	DIA	ETF	105.26	105.28	104.81	104.82	1754500.0
2005-06-07 16:00:00	DIA	ETF	104.84	104.94	104.8	104.94	8000.0
2005-06-07 17:00:00	DIA	ETF	104.94	105.0	104.9	104.9	5200.0
2005-06-07 18:00:00	DIA	ETF	104.9	104.9	104.9	104.9	100.0
2005-06-07 19:00:00	DIA	ETF	104.93	104.93	104.93	104.93	200.0
2005-06-07 09:00:00	GLD	ETF	42.45	42.48	42.31	42.34	104000.0
2005-06-07 10:00:00	GLD	ETF	42.33	42.44	42.33	42.41	66300.0
2005-06-07 11:00:00	GLD	ETF	42.39	42.47	42.38	42.45	102800.0
2005-06-07 12:00:00	GLD	ETF	42.45	42.47	42.37	42.4	129300.0
2005-06-07 13:00:00	GLD	ETF	42.41	42.43	42.35	42.38	103000.0
2005-06-07 14:00:00	GLD	ETF	42.39	42.4	42.37	42.39	41500.0
2005-06-07 15:00:00	GLD	ETF	42.41	42.41	42.37	42.39	62300.0

> showing 50 of 879 rows — these rows as CSV

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