PREVIEW / etf_1hour / 2018-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-25.parquet
  size:    295 KB
  rows:    9,690

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-04-25 04:00:00	SPY	ETF	262.84	262.84	261.98	262.11	28559.0
2018-04-25 05:00:00	SPY	ETF	262.22	262.44	261.81	262.44	18058.0
2018-04-25 06:00:00	SPY	ETF	262.51	262.62	261.82	261.86	120536.0
2018-04-25 07:00:00	SPY	ETF	261.79	262.52	261.55	262.52	414676.0
2018-04-25 08:00:00	SPY	ETF	262.5	263.27	261.63	262.35	655810.0
2018-04-25 09:00:00	SPY	ETF	262.4	263.06	260.85	261.04	11701779.0
2018-04-25 10:00:00	SPY	ETF	261.05	262.93	260.93	262.6402	15839105.0
2018-04-25 11:00:00	SPY	ETF	262.64	263.2	261.83	261.87	9862731.0
2018-04-25 12:00:00	SPY	ETF	261.86	262.94	261.69	262.561	7433749.0
2018-04-25 13:00:00	SPY	ETF	262.57	263.44	262.25	263.17	9922018.0
2018-04-25 14:00:00	SPY	ETF	263.18	264.05	262.43	264.04	11062583.0
2018-04-25 15:00:00	SPY	ETF	264.04	264.13	262.66	263.57	18309356.0
2018-04-25 16:00:00	SPY	ETF	263.56	264.54	263.5255	264.37	15756854.0
2018-04-25 17:00:00	SPY	ETF	264.37	264.45	264.0	264.45	815242.0
2018-04-25 18:00:00	SPY	ETF	264.45	265.03	264.45	264.87	403271.0
2018-04-25 19:00:00	SPY	ETF	264.87	264.99	264.72	264.75	74055.0
2018-04-25 04:00:00	QQQ	ETF	158.6	158.6	157.81	158.0	87500.0
2018-04-25 05:00:00	QQQ	ETF	157.94	158.09	157.6	158.09	13800.0
2018-04-25 06:00:00	QQQ	ETF	158.16	158.35	157.87	157.87	101170.0
2018-04-25 07:00:00	QQQ	ETF	157.86	158.36	157.64	158.36	478730.0
2018-04-25 08:00:00	QQQ	ETF	157.8	158.75	157.67	158.48	502584.0
2018-04-25 09:00:00	QQQ	ETF	158.56	158.82	156.79	156.8	7772053.0
2018-04-25 10:00:00	QQQ	ETF	156.81	158.65	156.47	158.44	11256306.0
2018-04-25 11:00:00	QQQ	ETF	158.44	159.27	158.01	158.029	6799265.0
2018-04-25 12:00:00	QQQ	ETF	158.03	158.95	157.81	158.38	3138765.0
2018-04-25 13:00:00	QQQ	ETF	158.38	159.01	158.16	158.73	3353950.0
2018-04-25 14:00:00	QQQ	ETF	158.73	159.19	157.97	159.19	5031049.0
2018-04-25 15:00:00	QQQ	ETF	159.18	159.31	158.1	158.72	6481067.0
2018-04-25 16:00:00	QQQ	ETF	158.72	160.05	158.6317	159.9	1730497.0
2018-04-25 17:00:00	QQQ	ETF	159.87	160.29	159.82	160.27	247260.0
2018-04-25 18:00:00	QQQ	ETF	160.27	160.7	160.27	160.51	216336.0
2018-04-25 19:00:00	QQQ	ETF	160.48	160.68	160.4	160.57	62731.0
2018-04-25 04:00:00	IWM	ETF	154.22	154.22	154.01	154.01	3506.0
2018-04-25 05:00:00	IWM	ETF	154.0	154.25	154.0	154.25	3200.0
2018-04-25 06:00:00	IWM	ETF	154.37	154.37	153.84	153.84	2000.0
2018-04-25 07:00:00	IWM	ETF	153.85	154.33	153.77	154.31	98707.0
2018-04-25 08:00:00	IWM	ETF	154.33	154.4	154.08	154.18	26618.0
2018-04-25 09:00:00	IWM	ETF	154.25	154.46	152.97	153.14	3125637.0
2018-04-25 10:00:00	IWM	ETF	153.15	154.46	152.96	154.085	3818458.0
2018-04-25 11:00:00	IWM	ETF	154.08	154.45	153.61	153.62	1640445.0
2018-04-25 12:00:00	IWM	ETF	153.62	154.18	153.48	153.93	1128262.0
2018-04-25 13:00:00	IWM	ETF	153.93	154.47	153.82	154.27	1286313.0
2018-04-25 14:00:00	IWM	ETF	154.27	154.7	153.875	154.7	1657897.0
2018-04-25 15:00:00	IWM	ETF	154.69	154.8	153.85	154.19	2850082.0
2018-04-25 16:00:00	IWM	ETF	154.137	154.61	154.1163	154.41	4128415.0
2018-04-25 17:00:00	IWM	ETF	154.52	154.58	154.2	154.45	5937.0
2018-04-25 18:00:00	IWM	ETF	154.66	154.78	154.58	154.64	14623.0
2018-04-25 19:00:00	IWM	ETF	154.72	154.76	154.61	154.68	7884.0
2018-04-25 06:00:00	DIA	ETF	239.56	239.56	239.56	239.56	500.0
2018-04-25 07:00:00	DIA	ETF	238.92	240.16	238.78	240.0	10346.0

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

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