PREVIEW / etf_1hour / 2006-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-11.parquet
  size:    56 KB
  rows:    1,798

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
2006-12-11 04:00:00	SPY	ETF	141.66	141.66	141.66	141.66	7000.0
2006-12-11 06:00:00	SPY	ETF	141.69	141.69	141.63	141.63	61500.0
2006-12-11 07:00:00	SPY	ETF	141.65	141.66	141.63	141.64	62900.0
2006-12-11 08:00:00	SPY	ETF	141.66	141.71	141.42	141.58	1591300.0
2006-12-11 09:00:00	SPY	ETF	141.56	141.69	141.34	141.64	6543100.0
2006-12-11 10:00:00	SPY	ETF	141.65	142.09	141.54	141.82	10080400.0
2006-12-11 11:00:00	SPY	ETF	141.83	142.01	141.79	141.88	4274700.0
2006-12-11 12:00:00	SPY	ETF	141.89	141.91	141.58	141.74	3992100.0
2006-12-11 13:00:00	SPY	ETF	141.74	141.89	141.67	141.85	2080500.0
2006-12-11 14:00:00	SPY	ETF	141.86	141.89	141.74	141.76	2333000.0
2006-12-11 15:00:00	SPY	ETF	141.75	141.86	141.66	141.74	5293000.0
2006-12-11 16:00:00	SPY	ETF	141.76	141.88	141.75	141.82	1895400.0
2006-12-11 17:00:00	SPY	ETF	141.81	141.84	141.78	141.83	135300.0
2006-12-11 18:00:00	SPY	ETF	141.83	141.83	141.8	141.8	1200.0
2006-12-11 19:00:00	SPY	ETF	141.83	141.83	141.8	141.8	3600.0
2006-12-11 09:00:00	QQQ	ETF	43.83	44.03	43.75	44.02	10683500.0
2006-12-11 10:00:00	QQQ	ETF	44.02	44.37	43.96	44.24	21561600.0
2006-12-11 11:00:00	QQQ	ETF	44.25	44.35	44.22	44.23	7003100.0
2006-12-11 12:00:00	QQQ	ETF	44.24	44.26	44.12	44.16	7974900.0
2006-12-11 13:00:00	QQQ	ETF	44.15	44.27	44.13	44.21	4337500.0
2006-12-11 14:00:00	QQQ	ETF	44.22	44.23	44.16	44.18	4423300.0
2006-12-11 15:00:00	QQQ	ETF	44.17	44.22	44.05	44.05	9877300.0
2006-12-11 08:00:00	IWM	ETF	78.93	78.93	78.84	78.84	45700.0
2006-12-11 09:00:00	IWM	ETF	78.87	78.93	78.54	78.91	3712000.0
2006-12-11 10:00:00	IWM	ETF	78.92	79.18	78.81	78.93	5631500.0
2006-12-11 11:00:00	IWM	ETF	78.9224	79.08	78.91	78.99	2625600.0
2006-12-11 12:00:00	IWM	ETF	78.99	79.03	78.8	78.94	1653100.0
2006-12-11 13:00:00	IWM	ETF	78.94	79.11	78.91	79.07	2903600.0
2006-12-11 14:00:00	IWM	ETF	79.07	79.1	78.92	78.93	1493100.0
2006-12-11 15:00:00	IWM	ETF	78.93	79.02	78.75	78.94	3642800.0
2006-12-11 16:00:00	IWM	ETF	78.93	79.06	78.93	79.03	187500.0
2006-12-11 17:00:00	IWM	ETF	79.0	79.08	78.99	79.04	212300.0
2006-12-11 08:00:00	DIA	ETF	123.22	123.22	123.17	123.18	17200.0
2006-12-11 09:00:00	DIA	ETF	123.18	123.32	123.07	123.26	792300.0
2006-12-11 10:00:00	DIA	ETF	123.28	123.55	123.18	123.36	1184700.0
2006-12-11 11:00:00	DIA	ETF	123.36	123.42	123.32	123.36	350100.0
2006-12-11 12:00:00	DIA	ETF	123.36	123.46	123.13	123.27	415800.0
2006-12-11 13:00:00	DIA	ETF	123.27	123.4	123.24	123.35	230900.0
2006-12-11 14:00:00	DIA	ETF	123.32	123.36	123.24	123.26	161100.0
2006-12-11 15:00:00	DIA	ETF	123.27	123.33	123.18	123.3	372400.0
2006-12-11 16:00:00	DIA	ETF	123.31	123.36	123.31	123.34	363600.0
2006-12-11 07:00:00	GLD	ETF	61.97	61.97	61.97	61.97	1000.0
2006-12-11 08:00:00	GLD	ETF	61.95	62.27	61.94	62.17	123500.0
2006-12-11 09:00:00	GLD	ETF	62.21	62.35	62.12	62.29	653900.0
2006-12-11 10:00:00	GLD	ETF	62.29	62.4705	62.07	62.39	748800.0
2006-12-11 11:00:00	GLD	ETF	62.39	62.53	62.29	62.29	452800.0
2006-12-11 12:00:00	GLD	ETF	62.28	62.59	62.25	62.49	487200.0
2006-12-11 13:00:00	GLD	ETF	62.47	62.6	62.38	62.48	287800.0
2006-12-11 14:00:00	GLD	ETF	62.46	62.54	62.43	62.4395	168400.0
2006-12-11 15:00:00	GLD	ETF	62.42	62.6	62.42	62.58	232200.0

> showing 50 of 1,798 rows — these rows as CSV

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