PREVIEW / etf_1hour / 2011-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-15.parquet
  size:    184 KB
  rows:    5,625

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
2011-06-15 04:00:00	SPY	ETF	129.17	129.17	128.84	128.84	8660.0
2011-06-15 05:00:00	SPY	ETF	128.9	128.97	128.84	128.95	34666.0
2011-06-15 06:00:00	SPY	ETF	128.97	129.07	128.84	128.89	89002.0
2011-06-15 07:00:00	SPY	ETF	128.89	129.01	128.84	128.84	257758.0
2011-06-15 08:00:00	SPY	ETF	128.83	129.23	128.17	128.23	5239567.0
2011-06-15 09:00:00	SPY	ETF	128.23	128.58	128.0	128.45	29696646.0
2011-06-15 10:00:00	SPY	ETF	128.46	128.65	128.16	128.48	24767735.0
2011-06-15 11:00:00	SPY	ETF	128.48	128.56	127.37	127.61	39229117.0
2011-06-15 12:00:00	SPY	ETF	127.61	127.68	126.81	127.17	39113688.0
2011-06-15 13:00:00	SPY	ETF	127.18	129.2991	126.86	127.11	27536489.0
2011-06-15 14:00:00	SPY	ETF	127.09	127.45	126.8	126.9789	38196755.0
2011-06-15 15:00:00	SPY	ETF	126.97	129.2962	126.68	127.03	69169512.0
2011-06-15 16:00:00	SPY	ETF	127.03	129.2962	126.99	127.08	16926194.0
2011-06-15 17:00:00	SPY	ETF	127.08	127.18	127.08	127.16	3329699.0
2011-06-15 18:00:00	SPY	ETF	127.13	127.3	127.02	127.3	395027.0
2011-06-15 19:00:00	SPY	ETF	127.3	127.36	127.04	127.15	185729.0
2011-06-15 04:00:00	QQQ	ETF	55.07	55.09	55.07	55.09	300.0
2011-06-15 05:00:00	QQQ	ETF	55.02	55.12	55.02	55.12	15400.0
2011-06-15 06:00:00	QQQ	ETF	55.08	55.11	55.08	55.11	1000.0
2011-06-15 07:00:00	QQQ	ETF	55.08	55.1	55.04	55.04	41800.0
2011-06-15 08:00:00	QQQ	ETF	55.06	55.07	54.76	54.78	395189.0
2011-06-15 09:00:00	QQQ	ETF	54.77	55.03	54.73	55.015	4357040.0
2011-06-15 10:00:00	QQQ	ETF	55.0	55.15	54.87	54.9201	4357309.0
2011-06-15 11:00:00	QQQ	ETF	54.93	54.96	54.54	54.59	8063552.0
2011-06-15 12:00:00	QQQ	ETF	54.595	54.65	54.34	54.4	8440968.0
2011-06-15 13:00:00	QQQ	ETF	54.41	54.48	54.32	54.41	6204188.0
2011-06-15 14:00:00	QQQ	ETF	54.41	54.52	54.29	54.32	7834425.0
2011-06-15 15:00:00	QQQ	ETF	54.31	54.4	54.18	54.3	11383940.0
2011-06-15 16:00:00	QQQ	ETF	54.31	54.4157	54.28	54.33	2559396.0
2011-06-15 17:00:00	QQQ	ETF	54.33	54.37	54.3133	54.34	12940.0
2011-06-15 18:00:00	QQQ	ETF	54.34	54.42	54.29	54.4	263591.0
2011-06-15 19:00:00	QQQ	ETF	54.38	54.41	54.33	54.41	15762.0
2011-06-15 04:00:00	IWM	ETF	79.39	79.39	79.32	79.32	776.0
2011-06-15 05:00:00	IWM	ETF	79.21	79.21	79.21	79.21	3000.0
2011-06-15 06:00:00	IWM	ETF	79.22	79.3	79.15	79.27	3500.0
2011-06-15 07:00:00	IWM	ETF	79.26	79.27	79.12	79.12	19896.0
2011-06-15 08:00:00	IWM	ETF	79.15	79.17	78.68	78.69	1044671.0
2011-06-15 09:00:00	IWM	ETF	78.68	79.03	78.32	78.9	8383045.0
2011-06-15 10:00:00	IWM	ETF	78.9	79.21	78.85	79.11	8875230.0
2011-06-15 11:00:00	IWM	ETF	79.11	79.175	78.36	78.495	10000005.0
2011-06-15 12:00:00	IWM	ETF	78.49	78.58	78.03	78.17	10843668.0
2011-06-15 13:00:00	IWM	ETF	78.175	78.31	77.96	78.19	8699933.0
2011-06-15 14:00:00	IWM	ETF	78.19	78.47	77.9	77.92	11070244.0
2011-06-15 15:00:00	IWM	ETF	77.92	78.23	77.72	78.04	16036591.0
2011-06-15 16:00:00	IWM	ETF	78.04	79.4426	77.99	78.04	4849888.0
2011-06-15 17:00:00	IWM	ETF	79.4426	79.4426	77.98	78.05	1607535.0
2011-06-15 18:00:00	IWM	ETF	78.05	78.14	78.05	78.13	33672.0
2011-06-15 19:00:00	IWM	ETF	78.13	78.2	78.05	78.12	12490.0
2011-06-15 04:00:00	DIA	ETF	120.44	120.44	120.44	120.44	341.0
2011-06-15 05:00:00	DIA	ETF	120.32	120.32	120.32	120.32	108.0

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

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