PREVIEW / etf_1hour / 2019-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-16.parquet
  size:    327 KB
  rows:    10,851

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-04-16 04:00:00	SPY	ETF	290.75	291.09	290.75	291.08	18540.0
2019-04-16 05:00:00	SPY	ETF	291.08	291.08	290.82	290.88	26950.0
2019-04-16 06:00:00	SPY	ETF	290.9	291.02	290.8	290.9	43048.0
2019-04-16 07:00:00	SPY	ETF	290.87	290.98	290.78	290.94	309793.0
2019-04-16 08:00:00	SPY	ETF	290.96	291.07	290.5	290.91	434855.0
2019-04-16 09:00:00	SPY	ETF	290.92	291.03	290.52	290.65	6513710.0
2019-04-16 10:00:00	SPY	ETF	290.655	290.82	290.19	290.285	6219054.0
2019-04-16 11:00:00	SPY	ETF	290.28	290.56	290.17	290.29	4784587.0
2019-04-16 12:00:00	SPY	ETF	290.29	290.51	290.245	290.47	3329238.0
2019-04-16 13:00:00	SPY	ETF	290.475	290.475	290.11	290.22	3364105.0
2019-04-16 14:00:00	SPY	ETF	290.22	290.38	290.01	290.35	8072843.0
2019-04-16 15:00:00	SPY	ETF	290.35	290.46	289.5	290.18	14742086.0
2019-04-16 16:00:00	SPY	ETF	290.19	290.29	289.88	290.07	3662801.0
2019-04-16 17:00:00	SPY	ETF	290.08	290.19	289.97	290.02	116094.0
2019-04-16 18:00:00	SPY	ETF	290.03	290.06	289.89	289.9	31909.0
2019-04-16 19:00:00	SPY	ETF	289.93	290.09	289.91	290.02	15380.0
2019-04-16 04:00:00	QQQ	ETF	186.59	186.71	186.54	186.71	18474.0
2019-04-16 05:00:00	QQQ	ETF	186.7	186.7	186.51	186.51	48677.0
2019-04-16 06:00:00	QQQ	ETF	186.66	186.66	186.54	186.61	23940.0
2019-04-16 07:00:00	QQQ	ETF	186.57	186.63	186.45	186.55	72838.0
2019-04-16 08:00:00	QQQ	ETF	186.62	186.7	185.88	186.54	319627.0
2019-04-16 09:00:00	QQQ	ETF	186.53	186.64	186.3179	186.55	2220171.0
2019-04-16 10:00:00	QQQ	ETF	186.56	186.91	186.36	186.55	4313088.0
2019-04-16 11:00:00	QQQ	ETF	186.56	186.8	186.35	186.47	2088890.0
2019-04-16 12:00:00	QQQ	ETF	186.46	186.71	186.42	186.68	1165275.0
2019-04-16 13:00:00	QQQ	ETF	186.69	186.75	186.52	186.585	846442.0
2019-04-16 14:00:00	QQQ	ETF	186.57	186.72	186.469	186.72	1911227.0
2019-04-16 15:00:00	QQQ	ETF	186.7	186.82	185.93	186.54	4787150.0
2019-04-16 16:00:00	QQQ	ETF	186.54	186.94	186.1	186.47	2399088.0
2019-04-16 17:00:00	QQQ	ETF	186.5	186.53	186.44	186.5	7651.0
2019-04-16 18:00:00	QQQ	ETF	186.45	186.45	186.3	186.35	15417.0
2019-04-16 19:00:00	QQQ	ETF	186.36	186.48	186.35	186.47	20898.0
2019-04-16 04:00:00	IWM	ETF	157.76	157.84	157.76	157.84	2500.0
2019-04-16 05:00:00	IWM	ETF	157.75	157.75	157.59	157.66	4100.0
2019-04-16 06:00:00	IWM	ETF	157.63	157.71	157.63	157.63	1711.0
2019-04-16 07:00:00	IWM	ETF	157.67	157.72	157.67	157.7	8900.0
2019-04-16 08:00:00	IWM	ETF	157.67	157.79	157.5	157.69	11080.0
2019-04-16 09:00:00	IWM	ETF	157.69	157.8999	157.39	157.45	1044954.0
2019-04-16 10:00:00	IWM	ETF	157.45	157.81	156.98	157.05	1899479.0
2019-04-16 11:00:00	IWM	ETF	157.05	157.46	157.02	157.39	1174433.0
2019-04-16 12:00:00	IWM	ETF	157.38	157.71	157.34	157.6333	1105994.0
2019-04-16 13:00:00	IWM	ETF	157.63	157.64	157.34	157.44	615309.0
2019-04-16 14:00:00	IWM	ETF	157.435	157.67	157.23	157.57	901916.0
2019-04-16 15:00:00	IWM	ETF	157.58	157.69	157.07	157.5	2598834.0
2019-04-16 16:00:00	IWM	ETF	157.5	157.56	157.0702	157.42	2729172.0
2019-04-16 17:00:00	IWM	ETF	157.46	157.46	157.4	157.4	300.0
2019-04-16 18:00:00	IWM	ETF	157.41	157.41	157.31	157.34	4197.0
2019-04-16 19:00:00	IWM	ETF	157.36	157.4	157.32	157.33	8410.0
2019-04-16 04:00:00	DIA	ETF	264.72	264.73	264.69	264.73	1400.0
2019-04-16 05:00:00	DIA	ETF	264.68	264.68	264.68	264.68	100.0

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

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