PREVIEW / etf_1hour / 2018-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-17.parquet
  size:    298 KB
  rows:    9,814

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-07-17 04:00:00	SPY	ETF	278.8	278.97	278.8	278.93	12984.0
2018-07-17 05:00:00	SPY	ETF	278.96	278.97	278.88	278.89	16059.0
2018-07-17 06:00:00	SPY	ETF	278.91	278.91	278.46	278.65	81492.0
2018-07-17 07:00:00	SPY	ETF	278.68	278.84	278.54	278.71	226798.0
2018-07-17 08:00:00	SPY	ETF	278.7301	278.85	278.46	278.56	406326.0
2018-07-17 09:00:00	SPY	ETF	278.56	278.96	278.35	278.89	4741435.0
2018-07-17 10:00:00	SPY	ETF	278.93	279.82	278.92	279.72	7007692.0
2018-07-17 11:00:00	SPY	ETF	279.72	280.2	279.66	280.18	6437312.0
2018-07-17 12:00:00	SPY	ETF	280.185	280.625	280.03	280.5132	7765738.0
2018-07-17 13:00:00	SPY	ETF	280.52	280.75	280.41	280.55	4658599.0
2018-07-17 14:00:00	SPY	ETF	280.56	280.65	280.33	280.36	4956936.0
2018-07-17 15:00:00	SPY	ETF	280.35	280.91	280.29	280.5	11137286.0
2018-07-17 16:00:00	SPY	ETF	280.5	280.78	280.38	280.66	3425808.0
2018-07-17 17:00:00	SPY	ETF	280.65	280.68	280.47	280.66	386880.0
2018-07-17 18:00:00	SPY	ETF	280.69	280.91	280.47	280.85	95547.0
2018-07-17 19:00:00	SPY	ETF	280.8	280.94	280.74	280.84	39784.0
2018-07-17 04:00:00	QQQ	ETF	177.7	177.8	177.66	177.74	12554.0
2018-07-17 05:00:00	QQQ	ETF	177.75	177.79	177.74	177.77	7434.0
2018-07-17 06:00:00	QQQ	ETF	177.8	177.8	177.43	177.56	10529.0
2018-07-17 07:00:00	QQQ	ETF	177.63	177.92	177.56	177.88	133701.0
2018-07-17 08:00:00	QQQ	ETF	179.18	179.18	177.27	177.59	279497.0
2018-07-17 09:00:00	QQQ	ETF	177.59	178.361	177.19	178.34	4287005.0
2018-07-17 10:00:00	QQQ	ETF	178.35	179.18	178.26	179.07	4465826.0
2018-07-17 11:00:00	QQQ	ETF	179.08	179.65	179.054	179.65	2832668.0
2018-07-17 12:00:00	QQQ	ETF	179.65	180.335	179.49	180.06	3535386.0
2018-07-17 13:00:00	QQQ	ETF	180.0799	180.475	180.07	180.27	2099813.0
2018-07-17 14:00:00	QQQ	ETF	180.275	180.44	180.08	180.12	1397854.0
2018-07-17 15:00:00	QQQ	ETF	180.115	180.65	180.05	180.31	4687713.0
2018-07-17 16:00:00	QQQ	ETF	180.32	180.48	180.18	180.39	1465474.0
2018-07-17 17:00:00	QQQ	ETF	180.45	180.45	180.36	180.44	3122.0
2018-07-17 18:00:00	QQQ	ETF	180.4	180.56	180.4	180.5	15872.0
2018-07-17 19:00:00	QQQ	ETF	180.5	180.57	180.41	180.55	48069.0
2018-07-17 05:00:00	IWM	ETF	166.9	166.9	166.9	166.9	2400.0
2018-07-17 06:00:00	IWM	ETF	166.77	166.77	166.63	166.7	10600.0
2018-07-17 07:00:00	IWM	ETF	166.84	166.99	166.74	166.91	62607.0
2018-07-17 08:00:00	IWM	ETF	166.99	167.18	166.83	166.87	43605.0
2018-07-17 09:00:00	IWM	ETF	166.83	167.54	166.59	167.37	2270092.0
2018-07-17 10:00:00	IWM	ETF	167.38	168.0	167.38	167.57	2707831.0
2018-07-17 11:00:00	IWM	ETF	167.57	167.7	167.3	167.43	1802544.0
2018-07-17 12:00:00	IWM	ETF	167.44	167.68	167.32	167.6	1000987.0
2018-07-17 13:00:00	IWM	ETF	167.61	167.93	167.59	167.75	1150511.0
2018-07-17 14:00:00	IWM	ETF	167.75	167.8	167.49	167.495	883118.0
2018-07-17 15:00:00	IWM	ETF	167.5	167.805	167.38	167.51	2468224.0
2018-07-17 16:00:00	IWM	ETF	167.51	167.69	167.42	167.57	571468.0
2018-07-17 17:00:00	IWM	ETF	167.55	167.55	167.55	167.55	135.0
2018-07-17 18:00:00	IWM	ETF	167.65	167.77	167.65	167.7	1077.0
2018-07-17 19:00:00	IWM	ETF	167.65	167.71	167.62	167.71	5373.0
2018-07-17 04:00:00	DIA	ETF	250.7	250.72	250.68	250.68	2400.0
2018-07-17 05:00:00	DIA	ETF	250.8	250.82	250.66	250.66	7700.0
2018-07-17 06:00:00	DIA	ETF	250.58	250.58	250.32	250.35	13900.0

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

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