PREVIEW / etf_1hour / 2017-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-28.parquet
  size:    273 KB
  rows:    8,958

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
2017-07-28 04:00:00	SPY	ETF	246.67	247.18	246.44	246.45	17322.0
2017-07-28 05:00:00	SPY	ETF	246.44	246.47	246.27	246.38	82586.0
2017-07-28 06:00:00	SPY	ETF	246.3	246.42	246.05	246.4	81169.0
2017-07-28 07:00:00	SPY	ETF	246.43	246.7	246.4	246.56	84053.0
2017-07-28 08:00:00	SPY	ETF	246.54	246.7	246.48	246.64	535230.0
2017-07-28 09:00:00	SPY	ETF	246.64	246.87	246.43	246.489	7134719.0
2017-07-28 10:00:00	SPY	ETF	246.49	246.62	246.2	246.35	7936973.0
2017-07-28 11:00:00	SPY	ETF	246.355	246.705	246.13	246.67	5065709.0
2017-07-28 12:00:00	SPY	ETF	246.67	246.78	246.605	246.66	2391683.0
2017-07-28 13:00:00	SPY	ETF	246.66	246.75	246.56	246.64	2771779.0
2017-07-28 14:00:00	SPY	ETF	246.65	246.87	246.59	246.8225	3467961.0
2017-07-28 15:00:00	SPY	ETF	246.83	247.06	246.68	246.9	10964196.0
2017-07-28 16:00:00	SPY	ETF	246.9	247.08	246.7019	247.0	7263098.0
2017-07-28 17:00:00	SPY	ETF	246.99	247.05	246.91	247.02	1431675.0
2017-07-28 18:00:00	SPY	ETF	247.02	247.08	246.99	247.04	34593.0
2017-07-28 19:00:00	SPY	ETF	247.04	247.07	247.04	247.07	18470.0
2017-07-28 04:00:00	QQQ	ETF	142.89	142.89	142.57	142.64	15971.0
2017-07-28 05:00:00	QQQ	ETF	142.64	142.64	142.47	142.6	5603.0
2017-07-28 06:00:00	QQQ	ETF	142.48	142.77	142.46	142.7	45002.0
2017-07-28 07:00:00	QQQ	ETF	142.79	143.16	142.69	143.03	69196.0
2017-07-28 08:00:00	QQQ	ETF	143.05	143.17	142.63	143.16	834269.0
2017-07-28 09:00:00	QQQ	ETF	143.19	143.77	142.87	143.35	6419908.0
2017-07-28 10:00:00	QQQ	ETF	143.35	143.65	143.18	143.29	6918421.0
2017-07-28 11:00:00	QQQ	ETF	143.29	143.73	143.24	143.72	3491827.0
2017-07-28 12:00:00	QQQ	ETF	143.73	144.0752	143.69	143.99	2375259.0
2017-07-28 13:00:00	QQQ	ETF	143.9801	144.02	143.8	143.87	1750524.0
2017-07-28 14:00:00	QQQ	ETF	143.88	144.01	143.82	143.93	1907029.0
2017-07-28 15:00:00	QQQ	ETF	143.94	143.97	143.68	143.85	5536482.0
2017-07-28 16:00:00	QQQ	ETF	143.84	143.99	143.5143	143.97	2378407.0
2017-07-28 17:00:00	QQQ	ETF	143.96	143.99	143.88	143.88	6020.0
2017-07-28 18:00:00	QQQ	ETF	143.95	143.95	143.9	143.93	950.0
2017-07-28 19:00:00	QQQ	ETF	143.97	143.99	143.92	143.98	2224.0
2017-07-28 04:00:00	IWM	ETF	141.8	141.8	141.56	141.56	2657.0
2017-07-28 05:00:00	IWM	ETF	141.75	141.78	141.63	141.78	2696.0
2017-07-28 06:00:00	IWM	ETF	141.57	141.6	141.09	141.09	7900.0
2017-07-28 07:00:00	IWM	ETF	141.33	141.87	141.33	141.87	7088.0
2017-07-28 08:00:00	IWM	ETF	141.79	141.85	141.71	141.85	37264.0
2017-07-28 09:00:00	IWM	ETF	141.86	142.36	141.8	141.98	1803130.0
2017-07-28 10:00:00	IWM	ETF	141.99	142.1892	141.7427	142.01	2650569.0
2017-07-28 11:00:00	IWM	ETF	142.02	142.09	141.47	141.588	2544088.0
2017-07-28 12:00:00	IWM	ETF	141.59	141.705	141.48	141.6511	964927.0
2017-07-28 13:00:00	IWM	ETF	141.655	141.83	141.54	141.73	982320.0
2017-07-28 14:00:00	IWM	ETF	141.74	141.96	141.71	141.87	811640.0
2017-07-28 15:00:00	IWM	ETF	141.87	142.08	141.69	141.95	3386640.0
2017-07-28 16:00:00	IWM	ETF	141.96	142.09	141.84	141.91	3135535.0
2017-07-28 17:00:00	IWM	ETF	141.99	141.99	141.91	141.96	6030.0
2017-07-28 18:00:00	IWM	ETF	141.97	141.97	141.97	141.97	1301.0
2017-07-28 19:00:00	IWM	ETF	142.07	142.09	142.02	142.09	1550.0
2017-07-28 06:00:00	DIA	ETF	217.32	217.35	217.32	217.35	1600.0
2017-07-28 07:00:00	DIA	ETF	217.4	217.4	217.4	217.4	800.0

> showing 50 of 8,958 rows — these rows as CSV

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