PREVIEW / etf_1hour / 2013-03-04

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-03-04.parquet
  size:    200 KB
  rows:    6,251

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-03-04 04:00:00	SPY	ETF	151.53	151.69	151.53	151.6	84920.0
2013-03-04 05:00:00	SPY	ETF	151.59	151.69	151.49	151.56	14698.0
2013-03-04 06:00:00	SPY	ETF	151.54	151.63	151.36	151.6	28979.0
2013-03-04 07:00:00	SPY	ETF	151.63	152.08	151.53	151.92	665010.0
2013-03-04 08:00:00	SPY	ETF	151.6	152.01	151.46	151.85	958086.0
2013-03-04 09:00:00	SPY	ETF	151.84	152.09	151.44	151.91	11992332.0
2013-03-04 10:00:00	SPY	ETF	151.92	152.13	151.68	152.01	12929683.0
2013-03-04 11:00:00	SPY	ETF	152.0	152.23	151.84	152.13	9403150.0
2013-03-04 12:00:00	SPY	ETF	152.13	152.16	151.52	151.85	10034854.0
2013-03-04 13:00:00	SPY	ETF	151.84	152.29	151.67	152.24	11165762.0
2013-03-04 14:00:00	SPY	ETF	152.24	152.78	152.11	152.71	12555015.0
2013-03-04 15:00:00	SPY	ETF	152.72	152.87	152.52	152.87	15638277.0
2013-03-04 16:00:00	SPY	ETF	152.86	153.12	152.135	153.11	8343950.0
2013-03-04 17:00:00	SPY	ETF	153.115	153.17	153.07	153.12	352819.0
2013-03-04 18:00:00	SPY	ETF	153.13	153.13	153.07	153.09	47942.0
2013-03-04 19:00:00	SPY	ETF	153.09	153.14	153.03	153.09	78028.0
2013-03-04 04:00:00	QQQ	ETF	67.22	67.22	67.22	67.22	400.0
2013-03-04 05:00:00	QQQ	ETF	67.25	67.26	67.22	67.22	3500.0
2013-03-04 06:00:00	QQQ	ETF	67.19	67.19	67.09	67.11	7100.0
2013-03-04 07:00:00	QQQ	ETF	67.11	67.34	67.11	67.27	35672.0
2013-03-04 08:00:00	QQQ	ETF	67.28	67.3	67.22	67.23	71587.0
2013-03-04 09:00:00	QQQ	ETF	67.22	67.37	67.11	67.21	2885467.0
2013-03-04 10:00:00	QQQ	ETF	67.21	67.36	67.07	67.3199	2629280.0
2013-03-04 11:00:00	QQQ	ETF	67.32	67.45	67.21	67.38	2140244.0
2013-03-04 12:00:00	QQQ	ETF	67.39	67.391	67.07	67.23	1926518.0
2013-03-04 13:00:00	QQQ	ETF	67.22	67.49	67.15	67.44	1802063.0
2013-03-04 14:00:00	QQQ	ETF	67.45	67.68	67.37	67.659	2622646.0
2013-03-04 15:00:00	QQQ	ETF	67.6599	67.69	67.55	67.66	4181321.0
2013-03-04 16:00:00	QQQ	ETF	67.67	67.81	67.376	67.79	863775.0
2013-03-04 17:00:00	QQQ	ETF	67.79	67.8	67.75	67.78	17036.0
2013-03-04 18:00:00	QQQ	ETF	67.81	67.81	67.76	67.81	2982.0
2013-03-04 19:00:00	QQQ	ETF	67.82	67.83	67.79	67.79	13336.0
2013-03-04 06:00:00	IWM	ETF	90.53	90.53	90.53	90.53	299.0
2013-03-04 07:00:00	IWM	ETF	90.6	90.88	90.6	90.81	133999.0
2013-03-04 08:00:00	IWM	ETF	90.82	90.85	90.67	90.71	310697.0
2013-03-04 09:00:00	IWM	ETF	90.68	90.97	90.58	90.85	3082083.0
2013-03-04 10:00:00	IWM	ETF	90.86	90.99	90.62	90.84	4015452.0
2013-03-04 11:00:00	IWM	ETF	90.85	90.96	90.715	90.861	2650602.0
2013-03-04 12:00:00	IWM	ETF	90.87	90.88	90.2	90.4799	3659167.0
2013-03-04 13:00:00	IWM	ETF	90.47	90.88	90.3775	90.82	2305345.0
2013-03-04 14:00:00	IWM	ETF	90.82	91.17	90.66	91.14	3860496.0
2013-03-04 15:00:00	IWM	ETF	91.14	91.16	90.9	91.13	4131134.0
2013-03-04 16:00:00	IWM	ETF	91.13	91.26	91.09	91.23	935144.0
2013-03-04 17:00:00	IWM	ETF	91.25	91.26	91.2	91.24	4725.0
2013-03-04 18:00:00	IWM	ETF	91.21	91.23	91.21	91.23	500.0
2013-03-04 19:00:00	IWM	ETF	91.23	91.23	91.23	91.23	100.0
2013-03-04 04:00:00	DIA	ETF	140.3	140.42	140.3	140.42	500.0
2013-03-04 05:00:00	DIA	ETF	140.32	140.32	140.32	140.32	100.0
2013-03-04 07:00:00	DIA	ETF	140.54	140.54	140.52	140.52	2100.0
2013-03-04 08:00:00	DIA	ETF	140.51	140.54	140.45	140.46	3100.0

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

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