PREVIEW / etf_1hour / 2017-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-24.parquet
  size:    272 KB
  rows:    8,904

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-08-24 04:00:00	SPY	ETF	244.25	244.7	244.25	244.63	42251.0
2017-08-24 05:00:00	SPY	ETF	244.58	244.7	244.57	244.7	11331.0
2017-08-24 06:00:00	SPY	ETF	244.71	244.79	244.62	244.67	30686.0
2017-08-24 07:00:00	SPY	ETF	244.65	244.94	244.57	244.87	504552.0
2017-08-24 08:00:00	SPY	ETF	244.85	245.09	244.6	245.05	477715.0
2017-08-24 09:00:00	SPY	ETF	245.05	245.18	244.12	244.19	6770341.0
2017-08-24 10:00:00	SPY	ETF	244.19	245.0	244.0	244.69	6718996.0
2017-08-24 11:00:00	SPY	ETF	244.69	244.76	243.75	244.22	8701828.0
2017-08-24 12:00:00	SPY	ETF	244.23	244.37	244.08	244.25	3641219.0
2017-08-24 13:00:00	SPY	ETF	244.25	244.69	244.18	244.37	3373311.0
2017-08-24 14:00:00	SPY	ETF	244.36	244.44	244.02	244.33	4142232.0
2017-08-24 15:00:00	SPY	ETF	244.32	244.42	243.92	244.03	10909455.0
2017-08-24 16:00:00	SPY	ETF	244.04	244.53	243.99	244.5	3985012.0
2017-08-24 17:00:00	SPY	ETF	244.48	244.52	244.46	244.5	470622.0
2017-08-24 18:00:00	SPY	ETF	244.5	244.64	244.46	244.53	125937.0
2017-08-24 19:00:00	SPY	ETF	244.53	244.53	244.42	244.47	62904.0
2017-08-24 04:00:00	QQQ	ETF	142.41	142.8	142.41	142.8	7469.0
2017-08-24 05:00:00	QQQ	ETF	142.74	142.84	142.74	142.84	5311.0
2017-08-24 06:00:00	QQQ	ETF	142.87	142.9	142.79	142.85	15373.0
2017-08-24 07:00:00	QQQ	ETF	142.87	142.97	142.8	142.95	36202.0
2017-08-24 08:00:00	QQQ	ETF	142.93	143.08	142.87	143.06	92836.0
2017-08-24 09:00:00	QQQ	ETF	143.08	143.17	142.2	142.26	2924775.0
2017-08-24 10:00:00	QQQ	ETF	142.26	142.65	141.93	142.44	3991955.0
2017-08-24 11:00:00	QQQ	ETF	142.45	142.5	141.47	141.86	5650958.0
2017-08-24 12:00:00	QQQ	ETF	141.86	142.1456	141.73	142.06	2596308.0
2017-08-24 13:00:00	QQQ	ETF	142.045	142.46	141.99	142.29	1928303.0
2017-08-24 14:00:00	QQQ	ETF	142.28	142.42	141.98	142.41	2248955.0
2017-08-24 15:00:00	QQQ	ETF	142.41	142.532	142.16	142.28	4228423.0
2017-08-24 16:00:00	QQQ	ETF	142.28	142.5	142.24	142.5	781591.0
2017-08-24 17:00:00	QQQ	ETF	142.5	142.52	142.27	142.47	3114331.0
2017-08-24 18:00:00	QQQ	ETF	142.48	142.62	142.48	142.53	10146.0
2017-08-24 19:00:00	QQQ	ETF	142.48	142.48	142.41	142.44	2800.0
2017-08-24 04:00:00	IWM	ETF	136.06	136.19	136.06	136.19	5566.0
2017-08-24 06:00:00	IWM	ETF	136.31	136.31	136.25	136.25	4551.0
2017-08-24 07:00:00	IWM	ETF	136.24	136.47	136.24	136.47	15300.0
2017-08-24 08:00:00	IWM	ETF	136.46	136.66	136.42	136.62	40336.0
2017-08-24 09:00:00	IWM	ETF	136.57	136.93	136.02	136.09	2103120.0
2017-08-24 10:00:00	IWM	ETF	136.08	136.89	136.0662	136.61	2889220.0
2017-08-24 11:00:00	IWM	ETF	136.62	136.78	136.34	136.74	2166117.0
2017-08-24 12:00:00	IWM	ETF	136.75	136.77	136.5	136.52	1111439.0
2017-08-24 13:00:00	IWM	ETF	136.51	136.6	136.28	136.37	1019105.0
2017-08-24 14:00:00	IWM	ETF	136.36	136.74	136.25	136.74	1025086.0
2017-08-24 15:00:00	IWM	ETF	136.72	136.76	136.4534	136.5	2104611.0
2017-08-24 16:00:00	IWM	ETF	136.51	136.77	136.48	136.61	1663336.0
2017-08-24 17:00:00	IWM	ETF	136.65	136.65	136.58	136.58	1586.0
2017-08-24 18:00:00	IWM	ETF	136.65	136.67	136.65	136.67	1015.0
2017-08-24 19:00:00	IWM	ETF	136.62	136.67	136.6	136.67	2900.0
2017-08-24 08:00:00	DIA	ETF	218.54	218.55	218.54	218.55	1100.0
2017-08-24 09:00:00	DIA	ETF	218.55	218.55	217.64	217.68	262459.0
2017-08-24 10:00:00	DIA	ETF	217.67	218.27	217.56	218.14	252407.0

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

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