PREVIEW / etf_1hour / 2019-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-25.parquet
  size:    333 KB
  rows:    10,988

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-06-25 04:00:00	SPY	ETF	293.22	293.55	293.15	293.23	8268.0
2019-06-25 05:00:00	SPY	ETF	293.2	293.41	293.2	293.34	3021.0
2019-06-25 06:00:00	SPY	ETF	293.33	293.43	293.2	293.39	32470.0
2019-06-25 07:00:00	SPY	ETF	293.39	293.52	293.32	293.48	185669.0
2019-06-25 08:00:00	SPY	ETF	293.49	293.74	292.93	293.69	195970.0
2019-06-25 09:00:00	SPY	ETF	293.69	293.91	292.68	293.0749	6090475.0
2019-06-25 10:00:00	SPY	ETF	293.08	293.16	292.22	292.43	7326884.0
2019-06-25 11:00:00	SPY	ETF	292.42	292.83	292.22	292.55	6177018.0
2019-06-25 12:00:00	SPY	ETF	292.54	292.78	291.76	291.89	7555263.0
2019-06-25 13:00:00	SPY	ETF	291.9	292.46	291.28	291.8501	9008088.0
2019-06-25 14:00:00	SPY	ETF	291.85	291.96	290.72	291.31	9831855.0
2019-06-25 15:00:00	SPY	ETF	291.31	291.555	290.64	290.79	21688887.0
2019-06-25 16:00:00	SPY	ETF	290.79	291.8424	290.75	290.87	9218223.0
2019-06-25 17:00:00	SPY	ETF	290.9	290.96	290.77	290.81	147451.0
2019-06-25 18:00:00	SPY	ETF	290.83	291.06	290.82	291.06	151120.0
2019-06-25 19:00:00	SPY	ETF	291.07	291.09	290.38	290.62	179583.0
2019-06-25 04:00:00	QQQ	ETF	187.76	187.91	187.67	187.67	24104.0
2019-06-25 05:00:00	QQQ	ETF	187.72	187.82	187.67	187.73	11200.0
2019-06-25 06:00:00	QQQ	ETF	187.7	187.82	187.64	187.81	9458.0
2019-06-25 07:00:00	QQQ	ETF	187.93	187.96	187.78	187.94	74813.0
2019-06-25 08:00:00	QQQ	ETF	187.88	188.1399	187.37	188.1	64343.0
2019-06-25 09:00:00	QQQ	ETF	188.08	188.2	187.2	187.48	2548822.0
2019-06-25 10:00:00	QQQ	ETF	187.48	187.61	186.37	186.56	4370132.0
2019-06-25 11:00:00	QQQ	ETF	186.58	186.7785	186.4	186.56	1776025.0
2019-06-25 12:00:00	QQQ	ETF	186.55	186.82	185.8106	185.91	2236919.0
2019-06-25 13:00:00	QQQ	ETF	185.9131	186.365	185.33	185.85	4736789.0
2019-06-25 14:00:00	QQQ	ETF	185.85	185.885	184.6901	185.04	3436057.0
2019-06-25 15:00:00	QQQ	ETF	185.0499	185.2699	184.65	184.93	5343936.0
2019-06-25 16:00:00	QQQ	ETF	184.93	185.25	184.9065	185.25	1156610.0
2019-06-25 17:00:00	QQQ	ETF	185.26	185.42	185.22	185.25	141378.0
2019-06-25 18:00:00	QQQ	ETF	185.25	185.4	185.22	185.38	42863.0
2019-06-25 19:00:00	QQQ	ETF	185.39	185.39	184.9	185.04	102667.0
2019-06-25 04:00:00	IWM	ETF	152.0	152.07	152.0	152.07	375.0
2019-06-25 06:00:00	IWM	ETF	152.08	152.1	152.08	152.08	2500.0
2019-06-25 07:00:00	IWM	ETF	152.18	152.21	152.08	152.08	6183.0
2019-06-25 08:00:00	IWM	ETF	152.18	152.33	151.92	152.31	16757.0
2019-06-25 09:00:00	IWM	ETF	152.32	152.48	151.62	152.46	1885185.0
2019-06-25 10:00:00	IWM	ETF	152.45	152.5	151.54	151.75	2837799.0
2019-06-25 11:00:00	IWM	ETF	151.75	152.2785	151.595	152.1	1447390.0
2019-06-25 12:00:00	IWM	ETF	152.09	152.455	151.7131	151.82	1566521.0
2019-06-25 13:00:00	IWM	ETF	151.82	152.26	151.58	151.96	1763412.0
2019-06-25 14:00:00	IWM	ETF	151.95	152.02	151.1	151.56	1603516.0
2019-06-25 15:00:00	IWM	ETF	151.59	151.84	151.0	151.15	3718322.0
2019-06-25 16:00:00	IWM	ETF	151.15	151.29	151.05	151.09	779555.0
2019-06-25 17:00:00	IWM	ETF	151.1	151.2	151.1	151.13	91256.0
2019-06-25 18:00:00	IWM	ETF	151.14	151.21	151.14	151.17	14538.0
2019-06-25 19:00:00	IWM	ETF	151.22	151.22	150.89	151.05	12955.0
2019-06-25 06:00:00	DIA	ETF	267.04	267.04	267.04	267.04	300.0
2019-06-25 07:00:00	DIA	ETF	267.21	267.21	267.21	267.21	4000.0
2019-06-25 08:00:00	DIA	ETF	266.77	267.15	266.76	267.15	600.0

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

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