PREVIEW / etf_1hour / 2016-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-13.parquet
  size:    249 KB
  rows:    7,986

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-05-13 04:00:00	SPY	ETF	205.84	205.84	205.34	205.57	83716.0
2016-05-13 05:00:00	SPY	ETF	205.47	205.68	205.37	205.55	13879.0
2016-05-13 06:00:00	SPY	ETF	205.53	205.85	205.46	205.85	66105.0
2016-05-13 07:00:00	SPY	ETF	205.9	205.99	205.68	205.7	252708.0
2016-05-13 08:00:00	SPY	ETF	205.68	206.45	205.29	206.1	1893124.0
2016-05-13 09:00:00	SPY	ETF	206.1	206.86	205.87	206.2263	10336675.0
2016-05-13 10:00:00	SPY	ETF	206.23	206.52	205.67	205.975	14821535.0
2016-05-13 11:00:00	SPY	ETF	205.97	206.755	205.96	206.23	9638017.0
2016-05-13 12:00:00	SPY	ETF	206.22	206.39	205.76	205.79	5810173.0
2016-05-13 13:00:00	SPY	ETF	205.8	205.97	204.92	205.12	11166350.0
2016-05-13 14:00:00	SPY	ETF	205.1275	205.28	204.38	204.78	14576340.0
2016-05-13 15:00:00	SPY	ETF	204.78	205.026	204.57	204.76	20623684.0
2016-05-13 16:00:00	SPY	ETF	204.77	204.94	204.72	204.8	5588830.0
2016-05-13 17:00:00	SPY	ETF	204.81	204.82	204.52	204.7	198724.0
2016-05-13 18:00:00	SPY	ETF	204.7	204.72	204.63	204.66	18148.0
2016-05-13 19:00:00	SPY	ETF	204.63	204.73	204.62	204.71	27160.0
2016-05-13 04:00:00	QQQ	ETF	105.49	105.49	105.21	105.25	1600.0
2016-05-13 05:00:00	QQQ	ETF	105.3	105.43	105.3	105.33	5298.0
2016-05-13 06:00:00	QQQ	ETF	105.39	105.57	105.36	105.52	8400.0
2016-05-13 07:00:00	QQQ	ETF	105.57	105.63	105.44	105.44	37111.0
2016-05-13 08:00:00	QQQ	ETF	105.45	105.89	105.43	105.79	266315.0
2016-05-13 09:00:00	QQQ	ETF	105.77	106.35	105.67	106.025	2765433.0
2016-05-13 10:00:00	QQQ	ETF	106.03	106.2999	105.77	105.97	2920582.0
2016-05-13 11:00:00	QQQ	ETF	105.96	106.449	105.96	106.17	2581839.0
2016-05-13 12:00:00	QQQ	ETF	106.165	106.31	105.84	105.88	1553430.0
2016-05-13 13:00:00	QQQ	ETF	105.89	106.05	105.52	105.61	1845551.0
2016-05-13 14:00:00	QQQ	ETF	105.61	105.76	105.29	105.48	2590107.0
2016-05-13 15:00:00	QQQ	ETF	105.48	105.69	105.38	105.51	3405625.0
2016-05-13 16:00:00	QQQ	ETF	105.53	105.61	105.4801	105.56	620151.0
2016-05-13 17:00:00	QQQ	ETF	105.54	105.6	105.48	105.48	988.0
2016-05-13 18:00:00	QQQ	ETF	105.48	105.55	105.48	105.5	864.0
2016-05-13 19:00:00	QQQ	ETF	105.52	105.52	105.44	105.44	5274.0
2016-05-13 04:00:00	IWM	ETF	109.82	109.82	109.56	109.56	1360.0
2016-05-13 05:00:00	IWM	ETF	109.51	109.51	109.51	109.51	100.0
2016-05-13 06:00:00	IWM	ETF	109.68	109.71	109.6	109.6	8500.0
2016-05-13 07:00:00	IWM	ETF	109.85	109.92	109.69	109.69	43827.0
2016-05-13 08:00:00	IWM	ETF	109.73	110.17	109.72	109.92	332621.0
2016-05-13 09:00:00	IWM	ETF	109.88	110.71	109.82	110.15	2351785.0
2016-05-13 10:00:00	IWM	ETF	110.16	110.42	109.82	110.28	3084049.0
2016-05-13 11:00:00	IWM	ETF	110.27	110.94	110.24	110.49	2463832.0
2016-05-13 12:00:00	IWM	ETF	110.49	110.69	110.08	110.13	1226301.0
2016-05-13 13:00:00	IWM	ETF	110.13	110.32	109.595	109.71	2324219.0
2016-05-13 14:00:00	IWM	ETF	109.7	109.83	109.36	109.59	3439540.0
2016-05-13 15:00:00	IWM	ETF	109.59	109.86	109.49	109.63	5007113.0
2016-05-13 16:00:00	IWM	ETF	109.64	109.9292	109.64	109.78	828105.0
2016-05-13 17:00:00	IWM	ETF	109.77	109.83	109.65	109.65	18964.0
2016-05-13 18:00:00	IWM	ETF	109.67	109.75	109.67	109.67	4915.0
2016-05-13 19:00:00	IWM	ETF	109.67	109.79	109.67	109.75	1123.0
2016-05-13 04:00:00	DIA	ETF	176.62	176.62	176.62	176.62	200.0
2016-05-13 06:00:00	DIA	ETF	176.59	176.59	176.59	176.59	1000.0

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

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