PREVIEW / etf_1hour / 2005-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-19.parquet
  size:    30 KB
  rows:    937

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-08-19 06:00:00	SPY	ETF	122.5	122.5	122.5	122.5	400.0
2005-08-19 07:00:00	SPY	ETF	122.46	122.46	122.42	122.43	62600.0
2005-08-19 08:00:00	SPY	ETF	122.41	122.5	122.36	122.49	121800.0
2005-08-19 09:00:00	SPY	ETF	122.51	122.64	122.4	122.55	4951800.0
2005-08-19 10:00:00	SPY	ETF	122.54	122.82	122.5	122.68	6435700.0
2005-08-19 11:00:00	SPY	ETF	122.66	122.8	122.56	122.59	4413600.0
2005-08-19 12:00:00	SPY	ETF	122.6	122.74	122.44	122.54	3139300.0
2005-08-19 13:00:00	SPY	ETF	122.54	122.55	122.27	122.48	6954000.0
2005-08-19 14:00:00	SPY	ETF	122.5	122.56	122.24	122.32	5560300.0
2005-08-19 15:00:00	SPY	ETF	122.33	122.51	122.2	122.27	5169100.0
2005-08-19 16:00:00	SPY	ETF	122.27	122.52	122.22	122.47	1980700.0
2005-08-19 17:00:00	SPY	ETF	122.47	122.62	122.37	122.4	53900.0
2005-08-19 18:00:00	SPY	ETF	122.44	122.48	122.43	122.48	1500.0
2005-08-19 09:00:00	QQQ	ETF	38.89	38.91	38.79	38.89	6459900.0
2005-08-19 10:00:00	QQQ	ETF	38.89	38.99	38.86	38.94	9095600.0
2005-08-19 11:00:00	QQQ	ETF	38.94	39.0	38.91	38.92	5826200.0
2005-08-19 12:00:00	QQQ	ETF	38.92	38.93	38.86	38.88	4358700.0
2005-08-19 13:00:00	QQQ	ETF	38.89	38.9	38.81	38.85	4785300.0
2005-08-19 14:00:00	QQQ	ETF	38.85	38.87	38.8	38.81	6736600.0
2005-08-19 15:00:00	QQQ	ETF	38.81	38.9	38.81	38.82	9640700.0
2005-08-19 07:00:00	IWM	ETF	64.98	64.99	64.97	64.97	22900.0
2005-08-19 08:00:00	IWM	ETF	64.95	65.0	64.92	65.0	24200.0
2005-08-19 09:00:00	IWM	ETF	65.01	65.07	64.71	64.9	1904200.0
2005-08-19 10:00:00	IWM	ETF	64.9	65.1	64.77	65.05	2231800.0
2005-08-19 11:00:00	IWM	ETF	65.05	65.16	64.95	65.02	1720800.0
2005-08-19 12:00:00	IWM	ETF	65.02	65.1	64.98	65.05	2266000.0
2005-08-19 13:00:00	IWM	ETF	65.04	65.08	64.9	65.01	2332900.0
2005-08-19 14:00:00	IWM	ETF	65.01	65.1	64.88	64.92	3293800.0
2005-08-19 15:00:00	IWM	ETF	64.91	65.05	64.89	65.01	5199900.0
2005-08-19 16:00:00	IWM	ETF	65.01	65.13	64.96	65.1	862300.0
2005-08-19 17:00:00	IWM	ETF	65.04	65.04	65.04	65.04	800.0
2005-08-19 07:00:00	DIA	ETF	105.74	105.74	105.72	105.72	4400.0
2005-08-19 08:00:00	DIA	ETF	105.73	105.76	105.73	105.76	5700.0
2005-08-19 09:00:00	DIA	ETF	105.85	105.91	105.67	105.85	341500.0
2005-08-19 10:00:00	DIA	ETF	105.83	106.2	105.79	106.08	1207800.0
2005-08-19 11:00:00	DIA	ETF	106.08	106.18	105.99	105.99	463800.0
2005-08-19 12:00:00	DIA	ETF	105.99	106.03	105.83	105.87	332400.0
2005-08-19 13:00:00	DIA	ETF	105.87	105.93	105.71	105.89	302700.0
2005-08-19 14:00:00	DIA	ETF	105.89	105.95	105.54	105.65	694200.0
2005-08-19 15:00:00	DIA	ETF	105.66	105.77	105.52	105.56	585100.0
2005-08-19 16:00:00	DIA	ETF	105.55	105.75	105.55	105.74	18000.0
2005-08-19 17:00:00	DIA	ETF	105.8	105.89	105.8	105.86	800.0
2005-08-19 09:00:00	GLD	ETF	43.72	43.88	43.66	43.88	116100.0
2005-08-19 10:00:00	GLD	ETF	43.87	43.88	43.68	43.7	76600.0
2005-08-19 11:00:00	GLD	ETF	43.73	43.76	43.49	43.56	160300.0
2005-08-19 12:00:00	GLD	ETF	43.54	43.66	43.53	43.64	124100.0
2005-08-19 13:00:00	GLD	ETF	43.64	43.67	43.57	43.65	146900.0
2005-08-19 14:00:00	GLD	ETF	43.64	43.67	43.6	43.67	78200.0
2005-08-19 15:00:00	GLD	ETF	43.64	43.84	43.59	43.6	103200.0
2005-08-19 08:00:00	TLT	ETF	93.5	93.5	93.46	93.46	9500.0

> showing 50 of 937 rows — these rows as CSV

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