PREVIEW / etf_1hour / 2012-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-20.parquet
  size:    179 KB
  rows:    5,564

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-20 05:00:00	SPY	ETF	142.39	142.39	142.33	142.33	20430.0
2012-08-20 06:00:00	SPY	ETF	142.2	142.36	142.2	142.27	3684.0
2012-08-20 07:00:00	SPY	ETF	142.29	142.29	141.97	142.09	358654.0
2012-08-20 08:00:00	SPY	ETF	142.03	142.15	141.97	141.98	442246.0
2012-08-20 09:00:00	SPY	ETF	141.97	142.22	141.76	141.82	11190616.0
2012-08-20 10:00:00	SPY	ETF	141.8281	141.89	141.59	141.8587	14388619.0
2012-08-20 11:00:00	SPY	ETF	141.85	142.04	141.75	141.98	9286858.0
2012-08-20 12:00:00	SPY	ETF	141.98	142.11	141.91	141.95	7938292.0
2012-08-20 13:00:00	SPY	ETF	141.96	142.04	141.86	141.98	3745745.0
2012-08-20 14:00:00	SPY	ETF	141.978	142.21	141.9	142.08	8074436.0
2012-08-20 15:00:00	SPY	ETF	142.08	142.22	141.99	142.19	11397037.0
2012-08-20 16:00:00	SPY	ETF	142.19	142.26	142.09	142.15	10795538.0
2012-08-20 17:00:00	SPY	ETF	142.14	142.25	142.14	142.22	61664.0
2012-08-20 18:00:00	SPY	ETF	142.21	142.24	142.17	142.2	115617.0
2012-08-20 19:00:00	SPY	ETF	142.18	142.2	142.14	142.14	26512.0
2012-08-20 05:00:00	QQQ	ETF	68.35	68.35	68.35	68.35	100.0
2012-08-20 07:00:00	QQQ	ETF	68.26	68.28	68.19	68.28	65297.0
2012-08-20 08:00:00	QQQ	ETF	68.25	68.32	68.22	68.29	110900.0
2012-08-20 09:00:00	QQQ	ETF	68.3	68.32	68.03	68.0601	3261012.0
2012-08-20 10:00:00	QQQ	ETF	68.06	68.21	68.0	68.2	4682457.0
2012-08-20 11:00:00	QQQ	ETF	68.2	68.34	68.12	68.325	1859892.0
2012-08-20 12:00:00	QQQ	ETF	68.32	68.43	68.193	68.28	2702161.0
2012-08-20 13:00:00	QQQ	ETF	68.27	68.32	68.16	68.24	1114177.0
2012-08-20 14:00:00	QQQ	ETF	68.23	68.36	68.2008	68.33	1831168.0
2012-08-20 15:00:00	QQQ	ETF	68.32	68.43	68.24	68.41	3314599.0
2012-08-20 16:00:00	QQQ	ETF	68.41	68.43	68.2833	68.34	2547564.0
2012-08-20 17:00:00	QQQ	ETF	68.36	68.4	68.34	68.35	24037.0
2012-08-20 18:00:00	QQQ	ETF	68.37	68.43	68.34	68.39	304942.0
2012-08-20 19:00:00	QQQ	ETF	68.4	68.4	68.38	68.4	7789.0
2012-08-20 05:00:00	IWM	ETF	81.89	81.89	81.89	81.89	100.0
2012-08-20 06:00:00	IWM	ETF	81.81	81.81	81.72	81.72	300.0
2012-08-20 07:00:00	IWM	ETF	81.6	81.64	81.59	81.64	28100.0
2012-08-20 08:00:00	IWM	ETF	81.6	81.64	81.55	81.55	208024.0
2012-08-20 09:00:00	IWM	ETF	81.53	81.66	81.3	81.37	3709165.0
2012-08-20 10:00:00	IWM	ETF	81.36	81.41	80.98	81.31	6588947.0
2012-08-20 11:00:00	IWM	ETF	81.31	81.43	81.16	81.39	2622913.0
2012-08-20 12:00:00	IWM	ETF	81.39	81.5199	81.34	81.37	3622269.0
2012-08-20 13:00:00	IWM	ETF	81.37	81.48	81.25	81.36	1424260.0
2012-08-20 14:00:00	IWM	ETF	81.37	81.63	81.32	81.485	1721841.0
2012-08-20 15:00:00	IWM	ETF	81.485	81.57	81.36	81.5	4298681.0
2012-08-20 16:00:00	IWM	ETF	81.5	81.6	81.419	81.57	4420355.0
2012-08-20 17:00:00	IWM	ETF	81.59	81.61	81.59	81.61	2800.0
2012-08-20 19:00:00	IWM	ETF	81.59	81.59	81.59	81.59	1000.0
2012-08-20 06:00:00	DIA	ETF	132.74	132.74	132.74	132.74	100.0
2012-08-20 08:00:00	DIA	ETF	132.25	132.25	132.21	132.23	6000.0
2012-08-20 09:00:00	DIA	ETF	132.12	132.38	132.12	132.21	239768.0
2012-08-20 10:00:00	DIA	ETF	132.23	132.3	131.99	132.247	694988.0
2012-08-20 11:00:00	DIA	ETF	132.244	132.36	132.13	132.3	311019.0
2012-08-20 12:00:00	DIA	ETF	132.3	132.4	132.29	132.34	143221.0
2012-08-20 13:00:00	DIA	ETF	132.33	132.36	132.1862	132.28	173675.0

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

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