PREVIEW / etf_1hour / 2020-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-11.parquet
  size:    359 KB
  rows:    11,838

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-11 04:00:00	SPY	ETF	335.48	335.55	335.1	335.44	14110.0
2020-02-11 05:00:00	SPY	ETF	335.5	335.75	335.5	335.7	16797.0
2020-02-11 06:00:00	SPY	ETF	335.7	335.73	335.43	335.47	41034.0
2020-02-11 07:00:00	SPY	ETF	335.44	335.94	335.44	335.84	102072.0
2020-02-11 08:00:00	SPY	ETF	335.53	336.04	335.4501	336.01	207443.0
2020-02-11 09:00:00	SPY	ETF	336.0	336.29	335.51	336.0114	5934108.0
2020-02-11 10:00:00	SPY	ETF	336.01	337.02	336.01	336.55	12252153.0
2020-02-11 11:00:00	SPY	ETF	336.555	336.71	335.62	335.8583	7222760.0
2020-02-11 12:00:00	SPY	ETF	335.85	336.3	335.76	336.29	2869287.0
2020-02-11 13:00:00	SPY	ETF	336.28	336.48	335.62	335.87	3691319.0
2020-02-11 14:00:00	SPY	ETF	335.87	335.9241	335.29	335.5	6356052.0
2020-02-11 15:00:00	SPY	ETF	335.51	335.685	334.75	335.29	10764970.0
2020-02-11 16:00:00	SPY	ETF	335.29	335.5	335.19	335.45	4499823.0
2020-02-11 17:00:00	SPY	ETF	335.43	335.54	335.36	335.53	97948.0
2020-02-11 18:00:00	SPY	ETF	335.58	335.82	335.48	335.66	41098.0
2020-02-11 19:00:00	SPY	ETF	335.64	335.76	335.13	335.35	47429.0
2020-02-11 04:00:00	QQQ	ETF	232.8	232.83	232.52	232.77	30266.0
2020-02-11 05:00:00	QQQ	ETF	232.78	233.05	232.78	232.96	37299.0
2020-02-11 06:00:00	QQQ	ETF	232.99	233.02	232.69	232.69	24733.0
2020-02-11 07:00:00	QQQ	ETF	232.72	233.16	232.72	233.06	90679.0
2020-02-11 08:00:00	QQQ	ETF	232.78	233.21	231.97	233.18	216226.0
2020-02-11 09:00:00	QQQ	ETF	233.16	233.37	232.3	232.77	3282096.0
2020-02-11 10:00:00	QQQ	ETF	232.7701	234.02	232.7701	233.78	4176078.0
2020-02-11 11:00:00	QQQ	ETF	233.75	233.98	232.65	232.8101	3505053.0
2020-02-11 12:00:00	QQQ	ETF	232.81	233.29	232.73	233.29	1903839.0
2020-02-11 13:00:00	QQQ	ETF	233.3	233.605	232.5333	232.66	2049625.0
2020-02-11 14:00:00	QQQ	ETF	232.665	232.7295	231.95	232.21	2766878.0
2020-02-11 15:00:00	QQQ	ETF	232.215	232.41	231.3999	231.98	4888853.0
2020-02-11 16:00:00	QQQ	ETF	231.99	232.18	231.93	232.14	1557557.0
2020-02-11 17:00:00	QQQ	ETF	232.08	232.19	232.07	232.15	10551.0
2020-02-11 18:00:00	QQQ	ETF	232.2	232.48	232.19	232.34	52974.0
2020-02-11 19:00:00	QQQ	ETF	232.35	232.49	231.95	232.2	65713.0
2020-02-11 04:00:00	IWM	ETF	166.28	166.28	166.17	166.17	278.0
2020-02-11 05:00:00	IWM	ETF	166.52	166.52	166.51	166.52	8700.0
2020-02-11 06:00:00	IWM	ETF	166.48	166.56	166.4	166.4	8555.0
2020-02-11 07:00:00	IWM	ETF	166.43	166.77	166.39	166.75	14200.0
2020-02-11 08:00:00	IWM	ETF	166.43	166.85	166.4	166.72	93293.0
2020-02-11 09:00:00	IWM	ETF	166.82	167.19	166.2679	167.11	1711567.0
2020-02-11 10:00:00	IWM	ETF	167.12	167.96	167.12	167.38	2535243.0
2020-02-11 11:00:00	IWM	ETF	167.38	167.5	166.65	167.06	1406315.0
2020-02-11 12:00:00	IWM	ETF	167.08	167.475	166.98	167.29	908624.0
2020-02-11 13:00:00	IWM	ETF	167.3	167.44	166.93	167.11	916745.0
2020-02-11 14:00:00	IWM	ETF	167.12	167.16	166.67	166.91	1098369.0
2020-02-11 15:00:00	IWM	ETF	166.92	167.05	166.57	166.97	2172400.0
2020-02-11 16:00:00	IWM	ETF	166.97	167.04	166.82	167.04	983696.0
2020-02-11 17:00:00	IWM	ETF	166.91	166.96	166.91	166.96	35279.0
2020-02-11 18:00:00	IWM	ETF	167.05	167.19	167.03	167.03	1897.0
2020-02-11 19:00:00	IWM	ETF	167.1	167.1	166.86	166.96	17600.0
2020-02-11 06:00:00	DIA	ETF	293.82	293.82	293.82	293.82	100.0
2020-02-11 07:00:00	DIA	ETF	293.81	294.08	293.75	294.08	8370.0

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

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