PREVIEW / etf_1hour / 2018-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-21.parquet
  size:    293 KB
  rows:    9,673

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-03-21 04:00:00	SPY	ETF	271.35	271.36	270.9	270.97	9323.0
2018-03-21 05:00:00	SPY	ETF	271.02	271.05	270.77	271.05	17954.0
2018-03-21 06:00:00	SPY	ETF	271.07	271.36	270.94	271.25	30760.0
2018-03-21 07:00:00	SPY	ETF	271.24	271.37	270.73	270.98	124733.0
2018-03-21 08:00:00	SPY	ETF	271.15	271.7	270.68	271.06	264017.0
2018-03-21 09:00:00	SPY	ETF	271.04	271.04	270.45	270.61	4744401.0
2018-03-21 10:00:00	SPY	ETF	270.62	271.23	270.53	270.9911	8041403.0
2018-03-21 11:00:00	SPY	ETF	270.995	272.3	270.87	272.01	6099039.0
2018-03-21 12:00:00	SPY	ETF	272.01	272.27	271.87	272.22	4393340.0
2018-03-21 13:00:00	SPY	ETF	272.23	272.25	271.51	272.03	6321032.0
2018-03-21 14:00:00	SPY	ETF	272.0	273.27	270.19	270.8807	23740222.0
2018-03-21 15:00:00	SPY	ETF	270.88	272.24	270.41	270.43	18161673.0
2018-03-21 16:00:00	SPY	ETF	270.41	270.8	270.38	270.69	5930962.0
2018-03-21 17:00:00	SPY	ETF	270.62	270.68	270.61	270.67	33573.0
2018-03-21 18:00:00	SPY	ETF	270.68	270.9	270.68	270.73	138944.0
2018-03-21 19:00:00	SPY	ETF	270.73	270.76	270.6	270.75	31872.0
2018-03-21 04:00:00	QQQ	ETF	167.74	167.74	167.32	167.32	42100.0
2018-03-21 05:00:00	QQQ	ETF	167.36	167.41	167.14	167.29	21566.0
2018-03-21 06:00:00	QQQ	ETF	167.44	167.56	167.28	167.39	23700.0
2018-03-21 07:00:00	QQQ	ETF	167.36	167.54	167.11	167.29	100003.0
2018-03-21 08:00:00	QQQ	ETF	167.35	167.51	167.19	167.47	451128.0
2018-03-21 09:00:00	QQQ	ETF	167.47	167.58	167.02	167.4088	2686894.0
2018-03-21 10:00:00	QQQ	ETF	167.42	167.99	167.32	167.45	3910555.0
2018-03-21 11:00:00	QQQ	ETF	167.45	168.22	167.35	168.04	2071748.0
2018-03-21 12:00:00	QQQ	ETF	168.03	168.24	167.91	168.2	1255129.0
2018-03-21 13:00:00	QQQ	ETF	168.21	168.235	167.72	167.94	1788445.0
2018-03-21 14:00:00	QQQ	ETF	167.95	168.76	166.19	166.817	11661305.0
2018-03-21 15:00:00	QQQ	ETF	166.82	167.72	166.74	166.86	8967429.0
2018-03-21 16:00:00	QQQ	ETF	166.87	167.35	166.83	167.12	1188069.0
2018-03-21 17:00:00	QQQ	ETF	167.08	167.15	167.03	167.13	3363.0
2018-03-21 18:00:00	QQQ	ETF	167.14	167.34	167.14	167.28	29080.0
2018-03-21 19:00:00	QQQ	ETF	167.27	167.27	167.17	167.17	30511.0
2018-03-21 04:00:00	IWM	ETF	156.47	156.47	156.22	156.22	2124.0
2018-03-21 05:00:00	IWM	ETF	156.16	156.24	156.16	156.24	3576.0
2018-03-21 06:00:00	IWM	ETF	156.18	156.51	156.18	156.51	4178.0
2018-03-21 07:00:00	IWM	ETF	156.45	156.45	156.17	156.21	20112.0
2018-03-21 08:00:00	IWM	ETF	156.45	156.51	156.12	156.46	54272.0
2018-03-21 09:00:00	IWM	ETF	156.41	156.99	156.19	156.85	1381955.0
2018-03-21 10:00:00	IWM	ETF	156.86	157.73	156.79	157.53	2164576.0
2018-03-21 11:00:00	IWM	ETF	157.54	157.81	157.34	157.66	1473777.0
2018-03-21 12:00:00	IWM	ETF	157.65	157.65	157.29	157.33	892875.0
2018-03-21 13:00:00	IWM	ETF	157.33	157.55	157.15	157.4	898863.0
2018-03-21 14:00:00	IWM	ETF	157.4	158.26	156.82	157.33	5549123.0
2018-03-21 15:00:00	IWM	ETF	157.34	158.01	157.11	157.14	3992495.0
2018-03-21 16:00:00	IWM	ETF	157.15	157.4	157.07	157.2	3673480.0
2018-03-21 17:00:00	IWM	ETF	157.15	157.29	157.15	157.29	954.0
2018-03-21 18:00:00	IWM	ETF	157.29	157.32	157.29	157.32	1503.0
2018-03-21 19:00:00	IWM	ETF	157.21	157.28	157.21	157.28	2221.0
2018-03-21 04:00:00	DIA	ETF	247.14	247.14	247.04	247.04	200.0
2018-03-21 07:00:00	DIA	ETF	247.26	247.26	246.98	246.98	1709.0

> showing 50 of 9,673 rows — these rows as CSV

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