PREVIEW / etf_1hour / 2013-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-22.parquet
  size:    198 KB
  rows:    6,167

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
2013-02-22 04:00:00	SPY	ETF	151.04	151.15	150.97	150.98	109464.0
2013-02-22 05:00:00	SPY	ETF	150.96	151.07	150.89	151.07	49100.0
2013-02-22 06:00:00	SPY	ETF	151.05	151.26	150.95	151.19	1004523.0
2013-02-22 07:00:00	SPY	ETF	151.19	151.37	151.19	151.31	419418.0
2013-02-22 08:00:00	SPY	ETF	151.3	151.38	151.19	151.27	707860.0
2013-02-22 09:00:00	SPY	ETF	151.27	151.37	150.88	151.02	16232442.0
2013-02-22 10:00:00	SPY	ETF	151.0	151.19	150.82	150.952	13405854.0
2013-02-22 11:00:00	SPY	ETF	150.95	151.29	150.761	151.225	9618178.0
2013-02-22 12:00:00	SPY	ETF	151.22	151.62	151.14	151.54	9292557.0
2013-02-22 13:00:00	SPY	ETF	151.55	151.62	151.36	151.52	8802916.0
2013-02-22 14:00:00	SPY	ETF	151.52	151.52	151.3	151.42	7972662.0
2013-02-22 15:00:00	SPY	ETF	151.43	151.84	151.41	151.84	22090170.0
2013-02-22 16:00:00	SPY	ETF	151.84	151.92	151.2376	151.77	9324494.0
2013-02-22 17:00:00	SPY	ETF	151.77	151.93	151.75	151.92	284049.0
2013-02-22 18:00:00	SPY	ETF	151.89	151.95	151.89	151.9	84089.0
2013-02-22 19:00:00	SPY	ETF	151.89	151.93	151.85	151.9	32992.0
2013-02-22 04:00:00	QQQ	ETF	66.8	66.8	66.78	66.78	300.0
2013-02-22 05:00:00	QQQ	ETF	66.75	66.77	66.75	66.77	300.0
2013-02-22 06:00:00	QQQ	ETF	66.75	66.83	66.75	66.83	14400.0
2013-02-22 07:00:00	QQQ	ETF	66.82	66.91	66.82	66.89	136907.0
2013-02-22 08:00:00	QQQ	ETF	66.85	66.96	66.84	66.93	155487.0
2013-02-22 09:00:00	QQQ	ETF	66.93	66.96	66.59	66.75	4629257.0
2013-02-22 10:00:00	QQQ	ETF	66.75	66.85	66.68	66.73	2834057.0
2013-02-22 11:00:00	QQQ	ETF	66.72	66.8906	66.63	66.84	2253318.0
2013-02-22 12:00:00	QQQ	ETF	66.84	67.06	66.81	67.03	2486669.0
2013-02-22 13:00:00	QQQ	ETF	67.03	67.06	66.94	67.0245	1560379.0
2013-02-22 14:00:00	QQQ	ETF	67.02	67.02	66.92	66.98	1278148.0
2013-02-22 15:00:00	QQQ	ETF	66.98	67.15	66.97	67.13	4579978.0
2013-02-22 16:00:00	QQQ	ETF	67.12	67.19	66.9141	67.12	1521013.0
2013-02-22 17:00:00	QQQ	ETF	67.12	67.12	67.11	67.11	1150.0
2013-02-22 18:00:00	QQQ	ETF	67.15	67.15	67.15	67.15	600.0
2013-02-22 19:00:00	QQQ	ETF	67.13	67.15	67.13	67.15	1600.0
2013-02-22 06:00:00	IWM	ETF	90.29	90.29	90.21	90.21	5200.0
2013-02-22 07:00:00	IWM	ETF	90.21	90.36	90.21	90.35	113524.0
2013-02-22 08:00:00	IWM	ETF	90.34	90.43	89.95	90.4	253382.0
2013-02-22 09:00:00	IWM	ETF	90.39	90.685	90.31	90.44	4184443.0
2013-02-22 10:00:00	IWM	ETF	90.46	90.71	90.3799	90.54	4439531.0
2013-02-22 11:00:00	IWM	ETF	90.55	90.77	90.44	90.72	3358735.0
2013-02-22 12:00:00	IWM	ETF	90.71	90.89	90.65	90.85	1967918.0
2013-02-22 13:00:00	IWM	ETF	90.85	90.88	90.68	90.78	1471300.0
2013-02-22 14:00:00	IWM	ETF	90.78	90.785	90.6	90.68	1512552.0
2013-02-22 15:00:00	IWM	ETF	90.69	91.0	90.64	90.98	4793756.0
2013-02-22 16:00:00	IWM	ETF	90.98	91.06	90.83	91.01	2290844.0
2013-02-22 17:00:00	IWM	ETF	90.98	91.02	90.97	90.98	71121.0
2013-02-22 18:00:00	IWM	ETF	90.98	90.98	90.97	90.98	4700.0
2013-02-22 19:00:00	IWM	ETF	90.96	90.98	90.96	90.96	3296.0
2013-02-22 06:00:00	DIA	ETF	139.05	139.05	139.0	139.05	1500.0
2013-02-22 07:00:00	DIA	ETF	139.11	139.35	139.11	139.32	4160.0
2013-02-22 08:00:00	DIA	ETF	139.27	139.48	139.27	139.39	14260.0
2013-02-22 09:00:00	DIA	ETF	139.29	139.32	138.88	138.96	785421.0

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

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