PREVIEW / etf_1hour / 2018-05-30

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-30.parquet
  size:    297 KB
  rows:    9,766

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
2018-05-30 04:00:00	SPY	ETF	270.16	270.4	269.8	269.88	16684.0
2018-05-30 05:00:00	SPY	ETF	270.25	270.62	269.96	270.53	76988.0
2018-05-30 06:00:00	SPY	ETF	270.52	270.92	270.38	270.79	84791.0
2018-05-30 07:00:00	SPY	ETF	270.7	271.02	270.69	270.71	297331.0
2018-05-30 08:00:00	SPY	ETF	270.7	270.97	269.02	270.45	1010434.0
2018-05-30 09:00:00	SPY	ETF	270.43	271.05	270.21	270.52	7726449.0
2018-05-30 10:00:00	SPY	ETF	270.5	271.76	270.42	271.76	8235699.0
2018-05-30 11:00:00	SPY	ETF	271.76	272.481	271.51	272.351	8981093.0
2018-05-30 12:00:00	SPY	ETF	272.35	272.65	272.245	272.3932	6783542.0
2018-05-30 13:00:00	SPY	ETF	272.4	273.0	272.215	272.7875	6000107.0
2018-05-30 14:00:00	SPY	ETF	272.785	273.11	272.7	272.91	6493344.0
2018-05-30 15:00:00	SPY	ETF	272.905	273.04	272.305	272.58	15678610.0
2018-05-30 16:00:00	SPY	ETF	272.6	272.79	270.5295	272.48	6060757.0
2018-05-30 17:00:00	SPY	ETF	272.47	272.61	272.31	272.31	495200.0
2018-05-30 18:00:00	SPY	ETF	272.3	272.36	272.05	272.3	141186.0
2018-05-30 19:00:00	SPY	ETF	272.28	272.29	272.15	272.26	28861.0
2018-05-30 04:00:00	QQQ	ETF	169.5	169.75	169.4	169.4	4885.0
2018-05-30 05:00:00	QQQ	ETF	169.58	169.77	169.44	169.72	22116.0
2018-05-30 06:00:00	QQQ	ETF	169.75	169.89	169.72	169.81	16252.0
2018-05-30 07:00:00	QQQ	ETF	169.77	170.02	169.75	169.9	94731.0
2018-05-30 08:00:00	QQQ	ETF	169.8	169.98	169.54	169.62	299213.0
2018-05-30 09:00:00	QQQ	ETF	169.58	169.93	169.34	169.44	3083241.0
2018-05-30 10:00:00	QQQ	ETF	169.44	170.14	169.22	170.08	3425653.0
2018-05-30 11:00:00	QQQ	ETF	170.08	170.38	169.93	170.285	1903102.0
2018-05-30 12:00:00	QQQ	ETF	170.29	170.48	169.95	170.04	2007389.0
2018-05-30 13:00:00	QQQ	ETF	170.041	170.35	169.86	170.15	1986177.0
2018-05-30 14:00:00	QQQ	ETF	170.15	170.41	170.14	170.335	1506100.0
2018-05-30 15:00:00	QQQ	ETF	170.34	170.41	170.0925	170.17	3285445.0
2018-05-30 16:00:00	QQQ	ETF	170.17	170.4	170.0577	170.18	1150968.0
2018-05-30 17:00:00	QQQ	ETF	170.28	170.28	170.11	170.16	11928.0
2018-05-30 18:00:00	QQQ	ETF	170.1	170.17	169.9	170.09	33199.0
2018-05-30 19:00:00	QQQ	ETF	170.11	170.12	169.96	170.07	14858.0
2018-05-30 05:00:00	IWM	ETF	162.0	162.18	162.0	162.18	500.0
2018-05-30 06:00:00	IWM	ETF	162.08	162.34	162.08	162.34	7300.0
2018-05-30 07:00:00	IWM	ETF	162.36	162.46	162.28	162.29	58628.0
2018-05-30 08:00:00	IWM	ETF	162.29	162.45	161.93	162.42	89056.0
2018-05-30 09:00:00	IWM	ETF	162.41	163.58	162.28	163.54	3877141.0
2018-05-30 10:00:00	IWM	ETF	163.54	164.16	163.395	164.04	4203041.0
2018-05-30 11:00:00	IWM	ETF	164.04	164.13	163.73	164.0	2917654.0
2018-05-30 12:00:00	IWM	ETF	164.01	164.24	163.89	164.06	1905253.0
2018-05-30 13:00:00	IWM	ETF	164.07	164.3	163.91	164.15	1955076.0
2018-05-30 14:00:00	IWM	ETF	164.16	164.38	164.11	164.29	1568243.0
2018-05-30 15:00:00	IWM	ETF	164.29	164.39	163.8	164.03	4160038.0
2018-05-30 16:00:00	IWM	ETF	164.03	164.15	163.86	164.0	1782832.0
2018-05-30 17:00:00	IWM	ETF	164.0	164.03	163.95	164.03	2400.0
2018-05-30 18:00:00	IWM	ETF	163.9	164.03	163.85	163.91	2963.0
2018-05-30 19:00:00	IWM	ETF	163.91	163.93	163.85	163.85	2174.0
2018-05-30 04:00:00	DIA	ETF	244.2	244.52	244.16	244.16	762.0
2018-05-30 05:00:00	DIA	ETF	244.66	244.72	244.44	244.72	700.0
2018-05-30 06:00:00	DIA	ETF	244.94	245.22	244.86	245.2	970.0

> showing 50 of 9,766 rows — these rows as CSV

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