PREVIEW / etf_1hour / 2017-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-30.parquet
  size:    277 KB
  rows:    9,086

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-06-30 04:00:00	SPY	ETF	241.72	241.79	241.5	241.79	2610.0
2017-06-30 05:00:00	SPY	ETF	241.79	242.1	241.79	242.1	58978.0
2017-06-30 06:00:00	SPY	ETF	242.14	242.42	242.14	242.3	54992.0
2017-06-30 07:00:00	SPY	ETF	242.28	242.4	242.23	242.3	257635.0
2017-06-30 08:00:00	SPY	ETF	242.34	242.37	241.97	242.0	599841.0
2017-06-30 09:00:00	SPY	ETF	242.01	242.55	241.95	242.1	8715132.0
2017-06-30 10:00:00	SPY	ETF	242.095	242.135	241.575	241.89	9668589.0
2017-06-30 11:00:00	SPY	ETF	241.89	242.15	241.5861	242.06	5376771.0
2017-06-30 12:00:00	SPY	ETF	242.07	242.16	241.84	241.9417	4366441.0
2017-06-30 13:00:00	SPY	ETF	241.95	242.2	241.93	242.105	4531166.0
2017-06-30 14:00:00	SPY	ETF	242.09	242.55	242.02	242.5	7022239.0
2017-06-30 15:00:00	SPY	ETF	242.5	242.71	241.73	241.77	16837822.0
2017-06-30 16:00:00	SPY	ETF	241.77	242.47	241.65	241.92	23172070.0
2017-06-30 17:00:00	SPY	ETF	241.91	242.01	241.8	241.83	4003384.0
2017-06-30 18:00:00	SPY	ETF	241.82	241.86	241.65	241.72	128566.0
2017-06-30 19:00:00	SPY	ETF	241.7	241.7	241.62	241.67	31497.0
2017-06-30 04:00:00	QQQ	ETF	137.31	137.75	137.28	137.75	15341.0
2017-06-30 05:00:00	QQQ	ETF	137.72	137.98	137.63	137.98	22790.0
2017-06-30 06:00:00	QQQ	ETF	137.93	138.32	137.88	138.09	37347.0
2017-06-30 07:00:00	QQQ	ETF	138.07	138.13	137.84	137.94	243384.0
2017-06-30 08:00:00	QQQ	ETF	137.89	137.98	137.35	137.54	600098.0
2017-06-30 09:00:00	QQQ	ETF	137.5	138.33	137.39	137.7799	11236810.0
2017-06-30 10:00:00	QQQ	ETF	137.77	137.97	137.19	137.82	12326231.0
2017-06-30 11:00:00	QQQ	ETF	137.83	137.958	137.52	137.86	3911935.0
2017-06-30 12:00:00	QQQ	ETF	137.84	137.96	137.63	137.73	2378496.0
2017-06-30 13:00:00	QQQ	ETF	137.73	137.92	137.72	137.83	1785548.0
2017-06-30 14:00:00	QQQ	ETF	137.82	138.1	137.76	138.08	3649120.0
2017-06-30 15:00:00	QQQ	ETF	138.08	138.12	137.45	137.47	8462562.0
2017-06-30 16:00:00	QQQ	ETF	137.48	138.0467	137.4489	137.64	4812003.0
2017-06-30 17:00:00	QQQ	ETF	137.64	137.64	137.52	137.55	7993187.0
2017-06-30 18:00:00	QQQ	ETF	137.57	137.57	137.5	137.52	4508.0
2017-06-30 19:00:00	QQQ	ETF	137.52	137.52	137.47	137.5	4757.0
2017-06-30 05:00:00	IWM	ETF	141.17	141.25	141.11	141.25	5600.0
2017-06-30 06:00:00	IWM	ETF	141.29	141.38	141.27	141.27	5200.0
2017-06-30 07:00:00	IWM	ETF	141.36	141.4	141.32	141.35	16740.0
2017-06-30 08:00:00	IWM	ETF	141.34	141.36	141.0	141.13	120443.0
2017-06-30 09:00:00	IWM	ETF	141.07	141.52	140.98	141.09	2247546.0
2017-06-30 10:00:00	IWM	ETF	141.08	141.3	140.77	141.035	2783113.0
2017-06-30 11:00:00	IWM	ETF	141.035	141.23	140.82	141.17	1624101.0
2017-06-30 12:00:00	IWM	ETF	141.18	141.245	140.96	141.0573	1207864.0
2017-06-30 13:00:00	IWM	ETF	141.05	141.43	141.03	141.32	1288690.0
2017-06-30 14:00:00	IWM	ETF	141.32	141.65	141.22	141.56	1896511.0
2017-06-30 15:00:00	IWM	ETF	141.5699	141.67	140.91	140.94	5844395.0
2017-06-30 16:00:00	IWM	ETF	140.92	140.99	140.73	140.92	1919706.0
2017-06-30 17:00:00	IWM	ETF	140.92	140.92	140.83	140.83	194800.0
2017-06-30 18:00:00	IWM	ETF	140.82	140.85	140.78	140.78	2900.0
2017-06-30 19:00:00	IWM	ETF	140.84	140.84	140.78	140.78	1500.0
2017-06-30 06:00:00	DIA	ETF	213.23	213.23	213.23	213.23	100.0
2017-06-30 07:00:00	DIA	ETF	213.3	213.33	213.29	213.29	2040.0
2017-06-30 08:00:00	DIA	ETF	213.21	213.21	213.21	213.21	100.0

> showing 50 of 9,086 rows — these rows as CSV

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