PREVIEW / etf_1hour / 2018-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-03.parquet
  size:    309 KB
  rows:    10,049

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-01-03 04:00:00	SPY	ETF	268.95	269.04	268.95	268.98	2881.0
2018-01-03 05:00:00	SPY	ETF	268.98	269.09	268.98	269.05	6500.0
2018-01-03 06:00:00	SPY	ETF	269.1	269.15	268.96	268.97	25460.0
2018-01-03 07:00:00	SPY	ETF	268.99	269.06	268.87	269.0	247820.0
2018-01-03 08:00:00	SPY	ETF	268.93	269.01	268.84	268.9	276466.0
2018-01-03 09:00:00	SPY	ETF	268.94	269.61	268.91	269.56	7035504.0
2018-01-03 10:00:00	SPY	ETF	269.565	270.07	269.54	269.84	13042966.0
2018-01-03 11:00:00	SPY	ETF	269.845	270.0	269.765	269.856	6475893.0
2018-01-03 12:00:00	SPY	ETF	269.86	270.46	269.86	270.315	6606995.0
2018-01-03 13:00:00	SPY	ETF	270.32	270.36	269.97	270.04	8806836.0
2018-01-03 14:00:00	SPY	ETF	270.035	270.36	269.99	270.275	8445486.0
2018-01-03 15:00:00	SPY	ETF	270.275	270.64	270.2	270.47	17472008.0
2018-01-03 16:00:00	SPY	ETF	270.47	270.52	270.11	270.21	17358694.0
2018-01-03 17:00:00	SPY	ETF	270.23	270.47	269.0832	270.27	1032681.0
2018-01-03 18:00:00	SPY	ETF	270.27	270.47	270.15	270.28	672033.0
2018-01-03 19:00:00	SPY	ETF	270.29	270.47	270.22	270.3	37725.0
2018-01-03 04:00:00	QQQ	ETF	158.55	158.7	158.55	158.69	19212.0
2018-01-03 05:00:00	QQQ	ETF	158.62	158.66	158.62	158.65	2400.0
2018-01-03 06:00:00	QQQ	ETF	158.66	158.68	158.63	158.63	8100.0
2018-01-03 07:00:00	QQQ	ETF	158.62	158.62	158.53	158.58	52551.0
2018-01-03 08:00:00	QQQ	ETF	158.63	158.63	158.48	158.48	125782.0
2018-01-03 09:00:00	QQQ	ETF	158.5	159.4634	158.5	159.43	4947839.0
2018-01-03 10:00:00	QQQ	ETF	159.43	159.75	159.35	159.67	3111096.0
2018-01-03 11:00:00	QQQ	ETF	159.67	159.86	159.56	159.7	2913348.0
2018-01-03 12:00:00	QQQ	ETF	159.7	160.12	159.7	160.0361	1856234.0
2018-01-03 13:00:00	QQQ	ETF	160.0375	160.07	159.71	159.73	1517968.0
2018-01-03 14:00:00	QQQ	ETF	159.73	160.03	159.68	159.93	2115562.0
2018-01-03 15:00:00	QQQ	ETF	159.93	160.17	159.84	160.02	4599530.0
2018-01-03 16:00:00	QQQ	ETF	160.01	160.12	159.9	159.98	2349528.0
2018-01-03 17:00:00	QQQ	ETF	160.08	160.08	160.01	160.02	16902.0
2018-01-03 18:00:00	QQQ	ETF	160.01	160.03	159.95	160.03	29697.0
2018-01-03 19:00:00	QQQ	ETF	160.03	160.21	160.03	160.07	12439.0
2018-01-03 04:00:00	IWM	ETF	153.99	153.99	153.96	153.96	1700.0
2018-01-03 06:00:00	IWM	ETF	154.0	154.0	154.0	154.0	247.0
2018-01-03 07:00:00	IWM	ETF	153.79	153.85	153.78	153.85	5658.0
2018-01-03 08:00:00	IWM	ETF	153.84	153.85	153.75	153.82	28281.0
2018-01-03 09:00:00	IWM	ETF	153.79	154.29	153.72	154.16	1750834.0
2018-01-03 10:00:00	IWM	ETF	154.17	154.46	153.9	154.07	2134330.0
2018-01-03 11:00:00	IWM	ETF	154.06	154.18	153.56	153.59	1579146.0
2018-01-03 12:00:00	IWM	ETF	153.6	153.97	153.5199	153.9	1383597.0
2018-01-03 13:00:00	IWM	ETF	153.9	154.0	153.82	153.89	727853.0
2018-01-03 14:00:00	IWM	ETF	153.89	154.24	153.88	154.21	1028973.0
2018-01-03 15:00:00	IWM	ETF	154.21	154.36	153.96	154.06	3987744.0
2018-01-03 16:00:00	IWM	ETF	154.065	154.35	153.99	154.03	3505891.0
2018-01-03 17:00:00	IWM	ETF	154.06	154.15	154.06	154.15	1645.0
2018-01-03 18:00:00	IWM	ETF	154.15	154.15	154.06	154.12	1596.0
2018-01-03 19:00:00	IWM	ETF	154.17	154.28	154.1	154.1	21513.0
2018-01-03 08:00:00	DIA	ETF	248.25	248.38	248.23	248.38	6650.0
2018-01-03 09:00:00	DIA	ETF	248.24	248.63	248.07	248.53	457757.0
2018-01-03 10:00:00	DIA	ETF	248.54	248.88	248.45	248.54	560266.0

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

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