PREVIEW / etf_1hour / 2019-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-07.parquet
  size:    322 KB
  rows:    10,926

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
2019-03-07 04:00:00	SPY	ETF	276.65	276.74	276.56	276.62	26361.0
2019-03-07 05:00:00	SPY	ETF	276.78	276.78	276.59	276.76	14370.0
2019-03-07 06:00:00	SPY	ETF	276.71	276.78	276.57	276.65	63829.0
2019-03-07 07:00:00	SPY	ETF	276.63	277.49	276.62	277.48	509047.0
2019-03-07 08:00:00	SPY	ETF	277.51	277.8	276.62	277.1	859707.0
2019-03-07 09:00:00	SPY	ETF	277.12	277.33	274.73	275.29	14052092.0
2019-03-07 10:00:00	SPY	ETF	275.27	275.48	274.36	275.29	15904222.0
2019-03-07 11:00:00	SPY	ETF	275.29	275.89	274.82	275.51	9919931.0
2019-03-07 12:00:00	SPY	ETF	275.51	276.3	275.08	276.17	9900607.0
2019-03-07 13:00:00	SPY	ETF	276.165	276.21	275.48	275.53	4634944.0
2019-03-07 14:00:00	SPY	ETF	275.53	275.71	274.25	274.41	10561424.0
2019-03-07 15:00:00	SPY	ETF	274.42	275.18	274.07	275.08	20031339.0
2019-03-07 16:00:00	SPY	ETF	275.08	275.4	274.7524	275.16	6295564.0
2019-03-07 17:00:00	SPY	ETF	275.16	275.23	275.06	275.1	148958.0
2019-03-07 18:00:00	SPY	ETF	275.08	275.29	275.01	275.29	42546.0
2019-03-07 19:00:00	SPY	ETF	275.29	275.3	274.73	274.73	134179.0
2019-03-07 04:00:00	QQQ	ETF	172.9	172.97	172.88	172.91	3485.0
2019-03-07 05:00:00	QQQ	ETF	172.98	173.03	172.98	173.01	27350.0
2019-03-07 06:00:00	QQQ	ETF	173.03	173.09	172.92	172.94	7000.0
2019-03-07 07:00:00	QQQ	ETF	172.87	173.41	172.87	173.41	109163.0
2019-03-07 08:00:00	QQQ	ETF	173.43	173.7	172.79	173.28	285285.0
2019-03-07 09:00:00	QQQ	ETF	173.28	173.48	171.64	171.94	6723456.0
2019-03-07 10:00:00	QQQ	ETF	171.93	172.03	171.31	171.91	7097558.0
2019-03-07 11:00:00	QQQ	ETF	171.895	172.4911	171.67	172.26	3614543.0
2019-03-07 12:00:00	QQQ	ETF	172.26	172.67	171.9299	172.58	3720141.0
2019-03-07 13:00:00	QQQ	ETF	172.58	172.65	171.86	171.91	2210275.0
2019-03-07 14:00:00	QQQ	ETF	171.9	172.01	170.86	170.98	3420238.0
2019-03-07 15:00:00	QQQ	ETF	171.0	171.51	170.79	171.45	7069785.0
2019-03-07 16:00:00	QQQ	ETF	171.43	171.51	171.34	171.41	831213.0
2019-03-07 17:00:00	QQQ	ETF	171.44	171.44	171.27	171.3	65201.0
2019-03-07 18:00:00	QQQ	ETF	171.37	171.51	171.31	171.51	140608.0
2019-03-07 19:00:00	QQQ	ETF	171.51	171.51	171.15	171.15	39714.0
2019-03-07 04:00:00	IWM	ETF	152.65	152.65	152.65	152.65	200.0
2019-03-07 05:00:00	IWM	ETF	152.77	152.78	152.77	152.78	600.0
2019-03-07 06:00:00	IWM	ETF	152.94	152.94	152.94	152.94	100.0
2019-03-07 07:00:00	IWM	ETF	153.03	153.36	153.0	153.36	3400.0
2019-03-07 08:00:00	IWM	ETF	152.94	153.5	152.57	153.17	64511.0
2019-03-07 09:00:00	IWM	ETF	153.22	153.26	151.52	152.22	4386792.0
2019-03-07 10:00:00	IWM	ETF	152.21	152.82	151.75	152.6	4679431.0
2019-03-07 11:00:00	IWM	ETF	152.59	153.14	152.09	152.43	2117582.0
2019-03-07 12:00:00	IWM	ETF	152.4	152.74	152.0333	152.65	2741039.0
2019-03-07 13:00:00	IWM	ETF	152.61	152.66	151.95	151.97	1622688.0
2019-03-07 14:00:00	IWM	ETF	151.969	153.75	151.4	151.429	2342712.0
2019-03-07 15:00:00	IWM	ETF	151.42	152.01	151.37	151.68	4122235.0
2019-03-07 16:00:00	IWM	ETF	151.68	152.4	151.6	151.78	1088762.0
2019-03-07 17:00:00	IWM	ETF	151.7	151.75	151.68	151.68	60064.0
2019-03-07 18:00:00	IWM	ETF	151.77	151.77	151.77	151.77	1000.0
2019-03-07 19:00:00	IWM	ETF	151.7	151.72	151.49	151.49	16918.0
2019-03-07 04:00:00	DIA	ETF	256.09	256.09	256.09	256.09	100.0
2019-03-07 05:00:00	DIA	ETF	256.1	256.1	256.08	256.08	500.0

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

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