PREVIEW / etf_1hour / 2004-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-13.parquet
  size:    28 KB
  rows:    787

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
2004-12-13 08:00:00	SPY	ETF	119.45	119.74	119.43	119.72	364700.0
2004-12-13 09:00:00	SPY	ETF	119.75	119.95	119.62	119.68	5052300.0
2004-12-13 10:00:00	SPY	ETF	119.66	119.84	119.35	119.55	7022100.0
2004-12-13 11:00:00	SPY	ETF	119.55	119.68	119.38	119.64	2737400.0
2004-12-13 12:00:00	SPY	ETF	119.67	119.73	119.56	119.66	1599000.0
2004-12-13 13:00:00	SPY	ETF	119.66	120.13	119.62	120.03	5370300.0
2004-12-13 14:00:00	SPY	ETF	120.04	120.22	119.85	120.17	5813800.0
2004-12-13 15:00:00	SPY	ETF	120.17	120.31	120.05	120.29	7335900.0
2004-12-13 16:00:00	SPY	ETF	120.3	120.4	120.24	120.33	2786000.0
2004-12-13 17:00:00	SPY	ETF	120.32	120.36	120.3	120.36	162900.0
2004-12-13 18:00:00	SPY	ETF	120.35	120.35	120.32	120.32	5300.0
2004-12-13 19:00:00	SPY	ETF	120.32	120.33	120.31	120.31	8700.0
2004-12-13 08:00:00	QQQ	ETF	40.13	40.21	40.1	40.21	1145538.0
2004-12-13 09:00:00	QQQ	ETF	40.21	40.34	40.07	40.2	10375223.0
2004-12-13 10:00:00	QQQ	ETF	40.201	40.31	40.03	40.147	14176568.0
2004-12-13 11:00:00	QQQ	ETF	40.137	40.15	39.98	40.097	8339041.0
2004-12-13 12:00:00	QQQ	ETF	40.1	40.13	40.038	40.1	4610140.0
2004-12-13 13:00:00	QQQ	ETF	40.1	40.201	40.06	40.176	11760896.0
2004-12-13 14:00:00	QQQ	ETF	40.179	40.31	40.11	40.29	8348968.0
2004-12-13 15:00:00	QQQ	ETF	40.29	40.31	40.2	40.2801	11841404.0
2004-12-13 16:00:00	QQQ	ETF	40.2801	40.358	40.245	40.333	3508716.0
2004-12-13 17:00:00	QQQ	ETF	40.34	40.349	40.321	40.339	39995.0
2004-12-13 18:00:00	QQQ	ETF	40.33	40.346	40.33	40.34	12790.0
2004-12-13 08:00:00	IWM	ETF	63.25	63.35	63.25	63.35	4200.0
2004-12-13 09:00:00	IWM	ETF	63.49	63.55	63.13	63.225	2490600.0
2004-12-13 10:00:00	IWM	ETF	63.215	63.335	63.105	63.17	1485600.0
2004-12-13 11:00:00	IWM	ETF	63.18	63.22	62.97	63.105	918000.0
2004-12-13 12:00:00	IWM	ETF	63.11	63.16	63.09	63.16	713600.0
2004-12-13 13:00:00	IWM	ETF	63.14	63.445	63.13	63.425	731800.0
2004-12-13 14:00:00	IWM	ETF	63.43	63.535	63.33	63.515	1417600.0
2004-12-13 15:00:00	IWM	ETF	63.515	63.75	63.455	63.71	2202400.0
2004-12-13 16:00:00	IWM	ETF	63.7	63.805	63.675	63.805	683800.0
2004-12-13 08:00:00	DIA	ETF	105.64	105.77	105.62	105.77	3600.0
2004-12-13 09:00:00	DIA	ETF	105.9	106.05	105.82	105.89	635600.0
2004-12-13 10:00:00	DIA	ETF	105.89	105.97	105.56	105.7	896400.0
2004-12-13 11:00:00	DIA	ETF	105.71	105.77	105.53	105.77	1196600.0
2004-12-13 12:00:00	DIA	ETF	105.77	105.82	105.7	105.77	202500.0
2004-12-13 13:00:00	DIA	ETF	105.78	106.21	105.74	106.17	1088400.0
2004-12-13 14:00:00	DIA	ETF	106.18	106.33	106.0	106.28	1100400.0
2004-12-13 15:00:00	DIA	ETF	106.29	106.39	106.15	106.36	979300.0
2004-12-13 16:00:00	DIA	ETF	106.37	106.46	106.32	106.44	108300.0
2004-12-13 17:00:00	DIA	ETF	106.35	106.35	106.35	106.35	100.0
2004-12-13 18:00:00	DIA	ETF	106.46	106.46	106.35	106.35	1000.0
2004-12-13 09:00:00	GLD	ETF	43.61	43.64	43.53	43.58	146600.0
2004-12-13 10:00:00	GLD	ETF	43.57	43.68	43.51	43.67	314300.0
2004-12-13 11:00:00	GLD	ETF	43.69	43.98	43.67	43.94	418000.0
2004-12-13 12:00:00	GLD	ETF	43.94	44.01	43.86	43.98	129700.0
2004-12-13 13:00:00	GLD	ETF	44.0	44.014	43.87	43.92	126200.0
2004-12-13 14:00:00	GLD	ETF	43.92	44.01	43.91	44.01	192100.0
2004-12-13 15:00:00	GLD	ETF	44.01	44.01	43.9	43.9	115700.0

> showing 50 of 787 rows — these rows as CSV

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