PREVIEW / etf_1hour / 2016-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-27.parquet
  size:    244 KB
  rows:    7,827

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
2016-05-27 04:00:00	SPY	ETF	209.59	209.6	209.49	209.54	34625.0
2016-05-27 05:00:00	SPY	ETF	209.52	209.8	209.47	209.71	7269.0
2016-05-27 06:00:00	SPY	ETF	209.72	209.79	209.66	209.79	6657.0
2016-05-27 07:00:00	SPY	ETF	209.71	209.78	209.66	209.68	85296.0
2016-05-27 08:00:00	SPY	ETF	209.7	209.77	209.481	209.53	326155.0
2016-05-27 09:00:00	SPY	ETF	209.52	209.83	209.47	209.6801	5614107.0
2016-05-27 10:00:00	SPY	ETF	209.68	209.94	209.66	209.76	8619453.0
2016-05-27 11:00:00	SPY	ETF	209.7599	210.1	209.68	209.97	6300625.0
2016-05-27 12:00:00	SPY	ETF	209.97	210.05	209.92	209.96	4851410.0
2016-05-27 13:00:00	SPY	ETF	209.96	209.99	209.52	209.68	6849185.0
2016-05-27 14:00:00	SPY	ETF	209.67	209.95	209.52	209.85	6744061.0
2016-05-27 15:00:00	SPY	ETF	209.855	210.21	209.8	210.2	13717933.0
2016-05-27 16:00:00	SPY	ETF	210.2	210.45	210.0738	210.4	8666704.0
2016-05-27 17:00:00	SPY	ETF	210.39	210.46	210.35	210.43	1455701.0
2016-05-27 18:00:00	SPY	ETF	210.41	210.43	210.34	210.39	56968.0
2016-05-27 19:00:00	SPY	ETF	210.39	210.41	210.35	210.39	66208.0
2016-05-27 04:00:00	QQQ	ETF	109.78	109.78	109.78	109.78	1311.0
2016-05-27 05:00:00	QQQ	ETF	109.76	109.9	109.76	109.89	8538.0
2016-05-27 06:00:00	QQQ	ETF	109.89	109.89	109.88	109.89	1470.0
2016-05-27 07:00:00	QQQ	ETF	109.85	109.86	109.82	109.82	15143.0
2016-05-27 08:00:00	QQQ	ETF	109.82	109.86	109.69	109.7	36187.0
2016-05-27 09:00:00	QQQ	ETF	109.69	109.94	109.61	109.87	1509318.0
2016-05-27 10:00:00	QQQ	ETF	109.86	110.12	109.75	109.91	2085186.0
2016-05-27 11:00:00	QQQ	ETF	109.91	110.14	109.86	110.08	1827184.0
2016-05-27 12:00:00	QQQ	ETF	110.09	110.11	110.01	110.07	1446106.0
2016-05-27 13:00:00	QQQ	ETF	110.065	110.08	109.81	109.84	1444471.0
2016-05-27 14:00:00	QQQ	ETF	109.84	110.03	109.73	110.0	1787964.0
2016-05-27 15:00:00	QQQ	ETF	110.0	110.13	109.91	110.12	3016874.0
2016-05-27 16:00:00	QQQ	ETF	110.11	110.1633	110.07	110.14	1357227.0
2016-05-27 17:00:00	QQQ	ETF	110.11	110.2	110.07	110.2	9465.0
2016-05-27 18:00:00	QQQ	ETF	110.16	110.16	110.13	110.16	2849.0
2016-05-27 19:00:00	QQQ	ETF	110.14	110.19	110.14	110.14	2218.0
2016-05-27 06:00:00	IWM	ETF	113.65	113.65	113.65	113.65	1000.0
2016-05-27 07:00:00	IWM	ETF	113.69	113.72	113.63	113.63	5306.0
2016-05-27 08:00:00	IWM	ETF	113.68	113.7	113.5	113.5	6662.0
2016-05-27 09:00:00	IWM	ETF	113.48	114.05	113.48	113.92	1732901.0
2016-05-27 10:00:00	IWM	ETF	113.91	114.36	113.89	114.03	2435185.0
2016-05-27 11:00:00	IWM	ETF	114.02	114.35	113.88	114.3	2045357.0
2016-05-27 12:00:00	IWM	ETF	114.31	114.5	114.31	114.43	1485222.0
2016-05-27 13:00:00	IWM	ETF	114.425	114.46	114.0	114.14	2030314.0
2016-05-27 14:00:00	IWM	ETF	114.14	114.4899	114.03	114.34	2697434.0
2016-05-27 15:00:00	IWM	ETF	114.34	114.6	114.26	114.6	3833683.0
2016-05-27 16:00:00	IWM	ETF	114.59	114.7	114.59	114.66	1461417.0
2016-05-27 17:00:00	IWM	ETF	114.68	114.72	114.68	114.72	2299.0
2016-05-27 18:00:00	IWM	ETF	114.7	114.7	114.7	114.7	3998.0
2016-05-27 08:00:00	DIA	ETF	178.28	178.31	178.28	178.3	3100.0
2016-05-27 09:00:00	DIA	ETF	178.09	178.45	178.09	178.34	196840.0
2016-05-27 10:00:00	DIA	ETF	178.34	178.51	178.27	178.3571	288376.0
2016-05-27 11:00:00	DIA	ETF	178.35	178.59	178.28	178.48	288312.0
2016-05-27 12:00:00	DIA	ETF	178.4801	178.545	178.44	178.4524	86303.0

> showing 50 of 7,827 rows — these rows as CSV

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