PREVIEW / etf_1hour / 2009-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-14.parquet
  size:    139 KB
  rows:    4,283

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-08-14 04:00:00	SPY	ETF	101.9	101.94	101.84	101.85	5500.0
2009-08-14 05:00:00	SPY	ETF	101.78	101.78	101.6	101.6	6100.0
2009-08-14 06:00:00	SPY	ETF	101.71	101.71	101.62	101.64	164043.0
2009-08-14 07:00:00	SPY	ETF	101.62	101.89	101.62	101.78	384164.0
2009-08-14 08:00:00	SPY	ETF	101.77	101.89	101.49	101.56	4863024.0
2009-08-14 09:00:00	SPY	ETF	101.55	101.76	100.5	100.6	30872659.0
2009-08-14 10:00:00	SPY	ETF	100.61	101.52	99.86	100.11	45393578.0
2009-08-14 11:00:00	SPY	ETF	100.1	101.6	99.7	99.9	23517252.0
2009-08-14 12:00:00	SPY	ETF	99.89	100.12	99.8	100.11	13453155.0
2009-08-14 13:00:00	SPY	ETF	100.11	100.14	99.86	100.03	12178814.0
2009-08-14 14:00:00	SPY	ETF	100.04	100.21	99.9	100.12	15070296.0
2009-08-14 15:00:00	SPY	ETF	100.12	100.74	99.97	100.73	36551179.0
2009-08-14 16:00:00	SPY	ETF	100.74	101.13	99.9	100.97	16445102.0
2009-08-14 17:00:00	SPY	ETF	100.97	100.99	100.87	100.9	290020.0
2009-08-14 18:00:00	SPY	ETF	100.9	100.94	100.87	100.89	35373.0
2009-08-14 19:00:00	SPY	ETF	100.93	100.98	100.88	100.93	46661.0
2009-08-14 04:00:00	QQQ	ETF	40.15	40.15	40.15	40.15	1300.0
2009-08-14 06:00:00	QQQ	ETF	40.09	40.09	40.07	40.07	500.0
2009-08-14 07:00:00	QQQ	ETF	40.06	40.17	40.06	40.13	35964.0
2009-08-14 08:00:00	QQQ	ETF	40.13	40.15	39.84	39.86	8758365.0
2009-08-14 09:00:00	QQQ	ETF	39.87	39.97	39.5	39.58	21608278.0
2009-08-14 10:00:00	QQQ	ETF	39.59	39.59	39.35	39.44	23249884.0
2009-08-14 11:00:00	QQQ	ETF	39.44	39.5	39.28	39.315	10415275.0
2009-08-14 12:00:00	QQQ	ETF	39.3199	39.43	39.3	39.42	5830611.0
2009-08-14 13:00:00	QQQ	ETF	39.4101	39.45	39.34	39.44	7373884.0
2009-08-14 14:00:00	QQQ	ETF	39.44	39.48	39.36	39.42	10050412.0
2009-08-14 15:00:00	QQQ	ETF	39.41	39.65	39.39	39.63	18019271.0
2009-08-14 16:00:00	QQQ	ETF	39.63	40.0763	39.5278	39.72	9597301.0
2009-08-14 17:00:00	QQQ	ETF	39.72	39.73	39.71	39.72	19170.0
2009-08-14 18:00:00	QQQ	ETF	39.72	39.73	39.71	39.73	10423.0
2009-08-14 19:00:00	QQQ	ETF	39.72	39.73	39.7	39.73	23454.0
2009-08-14 06:00:00	IWM	ETF	57.69	57.69	57.69	57.69	200.0
2009-08-14 07:00:00	IWM	ETF	57.63	57.81	57.63	57.7	17623.0
2009-08-14 08:00:00	IWM	ETF	57.7	57.77	57.45	57.47	958019.0
2009-08-14 09:00:00	IWM	ETF	57.48	57.61	56.54	56.565	9751009.0
2009-08-14 10:00:00	IWM	ETF	56.565	56.565	56.14	56.27	9261882.0
2009-08-14 11:00:00	IWM	ETF	56.27	56.34	55.88	56.06	5728005.0
2009-08-14 12:00:00	IWM	ETF	56.065	56.09	55.89	56.07	3143926.0
2009-08-14 13:00:00	IWM	ETF	56.07	56.07	55.9	55.97	3081867.0
2009-08-14 14:00:00	IWM	ETF	55.97	56.04	55.82	55.98	5510560.0
2009-08-14 15:00:00	IWM	ETF	55.98	56.46	55.98	56.39	8669537.0
2009-08-14 16:00:00	IWM	ETF	56.39	57.5539	56.0501	56.66	8881012.0
2009-08-14 17:00:00	IWM	ETF	56.66	56.66	56.57	56.57	6362.0
2009-08-14 18:00:00	IWM	ETF	56.55	56.58	56.48	56.48	2519.0
2009-08-14 19:00:00	IWM	ETF	56.5	56.61	56.45	56.45	5900.0
2009-08-14 07:00:00	DIA	ETF	94.37	94.37	94.22	94.25	3600.0
2009-08-14 08:00:00	DIA	ETF	94.33	94.36	94.05	94.08	38550.0
2009-08-14 09:00:00	DIA	ETF	94.07	94.28	93.27	93.38	1571633.0
2009-08-14 10:00:00	DIA	ETF	93.38	93.38	92.682	92.9	3074695.0
2009-08-14 11:00:00	DIA	ETF	92.9	92.98	92.5	92.69	1671030.0

> showing 50 of 4,283 rows — these rows as CSV

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