PREVIEW / etf_1hour / 2012-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-06-08.parquet
  size:    182 KB
  rows:    5,622

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-08 04:00:00	SPY	ETF	131.58	131.58	131.19	131.32	16470.0
2012-06-08 05:00:00	SPY	ETF	131.34	132.05	131.31	131.86	20353.0
2012-06-08 06:00:00	SPY	ETF	131.86	132.02	131.32	131.47	128244.0
2012-06-08 07:00:00	SPY	ETF	131.5	131.85	131.42	131.75	598215.0
2012-06-08 08:00:00	SPY	ETF	131.79	132.0	131.3	131.71	1434585.0
2012-06-08 09:00:00	SPY	ETF	131.72	132.05	131.29	131.63	20678927.0
2012-06-08 10:00:00	SPY	ETF	131.62	132.31	131.51	132.27	24162153.0
2012-06-08 11:00:00	SPY	ETF	132.28	132.31	131.99	132.045	13025072.0
2012-06-08 12:00:00	SPY	ETF	132.045	132.6	132.04	132.57	12012079.0
2012-06-08 13:00:00	SPY	ETF	132.58	132.88	132.5575	132.685	13632464.0
2012-06-08 14:00:00	SPY	ETF	132.69	132.975	132.63	132.76	11977344.0
2012-06-08 15:00:00	SPY	ETF	132.76	133.125	132.72	133.09	28707742.0
2012-06-08 16:00:00	SPY	ETF	133.1	133.51	133.0	133.37	13972538.0
2012-06-08 17:00:00	SPY	ETF	133.37	133.53	133.29	133.48	535395.0
2012-06-08 18:00:00	SPY	ETF	133.49	133.52	133.34	133.4	199443.0
2012-06-08 19:00:00	SPY	ETF	133.4	133.53	133.36	133.5	81963.0
2012-06-08 04:00:00	QQQ	ETF	62.0	62.1	61.95	62.1	6030.0
2012-06-08 05:00:00	QQQ	ETF	61.89	62.0	61.89	62.0	19360.0
2012-06-08 06:00:00	QQQ	ETF	62.0	62.05	62.0	62.05	8400.0
2012-06-08 07:00:00	QQQ	ETF	62.02	62.18	61.96	62.15	52735.0
2012-06-08 08:00:00	QQQ	ETF	62.16	62.26	62.04	62.12	174922.0
2012-06-08 09:00:00	QQQ	ETF	62.16	62.29	61.96	62.23	4651883.0
2012-06-08 10:00:00	QQQ	ETF	62.23	62.64	62.17	62.61	8272963.0
2012-06-08 11:00:00	QQQ	ETF	62.62	62.635	62.43	62.44	2848397.0
2012-06-08 12:00:00	QQQ	ETF	62.45	62.63	62.41	62.59	2576541.0
2012-06-08 13:00:00	QQQ	ETF	62.58	62.775	62.57	62.67	3675675.0
2012-06-08 14:00:00	QQQ	ETF	62.67	62.79	62.63	62.72	2326551.0
2012-06-08 15:00:00	QQQ	ETF	62.73	62.95	62.7	62.87	7636664.0
2012-06-08 16:00:00	QQQ	ETF	62.87	63.03	62.7465	62.93	1346271.0
2012-06-08 17:00:00	QQQ	ETF	62.95	62.99	62.91	62.99	21760.0
2012-06-08 18:00:00	QQQ	ETF	62.98	62.98	62.94	62.94	6400.0
2012-06-08 19:00:00	QQQ	ETF	62.96	63.03	62.94	63.0	5629.0
2012-06-08 04:00:00	IWM	ETF	75.65	75.65	75.65	75.65	200.0
2012-06-08 05:00:00	IWM	ETF	75.65	75.74	75.65	75.74	2000.0
2012-06-08 06:00:00	IWM	ETF	75.71	75.72	75.71	75.72	10000.0
2012-06-08 07:00:00	IWM	ETF	75.65	75.92	75.65	75.86	40800.0
2012-06-08 08:00:00	IWM	ETF	75.86	76.1	75.46	75.88	102048.0
2012-06-08 09:00:00	IWM	ETF	75.93	76.11	75.3501	75.82	4901082.0
2012-06-08 10:00:00	IWM	ETF	75.82	76.65	75.72	76.63	7466880.0
2012-06-08 11:00:00	IWM	ETF	76.62	76.65	76.24	76.34	3954755.0
2012-06-08 12:00:00	IWM	ETF	76.34	76.82	76.34	76.79	3439171.0
2012-06-08 13:00:00	IWM	ETF	76.79	76.96	76.76	76.9	3778162.0
2012-06-08 14:00:00	IWM	ETF	76.8909	76.98	76.666	76.8	4202630.0
2012-06-08 15:00:00	IWM	ETF	76.8	77.06	76.76	76.97	8543367.0
2012-06-08 16:00:00	IWM	ETF	76.96	77.16	76.87	77.02	3447860.0
2012-06-08 17:00:00	IWM	ETF	77.02	77.18	77.02	77.18	58625.0
2012-06-08 18:00:00	IWM	ETF	77.2	77.2	77.16	77.16	2600.0
2012-06-08 19:00:00	IWM	ETF	77.1	77.1	77.1	77.1	900.0
2012-06-08 06:00:00	DIA	ETF	124.09	124.09	124.09	124.09	100.0
2012-06-08 08:00:00	DIA	ETF	124.2	124.31	124.06	124.14	9200.0

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

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