PREVIEW / etf_1hour / 2017-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-28.parquet
  size:    277 KB
  rows:    9,124

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-08-28 04:00:00	SPY	ETF	244.38	244.43	244.23	244.23	11200.0
2017-08-28 05:00:00	SPY	ETF	244.26	244.47	244.26	244.46	2411.0
2017-08-28 06:00:00	SPY	ETF	244.43	244.5	244.35	244.49	17105.0
2017-08-28 07:00:00	SPY	ETF	244.47	244.71	244.47	244.71	133832.0
2017-08-28 08:00:00	SPY	ETF	244.7	245.0	244.68	245.0	329565.0
2017-08-28 09:00:00	SPY	ETF	245.0	245.2	244.58	244.64	3738732.0
2017-08-28 10:00:00	SPY	ETF	244.63	244.79	244.34	244.74	4714878.0
2017-08-28 11:00:00	SPY	ETF	244.76	244.832	244.4	244.6	2973914.0
2017-08-28 12:00:00	SPY	ETF	244.6	244.6	244.09	244.2599	3820150.0
2017-08-28 13:00:00	SPY	ETF	244.25	244.49	244.22	244.451	2039379.0
2017-08-28 14:00:00	SPY	ETF	244.4591	244.51	244.29	244.41	2539523.0
2017-08-28 15:00:00	SPY	ETF	244.41	244.61	244.28	244.59	8418522.0
2017-08-28 16:00:00	SPY	ETF	244.6	244.75	244.57	244.72	5977334.0
2017-08-28 17:00:00	SPY	ETF	244.69	244.69	242.9	243.41	2429448.0
2017-08-28 18:00:00	SPY	ETF	243.45	243.7	242.65	243.36	930849.0
2017-08-28 19:00:00	SPY	ETF	243.35	243.56	243.11	243.35	112204.0
2017-08-28 04:00:00	QQQ	ETF	141.8	141.81	141.65	141.7	27542.0
2017-08-28 05:00:00	QQQ	ETF	141.7	141.81	141.7	141.77	10499.0
2017-08-28 06:00:00	QQQ	ETF	141.86	141.97	141.82	141.97	22700.0
2017-08-28 07:00:00	QQQ	ETF	141.96	142.05	141.93	142.03	23297.0
2017-08-28 08:00:00	QQQ	ETF	142.0	142.35	141.92	142.35	224589.0
2017-08-28 09:00:00	QQQ	ETF	142.35	142.43	142.005	142.06	2709128.0
2017-08-28 10:00:00	QQQ	ETF	142.08	142.74	141.9501	142.67	2803001.0
2017-08-28 11:00:00	QQQ	ETF	142.67	142.74	142.42	142.58	1362924.0
2017-08-28 12:00:00	QQQ	ETF	142.58	142.59	142.09	142.25	1769182.0
2017-08-28 13:00:00	QQQ	ETF	142.25	142.48	142.21	142.45	1160343.0
2017-08-28 14:00:00	QQQ	ETF	142.45	142.475	142.25	142.33	811929.0
2017-08-28 15:00:00	QQQ	ETF	142.34	142.4	142.18	142.38	2506603.0
2017-08-28 16:00:00	QQQ	ETF	142.38	142.55	142.2494	142.52	570729.0
2017-08-28 17:00:00	QQQ	ETF	142.52	142.52	141.34	141.4	347379.0
2017-08-28 18:00:00	QQQ	ETF	141.49	141.85	141.09	141.6	237103.0
2017-08-28 19:00:00	QQQ	ETF	141.4	141.69	141.4	141.58	55035.0
2017-08-28 04:00:00	IWM	ETF	136.94	136.94	136.79	136.79	550.0
2017-08-28 05:00:00	IWM	ETF	136.76	136.76	136.76	136.76	100.0
2017-08-28 07:00:00	IWM	ETF	136.98	136.99	136.93	136.98	5725.0
2017-08-28 08:00:00	IWM	ETF	137.03	137.22	137.03	137.17	164271.0
2017-08-28 09:00:00	IWM	ETF	137.17	137.61	137.17	137.25	2382888.0
2017-08-28 10:00:00	IWM	ETF	137.26	137.36	136.77	137.22	2309191.0
2017-08-28 11:00:00	IWM	ETF	137.22	137.29	136.99	137.13	940874.0
2017-08-28 12:00:00	IWM	ETF	137.12	137.36	136.82	137.01	1225567.0
2017-08-28 13:00:00	IWM	ETF	137.01	137.17	136.89	137.07	987041.0
2017-08-28 14:00:00	IWM	ETF	137.07	137.27	136.93	137.19	806312.0
2017-08-28 15:00:00	IWM	ETF	137.19	137.48	137.12	137.47	2897513.0
2017-08-28 16:00:00	IWM	ETF	137.46	137.57	137.35	137.52	2237708.0
2017-08-28 17:00:00	IWM	ETF	137.48	137.48	136.25	136.34	136921.0
2017-08-28 18:00:00	IWM	ETF	136.44	137.46	136.13	136.55	22063.0
2017-08-28 19:00:00	IWM	ETF	136.55	136.6	136.55	136.6	1500.0
2017-08-28 08:00:00	DIA	ETF	218.16	218.19	218.15	218.16	2400.0
2017-08-28 09:00:00	DIA	ETF	218.5	218.58	217.74	217.85	161220.0
2017-08-28 10:00:00	DIA	ETF	217.86	217.94	217.53	217.84	211105.0

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

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