PREVIEW / etf_1hour / 2005-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-07.parquet
  size:    29 KB
  rows:    857

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-04-07 08:00:00	SPY	ETF	118.55	118.55	118.44	118.54	194500.0
2005-04-07 09:00:00	SPY	ETF	118.53	118.59	118.32	118.47	4764600.0
2005-04-07 10:00:00	SPY	ETF	118.47	118.84	118.41	118.75	9292700.0
2005-04-07 11:00:00	SPY	ETF	118.73	118.93	118.68	118.79	4226500.0
2005-04-07 12:00:00	SPY	ETF	118.81	119.17	118.74	119.01	4960300.0
2005-04-07 13:00:00	SPY	ETF	119.01	119.14	118.57	118.69	5706700.0
2005-04-07 14:00:00	SPY	ETF	118.7	119.14	118.66	119.09	7148500.0
2005-04-07 15:00:00	SPY	ETF	119.09	119.23	118.95	119.15	8089800.0
2005-04-07 16:00:00	SPY	ETF	119.15	119.27	118.845	119.19	1678700.0
2005-04-07 17:00:00	SPY	ETF	119.19	119.23	119.18	119.23	15000.0
2005-04-07 18:00:00	SPY	ETF	119.16	119.22	119.16	119.18	4700.0
2005-04-07 19:00:00	SPY	ETF	119.25	119.25	119.25	119.25	100.0
2005-04-07 09:00:00	QQQ	ETF	36.53	36.61	36.51	36.6	9421900.0
2005-04-07 10:00:00	QQQ	ETF	36.59	36.76	36.57	36.72	12595800.0
2005-04-07 11:00:00	QQQ	ETF	36.72	36.79	36.68	36.71	6878500.0
2005-04-07 12:00:00	QQQ	ETF	36.71	36.86	36.67	36.8	11157900.0
2005-04-07 13:00:00	QQQ	ETF	36.8	36.85	36.72	36.74	13874100.0
2005-04-07 14:00:00	QQQ	ETF	36.74	36.91	36.72	36.91	11006100.0
2005-04-07 15:00:00	QQQ	ETF	36.91	36.95	36.84	36.93	16067100.0
2005-04-07 08:00:00	IWM	ETF	61.25	61.275	61.25	61.275	6000.0
2005-04-07 09:00:00	IWM	ETF	61.275	61.275	60.945	61.075	1765200.0
2005-04-07 10:00:00	IWM	ETF	61.08	61.475	61.01	61.395	3031800.0
2005-04-07 11:00:00	IWM	ETF	61.4	61.57	61.37	61.49	2161800.0
2005-04-07 12:00:00	IWM	ETF	61.485	61.755	61.46	61.665	2154400.0
2005-04-07 13:00:00	IWM	ETF	61.655	61.67	61.33	61.44	1844000.0
2005-04-07 14:00:00	IWM	ETF	61.445	61.62	61.405	61.61	990800.0
2005-04-07 15:00:00	IWM	ETF	61.61	61.655	61.48	61.565	1910000.0
2005-04-07 16:00:00	IWM	ETF	61.575	61.665	61.55	61.56	258600.0
2005-04-07 17:00:00	IWM	ETF	61.55	61.56	61.55	61.56	10000.0
2005-04-07 08:00:00	DIA	ETF	104.91	104.95	104.91	104.94	700.0
2005-04-07 09:00:00	DIA	ETF	104.94	104.98	104.74	104.93	304700.0
2005-04-07 10:00:00	DIA	ETF	104.93	105.2	104.84	105.14	562400.0
2005-04-07 11:00:00	DIA	ETF	105.13	105.33	105.12	105.22	292200.0
2005-04-07 12:00:00	DIA	ETF	105.22	105.5	105.15	105.42	815200.0
2005-04-07 13:00:00	DIA	ETF	105.4	105.4	105.05	105.21	396500.0
2005-04-07 14:00:00	DIA	ETF	105.2	105.5	105.16	105.45	580700.0
2005-04-07 15:00:00	DIA	ETF	105.47	105.58	105.34	105.45	820500.0
2005-04-07 16:00:00	DIA	ETF	105.48	105.55	105.48	105.53	11600.0
2005-04-07 17:00:00	DIA	ETF	105.46	105.53	105.46	105.53	15400.0
2005-04-07 09:00:00	GLD	ETF	42.77	42.81	42.76	42.78	147300.0
2005-04-07 10:00:00	GLD	ETF	42.79	42.79	42.62	42.65	1081800.0
2005-04-07 11:00:00	GLD	ETF	42.65	42.72	42.64	42.68	225200.0
2005-04-07 12:00:00	GLD	ETF	42.68	42.72	42.66	42.67	115500.0
2005-04-07 13:00:00	GLD	ETF	42.68	42.68	42.58	42.61	420600.0
2005-04-07 14:00:00	GLD	ETF	42.6	42.62	42.56	42.57	704100.0
2005-04-07 15:00:00	GLD	ETF	42.57	42.59	42.53	42.57	158100.0
2005-04-07 16:00:00	GLD	ETF	42.58	42.58	42.58	42.58	300.0
2005-04-07 09:00:00	TLT	ETF	89.3	89.35	89.25	89.33	24900.0
2005-04-07 10:00:00	TLT	ETF	89.34	89.58	89.3	89.45	184200.0
2005-04-07 11:00:00	TLT	ETF	89.45	89.45	89.36	89.45	59300.0

> showing 50 of 857 rows — these rows as CSV

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