PREVIEW / etf_1hour / 2019-07-19

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-19.parquet
  size:    329 KB
  rows:    10,861

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-19 04:00:00	SPY	ETF	299.79	299.97	299.71	299.77	10254.0
2019-07-19 05:00:00	SPY	ETF	299.62	299.69	299.15	299.25	9320.0
2019-07-19 06:00:00	SPY	ETF	299.15	299.29	298.97	299.09	15291.0
2019-07-19 07:00:00	SPY	ETF	299.07	299.47	298.95	299.34	144507.0
2019-07-19 08:00:00	SPY	ETF	299.07	299.88	298.99	299.73	162929.0
2019-07-19 09:00:00	SPY	ETF	299.68	300.08	299.38	299.61	7714971.0
2019-07-19 10:00:00	SPY	ETF	299.6	299.75	298.91	299.1454	7704339.0
2019-07-19 11:00:00	SPY	ETF	299.15	299.52	298.44	298.76	10308396.0
2019-07-19 12:00:00	SPY	ETF	298.755	299.42	298.73	299.31	5302849.0
2019-07-19 13:00:00	SPY	ETF	299.32	299.35	298.72	299.02	3402166.0
2019-07-19 14:00:00	SPY	ETF	299.02	299.24	297.94	298.26	6637237.0
2019-07-19 15:00:00	SPY	ETF	298.2715	298.2725	296.96	297.12	15591811.0
2019-07-19 16:00:00	SPY	ETF	297.16	299.4	296.17	296.23	11838615.0
2019-07-19 17:00:00	SPY	ETF	296.28	297.17	296.22	296.48	117295.0
2019-07-19 18:00:00	SPY	ETF	296.48	296.59	296.32	296.34	48523.0
2019-07-19 19:00:00	SPY	ETF	296.35	296.4	296.2	296.36	80500.0
2019-07-19 04:00:00	QQQ	ETF	193.68	193.79	193.6	193.7	15900.0
2019-07-19 05:00:00	QQQ	ETF	193.6	193.66	193.34	193.42	13690.0
2019-07-19 06:00:00	QQQ	ETF	193.27	193.36	193.06	193.09	16067.0
2019-07-19 07:00:00	QQQ	ETF	193.09	193.36	192.97	193.29	120094.0
2019-07-19 08:00:00	QQQ	ETF	193.28	193.6	192.97	193.6	80641.0
2019-07-19 09:00:00	QQQ	ETF	193.58	193.98	193.06	193.25	2756527.0
2019-07-19 10:00:00	QQQ	ETF	193.24	193.37	192.46	192.72	2660269.0
2019-07-19 11:00:00	QQQ	ETF	192.73	193.13	192.06	192.35	2876646.0
2019-07-19 12:00:00	QQQ	ETF	192.34	192.95	192.34	192.78	1442047.0
2019-07-19 13:00:00	QQQ	ETF	192.79	192.8	192.24	192.5	1104100.0
2019-07-19 14:00:00	QQQ	ETF	192.49	192.67	191.4475	191.71	3247129.0
2019-07-19 15:00:00	QQQ	ETF	191.7	191.7	190.81	190.91	5296232.0
2019-07-19 16:00:00	QQQ	ETF	190.92	191.01	190.05	190.12	2423137.0
2019-07-19 17:00:00	QQQ	ETF	190.21	191.01	190.09	190.3	157454.0
2019-07-19 18:00:00	QQQ	ETF	190.3	190.4	190.3	190.38	13343.0
2019-07-19 19:00:00	QQQ	ETF	190.39	190.4	190.2	190.38	17771.0
2019-07-19 05:00:00	IWM	ETF	154.96	154.96	154.79	154.79	2800.0
2019-07-19 06:00:00	IWM	ETF	154.71	154.71	154.53	154.57	15990.0
2019-07-19 07:00:00	IWM	ETF	154.56	154.79	154.53	154.73	68296.0
2019-07-19 08:00:00	IWM	ETF	154.56	154.84	154.5	154.83	57167.0
2019-07-19 09:00:00	IWM	ETF	154.82	155.3	154.595	155.11	1792140.0
2019-07-19 10:00:00	IWM	ETF	155.1	155.43	154.8	154.97	2271201.0
2019-07-19 11:00:00	IWM	ETF	154.975	155.14	154.565	154.89	2112478.0
2019-07-19 12:00:00	IWM	ETF	154.88	155.21	154.88	155.015	788177.0
2019-07-19 13:00:00	IWM	ETF	155.02	155.16	154.94	155.145	868065.0
2019-07-19 14:00:00	IWM	ETF	155.14	155.21	154.49	154.69	1450830.0
2019-07-19 15:00:00	IWM	ETF	154.69	154.69	153.83	153.88	3079378.0
2019-07-19 16:00:00	IWM	ETF	153.88	154.0	153.49	153.49	1553309.0
2019-07-19 17:00:00	IWM	ETF	153.46	153.62	153.3	153.6	15537.0
2019-07-19 18:00:00	IWM	ETF	153.55	153.56	153.52	153.52	8158.0
2019-07-19 19:00:00	IWM	ETF	153.52	153.54	153.35	153.54	1530.0
2019-07-19 05:00:00	DIA	ETF	272.9	272.93	272.9	272.93	200.0
2019-07-19 06:00:00	DIA	ETF	272.45	272.45	272.45	272.45	150.0
2019-07-19 07:00:00	DIA	ETF	272.4	272.78	272.34	272.78	8986.0

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

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