PREVIEW / etf_1hour / 2019-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-24.parquet
  size:    330 KB
  rows:    10,858

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-07-24 04:00:00	SPY	ETF	299.35	299.47	298.9	298.95	15882.0
2019-07-24 05:00:00	SPY	ETF	298.95	299.15	298.87	298.95	16829.0
2019-07-24 06:00:00	SPY	ETF	299.05	299.39	299.05	299.39	44264.0
2019-07-24 07:00:00	SPY	ETF	299.38	299.43	299.2	299.26	137342.0
2019-07-24 08:00:00	SPY	ETF	299.2999	300.03	299.1	299.16	252513.0
2019-07-24 09:00:00	SPY	ETF	299.17	300.31	299.09	299.9393	4951610.0
2019-07-24 10:00:00	SPY	ETF	299.935	300.51	299.87	300.14	4856457.0
2019-07-24 11:00:00	SPY	ETF	300.15	300.16	299.7	299.84	4171788.0
2019-07-24 12:00:00	SPY	ETF	299.86	300.47	299.85	300.425	3601981.0
2019-07-24 13:00:00	SPY	ETF	300.42	300.47	300.225	300.41	3552310.0
2019-07-24 14:00:00	SPY	ETF	300.41	300.93	300.39	300.91	4763372.0
2019-07-24 15:00:00	SPY	ETF	300.91	301.42	300.8	301.38	12246060.0
2019-07-24 16:00:00	SPY	ETF	301.4	301.44	299.9604	300.98	6608141.0
2019-07-24 17:00:00	SPY	ETF	300.98	301.44	300.88	301.07	533751.0
2019-07-24 18:00:00	SPY	ETF	301.04	301.25	301.02	301.15	45453.0
2019-07-24 19:00:00	SPY	ETF	301.16	301.39	301.15	301.33	23536.0
2019-07-24 04:00:00	QQQ	ETF	193.23	193.23	192.79	192.88	39136.0
2019-07-24 05:00:00	QQQ	ETF	192.88	192.99	192.75	192.89	13204.0
2019-07-24 06:00:00	QQQ	ETF	192.9	193.33	192.9	193.3	20934.0
2019-07-24 07:00:00	QQQ	ETF	193.31	193.45	193.16	193.36	53409.0
2019-07-24 08:00:00	QQQ	ETF	193.25	193.79	192.98	193.14	169132.0
2019-07-24 09:00:00	QQQ	ETF	193.15	194.05	193.03	193.7783	2016616.0
2019-07-24 10:00:00	QQQ	ETF	193.8	194.4	193.655	194.02	1939699.0
2019-07-24 11:00:00	QQQ	ETF	194.02	194.26	193.78	194.01	1448211.0
2019-07-24 12:00:00	QQQ	ETF	194.01	194.39	193.99	194.32	1478035.0
2019-07-24 13:00:00	QQQ	ETF	194.33	194.36	194.09	194.285	1044382.0
2019-07-24 14:00:00	QQQ	ETF	194.28	194.76	194.2	194.76	2059784.0
2019-07-24 15:00:00	QQQ	ETF	194.77	195.16	194.71	195.15	5483760.0
2019-07-24 16:00:00	QQQ	ETF	195.15	195.78	194.56	194.58	2084668.0
2019-07-24 17:00:00	QQQ	ETF	194.55	194.99	194.34	194.75	180859.0
2019-07-24 18:00:00	QQQ	ETF	194.67	194.87	194.64	194.81	54067.0
2019-07-24 19:00:00	QQQ	ETF	194.79	194.95	194.79	194.94	19345.0
2019-07-24 06:00:00	IWM	ETF	154.16	154.18	154.16	154.18	2600.0
2019-07-24 07:00:00	IWM	ETF	154.24	154.35	154.2	154.2	39980.0
2019-07-24 08:00:00	IWM	ETF	154.32	154.39	154.24	154.28	72136.0
2019-07-24 09:00:00	IWM	ETF	154.35	155.07	154.12	154.82	2001616.0
2019-07-24 10:00:00	IWM	ETF	154.82	155.37	154.8	155.25	2076190.0
2019-07-24 11:00:00	IWM	ETF	155.25	155.27	154.9	155.1	1296103.0
2019-07-24 12:00:00	IWM	ETF	155.1016	156.2	155.09	156.11	3118193.0
2019-07-24 13:00:00	IWM	ETF	156.11	156.405	155.99	156.31	1777279.0
2019-07-24 14:00:00	IWM	ETF	156.315	156.85	156.21	156.85	2255015.0
2019-07-24 15:00:00	IWM	ETF	156.8571	157.45	156.72	157.26	6684906.0
2019-07-24 16:00:00	IWM	ETF	157.26	157.31	157.04	157.22	1994717.0
2019-07-24 17:00:00	IWM	ETF	157.2	157.33	157.16	157.26	42540.0
2019-07-24 18:00:00	IWM	ETF	157.26	157.33	157.26	157.29	16513.0
2019-07-24 19:00:00	IWM	ETF	157.26	157.37	157.26	157.37	7068.0
2019-07-24 04:00:00	DIA	ETF	272.92	272.92	272.92	272.92	600.0
2019-07-24 06:00:00	DIA	ETF	272.74	272.9	272.74	272.9	500.0
2019-07-24 07:00:00	DIA	ETF	272.82	272.94	272.56	272.56	960.0
2019-07-24 08:00:00	DIA	ETF	272.9	272.94	272.34	272.38	3800.0

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

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