PREVIEW / etf_1hour / 2005-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-14.parquet
  size:    31 KB
  rows:    935

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-07-14 07:00:00	SPY	ETF	122.81	122.94	122.81	122.87	123500.0
2005-07-14 08:00:00	SPY	ETF	122.86	123.17	122.45	123.13	1863600.0
2005-07-14 09:00:00	SPY	ETF	123.12	123.44	122.95	122.98	10120600.0
2005-07-14 10:00:00	SPY	ETF	123.0	123.25	122.78	122.92	14271500.0
2005-07-14 11:00:00	SPY	ETF	122.92	123.04	122.55	122.66	9003200.0
2005-07-14 12:00:00	SPY	ETF	122.66	122.91	122.66	122.76	5018800.0
2005-07-14 13:00:00	SPY	ETF	122.77	123.01	122.5	122.58	6030900.0
2005-07-14 14:00:00	SPY	ETF	122.58	122.71	122.49	122.61	4788700.0
2005-07-14 15:00:00	SPY	ETF	122.611	123.12	122.6	122.74	8975200.0
2005-07-14 16:00:00	SPY	ETF	122.74	123.06	122.69	122.75	2332600.0
2005-07-14 17:00:00	SPY	ETF	122.74	122.83	122.7	122.71	88000.0
2005-07-14 18:00:00	SPY	ETF	122.72	122.75	122.72	122.72	2000.0
2005-07-14 19:00:00	SPY	ETF	122.78	122.78	122.78	122.78	100.0
2005-07-14 09:00:00	QQQ	ETF	38.65	38.88	38.63	38.63	21032700.0
2005-07-14 10:00:00	QQQ	ETF	38.63	38.75	38.52	38.7	19233900.0
2005-07-14 11:00:00	QQQ	ETF	38.7	38.73	38.6	38.66	9707100.0
2005-07-14 12:00:00	QQQ	ETF	38.66	38.77	38.65	38.72	7517200.0
2005-07-14 13:00:00	QQQ	ETF	38.72	38.85	38.67	38.69	11595200.0
2005-07-14 14:00:00	QQQ	ETF	38.7	38.74	38.63	38.68	9051000.0
2005-07-14 15:00:00	QQQ	ETF	38.68	38.82	37.78	38.77	12769800.0
2005-07-14 07:00:00	IWM	ETF	66.65	66.75	66.65	66.75	8300.0
2005-07-14 08:00:00	IWM	ETF	66.73	67.0	66.73	66.95	56100.0
2005-07-14 09:00:00	IWM	ETF	66.97	67.07	66.57	66.57	4413500.0
2005-07-14 10:00:00	IWM	ETF	66.56	66.73	66.29	66.37	4522300.0
2005-07-14 11:00:00	IWM	ETF	66.38	66.45	66.02	66.06	3678000.0
2005-07-14 12:00:00	IWM	ETF	66.05	66.17	65.93	66.02	2715100.0
2005-07-14 13:00:00	IWM	ETF	66.02	66.27	65.96	66.03	3817400.0
2005-07-14 14:00:00	IWM	ETF	66.02	66.07	65.78	65.82	2316100.0
2005-07-14 15:00:00	IWM	ETF	65.82	66.15	65.82	65.87	3871600.0
2005-07-14 16:00:00	IWM	ETF	65.87	65.96	65.85	65.89	111600.0
2005-07-14 17:00:00	IWM	ETF	65.94	65.96	65.94	65.96	4000.0
2005-07-14 07:00:00	DIA	ETF	105.91	105.95	105.9	105.94	28800.0
2005-07-14 08:00:00	DIA	ETF	105.91	106.21	105.9	106.21	55500.0
2005-07-14 09:00:00	DIA	ETF	106.2	106.57	106.05	106.29	4022400.0
2005-07-14 10:00:00	DIA	ETF	106.28	106.5	106.13	106.28	1331400.0
2005-07-14 11:00:00	DIA	ETF	106.27	106.35	106.04	106.13	646800.0
2005-07-14 12:00:00	DIA	ETF	106.15	106.38	106.15	106.28	386100.0
2005-07-14 13:00:00	DIA	ETF	106.28	106.48	106.14	106.2	1805900.0
2005-07-14 14:00:00	DIA	ETF	106.2	106.29	106.14	106.25	565600.0
2005-07-14 15:00:00	DIA	ETF	106.27	106.5	106.25	106.28	1575700.0
2005-07-14 16:00:00	DIA	ETF	106.29	106.49	106.29	106.35	296300.0
2005-07-14 19:00:00	DIA	ETF	106.41	106.41	106.35	106.35	400.0
2005-07-14 08:00:00	GLD	ETF	42.29	42.29	42.29	42.29	100.0
2005-07-14 09:00:00	GLD	ETF	42.35	42.35	42.27	42.31	94200.0
2005-07-14 10:00:00	GLD	ETF	42.32	42.36	42.272	42.3	78500.0
2005-07-14 11:00:00	GLD	ETF	42.28	42.32	41.98	42.0	218200.0
2005-07-14 12:00:00	GLD	ETF	41.98	42.01	41.8	41.82	925000.0
2005-07-14 13:00:00	GLD	ETF	41.82	41.92	41.81	41.87	113400.0
2005-07-14 14:00:00	GLD	ETF	41.87	41.93	41.86	41.89	97200.0
2005-07-14 15:00:00	GLD	ETF	41.89	41.91	41.83	41.9	105500.0

> showing 50 of 935 rows — these rows as CSV

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