PREVIEW / etf_1hour / 2009-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-14.parquet
  size:    147 KB
  rows:    4,573

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
2009-12-14 04:00:00	SPY	ETF	111.66	111.76	111.66	111.76	2600.0
2009-12-14 05:00:00	SPY	ETF	111.83	111.91	111.74	111.74	4200.0
2009-12-14 06:00:00	SPY	ETF	111.75	111.77	111.63	111.75	10590.0
2009-12-14 07:00:00	SPY	ETF	111.75	111.88	111.74	111.83	242098.0
2009-12-14 08:00:00	SPY	ETF	111.82	112.17	111.07	111.81	1333037.0
2009-12-14 09:00:00	SPY	ETF	111.8	111.93	111.54	111.611	14923241.0
2009-12-14 10:00:00	SPY	ETF	111.62	111.76	111.37	111.63	19566407.0
2009-12-14 11:00:00	SPY	ETF	111.64	111.92	111.55	111.77	10672723.0
2009-12-14 12:00:00	SPY	ETF	111.77	112.0	111.74	111.88	9556855.0
2009-12-14 13:00:00	SPY	ETF	111.88	111.9	111.63	111.8	19348687.0
2009-12-14 14:00:00	SPY	ETF	111.809	111.91	111.72	111.81	8468439.0
2009-12-14 15:00:00	SPY	ETF	111.82	111.94	111.74	111.88	15574252.0
2009-12-14 16:00:00	SPY	ETF	111.88	111.9054	111.1317	111.73	6258558.0
2009-12-14 17:00:00	SPY	ETF	111.73	111.76	111.69	111.75	79782.0
2009-12-14 18:00:00	SPY	ETF	111.73	111.87	111.59	111.72	433663.0
2009-12-14 19:00:00	SPY	ETF	111.72	111.81	111.67	111.8	53192.0
2009-12-14 04:00:00	QQQ	ETF	44.4	44.4	44.4	44.4	150.0
2009-12-14 06:00:00	QQQ	ETF	44.39	44.39	44.35	44.39	800.0
2009-12-14 07:00:00	QQQ	ETF	44.39	44.46	44.39	44.42	58130.0
2009-12-14 08:00:00	QQQ	ETF	44.42	44.5	44.13	44.45	304380.0
2009-12-14 09:00:00	QQQ	ETF	44.44	44.46	44.33	44.36	7280402.0
2009-12-14 10:00:00	QQQ	ETF	44.36	44.4	44.19	44.3674	11306783.0
2009-12-14 11:00:00	QQQ	ETF	44.37	44.509	44.35	44.42	5329109.0
2009-12-14 12:00:00	QQQ	ETF	44.424	44.6	44.2448	44.54	5639803.0
2009-12-14 13:00:00	QQQ	ETF	44.54	44.55	44.45	44.5315	3314821.0
2009-12-14 14:00:00	QQQ	ETF	44.531	44.57	44.48	44.54	4453250.0
2009-12-14 15:00:00	QQQ	ETF	44.53	44.6	44.5	44.55	7175296.0
2009-12-14 16:00:00	QQQ	ETF	44.55	44.57	44.25	44.53	2219775.0
2009-12-14 17:00:00	QQQ	ETF	44.52	44.54	44.5	44.54	9290.0
2009-12-14 18:00:00	QQQ	ETF	44.52	44.56	44.47	44.52	46431.0
2009-12-14 19:00:00	QQQ	ETF	44.52	44.57	44.52	44.57	19213.0
2009-12-14 06:00:00	IWM	ETF	60.58	60.58	60.55	60.55	500.0
2009-12-14 07:00:00	IWM	ETF	60.68	60.68	60.55	60.55	80927.0
2009-12-14 08:00:00	IWM	ETF	60.56	60.82	60.17	60.67	680769.0
2009-12-14 09:00:00	IWM	ETF	60.65	60.72	60.24	60.305	7535024.0
2009-12-14 10:00:00	IWM	ETF	60.29	60.48	59.97	60.405	8438215.0
2009-12-14 11:00:00	IWM	ETF	60.4	60.705	60.39	60.6	4650568.0
2009-12-14 12:00:00	IWM	ETF	60.6	61.0	60.55	60.8825	4703285.0
2009-12-14 13:00:00	IWM	ETF	60.88	60.9	60.67	60.82	3049312.0
2009-12-14 14:00:00	IWM	ETF	60.82	60.94	60.75	60.875	3300159.0
2009-12-14 15:00:00	IWM	ETF	60.87	61.3775	60.81	61.09	9141514.0
2009-12-14 16:00:00	IWM	ETF	61.09	61.1675	60.44	60.94	4601645.0
2009-12-14 17:00:00	IWM	ETF	60.96	60.99	60.93	60.99	2935.0
2009-12-14 18:00:00	IWM	ETF	60.95	61.0	60.95	60.95	1500.0
2009-12-14 04:00:00	DIA	ETF	105.41	105.41	105.41	105.41	200.0
2009-12-14 07:00:00	DIA	ETF	105.3	106.45	105.3	106.45	1574.0
2009-12-14 08:00:00	DIA	ETF	105.02	105.51	104.96	105.4	13460.0
2009-12-14 09:00:00	DIA	ETF	105.36	105.47	105.08	105.17	1419334.0
2009-12-14 10:00:00	DIA	ETF	105.16	105.23	104.92	105.12	1358579.0
2009-12-14 11:00:00	DIA	ETF	105.12	105.3	105.02	105.18	757922.0

> showing 50 of 4,573 rows — these rows as CSV

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