PREVIEW / etf_1hour / 2016-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-06-10.parquet
  size:    255 KB
  rows:    8,177

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-06-10 04:00:00	SPY	ETF	211.13	211.15	210.89	210.94	72922.0
2016-06-10 05:00:00	SPY	ETF	210.95	210.97	210.62	210.67	91406.0
2016-06-10 06:00:00	SPY	ETF	210.67	210.84	210.6	210.8	172031.0
2016-06-10 07:00:00	SPY	ETF	210.8	210.97	210.68	210.73	348438.0
2016-06-10 08:00:00	SPY	ETF	210.73	210.89	210.39	210.47	1250847.0
2016-06-10 09:00:00	SPY	ETF	210.47	210.6	210.13	210.33	15374264.0
2016-06-10 10:00:00	SPY	ETF	210.33	210.86	210.1	210.56	13662622.0
2016-06-10 11:00:00	SPY	ETF	210.55	210.825	210.36	210.56	9106152.0
2016-06-10 12:00:00	SPY	ETF	210.555	210.61	210.02	210.345	8354141.0
2016-06-10 13:00:00	SPY	ETF	210.35	210.46	209.7	209.765	10445377.0
2016-06-10 14:00:00	SPY	ETF	209.76	209.8	209.46	209.66	14035415.0
2016-06-10 15:00:00	SPY	ETF	209.67	210.26	209.43	210.06	24899186.0
2016-06-10 16:00:00	SPY	ETF	210.08	210.35	210.03	210.13	10442649.0
2016-06-10 17:00:00	SPY	ETF	210.1	210.22	210.04	210.1	974888.0
2016-06-10 18:00:00	SPY	ETF	210.13	210.16	210.1	210.11	30878.0
2016-06-10 19:00:00	SPY	ETF	210.11	210.14	210.06	210.14	1763260.0
2016-06-10 04:00:00	QQQ	ETF	109.63	109.63	109.48	109.48	9280.0
2016-06-10 05:00:00	QQQ	ETF	109.5	109.5	109.3	109.36	24198.0
2016-06-10 06:00:00	QQQ	ETF	109.31	109.42	109.31	109.38	3839.0
2016-06-10 07:00:00	QQQ	ETF	109.4	109.51	109.36	109.36	16557.0
2016-06-10 08:00:00	QQQ	ETF	109.4	109.44	109.21	109.24	352932.0
2016-06-10 09:00:00	QQQ	ETF	109.25	109.31	109.0	109.15	4786265.0
2016-06-10 10:00:00	QQQ	ETF	109.15	109.4	108.97	109.13	3623067.0
2016-06-10 11:00:00	QQQ	ETF	109.135	109.33	109.1	109.24	2174735.0
2016-06-10 12:00:00	QQQ	ETF	109.25	109.28	109.01	109.21	1593813.0
2016-06-10 13:00:00	QQQ	ETF	109.215	109.27	108.81	108.86	2310564.0
2016-06-10 14:00:00	QQQ	ETF	108.86	108.86	108.61	108.6959	2369282.0
2016-06-10 15:00:00	QQQ	ETF	108.7	108.98	108.56	108.93	4445608.0
2016-06-10 16:00:00	QQQ	ETF	108.95	109.06	108.93	109.01	875084.0
2016-06-10 17:00:00	QQQ	ETF	109.0	109.06	108.97	108.97	41639.0
2016-06-10 18:00:00	QQQ	ETF	108.97	109.02	108.97	109.01	1900.0
2016-06-10 19:00:00	QQQ	ETF	108.97	109.0	108.95	108.95	4022.0
2016-06-10 04:00:00	IWM	ETF	117.15	117.15	116.89	116.98	2300.0
2016-06-10 05:00:00	IWM	ETF	116.76	116.8	116.71	116.8	1200.0
2016-06-10 06:00:00	IWM	ETF	116.81	116.89	116.81	116.89	5900.0
2016-06-10 07:00:00	IWM	ETF	116.82	116.91	116.66	116.77	55927.0
2016-06-10 08:00:00	IWM	ETF	116.75	116.86	116.45	116.51	446232.0
2016-06-10 09:00:00	IWM	ETF	116.49	116.71	116.0	116.345	5341181.0
2016-06-10 10:00:00	IWM	ETF	116.345	116.59	116.04	116.42	3881333.0
2016-06-10 11:00:00	IWM	ETF	116.41	116.88	116.39	116.61	3237540.0
2016-06-10 12:00:00	IWM	ETF	116.62	116.69	116.2	116.361	2068619.0
2016-06-10 13:00:00	IWM	ETF	116.36	116.41	115.88	115.93	3156300.0
2016-06-10 14:00:00	IWM	ETF	115.92	116.08	115.76	115.8	3038234.0
2016-06-10 15:00:00	IWM	ETF	115.81	116.19	115.69	116.035	5398094.0
2016-06-10 16:00:00	IWM	ETF	116.04	116.6264	115.98	115.98	2287055.0
2016-06-10 17:00:00	IWM	ETF	115.98	116.0	115.95	115.95	98908.0
2016-06-10 18:00:00	IWM	ETF	115.96	115.96	115.96	115.96	1900.0
2016-06-10 05:00:00	DIA	ETF	179.0	179.0	179.0	179.0	100.0
2016-06-10 07:00:00	DIA	ETF	178.89	179.02	178.83	178.83	4665.0
2016-06-10 08:00:00	DIA	ETF	178.97	179.0	178.75	178.75	8423.0

> showing 50 of 8,177 rows — these rows as CSV

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