PREVIEW / etf_1hour / 2012-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-02.parquet
  size:    181 KB
  rows:    5,642

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-03-02 04:00:00	SPY	ETF	137.69	137.75	137.6	137.64	24730.0
2012-03-02 05:00:00	SPY	ETF	137.62	137.71	137.58	137.65	121076.0
2012-03-02 06:00:00	SPY	ETF	137.65	137.75	137.6	137.65	31425.0
2012-03-02 07:00:00	SPY	ETF	137.65	137.65	137.32	137.47	307185.0
2012-03-02 08:00:00	SPY	ETF	137.47	137.64	137.37	137.61	804871.0
2012-03-02 09:00:00	SPY	ETF	137.62	137.74	137.41	137.47	10748955.0
2012-03-02 10:00:00	SPY	ETF	137.47	137.82	137.4	137.55	15666226.0
2012-03-02 11:00:00	SPY	ETF	137.55	137.6	137.22	137.325	19243862.0
2012-03-02 12:00:00	SPY	ETF	137.325	137.385	137.13	137.29	12828752.0
2012-03-02 13:00:00	SPY	ETF	137.28	137.35	137.0	137.28	12427680.0
2012-03-02 14:00:00	SPY	ETF	137.275	137.39	137.22	137.385	10406638.0
2012-03-02 15:00:00	SPY	ETF	137.385	137.59	137.25	137.32	24520529.0
2012-03-02 16:00:00	SPY	ETF	137.32	137.7749	137.1	137.38	11375588.0
2012-03-02 17:00:00	SPY	ETF	137.38	137.4	137.3	137.36	56589.0
2012-03-02 18:00:00	SPY	ETF	137.35	137.47	137.35	137.41	68640.0
2012-03-02 19:00:00	SPY	ETF	137.39	137.41	137.37	137.37	32918.0
2012-03-02 06:00:00	QQQ	ETF	64.87	64.87	64.86	64.86	400.0
2012-03-02 07:00:00	QQQ	ETF	64.82	64.82	64.67	64.75	84350.0
2012-03-02 08:00:00	QQQ	ETF	64.75	64.81	64.71	64.8	139578.0
2012-03-02 09:00:00	QQQ	ETF	64.8	64.96	64.77	64.89	3611428.0
2012-03-02 10:00:00	QQQ	ETF	64.89	65.07	64.87	64.94	6615180.0
2012-03-02 11:00:00	QQQ	ETF	64.95	65.0784	64.77	64.84	5602385.0
2012-03-02 12:00:00	QQQ	ETF	64.85	64.87	64.7	64.8005	5103861.0
2012-03-02 13:00:00	QQQ	ETF	64.8	64.85	64.66	64.84	2932578.0
2012-03-02 14:00:00	QQQ	ETF	64.83	64.9	64.81	64.862	2136918.0
2012-03-02 15:00:00	QQQ	ETF	64.87	64.96	64.8	64.85	5742747.0
2012-03-02 16:00:00	QQQ	ETF	64.86	64.97	64.85	64.93	1191849.0
2012-03-02 17:00:00	QQQ	ETF	64.92	64.94	64.91	64.91	43255.0
2012-03-02 18:00:00	QQQ	ETF	64.91	64.96	64.91	64.95	35034.0
2012-03-02 19:00:00	QQQ	ETF	64.95	64.97	64.92	64.95	25622.0
2012-03-02 04:00:00	IWM	ETF	81.42	81.43	81.42	81.42	1308.0
2012-03-02 06:00:00	IWM	ETF	81.38	81.39	81.38	81.39	800.0
2012-03-02 07:00:00	IWM	ETF	81.32	81.32	81.09	81.18	41331.0
2012-03-02 08:00:00	IWM	ETF	81.19	81.44	81.17	81.44	215072.0
2012-03-02 09:00:00	IWM	ETF	81.43	81.53	81.12	81.22	4101342.0
2012-03-02 10:00:00	IWM	ETF	81.21	81.64	81.15	81.38	5547366.0
2012-03-02 11:00:00	IWM	ETF	81.39	81.44	80.68	80.75	10024440.0
2012-03-02 12:00:00	IWM	ETF	80.76	81.451	80.28	80.41	8675934.0
2012-03-02 13:00:00	IWM	ETF	80.4	80.47	79.84	80.3	9625973.0
2012-03-02 14:00:00	IWM	ETF	80.3	80.44	80.17	80.41	5152730.0
2012-03-02 15:00:00	IWM	ETF	80.41	80.52	80.09	80.24	12699287.0
2012-03-02 16:00:00	IWM	ETF	80.24	81.4508	80.1	80.2	2978793.0
2012-03-02 17:00:00	IWM	ETF	80.2	80.2	80.13	80.15	4225.0
2012-03-02 18:00:00	IWM	ETF	80.17	80.24	80.17	80.22	2928.0
2012-03-02 19:00:00	IWM	ETF	80.16	80.16	80.16	80.16	400.0
2012-03-02 07:00:00	DIA	ETF	129.5	129.5	129.29	129.29	13372.0
2012-03-02 08:00:00	DIA	ETF	129.33	129.5	129.32	129.5	3300.0
2012-03-02 09:00:00	DIA	ETF	129.5	129.59	129.23	129.31	316636.0
2012-03-02 10:00:00	DIA	ETF	129.3	129.64	129.26	129.5	605586.0
2012-03-02 11:00:00	DIA	ETF	129.51	129.53	129.24	129.34	535339.0

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

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