PREVIEW / etf_1hour / 2019-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-18.parquet
  size:    333 KB
  rows:    10,933

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-01-18 04:00:00	SPY	ETF	263.56	263.81	263.5	263.73	107849.0
2019-01-18 05:00:00	SPY	ETF	263.74	263.82	263.34	263.57	32034.0
2019-01-18 06:00:00	SPY	ETF	263.59	264.23	263.55	264.14	111964.0
2019-01-18 07:00:00	SPY	ETF	264.16	264.32	263.98	264.08	212270.0
2019-01-18 08:00:00	SPY	ETF	264.12	266.55	263.5	264.25	702735.0
2019-01-18 09:00:00	SPY	ETF	264.25	265.15	264.14	264.5174	13234257.0
2019-01-18 10:00:00	SPY	ETF	264.51	265.76	264.1	265.64	31666934.0
2019-01-18 11:00:00	SPY	ETF	265.63	266.48	265.55	266.48	10941305.0
2019-01-18 12:00:00	SPY	ETF	266.49	266.98	266.16	266.7246	10341915.0
2019-01-18 13:00:00	SPY	ETF	266.73	266.89	265.96	266.47	9735205.0
2019-01-18 14:00:00	SPY	ETF	266.46	266.5	265.57	266.04	7849612.0
2019-01-18 15:00:00	SPY	ETF	266.05	266.57	265.73	266.42	20958162.0
2019-01-18 16:00:00	SPY	ETF	266.44	267.05	266.28	267.04	13376133.0
2019-01-18 17:00:00	SPY	ETF	266.98	267.0	266.46	266.87	4425849.0
2019-01-18 18:00:00	SPY	ETF	266.89	266.95	266.4	266.46	454981.0
2019-01-18 19:00:00	SPY	ETF	266.45	266.6	266.37	266.58	124176.0
2019-01-18 04:00:00	QQQ	ETF	163.72	164.17	163.72	164.07	15701.0
2019-01-18 05:00:00	QQQ	ETF	164.12	164.12	163.71	163.82	15540.0
2019-01-18 06:00:00	QQQ	ETF	163.88	164.2	163.81	164.16	40735.0
2019-01-18 07:00:00	QQQ	ETF	164.15	164.26	164.03	164.16	107687.0
2019-01-18 08:00:00	QQQ	ETF	164.18	164.4	163.63	164.34	245761.0
2019-01-18 09:00:00	QQQ	ETF	164.34	165.03	163.91	164.1585	5911825.0
2019-01-18 10:00:00	QQQ	ETF	164.15	165.27	163.82	165.25	7794051.0
2019-01-18 11:00:00	QQQ	ETF	165.25	165.7573	165.19	165.67	4828509.0
2019-01-18 12:00:00	QQQ	ETF	165.68	166.02	165.5514	165.86	4125622.0
2019-01-18 13:00:00	QQQ	ETF	165.86	165.93	165.29	165.48	2498261.0
2019-01-18 14:00:00	QQQ	ETF	165.48	165.49	164.614	165.01	4295680.0
2019-01-18 15:00:00	QQQ	ETF	165.02	165.29	164.71	165.2	7901822.0
2019-01-18 16:00:00	QQQ	ETF	165.21	165.49	165.0	165.49	2184793.0
2019-01-18 17:00:00	QQQ	ETF	165.45	165.45	165.1501	165.27	114619.0
2019-01-18 18:00:00	QQQ	ETF	165.27	165.52	165.21	165.3	106475.0
2019-01-18 19:00:00	QQQ	ETF	165.3	165.45	165.27	165.45	16125.0
2019-01-18 05:00:00	IWM	ETF	146.37	146.37	146.22	146.23	3200.0
2019-01-18 06:00:00	IWM	ETF	146.24	146.5	146.24	146.5	650.0
2019-01-18 07:00:00	IWM	ETF	146.51	146.53	146.35	146.4	57511.0
2019-01-18 08:00:00	IWM	ETF	146.5	146.5	146.23	146.4	10777.0
2019-01-18 09:00:00	IWM	ETF	146.33	146.93	146.08	146.2916	3619537.0
2019-01-18 10:00:00	IWM	ETF	146.29	147.3249	146.0	147.08	3712142.0
2019-01-18 11:00:00	IWM	ETF	147.0715	147.44	146.93	147.33	2736613.0
2019-01-18 12:00:00	IWM	ETF	147.34	147.92	147.29	147.62	2995579.0
2019-01-18 13:00:00	IWM	ETF	147.64	147.765	147.1	147.4	2275367.0
2019-01-18 14:00:00	IWM	ETF	147.41	147.45	146.91	147.17	2499480.0
2019-01-18 15:00:00	IWM	ETF	147.16	147.47	146.91	147.38	4502744.0
2019-01-18 16:00:00	IWM	ETF	147.33	147.55	147.2	147.55	1136204.0
2019-01-18 17:00:00	IWM	ETF	147.56	147.56	147.33	147.44	575522.0
2019-01-18 18:00:00	IWM	ETF	147.33	147.48	147.33	147.4	80207.0
2019-01-18 19:00:00	IWM	ETF	147.4	147.4	147.37	147.39	1513.0
2019-01-18 04:00:00	DIA	ETF	244.2	244.2	244.2	244.2	100.0
2019-01-18 05:00:00	DIA	ETF	244.2	244.2	244.2	244.2	100.0
2019-01-18 07:00:00	DIA	ETF	244.9	245.04	244.87	245.0	7260.0

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

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