PREVIEW / etf_1hour / 2017-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-03-31.parquet
  size:    272 KB
  rows:    8,856

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-31 04:00:00	SPY	ETF	235.76	235.76	235.6	235.6	16375.0
2017-03-31 05:00:00	SPY	ETF	235.61	235.82	235.61	235.69	3929.0
2017-03-31 06:00:00	SPY	ETF	235.74	235.74	235.62	235.68	154814.0
2017-03-31 07:00:00	SPY	ETF	235.72	235.86	235.69	235.85	149454.0
2017-03-31 08:00:00	SPY	ETF	235.7	236.13	235.69	236.0	505444.0
2017-03-31 09:00:00	SPY	ETF	236.0	236.14	235.72	236.0495	6342381.0
2017-03-31 10:00:00	SPY	ETF	236.04	236.36	235.9	236.1301	7145826.0
2017-03-31 11:00:00	SPY	ETF	236.14	236.36	236.05	236.17	4677571.0
2017-03-31 12:00:00	SPY	ETF	236.16	236.39	236.13	236.265	3457781.0
2017-03-31 13:00:00	SPY	ETF	236.26	236.51	236.16	236.16	4035528.0
2017-03-31 14:00:00	SPY	ETF	236.165	236.2	235.795	235.9001	7473856.0
2017-03-31 15:00:00	SPY	ETF	235.91	236.47	235.68	235.71	20736646.0
2017-03-31 16:00:00	SPY	ETF	235.7	236.2644	235.6	235.63	16546278.0
2017-03-31 17:00:00	SPY	ETF	235.74	235.74	235.49	235.53	714078.0
2017-03-31 18:00:00	SPY	ETF	235.54	235.84	235.53	235.58	124661.0
2017-03-31 19:00:00	SPY	ETF	235.6	235.65	235.58	235.65	20551.0
2017-03-31 04:00:00	QQQ	ETF	132.11	132.11	132.11	132.11	338.0
2017-03-31 05:00:00	QQQ	ETF	132.08	132.23	132.05	132.23	19100.0
2017-03-31 06:00:00	QQQ	ETF	132.18	132.18	132.14	132.16	14911.0
2017-03-31 07:00:00	QQQ	ETF	132.17	132.23	132.17	132.23	20299.0
2017-03-31 08:00:00	QQQ	ETF	132.22	132.37	132.22	132.31	58345.0
2017-03-31 09:00:00	QQQ	ETF	132.3	132.42	132.125	132.33	1473251.0
2017-03-31 10:00:00	QQQ	ETF	132.34	132.55	132.33	132.465	2549998.0
2017-03-31 11:00:00	QQQ	ETF	132.46	132.625	132.45	132.52	1640327.0
2017-03-31 12:00:00	QQQ	ETF	132.523	132.67	132.515	132.62	937867.0
2017-03-31 13:00:00	QQQ	ETF	132.62	132.74	132.47	132.47	1448934.0
2017-03-31 14:00:00	QQQ	ETF	132.48	132.51	132.29	132.41	2905516.0
2017-03-31 15:00:00	QQQ	ETF	132.41	132.71	132.35	132.36	4563961.0
2017-03-31 16:00:00	QQQ	ETF	132.35	132.44	132.31	132.36	872388.0
2017-03-31 17:00:00	QQQ	ETF	132.38	132.38	132.34	132.38	769161.0
2017-03-31 18:00:00	QQQ	ETF	132.33	132.4	132.33	132.4	2948.0
2017-03-31 19:00:00	QQQ	ETF	132.33	132.33	132.28	132.28	8584.0
2017-03-31 04:00:00	IWM	ETF	137.01	137.01	136.86	136.91	700.0
2017-03-31 05:00:00	IWM	ETF	136.95	136.95	136.95	136.95	448.0
2017-03-31 06:00:00	IWM	ETF	137.06	137.06	137.05	137.05	7984.0
2017-03-31 07:00:00	IWM	ETF	137.03	137.26	137.03	137.24	7877.0
2017-03-31 08:00:00	IWM	ETF	137.3	137.54	137.29	137.45	56389.0
2017-03-31 09:00:00	IWM	ETF	137.45	137.54	136.97	136.973	2646411.0
2017-03-31 10:00:00	IWM	ETF	136.97	137.6065	136.94	137.395	2920135.0
2017-03-31 11:00:00	IWM	ETF	137.4	137.92	137.37	137.76	2208433.0
2017-03-31 12:00:00	IWM	ETF	137.75	138.1	137.7	137.99	2223507.0
2017-03-31 13:00:00	IWM	ETF	137.99	138.17	137.851	137.89	1661845.0
2017-03-31 14:00:00	IWM	ETF	137.89	137.97	137.6	137.82	1962377.0
2017-03-31 15:00:00	IWM	ETF	137.82	138.09	137.51	137.52	8304383.0
2017-03-31 16:00:00	IWM	ETF	137.52	137.73	137.42	137.48	4801142.0
2017-03-31 17:00:00	IWM	ETF	137.46	137.48	137.41	137.47	45470.0
2017-03-31 18:00:00	IWM	ETF	137.48	137.48	137.45	137.45	5600.0
2017-03-31 19:00:00	IWM	ETF	137.52	137.54	137.47	137.52	7650.0
2017-03-31 08:00:00	DIA	ETF	206.87	206.87	206.81	206.84	970.0
2017-03-31 09:00:00	DIA	ETF	206.76	206.76	206.47	206.49	336880.0

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

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