PREVIEW / etf_1hour / 2011-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-04.parquet
  size:    196 KB
  rows:    6,103

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
2011-10-04 04:00:00	SPY	ETF	108.48	109.2	108.37	109.03	5064.0
2011-10-04 05:00:00	SPY	ETF	108.97	109.22	108.63	109.1	16538.0
2011-10-04 06:00:00	SPY	ETF	108.89	109.2	108.35	108.38	201844.0
2011-10-04 07:00:00	SPY	ETF	108.35	108.67	107.95	108.03	1501724.0
2011-10-04 08:00:00	SPY	ETF	108.04	110.0	107.83	108.45	5032425.0
2011-10-04 09:00:00	SPY	ETF	108.45	108.91	107.43	107.86	53529855.0
2011-10-04 10:00:00	SPY	ETF	107.87	109.51	107.48	109.24	96783544.0
2011-10-04 11:00:00	SPY	ETF	109.25	109.94	108.74	109.6	51998408.0
2011-10-04 12:00:00	SPY	ETF	109.59	110.35	109.59	109.881	43355146.0
2011-10-04 13:00:00	SPY	ETF	109.89	110.05	109.0	109.11	32543531.0
2011-10-04 14:00:00	SPY	ETF	109.11	109.53	108.24	108.35	43252140.0
2011-10-04 15:00:00	SPY	ETF	108.3501	112.58	107.89	112.32	100560899.0
2011-10-04 16:00:00	SPY	ETF	112.315	112.45	108.6	111.9	26293964.0
2011-10-04 17:00:00	SPY	ETF	111.91	112.2	111.7946	112.06	656753.0
2011-10-04 18:00:00	SPY	ETF	112.06	112.29	111.84	112.22	595525.0
2011-10-04 19:00:00	SPY	ETF	112.21	112.36	112.17	112.18	407934.0
2011-10-04 04:00:00	QQQ	ETF	50.72	50.72	50.38	50.55	2775.0
2011-10-04 05:00:00	QQQ	ETF	50.66	50.66	50.61	50.61	1000.0
2011-10-04 06:00:00	QQQ	ETF	50.69	50.69	50.5	50.57	2875.0
2011-10-04 07:00:00	QQQ	ETF	50.53	50.59	50.29	50.35	86720.0
2011-10-04 08:00:00	QQQ	ETF	50.34	50.65	50.25	50.61	1165344.0
2011-10-04 09:00:00	QQQ	ETF	50.61	50.84	50.3	50.52	12242675.0
2011-10-04 10:00:00	QQQ	ETF	50.52	51.33	50.25	51.2405	21996351.0
2011-10-04 11:00:00	QQQ	ETF	51.25	51.63	51.12	51.54	15101678.0
2011-10-04 12:00:00	QQQ	ETF	51.541	51.9	51.42	51.47	11651497.0
2011-10-04 13:00:00	QQQ	ETF	51.462	51.58	50.92	50.94	12176559.0
2011-10-04 14:00:00	QQQ	ETF	50.95	51.14	50.38	50.42	19003105.0
2011-10-04 15:00:00	QQQ	ETF	50.42	52.29	50.095	52.22	29241424.0
2011-10-04 16:00:00	QQQ	ETF	52.21	52.32	51.75	52.03	6271786.0
2011-10-04 17:00:00	QQQ	ETF	52.03	52.11	52.0	52.09	96949.0
2011-10-04 18:00:00	QQQ	ETF	52.06	52.24	52.04	52.22	304470.0
2011-10-04 19:00:00	QQQ	ETF	52.24	52.26	52.15	52.18	36254.0
2011-10-04 04:00:00	IWM	ETF	60.21	60.21	60.21	60.21	409.0
2011-10-04 05:00:00	IWM	ETF	60.61	60.85	60.6	60.79	2000.0
2011-10-04 06:00:00	IWM	ETF	60.88	60.88	60.63	60.8	900.0
2011-10-04 07:00:00	IWM	ETF	60.7	61.0	60.22	60.33	125687.0
2011-10-04 08:00:00	IWM	ETF	60.3	60.97	60.01	60.51	1264844.0
2011-10-04 09:00:00	IWM	ETF	60.5	60.97	60.09	60.55	19096938.0
2011-10-04 10:00:00	IWM	ETF	60.54	61.58	60.12	61.41	32225731.0
2011-10-04 11:00:00	IWM	ETF	61.409	62.13	61.18	61.63	15700207.0
2011-10-04 12:00:00	IWM	ETF	61.63	62.58	61.63	62.19	15387840.0
2011-10-04 13:00:00	IWM	ETF	62.19	62.35	61.47	61.62	11345452.0
2011-10-04 14:00:00	IWM	ETF	61.63	61.94	60.93	60.95	11288522.0
2011-10-04 15:00:00	IWM	ETF	60.95	64.88	60.62	64.75	33998795.0
2011-10-04 16:00:00	IWM	ETF	64.77	64.85	60.8694	64.29	8601005.0
2011-10-04 17:00:00	IWM	ETF	64.3	64.42	64.24	64.4	121761.0
2011-10-04 18:00:00	IWM	ETF	64.4	64.55	64.39	64.54	13352.0
2011-10-04 19:00:00	IWM	ETF	64.52	64.65	64.5	64.56	10219.0
2011-10-04 04:00:00	DIA	ETF	105.51	105.51	105.51	105.51	1000.0
2011-10-04 05:00:00	DIA	ETF	105.51	105.51	105.51	105.51	1000.0

> showing 50 of 6,103 rows — these rows as CSV

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