PREVIEW / etf_1hour / 2011-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-03.parquet
  size:    185 KB
  rows:    5,678

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-11-03 04:00:00	SPY	ETF	122.5	123.13	122.25	123.13	6619.0
2011-11-03 05:00:00	SPY	ETF	123.2	124.27	123.14	123.95	51771.0
2011-11-03 06:00:00	SPY	ETF	123.95	124.87	123.95	124.38	175782.0
2011-11-03 07:00:00	SPY	ETF	124.42	124.72	123.98	124.43	1739302.0
2011-11-03 08:00:00	SPY	ETF	123.07	126.0	122.23	125.73	14920407.0
2011-11-03 09:00:00	SPY	ETF	125.71	125.76	123.9513	124.38	35826756.0
2011-11-03 10:00:00	SPY	ETF	124.38	125.14	123.595	124.68	62461445.0
2011-11-03 11:00:00	SPY	ETF	124.68	125.33	124.52	124.91	25537339.0
2011-11-03 12:00:00	SPY	ETF	124.91	125.59	124.83	125.51	23111880.0
2011-11-03 13:00:00	SPY	ETF	125.51	126.21	125.37	125.85	24149553.0
2011-11-03 14:00:00	SPY	ETF	125.86	126.16	125.63	125.82	29269580.0
2011-11-03 15:00:00	SPY	ETF	125.825	126.5	125.8	126.26	46494065.0
2011-11-03 16:00:00	SPY	ETF	126.25	126.2943	126.01	126.07	19668664.0
2011-11-03 17:00:00	SPY	ETF	126.07	126.23	126.06	126.14	324620.0
2011-11-03 18:00:00	SPY	ETF	126.12	126.275	125.96	126.08	5057526.0
2011-11-03 19:00:00	SPY	ETF	126.09	126.18	125.99	126.1	77805.0
2011-11-03 04:00:00	QQQ	ETF	56.3	56.32	56.12	56.32	11784.0
2011-11-03 05:00:00	QQQ	ETF	56.59	56.86	56.55	56.86	2500.0
2011-11-03 06:00:00	QQQ	ETF	56.96	57.18	56.9	57.04	9653.0
2011-11-03 07:00:00	QQQ	ETF	57.06	57.11	56.8	57.05	1093696.0
2011-11-03 08:00:00	QQQ	ETF	57.01	57.43	57.0	57.37	6803745.0
2011-11-03 09:00:00	QQQ	ETF	57.35	57.43	56.95	57.02	8811071.0
2011-11-03 10:00:00	QQQ	ETF	57.03	57.47	56.71	57.26	14471608.0
2011-11-03 11:00:00	QQQ	ETF	57.26	57.68	57.24	57.42	6821437.0
2011-11-03 12:00:00	QQQ	ETF	57.41	57.69	57.33	57.64	5806197.0
2011-11-03 13:00:00	QQQ	ETF	57.65	57.97	57.58	57.825	6402784.0
2011-11-03 14:00:00	QQQ	ETF	57.83	57.94	57.78	57.89	8255462.0
2011-11-03 15:00:00	QQQ	ETF	57.89	58.175	57.88	58.099	13183540.0
2011-11-03 16:00:00	QQQ	ETF	58.1	58.17	58.03	58.06	1467285.0
2011-11-03 17:00:00	QQQ	ETF	58.07	58.13	58.04	58.12	216899.0
2011-11-03 18:00:00	QQQ	ETF	58.11	58.11	58.0	58.0	91433.0
2011-11-03 19:00:00	QQQ	ETF	58.07	58.1	58.04	58.04	9420.0
2011-11-03 04:00:00	IWM	ETF	72.0	72.41	71.9	72.41	1458.0
2011-11-03 05:00:00	IWM	ETF	72.58	73.22	72.58	73.22	400.0
2011-11-03 06:00:00	IWM	ETF	73.3	73.62	73.3	73.56	2100.0
2011-11-03 07:00:00	IWM	ETF	73.18	73.6	73.04	73.54	360423.0
2011-11-03 08:00:00	IWM	ETF	73.45	75.28	73.2802	74.59	2015900.0
2011-11-03 09:00:00	IWM	ETF	74.6	74.67	72.99	73.15	7382590.0
2011-11-03 10:00:00	IWM	ETF	73.15	73.93	72.29	73.6	15613961.0
2011-11-03 11:00:00	IWM	ETF	73.6	74.2	73.37	73.8	6754341.0
2011-11-03 12:00:00	IWM	ETF	73.8	74.509	73.76	74.468	6098164.0
2011-11-03 13:00:00	IWM	ETF	74.46	75.06	74.3	74.75	8078154.0
2011-11-03 14:00:00	IWM	ETF	74.76	75.0	74.49	74.67	7284573.0
2011-11-03 15:00:00	IWM	ETF	74.67	75.2	74.66	75.0	12408034.0
2011-11-03 16:00:00	IWM	ETF	75.0	75.1333	74.63	74.76	1954202.0
2011-11-03 17:00:00	IWM	ETF	74.68	74.76	74.68	74.74	3640.0
2011-11-03 18:00:00	IWM	ETF	74.73	74.77	74.68	74.7	3532.0
2011-11-03 19:00:00	IWM	ETF	74.7	74.82	74.69	74.69	4567.0
2011-11-03 04:00:00	DIA	ETF	116.88	116.88	116.88	116.88	100.0
2011-11-03 05:00:00	DIA	ETF	117.68	118.15	117.68	118.15	600.0

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

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