PREVIEW / etf_1hour / 2019-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-05.parquet
  size:    345 KB
  rows:    11,370

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-11-05 04:00:00	SPY	ETF	307.86	308.1	307.86	307.93	62379.0
2019-11-05 05:00:00	SPY	ETF	308.04	308.21	308.04	308.12	18635.0
2019-11-05 06:00:00	SPY	ETF	308.13	308.13	307.75	307.86	57491.0
2019-11-05 07:00:00	SPY	ETF	307.82	308.04	307.8	307.92	102163.0
2019-11-05 08:00:00	SPY	ETF	307.9899	308.09	307.37	308.05	438880.0
2019-11-05 09:00:00	SPY	ETF	308.04	308.13	307.2096	307.38	4122470.0
2019-11-05 10:00:00	SPY	ETF	307.46	307.9195	306.71	306.91	7468087.0
2019-11-05 11:00:00	SPY	ETF	306.93	307.32	306.83	307.01	4102417.0
2019-11-05 12:00:00	SPY	ETF	307.02	307.3	306.72	307.295	4869600.0
2019-11-05 13:00:00	SPY	ETF	307.29	307.42	307.17	307.31	3063164.0
2019-11-05 14:00:00	SPY	ETF	307.315	307.5	307.24	307.38	2211106.0
2019-11-05 15:00:00	SPY	ETF	307.385	307.41	306.836	307.0	12101364.0
2019-11-05 16:00:00	SPY	ETF	307.0	307.06	306.81	306.87	2881216.0
2019-11-05 17:00:00	SPY	ETF	306.87	307.03	306.74	306.83	387526.0
2019-11-05 18:00:00	SPY	ETF	306.84	306.97	306.78	306.88	72247.0
2019-11-05 19:00:00	SPY	ETF	306.89	306.95	306.57	306.57	45754.0
2019-11-05 04:00:00	QQQ	ETF	200.68	200.78	200.65	200.7	18500.0
2019-11-05 05:00:00	QQQ	ETF	200.77	200.89	200.77	200.83	16313.0
2019-11-05 06:00:00	QQQ	ETF	200.83	200.83	200.52	200.65	9205.0
2019-11-05 07:00:00	QQQ	ETF	200.6	200.73	200.58	200.61	40522.0
2019-11-05 08:00:00	QQQ	ETF	200.67	200.6998	200.52	200.64	69586.0
2019-11-05 09:00:00	QQQ	ETF	200.66	200.72	199.94	200.17	2000319.0
2019-11-05 10:00:00	QQQ	ETF	200.18	200.55	199.55	199.91	3126495.0
2019-11-05 11:00:00	QQQ	ETF	199.93	200.356	199.925	200.29	1643309.0
2019-11-05 12:00:00	QQQ	ETF	200.2701	200.465	200.16	200.41	1050253.0
2019-11-05 13:00:00	QQQ	ETF	200.41	200.51	200.32	200.4	1092853.0
2019-11-05 14:00:00	QQQ	ETF	200.4087	200.54	200.33	200.4	964742.0
2019-11-05 15:00:00	QQQ	ETF	200.41	200.46	200.01	200.11	2330133.0
2019-11-05 16:00:00	QQQ	ETF	200.08	200.21	199.94	199.99	750749.0
2019-11-05 17:00:00	QQQ	ETF	199.99	200.03	199.91	199.98	17099.0
2019-11-05 18:00:00	QQQ	ETF	199.98	200.09	199.94	200.03	33849.0
2019-11-05 19:00:00	QQQ	ETF	200.0	200.06	199.85	199.86	17607.0
2019-11-05 04:00:00	IWM	ETF	159.39	159.39	159.39	159.39	100.0
2019-11-05 05:00:00	IWM	ETF	159.48	159.51	159.48	159.48	9000.0
2019-11-05 06:00:00	IWM	ETF	159.47	159.47	159.33	159.33	2600.0
2019-11-05 07:00:00	IWM	ETF	159.42	159.59	159.42	159.49	37545.0
2019-11-05 08:00:00	IWM	ETF	159.45	159.64	159.45	159.64	44869.0
2019-11-05 09:00:00	IWM	ETF	159.65	159.82	159.28	159.76	1741153.0
2019-11-05 10:00:00	IWM	ETF	159.755	160.46	159.145	159.39	2942232.0
2019-11-05 11:00:00	IWM	ETF	159.39	159.735	159.25	159.29	964193.0
2019-11-05 12:00:00	IWM	ETF	159.28	159.37	158.97	159.2947	1283065.0
2019-11-05 13:00:00	IWM	ETF	159.29	159.39	159.13	159.36	767103.0
2019-11-05 14:00:00	IWM	ETF	159.35	159.5	159.21	159.34	651088.0
2019-11-05 15:00:00	IWM	ETF	159.35	159.355	159.01	159.11	2049506.0
2019-11-05 16:00:00	IWM	ETF	159.11	159.15	158.98	159.02	797104.0
2019-11-05 17:00:00	IWM	ETF	158.99	159.15	158.99	158.99	5720.0
2019-11-05 18:00:00	IWM	ETF	158.99	159.15	158.97	159.07	11658.0
2019-11-05 19:00:00	IWM	ETF	159.0	159.0	158.84	158.84	17800.0
2019-11-05 07:00:00	DIA	ETF	274.98	275.16	274.98	275.16	3335.0
2019-11-05 08:00:00	DIA	ETF	275.14	275.29	275.12	275.2	5680.0

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

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