PREVIEW / etf_1hour / 2016-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-10.parquet
  size:    249 KB
  rows:    7,962

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
2016-10-10 04:00:00	SPY	ETF	215.25	215.59	215.25	215.58	41972.0
2016-10-10 05:00:00	SPY	ETF	215.52	215.77	215.52	215.75	9956.0
2016-10-10 06:00:00	SPY	ETF	215.76	215.84	215.72	215.76	11345.0
2016-10-10 07:00:00	SPY	ETF	215.8	216.13	215.77	215.92	165862.0
2016-10-10 08:00:00	SPY	ETF	215.93	216.27	215.85	216.19	608960.0
2016-10-10 09:00:00	SPY	ETF	216.19	216.7	216.01	216.6	8868013.0
2016-10-10 10:00:00	SPY	ETF	216.6	216.69	216.48	216.62	7467507.0
2016-10-10 11:00:00	SPY	ETF	216.615	216.66	216.36	216.43	6105689.0
2016-10-10 12:00:00	SPY	ETF	216.43	216.46	216.07	216.25	4692678.0
2016-10-10 13:00:00	SPY	ETF	216.2499	216.45	216.2	216.26	2679142.0
2016-10-10 14:00:00	SPY	ETF	216.265	216.38	216.16	216.26	5302501.0
2016-10-10 15:00:00	SPY	ETF	216.255	216.32	215.985	216.11	9222334.0
2016-10-10 16:00:00	SPY	ETF	216.11	216.34	215.98	216.31	4281287.0
2016-10-10 17:00:00	SPY	ETF	216.3	216.32	216.16	216.3	103054.0
2016-10-10 18:00:00	SPY	ETF	216.3	216.41	216.16	216.41	56259.0
2016-10-10 19:00:00	SPY	ETF	216.42	216.43	216.33	216.42	108705.0
2016-10-10 04:00:00	QQQ	ETF	118.65	118.66	118.59	118.65	15729.0
2016-10-10 05:00:00	QQQ	ETF	118.79	118.8	118.77	118.8	1105.0
2016-10-10 06:00:00	QQQ	ETF	118.87	118.87	118.87	118.87	1000.0
2016-10-10 07:00:00	QQQ	ETF	118.88	118.99	118.88	118.92	46707.0
2016-10-10 08:00:00	QQQ	ETF	118.9	119.08	118.9	119.03	69338.0
2016-10-10 09:00:00	QQQ	ETF	119.04	119.42	119.0	119.38	2542522.0
2016-10-10 10:00:00	QQQ	ETF	119.385	119.48	119.32	119.455	2517578.0
2016-10-10 11:00:00	QQQ	ETF	119.455	119.475	119.32	119.39	1488100.0
2016-10-10 12:00:00	QQQ	ETF	119.39	119.4	119.22	119.34	1261917.0
2016-10-10 13:00:00	QQQ	ETF	119.34	119.44	119.3	119.37	1400812.0
2016-10-10 14:00:00	QQQ	ETF	119.37	119.48	119.36	119.421	1340138.0
2016-10-10 15:00:00	QQQ	ETF	119.42	119.4399	119.17	119.21	1975613.0
2016-10-10 16:00:00	QQQ	ETF	119.22	119.31	119.15	119.28	623663.0
2016-10-10 17:00:00	QQQ	ETF	119.27	119.28	119.22	119.26	3138.0
2016-10-10 18:00:00	QQQ	ETF	119.25	119.31	119.25	119.31	8209.0
2016-10-10 19:00:00	QQQ	ETF	119.33	119.34	119.33	119.33	3150.0
2016-10-10 04:00:00	IWM	ETF	122.87	123.01	122.87	123.01	357.0
2016-10-10 05:00:00	IWM	ETF	123.03	123.09	123.03	123.09	1100.0
2016-10-10 06:00:00	IWM	ETF	123.14	123.15	123.11	123.15	5000.0
2016-10-10 07:00:00	IWM	ETF	123.18	123.4	123.18	123.31	37341.0
2016-10-10 08:00:00	IWM	ETF	123.31	123.56	123.29	123.52	58492.0
2016-10-10 09:00:00	IWM	ETF	123.55	124.74	123.48	124.6201	5387634.0
2016-10-10 10:00:00	IWM	ETF	124.63	124.67	124.46	124.5401	2403053.0
2016-10-10 11:00:00	IWM	ETF	124.55	124.59	124.36	124.4	2016257.0
2016-10-10 12:00:00	IWM	ETF	124.405	124.49	124.2471	124.41	1154732.0
2016-10-10 13:00:00	IWM	ETF	124.4	124.53	124.29	124.4	837037.0
2016-10-10 14:00:00	IWM	ETF	124.4	124.42	124.26	124.32	967525.0
2016-10-10 15:00:00	IWM	ETF	124.33	124.41	124.205	124.26	3793692.0
2016-10-10 16:00:00	IWM	ETF	124.25	124.51	124.21	124.49	2007957.0
2016-10-10 17:00:00	IWM	ETF	124.49	124.49	124.4	124.42	2445.0
2016-10-10 18:00:00	IWM	ETF	124.45	124.5	124.45	124.5	971.0
2016-10-10 19:00:00	IWM	ETF	124.5	124.5	124.45	124.47	1850.0
2016-10-10 06:00:00	DIA	ETF	182.75	182.75	182.75	182.75	100.0
2016-10-10 07:00:00	DIA	ETF	182.63	182.63	182.63	182.63	200.0

> showing 50 of 7,962 rows — these rows as CSV

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