PREVIEW / etf_1hour / 2018-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-05.parquet
  size:    316 KB
  rows:    10,442

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-05 04:00:00	SPY	ETF	271.35	271.7	271.08	271.7	33729.0
2018-11-05 05:00:00	SPY	ETF	271.8	271.95	271.57	271.92	27809.0
2018-11-05 06:00:00	SPY	ETF	271.93	272.4	271.93	272.38	52081.0
2018-11-05 07:00:00	SPY	ETF	272.38	272.6	271.93	272.19	199245.0
2018-11-05 08:00:00	SPY	ETF	271.89	272.58	271.45	272.2	319866.0
2018-11-05 09:00:00	SPY	ETF	272.2	272.97	272.07	272.14	7620055.0
2018-11-05 10:00:00	SPY	ETF	272.16	272.95	271.35	272.87	10133368.0
2018-11-05 11:00:00	SPY	ETF	272.86	273.08	272.06	272.76	5607201.0
2018-11-05 12:00:00	SPY	ETF	272.7598	272.86	272.07	272.285	4695309.0
2018-11-05 13:00:00	SPY	ETF	272.28	273.0	272.16	272.86	5790476.0
2018-11-05 14:00:00	SPY	ETF	272.8715	274.01	272.64	273.75	8516351.0
2018-11-05 15:00:00	SPY	ETF	273.74	273.94	272.88	273.43	12344680.0
2018-11-05 16:00:00	SPY	ETF	273.45	273.81	271.18	273.64	6280971.0
2018-11-05 17:00:00	SPY	ETF	273.59	273.64	271.89	273.5	133714.0
2018-11-05 18:00:00	SPY	ETF	273.53	273.8	273.42	273.65	129345.0
2018-11-05 19:00:00	SPY	ETF	273.69	274.19	273.56	274.08	37357.0
2018-11-05 04:00:00	QQQ	ETF	169.41	169.77	169.33	169.77	4621.0
2018-11-05 05:00:00	QQQ	ETF	169.94	170.03	169.78	169.95	7189.0
2018-11-05 06:00:00	QQQ	ETF	169.97	170.21	169.94	170.18	14028.0
2018-11-05 07:00:00	QQQ	ETF	170.17	170.31	169.46	169.7	121323.0
2018-11-05 08:00:00	QQQ	ETF	170.31	170.31	169.31	169.6	305023.0
2018-11-05 09:00:00	QQQ	ETF	169.57	169.66	167.88	168.04	6450159.0
2018-11-05 10:00:00	QQQ	ETF	168.05	168.33	167.08	168.23	7474468.0
2018-11-05 11:00:00	QQQ	ETF	168.23	168.48	167.43	167.995	3965321.0
2018-11-05 12:00:00	QQQ	ETF	168.01	168.14	167.53	167.81	2450300.0
2018-11-05 13:00:00	QQQ	ETF	167.81	168.37	167.62	168.19	2411090.0
2018-11-05 14:00:00	QQQ	ETF	168.19	169.33	168.05	169.045	4831669.0
2018-11-05 15:00:00	QQQ	ETF	169.06	169.28	168.505	168.95	6128836.0
2018-11-05 16:00:00	QQQ	ETF	168.96	169.3	168.91	169.09	1355842.0
2018-11-05 17:00:00	QQQ	ETF	169.03	169.19	168.97	169.04	52093.0
2018-11-05 18:00:00	QQQ	ETF	169.05	169.21	168.94	169.2	180846.0
2018-11-05 19:00:00	QQQ	ETF	169.2	169.59	169.08	169.45	68954.0
2018-11-05 04:00:00	IWM	ETF	153.35	153.7	153.35	153.7	800.0
2018-11-05 06:00:00	IWM	ETF	153.92	153.93	153.87	153.87	5800.0
2018-11-05 07:00:00	IWM	ETF	153.94	154.09	153.91	153.93	7774.0
2018-11-05 08:00:00	IWM	ETF	154.0	154.01	153.53	154.01	46083.0
2018-11-05 09:00:00	IWM	ETF	154.01	154.66	153.46	153.49	1784297.0
2018-11-05 10:00:00	IWM	ETF	153.5	153.63	152.5	153.61	3335312.0
2018-11-05 11:00:00	IWM	ETF	153.59	153.8	152.85	153.34	1567832.0
2018-11-05 12:00:00	IWM	ETF	153.36	153.46	152.35	152.85	1727002.0
2018-11-05 13:00:00	IWM	ETF	152.85	153.34	152.79	153.17	1153766.0
2018-11-05 14:00:00	IWM	ETF	153.165	154.23	153.01	154.1	1904912.0
2018-11-05 15:00:00	IWM	ETF	154.11	154.21	153.58	153.88	3049256.0
2018-11-05 16:00:00	IWM	ETF	153.87	154.08	153.85	154.06	1514759.0
2018-11-05 17:00:00	IWM	ETF	153.91	154.06	153.91	153.96	3815.0
2018-11-05 18:00:00	IWM	ETF	153.97	154.05	153.95	154.05	4880.0
2018-11-05 19:00:00	IWM	ETF	154.02	154.33	153.96	154.28	4600.0
2018-11-05 07:00:00	DIA	ETF	252.92	253.0	252.67	252.69	3300.0
2018-11-05 08:00:00	DIA	ETF	252.96	252.96	252.26	252.51	2065.0
2018-11-05 09:00:00	DIA	ETF	252.52	253.72	252.52	253.345	275086.0

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

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