PREVIEW / etf_1hour / 2011-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-14.parquet
  size:    179 KB
  rows:    5,492

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-14 04:00:00	SPY	ETF	128.35	128.88	128.35	128.84	6455.0
2011-06-14 05:00:00	SPY	ETF	128.8	128.92	128.64	128.64	8744.0
2011-06-14 06:00:00	SPY	ETF	128.66	128.71	128.42	128.43	57849.0
2011-06-14 07:00:00	SPY	ETF	128.45	128.66	128.42	128.6	543855.0
2011-06-14 08:00:00	SPY	ETF	128.6	129.11	128.01	129.06	3767516.0
2011-06-14 09:00:00	SPY	ETF	129.05	129.24	128.82	129.14	20701815.0
2011-06-14 10:00:00	SPY	ETF	129.14	129.44	129.03	129.32	27912892.0
2011-06-14 11:00:00	SPY	ETF	129.315	129.41	129.14	129.38	13168186.0
2011-06-14 12:00:00	SPY	ETF	129.39	129.56	129.24	129.5	11874773.0
2011-06-14 13:00:00	SPY	ETF	129.5	129.7	129.39	129.48	12966923.0
2011-06-14 14:00:00	SPY	ETF	129.48	129.7	129.4	129.63	12901799.0
2011-06-14 15:00:00	SPY	ETF	129.64	129.77	129.18	129.31	38908046.0
2011-06-14 16:00:00	SPY	ETF	129.31	129.55	127.6917	129.38	15080166.0
2011-06-14 17:00:00	SPY	ETF	129.38	129.42	129.35	129.4	216271.0
2011-06-14 18:00:00	SPY	ETF	129.39	129.46	129.32	129.4	395254.0
2011-06-14 19:00:00	SPY	ETF	129.4	129.42	129.3	129.36	49164.0
2011-06-14 04:00:00	QQQ	ETF	55.04	55.09	55.04	55.09	1100.0
2011-06-14 05:00:00	QQQ	ETF	54.99	55.0	54.99	55.0	1300.0
2011-06-14 06:00:00	QQQ	ETF	54.98	55.0	54.9	54.9	6800.0
2011-06-14 07:00:00	QQQ	ETF	54.91	54.98	54.91	54.98	120550.0
2011-06-14 08:00:00	QQQ	ETF	54.97	55.2	54.97	55.18	1343312.0
2011-06-14 09:00:00	QQQ	ETF	55.17	55.27	55.03	55.23	7421939.0
2011-06-14 10:00:00	QQQ	ETF	55.2201	55.41	55.19	55.38	5295550.0
2011-06-14 11:00:00	QQQ	ETF	55.37	55.39	55.28	55.335	3293381.0
2011-06-14 12:00:00	QQQ	ETF	55.34	55.39	55.3	55.34	3248992.0
2011-06-14 13:00:00	QQQ	ETF	55.34	55.46	55.29	55.4	4205267.0
2011-06-14 14:00:00	QQQ	ETF	55.3999	55.46	55.35	55.42	2750061.0
2011-06-14 15:00:00	QQQ	ETF	55.42	55.47	55.31	55.35	8266364.0
2011-06-14 16:00:00	QQQ	ETF	55.32	55.38	55.26	55.3	1188727.0
2011-06-14 17:00:00	QQQ	ETF	55.31	55.32	55.3	55.3	10780.0
2011-06-14 18:00:00	QQQ	ETF	55.3	55.34	55.29	55.3	49989.0
2011-06-14 19:00:00	QQQ	ETF	55.3	55.31	55.26	55.26	20730.0
2011-06-14 04:00:00	IWM	ETF	78.35	78.6	78.35	78.53	1325.0
2011-06-14 05:00:00	IWM	ETF	78.51	78.51	78.41	78.41	5700.0
2011-06-14 06:00:00	IWM	ETF	78.38	78.38	78.32	78.32	7200.0
2011-06-14 07:00:00	IWM	ETF	78.25	78.4	78.21	78.39	29068.0
2011-06-14 08:00:00	IWM	ETF	78.4	78.72	78.34	78.67	1120602.0
2011-06-14 09:00:00	IWM	ETF	78.68	79.08	78.39	79.04	11353294.0
2011-06-14 10:00:00	IWM	ETF	79.04	79.49	78.97	79.39	7999650.0
2011-06-14 11:00:00	IWM	ETF	79.39	79.54	79.23	79.54	4475606.0
2011-06-14 12:00:00	IWM	ETF	79.54	79.59	79.41	79.54	3433265.0
2011-06-14 13:00:00	IWM	ETF	79.54	79.67	79.47	79.53	3634468.0
2011-06-14 14:00:00	IWM	ETF	79.54	79.63	79.36	79.57	3509864.0
2011-06-14 15:00:00	IWM	ETF	79.59	79.68	79.272	79.44	10971945.0
2011-06-14 16:00:00	IWM	ETF	79.45	79.66	79.3394	79.58	5928930.0
2011-06-14 17:00:00	IWM	ETF	79.53	79.6	79.53	79.54	33183.0
2011-06-14 18:00:00	IWM	ETF	79.59	79.59	79.57	79.57	600.0
2011-06-14 19:00:00	IWM	ETF	79.6	79.63	79.56	79.56	5845.0
2011-06-14 04:00:00	DIA	ETF	120.25	120.38	120.25	120.37	3800.0
2011-06-14 05:00:00	DIA	ETF	120.27	120.27	120.16	120.16	810.0

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

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