PREVIEW / etf_1hour / 2013-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-02-08.parquet
  size:    190 KB
  rows:    6,007

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-08 04:00:00	SPY	ETF	151.16	151.16	151.16	151.16	201.0
2013-02-08 05:00:00	SPY	ETF	150.9	151.04	150.88	151.04	52800.0
2013-02-08 06:00:00	SPY	ETF	150.94	151.06	150.93	151.06	52558.0
2013-02-08 07:00:00	SPY	ETF	151.05	151.11	150.92	150.94	117337.0
2013-02-08 08:00:00	SPY	ETF	151.05	151.16	150.82	151.16	555404.0
2013-02-08 09:00:00	SPY	ETF	151.16	151.84	151.11	151.75	18254091.0
2013-02-08 10:00:00	SPY	ETF	151.74	151.89	151.64	151.76	14764290.0
2013-02-08 11:00:00	SPY	ETF	151.76	151.8	151.54	151.74	9878694.0
2013-02-08 12:00:00	SPY	ETF	151.75	151.8	151.56	151.68	7284422.0
2013-02-08 13:00:00	SPY	ETF	151.67	151.78	151.6101	151.73	5082367.0
2013-02-08 14:00:00	SPY	ETF	151.74	151.83	151.7	151.7365	6671793.0
2013-02-08 15:00:00	SPY	ETF	151.74	151.79	151.52	151.78	21074332.0
2013-02-08 16:00:00	SPY	ETF	151.77	151.8401	150.9864	151.78	11503619.0
2013-02-08 17:00:00	SPY	ETF	151.78	151.82	151.71	151.71	3129024.0
2013-02-08 18:00:00	SPY	ETF	151.75	151.8	151.75	151.78	18112.0
2013-02-08 19:00:00	SPY	ETF	151.78	151.78	151.7	151.75	10750.0
2013-02-08 05:00:00	QQQ	ETF	67.32	67.34	67.32	67.34	5100.0
2013-02-08 06:00:00	QQQ	ETF	67.35	67.36	67.35	67.36	6000.0
2013-02-08 07:00:00	QQQ	ETF	67.34	67.39	67.34	67.36	18501.0
2013-02-08 08:00:00	QQQ	ETF	67.35	67.53	67.33	67.5	490236.0
2013-02-08 09:00:00	QQQ	ETF	67.5	68.088	67.5	68.05	6543183.0
2013-02-08 10:00:00	QQQ	ETF	68.05	68.13	67.97	68.1	6138777.0
2013-02-08 11:00:00	QQQ	ETF	68.091	68.13	68.0	68.06	3484312.0
2013-02-08 12:00:00	QQQ	ETF	68.06	68.09	67.95	68.03	2318387.0
2013-02-08 13:00:00	QQQ	ETF	68.035	68.13	68.019	68.075	1941500.0
2013-02-08 14:00:00	QQQ	ETF	68.07	68.125	67.97	68.012	2601577.0
2013-02-08 15:00:00	QQQ	ETF	68.02	68.065	67.94	67.99	3918703.0
2013-02-08 16:00:00	QQQ	ETF	67.99	68.03	67.3053	68.01	3941585.0
2013-02-08 17:00:00	QQQ	ETF	68.0	68.01	67.3053	67.97	4525434.0
2013-02-08 18:00:00	QQQ	ETF	67.97	67.99	67.97	67.99	926.0
2013-02-08 19:00:00	QQQ	ETF	67.99	68.07	67.99	68.05	8573.0
2013-02-08 07:00:00	IWM	ETF	90.15	90.15	90.1	90.1	6600.0
2013-02-08 08:00:00	IWM	ETF	90.11	90.3	90.07	90.3	636975.0
2013-02-08 09:00:00	IWM	ETF	90.3	90.68	90.24	90.56	3100701.0
2013-02-08 10:00:00	IWM	ETF	90.56	90.63	90.49	90.54	2842413.0
2013-02-08 11:00:00	IWM	ETF	90.54	90.8301	90.42	90.8	3429654.0
2013-02-08 12:00:00	IWM	ETF	90.79	90.86	90.67	90.77	2748766.0
2013-02-08 13:00:00	IWM	ETF	90.77	90.84	90.7	90.75	981155.0
2013-02-08 14:00:00	IWM	ETF	90.75	90.78	90.64	90.7	961868.0
2013-02-08 15:00:00	IWM	ETF	90.7	90.81	90.63	90.77	4341140.0
2013-02-08 16:00:00	IWM	ETF	90.78	90.81	90.55	90.78	1355258.0
2013-02-08 17:00:00	IWM	ETF	90.78	90.81	90.78	90.81	13106.0
2013-02-08 04:00:00	DIA	ETF	139.43	139.44	139.43	139.44	200.0
2013-02-08 06:00:00	DIA	ETF	139.27	139.27	139.27	139.27	100.0
2013-02-08 07:00:00	DIA	ETF	139.3	139.32	139.23	139.23	1880.0
2013-02-08 08:00:00	DIA	ETF	139.21	139.35	139.16	139.35	3800.0
2013-02-08 09:00:00	DIA	ETF	139.36	140.02	139.36	139.94	736650.0
2013-02-08 10:00:00	DIA	ETF	139.92	140.031	139.82	139.82	753991.0
2013-02-08 11:00:00	DIA	ETF	139.8399	139.86	139.57	139.73	443512.0
2013-02-08 12:00:00	DIA	ETF	139.7499	139.82	139.66	139.71	253768.0

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

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