PREVIEW / etf_1hour / 2018-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-15.parquet
  size:    319 KB
  rows:    10,584

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-15 04:00:00	SPY	ETF	274.7	274.82	273.7	273.86	148785.0
2018-10-15 05:00:00	SPY	ETF	273.86	274.98	273.8	274.82	171561.0
2018-10-15 06:00:00	SPY	ETF	274.84	275.05	274.6	274.75	157225.0
2018-10-15 07:00:00	SPY	ETF	274.72	275.99	274.66	275.8	600595.0
2018-10-15 08:00:00	SPY	ETF	275.95	276.0	274.58	275.74	584239.0
2018-10-15 09:00:00	SPY	ETF	275.73	276.14	275.11	275.28	10242318.0
2018-10-15 10:00:00	SPY	ETF	275.26	275.71	274.3	275.57	11807396.0
2018-10-15 11:00:00	SPY	ETF	275.58	276.65	275.11	275.23	11060696.0
2018-10-15 12:00:00	SPY	ETF	275.23	276.0593	274.62	275.75	10620908.0
2018-10-15 13:00:00	SPY	ETF	275.75	276.84	275.67	276.5599	8073788.0
2018-10-15 14:00:00	SPY	ETF	276.57	277.04	275.36	276.725	9210436.0
2018-10-15 15:00:00	SPY	ETF	276.73	276.95	274.46	274.48	27295048.0
2018-10-15 16:00:00	SPY	ETF	274.47	275.78	273.78	273.92	9915573.0
2018-10-15 17:00:00	SPY	ETF	273.94	274.4	273.92	273.98	170568.0
2018-10-15 18:00:00	SPY	ETF	273.96	274.6	273.75	274.19	133987.0
2018-10-15 19:00:00	SPY	ETF	274.21	274.75	274.16	274.67	110940.0
2018-10-15 04:00:00	QQQ	ETF	173.04	173.04	172.09	172.28	55894.0
2018-10-15 05:00:00	QQQ	ETF	172.28	173.01	172.28	172.9	176723.0
2018-10-15 06:00:00	QQQ	ETF	172.92	173.1	172.83	172.96	278446.0
2018-10-15 07:00:00	QQQ	ETF	172.89	174.08	172.88	173.99	653342.0
2018-10-15 08:00:00	QQQ	ETF	174.0	174.32	172.58	173.88	555436.0
2018-10-15 09:00:00	QQQ	ETF	173.88	174.01	172.53	172.7	9221097.0
2018-10-15 10:00:00	QQQ	ETF	172.67	172.87	171.56	172.78	9775611.0
2018-10-15 11:00:00	QQQ	ETF	172.8	173.93	172.49	172.58	6881656.0
2018-10-15 12:00:00	QQQ	ETF	172.59	173.5	172.17	173.2	4933537.0
2018-10-15 13:00:00	QQQ	ETF	173.21	174.04	172.88	173.7	4174475.0
2018-10-15 14:00:00	QQQ	ETF	173.71	173.93	172.63	173.68	4740695.0
2018-10-15 15:00:00	QQQ	ETF	173.68	174.03	172.11	172.12	8778301.0
2018-10-15 16:00:00	QQQ	ETF	172.12	173.2063	171.73	171.87	2041508.0
2018-10-15 17:00:00	QQQ	ETF	171.82	171.94	171.82	171.9	26817.0
2018-10-15 18:00:00	QQQ	ETF	171.85	172.22	171.7	172.1	161066.0
2018-10-15 19:00:00	QQQ	ETF	172.06	172.56	172.06	172.52	51525.0
2018-10-15 04:00:00	IWM	ETF	152.95	153.02	152.46	152.49	8033.0
2018-10-15 05:00:00	IWM	ETF	152.66	152.7	152.66	152.7	1100.0
2018-10-15 06:00:00	IWM	ETF	152.9	153.1	152.9	152.93	8600.0
2018-10-15 07:00:00	IWM	ETF	152.82	153.5	152.82	153.38	55296.0
2018-10-15 08:00:00	IWM	ETF	153.6	153.65	152.9	153.64	77130.0
2018-10-15 09:00:00	IWM	ETF	153.629	154.08	153.13	153.55	4185388.0
2018-10-15 10:00:00	IWM	ETF	153.54	153.75	152.54	153.23	5536037.0
2018-10-15 11:00:00	IWM	ETF	153.23	154.31	153.23	153.69	3951296.0
2018-10-15 12:00:00	IWM	ETF	153.71	154.51	153.44	154.34	2866725.0
2018-10-15 13:00:00	IWM	ETF	154.34	155.29	154.04	155.2	2797448.0
2018-10-15 14:00:00	IWM	ETF	155.21	155.23	154.29	155.11	2414795.0
2018-10-15 15:00:00	IWM	ETF	155.1	155.29	154.22	154.24	4651690.0
2018-10-15 16:00:00	IWM	ETF	154.24	154.25	153.6709	153.72	1357886.0
2018-10-15 17:00:00	IWM	ETF	153.8	153.85	153.8	153.85	3050.0
2018-10-15 18:00:00	IWM	ETF	154.17	154.17	153.67	153.98	117599.0
2018-10-15 19:00:00	IWM	ETF	153.98	154.2	153.98	154.18	8075.0
2018-10-15 05:00:00	DIA	ETF	251.5	251.5	251.5	251.5	100.0
2018-10-15 06:00:00	DIA	ETF	252.37	252.37	252.37	252.37	300.0

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

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