PREVIEW / etf_1hour / 2018-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-07.parquet
  size:    305 KB
  rows:    9,935

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-09-07 04:00:00	SPY	ETF	287.97	287.97	287.71	287.71	46900.0
2018-09-07 05:00:00	SPY	ETF	287.65	288.03	287.46	287.52	41544.0
2018-09-07 06:00:00	SPY	ETF	287.54	287.83	287.46	287.79	32555.0
2018-09-07 07:00:00	SPY	ETF	287.74	287.85	287.61	287.65	99977.0
2018-09-07 08:00:00	SPY	ETF	287.64	288.11	286.99	287.03	935060.0
2018-09-07 09:00:00	SPY	ETF	287.03	287.99	286.71	287.78	7844075.0
2018-09-07 10:00:00	SPY	ETF	287.7738	288.47	287.64	288.335	6456096.0
2018-09-07 11:00:00	SPY	ETF	288.34	288.7	288.1	288.14	4876274.0
2018-09-07 12:00:00	SPY	ETF	288.14	288.22	286.92	287.58	13656456.0
2018-09-07 13:00:00	SPY	ETF	287.59	287.6	287.09	287.15	3933908.0
2018-09-07 14:00:00	SPY	ETF	287.15	287.95	287.145	287.91	5057588.0
2018-09-07 15:00:00	SPY	ETF	287.915	287.95	287.22	287.56	17105962.0
2018-09-07 16:00:00	SPY	ETF	287.55	287.76	279.18	287.5	10759604.0
2018-09-07 17:00:00	SPY	ETF	287.52	287.66	287.37	287.53	1511227.0
2018-09-07 18:00:00	SPY	ETF	287.53	287.56	287.44	287.48	31835.0
2018-09-07 19:00:00	SPY	ETF	287.46	287.46	287.16	287.38	22665.0
2018-09-07 04:00:00	QQQ	ETF	181.5	181.62	181.42	181.43	60352.0
2018-09-07 05:00:00	QQQ	ETF	181.39	181.65	181.24	181.34	17663.0
2018-09-07 06:00:00	QQQ	ETF	181.31	181.54	181.29	181.51	8664.0
2018-09-07 07:00:00	QQQ	ETF	181.44	181.54	181.35	181.35	57462.0
2018-09-07 08:00:00	QQQ	ETF	181.48	181.72	180.56	180.56	917179.0
2018-09-07 09:00:00	QQQ	ETF	180.54	182.38	180.23	182.16	8272473.0
2018-09-07 10:00:00	QQQ	ETF	182.16	182.55	181.95	182.475	5443923.0
2018-09-07 11:00:00	QQQ	ETF	182.48	182.67	182.05	182.07	2974518.0
2018-09-07 12:00:00	QQQ	ETF	182.06	182.13	181.07	181.92	5852330.0
2018-09-07 13:00:00	QQQ	ETF	181.9301	181.94	181.25	181.33	1720988.0
2018-09-07 14:00:00	QQQ	ETF	181.33	181.87	181.32	181.84	1939464.0
2018-09-07 15:00:00	QQQ	ETF	181.82	181.885	180.9	181.26	6439680.0
2018-09-07 16:00:00	QQQ	ETF	181.26	181.39	181.05	181.11	1867580.0
2018-09-07 17:00:00	QQQ	ETF	181.3	181.3	181.11	181.13	800237.0
2018-09-07 18:00:00	QQQ	ETF	181.15	181.15	181.03	181.09	7620.0
2018-09-07 19:00:00	QQQ	ETF	181.06	181.11	180.91	180.92	9302.0
2018-09-07 04:00:00	IWM	ETF	170.63	170.63	170.63	170.63	100.0
2018-09-07 05:00:00	IWM	ETF	170.3	170.43	170.2	170.2	2400.0
2018-09-07 06:00:00	IWM	ETF	170.39	170.39	170.33	170.33	3287.0
2018-09-07 07:00:00	IWM	ETF	170.33	170.37	170.32	170.35	6389.0
2018-09-07 08:00:00	IWM	ETF	170.29	170.33	169.99	170.1	27713.0
2018-09-07 09:00:00	IWM	ETF	169.98	170.97	169.6585	170.82	2476083.0
2018-09-07 10:00:00	IWM	ETF	170.82	171.445	170.7	171.14	2023661.0
2018-09-07 11:00:00	IWM	ETF	171.15	171.36	170.95	170.971	1196123.0
2018-09-07 12:00:00	IWM	ETF	170.97	171.01	170.1	170.57	2274431.0
2018-09-07 13:00:00	IWM	ETF	170.56	170.61	169.98	170.03	1152078.0
2018-09-07 14:00:00	IWM	ETF	170.03	170.415	170.02	170.35	1220683.0
2018-09-07 15:00:00	IWM	ETF	170.35	170.56	170.16	170.47	3316257.0
2018-09-07 16:00:00	IWM	ETF	170.48	170.68	170.4227	170.54	985749.0
2018-09-07 17:00:00	IWM	ETF	170.54	170.55	170.54	170.54	1300.0
2018-09-07 18:00:00	IWM	ETF	170.54	170.54	170.54	170.54	1000.0
2018-09-07 19:00:00	IWM	ETF	170.5	170.52	170.42	170.52	1229.0
2018-09-07 04:00:00	DIA	ETF	260.06	260.06	260.06	260.06	150.0
2018-09-07 08:00:00	DIA	ETF	259.84	259.88	259.29	259.36	13248.0

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

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