PREVIEW / etf_1hour / 2018-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-05.parquet
  size:    305 KB
  rows:    9,952

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-03-05 04:00:00	SPY	ETF	268.48	268.94	268.14	268.82	67445.0
2018-03-05 05:00:00	SPY	ETF	268.86	269.31	268.67	269.22	42048.0
2018-03-05 06:00:00	SPY	ETF	269.15	269.15	268.36	268.38	116942.0
2018-03-05 07:00:00	SPY	ETF	268.38	268.7	268.02	268.1	400948.0
2018-03-05 08:00:00	SPY	ETF	268.13	268.76	267.0	268.0	949516.0
2018-03-05 09:00:00	SPY	ETF	267.98	268.63	267.41	268.06	10128190.0
2018-03-05 10:00:00	SPY	ETF	268.07	269.69	267.61	269.66	9502085.0
2018-03-05 11:00:00	SPY	ETF	269.66	271.54	269.54	271.28	12621613.0
2018-03-05 12:00:00	SPY	ETF	271.27	271.81	270.86	271.79	10524753.0
2018-03-05 13:00:00	SPY	ETF	271.79	272.23	271.31	271.79	9310659.0
2018-03-05 14:00:00	SPY	ETF	271.8085	272.55	270.97	272.52	8977338.0
2018-03-05 15:00:00	SPY	ETF	272.52	272.89	272.07	272.21	21456276.0
2018-03-05 16:00:00	SPY	ETF	272.2	272.8167	270.6621	272.01	10445950.0
2018-03-05 17:00:00	SPY	ETF	272.02	272.05	271.95	272.0	91926.0
2018-03-05 18:00:00	SPY	ETF	272.05	272.2	271.95	271.96	484956.0
2018-03-05 19:00:00	SPY	ETF	271.96	272.23	271.88	272.2	51354.0
2018-03-05 04:00:00	QQQ	ETF	165.66	166.5	165.4	165.91	184581.0
2018-03-05 05:00:00	QQQ	ETF	165.9	166.54	165.85	166.45	105943.0
2018-03-05 06:00:00	QQQ	ETF	166.36	166.36	165.9	165.91	82254.0
2018-03-05 07:00:00	QQQ	ETF	165.87	166.05	165.51	165.53	76799.0
2018-03-05 08:00:00	QQQ	ETF	165.56	165.99	164.5	165.51	310511.0
2018-03-05 09:00:00	QQQ	ETF	165.47	165.74	164.79	165.175	4385080.0
2018-03-05 10:00:00	QQQ	ETF	165.18	166.23	164.59	166.19	5356724.0
2018-03-05 11:00:00	QQQ	ETF	166.21	167.46	166.13	167.38	5183052.0
2018-03-05 12:00:00	QQQ	ETF	167.37	167.735	167.09	167.71	4241354.0
2018-03-05 13:00:00	QQQ	ETF	167.73	168.07	167.33	167.66	3339014.0
2018-03-05 14:00:00	QQQ	ETF	167.66	168.09	166.99	168.07	3261057.0
2018-03-05 15:00:00	QQQ	ETF	168.055	168.26	167.73	167.78	5571677.0
2018-03-05 16:00:00	QQQ	ETF	167.78	167.83	167.58	167.68	2419502.0
2018-03-05 17:00:00	QQQ	ETF	167.57	167.73	167.57	167.72	6081.0
2018-03-05 18:00:00	QQQ	ETF	167.69	167.83	167.69	167.69	15736.0
2018-03-05 19:00:00	QQQ	ETF	167.69	167.86	167.63	167.86	43162.0
2018-03-05 04:00:00	IWM	ETF	151.81	152.13	151.77	152.13	2000.0
2018-03-05 05:00:00	IWM	ETF	152.13	152.43	152.02	152.43	2700.0
2018-03-05 06:00:00	IWM	ETF	152.33	152.33	152.02	152.03	29979.0
2018-03-05 07:00:00	IWM	ETF	152.02	152.19	151.87	151.87	59432.0
2018-03-05 08:00:00	IWM	ETF	152.0	152.21	150.99	151.74	106275.0
2018-03-05 09:00:00	IWM	ETF	151.72	152.63	151.52	151.78	2036090.0
2018-03-05 10:00:00	IWM	ETF	151.78	152.78	151.47	152.75	2147759.0
2018-03-05 11:00:00	IWM	ETF	152.75	153.67	152.65	153.36	2380306.0
2018-03-05 12:00:00	IWM	ETF	153.35	153.68	153.05	153.55	1572217.0
2018-03-05 13:00:00	IWM	ETF	153.55	153.89	153.4	153.71	1568697.0
2018-03-05 14:00:00	IWM	ETF	153.71	153.875	153.12	153.85	1265440.0
2018-03-05 15:00:00	IWM	ETF	153.83	154.2601	153.57	153.68	3496735.0
2018-03-05 16:00:00	IWM	ETF	153.68	153.7413	152.303	153.71	1235275.0
2018-03-05 17:00:00	IWM	ETF	153.67	153.67	153.62	153.62	462.0
2018-03-05 18:00:00	IWM	ETF	153.63	153.79	153.61	153.69	8265.0
2018-03-05 19:00:00	IWM	ETF	153.55	153.7	153.55	153.7	1200.0
2018-03-05 04:00:00	DIA	ETF	245.08	245.08	244.75	245.0	700.0
2018-03-05 06:00:00	DIA	ETF	245.24	245.24	244.88	244.88	553.0

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

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