PREVIEW / etf_1hour / 2012-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-19.parquet
  size:    187 KB
  rows:    5,751

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-19 04:00:00	SPY	ETF	140.5	140.5	139.85	139.92	86140.0
2012-03-19 05:00:00	SPY	ETF	140.04	140.09	140.03	140.09	15980.0
2012-03-19 06:00:00	SPY	ETF	140.01	140.12	139.96	140.07	17480.0
2012-03-19 07:00:00	SPY	ETF	140.09	140.21	140.02	140.13	184851.0
2012-03-19 08:00:00	SPY	ETF	140.15	140.3	139.94	140.03	2360492.0
2012-03-19 09:00:00	SPY	ETF	140.03	140.62	140.0	140.55	15878762.0
2012-03-19 10:00:00	SPY	ETF	140.55	140.62	140.3	140.5798	15618863.0
2012-03-19 11:00:00	SPY	ETF	140.58	140.86	140.4	140.84	18888369.0
2012-03-19 12:00:00	SPY	ETF	140.84	141.12	140.83	141.04	14305002.0
2012-03-19 13:00:00	SPY	ETF	141.04	141.28	141.01	141.201	12759021.0
2012-03-19 14:00:00	SPY	ETF	141.2	141.25	141.03	141.0691	11169532.0
2012-03-19 15:00:00	SPY	ETF	141.06	141.13	140.76	140.85	22326269.0
2012-03-19 16:00:00	SPY	ETF	140.85	141.18	140.28	140.93	8862687.0
2012-03-19 17:00:00	SPY	ETF	140.93	140.96	140.89	140.92	56391.0
2012-03-19 18:00:00	SPY	ETF	140.91	140.91	140.86	140.87	33137.0
2012-03-19 19:00:00	SPY	ETF	140.87	140.88	140.81	140.88	48859.0
2012-03-19 04:00:00	QQQ	ETF	66.5	66.5	66.5	66.5	300.0
2012-03-19 05:00:00	QQQ	ETF	66.52	66.52	66.52	66.52	4000.0
2012-03-19 06:00:00	QQQ	ETF	66.5	66.54	66.5	66.54	3500.0
2012-03-19 07:00:00	QQQ	ETF	66.58	66.73	66.58	66.62	249227.0
2012-03-19 08:00:00	QQQ	ETF	66.64	66.74	66.29	66.44	4138280.0
2012-03-19 09:00:00	QQQ	ETF	66.43	66.73	66.39	66.69	7365556.0
2012-03-19 10:00:00	QQQ	ETF	66.69	66.7	66.47	66.67	5860088.0
2012-03-19 11:00:00	QQQ	ETF	66.66	66.88	66.59	66.88	6158650.0
2012-03-19 12:00:00	QQQ	ETF	66.88	67.07	66.8771	66.99	5596550.0
2012-03-19 13:00:00	QQQ	ETF	66.9979	67.13	66.98	67.09	4323347.0
2012-03-19 14:00:00	QQQ	ETF	67.09	67.15	67.06	67.1	3221694.0
2012-03-19 15:00:00	QQQ	ETF	67.1	67.14	66.94	66.99	9671279.0
2012-03-19 16:00:00	QQQ	ETF	66.99	67.0901	66.5109	67.05	2508397.0
2012-03-19 17:00:00	QQQ	ETF	67.05	67.07	67.01	67.07	15228.0
2012-03-19 18:00:00	QQQ	ETF	67.03	67.03	66.99	66.99	33392.0
2012-03-19 19:00:00	QQQ	ETF	66.99	67.0	66.98	67.0	15000.0
2012-03-19 04:00:00	IWM	ETF	82.68	82.68	82.68	82.68	500.0
2012-03-19 07:00:00	IWM	ETF	82.75	82.87	82.7	82.77	56748.0
2012-03-19 08:00:00	IWM	ETF	82.78	82.84	82.61	82.7	186512.0
2012-03-19 09:00:00	IWM	ETF	82.69	83.74	82.67	83.67	8476749.0
2012-03-19 10:00:00	IWM	ETF	83.67	83.7	83.03	83.55	7972946.0
2012-03-19 11:00:00	IWM	ETF	83.55	83.89	83.3732	83.79	6694420.0
2012-03-19 12:00:00	IWM	ETF	83.7899	84.11	83.78	84.0481	5889779.0
2012-03-19 13:00:00	IWM	ETF	84.05	84.39	84.02	84.3	7095404.0
2012-03-19 14:00:00	IWM	ETF	84.31	84.38	84.13	84.16	4339554.0
2012-03-19 15:00:00	IWM	ETF	84.17	84.25	83.62	83.72	11418665.0
2012-03-19 16:00:00	IWM	ETF	83.72	84.21	82.82	83.72	7320140.0
2012-03-19 17:00:00	IWM	ETF	83.74	83.74	83.72	83.72	12100.0
2012-03-19 18:00:00	IWM	ETF	83.71	83.71	83.71	83.71	900.0
2012-03-19 19:00:00	IWM	ETF	83.7	83.71	83.68	83.68	4881.0
2012-03-19 04:00:00	DIA	ETF	131.19	131.19	131.19	131.19	100.0
2012-03-19 08:00:00	DIA	ETF	131.97	131.97	131.75	131.81	10726.0
2012-03-19 09:00:00	DIA	ETF	131.8	132.04	131.8	131.91	498246.0
2012-03-19 10:00:00	DIA	ETF	131.9	132.0	131.85	131.93	786920.0

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

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