PREVIEW / etf_1hour / 2012-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-06.parquet
  size:    185 KB
  rows:    5,774

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
2012-02-06 04:00:00	SPY	ETF	134.1	134.1	133.51	133.77	80527.0
2012-02-06 05:00:00	SPY	ETF	133.74	133.86	133.72	133.74	6701.0
2012-02-06 06:00:00	SPY	ETF	133.8	133.94	133.64	133.79	76315.0
2012-02-06 07:00:00	SPY	ETF	133.8	134.06	133.77	134.0	721334.0
2012-02-06 08:00:00	SPY	ETF	133.97	134.03	133.72	133.72	877567.0
2012-02-06 09:00:00	SPY	ETF	133.73	134.25	133.71	134.12	15609849.0
2012-02-06 10:00:00	SPY	ETF	134.11	134.31	133.94	134.146	15049062.0
2012-02-06 11:00:00	SPY	ETF	134.145	134.34	134.09	134.31	12078019.0
2012-02-06 12:00:00	SPY	ETF	134.31	134.41	134.16	134.36	11154902.0
2012-02-06 13:00:00	SPY	ETF	134.36	134.4	134.11	134.19	7272265.0
2012-02-06 14:00:00	SPY	ETF	134.19	134.36	134.17	134.2805	11367995.0
2012-02-06 15:00:00	SPY	ETF	134.28	134.5	134.28	134.45	19470760.0
2012-02-06 16:00:00	SPY	ETF	134.44	134.57	134.19	134.47	11791992.0
2012-02-06 17:00:00	SPY	ETF	134.47	134.51	134.43	134.45	221252.0
2012-02-06 18:00:00	SPY	ETF	134.46	134.54	134.46	134.48	104569.0
2012-02-06 19:00:00	SPY	ETF	134.48	134.54	134.4	134.5	72479.0
2012-02-06 04:00:00	QQQ	ETF	61.83	61.83	61.7	61.7	500.0
2012-02-06 05:00:00	QQQ	ETF	61.7	61.7	61.7	61.7	2000.0
2012-02-06 07:00:00	QQQ	ETF	61.75	61.86	61.75	61.77	14614.0
2012-02-06 08:00:00	QQQ	ETF	61.87	61.87	61.69	61.69	380838.0
2012-02-06 09:00:00	QQQ	ETF	61.69	61.87	61.66	61.83	3543067.0
2012-02-06 10:00:00	QQQ	ETF	61.83	61.93	61.71	61.816	4176348.0
2012-02-06 11:00:00	QQQ	ETF	61.812	61.92	61.78	61.9	2848076.0
2012-02-06 12:00:00	QQQ	ETF	61.9001	62.0	61.82	61.97	4192446.0
2012-02-06 13:00:00	QQQ	ETF	61.97	62.0	61.885	61.92	3181967.0
2012-02-06 14:00:00	QQQ	ETF	61.93	61.995	61.9	61.9	2732237.0
2012-02-06 15:00:00	QQQ	ETF	61.9	62.02	61.9	62.01	5614734.0
2012-02-06 16:00:00	QQQ	ETF	62.01	62.075	61.97	62.06	1277106.0
2012-02-06 17:00:00	QQQ	ETF	62.06	62.08	62.06	62.06	5843.0
2012-02-06 18:00:00	QQQ	ETF	62.06	62.07	62.05	62.05	2715.0
2012-02-06 19:00:00	QQQ	ETF	62.05	62.08	62.04	62.08	11134.0
2012-02-06 04:00:00	IWM	ETF	82.35	82.35	82.35	82.35	500.0
2012-02-06 06:00:00	IWM	ETF	82.25	82.25	82.25	82.25	290.0
2012-02-06 07:00:00	IWM	ETF	82.45	82.49	82.41	82.44	16900.0
2012-02-06 08:00:00	IWM	ETF	82.46	82.53	82.27	82.38	190510.0
2012-02-06 09:00:00	IWM	ETF	82.36	82.86	82.36	82.76	4947397.0
2012-02-06 10:00:00	IWM	ETF	82.76	82.93	82.37	82.52	5308739.0
2012-02-06 11:00:00	IWM	ETF	82.52	82.76	82.4705	82.74	2516392.0
2012-02-06 12:00:00	IWM	ETF	82.749	82.89	82.65	82.83	2160102.0
2012-02-06 13:00:00	IWM	ETF	82.84	82.85	82.5	82.5737	3035284.0
2012-02-06 14:00:00	IWM	ETF	82.57	82.66	82.471	82.499	2520596.0
2012-02-06 15:00:00	IWM	ETF	82.5	82.74	82.5	82.7	4033731.0
2012-02-06 16:00:00	IWM	ETF	82.69	82.69	82.4946	82.63	3755489.0
2012-02-06 17:00:00	IWM	ETF	82.63	82.63	82.57	82.57	2234.0
2012-02-06 18:00:00	IWM	ETF	82.61	82.62	82.61	82.62	1600.0
2012-02-06 19:00:00	IWM	ETF	82.59	82.63	82.59	82.63	4000.0
2012-02-06 04:00:00	DIA	ETF	127.6	127.6	127.6	127.6	100.0
2012-02-06 06:00:00	DIA	ETF	127.8	127.8	127.63	127.63	1600.0
2012-02-06 07:00:00	DIA	ETF	127.8	128.0	127.8	127.91	4672.0
2012-02-06 08:00:00	DIA	ETF	127.96	127.96	127.7	127.7	8000.0

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

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