PREVIEW / etf_1hour / 2013-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-30.parquet
  size:    201 KB
  rows:    6,315

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
2013-07-30 04:00:00	SPY	ETF	169.1	169.1	168.73	168.84	46000.0
2013-07-30 05:00:00	SPY	ETF	168.81	168.92	168.7	168.7	14400.0
2013-07-30 06:00:00	SPY	ETF	168.75	169.11	168.75	169.11	98879.0
2013-07-30 07:00:00	SPY	ETF	169.1	169.15	168.97	169.09	187377.0
2013-07-30 08:00:00	SPY	ETF	169.08	169.23	169.01	169.2	553364.0
2013-07-30 09:00:00	SPY	ETF	169.21	169.28	168.84	169.0	9117392.0
2013-07-30 10:00:00	SPY	ETF	168.98	169.19	168.78	168.83	13293653.0
2013-07-30 11:00:00	SPY	ETF	168.83	169.07	168.75	168.9572	8629867.0
2013-07-30 12:00:00	SPY	ETF	168.96	168.98	168.72	168.83	6701974.0
2013-07-30 13:00:00	SPY	ETF	168.8349	168.855	168.19	168.38	11328349.0
2013-07-30 14:00:00	SPY	ETF	168.38	168.59	168.28	168.49	8629344.0
2013-07-30 15:00:00	SPY	ETF	168.48	168.89	168.4	168.58	19096024.0
2013-07-30 16:00:00	SPY	ETF	168.58	168.92	168.24	168.88	6701182.0
2013-07-30 17:00:00	SPY	ETF	168.88	168.89	168.8	168.83	97806.0
2013-07-30 18:00:00	SPY	ETF	168.83	168.89	168.78	168.88	56770.0
2013-07-30 19:00:00	SPY	ETF	168.86	168.89	168.85	168.87	35616.0
2013-07-30 04:00:00	QQQ	ETF	75.51	75.52	75.36	75.38	19400.0
2013-07-30 05:00:00	QQQ	ETF	75.38	75.4	75.34	75.35	6700.0
2013-07-30 06:00:00	QQQ	ETF	75.36	75.52	75.36	75.51	9780.0
2013-07-30 07:00:00	QQQ	ETF	75.51	75.51	75.46	75.48	5700.0
2013-07-30 08:00:00	QQQ	ETF	75.48	75.56	75.48	75.56	94402.0
2013-07-30 09:00:00	QQQ	ETF	75.55	75.57	75.41	75.43	2015480.0
2013-07-30 10:00:00	QQQ	ETF	75.4299	75.72	75.415	75.61	3711551.0
2013-07-30 11:00:00	QQQ	ETF	75.61	75.95	75.56	75.899	3967332.0
2013-07-30 12:00:00	QQQ	ETF	75.9	75.91	75.73	75.7993	2502934.0
2013-07-30 13:00:00	QQQ	ETF	75.795	75.81	75.35	75.429	3094869.0
2013-07-30 14:00:00	QQQ	ETF	75.41	75.61	75.37	75.54	2289411.0
2013-07-30 15:00:00	QQQ	ETF	75.53	75.77	75.5	75.6	4699581.0
2013-07-30 16:00:00	QQQ	ETF	75.6	75.76	75.538	75.7	1355992.0
2013-07-30 17:00:00	QQQ	ETF	75.7	75.71	75.63	75.63	65510.0
2013-07-30 18:00:00	QQQ	ETF	75.66	75.7	75.66	75.7	7300.0
2013-07-30 19:00:00	QQQ	ETF	75.67	75.7	75.67	75.7	12825.0
2013-07-30 04:00:00	IWM	ETF	103.55	103.55	103.55	103.55	250.0
2013-07-30 06:00:00	IWM	ETF	103.6	103.79	103.6	103.79	2400.0
2013-07-30 07:00:00	IWM	ETF	103.68	103.71	103.6	103.6	63393.0
2013-07-30 08:00:00	IWM	ETF	103.64	103.82	103.63	103.8	73143.0
2013-07-30 09:00:00	IWM	ETF	103.78	103.87	103.46	103.66	2651341.0
2013-07-30 10:00:00	IWM	ETF	103.666	103.845	103.45	103.54	3928999.0
2013-07-30 11:00:00	IWM	ETF	103.54	103.72	103.43	103.64	2329034.0
2013-07-30 12:00:00	IWM	ETF	103.65	103.67	103.42	103.54	1528647.0
2013-07-30 13:00:00	IWM	ETF	103.545	103.6	103.11	103.28	2793461.0
2013-07-30 14:00:00	IWM	ETF	103.28	103.4001	103.17	103.27	2545533.0
2013-07-30 15:00:00	IWM	ETF	103.26	103.58	103.21	103.48	4859158.0
2013-07-30 16:00:00	IWM	ETF	103.5	103.78	103.2833	103.72	2197319.0
2013-07-30 17:00:00	IWM	ETF	103.71	103.72	103.71	103.71	3168.0
2013-07-30 18:00:00	IWM	ETF	103.71	103.77	103.7	103.74	12894.0
2013-07-30 19:00:00	IWM	ETF	103.73	103.73	103.71	103.71	750.0
2013-07-30 07:00:00	DIA	ETF	155.3	155.3	155.3	155.3	3000.0
2013-07-30 08:00:00	DIA	ETF	155.28	155.47	155.28	155.44	20196.0
2013-07-30 09:00:00	DIA	ETF	155.43	155.58	155.16	155.31	600608.0

> showing 50 of 6,315 rows — these rows as CSV

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