PREVIEW / etf_1hour / 2018-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-05.parquet
  size:    300 KB
  rows:    9,850

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-06-05 04:00:00	SPY	ETF	275.0	275.17	274.96	275.16	25185.0
2018-06-05 05:00:00	SPY	ETF	275.14	275.44	275.04	275.42	43016.0
2018-06-05 06:00:00	SPY	ETF	275.44	275.44	275.07	275.13	94552.0
2018-06-05 07:00:00	SPY	ETF	275.13	275.31	275.11	275.14	69807.0
2018-06-05 08:00:00	SPY	ETF	275.19	275.28	274.69	274.75	403313.0
2018-06-05 09:00:00	SPY	ETF	274.76	275.2	274.7	275.2	3940038.0
2018-06-05 10:00:00	SPY	ETF	275.2	275.53	274.87	275.1375	6996722.0
2018-06-05 11:00:00	SPY	ETF	275.13	275.175	274.181	274.5	6705694.0
2018-06-05 12:00:00	SPY	ETF	274.51	274.82	274.18	274.72	4348751.0
2018-06-05 13:00:00	SPY	ETF	274.71	275.05	274.675	274.94	3252008.0
2018-06-05 14:00:00	SPY	ETF	274.94	275.37	274.78	275.36	3359795.0
2018-06-05 15:00:00	SPY	ETF	275.35	275.37	274.92	275.2	12191256.0
2018-06-05 16:00:00	SPY	ETF	275.2	275.59	274.9473	275.35	6678967.0
2018-06-05 17:00:00	SPY	ETF	275.39	275.45	275.33	275.42	72809.0
2018-06-05 18:00:00	SPY	ETF	275.41	275.5	275.31	275.4	74206.0
2018-06-05 19:00:00	SPY	ETF	275.37	275.47	275.32	275.42	15006.0
2018-06-05 20:00:00	SPY	ETF	275.1373	275.1373	275.1	275.1	832000.0
2018-06-05 04:00:00	QQQ	ETF	174.51	174.61	174.44	174.61	12490.0
2018-06-05 05:00:00	QQQ	ETF	174.6	175.0	174.6	174.88	25328.0
2018-06-05 06:00:00	QQQ	ETF	174.86	174.86	174.66	174.66	8493.0
2018-06-05 07:00:00	QQQ	ETF	174.68	174.73	174.59	174.61	45255.0
2018-06-05 08:00:00	QQQ	ETF	174.6999	174.71	174.39	174.45	156569.0
2018-06-05 09:00:00	QQQ	ETF	174.44	174.89	174.4	174.86	2320151.0
2018-06-05 10:00:00	QQQ	ETF	174.89	175.13	174.65	174.901	3252999.0
2018-06-05 11:00:00	QQQ	ETF	174.905	174.94	174.065	174.41	3381404.0
2018-06-05 12:00:00	QQQ	ETF	174.41	174.4958	174.085	174.46	1894375.0
2018-06-05 13:00:00	QQQ	ETF	174.4666	174.72	174.41	174.63	1647275.0
2018-06-05 14:00:00	QQQ	ETF	174.64	174.9	174.48	174.86	1192563.0
2018-06-05 15:00:00	QQQ	ETF	174.8501	174.88	174.56	174.83	4345011.0
2018-06-05 16:00:00	QQQ	ETF	174.83	175.19	174.7982	175.08	1163030.0
2018-06-05 17:00:00	QQQ	ETF	175.01	175.22	175.01	175.17	15314.0
2018-06-05 18:00:00	QQQ	ETF	175.11	175.11	174.98	174.98	23622.0
2018-06-05 19:00:00	QQQ	ETF	175.01	175.12	174.96	175.08	6404.0
2018-06-05 07:00:00	IWM	ETF	164.64	164.65	164.53	164.57	11842.0
2018-06-05 08:00:00	IWM	ETF	164.55	164.64	164.38	164.5	21999.0
2018-06-05 09:00:00	IWM	ETF	164.48	165.17	164.45	165.14	1325728.0
2018-06-05 10:00:00	IWM	ETF	165.13	165.51	164.76	164.84	2695704.0
2018-06-05 11:00:00	IWM	ETF	164.85	164.89	164.34	164.75	1296933.0
2018-06-05 12:00:00	IWM	ETF	164.75	165.15	164.62	165.07	965437.0
2018-06-05 13:00:00	IWM	ETF	165.07	165.435	165.045	165.34	1027353.0
2018-06-05 14:00:00	IWM	ETF	165.35	165.71	165.28	165.62	1290685.0
2018-06-05 15:00:00	IWM	ETF	165.61	165.77	165.35	165.72	2579555.0
2018-06-05 16:00:00	IWM	ETF	165.72	165.93	165.6779	165.92	784113.0
2018-06-05 17:00:00	IWM	ETF	165.77	165.77	165.77	165.77	1464.0
2018-06-05 18:00:00	IWM	ETF	165.77	165.77	165.75	165.75	5396.0
2018-06-05 19:00:00	IWM	ETF	165.75	165.78	165.67	165.75	9243.0
2018-06-05 04:00:00	DIA	ETF	248.38	248.38	248.38	248.38	100.0
2018-06-05 06:00:00	DIA	ETF	248.44	248.44	248.44	248.44	1659.0
2018-06-05 07:00:00	DIA	ETF	248.33	248.41	248.33	248.41	879.0
2018-06-05 08:00:00	DIA	ETF	248.27	248.27	247.89	247.89	15173.0

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

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