PREVIEW / etf_1hour / 2017-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-06-26.parquet
  size:    276 KB
  rows:    9,038

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-26 04:00:00	SPY	ETF	243.45	243.73	243.45	243.62	60650.0
2017-06-26 05:00:00	SPY	ETF	243.54	243.57	243.54	243.57	200.0
2017-06-26 06:00:00	SPY	ETF	243.71	243.81	243.66	243.81	54887.0
2017-06-26 07:00:00	SPY	ETF	243.68	243.84	243.68	243.84	102144.0
2017-06-26 08:00:00	SPY	ETF	243.81	243.91	243.12	243.82	594592.0
2017-06-26 09:00:00	SPY	ETF	243.81	244.38	243.13	244.36	6639252.0
2017-06-26 10:00:00	SPY	ETF	244.35	244.37	243.23	243.44	9045180.0
2017-06-26 11:00:00	SPY	ETF	243.45	243.68	243.045	243.6675	9210830.0
2017-06-26 12:00:00	SPY	ETF	243.66	243.79	243.46	243.71	4475724.0
2017-06-26 13:00:00	SPY	ETF	243.71	243.74	243.49	243.575	2826347.0
2017-06-26 14:00:00	SPY	ETF	243.57	243.635	243.38	243.62	3321447.0
2017-06-26 15:00:00	SPY	ETF	243.62	243.7099	243.17	243.27	12762820.0
2017-06-26 16:00:00	SPY	ETF	243.26	243.6372	243.16	243.22	6024839.0
2017-06-26 17:00:00	SPY	ETF	243.22	243.3	243.22	243.24	45757.0
2017-06-26 18:00:00	SPY	ETF	243.24	243.34	243.11	243.3	97940.0
2017-06-26 19:00:00	SPY	ETF	243.32	243.35	243.28	243.32	17876.0
2017-06-26 04:00:00	QQQ	ETF	141.49	141.78	141.49	141.72	4059.0
2017-06-26 05:00:00	QQQ	ETF	141.73	141.8	141.73	141.8	20000.0
2017-06-26 06:00:00	QQQ	ETF	141.78	141.86	141.74	141.86	10196.0
2017-06-26 07:00:00	QQQ	ETF	141.8	142.08	141.8	142.02	44365.0
2017-06-26 08:00:00	QQQ	ETF	142.0	142.08	141.97	141.99	280942.0
2017-06-26 09:00:00	QQQ	ETF	141.98	142.29	141.93	142.0685	3570092.0
2017-06-26 10:00:00	QQQ	ETF	142.08	142.09	140.73	140.92	6898606.0
2017-06-26 11:00:00	QQQ	ETF	140.93	140.99	140.27	140.86	5498684.0
2017-06-26 12:00:00	QQQ	ETF	140.86	141.21	140.75	141.11	2949132.0
2017-06-26 13:00:00	QQQ	ETF	141.12	141.125	140.84	140.99	1624800.0
2017-06-26 14:00:00	QQQ	ETF	140.99	141.01	140.64	140.8	2963345.0
2017-06-26 15:00:00	QQQ	ETF	140.8	140.8999	140.5	140.58	4773588.0
2017-06-26 16:00:00	QQQ	ETF	140.58	142.121	140.44	140.56	712841.0
2017-06-26 17:00:00	QQQ	ETF	140.5	140.58	140.48	140.57	27701.0
2017-06-26 18:00:00	QQQ	ETF	140.57	140.6	140.46	140.56	28656.0
2017-06-26 19:00:00	QQQ	ETF	140.55	140.63	140.55	140.59	17650.0
2017-06-26 04:00:00	IWM	ETF	141.34	141.34	141.34	141.34	100.0
2017-06-26 05:00:00	IWM	ETF	141.25	141.32	141.25	141.32	2100.0
2017-06-26 06:00:00	IWM	ETF	141.29	141.29	141.29	141.29	1000.0
2017-06-26 07:00:00	IWM	ETF	141.29	141.38	141.27	141.27	23350.0
2017-06-26 08:00:00	IWM	ETF	141.32	141.33	140.95	140.98	143030.0
2017-06-26 09:00:00	IWM	ETF	140.93	141.53	140.88	141.5001	2836602.0
2017-06-26 10:00:00	IWM	ETF	141.4992	141.52	140.47	140.58	3599246.0
2017-06-26 11:00:00	IWM	ETF	140.6	141.14	140.201	140.97	3570798.0
2017-06-26 12:00:00	IWM	ETF	140.96	141.36	140.93	141.3371	1599613.0
2017-06-26 13:00:00	IWM	ETF	141.34	141.365	141.09	141.23	1094382.0
2017-06-26 14:00:00	IWM	ETF	141.24	141.38	141.07	141.37	1020626.0
2017-06-26 15:00:00	IWM	ETF	141.37	141.51	140.97	141.08	3661290.0
2017-06-26 16:00:00	IWM	ETF	141.08	141.11	140.87	140.97	860068.0
2017-06-26 17:00:00	IWM	ETF	140.96	140.96	140.96	140.96	100.0
2017-06-26 18:00:00	IWM	ETF	141.08	141.08	141.01	141.01	800.0
2017-06-26 19:00:00	IWM	ETF	141.03	141.09	140.95	141.02	5221.0
2017-06-26 04:00:00	DIA	ETF	213.83	214.22	213.83	214.22	500.0
2017-06-26 08:00:00	DIA	ETF	214.33	214.33	214.29	214.33	2107.0

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

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