PREVIEW / etf_1hour / 2018-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-20.parquet
  size:    301 KB
  rows:    9,931

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-20 04:00:00	SPY	ETF	276.34	276.39	276.12	276.22	27763.0
2018-06-20 05:00:00	SPY	ETF	276.31	276.5	276.31	276.48	6852.0
2018-06-20 06:00:00	SPY	ETF	276.37	276.57	276.37	276.38	11610.0
2018-06-20 07:00:00	SPY	ETF	276.44	276.45	275.96	276.1	149646.0
2018-06-20 08:00:00	SPY	ETF	276.32	276.42	275.62	276.35	236042.0
2018-06-20 09:00:00	SPY	ETF	276.35	276.49	276.08	276.31	6482436.0
2018-06-20 10:00:00	SPY	ETF	276.31	276.44	275.59	275.98	7982650.0
2018-06-20 11:00:00	SPY	ETF	275.99	276.33	275.67	276.3	4317307.0
2018-06-20 12:00:00	SPY	ETF	276.31	276.72	276.2133	276.58	4521470.0
2018-06-20 13:00:00	SPY	ETF	276.58	276.63	276.26	276.58	5112284.0
2018-06-20 14:00:00	SPY	ETF	276.58	276.65	275.95	276.0268	6597254.0
2018-06-20 15:00:00	SPY	ETF	276.02	276.37	275.89	275.98	10426636.0
2018-06-20 16:00:00	SPY	ETF	275.99	276.09	275.4815	275.97	5308496.0
2018-06-20 17:00:00	SPY	ETF	275.97	276.04	275.95	276.03	115571.0
2018-06-20 18:00:00	SPY	ETF	276.02	276.19	275.95	276.08	88870.0
2018-06-20 19:00:00	SPY	ETF	276.12	276.27	276.1	276.25	30561.0
2018-06-20 04:00:00	QQQ	ETF	176.39	176.43	176.29	176.4	19185.0
2018-06-20 05:00:00	QQQ	ETF	176.48	176.75	176.48	176.58	10690.0
2018-06-20 06:00:00	QQQ	ETF	176.57	176.62	176.51	176.6	16769.0
2018-06-20 07:00:00	QQQ	ETF	176.56	176.58	176.31	176.4	62050.0
2018-06-20 08:00:00	QQQ	ETF	176.56	176.94	176.38	176.85	141142.0
2018-06-20 09:00:00	QQQ	ETF	176.85	177.28	176.75	177.15	4962171.0
2018-06-20 10:00:00	QQQ	ETF	177.14	177.34	176.65	177.25	4061249.0
2018-06-20 11:00:00	QQQ	ETF	177.26	177.51	177.01	177.51	2258202.0
2018-06-20 12:00:00	QQQ	ETF	177.55	177.9	177.49	177.77	2649763.0
2018-06-20 13:00:00	QQQ	ETF	177.7699	177.82	177.57	177.79	1745325.0
2018-06-20 14:00:00	QQQ	ETF	177.8	177.98	177.35	177.41	3274788.0
2018-06-20 15:00:00	QQQ	ETF	177.41	177.56	177.19	177.25	4607247.0
2018-06-20 16:00:00	QQQ	ETF	177.25	177.53	177.23	177.47	1530815.0
2018-06-20 17:00:00	QQQ	ETF	177.41	177.51	177.38	177.51	17614.0
2018-06-20 18:00:00	QQQ	ETF	177.51	177.56	177.47	177.54	34872.0
2018-06-20 19:00:00	QQQ	ETF	177.55	177.68	177.55	177.65	36928.0
2018-06-20 04:00:00	IWM	ETF	169.41	169.51	169.33	169.51	6170.0
2018-06-20 06:00:00	IWM	ETF	169.54	169.54	169.5	169.5	814.0
2018-06-20 07:00:00	IWM	ETF	169.45	169.45	169.21	169.23	64750.0
2018-06-20 08:00:00	IWM	ETF	169.28	169.43	169.24	169.35	78480.0
2018-06-20 09:00:00	IWM	ETF	169.35	169.48	169.05	169.25	2440635.0
2018-06-20 10:00:00	IWM	ETF	169.25	169.69	168.9515	169.6361	3581195.0
2018-06-20 11:00:00	IWM	ETF	169.63	169.94	169.51	169.92	2039462.0
2018-06-20 12:00:00	IWM	ETF	169.92	170.18	169.835	170.14	1867841.0
2018-06-20 13:00:00	IWM	ETF	170.14	170.2	169.88	170.12	1313375.0
2018-06-20 14:00:00	IWM	ETF	170.13	170.1599	169.97	170.01	1444622.0
2018-06-20 15:00:00	IWM	ETF	170.0	170.18	169.94	169.99	3485030.0
2018-06-20 16:00:00	IWM	ETF	169.99	170.2	169.9	170.01	856088.0
2018-06-20 17:00:00	IWM	ETF	170.13	170.18	169.95	170.09	32858.0
2018-06-20 18:00:00	IWM	ETF	170.03	170.15	170.0	170.14	64734.0
2018-06-20 19:00:00	IWM	ETF	170.14	170.2	170.14	170.17	5481.0
2018-06-20 04:00:00	DIA	ETF	248.1	248.2	247.5	247.98	2300.0
2018-06-20 05:00:00	DIA	ETF	248.05	248.18	248.05	248.18	500.0
2018-06-20 06:00:00	DIA	ETF	248.24	248.24	248.24	248.24	100.0

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

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