PREVIEW / etf_1hour / 2005-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-22.parquet
  size:    35 KB
  rows:    1,067

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-11-22 07:00:00	SPY	ETF	125.63	125.63	125.57	125.58	7300.0
2005-11-22 08:00:00	SPY	ETF	125.58	125.63	125.5	125.56	355300.0
2005-11-22 09:00:00	SPY	ETF	125.57	125.63	125.42	125.45	7248500.0
2005-11-22 10:00:00	SPY	ETF	125.45	125.76	125.42	125.68	8341400.0
2005-11-22 11:00:00	SPY	ETF	125.68	125.8	125.57	125.68	3548000.0
2005-11-22 12:00:00	SPY	ETF	125.68	125.75	125.62	125.66	1615700.0
2005-11-22 13:00:00	SPY	ETF	125.65	125.89	125.65	125.67	4315800.0
2005-11-22 14:00:00	SPY	ETF	125.67	126.35	125.64	126.34	27245400.0
2005-11-22 15:00:00	SPY	ETF	126.35	126.52	126.25	126.37	9041500.0
2005-11-22 16:00:00	SPY	ETF	126.36	126.42	125.92	126.25	881700.0
2005-11-22 17:00:00	SPY	ETF	126.26	126.31	126.26	126.27	10900.0
2005-11-22 18:00:00	SPY	ETF	126.27	126.27	126.27	126.27	1000.0
2005-11-22 09:00:00	QQQ	ETF	41.46	41.48	41.36	41.43	8798000.0
2005-11-22 10:00:00	QQQ	ETF	41.43	41.6	41.41	41.55	13074500.0
2005-11-22 11:00:00	QQQ	ETF	41.55	41.59	41.47	41.56	5300800.0
2005-11-22 12:00:00	QQQ	ETF	41.56	41.59	41.53	41.53	3951300.0
2005-11-22 13:00:00	QQQ	ETF	41.53	41.63	41.51	41.52	6202000.0
2005-11-22 14:00:00	QQQ	ETF	41.51	41.8	41.51	41.79	24758600.0
2005-11-22 15:00:00	QQQ	ETF	41.79	41.87	41.7	41.71	15658700.0
2005-11-22 08:00:00	IWM	ETF	67.45	67.48	67.41	67.43	67200.0
2005-11-22 09:00:00	IWM	ETF	67.43	67.57	67.29	67.33	2584300.0
2005-11-22 10:00:00	IWM	ETF	67.33	67.59	67.3	67.53	2392800.0
2005-11-22 11:00:00	IWM	ETF	67.54	67.63	67.44	67.62	1537000.0
2005-11-22 12:00:00	IWM	ETF	67.63	67.65	67.49	67.56	3997600.0
2005-11-22 13:00:00	IWM	ETF	67.57	67.72	67.51	67.54	2273500.0
2005-11-22 14:00:00	IWM	ETF	67.55	68.04	67.55	68.0	4425500.0
2005-11-22 15:00:00	IWM	ETF	68.01	68.11	67.84	67.94	3274100.0
2005-11-22 16:00:00	IWM	ETF	67.92	68.0184	67.78	67.86	142500.0
2005-11-22 17:00:00	IWM	ETF	67.86	67.86	67.86	67.86	100.0
2005-11-22 08:00:00	DIA	ETF	107.99	108.0	107.93	107.99	22500.0
2005-11-22 09:00:00	DIA	ETF	108.0	108.05	107.84	107.91	629200.0
2005-11-22 10:00:00	DIA	ETF	107.93	108.09	107.87	107.97	661600.0
2005-11-22 11:00:00	DIA	ETF	107.99	108.07	107.93	108.06	682600.0
2005-11-22 12:00:00	DIA	ETF	108.06	108.14	108.03	108.03	225300.0
2005-11-22 13:00:00	DIA	ETF	108.04	108.22	108.04	108.09	400300.0
2005-11-22 14:00:00	DIA	ETF	108.09	108.65	108.09	108.64	1736500.0
2005-11-22 15:00:00	DIA	ETF	108.64	108.74	108.52	108.6001	1744000.0
2005-11-22 16:00:00	DIA	ETF	108.6	108.75	108.56	108.6	367300.0
2005-11-22 17:00:00	DIA	ETF	108.55	108.55	108.55	108.55	200.0
2005-11-22 08:00:00	GLD	ETF	49.08	49.16	48.97	48.98	27400.0
2005-11-22 09:00:00	GLD	ETF	48.95	49.12	48.91	49.08	514400.0
2005-11-22 10:00:00	GLD	ETF	49.07	49.24	48.99	48.99	360000.0
2005-11-22 11:00:00	GLD	ETF	48.99	49.05	48.8501	49.0299	422800.0
2005-11-22 12:00:00	GLD	ETF	49.02	49.1	48.9	49.06	160800.0
2005-11-22 13:00:00	GLD	ETF	49.09	49.16	49.06	49.12	154400.0
2005-11-22 14:00:00	GLD	ETF	49.12	49.34	49.1	49.27	488900.0
2005-11-22 15:00:00	GLD	ETF	49.27	49.34	49.21	49.33	568300.0
2005-11-22 16:00:00	GLD	ETF	49.32	49.32	49.32	49.32	500.0
2005-11-22 08:00:00	TLT	ETF	90.28	90.28	90.28	90.28	5500.0
2005-11-22 09:00:00	TLT	ETF	90.37	90.4	90.35	90.38	177000.0

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

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