PREVIEW / etf_1hour / 2013-07-15

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-15.parquet
  size:    200 KB
  rows:    6,374

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-15 04:00:00	SPY	ETF	167.81	167.93	167.81	167.83	10076.0
2013-07-15 05:00:00	SPY	ETF	167.87	167.88	167.67	167.67	4400.0
2013-07-15 06:00:00	SPY	ETF	167.63	167.75	167.63	167.68	12395.0
2013-07-15 07:00:00	SPY	ETF	167.7	167.81	167.66	167.72	343105.0
2013-07-15 08:00:00	SPY	ETF	167.72	167.94	167.71	167.85	771947.0
2013-07-15 09:00:00	SPY	ETF	167.84	168.12	167.51	167.845	12588726.0
2013-07-15 10:00:00	SPY	ETF	167.85	168.04	167.77	168.01	11117397.0
2013-07-15 11:00:00	SPY	ETF	168.0	168.2	167.91	168.15	9415943.0
2013-07-15 12:00:00	SPY	ETF	168.14	168.23	168.08	168.1	4706357.0
2013-07-15 13:00:00	SPY	ETF	168.1	168.21	168.01	168.18	5103116.0
2013-07-15 14:00:00	SPY	ETF	168.18	168.39	168.16	168.29	7974098.0
2013-07-15 15:00:00	SPY	ETF	168.29	168.34	168.14	168.19	12028490.0
2013-07-15 16:00:00	SPY	ETF	168.18	168.3293	168.0088	168.22	4200101.0
2013-07-15 17:00:00	SPY	ETF	168.22	168.23	168.18	168.21	554900.0
2013-07-15 18:00:00	SPY	ETF	168.19	168.26	168.18	168.18	22205.0
2013-07-15 19:00:00	SPY	ETF	168.2	168.23	168.15	168.18	40558.0
2013-07-15 04:00:00	QQQ	ETF	75.37	75.37	75.35	75.35	3600.0
2013-07-15 05:00:00	QQQ	ETF	75.35	75.35	75.33	75.33	800.0
2013-07-15 06:00:00	QQQ	ETF	75.28	75.33	75.28	75.29	1000.0
2013-07-15 07:00:00	QQQ	ETF	75.3	75.33	75.28	75.3	13268.0
2013-07-15 08:00:00	QQQ	ETF	75.29	75.32	75.28	75.29	86118.0
2013-07-15 09:00:00	QQQ	ETF	75.28	75.42	75.17	75.26	2596234.0
2013-07-15 10:00:00	QQQ	ETF	75.27	75.385	75.24	75.385	2158768.0
2013-07-15 11:00:00	QQQ	ETF	75.39	75.45	75.33	75.42	1511407.0
2013-07-15 12:00:00	QQQ	ETF	75.42	75.46	75.37	75.4099	1229166.0
2013-07-15 13:00:00	QQQ	ETF	75.41	75.475	75.379	75.46	1164742.0
2013-07-15 14:00:00	QQQ	ETF	75.4599	75.51	75.43	75.4742	2882129.0
2013-07-15 15:00:00	QQQ	ETF	75.47	75.52	75.42	75.47	3958532.0
2013-07-15 16:00:00	QQQ	ETF	75.47	75.4914	75.306	75.43	2323416.0
2013-07-15 17:00:00	QQQ	ETF	75.46	75.48	75.46	75.48	5700.0
2013-07-15 18:00:00	QQQ	ETF	75.46	75.47	75.44	75.45	5639.0
2013-07-15 19:00:00	QQQ	ETF	75.44	75.46	75.44	75.44	4737.0
2013-07-15 06:00:00	IWM	ETF	102.75	102.83	102.75	102.83	600.0
2013-07-15 07:00:00	IWM	ETF	102.84	102.88	102.83	102.83	9255.0
2013-07-15 08:00:00	IWM	ETF	102.82	102.96	102.82	102.84	81304.0
2013-07-15 09:00:00	IWM	ETF	102.84	103.37	102.68	103.13	3795578.0
2013-07-15 10:00:00	IWM	ETF	103.13	103.345	103.1	103.26	4099264.0
2013-07-15 11:00:00	IWM	ETF	103.27	103.55	103.22	103.52	3853601.0
2013-07-15 12:00:00	IWM	ETF	103.52	103.6	103.43	103.44	2299528.0
2013-07-15 13:00:00	IWM	ETF	103.43	103.5	103.38	103.4799	1899571.0
2013-07-15 14:00:00	IWM	ETF	103.48	103.68	103.48	103.56	3210454.0
2013-07-15 15:00:00	IWM	ETF	103.56	103.61	103.41	103.54	6604667.0
2013-07-15 16:00:00	IWM	ETF	103.54	103.65	103.27	103.65	1198258.0
2013-07-15 17:00:00	IWM	ETF	103.62	103.67	103.61	103.67	7524.0
2013-07-15 18:00:00	IWM	ETF	103.67	103.67	103.61	103.61	2776.0
2013-07-15 19:00:00	IWM	ETF	103.62	103.63	103.62	103.63	2500.0
2013-07-15 08:00:00	DIA	ETF	154.36	154.5	154.36	154.5	5405.0
2013-07-15 09:00:00	DIA	ETF	154.45	154.67	154.33	154.37	318256.0
2013-07-15 10:00:00	DIA	ETF	154.39	154.57	154.346	154.49	312921.0
2013-07-15 11:00:00	DIA	ETF	154.5	154.62	154.43	154.55	304152.0

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

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