PREVIEW / etf_1hour / 2018-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-16.parquet
  size:    328 KB
  rows:    10,556

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-10-16 04:00:00	SPY	ETF	275.01	275.45	274.95	275.02	41920.0
2018-10-16 05:00:00	SPY	ETF	274.98	275.13	274.78	275.13	16376.0
2018-10-16 06:00:00	SPY	ETF	275.17	275.5	274.99	275.26	54116.0
2018-10-16 07:00:00	SPY	ETF	275.28	275.67	275.18	275.64	338620.0
2018-10-16 08:00:00	SPY	ETF	275.6	276.34	274.71	276.2	518774.0
2018-10-16 09:00:00	SPY	ETF	276.2	277.0	276.07	277.0	11090087.0
2018-10-16 10:00:00	SPY	ETF	276.99	278.1	276.67	278.08	16179532.0
2018-10-16 11:00:00	SPY	ETF	278.07	278.69	277.78	278.66	12037970.0
2018-10-16 12:00:00	SPY	ETF	278.66	279.02	278.355	278.9764	7329135.0
2018-10-16 13:00:00	SPY	ETF	278.97	279.75	278.78	279.36	8793624.0
2018-10-16 14:00:00	SPY	ETF	279.36	280.03	279.36	279.53	11613657.0
2018-10-16 15:00:00	SPY	ETF	279.53	280.82	279.26	280.3	29069000.0
2018-10-16 16:00:00	SPY	ETF	280.3	281.08	279.93	280.79	17395670.0
2018-10-16 17:00:00	SPY	ETF	280.79	280.91	280.71	280.85	124348.0
2018-10-16 18:00:00	SPY	ETF	280.84	280.89	280.4	280.61	132428.0
2018-10-16 19:00:00	SPY	ETF	280.68	280.9	280.59	280.9	24957.0
2018-10-16 04:00:00	QQQ	ETF	172.74	173.15	172.74	172.88	65295.0
2018-10-16 05:00:00	QQQ	ETF	172.94	172.99	172.73	172.97	22430.0
2018-10-16 06:00:00	QQQ	ETF	173.02	173.2	172.83	173.04	42850.0
2018-10-16 07:00:00	QQQ	ETF	173.07	173.41	173.01	173.39	229994.0
2018-10-16 08:00:00	QQQ	ETF	173.05	173.86	172.74	173.79	828933.0
2018-10-16 09:00:00	QQQ	ETF	173.79	174.73	173.7	174.73	11006857.0
2018-10-16 10:00:00	QQQ	ETF	174.73	174.94	173.7	174.91	8544698.0
2018-10-16 11:00:00	QQQ	ETF	174.9	175.79	174.65	175.76	7331452.0
2018-10-16 12:00:00	QQQ	ETF	175.76	176.04	175.44	176.01	3714450.0
2018-10-16 13:00:00	QQQ	ETF	176.02	176.6	175.93	176.335	4944258.0
2018-10-16 14:00:00	QQQ	ETF	176.34	176.78	176.27	176.37	5053396.0
2018-10-16 15:00:00	QQQ	ETF	176.3799	177.65	176.2	177.13	12637210.0
2018-10-16 16:00:00	QQQ	ETF	177.135	178.75	176.86	178.32	6720283.0
2018-10-16 17:00:00	QQQ	ETF	178.38	178.59	178.38	178.42	94603.0
2018-10-16 18:00:00	QQQ	ETF	178.42	178.54	178.25	178.35	189634.0
2018-10-16 19:00:00	QQQ	ETF	178.39	178.52	178.31	178.5	56638.0
2018-10-16 04:00:00	IWM	ETF	154.52	154.56	154.52	154.56	1525.0
2018-10-16 05:00:00	IWM	ETF	154.21	154.36	154.21	154.36	4000.0
2018-10-16 06:00:00	IWM	ETF	154.44	154.5	154.44	154.45	7080.0
2018-10-16 07:00:00	IWM	ETF	154.4	154.76	154.4	154.76	37956.0
2018-10-16 08:00:00	IWM	ETF	154.76	155.09	154.41	155.03	68297.0
2018-10-16 09:00:00	IWM	ETF	155.04	155.31	154.04	154.85	3767689.0
2018-10-16 10:00:00	IWM	ETF	154.88	156.17	154.88	156.149	5121130.0
2018-10-16 11:00:00	IWM	ETF	156.14	156.84	155.89	156.81	3089864.0
2018-10-16 12:00:00	IWM	ETF	156.82	157.52	156.75	157.46	3104054.0
2018-10-16 13:00:00	IWM	ETF	157.48	157.98	157.3501	157.97	2709693.0
2018-10-16 14:00:00	IWM	ETF	157.98	158.4	157.97	158.04	3104756.0
2018-10-16 15:00:00	IWM	ETF	158.05	158.86	157.78	158.56	6548715.0
2018-10-16 16:00:00	IWM	ETF	158.56	158.88	158.44	158.6	1349724.0
2018-10-16 17:00:00	IWM	ETF	158.51	158.86	158.51	158.64	4815.0
2018-10-16 18:00:00	IWM	ETF	158.7	158.72	158.5	158.6	10980.0
2018-10-16 19:00:00	IWM	ETF	158.63	158.65	158.63	158.65	2355.0
2018-10-16 05:00:00	DIA	ETF	252.7	252.7	252.64	252.64	900.0
2018-10-16 06:00:00	DIA	ETF	253.04	253.41	253.04	253.41	300.0

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

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