PREVIEW / etf_1hour / 2012-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-13.parquet
  size:    177 KB
  rows:    5,512

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-08-13 04:00:00	SPY	ETF	140.56	140.56	140.43	140.5	2200.0
2012-08-13 05:00:00	SPY	ETF	140.7	140.74	140.65	140.65	2200.0
2012-08-13 06:00:00	SPY	ETF	140.66	140.84	140.66	140.84	24699.0
2012-08-13 07:00:00	SPY	ETF	140.83	141.0	140.8	140.81	175911.0
2012-08-13 08:00:00	SPY	ETF	140.84	140.9	140.67	140.71	449850.0
2012-08-13 09:00:00	SPY	ETF	140.71	140.84	140.47	140.69	9670950.0
2012-08-13 10:00:00	SPY	ETF	140.7	140.81	140.21	140.21	14823444.0
2012-08-13 11:00:00	SPY	ETF	140.22	140.32	140.04	140.26	10439176.0
2012-08-13 12:00:00	SPY	ETF	140.26	140.41	140.09	140.39	7265558.0
2012-08-13 13:00:00	SPY	ETF	140.4	140.47	140.25	140.405	6987732.0
2012-08-13 14:00:00	SPY	ETF	140.42	140.81	140.36	140.711	10102560.0
2012-08-13 15:00:00	SPY	ETF	140.71	140.77	140.52	140.76	13723980.0
2012-08-13 16:00:00	SPY	ETF	140.77	140.91	140.3414	140.8	3099916.0
2012-08-13 17:00:00	SPY	ETF	140.8	140.88	140.8	140.86	56415.0
2012-08-13 18:00:00	SPY	ETF	140.88	140.88	140.76	140.77	33322.0
2012-08-13 19:00:00	SPY	ETF	140.77	140.83	140.77	140.78	41237.0
2012-08-13 05:00:00	QQQ	ETF	66.87	66.87	66.86	66.86	200.0
2012-08-13 06:00:00	QQQ	ETF	66.91	66.91	66.91	66.91	2500.0
2012-08-13 07:00:00	QQQ	ETF	66.92	66.99	66.89	66.89	21600.0
2012-08-13 08:00:00	QQQ	ETF	66.89	66.91	66.84	66.84	238254.0
2012-08-13 09:00:00	QQQ	ETF	66.88	66.97	66.76	66.862	2757798.0
2012-08-13 10:00:00	QQQ	ETF	66.87	66.94	66.62	66.64	4204043.0
2012-08-13 11:00:00	QQQ	ETF	66.63	66.73	66.5	66.69	3162151.0
2012-08-13 12:00:00	QQQ	ETF	66.695	66.828	66.62	66.82	1734304.0
2012-08-13 13:00:00	QQQ	ETF	66.82	66.87	66.77	66.83	1153076.0
2012-08-13 14:00:00	QQQ	ETF	66.83	67.0095	66.81	66.95	2282790.0
2012-08-13 15:00:00	QQQ	ETF	66.9599	67.02	66.86	67.01	2996868.0
2012-08-13 16:00:00	QQQ	ETF	67.02	67.09	66.8452	67.06	438308.0
2012-08-13 17:00:00	QQQ	ETF	67.06	67.09	67.01	67.08	24264.0
2012-08-13 18:00:00	QQQ	ETF	67.09	67.09	67.02	67.02	14211.0
2012-08-13 19:00:00	QQQ	ETF	67.01	67.03	67.01	67.02	29112.0
2012-08-13 04:00:00	IWM	ETF	79.59	79.59	79.59	79.59	2100.0
2012-08-13 06:00:00	IWM	ETF	79.9	79.9	79.9	79.9	9500.0
2012-08-13 07:00:00	IWM	ETF	79.96	80.13	79.93	79.93	53000.0
2012-08-13 08:00:00	IWM	ETF	79.92	79.95	79.86	79.92	47300.0
2012-08-13 09:00:00	IWM	ETF	79.9	80.01	79.68	79.749	2089672.0
2012-08-13 10:00:00	IWM	ETF	79.75	79.87	79.03	79.05	8475582.0
2012-08-13 11:00:00	IWM	ETF	79.05	79.13	78.89	79.07	3954794.0
2012-08-13 12:00:00	IWM	ETF	79.07	79.25	78.96	79.25	3011964.0
2012-08-13 13:00:00	IWM	ETF	79.25	79.61	79.22	79.54	2213440.0
2012-08-13 14:00:00	IWM	ETF	79.55	79.79	79.54	79.71	4002519.0
2012-08-13 15:00:00	IWM	ETF	79.72	79.8	79.57	79.8	4162935.0
2012-08-13 16:00:00	IWM	ETF	79.79	79.9	79.1	79.83	1517360.0
2012-08-13 17:00:00	IWM	ETF	79.84	79.87	79.78	79.78	1100.0
2012-08-13 18:00:00	IWM	ETF	79.8	79.83	79.8	79.83	1170.0
2012-08-13 19:00:00	IWM	ETF	79.84	79.84	79.81	79.81	800.0
2012-08-13 05:00:00	DIA	ETF	132.0	132.0	131.93	131.93	200.0
2012-08-13 07:00:00	DIA	ETF	132.0	132.0	132.0	132.0	100.0
2012-08-13 08:00:00	DIA	ETF	131.93	131.94	131.9	131.9	1979.0
2012-08-13 09:00:00	DIA	ETF	131.83	131.9	131.57	131.78	804588.0

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

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