PREVIEW / etf_1hour / 2019-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-29.parquet
  size:    332 KB
  rows:    10,951

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-05-29 04:00:00	SPY	ETF	278.94	279.12	278.68	278.84	35985.0
2019-05-29 05:00:00	SPY	ETF	278.75	278.81	278.28	278.8	34510.0
2019-05-29 06:00:00	SPY	ETF	278.75	279.3	278.68	279.24	107058.0
2019-05-29 07:00:00	SPY	ETF	279.24	279.3	278.8	278.97	486515.0
2019-05-29 08:00:00	SPY	ETF	278.95	279.93	278.5	278.78	830665.0
2019-05-29 09:00:00	SPY	ETF	278.8	279.04	277.9775	278.435	11150407.0
2019-05-29 10:00:00	SPY	ETF	278.435	279.36	278.1114	278.295	13249801.0
2019-05-29 11:00:00	SPY	ETF	278.29	278.93	276.71	277.0	17010225.0
2019-05-29 12:00:00	SPY	ETF	277.0	277.99	276.8275	277.4312	12039478.0
2019-05-29 13:00:00	SPY	ETF	277.4399	278.64	277.24	278.2	8978326.0
2019-05-29 14:00:00	SPY	ETF	278.205	278.53	277.11	277.52	8491566.0
2019-05-29 15:00:00	SPY	ETF	277.52	278.84	276.96	278.34	20766540.0
2019-05-29 16:00:00	SPY	ETF	278.33	278.4223	278.02	278.16	10275799.0
2019-05-29 17:00:00	SPY	ETF	278.15	278.21	278.01	278.05	273858.0
2019-05-29 18:00:00	SPY	ETF	278.06	278.62	278.05	278.54	225896.0
2019-05-29 19:00:00	SPY	ETF	278.54	278.55	278.2	278.28	62942.0
2019-05-29 04:00:00	QQQ	ETF	176.38	176.5	176.2	176.3	30457.0
2019-05-29 05:00:00	QQQ	ETF	176.39	176.4	175.96	176.34	69057.0
2019-05-29 06:00:00	QQQ	ETF	176.29	176.62	176.24	176.61	60108.0
2019-05-29 07:00:00	QQQ	ETF	176.61	176.65	176.29	176.46	158175.0
2019-05-29 08:00:00	QQQ	ETF	176.44	177.09	176.08	176.33	251847.0
2019-05-29 09:00:00	QQQ	ETF	176.34	176.6	175.8	176.2	4457488.0
2019-05-29 10:00:00	QQQ	ETF	176.2	177.0	175.952	176.14	5413929.0
2019-05-29 11:00:00	QQQ	ETF	176.14	176.55	175.09	175.37	5855720.0
2019-05-29 12:00:00	QQQ	ETF	175.37	175.97	175.2028	175.61	3199182.0
2019-05-29 13:00:00	QQQ	ETF	175.6	176.59	175.475	176.245	3289030.0
2019-05-29 14:00:00	QQQ	ETF	176.26	176.47	175.3309	175.65	3358140.0
2019-05-29 15:00:00	QQQ	ETF	175.6492	176.43	175.27	176.07	7801186.0
2019-05-29 16:00:00	QQQ	ETF	176.07	176.19	175.85	175.88	1932953.0
2019-05-29 17:00:00	QQQ	ETF	175.85	175.88	175.71	175.88	10347.0
2019-05-29 18:00:00	QQQ	ETF	175.83	176.24	175.83	176.23	82893.0
2019-05-29 19:00:00	QQQ	ETF	176.28	176.28	176.03	176.03	62519.0
2019-05-29 04:00:00	IWM	ETF	149.0	149.0	148.87	148.87	3300.0
2019-05-29 05:00:00	IWM	ETF	148.77	148.83	148.6	148.83	6250.0
2019-05-29 06:00:00	IWM	ETF	148.85	149.08	148.85	149.08	10112.0
2019-05-29 07:00:00	IWM	ETF	149.11	149.11	148.83	148.91	48240.0
2019-05-29 08:00:00	IWM	ETF	148.95	149.09	148.52	148.68	82535.0
2019-05-29 09:00:00	IWM	ETF	148.69	148.9	147.71	148.22	2569047.0
2019-05-29 10:00:00	IWM	ETF	148.21	148.93	148.09	148.4	3290785.0
2019-05-29 11:00:00	IWM	ETF	148.36	148.62	147.36	147.51	2700612.0
2019-05-29 12:00:00	IWM	ETF	147.51	148.3	147.41	147.98	1682843.0
2019-05-29 13:00:00	IWM	ETF	147.99	148.83	147.85	148.5	2602121.0
2019-05-29 14:00:00	IWM	ETF	148.49	148.67	147.72	147.91	1274892.0
2019-05-29 15:00:00	IWM	ETF	147.92	148.75	147.58	148.32	4117044.0
2019-05-29 16:00:00	IWM	ETF	148.32	148.43	148.12	148.22	1101680.0
2019-05-29 17:00:00	IWM	ETF	148.21	148.28	148.16	148.27	3063.0
2019-05-29 18:00:00	IWM	ETF	148.34	148.5	148.27	148.47	76718.0
2019-05-29 19:00:00	IWM	ETF	148.49	148.49	148.3	148.3	7920.0
2019-05-29 04:00:00	DIA	ETF	252.0	252.1	252.0	252.1	1139.0
2019-05-29 06:00:00	DIA	ETF	252.08	252.42	252.08	252.42	3500.0

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

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