PREVIEW / etf_1hour / 2016-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-06.parquet
  size:    247 KB
  rows:    7,895

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-04-06 04:00:00	SPY	ETF	204.93	205.1	204.56	205.05	35958.0
2016-04-06 05:00:00	SPY	ETF	205.09	205.14	204.99	205.08	18623.0
2016-04-06 06:00:00	SPY	ETF	205.0	205.0	204.62	204.68	132632.0
2016-04-06 07:00:00	SPY	ETF	204.69	204.9	204.62	204.83	162629.0
2016-04-06 08:00:00	SPY	ETF	204.9729	205.0	204.38	204.46	643958.0
2016-04-06 09:00:00	SPY	ETF	204.44	204.64	203.98	204.345	9449642.0
2016-04-06 10:00:00	SPY	ETF	204.35	205.18	204.03	205.17	15440525.0
2016-04-06 11:00:00	SPY	ETF	205.18	205.67	205.12	205.6	10463132.0
2016-04-06 12:00:00	SPY	ETF	205.6	205.66	205.367	205.4969	5594265.0
2016-04-06 13:00:00	SPY	ETF	205.495	205.91	205.495	205.65	6283750.0
2016-04-06 14:00:00	SPY	ETF	205.66	205.7	205.03	205.63	13090829.0
2016-04-06 15:00:00	SPY	ETF	205.63	206.49	205.54	206.43	22185861.0
2016-04-06 16:00:00	SPY	ETF	206.42	206.5	204.2461	206.37	5754588.0
2016-04-06 17:00:00	SPY	ETF	206.37	206.42	206.32	206.4	278443.0
2016-04-06 18:00:00	SPY	ETF	206.33	206.46	206.26	206.28	95976.0
2016-04-06 19:00:00	SPY	ETF	206.26	206.34	206.24	206.3	64686.0
2016-04-06 04:00:00	QQQ	ETF	109.23	109.23	109.23	109.23	200.0
2016-04-06 05:00:00	QQQ	ETF	109.42	109.42	109.41	109.41	10000.0
2016-04-06 06:00:00	QQQ	ETF	109.39	109.39	109.39	109.39	600.0
2016-04-06 07:00:00	QQQ	ETF	109.24	109.3	109.17	109.27	25202.0
2016-04-06 08:00:00	QQQ	ETF	109.26	109.29	109.07	109.11	120045.0
2016-04-06 09:00:00	QQQ	ETF	109.12	109.39	108.99	109.31	2162103.0
2016-04-06 10:00:00	QQQ	ETF	109.31	109.66	109.02	109.66	3480440.0
2016-04-06 11:00:00	QQQ	ETF	109.655	110.0199	109.61	109.96	2902954.0
2016-04-06 12:00:00	QQQ	ETF	109.96	110.065	109.8	109.98	1720265.0
2016-04-06 13:00:00	QQQ	ETF	109.98	110.26	109.98	110.13	1905188.0
2016-04-06 14:00:00	QQQ	ETF	110.14	110.25	109.84	110.23	3126503.0
2016-04-06 15:00:00	QQQ	ETF	110.22	110.71	110.175	110.665	5449337.0
2016-04-06 16:00:00	QQQ	ETF	110.65	110.67	110.1501	110.59	965282.0
2016-04-06 17:00:00	QQQ	ETF	110.56	110.65	110.56	110.6	17682.0
2016-04-06 18:00:00	QQQ	ETF	110.62	110.67	110.54	110.54	11181.0
2016-04-06 19:00:00	QQQ	ETF	110.54	110.59	110.53	110.57	12350.0
2016-04-06 05:00:00	IWM	ETF	109.35	109.35	109.35	109.35	1000.0
2016-04-06 06:00:00	IWM	ETF	109.25	109.25	109.25	109.25	2500.0
2016-04-06 07:00:00	IWM	ETF	109.15	109.23	109.1	109.17	12182.0
2016-04-06 08:00:00	IWM	ETF	109.2	109.2	108.92	108.94	61319.0
2016-04-06 09:00:00	IWM	ETF	108.96	109.09	108.585	108.85	3055044.0
2016-04-06 10:00:00	IWM	ETF	108.83	109.51	108.685	109.51	5291658.0
2016-04-06 11:00:00	IWM	ETF	109.5	109.83	109.41	109.78	3759299.0
2016-04-06 12:00:00	IWM	ETF	109.785	109.88	109.62	109.75	1352656.0
2016-04-06 13:00:00	IWM	ETF	109.76	110.03	109.76	109.85	1595958.0
2016-04-06 14:00:00	IWM	ETF	109.85	109.88	109.3299	109.74	3688709.0
2016-04-06 15:00:00	IWM	ETF	109.74	110.27	109.67	110.16	5556467.0
2016-04-06 16:00:00	IWM	ETF	110.16	110.18	110.02	110.08	867590.0
2016-04-06 17:00:00	IWM	ETF	110.07	110.07	110.03	110.04	9615.0
2016-04-06 20:00:00	IWM	ETF	110.2353	110.2353	110.2353	110.2353	590000.0
2016-04-06 06:00:00	DIA	ETF	176.3	176.3	176.3	176.3	300.0
2016-04-06 07:00:00	DIA	ETF	176.22	176.22	176.22	176.22	100.0
2016-04-06 08:00:00	DIA	ETF	176.25	176.25	176.02	176.08	5300.0
2016-04-06 09:00:00	DIA	ETF	175.98	176.09	175.42	175.68	488751.0

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

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