PREVIEW / etf_1hour / 2019-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-25.parquet
  size:    318 KB
  rows:    10,485

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-01-25 04:00:00	SPY	ETF	264.53	264.78	264.3	264.3	27330.0
2019-01-25 05:00:00	SPY	ETF	264.31	264.97	264.24	264.8	13087.0
2019-01-25 06:00:00	SPY	ETF	264.83	265.09	264.77	264.91	81529.0
2019-01-25 07:00:00	SPY	ETF	264.79	264.86	264.55	264.84	180502.0
2019-01-25 08:00:00	SPY	ETF	264.81	265.63	264.08	265.41	440293.0
2019-01-25 09:00:00	SPY	ETF	265.42	265.82	265.11	265.7	7553269.0
2019-01-25 10:00:00	SPY	ETF	265.7	266.63	265.68	266.38	10108399.0
2019-01-25 11:00:00	SPY	ETF	266.38	266.5	265.81	266.28	11094566.0
2019-01-25 12:00:00	SPY	ETF	266.27	266.7	265.52	265.97	17044668.0
2019-01-25 13:00:00	SPY	ETF	265.97	266.28	265.75	266.2	5786143.0
2019-01-25 14:00:00	SPY	ETF	266.2	266.34	265.49	265.99	10281009.0
2019-01-25 15:00:00	SPY	ETF	265.99	266.09	265.26	265.82	20297229.0
2019-01-25 16:00:00	SPY	ETF	265.82	266.09	265.57	266.05	12306552.0
2019-01-25 17:00:00	SPY	ETF	266.06	266.06	265.78	265.96	383532.0
2019-01-25 18:00:00	SPY	ETF	265.95	266.06	265.95	266.02	13981.0
2019-01-25 19:00:00	SPY	ETF	266.03	266.1	266.03	266.1	27367.0
2019-01-25 04:00:00	QQQ	ETF	163.8	164.0	163.65	163.68	13126.0
2019-01-25 05:00:00	QQQ	ETF	163.72	164.03	163.66	163.98	23760.0
2019-01-25 06:00:00	QQQ	ETF	164.03	164.2	163.93	163.99	38403.0
2019-01-25 07:00:00	QQQ	ETF	163.99	164.02	163.8	164.02	95642.0
2019-01-25 08:00:00	QQQ	ETF	163.97	164.63	163.4	164.48	444493.0
2019-01-25 09:00:00	QQQ	ETF	164.5	164.68	163.95	164.65	3878637.0
2019-01-25 10:00:00	QQQ	ETF	164.66	165.21	164.62	165.08	4621023.0
2019-01-25 11:00:00	QQQ	ETF	165.09	165.47	164.86	165.45	3187684.0
2019-01-25 12:00:00	QQQ	ETF	165.45	165.65	164.96	165.2699	4177642.0
2019-01-25 13:00:00	QQQ	ETF	165.26	165.51	165.07	165.45	2457160.0
2019-01-25 14:00:00	QQQ	ETF	165.455	165.58	164.87	165.2	3491484.0
2019-01-25 15:00:00	QQQ	ETF	165.2	165.32	164.84	165.25	6403433.0
2019-01-25 16:00:00	QQQ	ETF	165.25	165.3599	165.04	165.3	1921553.0
2019-01-25 17:00:00	QQQ	ETF	165.33	165.34	165.15	165.25	23538.0
2019-01-25 18:00:00	QQQ	ETF	165.2	165.3	165.2	165.25	5405.0
2019-01-25 19:00:00	QQQ	ETF	165.28	165.39	165.26	165.37	6441.0
2019-01-25 04:00:00	IWM	ETF	146.0	146.0	146.0	146.0	199.0
2019-01-25 05:00:00	IWM	ETF	146.15	146.15	146.1	146.1	6630.0
2019-01-25 06:00:00	IWM	ETF	146.09	146.22	146.09	146.22	2072.0
2019-01-25 07:00:00	IWM	ETF	146.13	146.17	146.05	146.11	21023.0
2019-01-25 08:00:00	IWM	ETF	145.99	146.56	145.99	146.45	41966.0
2019-01-25 09:00:00	IWM	ETF	146.48	147.31	146.41	146.84	2401026.0
2019-01-25 10:00:00	IWM	ETF	146.845	147.42	146.81	147.36	2889975.0
2019-01-25 11:00:00	IWM	ETF	147.36	147.51	147.03	147.401	1916226.0
2019-01-25 12:00:00	IWM	ETF	147.42	147.425	146.97	147.2	2300883.0
2019-01-25 13:00:00	IWM	ETF	147.2	147.42	147.17	147.37	1202207.0
2019-01-25 14:00:00	IWM	ETF	147.37	147.49	147.0201	147.38	2300837.0
2019-01-25 15:00:00	IWM	ETF	147.38	147.64	147.14	147.32	5017310.0
2019-01-25 16:00:00	IWM	ETF	147.33	147.4052	147.09	147.34	1784093.0
2019-01-25 17:00:00	IWM	ETF	147.34	147.34	147.34	147.34	113.0
2019-01-25 18:00:00	IWM	ETF	147.34	147.34	147.34	147.34	44509.0
2019-01-25 19:00:00	IWM	ETF	147.34	147.38	147.34	147.38	1212.0
2019-01-25 04:00:00	DIA	ETF	246.21	246.21	246.21	246.21	100.0
2019-01-25 05:00:00	DIA	ETF	246.5	246.52	246.5	246.52	300.0

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

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