PREVIEW / etf_1hour / 2020-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-06.parquet
  size:    370 KB
  rows:    12,566

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
2020-08-06 04:00:00	SPY	ETF	332.25	332.26	331.65	331.83	7380.0
2020-08-06 05:00:00	SPY	ETF	331.73	332.08	331.73	332.06	18735.0
2020-08-06 06:00:00	SPY	ETF	332.04	332.05	330.67	330.85	54365.0
2020-08-06 07:00:00	SPY	ETF	330.85	331.24	330.15	330.49	265801.0
2020-08-06 08:00:00	SPY	ETF	330.6699	331.9504	330.13	331.72	949879.0
2020-08-06 09:00:00	SPY	ETF	331.73	332.32	331.39	332.28	4214272.0
2020-08-06 10:00:00	SPY	ETF	332.295	332.64	331.13	331.75	5095575.0
2020-08-06 11:00:00	SPY	ETF	331.75	332.2999	331.28	331.66	4230359.0
2020-08-06 12:00:00	SPY	ETF	331.655	332.46	331.59	332.42	4044610.0
2020-08-06 13:00:00	SPY	ETF	332.425	332.9	332.27	332.81	2613127.0
2020-08-06 14:00:00	SPY	ETF	332.815	334.15	332.77	333.995	5219156.0
2020-08-06 15:00:00	SPY	ETF	334.0	334.46	333.66	334.31	13042997.0
2020-08-06 16:00:00	SPY	ETF	334.3	334.55	334.23	334.4	2414322.0
2020-08-06 17:00:00	SPY	ETF	334.46	334.46	334.24	334.34	78487.0
2020-08-06 18:00:00	SPY	ETF	334.37	334.44	334.11	334.26	114704.0
2020-08-06 19:00:00	SPY	ETF	334.22	334.29	334.1	334.16	35533.0
2020-08-06 04:00:00	QQQ	ETF	270.89	270.89	270.47	270.58	10685.0
2020-08-06 05:00:00	QQQ	ETF	270.77	270.79	270.54	270.67	8816.0
2020-08-06 06:00:00	QQQ	ETF	270.61	270.71	269.79	269.95	46601.0
2020-08-06 07:00:00	QQQ	ETF	269.95	270.47	269.67	270.26	105921.0
2020-08-06 08:00:00	QQQ	ETF	270.27	271.13	269.7099	270.98	424123.0
2020-08-06 09:00:00	QQQ	ETF	270.92	271.31	270.19	271.27	2549970.0
2020-08-06 10:00:00	QQQ	ETF	271.28	271.97	270.36	271.135	2792046.0
2020-08-06 11:00:00	QQQ	ETF	271.11	271.8	270.99	271.46	2306126.0
2020-08-06 12:00:00	QQQ	ETF	271.44	272.62	271.3799	272.6	1891990.0
2020-08-06 13:00:00	QQQ	ETF	272.6	273.21	272.3302	273.13	2159263.0
2020-08-06 14:00:00	QQQ	ETF	273.14	274.61	273.1	274.455	3343860.0
2020-08-06 15:00:00	QQQ	ETF	274.46	274.98	274.04	274.585	5372755.0
2020-08-06 16:00:00	QQQ	ETF	274.58	274.82	274.44	274.69	1238592.0
2020-08-06 17:00:00	QQQ	ETF	274.59	274.84	274.58	274.72	77475.0
2020-08-06 18:00:00	QQQ	ETF	274.73	274.73	274.46	274.5	56167.0
2020-08-06 19:00:00	QQQ	ETF	274.54	274.64	274.45	274.51	36876.0
2020-08-06 04:00:00	IWM	ETF	154.4	154.4	153.97	154.09	3560.0
2020-08-06 05:00:00	IWM	ETF	154.15	154.25	154.0	154.25	6783.0
2020-08-06 06:00:00	IWM	ETF	154.16	154.19	153.17	153.26	12800.0
2020-08-06 07:00:00	IWM	ETF	153.27	153.65	152.9	153.18	56596.0
2020-08-06 08:00:00	IWM	ETF	153.19	154.01	152.9	153.89	172932.0
2020-08-06 09:00:00	IWM	ETF	153.96	154.25	153.56	154.19	1717778.0
2020-08-06 10:00:00	IWM	ETF	154.195	154.44	153.24	153.7	2553043.0
2020-08-06 11:00:00	IWM	ETF	153.69	153.8	152.96	153.35	2060224.0
2020-08-06 12:00:00	IWM	ETF	153.35	153.51	153.04	153.465	1102144.0
2020-08-06 13:00:00	IWM	ETF	153.46	153.5	152.91	153.06	1207214.0
2020-08-06 14:00:00	IWM	ETF	153.065	153.96	153.04	153.935	2131323.0
2020-08-06 15:00:00	IWM	ETF	153.93	154.05	153.46	153.74	3486252.0
2020-08-06 16:00:00	IWM	ETF	153.73	153.9	153.73	153.8	476997.0
2020-08-06 17:00:00	IWM	ETF	153.77	153.84	153.7	153.78	22462.0
2020-08-06 18:00:00	IWM	ETF	153.84	153.84	153.62	153.67	80604.0
2020-08-06 19:00:00	IWM	ETF	153.76	153.76	153.6	153.6	2984.0
2020-08-06 04:00:00	DIA	ETF	272.72	272.72	271.9	271.9	700.0
2020-08-06 05:00:00	DIA	ETF	272.21	272.21	272.19	272.19	338.0

> showing 50 of 12,566 rows — these rows as CSV

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