PREVIEW / etf_1hour / 2006-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-04-13.parquet
  size:    39 KB
  rows:    1,239

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-04-13 06:00:00	SPY	ETF	128.87	128.87	128.74	128.74	5500.0
2006-04-13 07:00:00	SPY	ETF	128.73	128.75	128.64	128.66	86600.0
2006-04-13 08:00:00	SPY	ETF	128.69	128.95	128.65	128.68	947200.0
2006-04-13 09:00:00	SPY	ETF	128.69	128.69	128.31	128.4	9555800.0
2006-04-13 10:00:00	SPY	ETF	128.4	129.16	128.37	129.11	12031400.0
2006-04-13 11:00:00	SPY	ETF	129.121	129.25	128.87	129.07	9430900.0
2006-04-13 12:00:00	SPY	ETF	129.07	129.13	128.77	128.8	4600800.0
2006-04-13 13:00:00	SPY	ETF	128.81	129.03	128.67	128.97	3798800.0
2006-04-13 14:00:00	SPY	ETF	128.96	128.99	128.63	128.71	3152600.0
2006-04-13 15:00:00	SPY	ETF	128.71	128.92	128.59	128.86	5575400.0
2006-04-13 16:00:00	SPY	ETF	128.85	128.875	128.69	128.71	514000.0
2006-04-13 17:00:00	SPY	ETF	128.71	128.87	128.67	128.87	20000.0
2006-04-13 19:00:00	SPY	ETF	128.85	128.85	128.85	128.85	300.0
2006-04-13 09:00:00	QQQ	ETF	41.9	41.93	41.79	41.85	6403100.0
2006-04-13 10:00:00	QQQ	ETF	41.85	42.27	41.84	42.27	15399500.0
2006-04-13 11:00:00	QQQ	ETF	42.27	42.33	42.2	42.26	10870900.0
2006-04-13 12:00:00	QQQ	ETF	42.26	42.29	42.16	42.17	5615100.0
2006-04-13 13:00:00	QQQ	ETF	42.15	42.26	42.11	42.24	4834600.0
2006-04-13 14:00:00	QQQ	ETF	42.24	42.24	42.09	42.12	4473200.0
2006-04-13 15:00:00	QQQ	ETF	42.12	42.13	42.02	42.1	8291400.0
2006-04-13 06:00:00	IWM	ETF	75.27	75.27	75.27	75.27	100.0
2006-04-13 07:00:00	IWM	ETF	74.3	74.3	74.3	74.3	100.0
2006-04-13 08:00:00	IWM	ETF	74.32	74.47	74.21	74.3	557200.0
2006-04-13 09:00:00	IWM	ETF	74.28	74.28	73.76	73.87	4972600.0
2006-04-13 10:00:00	IWM	ETF	73.88	74.56	73.88	74.53	7483200.0
2006-04-13 11:00:00	IWM	ETF	74.53	74.93	74.45	74.88	6123200.0
2006-04-13 12:00:00	IWM	ETF	74.9	74.92	74.66	74.69	2511600.0
2006-04-13 13:00:00	IWM	ETF	74.68	74.9	74.62	74.86	2107700.0
2006-04-13 14:00:00	IWM	ETF	74.86	74.87	74.5	74.58	2983000.0
2006-04-13 15:00:00	IWM	ETF	74.58	74.65	74.38	74.61	6024400.0
2006-04-13 16:00:00	IWM	ETF	74.6	74.64	74.51	74.55	477100.0
2006-04-13 17:00:00	IWM	ETF	74.61	74.63	74.6	74.63	3000.0
2006-04-13 18:00:00	IWM	ETF	74.63	74.63	74.63	74.63	200.0
2006-04-13 19:00:00	IWM	ETF	74.62	74.63	74.62	74.63	300.0
2006-04-13 08:00:00	DIA	ETF	111.21	111.35	111.21	111.31	16900.0
2006-04-13 09:00:00	DIA	ETF	111.17	111.28	111.08	111.18	628300.0
2006-04-13 10:00:00	DIA	ETF	111.16	111.76	111.16	111.72	1226400.0
2006-04-13 11:00:00	DIA	ETF	111.72	111.81	111.44	111.59	955000.0
2006-04-13 12:00:00	DIA	ETF	111.57	111.64	111.3	111.32	252400.0
2006-04-13 13:00:00	DIA	ETF	111.28	111.44	111.17	111.43	428100.0
2006-04-13 14:00:00	DIA	ETF	111.44	111.47	111.04	111.12	253000.0
2006-04-13 15:00:00	DIA	ETF	111.1	111.36	111.04	111.35	431100.0
2006-04-13 16:00:00	DIA	ETF	111.34	111.38	111.29	111.36	16500.0
2006-04-13 17:00:00	DIA	ETF	111.35	111.4	111.35	111.4	400.0
2006-04-13 19:00:00	DIA	ETF	111.45	111.45	111.45	111.45	100.0
2006-04-13 08:00:00	GLD	ETF	59.45	59.45	58.78	59.03	50400.0
2006-04-13 09:00:00	GLD	ETF	59.1	59.17	58.88	58.93	1015600.0
2006-04-13 10:00:00	GLD	ETF	58.93	59.18	58.87	59.122	481600.0
2006-04-13 11:00:00	GLD	ETF	59.11	59.3	59.08	59.3	267300.0
2006-04-13 12:00:00	GLD	ETF	59.3	59.4	59.21	59.31	131300.0

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

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