PREVIEW / etf_1hour / 2018-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-29.parquet
  size:    307 KB
  rows:    10,152

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-05-29 04:00:00	SPY	ETF	270.9	270.9	269.33	269.92	99742.0
2018-05-29 05:00:00	SPY	ETF	269.92	270.29	269.74	270.29	80839.0
2018-05-29 06:00:00	SPY	ETF	270.35	270.51	269.8	269.87	223968.0
2018-05-29 07:00:00	SPY	ETF	269.87	270.44	269.57	270.24	517944.0
2018-05-29 08:00:00	SPY	ETF	269.6201	271.75	269.605	270.73	972510.0
2018-05-29 09:00:00	SPY	ETF	270.69	271.08	269.92	270.93	9507617.0
2018-05-29 10:00:00	SPY	ETF	270.93	271.17	270.32	270.34	10189225.0
2018-05-29 11:00:00	SPY	ETF	270.36	270.49	268.85	268.9163	12843305.0
2018-05-29 12:00:00	SPY	ETF	268.92	269.39	267.89	269.29	14085308.0
2018-05-29 13:00:00	SPY	ETF	269.28	269.3	268.275	268.61	9120352.0
2018-05-29 14:00:00	SPY	ETF	268.6	268.84	267.77	267.83	11698088.0
2018-05-29 15:00:00	SPY	ETF	267.84	269.38	267.76	269.1	28370122.0
2018-05-29 16:00:00	SPY	ETF	269.07	269.56	268.7832	269.5	14141206.0
2018-05-29 17:00:00	SPY	ETF	269.51	269.6	269.02	269.55	635662.0
2018-05-29 18:00:00	SPY	ETF	269.52	269.58	269.28	269.28	82560.0
2018-05-29 19:00:00	SPY	ETF	269.29	269.42	269.02	269.1	105769.0
2018-05-29 04:00:00	QQQ	ETF	169.27	169.28	168.07	168.41	33619.0
2018-05-29 05:00:00	QQQ	ETF	168.4	168.79	168.4	168.79	17465.0
2018-05-29 06:00:00	QQQ	ETF	168.81	169.07	168.55	168.67	43717.0
2018-05-29 07:00:00	QQQ	ETF	168.65	168.83	168.35	168.69	113276.0
2018-05-29 08:00:00	QQQ	ETF	168.68	169.22	168.38	169.22	258078.0
2018-05-29 09:00:00	QQQ	ETF	169.11	169.75	168.57	169.65	5604742.0
2018-05-29 10:00:00	QQQ	ETF	169.65	169.92	169.12	169.47	4496834.0
2018-05-29 11:00:00	QQQ	ETF	169.46	169.55	168.391	168.53	4778190.0
2018-05-29 12:00:00	QQQ	ETF	168.53	169.04	167.96	169.0	3998922.0
2018-05-29 13:00:00	QQQ	ETF	168.99	169.01	168.38	168.64	3259583.0
2018-05-29 14:00:00	QQQ	ETF	168.63	168.89	168.09	168.18	4574714.0
2018-05-29 15:00:00	QQQ	ETF	168.18	169.16	168.02	168.95	6723353.0
2018-05-29 16:00:00	QQQ	ETF	168.95	169.33	168.3738	169.33	1459896.0
2018-05-29 17:00:00	QQQ	ETF	169.33	169.33	169.26	169.29	19666.0
2018-05-29 18:00:00	QQQ	ETF	169.3	169.4	169.1	169.1	21021.0
2018-05-29 19:00:00	QQQ	ETF	169.08	169.15	168.94	169.0	62473.0
2018-05-29 04:00:00	IWM	ETF	160.79	160.8	159.89	160.25	7316.0
2018-05-29 05:00:00	IWM	ETF	160.11	160.19	160.07	160.19	1450.0
2018-05-29 06:00:00	IWM	ETF	160.5	160.5	160.2	160.2	11100.0
2018-05-29 07:00:00	IWM	ETF	160.24	160.54	160.03	160.54	93052.0
2018-05-29 08:00:00	IWM	ETF	160.38	160.99	160.38	160.94	131809.0
2018-05-29 09:00:00	IWM	ETF	160.94	161.9	160.75	161.81	2205699.0
2018-05-29 10:00:00	IWM	ETF	161.83	162.23	161.7	161.88	2316430.0
2018-05-29 11:00:00	IWM	ETF	161.8825	162.1	160.94	161.0357	2216871.0
2018-05-29 12:00:00	IWM	ETF	161.04	161.52	160.11	161.45	3570365.0
2018-05-29 13:00:00	IWM	ETF	161.45	161.46	161.0	161.15	1780649.0
2018-05-29 14:00:00	IWM	ETF	161.14	161.39	160.83	160.87	1905897.0
2018-05-29 15:00:00	IWM	ETF	160.86	161.84	160.82	161.54	3911512.0
2018-05-29 16:00:00	IWM	ETF	161.52	161.77	161.5	161.76	817114.0
2018-05-29 18:00:00	IWM	ETF	161.69	161.69	161.61	161.61	5958.0
2018-05-29 19:00:00	IWM	ETF	161.6	161.64	161.46	161.48	14204.0
2018-05-29 04:00:00	DIA	ETF	246.24	246.24	245.25	245.25	310.0
2018-05-29 06:00:00	DIA	ETF	245.8	245.8	245.5	245.52	300.0
2018-05-29 07:00:00	DIA	ETF	245.4	246.1	245.08	245.77	8047.0

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

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