PREVIEW / etf_1hour / 2018-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-23.parquet
  size:    196 KB
  rows:    6,161

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
2018-11-23 04:00:00	SPY	ETF	264.39	264.56	264.28	264.56	13303.0
2018-11-23 05:00:00	SPY	ETF	264.58	264.64	263.65	263.82	22315.0
2018-11-23 06:00:00	SPY	ETF	263.79	264.0	263.55	263.79	20422.0
2018-11-23 07:00:00	SPY	ETF	263.74	264.08	263.55	264.0	154700.0
2018-11-23 08:00:00	SPY	ETF	263.71	264.55	262.68	263.06	841107.0
2018-11-23 09:00:00	SPY	ETF	263.02	264.35	262.79	264.11	7799479.0
2018-11-23 10:00:00	SPY	ETF	264.1	264.41	263.43	264.1675	8408643.0
2018-11-23 11:00:00	SPY	ETF	264.17	264.8234	263.69	263.755	6655705.0
2018-11-23 12:00:00	SPY	ETF	263.74	264.3	263.24	263.36	13511256.0
2018-11-23 13:00:00	SPY	ETF	263.37	263.9757	262.87	262.87	3850045.0
2018-11-23 14:00:00	SPY	ETF	262.97	263.32	262.84	262.87	180742.0
2018-11-23 15:00:00	SPY	ETF	262.93	263.0	262.76	262.94	51686.0
2018-11-23 16:00:00	SPY	ETF	262.94	276.2096	262.9	262.93	128693.0
2018-11-23 04:00:00	QQQ	ETF	159.72	159.85	159.58	159.8	9721.0
2018-11-23 05:00:00	QQQ	ETF	159.85	159.85	159.25	159.35	7238.0
2018-11-23 06:00:00	QQQ	ETF	159.3	159.52	159.3	159.3	5781.0
2018-11-23 07:00:00	QQQ	ETF	159.44	159.72	159.24	159.65	47822.0
2018-11-23 08:00:00	QQQ	ETF	159.55	159.71	158.29	158.93	669919.0
2018-11-23 09:00:00	QQQ	ETF	158.9	160.84	158.86	160.5	4173796.0
2018-11-23 10:00:00	QQQ	ETF	160.49	160.67	159.74	160.13	3863745.0
2018-11-23 11:00:00	QQQ	ETF	160.13	160.47	159.45	159.5	3394758.0
2018-11-23 12:00:00	QQQ	ETF	159.5	159.94	159.19	159.23	5642095.0
2018-11-23 13:00:00	QQQ	ETF	159.25	160.0489	158.95	159.1	1835694.0
2018-11-23 14:00:00	QQQ	ETF	159.03	159.09	158.86	158.95	30483.0
2018-11-23 15:00:00	QQQ	ETF	159.0	159.21	158.9304	158.96	80093.0
2018-11-23 16:00:00	QQQ	ETF	158.98	159.2267	158.96	159.06	41982.0
2018-11-23 04:00:00	IWM	ETF	147.29	147.29	147.29	147.29	500.0
2018-11-23 05:00:00	IWM	ETF	147.32	147.4	147.01	147.4	4239.0
2018-11-23 06:00:00	IWM	ETF	147.4	147.53	147.18	147.18	1100.0
2018-11-23 07:00:00	IWM	ETF	147.0	147.23	147.0	147.23	400.0
2018-11-23 08:00:00	IWM	ETF	147.23	147.23	146.5	146.6	44764.0
2018-11-23 09:00:00	IWM	ETF	146.76	148.33	146.64	148.1	1450763.0
2018-11-23 10:00:00	IWM	ETF	148.06	149.0	148.06	148.7201	2099642.0
2018-11-23 11:00:00	IWM	ETF	148.73	149.3	148.59	148.71	1511909.0
2018-11-23 12:00:00	IWM	ETF	148.69	148.96	147.82	147.94	3513285.0
2018-11-23 13:00:00	IWM	ETF	147.9	148.0931	147.65	147.73	1030695.0
2018-11-23 14:00:00	IWM	ETF	147.71	147.71	147.67	147.67	2554.0
2018-11-23 15:00:00	IWM	ETF	147.7	147.71	147.7	147.71	1300.0
2018-11-23 16:00:00	IWM	ETF	147.71	147.72	147.56	147.66	4490.0
2018-11-23 04:00:00	DIA	ETF	243.99	244.0	243.99	244.0	200.0
2018-11-23 05:00:00	DIA	ETF	243.5	243.5	243.5	243.5	1985.0
2018-11-23 06:00:00	DIA	ETF	243.5	243.5	243.5	243.5	1500.0
2018-11-23 07:00:00	DIA	ETF	244.15	244.15	244.15	244.15	260.0
2018-11-23 08:00:00	DIA	ETF	243.78	243.8	242.6501	243.03	13353.0
2018-11-23 09:00:00	DIA	ETF	244.65	244.65	242.71	243.64	431398.0
2018-11-23 10:00:00	DIA	ETF	243.61	243.8	242.86	243.42	300918.0
2018-11-23 11:00:00	DIA	ETF	243.47	244.03	243.2232	243.28	227510.0
2018-11-23 12:00:00	DIA	ETF	243.26	243.7	242.72	242.81	581825.0
2018-11-23 13:00:00	DIA	ETF	242.81	242.88	242.56	242.88	163093.0
2018-11-23 14:00:00	DIA	ETF	242.8	242.85	242.72	242.85	992.0

> showing 50 of 6,161 rows — these rows as CSV

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