PREVIEW / etf_1hour / 2016-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-30.parquet
  size:    252 KB
  rows:    8,106

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-03-30 04:00:00	SPY	ETF	205.92	206.3	205.92	206.17	63394.0
2016-03-30 05:00:00	SPY	ETF	206.14	206.31	206.13	206.24	46001.0
2016-03-30 06:00:00	SPY	ETF	206.25	206.57	206.25	206.33	177560.0
2016-03-30 07:00:00	SPY	ETF	206.38	206.46	206.25	206.31	335460.0
2016-03-30 08:00:00	SPY	ETF	206.31	206.43	205.34	206.38	835264.0
2016-03-30 09:00:00	SPY	ETF	206.38	206.78	206.07	206.545	13431247.0
2016-03-30 10:00:00	SPY	ETF	206.545	206.78	206.34	206.63	12825669.0
2016-03-30 11:00:00	SPY	ETF	206.63	206.87	205.9	206.18	12350083.0
2016-03-30 12:00:00	SPY	ETF	206.19	206.31	205.79	205.92	6277782.0
2016-03-30 13:00:00	SPY	ETF	205.92	206.1	205.59	205.98	7403156.0
2016-03-30 14:00:00	SPY	ETF	205.98	206.29	205.92	206.2	9120110.0
2016-03-30 15:00:00	SPY	ETF	206.2	206.49	205.93	206.07	15435794.0
2016-03-30 16:00:00	SPY	ETF	206.08	206.3701	205.1115	206.02	4231045.0
2016-03-30 17:00:00	SPY	ETF	206.02	206.06	205.92	205.97	2596159.0
2016-03-30 18:00:00	SPY	ETF	205.96	206.04	205.87	205.9	64277.0
2016-03-30 19:00:00	SPY	ETF	205.92	205.94	205.83	205.88	91369.0
2016-03-30 20:00:00	SPY	ETF	206.02	206.02	206.02	206.02	146.0
2016-03-30 04:00:00	QQQ	ETF	109.27	109.39	109.27	109.37	579.0
2016-03-30 05:00:00	QQQ	ETF	109.38	109.4	109.38	109.4	843.0
2016-03-30 06:00:00	QQQ	ETF	109.42	109.65	109.42	109.52	30094.0
2016-03-30 07:00:00	QQQ	ETF	109.54	109.62	109.51	109.55	47760.0
2016-03-30 08:00:00	QQQ	ETF	109.52	109.6	109.42	109.52	89594.0
2016-03-30 09:00:00	QQQ	ETF	109.52	110.0	109.34	109.91	4598509.0
2016-03-30 10:00:00	QQQ	ETF	109.92	110.04	109.76	109.86	3652098.0
2016-03-30 11:00:00	QQQ	ETF	109.86	109.96	109.181	109.39	3799223.0
2016-03-30 12:00:00	QQQ	ETF	109.39	109.4478	109.14	109.26	1894727.0
2016-03-30 13:00:00	QQQ	ETF	109.25	109.415	109.13	109.36	1869350.0
2016-03-30 14:00:00	QQQ	ETF	109.35	109.51	109.26	109.45	2406409.0
2016-03-30 15:00:00	QQQ	ETF	109.46	109.65	109.31	109.37	3480575.0
2016-03-30 16:00:00	QQQ	ETF	109.36	109.41	109.27	109.34	463760.0
2016-03-30 17:00:00	QQQ	ETF	109.32	109.4	109.32	109.33	4322.0
2016-03-30 18:00:00	QQQ	ETF	109.3	109.31	109.26	109.26	8553.0
2016-03-30 19:00:00	QQQ	ETF	109.27	109.27	109.25	109.25	3510.0
2016-03-30 04:00:00	IWM	ETF	110.86	110.9	110.85	110.9	7100.0
2016-03-30 05:00:00	IWM	ETF	110.9	110.99	110.9	110.99	6400.0
2016-03-30 06:00:00	IWM	ETF	111.01	111.12	110.99	111.0	6650.0
2016-03-30 07:00:00	IWM	ETF	111.0	111.05	110.96	111.04	14758.0
2016-03-30 08:00:00	IWM	ETF	110.99	111.04	110.345	110.89	179390.0
2016-03-30 09:00:00	IWM	ETF	110.94	111.12	110.54	110.755	5731343.0
2016-03-30 10:00:00	IWM	ETF	110.77	110.94	110.4	110.61	6136170.0
2016-03-30 11:00:00	IWM	ETF	110.61	110.84	110.05	110.68	5373819.0
2016-03-30 12:00:00	IWM	ETF	110.69	110.69	110.3	110.41	2902019.0
2016-03-30 13:00:00	IWM	ETF	110.41	110.49	110.11	110.32	2098332.0
2016-03-30 14:00:00	IWM	ETF	110.31	110.72	110.29	110.56	1999412.0
2016-03-30 15:00:00	IWM	ETF	110.56	110.81	110.3	110.33	5140135.0
2016-03-30 16:00:00	IWM	ETF	110.34	110.45	110.25	110.4014	1588074.0
2016-03-30 17:00:00	IWM	ETF	110.4	110.4	110.27	110.27	1814.0
2016-03-30 18:00:00	IWM	ETF	110.26	110.43	110.26	110.35	5837.0
2016-03-30 19:00:00	IWM	ETF	110.35	110.5	110.35	110.47	66800.0
2016-03-30 04:00:00	DIA	ETF	176.73	176.73	176.73	176.73	100.0

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

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