PREVIEW / etf_1hour / 2019-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-17.parquet
  size:    325 KB
  rows:    10,706

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-04-17 04:00:00	SPY	ETF	290.52	290.71	290.52	290.68	14406.0
2019-04-17 05:00:00	SPY	ETF	290.69	290.81	290.66	290.79	13435.0
2019-04-17 06:00:00	SPY	ETF	290.82	290.82	290.72	290.76	30383.0
2019-04-17 07:00:00	SPY	ETF	290.7	290.95	290.7	290.89	96442.0
2019-04-17 08:00:00	SPY	ETF	290.7401	291.14	290.46	291.08	330316.0
2019-04-17 09:00:00	SPY	ETF	291.08	291.425	290.1	290.125	7383768.0
2019-04-17 10:00:00	SPY	ETF	290.125	290.31	289.58	289.82	8102869.0
2019-04-17 11:00:00	SPY	ETF	289.83	290.21	289.35	289.59	7033644.0
2019-04-17 12:00:00	SPY	ETF	289.58	289.84	289.2	289.73	4358306.0
2019-04-17 13:00:00	SPY	ETF	289.74	290.15	289.51	289.53	5132788.0
2019-04-17 14:00:00	SPY	ETF	289.53	289.64	288.99	289.49	5724617.0
2019-04-17 15:00:00	SPY	ETF	289.48	289.8	289.45	289.48	8963098.0
2019-04-17 16:00:00	SPY	ETF	289.49	289.5102	289.11	289.22	9956586.0
2019-04-17 17:00:00	SPY	ETF	289.225	289.45	289.11	289.18	89356.0
2019-04-17 18:00:00	SPY	ETF	289.19	289.34	289.17	289.33	121585.0
2019-04-17 19:00:00	SPY	ETF	289.33	289.42	289.29	289.4199	89005.0
2019-04-17 04:00:00	QQQ	ETF	186.95	187.06	186.95	187.0	6699.0
2019-04-17 05:00:00	QQQ	ETF	187.07	187.11	187.05	187.1	32478.0
2019-04-17 06:00:00	QQQ	ETF	187.1	187.17	187.1	187.11	19040.0
2019-04-17 07:00:00	QQQ	ETF	187.08	187.3	187.08	187.28	77757.0
2019-04-17 08:00:00	QQQ	ETF	187.1401	187.66	186.95	187.57	236155.0
2019-04-17 09:00:00	QQQ	ETF	187.58	187.93	187.045	187.0985	3201383.0
2019-04-17 10:00:00	QQQ	ETF	187.105	187.55	186.635	187.06	4207592.0
2019-04-17 11:00:00	QQQ	ETF	187.07	187.33	186.6	187.005	2476792.0
2019-04-17 12:00:00	QQQ	ETF	187.0	187.28	186.63	187.17	1996437.0
2019-04-17 13:00:00	QQQ	ETF	187.19	187.3785	187.03	187.12	2360710.0
2019-04-17 14:00:00	QQQ	ETF	187.12	187.18	186.6	187.0	2663331.0
2019-04-17 15:00:00	QQQ	ETF	186.99	187.24	186.84	187.14	4203816.0
2019-04-17 16:00:00	QQQ	ETF	187.15	187.16	186.77	186.81	1385396.0
2019-04-17 17:00:00	QQQ	ETF	186.77	187.15	186.75	187.15	45264.0
2019-04-17 18:00:00	QQQ	ETF	186.89	186.91	186.81	186.89	37880.0
2019-04-17 19:00:00	QQQ	ETF	186.9	187.0	186.87	187.0	16630.0
2019-04-17 04:00:00	IWM	ETF	157.75	157.75	157.75	157.75	100.0
2019-04-17 05:00:00	IWM	ETF	157.8	157.84	157.8	157.83	2100.0
2019-04-17 06:00:00	IWM	ETF	157.84	157.91	157.84	157.91	2000.0
2019-04-17 07:00:00	IWM	ETF	157.84	157.88	157.84	157.88	8300.0
2019-04-17 08:00:00	IWM	ETF	157.8601	157.98	157.83	157.93	10377.0
2019-04-17 09:00:00	IWM	ETF	157.89	158.14	156.38	156.4	1721409.0
2019-04-17 10:00:00	IWM	ETF	156.39	156.61	156.04	156.15	2750739.0
2019-04-17 11:00:00	IWM	ETF	156.17	156.68	155.78	155.97	1693186.0
2019-04-17 12:00:00	IWM	ETF	155.96	156.11	155.5	156.01	1514793.0
2019-04-17 13:00:00	IWM	ETF	156.02	156.14	155.64	155.69	1534708.0
2019-04-17 14:00:00	IWM	ETF	155.68	155.81	155.2	155.81	1520637.0
2019-04-17 15:00:00	IWM	ETF	155.81	156.17	155.81	156.03	3548096.0
2019-04-17 16:00:00	IWM	ETF	156.05	156.1	155.77	155.88	843525.0
2019-04-17 17:00:00	IWM	ETF	155.9	155.95	155.9	155.95	1400.0
2019-04-17 18:00:00	IWM	ETF	155.91	155.96	155.9	155.96	3900.0
2019-04-17 19:00:00	IWM	ETF	155.99	156.03	155.97	156.03	6060.0
2019-04-17 04:00:00	DIA	ETF	264.75	264.75	264.75	264.75	100.0
2019-04-17 05:00:00	DIA	ETF	264.74	264.74	264.74	264.74	200.0

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

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