PREVIEW / etf_1hour / 2018-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-09.parquet
  size:    335 KB
  rows:    10,806

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-02-09 04:00:00	SPY	ETF	261.08	261.16	260.5	260.89	61843.0
2018-02-09 05:00:00	SPY	ETF	260.78	261.23	260.41	260.9	28564.0
2018-02-09 06:00:00	SPY	ETF	260.9	261.05	259.17	260.0	315880.0
2018-02-09 07:00:00	SPY	ETF	260.0	260.5	257.92	258.32	672678.0
2018-02-09 08:00:00	SPY	ETF	258.325	261.13	257.95	260.83	1406959.0
2018-02-09 09:00:00	SPY	ETF	260.8	261.76	259.28	260.75	23107045.0
2018-02-09 10:00:00	SPY	ETF	260.76	261.21	256.5	258.49	32749085.0
2018-02-09 11:00:00	SPY	ETF	258.5	259.66	256.67	256.75	17237034.0
2018-02-09 12:00:00	SPY	ETF	256.749	257.05	253.76	256.39	34221523.0
2018-02-09 13:00:00	SPY	ETF	256.36	256.9	252.92	255.73	37114674.0
2018-02-09 14:00:00	SPY	ETF	255.71	260.76	255.62	258.47	38549803.0
2018-02-09 15:00:00	SPY	ETF	258.45	263.61	256.55	261.67	69869285.0
2018-02-09 16:00:00	SPY	ETF	261.69	262.2	261.19	262.05	19219904.0
2018-02-09 17:00:00	SPY	ETF	262.0	262.49	261.6647	262.4	4661555.0
2018-02-09 18:00:00	SPY	ETF	262.4	262.45	262.34	262.4	33516.0
2018-02-09 19:00:00	SPY	ETF	262.41	262.44	261.5	262.42	236986.0
2018-02-09 04:00:00	QQQ	ETF	155.04	155.25	154.81	155.12	72060.0
2018-02-09 05:00:00	QQQ	ETF	155.0	155.24	154.73	154.96	36618.0
2018-02-09 06:00:00	QQQ	ETF	154.97	155.0	154.0	154.6	55671.0
2018-02-09 07:00:00	QQQ	ETF	154.66	154.83	153.79	154.08	444363.0
2018-02-09 08:00:00	QQQ	ETF	154.26	155.38	153.25	155.19	662784.0
2018-02-09 09:00:00	QQQ	ETF	155.19	156.46	154.705	155.8987	8969248.0
2018-02-09 10:00:00	QQQ	ETF	155.89	156.33	153.07	154.2163	13231582.0
2018-02-09 11:00:00	QQQ	ETF	154.21	155.12	152.96	153.02	8094625.0
2018-02-09 12:00:00	QQQ	ETF	153.01	153.245	150.27	152.45	14138760.0
2018-02-09 13:00:00	QQQ	ETF	152.4	152.89	150.125	152.17	12655291.0
2018-02-09 14:00:00	QQQ	ETF	152.17	155.72	152.1	154.35	16836553.0
2018-02-09 15:00:00	QQQ	ETF	154.34	157.24	152.98	156.13	19513730.0
2018-02-09 16:00:00	QQQ	ETF	156.15	156.8	155.94	156.5	1969704.0
2018-02-09 17:00:00	QQQ	ETF	156.35	156.6	156.1	156.6	178522.0
2018-02-09 18:00:00	QQQ	ETF	156.6	156.65	156.54	156.62	11085.0
2018-02-09 19:00:00	QQQ	ETF	156.63	156.73	156.1	156.7	847496.0
2018-02-09 04:00:00	IWM	ETF	146.79	146.9	146.68	146.75	10200.0
2018-02-09 05:00:00	IWM	ETF	146.75	147.1	146.64	146.96	11515.0
2018-02-09 06:00:00	IWM	ETF	146.99	147.03	145.72	145.98	13920.0
2018-02-09 07:00:00	IWM	ETF	146.29	146.39	145.16	145.23	141360.0
2018-02-09 08:00:00	IWM	ETF	145.63	146.94	145.26	146.94	444739.0
2018-02-09 09:00:00	IWM	ETF	146.93	147.27	146.02	146.79	4745130.0
2018-02-09 10:00:00	IWM	ETF	146.78	146.95	144.48	145.35	4809228.0
2018-02-09 11:00:00	IWM	ETF	145.36	146.12	144.45	144.5	3618889.0
2018-02-09 12:00:00	IWM	ETF	144.5	144.645	142.5	143.91	5813462.0
2018-02-09 13:00:00	IWM	ETF	143.9	144.74	142.71	144.47	6405071.0
2018-02-09 14:00:00	IWM	ETF	144.47	146.78	144.43	145.66	6876611.0
2018-02-09 15:00:00	IWM	ETF	145.69	147.94	145.07	146.74	10373670.0
2018-02-09 16:00:00	IWM	ETF	146.77	147.18	143.7	146.77	4134151.0
2018-02-09 17:00:00	IWM	ETF	146.89	147.19	146.77	147.19	358864.0
2018-02-09 18:00:00	IWM	ETF	147.12	147.12	147.12	147.12	593.0
2018-02-09 19:00:00	IWM	ETF	147.12	147.15	146.77	147.15	593007.0
2018-02-09 04:00:00	DIA	ETF	241.3	241.3	241.1	241.1	1000.0
2018-02-09 05:00:00	DIA	ETF	241.78	241.78	241.22	241.22	500.0

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

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