PREVIEW / etf_1hour / 2018-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-12.parquet
  size:    304 KB
  rows:    9,943

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-12 04:00:00	SPY	ETF	289.59	289.81	289.59	289.7	4054.0
2018-09-12 05:00:00	SPY	ETF	289.67	289.67	289.37	289.37	6628.0
2018-09-12 06:00:00	SPY	ETF	289.34	289.48	289.29	289.48	8147.0
2018-09-12 07:00:00	SPY	ETF	289.48	289.48	288.96	289.08	140170.0
2018-09-12 08:00:00	SPY	ETF	289.15	289.43	288.9	288.94	502037.0
2018-09-12 09:00:00	SPY	ETF	288.96	289.37	288.7975	288.9	4914538.0
2018-09-12 10:00:00	SPY	ETF	288.905	289.29	288.23	288.5	8944967.0
2018-09-12 11:00:00	SPY	ETF	288.505	289.8	288.4035	288.6	11267435.0
2018-09-12 12:00:00	SPY	ETF	288.61	289.22	288.56	289.0	4935402.0
2018-09-12 13:00:00	SPY	ETF	289.01	289.3	288.7	288.82	4280016.0
2018-09-12 14:00:00	SPY	ETF	288.83	288.94	288.56	288.82	4205552.0
2018-09-12 15:00:00	SPY	ETF	288.82	289.52	288.815	289.16	14964893.0
2018-09-12 16:00:00	SPY	ETF	289.17	289.29	289.0	289.04	4382592.0
2018-09-12 17:00:00	SPY	ETF	289.02	289.12	288.99	288.99	564249.0
2018-09-12 18:00:00	SPY	ETF	289.02	289.02	288.85	289.02	42384.0
2018-09-12 19:00:00	SPY	ETF	289.03	289.05	288.98	289.02	22471.0
2018-09-12 04:00:00	QQQ	ETF	183.5	183.8	183.5	183.76	9791.0
2018-09-12 05:00:00	QQQ	ETF	183.74	183.74	183.48	183.52	14500.0
2018-09-12 06:00:00	QQQ	ETF	183.53	183.57	183.42	183.52	9444.0
2018-09-12 07:00:00	QQQ	ETF	183.55	183.59	183.1	183.17	69327.0
2018-09-12 08:00:00	QQQ	ETF	183.2499	183.4	182.83	182.88	243475.0
2018-09-12 09:00:00	QQQ	ETF	182.9	182.98	182.0	182.01	3732638.0
2018-09-12 10:00:00	QQQ	ETF	182.0031	182.43	181.01	181.28	5920831.0
2018-09-12 11:00:00	QQQ	ETF	181.28	182.77	181.2	181.57	7956105.0
2018-09-12 12:00:00	QQQ	ETF	181.56	182.47	181.5333	182.2	3360135.0
2018-09-12 13:00:00	QQQ	ETF	182.21	182.7	182.07	182.19	2224117.0
2018-09-12 14:00:00	QQQ	ETF	182.2	182.29	181.82	182.0515	2259758.0
2018-09-12 15:00:00	QQQ	ETF	182.05	182.7071	182.05	182.59	3601993.0
2018-09-12 16:00:00	QQQ	ETF	182.59	183.105	182.36	182.41	1007048.0
2018-09-12 17:00:00	QQQ	ETF	182.48	182.58	182.4	182.4	124815.0
2018-09-12 18:00:00	QQQ	ETF	182.41	182.41	182.27	182.39	27019.0
2018-09-12 19:00:00	QQQ	ETF	182.39	182.41	182.36	182.4	45176.0
2018-09-12 05:00:00	IWM	ETF	171.08	171.12	171.06	171.08	12500.0
2018-09-12 06:00:00	IWM	ETF	171.1	171.1	171.03	171.1	4500.0
2018-09-12 07:00:00	IWM	ETF	171.1	171.1	170.84	170.86	5399.0
2018-09-12 08:00:00	IWM	ETF	170.9	170.98	170.75	170.78	62178.0
2018-09-12 09:00:00	IWM	ETF	170.74	170.96	170.44	170.46	1002177.0
2018-09-12 10:00:00	IWM	ETF	170.44	170.64	169.33	169.56	3865824.0
2018-09-12 11:00:00	IWM	ETF	169.56	170.7	169.481	169.96	3408747.0
2018-09-12 12:00:00	IWM	ETF	169.95	170.35	169.79	170.16	1316045.0
2018-09-12 13:00:00	IWM	ETF	170.15	170.455	170.14	170.32	648211.0
2018-09-12 14:00:00	IWM	ETF	170.33	170.68	170.24	170.56	1161185.0
2018-09-12 15:00:00	IWM	ETF	170.55	171.09	170.55	170.62	3461415.0
2018-09-12 16:00:00	IWM	ETF	170.6	170.77	170.53	170.72	2989235.0
2018-09-12 17:00:00	IWM	ETF	170.72	170.72	170.62	170.66	25499.0
2018-09-12 18:00:00	IWM	ETF	170.64	170.64	170.6	170.62	15420.0
2018-09-12 19:00:00	IWM	ETF	170.67	170.69	170.65	170.65	2301.0
2018-09-12 04:00:00	DIA	ETF	260.71	260.71	260.7	260.7	1500.0
2018-09-12 06:00:00	DIA	ETF	260.48	260.48	260.48	260.48	1111.0
2018-09-12 07:00:00	DIA	ETF	260.25	260.25	259.96	259.96	4478.0

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

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