PREVIEW / etf_1hour / 2018-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-21.parquet
  size:    305 KB
  rows:    9,982

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-21 04:00:00	SPY	ETF	271.15	271.21	270.64	270.96	41814.0
2018-02-21 05:00:00	SPY	ETF	271.01	271.16	270.8	270.98	49802.0
2018-02-21 06:00:00	SPY	ETF	271.01	271.17	270.76	271.17	48177.0
2018-02-21 07:00:00	SPY	ETF	271.18	271.34	271.14	271.29	91789.0
2018-02-21 08:00:00	SPY	ETF	271.23	271.72	270.82	271.57	855462.0
2018-02-21 09:00:00	SPY	ETF	271.58	273.06	271.4	272.68	6851082.0
2018-02-21 10:00:00	SPY	ETF	272.69	273.4	272.35	273.32	5685800.0
2018-02-21 11:00:00	SPY	ETF	273.29	273.64	272.85	273.102	3775070.0
2018-02-21 12:00:00	SPY	ETF	273.1	273.33	272.58	273.3	3909290.0
2018-02-21 13:00:00	SPY	ETF	273.3	273.48	272.95	273.31	3654662.0
2018-02-21 14:00:00	SPY	ETF	273.31	274.72	272.81	273.23	19116491.0
2018-02-21 15:00:00	SPY	ETF	273.25	273.29	269.98	270.0	34931609.0
2018-02-21 16:00:00	SPY	ETF	269.99	272.23	269.31	269.84	16117527.0
2018-02-21 17:00:00	SPY	ETF	269.88	270.05	269.66	269.8	1008225.0
2018-02-21 18:00:00	SPY	ETF	269.78	269.87	269.0	269.15	234614.0
2018-02-21 19:00:00	SPY	ETF	269.14	269.59	269.06	269.24	212368.0
2018-02-21 04:00:00	QQQ	ETF	165.25	165.63	165.17	165.32	9680.0
2018-02-21 05:00:00	QQQ	ETF	165.25	165.46	165.21	165.37	52700.0
2018-02-21 06:00:00	QQQ	ETF	165.31	165.6	165.27	165.57	20094.0
2018-02-21 07:00:00	QQQ	ETF	165.61	165.8	165.61	165.71	47680.0
2018-02-21 08:00:00	QQQ	ETF	165.58	166.04	165.22	165.91	152868.0
2018-02-21 09:00:00	QQQ	ETF	166.0	166.44	165.8	166.2	3168087.0
2018-02-21 10:00:00	QQQ	ETF	166.2	166.76	165.9677	166.66	3159711.0
2018-02-21 11:00:00	QQQ	ETF	166.67	167.1501	166.44	166.73	2348323.0
2018-02-21 12:00:00	QQQ	ETF	166.73	166.83	166.32	166.64	1843779.0
2018-02-21 13:00:00	QQQ	ETF	166.64	166.84	166.53	166.7445	1408649.0
2018-02-21 14:00:00	QQQ	ETF	166.74	167.72	166.51	166.81	7569000.0
2018-02-21 15:00:00	QQQ	ETF	166.81	166.83	164.73	164.74	10758963.0
2018-02-21 16:00:00	QQQ	ETF	164.73	164.82	164.24	164.5	3123336.0
2018-02-21 17:00:00	QQQ	ETF	164.65	164.65	164.43	164.53	12105.0
2018-02-21 18:00:00	QQQ	ETF	164.5	164.82	163.7	163.79	513730.0
2018-02-21 19:00:00	QQQ	ETF	163.81	164.15	163.73	163.84	65465.0
2018-02-21 04:00:00	IWM	ETF	151.86	152.01	151.82	151.85	4569.0
2018-02-21 05:00:00	IWM	ETF	151.94	152.01	151.82	152.01	5303.0
2018-02-21 06:00:00	IWM	ETF	151.91	152.14	151.85	152.14	9753.0
2018-02-21 07:00:00	IWM	ETF	152.18	152.27	152.13	152.2	42121.0
2018-02-21 08:00:00	IWM	ETF	152.22	152.46	152.08	152.25	72715.0
2018-02-21 09:00:00	IWM	ETF	152.42	153.16	152.01	153.03	1698696.0
2018-02-21 10:00:00	IWM	ETF	153.03	154.05	152.76	153.88	2254835.0
2018-02-21 11:00:00	IWM	ETF	153.89	154.25	153.65	153.7	1319913.0
2018-02-21 12:00:00	IWM	ETF	153.7	153.95	153.43	153.95	1261655.0
2018-02-21 13:00:00	IWM	ETF	153.96	154.231	153.88	154.01	960663.0
2018-02-21 14:00:00	IWM	ETF	154.0	154.81	153.66	153.79	3320232.0
2018-02-21 15:00:00	IWM	ETF	153.79	153.81	152.22	152.24	5734879.0
2018-02-21 16:00:00	IWM	ETF	152.24	152.29	151.51	151.84	3404854.0
2018-02-21 17:00:00	IWM	ETF	151.84	152.24	151.75	151.94	1030660.0
2018-02-21 18:00:00	IWM	ETF	151.9	151.9	151.45	151.5	26097.0
2018-02-21 19:00:00	IWM	ETF	151.49	151.7	151.41	151.52	7725.0
2018-02-21 04:00:00	DIA	ETF	249.0	249.0	249.0	249.0	200.0
2018-02-21 05:00:00	DIA	ETF	249.03	249.11	249.03	249.06	700.0

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

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