PREVIEW / etf_1hour / 2018-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-13.parquet
  size:    313 KB
  rows:    10,330

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-13 04:00:00	SPY	ETF	273.91	274.1	273.35	273.35	67083.0
2018-11-13 05:00:00	SPY	ETF	273.35	273.9	273.16	273.9	71874.0
2018-11-13 06:00:00	SPY	ETF	273.95	274.33	273.88	274.1	154044.0
2018-11-13 07:00:00	SPY	ETF	274.1	274.65	273.94	274.04	363939.0
2018-11-13 08:00:00	SPY	ETF	274.05	274.54	273.29	273.57	529226.0
2018-11-13 09:00:00	SPY	ETF	273.56	274.13	272.94	273.28	9195273.0
2018-11-13 10:00:00	SPY	ETF	273.29	273.82	271.73	273.41	17175566.0
2018-11-13 11:00:00	SPY	ETF	273.38	275.325	273.28	274.24	11729481.0
2018-11-13 12:00:00	SPY	ETF	274.24	274.649	272.96	273.12	8085699.0
2018-11-13 13:00:00	SPY	ETF	273.12	273.86	272.5401	273.0911	7931218.0
2018-11-13 14:00:00	SPY	ETF	273.09	273.235	271.39	272.05	11525126.0
2018-11-13 15:00:00	SPY	ETF	272.07	272.88	271.25	272.06	21082596.0
2018-11-13 16:00:00	SPY	ETF	272.04	272.9	271.6	272.57	8762910.0
2018-11-13 17:00:00	SPY	ETF	272.59	272.85	272.56	272.85	243287.0
2018-11-13 18:00:00	SPY	ETF	272.79	274.1	272.61	273.33	171147.0
2018-11-13 19:00:00	SPY	ETF	273.28	273.7	273.25	273.42	198177.0
2018-11-13 04:00:00	QQQ	ETF	167.69	167.86	167.24	167.24	42485.0
2018-11-13 05:00:00	QQQ	ETF	167.2	167.75	167.04	167.75	33028.0
2018-11-13 06:00:00	QQQ	ETF	167.75	168.01	167.66	167.8	81808.0
2018-11-13 07:00:00	QQQ	ETF	167.83	168.19	167.58	167.64	317974.0
2018-11-13 08:00:00	QQQ	ETF	167.76	168.15	167.04	167.23	428072.0
2018-11-13 09:00:00	QQQ	ETF	167.25	168.48	166.93	167.05	7523427.0
2018-11-13 10:00:00	QQQ	ETF	167.0545	168.19	166.41	168.05	11204370.0
2018-11-13 11:00:00	QQQ	ETF	168.07	169.48	167.99	168.1768	9668156.0
2018-11-13 12:00:00	QQQ	ETF	168.19	168.46	167.1	167.3538	4898741.0
2018-11-13 13:00:00	QQQ	ETF	167.36	168.04	167.02	167.33	5011173.0
2018-11-13 14:00:00	QQQ	ETF	167.32	167.43	166.1	166.6	5712974.0
2018-11-13 15:00:00	QQQ	ETF	166.6	167.19	166.0	166.5	10643751.0
2018-11-13 16:00:00	QQQ	ETF	166.49	167.4869	166.17	166.95	1385975.0
2018-11-13 17:00:00	QQQ	ETF	166.92	167.05	166.92	167.05	10423.0
2018-11-13 18:00:00	QQQ	ETF	167.03	167.9	166.91	167.51	90256.0
2018-11-13 19:00:00	QQQ	ETF	167.5	167.8	167.42	167.64	56141.0
2018-11-13 04:00:00	IWM	ETF	151.99	151.99	151.74	151.98	2800.0
2018-11-13 05:00:00	IWM	ETF	151.54	152.0	151.54	152.0	3914.0
2018-11-13 06:00:00	IWM	ETF	152.1	152.19	151.96	152.11	4677.0
2018-11-13 07:00:00	IWM	ETF	152.13	152.4	152.12	152.12	20482.0
2018-11-13 08:00:00	IWM	ETF	152.26	152.3999	151.73	151.92	49680.0
2018-11-13 09:00:00	IWM	ETF	151.9	152.61	151.49	152.03	1792847.0
2018-11-13 10:00:00	IWM	ETF	152.02	152.42	150.97	151.64	2628104.0
2018-11-13 11:00:00	IWM	ETF	151.63	153.09	151.56	152.66	2758736.0
2018-11-13 12:00:00	IWM	ETF	152.68	152.88	151.66	151.76	1765201.0
2018-11-13 13:00:00	IWM	ETF	151.75	152.01	151.22	151.41	2551151.0
2018-11-13 14:00:00	IWM	ETF	151.39	151.48	150.29	150.59	2158988.0
2018-11-13 15:00:00	IWM	ETF	150.58	151.03	150.33	150.54	3434646.0
2018-11-13 16:00:00	IWM	ETF	150.49	154.09	150.31	150.95	425550.0
2018-11-13 17:00:00	IWM	ETF	150.94	151.05	150.83	151.04	32788.0
2018-11-13 18:00:00	IWM	ETF	151.04	151.53	150.95	151.3	8250.0
2018-11-13 19:00:00	IWM	ETF	151.44	151.58	151.35	151.35	3047.0
2018-11-13 04:00:00	DIA	ETF	255.34	255.36	255.2	255.3	2400.0
2018-11-13 05:00:00	DIA	ETF	254.8	255.18	254.8	255.18	300.0

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

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