PREVIEW / etf_1hour / 2012-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-19.parquet
  size:    188 KB
  rows:    5,773

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-06-19 04:00:00	SPY	ETF	134.94	134.94	134.26	134.73	5070.0
2012-06-19 05:00:00	SPY	ETF	134.53	134.94	134.48	134.94	10320.0
2012-06-19 06:00:00	SPY	ETF	134.88	134.96	134.78	134.78	25420.0
2012-06-19 07:00:00	SPY	ETF	134.84	135.14	134.84	135.01	379078.0
2012-06-19 08:00:00	SPY	ETF	135.0	135.15	134.5	134.93	1295663.0
2012-06-19 09:00:00	SPY	ETF	134.92	135.44	134.84	135.42	14615108.0
2012-06-19 10:00:00	SPY	ETF	135.415	135.75	135.37	135.7	23749202.0
2012-06-19 11:00:00	SPY	ETF	135.7	135.85	135.53	135.82	16358154.0
2012-06-19 12:00:00	SPY	ETF	135.82	135.9	135.71	135.87	7339883.0
2012-06-19 13:00:00	SPY	ETF	135.88	136.25	135.79	136.12	14472161.0
2012-06-19 14:00:00	SPY	ETF	136.12	136.13	135.58	135.865	20891133.0
2012-06-19 15:00:00	SPY	ETF	135.87	136.06	135.59	135.7	27081624.0
2012-06-19 16:00:00	SPY	ETF	135.69	135.8121	134.3744	135.54	10386291.0
2012-06-19 17:00:00	SPY	ETF	135.54	135.55	135.47	135.48	173532.0
2012-06-19 18:00:00	SPY	ETF	135.47	135.58	135.45	135.53	69640.0
2012-06-19 19:00:00	SPY	ETF	135.57	135.65	135.52	135.54	103722.0
2012-06-19 04:00:00	QQQ	ETF	63.72	63.72	63.72	63.72	100.0
2012-06-19 05:00:00	QQQ	ETF	63.75	63.75	63.75	63.75	200.0
2012-06-19 07:00:00	QQQ	ETF	63.8	63.92	63.79	63.86	68085.0
2012-06-19 08:00:00	QQQ	ETF	63.87	63.9	63.75	63.8	195766.0
2012-06-19 09:00:00	QQQ	ETF	63.8	64.21	63.8	64.18	4622431.0
2012-06-19 10:00:00	QQQ	ETF	64.19	64.29	64.13	64.27	5076933.0
2012-06-19 11:00:00	QQQ	ETF	64.27	64.3783	64.18	64.34	3404999.0
2012-06-19 12:00:00	QQQ	ETF	64.34	64.38	64.24	64.33	2144285.0
2012-06-19 13:00:00	QQQ	ETF	64.3395	64.51	64.29	64.45	3312751.0
2012-06-19 14:00:00	QQQ	ETF	64.445	64.47	64.1809	64.3292	3536837.0
2012-06-19 15:00:00	QQQ	ETF	64.325	64.43	64.195	64.24	6160089.0
2012-06-19 16:00:00	QQQ	ETF	64.24	64.28	64.16	64.18	578172.0
2012-06-19 17:00:00	QQQ	ETF	64.18	64.24	64.18	64.23	8868.0
2012-06-19 18:00:00	QQQ	ETF	64.2	64.2	64.16	64.19	13642.0
2012-06-19 19:00:00	QQQ	ETF	64.21	64.22	64.2	64.22	4479.0
2012-06-19 04:00:00	IWM	ETF	77.3	77.3	77.3	77.3	500.0
2012-06-19 07:00:00	IWM	ETF	77.5	77.66	77.49	77.57	9400.0
2012-06-19 08:00:00	IWM	ETF	77.58	77.72	77.43	77.56	114848.0
2012-06-19 09:00:00	IWM	ETF	77.5	78.12	77.5	78.09	5134300.0
2012-06-19 10:00:00	IWM	ETF	78.09	78.82	78.03	78.63	15237281.0
2012-06-19 11:00:00	IWM	ETF	78.64	78.79	78.4	78.78	6943247.0
2012-06-19 12:00:00	IWM	ETF	78.78	78.83	78.55	78.7	3505831.0
2012-06-19 13:00:00	IWM	ETF	78.7	79.08	78.65	78.95	6291571.0
2012-06-19 14:00:00	IWM	ETF	78.94	78.9801	78.5	78.78	6572261.0
2012-06-19 15:00:00	IWM	ETF	78.78	78.95	78.64	78.64	8145449.0
2012-06-19 16:00:00	IWM	ETF	78.65	78.9	77.8597	78.58	4588194.0
2012-06-19 17:00:00	IWM	ETF	78.58	78.61	78.55	78.6	23800.0
2012-06-19 18:00:00	IWM	ETF	78.51	78.52	78.51	78.52	210.0
2012-06-19 19:00:00	IWM	ETF	78.59	78.6	78.58	78.59	6100.0
2012-06-19 08:00:00	DIA	ETF	127.78	127.78	127.59	127.63	5750.0
2012-06-19 09:00:00	DIA	ETF	127.67	127.93	127.51	127.91	440349.0
2012-06-19 10:00:00	DIA	ETF	127.93	128.32	127.88	128.2459	711037.0
2012-06-19 11:00:00	DIA	ETF	128.25	128.37	128.15	128.35	382943.0
2012-06-19 12:00:00	DIA	ETF	128.36	128.42	128.29	128.39	356537.0

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

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