PREVIEW / etf_1hour / 2018-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-03.parquet
  size:    299 KB
  rows:    9,775

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-03 04:00:00	SPY	ETF	257.91	258.09	257.87	258.05	34927.0
2018-04-03 05:00:00	SPY	ETF	258.01	258.15	257.85	257.85	10137.0
2018-04-03 06:00:00	SPY	ETF	257.92	258.47	257.92	258.19	77162.0
2018-04-03 07:00:00	SPY	ETF	258.15	258.47	258.02	258.42	154593.0
2018-04-03 08:00:00	SPY	ETF	258.47	259.1	257.7	259.03	670750.0
2018-04-03 09:00:00	SPY	ETF	259.03	259.23	258.04	258.37	17182378.0
2018-04-03 10:00:00	SPY	ETF	258.37	259.35	256.84	259.17	14934830.0
2018-04-03 11:00:00	SPY	ETF	259.15	260.08	258.09	258.11	12661727.0
2018-04-03 12:00:00	SPY	ETF	258.11	258.85	257.85	258.33	9299091.0
2018-04-03 13:00:00	SPY	ETF	258.32	259.4	258.01	259.07	10770353.0
2018-04-03 14:00:00	SPY	ETF	259.07	259.71	257.4	259.4	16107800.0
2018-04-03 15:00:00	SPY	ETF	259.4	261.31	259.17	260.77	30532293.0
2018-04-03 16:00:00	SPY	ETF	260.8	260.86	258.4627	260.61	5715197.0
2018-04-03 17:00:00	SPY	ETF	260.6	260.65	260.48	260.58	224866.0
2018-04-03 18:00:00	SPY	ETF	260.48	260.6	260.36	260.54	193113.0
2018-04-03 19:00:00	SPY	ETF	260.5	260.5	260.19	260.28	34872.0
2018-04-03 04:00:00	QQQ	ETF	156.1	156.27	156.0	156.19	53866.0
2018-04-03 05:00:00	QQQ	ETF	156.14	156.33	156.01	156.02	6911.0
2018-04-03 06:00:00	QQQ	ETF	156.1	156.57	156.0	156.3	27700.0
2018-04-03 07:00:00	QQQ	ETF	156.29	156.45	156.11	156.45	173474.0
2018-04-03 08:00:00	QQQ	ETF	156.45	157.18	156.13	157.17	392891.0
2018-04-03 09:00:00	QQQ	ETF	157.17	157.255	155.78	155.97	5929670.0
2018-04-03 10:00:00	QQQ	ETF	155.98	156.71	154.44	156.53	11573780.0
2018-04-03 11:00:00	QQQ	ETF	156.53	157.6	155.41	155.42	7540343.0
2018-04-03 12:00:00	QQQ	ETF	155.44	156.0799	155.055	155.61	3843463.0
2018-04-03 13:00:00	QQQ	ETF	155.59	156.47	155.31	156.27	3875933.0
2018-04-03 14:00:00	QQQ	ETF	156.25	156.97	154.9	156.75	7693760.0
2018-04-03 15:00:00	QQQ	ETF	156.75	157.92	156.56	157.24	11434435.0
2018-04-03 16:00:00	QQQ	ETF	157.25	157.4	156.6584	157.29	2864939.0
2018-04-03 17:00:00	QQQ	ETF	157.34	157.34	157.05	157.14	77297.0
2018-04-03 18:00:00	QQQ	ETF	157.17	157.22	157.04	157.12	62290.0
2018-04-03 19:00:00	QQQ	ETF	157.09	157.1	156.85	156.88	37446.0
2018-04-03 04:00:00	IWM	ETF	148.65	148.99	148.53	148.65	23021.0
2018-04-03 05:00:00	IWM	ETF	148.68	148.71	148.63	148.71	2700.0
2018-04-03 06:00:00	IWM	ETF	148.78	149.26	148.77	148.93	10300.0
2018-04-03 07:00:00	IWM	ETF	148.78	148.89	148.65	148.83	20345.0
2018-04-03 08:00:00	IWM	ETF	148.85	149.2	148.85	149.2	204335.0
2018-04-03 09:00:00	IWM	ETF	149.2	149.78	148.13	149.01	4260393.0
2018-04-03 10:00:00	IWM	ETF	149.02	149.6672	148.3	149.55	3531448.0
2018-04-03 11:00:00	IWM	ETF	149.54	150.12	149.22	149.39	3125280.0
2018-04-03 12:00:00	IWM	ETF	149.4	149.94	149.04	149.12	1884626.0
2018-04-03 13:00:00	IWM	ETF	149.13	149.75	148.78	149.33	2165718.0
2018-04-03 14:00:00	IWM	ETF	149.35	149.9499	148.93	149.79	2257928.0
2018-04-03 15:00:00	IWM	ETF	149.79	150.6	149.7	150.23	4759262.0
2018-04-03 16:00:00	IWM	ETF	150.23	150.37	150.05	150.34	1967582.0
2018-04-03 17:00:00	IWM	ETF	150.26	150.26	150.24	150.25	3476.0
2018-04-03 18:00:00	IWM	ETF	150.25	150.34	150.12	150.15	208403.0
2018-04-03 19:00:00	IWM	ETF	150.11	150.11	150.0	150.0	573.0
2018-04-03 04:00:00	DIA	ETF	236.22	236.22	236.1	236.1	700.0
2018-04-03 07:00:00	DIA	ETF	236.83	236.83	236.52	236.77	12641.0

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

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