PREVIEW / etf_1hour / 2018-05-14

all etf 1-hour files

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

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-14 04:00:00	SPY	ETF	273.28	273.56	273.28	273.42	17510.0
2018-05-14 05:00:00	SPY	ETF	273.48	273.6	273.45	273.51	14690.0
2018-05-14 06:00:00	SPY	ETF	273.47	273.49	273.3	273.43	20006.0
2018-05-14 07:00:00	SPY	ETF	273.42	273.47	273.26	273.26	136503.0
2018-05-14 08:00:00	SPY	ETF	273.43	274.07	273.2	273.28	275662.0
2018-05-14 09:00:00	SPY	ETF	273.29	273.92	273.24	273.76	5390716.0
2018-05-14 10:00:00	SPY	ETF	273.7575	274.08	273.44	273.56	5716812.0
2018-05-14 11:00:00	SPY	ETF	273.56	273.91	273.21	273.45	4601011.0
2018-05-14 12:00:00	SPY	ETF	273.455	273.81	272.94	272.97	4064633.0
2018-05-14 13:00:00	SPY	ETF	272.96	273.13	272.56	272.9	4681679.0
2018-05-14 14:00:00	SPY	ETF	272.9	273.055	272.36	272.995	5834505.0
2018-05-14 15:00:00	SPY	ETF	272.99	273.215	272.47	272.92	14979527.0
2018-05-14 16:00:00	SPY	ETF	272.91	273.1124	272.41	272.83	6152822.0
2018-05-14 17:00:00	SPY	ETF	272.84	272.85	272.74	272.76	29992.0
2018-05-14 18:00:00	SPY	ETF	272.77	273.0	272.77	272.96	62231.0
2018-05-14 19:00:00	SPY	ETF	272.97	272.98	272.8	272.95	17057.0
2018-05-14 20:00:00	SPY	ETF	272.98	272.98	272.8542	272.8542	14700.0
2018-05-14 04:00:00	QQQ	ETF	169.91	170.01	169.87	169.98	8038.0
2018-05-14 05:00:00	QQQ	ETF	169.96	170.11	169.96	170.03	14870.0
2018-05-14 06:00:00	QQQ	ETF	170.02	170.05	169.91	169.97	13174.0
2018-05-14 07:00:00	QQQ	ETF	169.95	169.95	169.77	169.81	37785.0
2018-05-14 08:00:00	QQQ	ETF	169.9599	170.12	169.74	169.8	382698.0
2018-05-14 09:00:00	QQQ	ETF	169.8	170.46	169.79	170.24	2866401.0
2018-05-14 10:00:00	QQQ	ETF	170.24	170.82	170.1342	170.48	2336600.0
2018-05-14 11:00:00	QQQ	ETF	170.46	170.74	170.1208	170.275	1603421.0
2018-05-14 12:00:00	QQQ	ETF	170.27	170.51	170.0	170.031	1792643.0
2018-05-14 13:00:00	QQQ	ETF	170.03	170.04	169.62	169.91	1921244.0
2018-05-14 14:00:00	QQQ	ETF	169.91	169.98	169.47	169.95	1792674.0
2018-05-14 15:00:00	QQQ	ETF	169.95	170.02	169.51	169.74	3085345.0
2018-05-14 16:00:00	QQQ	ETF	169.74	169.86	169.4	169.67	1216201.0
2018-05-14 17:00:00	QQQ	ETF	169.61	169.75	169.61	169.67	2883.0
2018-05-14 18:00:00	QQQ	ETF	169.68	169.85	169.68	169.8	35574.0
2018-05-14 19:00:00	QQQ	ETF	169.73	169.82	169.73	169.82	8810.0
2018-05-14 04:00:00	IWM	ETF	160.22	160.22	160.22	160.22	100.0
2018-05-14 06:00:00	IWM	ETF	160.02	160.02	160.0	160.0	2000.0
2018-05-14 07:00:00	IWM	ETF	160.05	160.05	159.96	160.02	17800.0
2018-05-14 08:00:00	IWM	ETF	159.83	160.01	159.83	159.9	26934.0
2018-05-14 09:00:00	IWM	ETF	159.97	160.69	159.92	160.37	1811988.0
2018-05-14 10:00:00	IWM	ETF	160.37	160.49	159.85	159.9	1963407.0
2018-05-14 11:00:00	IWM	ETF	159.9	160.05	159.59	159.81	1392400.0
2018-05-14 12:00:00	IWM	ETF	159.82	160.02	159.259	159.2724	1028116.0
2018-05-14 13:00:00	IWM	ETF	159.261	159.56	159.09	159.431	1750412.0
2018-05-14 14:00:00	IWM	ETF	159.44	159.485	159.05	159.405	1430836.0
2018-05-14 15:00:00	IWM	ETF	159.41	159.5	159.05	159.25	3030824.0
2018-05-14 16:00:00	IWM	ETF	159.24	159.47	158.91	159.36	956673.0
2018-05-14 17:00:00	IWM	ETF	159.33	159.36	159.3	159.36	1900.0
2018-05-14 18:00:00	IWM	ETF	159.35	159.45	159.35	159.39	6305.0
2018-05-14 19:00:00	IWM	ETF	159.37	159.44	159.35	159.44	9474.0
2018-05-14 04:00:00	DIA	ETF	249.55	249.59	249.55	249.59	500.0
2018-05-14 05:00:00	DIA	ETF	249.6	249.6	249.6	249.6	100.0

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

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