PREVIEW / etf_1hour / 2011-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-10-06.parquet
  size:    186 KB
  rows:    5,730

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-06 04:00:00	SPY	ETF	114.42	115.12	114.42	115.02	74347.0
2011-10-06 05:00:00	SPY	ETF	115.0	115.11	114.67	114.8	34419.0
2011-10-06 06:00:00	SPY	ETF	114.78	115.03	114.65	114.97	112016.0
2011-10-06 07:00:00	SPY	ETF	114.97	115.43	114.17	114.55	2447058.0
2011-10-06 08:00:00	SPY	ETF	114.55	115.25	114.15	114.58	6548680.0
2011-10-06 09:00:00	SPY	ETF	114.56	114.62	113.51	113.925	34517703.0
2011-10-06 10:00:00	SPY	ETF	113.92	115.35	113.64	114.804	44644062.0
2011-10-06 11:00:00	SPY	ETF	114.8	116.07	114.73	115.72	34616827.0
2011-10-06 12:00:00	SPY	ETF	115.71	116.04	115.46	115.52	20999211.0
2011-10-06 13:00:00	SPY	ETF	115.52	115.83	115.16	115.61	21623256.0
2011-10-06 14:00:00	SPY	ETF	115.61	116.22	115.45	115.85	25979428.0
2011-10-06 15:00:00	SPY	ETF	115.84	116.66	115.39	116.517	53194831.0
2011-10-06 16:00:00	SPY	ETF	116.5	116.573	115.51	116.37	9748779.0
2011-10-06 17:00:00	SPY	ETF	116.37	116.42	116.31	116.34	240249.0
2011-10-06 18:00:00	SPY	ETF	116.34	116.51	116.31	116.4	350458.0
2011-10-06 19:00:00	SPY	ETF	116.38	116.4	116.29	116.36	102098.0
2011-10-06 04:00:00	QQQ	ETF	53.54	53.8	53.48	53.8	13100.0
2011-10-06 05:00:00	QQQ	ETF	53.6	53.73	53.46	53.46	13500.0
2011-10-06 06:00:00	QQQ	ETF	53.48	53.65	53.48	53.63	14725.0
2011-10-06 07:00:00	QQQ	ETF	53.63	53.79	53.43	53.62	601737.0
2011-10-06 08:00:00	QQQ	ETF	53.58	53.86	53.42	53.63	1532830.0
2011-10-06 09:00:00	QQQ	ETF	53.62	53.68	53.21	53.48	12387499.0
2011-10-06 10:00:00	QQQ	ETF	53.48	54.18	53.34	53.87	13906475.0
2011-10-06 11:00:00	QQQ	ETF	53.86	54.2	53.74	54.0975	10387942.0
2011-10-06 12:00:00	QQQ	ETF	54.09	54.32	54.04	54.06	7295851.0
2011-10-06 13:00:00	QQQ	ETF	54.05	54.17	53.76	54.03	7180804.0
2011-10-06 14:00:00	QQQ	ETF	54.04	54.27	53.95	54.16	4627626.0
2011-10-06 15:00:00	QQQ	ETF	54.16	54.44	53.93	54.41	10519046.0
2011-10-06 16:00:00	QQQ	ETF	54.42	54.45	54.24	54.28	2007245.0
2011-10-06 17:00:00	QQQ	ETF	54.3	54.33	54.28	54.29	26135.0
2011-10-06 18:00:00	QQQ	ETF	54.29	54.32	54.25	54.3	31272.0
2011-10-06 19:00:00	QQQ	ETF	54.29	54.3	54.25	54.29	29500.0
2011-10-06 04:00:00	IWM	ETF	65.88	66.21	65.88	66.21	1865.0
2011-10-06 05:00:00	IWM	ETF	66.2	66.2	66.02	66.02	1000.0
2011-10-06 06:00:00	IWM	ETF	66.0	66.1	66.0	66.02	1230.0
2011-10-06 07:00:00	IWM	ETF	66.24	66.24	65.59	65.81	122797.0
2011-10-06 08:00:00	IWM	ETF	65.7	66.03	65.34	65.61	1540853.0
2011-10-06 09:00:00	IWM	ETF	65.63	66.02	65.15	65.39	11759208.0
2011-10-06 10:00:00	IWM	ETF	65.39	66.38	65.15	66.16	14617040.0
2011-10-06 11:00:00	IWM	ETF	66.15	66.76	66.07	66.61	9128074.0
2011-10-06 12:00:00	IWM	ETF	66.6	66.99	66.51	66.75	7193860.0
2011-10-06 13:00:00	IWM	ETF	66.76	66.92	66.25	66.5099	7703569.0
2011-10-06 14:00:00	IWM	ETF	66.53	66.955	66.32	66.7	10006980.0
2011-10-06 15:00:00	IWM	ETF	66.73	67.31	66.31	67.18	17347666.0
2011-10-06 16:00:00	IWM	ETF	67.17	67.221	67.0	67.09	2487387.0
2011-10-06 17:00:00	IWM	ETF	67.13	67.17	67.07	67.17	7100.0
2011-10-06 18:00:00	IWM	ETF	67.16	67.16	67.07	67.09	10267.0
2011-10-06 19:00:00	IWM	ETF	67.1	67.13	67.09	67.13	5500.0
2011-10-06 04:00:00	DIA	ETF	109.85	109.95	109.85	109.95	12000.0
2011-10-06 05:00:00	DIA	ETF	109.9	109.9	109.85	109.85	400.0

> showing 50 of 5,730 rows — these rows as CSV

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