PREVIEW / etf_1hour / 2018-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-05.parquet
  size:    318 KB
  rows:    10,351

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-10-05 04:00:00	SPY	ETF	289.47	289.58	289.1	289.21	16980.0
2018-10-05 05:00:00	SPY	ETF	289.27	289.44	289.23	289.37	12190.0
2018-10-05 06:00:00	SPY	ETF	289.46	289.63	289.46	289.54	33250.0
2018-10-05 07:00:00	SPY	ETF	289.56	289.89	289.55	289.62	104613.0
2018-10-05 08:00:00	SPY	ETF	289.44	290.35	288.74	289.54	1555516.0
2018-10-05 09:00:00	SPY	ETF	289.54	290.3	289.4	289.42	9406520.0
2018-10-05 10:00:00	SPY	ETF	289.43	289.86	288.855	289.04	10824032.0
2018-10-05 11:00:00	SPY	ETF	289.03	289.0685	287.01	287.04	16991821.0
2018-10-05 12:00:00	SPY	ETF	287.045	287.58	286.61	286.952	12800453.0
2018-10-05 13:00:00	SPY	ETF	286.95	287.38	286.22	287.23	10280209.0
2018-10-05 14:00:00	SPY	ETF	287.23	288.05	287.0	287.945	9311445.0
2018-10-05 15:00:00	SPY	ETF	287.95	288.36	287.42	287.89	19103852.0
2018-10-05 16:00:00	SPY	ETF	287.89	288.35	287.8	288.35	11103544.0
2018-10-05 17:00:00	SPY	ETF	288.25	288.32	288.06	288.16	114220.0
2018-10-05 18:00:00	SPY	ETF	288.13	288.28	287.98	288.28	106560.0
2018-10-05 19:00:00	SPY	ETF	288.15	288.18	288.1	288.11	14196.0
2018-10-05 04:00:00	QQQ	ETF	181.99	182.0	181.6	181.72	34910.0
2018-10-05 05:00:00	QQQ	ETF	181.9	182.1	181.9	182.1	22139.0
2018-10-05 06:00:00	QQQ	ETF	182.16	182.26	182.08	182.18	67955.0
2018-10-05 07:00:00	QQQ	ETF	182.19	182.5	182.17	182.21	164966.0
2018-10-05 08:00:00	QQQ	ETF	182.4999	182.98	181.41	182.17	1376543.0
2018-10-05 09:00:00	QQQ	ETF	182.2	182.97	181.47	181.61	8056912.0
2018-10-05 10:00:00	QQQ	ETF	181.61	182.26	181.05	181.37	7695591.0
2018-10-05 11:00:00	QQQ	ETF	181.37	181.39	179.35	179.47	13072391.0
2018-10-05 12:00:00	QQQ	ETF	179.48	179.92	178.795	179.1	10527166.0
2018-10-05 13:00:00	QQQ	ETF	179.09	179.655	178.43	179.5403	10170128.0
2018-10-05 14:00:00	QQQ	ETF	179.555	180.74	179.37	180.5	8783343.0
2018-10-05 15:00:00	QQQ	ETF	180.5013	180.87	180.0	180.21	11319769.0
2018-10-05 16:00:00	QQQ	ETF	180.21	180.62	180.15	180.62	3077289.0
2018-10-05 17:00:00	QQQ	ETF	180.58	180.58	180.38	180.38	15466.0
2018-10-05 18:00:00	QQQ	ETF	180.44	180.44	180.37	180.44	14848.0
2018-10-05 19:00:00	QQQ	ETF	180.37	180.41	180.31	180.31	6486.0
2018-10-05 05:00:00	IWM	ETF	163.59	163.61	163.59	163.61	2000.0
2018-10-05 07:00:00	IWM	ETF	164.0	164.0	163.96	163.98	25800.0
2018-10-05 08:00:00	IWM	ETF	163.64	164.24	163.29	163.79	256085.0
2018-10-05 09:00:00	IWM	ETF	163.83	164.16	163.34	163.5	2643362.0
2018-10-05 10:00:00	IWM	ETF	163.5	163.89	162.83	163.11	3454450.0
2018-10-05 11:00:00	IWM	ETF	163.12	163.15	161.16	161.175	5109793.0
2018-10-05 12:00:00	IWM	ETF	161.17	161.73	161.08	161.3051	4107493.0
2018-10-05 13:00:00	IWM	ETF	161.3	161.76	160.66	161.665	3410338.0
2018-10-05 14:00:00	IWM	ETF	161.66	162.66	161.66	162.46	4297720.0
2018-10-05 15:00:00	IWM	ETF	162.47	162.63	161.91	162.18	3847442.0
2018-10-05 16:00:00	IWM	ETF	162.18	162.62	162.1303	162.6	1146033.0
2018-10-05 17:00:00	IWM	ETF	162.62	162.62	162.44	162.44	5370.0
2018-10-05 18:00:00	IWM	ETF	162.4	162.48	162.33	162.47	6450.0
2018-10-05 19:00:00	IWM	ETF	162.45	162.45	162.4	162.4	2362.0
2018-10-05 04:00:00	DIA	ETF	265.99	265.99	265.7	265.79	500.0
2018-10-05 05:00:00	DIA	ETF	266.01	266.14	266.01	266.14	350.0
2018-10-05 06:00:00	DIA	ETF	266.2	266.2	266.2	266.2	100.0
2018-10-05 07:00:00	DIA	ETF	266.28	266.48	266.28	266.48	1344.0

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

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