PREVIEW / etf_1hour / 2018-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-29.parquet
  size:    314 KB
  rows:    10,407

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-11-29 04:00:00	SPY	ETF	273.83	273.86	273.36	273.51	32084.0
2018-11-29 05:00:00	SPY	ETF	273.41	273.69	273.23	273.25	86202.0
2018-11-29 06:00:00	SPY	ETF	273.33	273.49	273.01	273.29	66018.0
2018-11-29 07:00:00	SPY	ETF	273.3	273.78	273.28	273.38	303626.0
2018-11-29 08:00:00	SPY	ETF	273.26	273.89	273.26	273.63	884964.0
2018-11-29 09:00:00	SPY	ETF	273.62	274.02	273.46	273.64	6621804.0
2018-11-29 10:00:00	SPY	ETF	273.63	274.12	272.43	272.79	14032060.0
2018-11-29 11:00:00	SPY	ETF	272.79	274.0	272.57	273.92	11868454.0
2018-11-29 12:00:00	SPY	ETF	273.92	274.3185	273.41	274.26	5288856.0
2018-11-29 13:00:00	SPY	ETF	274.26	274.45	273.82	274.15	4701052.0
2018-11-29 14:00:00	SPY	ETF	274.17	275.54	273.92	275.49	9488278.0
2018-11-29 15:00:00	SPY	ETF	275.49	275.55	273.83	273.96	17704148.0
2018-11-29 16:00:00	SPY	ETF	273.95	274.55	273.85	274.27	9076283.0
2018-11-29 17:00:00	SPY	ETF	274.28	274.6	274.18	274.31	483463.0
2018-11-29 18:00:00	SPY	ETF	274.29	274.3	273.87	274.14	388075.0
2018-11-29 19:00:00	SPY	ETF	274.13	274.25	273.93	274.16	73550.0
2018-11-29 04:00:00	QQQ	ETF	168.33	168.33	167.7	167.83	65317.0
2018-11-29 05:00:00	QQQ	ETF	167.71	167.95	167.51	167.59	37381.0
2018-11-29 06:00:00	QQQ	ETF	167.56	167.69	167.41	167.51	59342.0
2018-11-29 07:00:00	QQQ	ETF	167.52	167.97	167.5	167.63	116276.0
2018-11-29 08:00:00	QQQ	ETF	167.7401	168.15	167.51	167.91	448792.0
2018-11-29 09:00:00	QQQ	ETF	167.89	168.469	167.59	168.04	3965080.0
2018-11-29 10:00:00	QQQ	ETF	168.05	168.27	166.82	166.985	8058005.0
2018-11-29 11:00:00	QQQ	ETF	166.98	168.15	166.8899	168.0	6357967.0
2018-11-29 12:00:00	QQQ	ETF	168.0	168.38	167.6	168.36	2287630.0
2018-11-29 13:00:00	QQQ	ETF	168.37	168.52	167.9	168.21	2434844.0
2018-11-29 14:00:00	QQQ	ETF	168.21	169.25	168.04	169.21	4977273.0
2018-11-29 15:00:00	QQQ	ETF	169.21	169.26	168.07	168.16	5799477.0
2018-11-29 16:00:00	QQQ	ETF	168.15	168.51	168.04	168.36	1559883.0
2018-11-29 17:00:00	QQQ	ETF	168.42	168.44	168.21	168.3	27067.0
2018-11-29 18:00:00	QQQ	ETF	168.26	168.32	168.06	168.22	89668.0
2018-11-29 19:00:00	QQQ	ETF	168.22	168.32	168.15	168.25	42502.0
2018-11-29 04:00:00	IWM	ETF	151.9	151.9	151.45	151.45	2900.0
2018-11-29 05:00:00	IWM	ETF	151.53	151.53	151.3	151.3	1500.0
2018-11-29 06:00:00	IWM	ETF	151.3	151.35	151.15	151.32	17400.0
2018-11-29 07:00:00	IWM	ETF	151.27	151.57	151.27	151.48	29789.0
2018-11-29 08:00:00	IWM	ETF	151.3	151.7	151.3	151.6	30590.0
2018-11-29 09:00:00	IWM	ETF	151.51	152.34	151.39	151.59	1415895.0
2018-11-29 10:00:00	IWM	ETF	151.59	151.83	150.44	150.84	2980387.0
2018-11-29 11:00:00	IWM	ETF	150.83	152.0	150.8	151.89	2157417.0
2018-11-29 12:00:00	IWM	ETF	151.9	152.28	151.58	152.25	1006505.0
2018-11-29 13:00:00	IWM	ETF	152.26	152.26	151.78	152.12	1176536.0
2018-11-29 14:00:00	IWM	ETF	152.1	152.74	151.94	152.71	1473914.0
2018-11-29 15:00:00	IWM	ETF	152.7	152.74	151.65	151.82	3242992.0
2018-11-29 16:00:00	IWM	ETF	151.83	152.2752	151.82	151.87	403662.0
2018-11-29 17:00:00	IWM	ETF	151.84	151.9	151.84	151.9	580.0
2018-11-29 18:00:00	IWM	ETF	151.87	151.87	151.64	151.73	33700.0
2018-11-29 19:00:00	IWM	ETF	151.73	151.79	151.67	151.78	4781.0
2018-11-29 05:00:00	DIA	ETF	252.88	253.0	252.74	252.74	1400.0
2018-11-29 06:00:00	DIA	ETF	252.62	252.62	252.62	252.62	500.0

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

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