PREVIEW / etf_1hour / 2017-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-03.parquet
  size:    185 KB
  rows:    5,832

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-03 04:00:00	SPY	ETF	242.46	242.76	242.4	242.67	103998.0
2017-07-03 05:00:00	SPY	ETF	242.52	242.67	242.47	242.48	18050.0
2017-07-03 06:00:00	SPY	ETF	242.51	242.59	242.49	242.54	18411.0
2017-07-03 07:00:00	SPY	ETF	242.54	242.69	242.51	242.64	108246.0
2017-07-03 08:00:00	SPY	ETF	242.64	242.85	241.8	242.85	281933.0
2017-07-03 09:00:00	SPY	ETF	242.86	243.18	242.81	243.05	6222824.0
2017-07-03 10:00:00	SPY	ETF	243.13	243.38	242.943	243.2	7796119.0
2017-07-03 11:00:00	SPY	ETF	243.2	243.26	242.99	243.12	6436359.0
2017-07-03 12:00:00	SPY	ETF	243.125	243.14	242.29	242.32	11571774.0
2017-07-03 13:00:00	SPY	ETF	242.31	243.29	241.78	241.82	5474854.0
2017-07-03 14:00:00	SPY	ETF	241.82	242.35	241.75	241.9	203585.0
2017-07-03 15:00:00	SPY	ETF	241.89	241.9	241.76	241.83	93198.0
2017-07-03 16:00:00	SPY	ETF	241.83	241.86	241.8	241.83	10838.0
2017-07-03 04:00:00	QQQ	ETF	137.99	138.03	137.95	137.95	12270.0
2017-07-03 05:00:00	QQQ	ETF	137.99	137.99	137.9	137.9	2963.0
2017-07-03 06:00:00	QQQ	ETF	137.95	137.95	137.78	137.84	15898.0
2017-07-03 07:00:00	QQQ	ETF	137.86	137.98	137.8	137.98	18802.0
2017-07-03 08:00:00	QQQ	ETF	137.92	138.27	137.64	138.27	115263.0
2017-07-03 09:00:00	QQQ	ETF	138.27	138.43	137.8	137.93	3926686.0
2017-07-03 10:00:00	QQQ	ETF	137.94	138.1	136.91	136.93	5850403.0
2017-07-03 11:00:00	QQQ	ETF	136.92	136.99	136.42	136.885	5995861.0
2017-07-03 12:00:00	QQQ	ETF	136.88	136.88	136.1	136.18	8122686.0
2017-07-03 13:00:00	QQQ	ETF	136.18	137.9049	135.8	135.96	2086470.0
2017-07-03 14:00:00	QQQ	ETF	135.95	136.2	135.93	136.0	617689.0
2017-07-03 15:00:00	QQQ	ETF	136.0	136.08	135.95	135.99	6885.0
2017-07-03 16:00:00	QQQ	ETF	136.05	136.12	136.0	136.04	15155.0
2017-07-03 04:00:00	IWM	ETF	141.25	141.27	140.24	141.27	935.0
2017-07-03 05:00:00	IWM	ETF	141.32	141.32	141.27	141.27	3200.0
2017-07-03 06:00:00	IWM	ETF	141.31	141.32	141.2	141.2	4272.0
2017-07-03 07:00:00	IWM	ETF	141.27	141.34	141.25	141.31	7001.0
2017-07-03 08:00:00	IWM	ETF	141.27	141.45	140.92	141.45	32860.0
2017-07-03 09:00:00	IWM	ETF	141.45	141.92	141.28	141.64	2181577.0
2017-07-03 10:00:00	IWM	ETF	141.65	142.205	141.65	141.79	2251756.0
2017-07-03 11:00:00	IWM	ETF	141.79	142.35	141.6901	142.2118	2096928.0
2017-07-03 12:00:00	IWM	ETF	142.22	142.495	141.79	142.08	3698578.0
2017-07-03 13:00:00	IWM	ETF	142.09	142.31	141.9	141.98	803263.0
2017-07-03 14:00:00	IWM	ETF	141.98	142.1	141.94	141.96	17141.0
2017-07-03 15:00:00	IWM	ETF	141.98	141.98	141.98	141.98	100.0
2017-07-03 16:00:00	IWM	ETF	142.1	142.1	141.92	141.92	100.0
2017-07-03 07:00:00	DIA	ETF	213.9	214.0	213.9	214.0	500.0
2017-07-03 08:00:00	DIA	ETF	213.24	213.24	213.24	213.24	386.0
2017-07-03 09:00:00	DIA	ETF	213.89	214.67	213.88	214.59	497301.0
2017-07-03 10:00:00	DIA	ETF	214.72	215.2	214.6	215.12	658940.0
2017-07-03 11:00:00	DIA	ETF	215.14	215.38	214.95	215.19	398270.0
2017-07-03 12:00:00	DIA	ETF	215.19	215.2	214.51	214.52	431093.0
2017-07-03 13:00:00	DIA	ETF	214.52	214.55	214.25	214.37	51600.0
2017-07-03 14:00:00	DIA	ETF	214.3758	214.47	214.3757	214.45	4830.0
2017-07-03 15:00:00	DIA	ETF	214.31	214.31	214.31	214.31	200.0
2017-07-03 16:00:00	DIA	ETF	214.5	214.5	214.5	214.5	200.0
2017-07-03 04:00:00	GLD	ETF	117.6	117.6	117.44	117.55	15730.0

> showing 50 of 5,832 rows — these rows as CSV

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