PREVIEW / etf_1hour / 2005-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-05-19.parquet
  size:    29 KB
  rows:    880

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-05-19 07:00:00	SPY	ETF	118.8	118.83	118.8	118.83	39800.0
2005-05-19 08:00:00	SPY	ETF	118.81	118.95	118.78	118.94	153100.0
2005-05-19 09:00:00	SPY	ETF	118.95	119.08	118.73	119.01	5178100.0
2005-05-19 10:00:00	SPY	ETF	119.01	119.24	118.82	119.05	10666000.0
2005-05-19 11:00:00	SPY	ETF	119.05	119.32	118.96	119.03	7335400.0
2005-05-19 12:00:00	SPY	ETF	119.03	119.18	118.83	119.15	8460400.0
2005-05-19 13:00:00	SPY	ETF	119.15	119.24	118.83	118.83	5937500.0
2005-05-19 14:00:00	SPY	ETF	118.84	119.18	118.7	119.11	10198800.0
2005-05-19 15:00:00	SPY	ETF	119.11	119.41	119.04	119.37	10450900.0
2005-05-19 16:00:00	SPY	ETF	119.37	119.37	119.25	119.3	1939400.0
2005-05-19 17:00:00	SPY	ETF	119.29	119.32	119.25	119.32	231500.0
2005-05-19 18:00:00	SPY	ETF	119.35	119.35	119.35	119.35	490000.0
2005-05-19 09:00:00	QQQ	ETF	37.29	37.39	37.2	37.37	11304600.0
2005-05-19 10:00:00	QQQ	ETF	37.37	37.45	37.29	37.39	16269800.0
2005-05-19 11:00:00	QQQ	ETF	37.38	37.48	37.36	37.41	10839700.0
2005-05-19 12:00:00	QQQ	ETF	37.41	37.47	37.32	37.45	7744600.0
2005-05-19 13:00:00	QQQ	ETF	37.46	37.5	37.34	37.36	12366700.0
2005-05-19 14:00:00	QQQ	ETF	37.35	37.48	37.31	37.41	15690200.0
2005-05-19 15:00:00	QQQ	ETF	37.41	37.52	37.39	37.51	13737800.0
2005-05-19 08:00:00	IWM	ETF	60.505	60.525	60.5	60.525	3000.0
2005-05-19 09:00:00	IWM	ETF	60.535	60.725	60.36	60.715	2361200.0
2005-05-19 10:00:00	IWM	ETF	60.715	60.87	60.555	60.69	6142600.0
2005-05-19 11:00:00	IWM	ETF	60.695	60.815	60.565	60.585	2835400.0
2005-05-19 12:00:00	IWM	ETF	60.585	60.73	60.49	60.72	3611000.0
2005-05-19 13:00:00	IWM	ETF	60.725	60.775	60.4	60.43	3258800.0
2005-05-19 14:00:00	IWM	ETF	60.415	60.6	60.345	60.545	3361600.0
2005-05-19 15:00:00	IWM	ETF	60.555	60.785	60.49	60.72	3663400.0
2005-05-19 16:00:00	IWM	ETF	60.715	60.74	60.61	60.61	541200.0
2005-05-19 17:00:00	IWM	ETF	60.705	60.705	60.685	60.685	400.0
2005-05-19 18:00:00	IWM	ETF	60.755	60.755	60.755	60.755	88000.0
2005-05-19 08:00:00	DIA	ETF	104.86	104.95	104.85	104.95	2100.0
2005-05-19 09:00:00	DIA	ETF	104.98	105.02	104.77	104.92	802400.0
2005-05-19 10:00:00	DIA	ETF	104.9	105.09	104.66	104.85	1005700.0
2005-05-19 11:00:00	DIA	ETF	104.86	105.06	104.8	104.83	436000.0
2005-05-19 12:00:00	DIA	ETF	104.83	104.96	104.7	104.93	412800.0
2005-05-19 13:00:00	DIA	ETF	104.94	105.03	104.72	104.75	264100.0
2005-05-19 14:00:00	DIA	ETF	104.73	104.97	104.59	104.95	740600.0
2005-05-19 15:00:00	DIA	ETF	104.95	105.2	104.9	105.14	1113500.0
2005-05-19 16:00:00	DIA	ETF	105.14	105.16	105.09	105.13	159300.0
2005-05-19 17:00:00	DIA	ETF	105.14	105.14	104.93	104.93	74200.0
2005-05-19 18:00:00	DIA	ETF	105.1	105.1	105.1	105.1	100.0
2005-05-19 08:00:00	GLD	ETF	42.05	42.05	42.05	42.05	600.0
2005-05-19 09:00:00	GLD	ETF	42.0	42.05	41.99	42.0	71200.0
2005-05-19 10:00:00	GLD	ETF	42.0	42.03	41.9	41.94	74100.0
2005-05-19 11:00:00	GLD	ETF	41.95	42.04	41.93	41.98	242200.0
2005-05-19 12:00:00	GLD	ETF	41.99	42.04	41.87	41.95	109800.0
2005-05-19 13:00:00	GLD	ETF	41.97	42.05	41.95	42.01	75100.0
2005-05-19 14:00:00	GLD	ETF	42.02	42.03	42.0	42.02	16900.0
2005-05-19 15:00:00	GLD	ETF	42.02	42.02	41.99	42.01	19200.0
2005-05-19 07:00:00	TLT	ETF	93.4	93.4	93.4	93.4	21000.0

> showing 50 of 880 rows — these rows as CSV

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