PREVIEW / etf_1hour / 2019-02-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-15.parquet
  size:    321 KB
  rows:    10,607

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
2019-02-15 04:00:00	SPY	ETF	273.4	273.9	273.37	273.9	4886.0
2019-02-15 05:00:00	SPY	ETF	273.9	274.55	273.7	274.37	64968.0
2019-02-15 06:00:00	SPY	ETF	274.46	274.79	274.37	274.37	56445.0
2019-02-15 07:00:00	SPY	ETF	274.37	275.07	274.35	275.04	508437.0
2019-02-15 08:00:00	SPY	ETF	273.8	275.52	272.85	275.31	1085155.0
2019-02-15 09:00:00	SPY	ETF	275.35	276.96	275.27	276.58	15078311.0
2019-02-15 10:00:00	SPY	ETF	276.58	277.13	276.22	276.49	18552430.0
2019-02-15 11:00:00	SPY	ETF	276.49	276.92	276.13	276.7	8702576.0
2019-02-15 12:00:00	SPY	ETF	276.71	276.9	276.51	276.6	4818690.0
2019-02-15 13:00:00	SPY	ETF	276.605	276.74	276.26	276.49	4224220.0
2019-02-15 14:00:00	SPY	ETF	276.49	277.03	276.49	276.94	7283890.0
2019-02-15 15:00:00	SPY	ETF	276.9348	277.41	276.5	277.39	20443651.0
2019-02-15 16:00:00	SPY	ETF	277.39	279.0643	277.1318	277.55	12667068.0
2019-02-15 17:00:00	SPY	ETF	277.56	277.75	277.37	277.7	862669.0
2019-02-15 18:00:00	SPY	ETF	277.73	277.96	277.7	277.85	254329.0
2019-02-15 19:00:00	SPY	ETF	277.86	278.0	277.83	278.0	75813.0
2019-02-15 04:00:00	QQQ	ETF	170.45	170.71	170.42	170.71	8379.0
2019-02-15 05:00:00	QQQ	ETF	170.62	171.15	170.62	171.12	32648.0
2019-02-15 06:00:00	QQQ	ETF	171.15	171.38	171.08	171.08	46269.0
2019-02-15 07:00:00	QQQ	ETF	171.07	171.56	171.04	171.52	149792.0
2019-02-15 08:00:00	QQQ	ETF	171.22	171.97	170.0	171.81	299016.0
2019-02-15 09:00:00	QQQ	ETF	171.86	172.81	171.43	171.64	5337261.0
2019-02-15 10:00:00	QQQ	ETF	171.66	172.3	171.4	171.6375	5310991.0
2019-02-15 11:00:00	QQQ	ETF	171.65	171.94	171.1392	171.42	3837954.0
2019-02-15 12:00:00	QQQ	ETF	171.42	171.71	171.315	171.44	1608301.0
2019-02-15 13:00:00	QQQ	ETF	171.42	171.53	171.26	171.465	1457518.0
2019-02-15 14:00:00	QQQ	ETF	171.45	171.8099	171.44	171.76	1609570.0
2019-02-15 15:00:00	QQQ	ETF	171.75	171.97	171.48	171.96	5322466.0
2019-02-15 16:00:00	QQQ	ETF	171.96	172.11	171.91	172.07	1725907.0
2019-02-15 17:00:00	QQQ	ETF	172.07	172.12	171.94	172.08	248101.0
2019-02-15 18:00:00	QQQ	ETF	172.09	172.19	172.08	172.1	28181.0
2019-02-15 19:00:00	QQQ	ETF	172.1	172.19	172.1	172.16	7532.0
2019-02-15 05:00:00	IWM	ETF	153.69	153.76	153.69	153.73	7807.0
2019-02-15 06:00:00	IWM	ETF	153.75	153.95	153.74	153.83	8800.0
2019-02-15 07:00:00	IWM	ETF	153.75	153.99	153.75	153.99	20170.0
2019-02-15 08:00:00	IWM	ETF	153.74	154.23	153.74	154.13	44128.0
2019-02-15 09:00:00	IWM	ETF	154.13	155.24	154.08	155.05	3121007.0
2019-02-15 10:00:00	IWM	ETF	155.05	155.72	154.88	155.595	3032852.0
2019-02-15 11:00:00	IWM	ETF	155.6	156.02	155.33	155.97	3213707.0
2019-02-15 12:00:00	IWM	ETF	155.98	156.24	155.86	156.14	2012849.0
2019-02-15 13:00:00	IWM	ETF	156.13	156.21	155.48	155.82	2461219.0
2019-02-15 14:00:00	IWM	ETF	155.825	155.89	155.52	155.78	2028794.0
2019-02-15 15:00:00	IWM	ETF	155.78	156.22	155.62	156.2	5014697.0
2019-02-15 16:00:00	IWM	ETF	156.21	156.5	156.06	156.26	1222538.0
2019-02-15 17:00:00	IWM	ETF	156.22	156.32	156.22	156.24	485655.0
2019-02-15 18:00:00	IWM	ETF	156.24	156.37	156.05	156.12	127558.0
2019-02-15 19:00:00	IWM	ETF	156.09	156.26	156.09	156.25	7875.0
2019-02-15 05:00:00	DIA	ETF	254.2	254.2	254.2	254.2	100.0
2019-02-15 06:00:00	DIA	ETF	254.35	254.51	254.35	254.4	520.0
2019-02-15 07:00:00	DIA	ETF	254.84	254.84	254.8	254.84	570.0

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

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