PREVIEW / etf_1hour / 2018-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-15.parquet
  size:    312 KB
  rows:    10,266

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-02-15 04:00:00	SPY	ETF	271.18	271.79	271.18	271.74	53800.0
2018-02-15 05:00:00	SPY	ETF	271.7	271.75	271.4	271.4	20629.0
2018-02-15 06:00:00	SPY	ETF	271.41	271.46	270.69	270.92	98971.0
2018-02-15 07:00:00	SPY	ETF	270.92	271.19	270.45	270.65	259672.0
2018-02-15 08:00:00	SPY	ETF	270.63	271.43	270.11	271.07	1017001.0
2018-02-15 09:00:00	SPY	ETF	271.08	271.65	270.64	271.45	11836130.0
2018-02-15 10:00:00	SPY	ETF	271.46	271.58	269.15	269.22	14532983.0
2018-02-15 11:00:00	SPY	ETF	269.22	270.95	268.77	270.6989	15264936.0
2018-02-15 12:00:00	SPY	ETF	270.69	271.26	270.37	271.2398	7619288.0
2018-02-15 13:00:00	SPY	ETF	271.24	271.98	271.11	271.67	11164277.0
2018-02-15 14:00:00	SPY	ETF	271.67	272.41	271.59	272.15	10435718.0
2018-02-15 15:00:00	SPY	ETF	272.16	273.01	271.83	273.0	24727341.0
2018-02-15 16:00:00	SPY	ETF	273.0	273.54	272.54	273.35	9085396.0
2018-02-15 17:00:00	SPY	ETF	273.35	273.46	273.26	273.3	1848193.0
2018-02-15 18:00:00	SPY	ETF	273.34	273.6	273.03	273.57	809019.0
2018-02-15 19:00:00	SPY	ETF	273.52	273.56	273.44	273.56	62710.0
2018-02-15 04:00:00	QQQ	ETF	163.8	164.17	163.5	164.01	46297.0
2018-02-15 05:00:00	QQQ	ETF	164.05	164.17	164.04	164.07	16875.0
2018-02-15 06:00:00	QQQ	ETF	164.02	164.1	163.76	163.82	23963.0
2018-02-15 07:00:00	QQQ	ETF	163.9	164.08	163.55	163.73	245263.0
2018-02-15 08:00:00	QQQ	ETF	163.92	164.15	163.39	163.79	300956.0
2018-02-15 09:00:00	QQQ	ETF	163.82	164.53	163.26	164.48	4910617.0
2018-02-15 10:00:00	QQQ	ETF	164.48	164.51	162.7	162.74	8277061.0
2018-02-15 11:00:00	QQQ	ETF	162.74	164.27	162.44	164.1162	5932599.0
2018-02-15 12:00:00	QQQ	ETF	164.11	164.645	163.8814	164.6207	3072590.0
2018-02-15 13:00:00	QQQ	ETF	164.63	165.1901	164.51	164.845	5371179.0
2018-02-15 14:00:00	QQQ	ETF	164.85	165.36	164.72	165.14	4370906.0
2018-02-15 15:00:00	QQQ	ETF	165.15	165.66	165.03	165.66	8106497.0
2018-02-15 16:00:00	QQQ	ETF	165.66	166.23	165.53	165.7	1730470.0
2018-02-15 17:00:00	QQQ	ETF	166.02	166.1	166.0	166.0	45204.0
2018-02-15 18:00:00	QQQ	ETF	166.0	166.24	165.7	166.17	421900.0
2018-02-15 19:00:00	QQQ	ETF	166.17	166.25	166.12	166.24	45703.0
2018-02-15 04:00:00	IWM	ETF	152.02	152.41	152.02	152.4	9600.0
2018-02-15 05:00:00	IWM	ETF	152.39	152.5	152.39	152.47	5645.0
2018-02-15 06:00:00	IWM	ETF	152.4	152.4	151.82	151.99	12818.0
2018-02-15 07:00:00	IWM	ETF	151.94	152.0	151.64	151.75	62762.0
2018-02-15 08:00:00	IWM	ETF	151.76	152.11	151.65	151.84	152094.0
2018-02-15 09:00:00	IWM	ETF	151.96	152.25	151.35	152.003	2389091.0
2018-02-15 10:00:00	IWM	ETF	152.01	152.07	150.69	150.72	3540090.0
2018-02-15 11:00:00	IWM	ETF	150.72	151.67	150.56	151.56	2089058.0
2018-02-15 12:00:00	IWM	ETF	151.54	151.9	151.41	151.9	1296610.0
2018-02-15 13:00:00	IWM	ETF	151.91	152.19	151.8101	152.089	2077519.0
2018-02-15 14:00:00	IWM	ETF	152.09	152.795	152.08	152.68	2383729.0
2018-02-15 15:00:00	IWM	ETF	152.68	152.87	152.4	152.78	4524616.0
2018-02-15 16:00:00	IWM	ETF	152.77	153.26	152.08	153.1	1021898.0
2018-02-15 17:00:00	IWM	ETF	153.07	153.08	152.92	152.93	37116.0
2018-02-15 18:00:00	IWM	ETF	153.0	153.18	152.8	153.18	813488.0
2018-02-15 19:00:00	IWM	ETF	153.13	153.17	153.11	153.17	4998.0
2018-02-15 04:00:00	DIA	ETF	249.75	251.5	249.75	251.3	5078.0
2018-02-15 05:00:00	DIA	ETF	250.8	251.7	250.8	251.7	700.0

> showing 50 of 10,266 rows — these rows as CSV

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