PREVIEW / etf_1hour / 2018-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-04.parquet
  size:    310 KB
  rows:    10,155

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-01-04 04:00:00	SPY	ETF	270.5	270.87	270.5	270.84	49547.0
2018-01-04 05:00:00	SPY	ETF	270.81	270.81	270.64	270.69	19500.0
2018-01-04 06:00:00	SPY	ETF	270.61	270.81	270.61	270.78	16750.0
2018-01-04 07:00:00	SPY	ETF	270.78	271.05	270.78	270.86	437371.0
2018-01-04 08:00:00	SPY	ETF	270.84	271.19	270.79	271.12	717636.0
2018-01-04 09:00:00	SPY	ETF	271.13	271.86	271.1	271.8162	9647896.0
2018-01-04 10:00:00	SPY	ETF	271.82	272.16	271.659	271.89	9345055.0
2018-01-04 11:00:00	SPY	ETF	271.89	271.92	271.43	271.63	9736551.0
2018-01-04 12:00:00	SPY	ETF	271.6215	271.93	271.585	271.86	7601850.0
2018-01-04 13:00:00	SPY	ETF	271.86	271.95	271.73	271.94	9232090.0
2018-01-04 14:00:00	SPY	ETF	271.945	272.06	271.79	271.905	6810959.0
2018-01-04 15:00:00	SPY	ETF	271.9	271.97	271.59	271.63	12067553.0
2018-01-04 16:00:00	SPY	ETF	271.64	271.8	271.49	271.71	10197232.0
2018-01-04 17:00:00	SPY	ETF	271.71	271.77	271.61	271.75	178914.0
2018-01-04 18:00:00	SPY	ETF	271.75	271.86	271.73	271.79	134332.0
2018-01-04 19:00:00	SPY	ETF	271.78	271.84	271.74	271.81	26503.0
2018-01-04 04:00:00	QQQ	ETF	160.32	160.44	160.32	160.44	7300.0
2018-01-04 05:00:00	QQQ	ETF	160.44	160.45	160.29	160.29	26400.0
2018-01-04 06:00:00	QQQ	ETF	160.29	160.36	160.26	160.33	25300.0
2018-01-04 07:00:00	QQQ	ETF	160.4	160.54	160.38	160.45	88599.0
2018-01-04 08:00:00	QQQ	ETF	160.03	160.81	160.03	160.69	292647.0
2018-01-04 09:00:00	QQQ	ETF	160.72	160.79	160.0825	160.38	4493771.0
2018-01-04 10:00:00	QQQ	ETF	160.38	160.7387	160.23	160.53	2773835.0
2018-01-04 11:00:00	QQQ	ETF	160.54	160.56	160.22	160.33	2190445.0
2018-01-04 12:00:00	QQQ	ETF	160.33	160.57	160.25	160.2962	2198161.0
2018-01-04 13:00:00	QQQ	ETF	160.2993	160.36	160.125	160.32	1696075.0
2018-01-04 14:00:00	QQQ	ETF	160.319	160.45	160.21	160.376	1803608.0
2018-01-04 15:00:00	QQQ	ETF	160.37	160.485	160.24	160.31	2492757.0
2018-01-04 16:00:00	QQQ	ETF	160.31	160.6	160.27	160.55	905667.0
2018-01-04 17:00:00	QQQ	ETF	160.53	160.61	160.5	160.55	14763.0
2018-01-04 18:00:00	QQQ	ETF	160.59	160.63	160.5	160.5	24029.0
2018-01-04 19:00:00	QQQ	ETF	160.51	160.62	160.51	160.6	10962.0
2018-01-04 04:00:00	IWM	ETF	154.38	154.61	154.38	154.61	5833.0
2018-01-04 05:00:00	IWM	ETF	154.58	154.59	154.54	154.54	2820.0
2018-01-04 06:00:00	IWM	ETF	154.6	154.64	154.6	154.64	960.0
2018-01-04 07:00:00	IWM	ETF	154.63	154.73	154.63	154.64	21804.0
2018-01-04 08:00:00	IWM	ETF	154.66	155.04	154.6	154.96	123160.0
2018-01-04 09:00:00	IWM	ETF	154.97	155.15	154.44	154.81	1550168.0
2018-01-04 10:00:00	IWM	ETF	154.81	154.86	154.29	154.4665	2122816.0
2018-01-04 11:00:00	IWM	ETF	154.46	154.521	154.02	154.25	1581968.0
2018-01-04 12:00:00	IWM	ETF	154.26	154.595	154.24	154.43	1124880.0
2018-01-04 13:00:00	IWM	ETF	154.43	154.69	154.41	154.64	992085.0
2018-01-04 14:00:00	IWM	ETF	154.635	154.735	154.58	154.65	998855.0
2018-01-04 15:00:00	IWM	ETF	154.65	154.73	154.4	154.45	2471286.0
2018-01-04 16:00:00	IWM	ETF	154.46	154.57	154.31	154.52	673861.0
2018-01-04 17:00:00	IWM	ETF	154.5	154.52	154.5	154.52	1000.0
2018-01-04 18:00:00	IWM	ETF	154.47	154.64	154.47	154.64	5054.0
2018-01-04 19:00:00	IWM	ETF	154.59	154.59	154.53	154.56	3361.0
2018-01-04 04:00:00	DIA	ETF	249.45	249.72	249.45	249.72	600.0
2018-01-04 05:00:00	DIA	ETF	249.74	249.74	249.74	249.74	100.0

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

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