PREVIEW / etf_1hour / 2011-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-11.parquet
  size:    182 KB
  rows:    5,527

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-04-11 04:00:00	SPY	ETF	133.5	133.5	132.88	132.9	30500.0
2011-04-11 05:00:00	SPY	ETF	132.96	133.01	132.93	132.93	8600.0
2011-04-11 06:00:00	SPY	ETF	132.92	133.28	132.91	133.23	22450.0
2011-04-11 07:00:00	SPY	ETF	133.2	133.21	133.0	133.03	546832.0
2011-04-11 08:00:00	SPY	ETF	133.01	133.3	132.82	133.07	972750.0
2011-04-11 09:00:00	SPY	ETF	133.07	133.45	132.97	133.27	16794743.0
2011-04-11 10:00:00	SPY	ETF	133.27	133.36	132.9	133.19	19700186.0
2011-04-11 11:00:00	SPY	ETF	133.195	133.32	132.97	132.98	10984499.0
2011-04-11 12:00:00	SPY	ETF	132.98	133.03	132.55	132.55	12764116.0
2011-04-11 13:00:00	SPY	ETF	132.5526	132.72	132.48	132.709	11871703.0
2011-04-11 14:00:00	SPY	ETF	132.71	132.83	132.355	132.39	12929614.0
2011-04-11 15:00:00	SPY	ETF	132.395	132.52	132.14	132.47	26137241.0
2011-04-11 16:00:00	SPY	ETF	132.46	133.3104	132.23	132.3	7680081.0
2011-04-11 17:00:00	SPY	ETF	132.29	132.33	132.1	132.18	718987.0
2011-04-11 18:00:00	SPY	ETF	132.17	132.49	132.14	132.17	103007.0
2011-04-11 19:00:00	SPY	ETF	132.16	132.17	132.05	132.15	79886.0
2011-04-11 04:00:00	QQQ	ETF	57.12	57.15	57.02	57.08	3829.0
2011-04-11 06:00:00	QQQ	ETF	57.04	57.16	57.04	57.16	17100.0
2011-04-11 07:00:00	QQQ	ETF	57.17	57.18	57.12	57.12	28545.0
2011-04-11 08:00:00	QQQ	ETF	57.12	57.19	57.04	57.17	267239.0
2011-04-11 09:00:00	QQQ	ETF	57.16	57.29	57.0	57.01	7102050.0
2011-04-11 10:00:00	QQQ	ETF	57.01	57.07	56.77	56.98	9862339.0
2011-04-11 11:00:00	QQQ	ETF	56.98	57.07	56.77	56.78	3698941.0
2011-04-11 12:00:00	QQQ	ETF	56.77	56.84	56.67	56.68	4239625.0
2011-04-11 13:00:00	QQQ	ETF	56.679	56.81	56.61	56.7862	3782348.0
2011-04-11 14:00:00	QQQ	ETF	56.79	56.85	56.63	56.66	3113386.0
2011-04-11 15:00:00	QQQ	ETF	56.66	56.78	56.56	56.77	6244458.0
2011-04-11 16:00:00	QQQ	ETF	56.76	56.8311	56.63	56.66	2092326.0
2011-04-11 17:00:00	QQQ	ETF	56.65	56.67	56.61	56.63	57413.0
2011-04-11 18:00:00	QQQ	ETF	56.64	56.8	56.63	56.63	38442.0
2011-04-11 19:00:00	QQQ	ETF	56.61	56.63	56.59	56.62	10318.0
2011-04-11 04:00:00	IWM	ETF	84.01	85.11	83.86	83.92	26297.0
2011-04-11 05:00:00	IWM	ETF	83.93	83.93	83.84	83.88	5199.0
2011-04-11 06:00:00	IWM	ETF	83.82	84.12	83.82	84.08	28700.0
2011-04-11 07:00:00	IWM	ETF	84.09	84.09	83.89	83.89	35150.0
2011-04-11 08:00:00	IWM	ETF	84.18	84.18	83.77	83.98	222962.0
2011-04-11 09:00:00	IWM	ETF	83.99	84.28	83.91	83.97	7153620.0
2011-04-11 10:00:00	IWM	ETF	83.97	84.08	83.615	83.945	5967716.0
2011-04-11 11:00:00	IWM	ETF	83.96	84.14	83.64	83.6501	4321735.0
2011-04-11 12:00:00	IWM	ETF	83.66	83.75	83.39	83.39	4088329.0
2011-04-11 13:00:00	IWM	ETF	83.38	83.53	83.29	83.46	3091687.0
2011-04-11 14:00:00	IWM	ETF	83.47	83.56	83.22	83.25	2544676.0
2011-04-11 15:00:00	IWM	ETF	83.25	83.31	82.9	83.22	8932897.0
2011-04-11 16:00:00	IWM	ETF	83.21	83.26	83.12	83.15	1067466.0
2011-04-11 17:00:00	IWM	ETF	83.18	83.18	83.08	83.08	5880.0
2011-04-11 18:00:00	IWM	ETF	83.06	83.06	83.04	83.04	2227.0
2011-04-11 19:00:00	IWM	ETF	82.96	82.96	82.95	82.95	1100.0
2011-04-11 06:00:00	DIA	ETF	123.85	123.94	123.85	123.94	1298.0
2011-04-11 07:00:00	DIA	ETF	123.95	123.95	123.86	123.86	500.0
2011-04-11 08:00:00	DIA	ETF	123.83	123.84	123.67	123.84	3441.0

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

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