PREVIEW / etf_1hour / 2019-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-30.parquet
  size:    326 KB
  rows:    10,865

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-30 04:00:00	SPY	ETF	301.36	301.38	300.8	300.8	19604.0
2019-07-30 05:00:00	SPY	ETF	300.8	300.92	300.56	300.88	60084.0
2019-07-30 06:00:00	SPY	ETF	300.9	300.9	300.53	300.86	15649.0
2019-07-30 07:00:00	SPY	ETF	300.87	300.87	300.04	300.18	312778.0
2019-07-30 08:00:00	SPY	ETF	300.2	301.65	299.75	299.91	589584.0
2019-07-30 09:00:00	SPY	ETF	299.84	300.54	299.49	300.395	6829129.0
2019-07-30 10:00:00	SPY	ETF	300.395	300.72	300.15	300.57	5716198.0
2019-07-30 11:00:00	SPY	ETF	300.57	300.92	300.33	300.37	4055642.0
2019-07-30 12:00:00	SPY	ETF	300.37	300.77	300.29	300.38	2658541.0
2019-07-30 13:00:00	SPY	ETF	300.39	300.74	300.3335	300.66	2849314.0
2019-07-30 14:00:00	SPY	ETF	300.66	301.17	300.655	300.8	4586161.0
2019-07-30 15:00:00	SPY	ETF	300.81	300.94	300.4	300.82	12063724.0
2019-07-30 16:00:00	SPY	ETF	300.82	300.9	300.48	300.84	4343842.0
2019-07-30 17:00:00	SPY	ETF	300.88	300.96	300.72	300.92	417032.0
2019-07-30 18:00:00	SPY	ETF	300.92	300.99	300.85	300.89	179239.0
2019-07-30 19:00:00	SPY	ETF	300.9	300.96	300.75	300.91	33907.0
2019-07-30 04:00:00	QQQ	ETF	194.44	194.48	193.95	193.95	23297.0
2019-07-30 05:00:00	QQQ	ETF	193.9	193.97	193.8	193.92	25440.0
2019-07-30 06:00:00	QQQ	ETF	193.97	193.99	193.69	193.9	30840.0
2019-07-30 07:00:00	QQQ	ETF	193.93	193.93	193.11	193.3	207701.0
2019-07-30 08:00:00	QQQ	ETF	193.29	194.88	192.88	193.07	282704.0
2019-07-30 09:00:00	QQQ	ETF	193.05	193.88	192.99	193.6	3008233.0
2019-07-30 10:00:00	QQQ	ETF	193.6	194.04	193.51	193.74	2987665.0
2019-07-30 11:00:00	QQQ	ETF	193.76	194.05	193.53	193.58	1672627.0
2019-07-30 12:00:00	QQQ	ETF	193.58	193.88	193.53	193.65	955760.0
2019-07-30 13:00:00	QQQ	ETF	193.665	194.04	193.62	194.0	676864.0
2019-07-30 14:00:00	QQQ	ETF	194.02	194.54	194.01	194.04	2568129.0
2019-07-30 15:00:00	QQQ	ETF	194.04	194.13	193.52	193.79	3076511.0
2019-07-30 16:00:00	QQQ	ETF	193.8	194.37	193.37	194.32	1507753.0
2019-07-30 17:00:00	QQQ	ETF	194.32	194.42	194.26	194.37	107227.0
2019-07-30 18:00:00	QQQ	ETF	194.4	194.46	194.27	194.32	45917.0
2019-07-30 19:00:00	QQQ	ETF	194.34	194.34	194.18	194.34	63738.0
2019-07-30 05:00:00	IWM	ETF	155.69	155.76	155.65	155.65	900.0
2019-07-30 06:00:00	IWM	ETF	155.55	155.65	155.44	155.57	1700.0
2019-07-30 07:00:00	IWM	ETF	155.62	155.63	155.16	155.25	67275.0
2019-07-30 08:00:00	IWM	ETF	155.22	155.37	155.07	155.13	24593.0
2019-07-30 09:00:00	IWM	ETF	155.13	155.475	154.71	155.1	2841592.0
2019-07-30 10:00:00	IWM	ETF	155.09	156.05	155.03	155.85	2763103.0
2019-07-30 11:00:00	IWM	ETF	155.865	156.91	155.85	156.72	2558682.0
2019-07-30 12:00:00	IWM	ETF	156.72	157.085	156.61	156.94	1447409.0
2019-07-30 13:00:00	IWM	ETF	156.94	157.205	156.83	157.13	1313814.0
2019-07-30 14:00:00	IWM	ETF	157.13	157.54	157.12	157.425	1369616.0
2019-07-30 15:00:00	IWM	ETF	157.43	157.84	157.35	157.81	4821009.0
2019-07-30 16:00:00	IWM	ETF	157.82	157.84	157.56	157.61	894828.0
2019-07-30 17:00:00	IWM	ETF	157.42	157.65	157.42	157.5799	3529.0
2019-07-30 18:00:00	IWM	ETF	157.58	157.84	157.58	157.61	66971.0
2019-07-30 19:00:00	IWM	ETF	157.59	157.61	157.56	157.61	3101.0
2019-07-30 04:00:00	DIA	ETF	271.6	271.6	271.6	271.6	200.0
2019-07-30 05:00:00	DIA	ETF	271.56	271.56	271.56	271.56	100.0
2019-07-30 07:00:00	DIA	ETF	271.75	271.75	271.14	271.14	16607.0

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

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