PREVIEW / etf_1hour / 2020-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-07.parquet
  size:    356 KB
  rows:    11,825

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-02-07 04:00:00	SPY	ETF	333.78	333.81	333.08	333.08	43212.0
2020-02-07 05:00:00	SPY	ETF	333.15	333.15	332.56	332.56	20190.0
2020-02-07 06:00:00	SPY	ETF	332.5	332.97	332.34	332.96	41393.0
2020-02-07 07:00:00	SPY	ETF	333.0	333.28	332.93	333.28	106605.0
2020-02-07 08:00:00	SPY	ETF	333.18	334.2	332.56	332.87	1317554.0
2020-02-07 09:00:00	SPY	ETF	332.83	333.1	331.96	332.29	6783715.0
2020-02-07 10:00:00	SPY	ETF	332.29	333.9941	331.93	332.83	7095952.0
2020-02-07 11:00:00	SPY	ETF	332.84	333.62	332.6	333.18	5550849.0
2020-02-07 12:00:00	SPY	ETF	333.19	333.49	333.02	333.21	6035824.0
2020-02-07 13:00:00	SPY	ETF	333.21	333.21	332.27	332.27	5455175.0
2020-02-07 14:00:00	SPY	ETF	332.28	332.41	331.6	332.35	9532425.0
2020-02-07 15:00:00	SPY	ETF	332.36	332.64	331.83	332.2	11661059.0
2020-02-07 16:00:00	SPY	ETF	332.21	332.33	331.86	331.87	7420053.0
2020-02-07 17:00:00	SPY	ETF	332.03	332.09	331.6	331.77	1767396.0
2020-02-07 18:00:00	SPY	ETF	331.73	331.79	331.55	331.62	38959.0
2020-02-07 19:00:00	SPY	ETF	331.69	331.76	331.6	331.68	22148.0
2020-02-07 04:00:00	QQQ	ETF	229.97	230.0	229.34	229.36	59928.0
2020-02-07 05:00:00	QQQ	ETF	229.43	229.43	228.94	228.99	84182.0
2020-02-07 06:00:00	QQQ	ETF	228.95	229.4	228.8	229.38	61225.0
2020-02-07 07:00:00	QQQ	ETF	229.38	229.63	229.35	229.57	101633.0
2020-02-07 08:00:00	QQQ	ETF	229.42	230.37	228.96	229.22	717333.0
2020-02-07 09:00:00	QQQ	ETF	229.2	229.48	228.54	228.87	2940558.0
2020-02-07 10:00:00	QQQ	ETF	228.87	229.86	228.61	229.58	3323002.0
2020-02-07 11:00:00	QQQ	ETF	229.5899	230.44	229.36	230.16	2401885.0
2020-02-07 12:00:00	QQQ	ETF	230.16	230.42	230.0301	230.1798	1149901.0
2020-02-07 13:00:00	QQQ	ETF	230.17	230.19	229.23	229.23	2103603.0
2020-02-07 14:00:00	QQQ	ETF	229.23	229.33	228.55	229.28	3461236.0
2020-02-07 15:00:00	QQQ	ETF	229.27	229.36	228.79	229.17	4012232.0
2020-02-07 16:00:00	QQQ	ETF	229.17	229.23	228.9	228.91	890376.0
2020-02-07 17:00:00	QQQ	ETF	228.93	229.07	228.81	228.84	13028.0
2020-02-07 18:00:00	QQQ	ETF	228.86	229.0	228.78	228.9	18562.0
2020-02-07 19:00:00	QQQ	ETF	228.9	228.9	228.75	228.84	30804.0
2020-02-07 04:00:00	IWM	ETF	166.54	166.54	166.54	166.54	1400.0
2020-02-07 05:00:00	IWM	ETF	166.37	166.45	166.24	166.24	6015.0
2020-02-07 06:00:00	IWM	ETF	166.1	166.4	166.1	166.35	5500.0
2020-02-07 07:00:00	IWM	ETF	166.57	166.65	166.48	166.65	14900.0
2020-02-07 08:00:00	IWM	ETF	166.51	167.11	166.23	166.36	105153.0
2020-02-07 09:00:00	IWM	ETF	166.35	166.45	165.21	165.34	2990555.0
2020-02-07 10:00:00	IWM	ETF	165.34	165.78	165.06	165.32	2027083.0
2020-02-07 11:00:00	IWM	ETF	165.29	165.68	165.03	165.48	1705914.0
2020-02-07 12:00:00	IWM	ETF	165.475	165.64	165.22	165.38	833515.0
2020-02-07 13:00:00	IWM	ETF	165.385	165.42	164.71	164.71	1290147.0
2020-02-07 14:00:00	IWM	ETF	164.709	164.81	164.4	164.77	1770506.0
2020-02-07 15:00:00	IWM	ETF	164.79	164.97	164.6	164.88	2796518.0
2020-02-07 16:00:00	IWM	ETF	164.87	164.94	164.7	164.79	830702.0
2020-02-07 17:00:00	IWM	ETF	164.73	164.78	164.73	164.78	379.0
2020-02-07 18:00:00	IWM	ETF	164.72	164.72	164.71	164.71	1940.0
2020-02-07 19:00:00	IWM	ETF	164.81	164.81	164.75	164.76	2800.0
2020-02-07 04:00:00	DIA	ETF	293.05	293.05	293.05	293.05	200.0
2020-02-07 05:00:00	DIA	ETF	292.89	292.89	292.4	292.4	752.0

> showing 50 of 11,825 rows — these rows as CSV

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