PREVIEW / etf_1hour / 2011-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-08.parquet
  size:    184 KB
  rows:    5,628

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-12-08 04:00:00	SPY	ETF	126.76	126.77	126.5	126.67	50100.0
2011-12-08 05:00:00	SPY	ETF	126.79	126.85	126.4	126.4	98700.0
2011-12-08 06:00:00	SPY	ETF	126.39	126.83	126.39	126.8	80585.0
2011-12-08 07:00:00	SPY	ETF	126.73	127.06	126.6	126.91	925329.0
2011-12-08 08:00:00	SPY	ETF	126.91	127.77	126.19	126.46	10884221.0
2011-12-08 09:00:00	SPY	ETF	126.46	126.47	125.53	125.79	32560763.0
2011-12-08 10:00:00	SPY	ETF	125.78	125.91	125.21	125.4	31900979.0
2011-12-08 11:00:00	SPY	ETF	125.4	125.42	124.65	125.06	28165336.0
2011-12-08 12:00:00	SPY	ETF	125.06	125.25	124.75	124.86	20966598.0
2011-12-08 13:00:00	SPY	ETF	124.86	124.87	124.26	124.63	21548610.0
2011-12-08 14:00:00	SPY	ETF	124.63	124.795	124.134	124.27	16520592.0
2011-12-08 15:00:00	SPY	ETF	124.27	125.21	123.65	123.97	61005976.0
2011-12-08 16:00:00	SPY	ETF	123.97	126.6207	123.82	123.84	11503568.0
2011-12-08 17:00:00	SPY	ETF	123.83	123.98	123.76	123.95	388069.0
2011-12-08 18:00:00	SPY	ETF	123.94	124.16	123.92	124.12	535171.0
2011-12-08 19:00:00	SPY	ETF	124.05	124.32	124.05	124.11	201151.0
2011-12-08 04:00:00	QQQ	ETF	57.15	57.15	57.15	57.15	500.0
2011-12-08 05:00:00	QQQ	ETF	57.03	57.03	56.97	56.97	700.0
2011-12-08 07:00:00	QQQ	ETF	57.06	57.28	57.03	57.26	396909.0
2011-12-08 08:00:00	QQQ	ETF	57.21	57.55	56.87	56.96	2517136.0
2011-12-08 09:00:00	QQQ	ETF	56.94	57.15	56.56	56.95	5320617.0
2011-12-08 10:00:00	QQQ	ETF	56.95	57.02	56.64	56.8	7432145.0
2011-12-08 11:00:00	QQQ	ETF	56.79	56.82	56.57	56.72	4493716.0
2011-12-08 12:00:00	QQQ	ETF	56.72	56.78	56.56	56.6	5886319.0
2011-12-08 13:00:00	QQQ	ETF	56.6	56.6	56.3	56.48	5894695.0
2011-12-08 14:00:00	QQQ	ETF	56.48	56.56	56.28	56.34	4195837.0
2011-12-08 15:00:00	QQQ	ETF	56.34	56.69	56.01	56.12	11886713.0
2011-12-08 16:00:00	QQQ	ETF	56.12	56.2	55.94	55.95	3285302.0
2011-12-08 17:00:00	QQQ	ETF	55.95	56.02	55.9	56.0	92042.0
2011-12-08 18:00:00	QQQ	ETF	55.98	56.07	55.98	56.07	56730.0
2011-12-08 19:00:00	QQQ	ETF	56.08	56.11	56.06	56.06	19115.0
2011-12-08 04:00:00	IWM	ETF	74.61	74.61	74.59	74.59	600.0
2011-12-08 06:00:00	IWM	ETF	74.37	74.37	74.37	74.37	100.0
2011-12-08 07:00:00	IWM	ETF	74.65	74.81	74.51	74.7	165495.0
2011-12-08 08:00:00	IWM	ETF	74.67	75.43	74.27	74.44	1807723.0
2011-12-08 09:00:00	IWM	ETF	74.39	74.4	73.65	73.83	6521994.0
2011-12-08 10:00:00	IWM	ETF	73.82	73.9	73.29	73.53	7578800.0
2011-12-08 11:00:00	IWM	ETF	73.53	73.62	73.16	73.39	5698257.0
2011-12-08 12:00:00	IWM	ETF	73.39	73.56	73.08	73.1601	4332715.0
2011-12-08 13:00:00	IWM	ETF	73.16	73.17	72.59	72.89	5412102.0
2011-12-08 14:00:00	IWM	ETF	72.88	73.02	72.54	72.6	4580103.0
2011-12-08 15:00:00	IWM	ETF	72.6	73.4	72.22	72.37	14557056.0
2011-12-08 16:00:00	IWM	ETF	72.38	74.6623	72.18	72.18	4494270.0
2011-12-08 17:00:00	IWM	ETF	72.18	72.23	72.0	72.23	43031.0
2011-12-08 18:00:00	IWM	ETF	72.29	72.34	72.17	72.27	49415.0
2011-12-08 19:00:00	IWM	ETF	72.3	72.39	72.3	72.33	925801.0
2011-12-08 08:00:00	DIA	ETF	122.48	122.98	121.61	121.9	28666.0
2011-12-08 09:00:00	DIA	ETF	121.91	121.91	121.11	121.48	1256324.0
2011-12-08 10:00:00	DIA	ETF	121.48	121.57	120.99	121.16	1134835.0
2011-12-08 11:00:00	DIA	ETF	121.15	121.17	120.455	120.77	1119530.0

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

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