PREVIEW / etf_1hour / 2004-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-14.parquet
  size:    27 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-14 08:00:00	SPY	ETF	120.23	120.32	120.18	120.22	115200.0
2004-12-14 09:00:00	SPY	ETF	120.21	120.45	120.18	120.41	3645900.0
2004-12-14 10:00:00	SPY	ETF	120.4	120.46	120.21	120.32	5540000.0
2004-12-14 11:00:00	SPY	ETF	120.32	120.4	120.26	120.31	2877000.0
2004-12-14 12:00:00	SPY	ETF	120.32	120.51	120.28	120.44	3295100.0
2004-12-14 13:00:00	SPY	ETF	120.44	120.48	120.37	120.39	1918200.0
2004-12-14 14:00:00	SPY	ETF	120.39	120.75	120.32	120.7	10091900.0
2004-12-14 15:00:00	SPY	ETF	120.7	120.96	120.65	120.79	10313400.0
2004-12-14 16:00:00	SPY	ETF	120.8	120.85	120.68	120.76	1971900.0
2004-12-14 17:00:00	SPY	ETF	120.7	120.7	120.66	120.7	223700.0
2004-12-14 18:00:00	SPY	ETF	120.7	120.7	120.63	120.63	26700.0
2004-12-14 08:00:00	QQQ	ETF	40.297	40.34	40.27	40.31	149996.0
2004-12-14 09:00:00	QQQ	ETF	40.31	40.43	40.25	40.3801	9255807.0
2004-12-14 10:00:00	QQQ	ETF	40.38	40.4	40.27	40.348	9153352.0
2004-12-14 11:00:00	QQQ	ETF	40.35	40.391	40.29	40.39	4951170.0
2004-12-14 12:00:00	QQQ	ETF	40.38	40.511	40.36	40.45	10993115.0
2004-12-14 13:00:00	QQQ	ETF	40.451	40.46	40.41	40.43	4657920.0
2004-12-14 14:00:00	QQQ	ETF	40.427	40.53	40.33	40.484	20607576.0
2004-12-14 15:00:00	QQQ	ETF	40.4899	40.59	40.38	40.45	20098711.0
2004-12-14 16:00:00	QQQ	ETF	40.459	40.48	40.3099	40.45	4339188.0
2004-12-14 17:00:00	QQQ	ETF	40.44	40.47	40.43	40.47	33101.0
2004-12-14 18:00:00	QQQ	ETF	40.45	40.46	40.44	40.45	23070.0
2004-12-14 08:00:00	IWM	ETF	63.77	63.77	63.74	63.74	1200.0
2004-12-14 09:00:00	IWM	ETF	63.7	63.93	63.685	63.91	1133200.0
2004-12-14 10:00:00	IWM	ETF	63.905	63.925	63.76	63.88	1319200.0
2004-12-14 11:00:00	IWM	ETF	63.875	64.035	63.83	63.96	1423400.0
2004-12-14 12:00:00	IWM	ETF	63.965	64.03	63.93	63.95	906200.0
2004-12-14 13:00:00	IWM	ETF	63.95	64.09	63.95	64.01	1015600.0
2004-12-14 14:00:00	IWM	ETF	64.02	64.19	63.94	64.15	1101400.0
2004-12-14 15:00:00	IWM	ETF	64.15	64.315	64.14	64.21	2119400.0
2004-12-14 16:00:00	IWM	ETF	64.21	64.235	64.1	64.235	1125600.0
2004-12-14 17:00:00	IWM	ETF	64.235	64.235	64.235	64.235	235200.0
2004-12-14 08:00:00	DIA	ETF	106.28	106.3	106.27	106.27	700.0
2004-12-14 09:00:00	DIA	ETF	106.27	106.34	106.2	106.31	345500.0
2004-12-14 10:00:00	DIA	ETF	106.32	106.48	106.25	106.37	1364900.0
2004-12-14 11:00:00	DIA	ETF	106.35	106.47	106.27	106.35	261000.0
2004-12-14 12:00:00	DIA	ETF	106.35	106.42	106.28	106.41	356800.0
2004-12-14 13:00:00	DIA	ETF	106.41	106.44	106.36	106.4	248300.0
2004-12-14 14:00:00	DIA	ETF	106.4	106.72	106.33	106.71	1091400.0
2004-12-14 15:00:00	DIA	ETF	106.72	106.95	106.66	106.77	1565900.0
2004-12-14 16:00:00	DIA	ETF	106.77	106.82	106.72	106.73	81200.0
2004-12-14 17:00:00	DIA	ETF	106.72	106.72	106.72	106.72	500.0
2004-12-14 18:00:00	DIA	ETF	106.71	106.71	106.71	106.71	400.0
2004-12-14 09:00:00	GLD	ETF	43.76	43.8	43.74	43.76	643500.0
2004-12-14 10:00:00	GLD	ETF	43.75	43.79	43.61	43.66	496100.0
2004-12-14 11:00:00	GLD	ETF	43.66	43.73	43.53	43.57	278800.0
2004-12-14 12:00:00	GLD	ETF	43.55	43.62	43.51	43.55	187000.0
2004-12-14 13:00:00	GLD	ETF	43.57	43.63	43.53	43.59	105800.0
2004-12-14 14:00:00	GLD	ETF	43.6	43.64	43.55	43.61	382100.0
2004-12-14 15:00:00	GLD	ETF	43.58	43.59	43.53	43.54	133100.0

> showing 50 of 787 rows — these rows as CSV

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