PREVIEW / etf_1hour / 2009-12-16

all etf 1-hour files

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

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-16 04:00:00	SPY	ETF	111.89	111.94	111.84	111.87	2000.0
2009-12-16 05:00:00	SPY	ETF	112.0	112.12	112.0	112.1	5662.0
2009-12-16 06:00:00	SPY	ETF	112.07	112.07	111.9	111.9	13600.0
2009-12-16 07:00:00	SPY	ETF	111.87	111.94	111.83	111.88	225286.0
2009-12-16 08:00:00	SPY	ETF	111.86	112.16	111.73	111.8	1288372.0
2009-12-16 09:00:00	SPY	ETF	111.8	112.08	111.69	111.9399	14693310.0
2009-12-16 10:00:00	SPY	ETF	111.93	112.06	111.75	112.02	19555288.0
2009-12-16 11:00:00	SPY	ETF	112.02	112.13	111.94	111.96	10397135.0
2009-12-16 12:00:00	SPY	ETF	111.96	112.03	111.87	111.8899	10752009.0
2009-12-16 13:00:00	SPY	ETF	111.885	111.97	111.84	111.84	7296313.0
2009-12-16 14:00:00	SPY	ETF	111.84	112.05	111.5	111.57	34172418.0
2009-12-16 15:00:00	SPY	ETF	111.57	111.68	111.27	111.49	28224525.0
2009-12-16 16:00:00	SPY	ETF	111.49	111.99	111.2854	111.39	12722284.0
2009-12-16 17:00:00	SPY	ETF	111.37	111.83	111.2854	111.36	4596642.0
2009-12-16 18:00:00	SPY	ETF	111.35	111.5	111.34	111.48	104965.0
2009-12-16 19:00:00	SPY	ETF	111.49	111.58	111.45	111.55	183698.0
2009-12-16 04:00:00	QQQ	ETF	44.5	44.5	44.5	44.5	200.0
2009-12-16 05:00:00	QQQ	ETF	44.55	44.6	44.55	44.59	5300.0
2009-12-16 06:00:00	QQQ	ETF	44.6	44.61	44.51	44.51	8300.0
2009-12-16 07:00:00	QQQ	ETF	44.51	44.55	44.49	44.49	58600.0
2009-12-16 08:00:00	QQQ	ETF	44.49	44.51	44.43	44.45	453065.0
2009-12-16 09:00:00	QQQ	ETF	44.44	44.69	44.41	44.65	10206588.0
2009-12-16 10:00:00	QQQ	ETF	44.66	44.7	44.51	44.571	12563982.0
2009-12-16 11:00:00	QQQ	ETF	44.57	44.65	44.56	44.59	4575892.0
2009-12-16 12:00:00	QQQ	ETF	44.58	44.61	44.55	44.55	2470558.0
2009-12-16 13:00:00	QQQ	ETF	44.5501	44.59	44.44	44.455	3255069.0
2009-12-16 14:00:00	QQQ	ETF	44.45	44.56	44.33	44.37	7793319.0
2009-12-16 15:00:00	QQQ	ETF	44.37	44.45	44.29	44.36	9178167.0
2009-12-16 16:00:00	QQQ	ETF	44.37	44.4488	44.3	44.35	6636807.0
2009-12-16 17:00:00	QQQ	ETF	44.35	44.35	44.34	44.34	42042.0
2009-12-16 18:00:00	QQQ	ETF	44.34	44.4	44.34	44.4	25000.0
2009-12-16 19:00:00	QQQ	ETF	44.38	44.41	44.38	44.4	35928.0
2009-12-16 06:00:00	IWM	ETF	61.39	61.41	61.38	61.41	1600.0
2009-12-16 07:00:00	IWM	ETF	61.32	61.35	61.3	61.3	12700.0
2009-12-16 08:00:00	IWM	ETF	61.3	61.57	61.18	61.31	375552.0
2009-12-16 09:00:00	IWM	ETF	61.3	61.62	61.25	61.45	6244489.0
2009-12-16 10:00:00	IWM	ETF	61.45	61.51	60.9	61.24	13462710.0
2009-12-16 11:00:00	IWM	ETF	61.24	61.4	61.17	61.3165	3969981.0
2009-12-16 12:00:00	IWM	ETF	61.319	61.395	61.29	61.36	2756452.0
2009-12-16 13:00:00	IWM	ETF	61.36	61.48	61.34	61.39	2241835.0
2009-12-16 14:00:00	IWM	ETF	61.38	61.44	61.09	61.2	8099600.0
2009-12-16 15:00:00	IWM	ETF	61.2	61.3799	60.97	61.31	11075117.0
2009-12-16 16:00:00	IWM	ETF	61.31	61.4	60.91	61.3	3112066.0
2009-12-16 17:00:00	IWM	ETF	61.3	61.3	61.25	61.25	33044.0
2009-12-16 18:00:00	IWM	ETF	61.29	61.29	61.29	61.29	100.0
2009-12-16 19:00:00	IWM	ETF	61.39	61.5	61.38	61.43	3400.0
2009-12-16 07:00:00	DIA	ETF	105.2	105.2	105.2	105.2	600.0
2009-12-16 08:00:00	DIA	ETF	105.08	105.21	105.08	105.14	21900.0
2009-12-16 09:00:00	DIA	ETF	105.12	105.31	105.04	105.18	823732.0
2009-12-16 10:00:00	DIA	ETF	105.18	105.29	105.035	105.18	653424.0

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

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