PREVIEW / etf_1hour / 2018-03-15

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-15.parquet
  size:    292 KB
  rows:    9,547

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-03-15 04:00:00	SPY	ETF	275.92	276.18	275.6	275.64	14534.0
2018-03-15 05:00:00	SPY	ETF	275.88	275.99	275.78	275.8	21820.0
2018-03-15 06:00:00	SPY	ETF	275.62	275.62	275.13	275.13	36639.0
2018-03-15 07:00:00	SPY	ETF	275.18	275.6	275.12	275.42	206345.0
2018-03-15 08:00:00	SPY	ETF	275.21	275.99	275.21	275.65	239053.0
2018-03-15 09:00:00	SPY	ETF	275.66	275.98	275.02	275.255	6070504.0
2018-03-15 10:00:00	SPY	ETF	275.26	275.92	275.23	275.72	8451105.0
2018-03-15 11:00:00	SPY	ETF	275.73	276.61	275.48	275.81	9582131.0
2018-03-15 12:00:00	SPY	ETF	275.82	276.07	275.45	275.585	6774796.0
2018-03-15 13:00:00	SPY	ETF	275.58	275.77	274.55	274.5575	7336604.0
2018-03-15 14:00:00	SPY	ETF	274.56	275.09	274.43	275.06	9735203.0
2018-03-15 15:00:00	SPY	ETF	275.06	275.39	274.7	275.01	14920692.0
2018-03-15 16:00:00	SPY	ETF	275.01	275.65	274.9022	275.57	12004538.0
2018-03-15 17:00:00	SPY	ETF	275.63	275.64	275.0	275.49	615509.0
2018-03-15 18:00:00	SPY	ETF	275.5	275.64	275.0	275.5	2235556.0
2018-03-15 19:00:00	SPY	ETF	275.5	275.69	275.49	275.67	55460.0
2018-03-15 04:00:00	QQQ	ETF	171.84	171.85	171.7	171.7	20980.0
2018-03-15 05:00:00	QQQ	ETF	171.62	171.89	171.62	171.79	16651.0
2018-03-15 06:00:00	QQQ	ETF	171.79	171.79	171.32	171.39	36296.0
2018-03-15 07:00:00	QQQ	ETF	171.39	171.56	171.29	171.45	153849.0
2018-03-15 08:00:00	QQQ	ETF	171.39	171.75	171.31	171.63	181164.0
2018-03-15 09:00:00	QQQ	ETF	171.63	171.91	171.03	171.45	2709648.0
2018-03-15 10:00:00	QQQ	ETF	171.4524	172.091	171.45	172.0	3344153.0
2018-03-15 11:00:00	QQQ	ETF	172.02	172.53	171.95	172.09	3608245.0
2018-03-15 12:00:00	QQQ	ETF	172.1199	172.179	171.63	171.84	2326419.0
2018-03-15 13:00:00	QQQ	ETF	171.84	171.94	171.0	171.01	2920246.0
2018-03-15 14:00:00	QQQ	ETF	171.01	171.53	170.9	171.51	2671505.0
2018-03-15 15:00:00	QQQ	ETF	171.5	171.7	171.26	171.43	3822657.0
2018-03-15 16:00:00	QQQ	ETF	171.44	171.94	171.42	171.94	1084157.0
2018-03-15 17:00:00	QQQ	ETF	171.95	171.96	171.53	171.85	1824660.0
2018-03-15 18:00:00	QQQ	ETF	171.82	172.0	171.53	171.96	21355.0
2018-03-15 19:00:00	QQQ	ETF	171.95	172.1	171.95	172.05	25540.0
2018-03-15 04:00:00	IWM	ETF	157.94	157.96	157.76	157.87	11431.0
2018-03-15 05:00:00	IWM	ETF	157.92	157.95	157.92	157.95	600.0
2018-03-15 06:00:00	IWM	ETF	157.81	157.81	157.56	157.67	6200.0
2018-03-15 07:00:00	IWM	ETF	157.59	157.8	157.51	157.76	12141.0
2018-03-15 08:00:00	IWM	ETF	157.75	157.97	157.62	157.89	368090.0
2018-03-15 09:00:00	IWM	ETF	157.9	158.14	157.12	157.1865	1591631.0
2018-03-15 10:00:00	IWM	ETF	157.19	157.68	157.03	157.27	2158000.0
2018-03-15 11:00:00	IWM	ETF	157.28	157.92	157.24	157.37	1492053.0
2018-03-15 12:00:00	IWM	ETF	157.35	157.46	156.81	157.05	1113442.0
2018-03-15 13:00:00	IWM	ETF	157.04	157.2	156.71	156.72	1048489.0
2018-03-15 14:00:00	IWM	ETF	156.7	156.8	156.37	156.73	1230567.0
2018-03-15 15:00:00	IWM	ETF	156.73	157.01	156.5	156.91	2524120.0
2018-03-15 16:00:00	IWM	ETF	156.92	157.83	156.8815	157.28	1359209.0
2018-03-15 17:00:00	IWM	ETF	156.92	157.27	156.92	157.27	130848.0
2018-03-15 18:00:00	IWM	ETF	157.2	157.3	157.2	157.3	2800.0
2018-03-15 19:00:00	IWM	ETF	157.23	157.38	157.23	157.37	2400.0
2018-03-15 04:00:00	DIA	ETF	248.24	248.75	248.24	248.75	200.0
2018-03-15 06:00:00	DIA	ETF	248.79	248.79	248.2	248.2	1791.0

> showing 50 of 9,547 rows — these rows as CSV

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