PREVIEW / etf_1hour / 2005-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-07-19.parquet
  size:    31 KB
  rows:    959

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-19 04:00:00	SPY	ETF	122.58	122.58	122.58	122.58	16400.0
2005-07-19 07:00:00	SPY	ETF	122.6	122.73	122.58	122.71	40500.0
2005-07-19 08:00:00	SPY	ETF	122.7	122.79	122.68	122.72	190600.0
2005-07-19 09:00:00	SPY	ETF	122.72	122.88	122.41	122.66	6170500.0
2005-07-19 10:00:00	SPY	ETF	122.65	123.03	122.49	122.78	9317000.0
2005-07-19 11:00:00	SPY	ETF	122.79	122.82	122.5	122.7	6161300.0
2005-07-19 12:00:00	SPY	ETF	122.69	122.82	122.53	122.81	2500300.0
2005-07-19 13:00:00	SPY	ETF	122.81	122.87	122.66	122.76	3764900.0
2005-07-19 14:00:00	SPY	ETF	122.76	122.91	122.6	122.83	19584100.0
2005-07-19 15:00:00	SPY	ETF	122.83	123.11	122.75	122.99	8098500.0
2005-07-19 16:00:00	SPY	ETF	123.01	123.08	122.53	122.53	2276700.0
2005-07-19 17:00:00	SPY	ETF	122.52	122.67	122.52	122.6	177100.0
2005-07-19 18:00:00	SPY	ETF	122.6	122.63	122.56	122.56	14800.0
2005-07-19 19:00:00	SPY	ETF	122.63	122.63	122.61	122.61	2400.0
2005-07-19 09:00:00	QQQ	ETF	38.92	38.96	38.84	38.93	10598400.0
2005-07-19 10:00:00	QQQ	ETF	38.93	39.13	38.87	39.06	17027800.0
2005-07-19 11:00:00	QQQ	ETF	39.06	39.08	38.97	39.06	7262700.0
2005-07-19 12:00:00	QQQ	ETF	39.06	39.13	39.02	39.13	4015600.0
2005-07-19 13:00:00	QQQ	ETF	39.13	39.16	39.08	39.12	5829600.0
2005-07-19 14:00:00	QQQ	ETF	39.12	39.17	39.05	39.14	7059900.0
2005-07-19 15:00:00	QQQ	ETF	39.14	39.2	39.11	39.18	16361100.0
2005-07-19 07:00:00	IWM	ETF	65.75	65.8	65.75	65.8	200.0
2005-07-19 08:00:00	IWM	ETF	65.89	65.89	65.84	65.87	9500.0
2005-07-19 09:00:00	IWM	ETF	65.85	66.03	65.75	65.92	2280600.0
2005-07-19 10:00:00	IWM	ETF	65.93	66.27	65.77	66.16	2970600.0
2005-07-19 11:00:00	IWM	ETF	66.16	66.17	65.88	66.14	1317200.0
2005-07-19 12:00:00	IWM	ETF	66.15	66.35	66.05	66.32	962300.0
2005-07-19 13:00:00	IWM	ETF	66.32	66.42	66.26	66.42	1383600.0
2005-07-19 14:00:00	IWM	ETF	66.43	66.51	66.32	66.45	1553000.0
2005-07-19 15:00:00	IWM	ETF	66.45	66.65	66.41	66.55	2783900.0
2005-07-19 16:00:00	IWM	ETF	66.56	66.6	66.18	66.18	525900.0
2005-07-19 17:00:00	IWM	ETF	66.2	66.2	66.17	66.2	30200.0
2005-07-19 18:00:00	IWM	ETF	66.15	66.25	66.14	66.25	4600.0
2005-07-19 19:00:00	IWM	ETF	66.27	66.27	66.27	66.27	500.0
2005-07-19 07:00:00	DIA	ETF	106.23	106.3	106.2	106.3	1000.0
2005-07-19 08:00:00	DIA	ETF	106.34	106.46	106.34	106.45	15600.0
2005-07-19 09:00:00	DIA	ETF	106.44	106.55	106.17	106.34	838600.0
2005-07-19 10:00:00	DIA	ETF	106.35	106.59	106.2	106.41	570900.0
2005-07-19 11:00:00	DIA	ETF	106.4	106.42	106.14	106.29	482900.0
2005-07-19 12:00:00	DIA	ETF	106.28	106.34	106.12	106.32	165500.0
2005-07-19 13:00:00	DIA	ETF	106.33	106.36	106.2	106.24	262400.0
2005-07-19 14:00:00	DIA	ETF	106.25	106.38	106.11	106.27	436500.0
2005-07-19 15:00:00	DIA	ETF	106.29	106.49	106.23	106.39	892300.0
2005-07-19 16:00:00	DIA	ETF	106.43	106.43	106.01	106.01	21100.0
2005-07-19 17:00:00	DIA	ETF	105.97	106.05	105.97	106.05	600.0
2005-07-19 18:00:00	DIA	ETF	106.07	106.07	106.07	106.07	600.0
2005-07-19 08:00:00	GLD	ETF	41.88	41.9	41.84	41.85	42400.0
2005-07-19 09:00:00	GLD	ETF	41.88	41.88	41.83	41.85	245200.0
2005-07-19 10:00:00	GLD	ETF	41.86	41.95	41.84	41.9	129500.0
2005-07-19 11:00:00	GLD	ETF	41.91	41.92	41.81	41.91	62400.0

> showing 50 of 959 rows — these rows as CSV

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