PREVIEW / etf_1hour / 2018-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-30.parquet
  size:    296 KB
  rows:    9,693

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-04-30 04:00:00	SPY	ETF	267.32	267.61	267.32	267.6	11383.0
2018-04-30 05:00:00	SPY	ETF	267.58	267.89	267.54	267.89	14017.0
2018-04-30 06:00:00	SPY	ETF	267.87	267.94	267.62	267.75	39287.0
2018-04-30 07:00:00	SPY	ETF	267.77	267.82	267.52	267.68	98990.0
2018-04-30 08:00:00	SPY	ETF	267.7	267.78	267.28	267.45	199963.0
2018-04-30 09:00:00	SPY	ETF	267.44	267.89	267.16	267.4808	5427803.0
2018-04-30 10:00:00	SPY	ETF	267.48	267.87	266.93	267.289	5588801.0
2018-04-30 11:00:00	SPY	ETF	267.29	267.52	266.02	266.26	6219929.0
2018-04-30 12:00:00	SPY	ETF	266.26	266.27	265.19	265.7492	6505657.0
2018-04-30 13:00:00	SPY	ETF	265.74	266.2	265.295	266.06	5882277.0
2018-04-30 14:00:00	SPY	ETF	266.05	266.5866	264.98	265.22	12282955.0
2018-04-30 15:00:00	SPY	ETF	265.23	265.65	264.43	264.45	20237853.0
2018-04-30 16:00:00	SPY	ETF	264.44	266.5866	264.26	264.3	15217470.0
2018-04-30 17:00:00	SPY	ETF	264.29	264.51	264.29	264.39	1594452.0
2018-04-30 18:00:00	SPY	ETF	264.43	264.43	264.0	264.1	122984.0
2018-04-30 19:00:00	SPY	ETF	264.1	264.68	264.09	264.63	237919.0
2018-04-30 04:00:00	QQQ	ETF	162.8	163.16	162.8	163.13	57637.0
2018-04-30 05:00:00	QQQ	ETF	163.09	163.27	163.05	163.23	32400.0
2018-04-30 06:00:00	QQQ	ETF	163.29	163.29	163.02	163.22	18639.0
2018-04-30 07:00:00	QQQ	ETF	163.18	163.21	162.88	163.01	73878.0
2018-04-30 08:00:00	QQQ	ETF	162.97	163.05	162.7	162.76	180277.0
2018-04-30 09:00:00	QQQ	ETF	162.75	163.22	162.35	162.93	3584022.0
2018-04-30 10:00:00	QQQ	ETF	162.92	163.48	162.67	162.87	4200057.0
2018-04-30 11:00:00	QQQ	ETF	162.89	163.03	161.25	161.49	4539116.0
2018-04-30 12:00:00	QQQ	ETF	161.49	161.49	160.54	161.08	5611049.0
2018-04-30 13:00:00	QQQ	ETF	161.07	161.55	160.75	161.54	2890092.0
2018-04-30 14:00:00	QQQ	ETF	161.54	161.54	160.77	161.09	2637183.0
2018-04-30 15:00:00	QQQ	ETF	161.09	161.65	160.85	160.89	5507007.0
2018-04-30 16:00:00	QQQ	ETF	160.89	162.374	160.7	160.72	1240156.0
2018-04-30 17:00:00	QQQ	ETF	160.87	160.97	160.73	160.83	332787.0
2018-04-30 18:00:00	QQQ	ETF	160.9	160.94	160.63	160.75	42904.0
2018-04-30 19:00:00	QQQ	ETF	160.74	161.17	160.72	161.1	37007.0
2018-04-30 04:00:00	IWM	ETF	154.93	155.0	154.93	155.0	875.0
2018-04-30 05:00:00	IWM	ETF	155.05	155.14	155.05	155.14	600.0
2018-04-30 07:00:00	IWM	ETF	155.18	155.22	155.01	155.2	11563.0
2018-04-30 08:00:00	IWM	ETF	155.12	155.25	155.06	155.06	14950.0
2018-04-30 09:00:00	IWM	ETF	155.12	155.65	154.98	155.27	1059570.0
2018-04-30 10:00:00	IWM	ETF	155.28	155.52	154.64	154.8	1453941.0
2018-04-30 11:00:00	IWM	ETF	154.82	154.92	154.23	154.4	1146401.0
2018-04-30 12:00:00	IWM	ETF	154.41	154.41	154.0	154.28	1111364.0
2018-04-30 13:00:00	IWM	ETF	154.28	154.51	154.01	154.37	1089299.0
2018-04-30 14:00:00	IWM	ETF	154.37	154.37	153.6	153.67	1841415.0
2018-04-30 15:00:00	IWM	ETF	153.65	153.88	153.3	153.31	3859003.0
2018-04-30 16:00:00	IWM	ETF	153.3	153.35	153.16	153.24	1664198.0
2018-04-30 17:00:00	IWM	ETF	153.28	153.31	153.17	153.3	311452.0
2018-04-30 18:00:00	IWM	ETF	153.3	153.39	153.14	153.14	4975.0
2018-04-30 19:00:00	IWM	ETF	153.12	153.44	153.12	153.44	3087.0
2018-04-30 04:00:00	DIA	ETF	243.95	243.95	243.95	243.95	130.0
2018-04-30 06:00:00	DIA	ETF	244.14	244.22	244.14	244.22	1700.0
2018-04-30 07:00:00	DIA	ETF	244.16	244.25	244.15	244.15	11456.0

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

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