PREVIEW / etf_1hour / 2018-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-18.parquet
  size:    302 KB
  rows:    9,950

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-06-18 04:00:00	SPY	ETF	276.8	276.8	275.87	276.04	34920.0
2018-06-18 05:00:00	SPY	ETF	276.09	276.13	275.86	276.06	36012.0
2018-06-18 06:00:00	SPY	ETF	276.06	276.09	275.5	275.59	174085.0
2018-06-18 07:00:00	SPY	ETF	275.6	275.68	275.3	275.34	409519.0
2018-06-18 08:00:00	SPY	ETF	275.34	276.1	275.25	275.66	412473.0
2018-06-18 09:00:00	SPY	ETF	275.66	275.72	274.95	275.52	6909880.0
2018-06-18 10:00:00	SPY	ETF	275.51	276.36	275.31	276.1509	9626129.0
2018-06-18 11:00:00	SPY	ETF	276.15	276.59	276.0	276.06	5604279.0
2018-06-18 12:00:00	SPY	ETF	276.06	276.29	275.86	276.18	5132777.0
2018-06-18 13:00:00	SPY	ETF	276.19	276.49	276.15	276.37	3570200.0
2018-06-18 14:00:00	SPY	ETF	276.3775	276.61	276.14	276.21	5681747.0
2018-06-18 15:00:00	SPY	ETF	276.21	276.7	276.15	276.57	8990969.0
2018-06-18 16:00:00	SPY	ETF	276.57	276.79	276.48	276.64	4871589.0
2018-06-18 17:00:00	SPY	ETF	276.5941	276.72	276.5941	276.71	64605.0
2018-06-18 18:00:00	SPY	ETF	276.69	276.82	276.64	276.64	62834.0
2018-06-18 19:00:00	SPY	ETF	276.65	276.68	275.02	275.36	274751.0
2018-06-18 04:00:00	QQQ	ETF	175.99	175.99	175.63	175.76	16220.0
2018-06-18 05:00:00	QQQ	ETF	175.8	175.81	175.57	175.81	34283.0
2018-06-18 06:00:00	QQQ	ETF	175.76	175.78	175.33	175.39	32343.0
2018-06-18 07:00:00	QQQ	ETF	175.4	175.51	175.25	175.25	255510.0
2018-06-18 08:00:00	QQQ	ETF	175.24	175.52	175.2	175.51	185836.0
2018-06-18 09:00:00	QQQ	ETF	175.54	175.79	174.94	175.54	4658309.0
2018-06-18 10:00:00	QQQ	ETF	175.54	176.46	175.36	176.3216	3474748.0
2018-06-18 11:00:00	QQQ	ETF	176.33	176.65	176.22	176.26	2461482.0
2018-06-18 12:00:00	QQQ	ETF	176.26	176.4	176.045	176.205	1006836.0
2018-06-18 13:00:00	QQQ	ETF	176.2	176.56	176.2	176.45	1396683.0
2018-06-18 14:00:00	QQQ	ETF	176.44	176.55	176.27	176.37	2090299.0
2018-06-18 15:00:00	QQQ	ETF	176.36	176.63	176.32	176.5	3966103.0
2018-06-18 16:00:00	QQQ	ETF	176.5	176.56	176.41	176.54	3144705.0
2018-06-18 17:00:00	QQQ	ETF	176.51	176.55	176.43	176.55	5339.0
2018-06-18 18:00:00	QQQ	ETF	176.55	176.58	176.45	176.45	21372.0
2018-06-18 19:00:00	QQQ	ETF	176.47	176.51	175.31	175.5	172257.0
2018-06-18 04:00:00	IWM	ETF	167.0	167.0	166.77	166.77	400.0
2018-06-18 05:00:00	IWM	ETF	166.92	166.92	166.8	166.8	470.0
2018-06-18 06:00:00	IWM	ETF	166.9	166.91	166.61	166.62	1867.0
2018-06-18 07:00:00	IWM	ETF	166.66	166.78	166.65	166.75	179450.0
2018-06-18 08:00:00	IWM	ETF	166.72	166.91	166.64	166.9	117970.0
2018-06-18 09:00:00	IWM	ETF	166.91	167.68	166.73	167.54	2252291.0
2018-06-18 10:00:00	IWM	ETF	167.54	168.4	167.46	168.22	2674202.0
2018-06-18 11:00:00	IWM	ETF	168.22	168.47	167.6	167.64	1823712.0
2018-06-18 12:00:00	IWM	ETF	167.66	167.81	167.38	167.69	1193074.0
2018-06-18 13:00:00	IWM	ETF	167.69	167.91	167.61	167.72	882912.0
2018-06-18 14:00:00	IWM	ETF	167.72	168.6	167.62	168.15	2256797.0
2018-06-18 15:00:00	IWM	ETF	168.15	168.61	168.08	168.59	3247153.0
2018-06-18 16:00:00	IWM	ETF	168.6	168.79	168.5442	168.7301	541886.0
2018-06-18 17:00:00	IWM	ETF	168.74	168.74	168.68	168.68	4553.0
2018-06-18 18:00:00	IWM	ETF	168.68	168.74	168.67	168.67	6010.0
2018-06-18 19:00:00	IWM	ETF	168.65	168.65	167.93	168.03	13912.0
2018-06-18 04:00:00	DIA	ETF	250.02	250.02	249.31	249.51	1115.0
2018-06-18 05:00:00	DIA	ETF	249.43	249.43	249.3	249.3	400.0

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

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