PREVIEW / etf_1hour / 2017-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-14.parquet
  size:    270 KB
  rows:    8,803

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-03-14 04:00:00	SPY	ETF	237.89	237.89	237.29	237.31	24346.0
2017-03-14 05:00:00	SPY	ETF	237.33	237.53	237.33	237.53	13811.0
2017-03-14 06:00:00	SPY	ETF	237.5	237.58	237.41	237.51	21229.0
2017-03-14 07:00:00	SPY	ETF	237.54	237.55	237.28	237.3	147293.0
2017-03-14 08:00:00	SPY	ETF	237.3	237.48	236.9	237.11	652471.0
2017-03-14 09:00:00	SPY	ETF	237.11	237.24	236.7	236.85	6914264.0
2017-03-14 10:00:00	SPY	ETF	236.855	237.2	236.19	236.62	11564835.0
2017-03-14 11:00:00	SPY	ETF	236.62	237.0	236.34	236.955	7861490.0
2017-03-14 12:00:00	SPY	ETF	236.955	237.15	236.415	236.54	5023680.0
2017-03-14 13:00:00	SPY	ETF	236.54	237.07	236.49	236.71	7241360.0
2017-03-14 14:00:00	SPY	ETF	236.7	236.95	236.6	236.74	4137462.0
2017-03-14 15:00:00	SPY	ETF	236.74	237.03	236.72	236.93	8864036.0
2017-03-14 16:00:00	SPY	ETF	236.94	237.1	236.86	237.05	6248393.0
2017-03-14 17:00:00	SPY	ETF	237.04	237.7381	237.0	237.05	82728.0
2017-03-14 18:00:00	SPY	ETF	237.05	237.14	237.04	237.1	19447.0
2017-03-14 19:00:00	SPY	ETF	237.1	237.13	237.06	237.08	17088.0
2017-03-14 04:00:00	QQQ	ETF	131.48	131.48	131.4	131.43	31171.0
2017-03-14 06:00:00	QQQ	ETF	131.53	131.55	131.53	131.55	24997.0
2017-03-14 07:00:00	QQQ	ETF	131.5	131.5	131.43	131.47	11589.0
2017-03-14 08:00:00	QQQ	ETF	131.43	131.44	131.21	131.27	219683.0
2017-03-14 09:00:00	QQQ	ETF	131.28	131.36	131.02	131.14	2544525.0
2017-03-14 10:00:00	QQQ	ETF	131.14	131.16	130.76	131.01	2601875.0
2017-03-14 11:00:00	QQQ	ETF	131.0	131.2	130.88	131.18	1336010.0
2017-03-14 12:00:00	QQQ	ETF	131.18	131.23	130.94	131.038	1168677.0
2017-03-14 13:00:00	QQQ	ETF	131.03	131.2446	131.02	131.17	1133530.0
2017-03-14 14:00:00	QQQ	ETF	131.18	131.24	131.09	131.14	903796.0
2017-03-14 15:00:00	QQQ	ETF	131.14	131.32	131.131	131.27	1413018.0
2017-03-14 16:00:00	QQQ	ETF	131.28	131.34	131.23	131.28	506312.0
2017-03-14 17:00:00	QQQ	ETF	131.28	131.28	131.24	131.24	16998.0
2017-03-14 18:00:00	QQQ	ETF	131.27	131.29	131.27	131.28	3719.0
2017-03-14 19:00:00	QQQ	ETF	131.29	131.29	131.26	131.26	11491.0
2017-03-14 04:00:00	IWM	ETF	136.08	136.08	136.08	136.08	2500.0
2017-03-14 07:00:00	IWM	ETF	136.1	136.2	135.9	135.9	27368.0
2017-03-14 08:00:00	IWM	ETF	135.93	135.95	135.44	135.69	74778.0
2017-03-14 09:00:00	IWM	ETF	135.69	135.78	134.95	135.01	3198781.0
2017-03-14 10:00:00	IWM	ETF	135.03	135.12	134.5601	135.12	5103945.0
2017-03-14 11:00:00	IWM	ETF	135.12	135.55	134.94	135.43	4211310.0
2017-03-14 12:00:00	IWM	ETF	135.44	135.49	134.93	135.15	2715875.0
2017-03-14 13:00:00	IWM	ETF	135.16	135.79	135.14	135.512	3382876.0
2017-03-14 14:00:00	IWM	ETF	135.5038	135.67	135.36	135.475	1449071.0
2017-03-14 15:00:00	IWM	ETF	135.47	135.83	135.45	135.6	3392884.0
2017-03-14 16:00:00	IWM	ETF	135.63	135.78	135.5	135.71	1067437.0
2017-03-14 17:00:00	IWM	ETF	135.71	135.84	135.71	135.83	44085.0
2017-03-14 18:00:00	IWM	ETF	135.74	135.81	135.74	135.75	4326.0
2017-03-14 19:00:00	IWM	ETF	135.76	135.82	135.76	135.82	1256.0
2017-03-14 04:00:00	DIA	ETF	208.75	208.75	208.68	208.68	350.0
2017-03-14 06:00:00	DIA	ETF	208.69	208.69	208.69	208.69	200.0
2017-03-14 08:00:00	DIA	ETF	208.69	208.69	208.21	208.32	4161.0
2017-03-14 09:00:00	DIA	ETF	208.45	208.88	208.39	208.63	375364.0
2017-03-14 10:00:00	DIA	ETF	208.63	208.63	207.98	208.38	512780.0

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

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