PREVIEW / etf_1hour / 2009-11-16

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-16.parquet
  size:    149 KB
  rows:    4,650

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-11-16 04:00:00	SPY	ETF	110.4	110.57	110.4	110.46	5600.0
2009-11-16 05:00:00	SPY	ETF	110.5	110.53	110.5	110.53	26199.0
2009-11-16 06:00:00	SPY	ETF	110.51	110.54	110.39	110.51	36205.0
2009-11-16 07:00:00	SPY	ETF	110.46	110.55	110.39	110.48	714202.0
2009-11-16 08:00:00	SPY	ETF	110.5	110.7	110.25	110.38	4262427.0
2009-11-16 09:00:00	SPY	ETF	110.38	111.21	110.32	111.09	26904321.0
2009-11-16 10:00:00	SPY	ETF	111.09	111.44	111.08	111.4	29767312.0
2009-11-16 11:00:00	SPY	ETF	111.4	111.47	111.2	111.37	17450663.0
2009-11-16 12:00:00	SPY	ETF	111.37	111.42	110.95	111.41	21853079.0
2009-11-16 13:00:00	SPY	ETF	111.41	111.57	111.28	111.46	12204263.0
2009-11-16 14:00:00	SPY	ETF	111.46	111.69	111.36	111.46	19059898.0
2009-11-16 15:00:00	SPY	ETF	111.4501	111.49	110.84	111.21	53703428.0
2009-11-16 16:00:00	SPY	ETF	111.2	111.61	109.6454	111.09	20450579.0
2009-11-16 17:00:00	SPY	ETF	111.1	111.11	111.03	111.04	2605572.0
2009-11-16 18:00:00	SPY	ETF	111.05	111.12	110.98	111.11	50993.0
2009-11-16 19:00:00	SPY	ETF	111.12	111.12	111.01	111.04	26139.0
2009-11-16 06:00:00	QQQ	ETF	44.22	44.3	44.22	44.3	200.0
2009-11-16 07:00:00	QQQ	ETF	44.24	44.28	44.23	44.27	445541.0
2009-11-16 08:00:00	QQQ	ETF	44.33	44.35	44.19	44.23	1567633.0
2009-11-16 09:00:00	QQQ	ETF	44.23	44.55	44.12	44.49	15290926.0
2009-11-16 10:00:00	QQQ	ETF	44.49	44.59	44.46	44.5501	10332173.0
2009-11-16 11:00:00	QQQ	ETF	44.56	44.62	44.47	44.6	9421580.0
2009-11-16 12:00:00	QQQ	ETF	44.5999	44.61	44.44	44.5723	9049979.0
2009-11-16 13:00:00	QQQ	ETF	44.5701	44.6197	44.52	44.59	5091686.0
2009-11-16 14:00:00	QQQ	ETF	44.59	44.65	44.53	44.57	7262498.0
2009-11-16 15:00:00	QQQ	ETF	44.568	44.58	44.33	44.46	19528522.0
2009-11-16 16:00:00	QQQ	ETF	44.46	44.48	44.36	44.4	6179480.0
2009-11-16 17:00:00	QQQ	ETF	44.4	44.41	44.38	44.4	38314.0
2009-11-16 18:00:00	QQQ	ETF	44.38	44.41	44.36	44.41	15037.0
2009-11-16 19:00:00	QQQ	ETF	44.4	44.4	44.36	44.36	48418.0
2009-11-16 06:00:00	IWM	ETF	59.17	59.17	59.17	59.17	100.0
2009-11-16 07:00:00	IWM	ETF	59.21	59.31	59.2	59.31	33084.0
2009-11-16 08:00:00	IWM	ETF	59.28	59.45	59.16	59.21	637739.0
2009-11-16 09:00:00	IWM	ETF	59.22	60.02	59.11	59.84	11844040.0
2009-11-16 10:00:00	IWM	ETF	59.83	60.17	59.82	60.15	8083369.0
2009-11-16 11:00:00	IWM	ETF	60.15	60.41	60.03	60.34	6949879.0
2009-11-16 12:00:00	IWM	ETF	60.34	60.38	59.95	60.31	6136396.0
2009-11-16 13:00:00	IWM	ETF	60.31	60.42	60.24	60.405	2820001.0
2009-11-16 14:00:00	IWM	ETF	60.41	60.68	60.41	60.48	7016321.0
2009-11-16 15:00:00	IWM	ETF	60.48	60.5	60.01	60.31	12283368.0
2009-11-16 16:00:00	IWM	ETF	60.31	60.3658	58.7008	60.18	6168814.0
2009-11-16 17:00:00	IWM	ETF	60.19	60.23	58.7001	60.16	1084931.0
2009-11-16 18:00:00	IWM	ETF	60.16	60.23	60.15	60.23	5500.0
2009-11-16 19:00:00	IWM	ETF	60.29	60.31	60.18	60.31	1400.0
2009-11-16 04:00:00	DIA	ETF	103.16	103.16	103.16	103.16	200.0
2009-11-16 07:00:00	DIA	ETF	103.67	103.67	103.67	103.67	2100.0
2009-11-16 08:00:00	DIA	ETF	103.52	103.71	103.41	103.44	30004.0
2009-11-16 09:00:00	DIA	ETF	103.47	104.1	103.35	103.99	1941962.0
2009-11-16 10:00:00	DIA	ETF	103.99	104.37	103.97	104.326	1835233.0
2009-11-16 11:00:00	DIA	ETF	104.33	104.37	104.13	104.3194	744255.0

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

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