PREVIEW / etf_1hour / 2009-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-12.parquet
  size:    126 KB
  rows:    3,936

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-02-12 04:00:00	SPY	ETF	82.75	82.92	82.75	82.8	5500.0
2009-02-12 05:00:00	SPY	ETF	82.74	82.84	82.51	82.6	49335.0
2009-02-12 06:00:00	SPY	ETF	82.5	82.9	82.5	82.75	48766.0
2009-02-12 07:00:00	SPY	ETF	82.72	82.92	82.58	82.6	983698.0
2009-02-12 08:00:00	SPY	ETF	82.85	83.05	82.47	82.77	6075204.0
2009-02-12 09:00:00	SPY	ETF	82.81	82.81	81.5	81.64	46981944.0
2009-02-12 10:00:00	SPY	ETF	81.65	82.37	81.3	82.2101	68134980.0
2009-02-12 11:00:00	SPY	ETF	82.22	82.69	81.68	82.31	53343184.0
2009-02-12 12:00:00	SPY	ETF	82.32	82.96	82.27	82.52	34384114.0
2009-02-12 13:00:00	SPY	ETF	82.53	82.61	81.75	82.19	53802244.0
2009-02-12 14:00:00	SPY	ETF	82.2	82.4	81.17	81.35	52825496.0
2009-02-12 15:00:00	SPY	ETF	81.35	83.82	81.05	83.69	121164045.0
2009-02-12 16:00:00	SPY	ETF	83.66	84.1	81.75	83.95	21049298.0
2009-02-12 17:00:00	SPY	ETF	83.94	84.04	83.6235	83.86	2476784.0
2009-02-12 18:00:00	SPY	ETF	83.86	84.09	83.78	83.78	353015.0
2009-02-12 19:00:00	SPY	ETF	83.77	83.8	83.69	83.71	83197.0
2009-02-12 04:00:00	QQQ	ETF	29.9	29.92	29.9	29.92	600.0
2009-02-12 06:00:00	QQQ	ETF	29.8	29.94	29.75	29.94	500.0
2009-02-12 07:00:00	QQQ	ETF	29.91	30.04	29.91	29.92	520299.0
2009-02-12 08:00:00	QQQ	ETF	29.93	30.1	29.85	30.04	989577.0
2009-02-12 09:00:00	QQQ	ETF	30.04	30.04	29.7	29.82	24354239.0
2009-02-12 10:00:00	QQQ	ETF	29.81	30.17	29.64	30.07	26396490.0
2009-02-12 11:00:00	QQQ	ETF	30.06	30.39	29.92	30.22	23251186.0
2009-02-12 12:00:00	QQQ	ETF	30.22	30.51	30.2	30.27	17925319.0
2009-02-12 13:00:00	QQQ	ETF	30.28	30.3	29.97	30.17	22116454.0
2009-02-12 14:00:00	QQQ	ETF	30.16	30.24	29.73	29.82	22773748.0
2009-02-12 15:00:00	QQQ	ETF	29.82	30.61	29.66	30.6	50946642.0
2009-02-12 16:00:00	QQQ	ETF	30.6	30.75	30.57	30.65	4824681.0
2009-02-12 17:00:00	QQQ	ETF	30.6	30.67	30.6	30.67	5069796.0
2009-02-12 18:00:00	QQQ	ETF	30.65	30.68	30.61	30.61	70744.0
2009-02-12 19:00:00	QQQ	ETF	30.61	30.62	30.6	30.61	43457.0
2009-02-12 06:00:00	IWM	ETF	44.39	44.39	44.36	44.36	386.0
2009-02-12 07:00:00	IWM	ETF	44.38	44.43	44.25	44.25	29051.0
2009-02-12 08:00:00	IWM	ETF	44.25	44.76	44.18	44.41	288296.0
2009-02-12 09:00:00	IWM	ETF	44.35	44.37	43.76	43.88	6580180.0
2009-02-12 10:00:00	IWM	ETF	43.88	44.45	43.64	44.3422	11250975.0
2009-02-12 11:00:00	IWM	ETF	44.34	44.6	44.02	44.38	8778664.0
2009-02-12 12:00:00	IWM	ETF	44.37	44.73	44.29	44.52	4323987.0
2009-02-12 13:00:00	IWM	ETF	44.52	44.53	43.89	44.16	8059857.0
2009-02-12 14:00:00	IWM	ETF	44.16	44.32	43.57	43.63	8624468.0
2009-02-12 15:00:00	IWM	ETF	43.64	45.21	43.47	45.09	21153788.0
2009-02-12 16:00:00	IWM	ETF	45.09	45.46	43.82	45.33	6172008.0
2009-02-12 17:00:00	IWM	ETF	44.7709	45.38	44.7709	45.32	1004184.0
2009-02-12 18:00:00	IWM	ETF	45.33	45.33	45.2	45.26	847.0
2009-02-12 19:00:00	IWM	ETF	45.26	45.26	45.16	45.2	3255.0
2009-02-12 04:00:00	DIA	ETF	78.94	78.94	78.94	78.94	100.0
2009-02-12 06:00:00	DIA	ETF	78.71	78.71	78.71	78.71	330.0
2009-02-12 07:00:00	DIA	ETF	78.75	78.9	78.66	78.66	10136.0
2009-02-12 08:00:00	DIA	ETF	78.69	79.13	78.65	78.86	79858.0
2009-02-12 09:00:00	DIA	ETF	78.8	78.86	77.61	77.74	4096479.0

> showing 50 of 3,936 rows — these rows as CSV

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