PREVIEW / etf_1hour / 2015-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-26.parquet
  size:    238 KB
  rows:    7,668

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
2015-10-26 04:00:00	SPY	ETF	206.9	206.9	206.4	206.77	26772.0
2015-10-26 05:00:00	SPY	ETF	206.78	206.91	206.63	206.83	7138.0
2015-10-26 06:00:00	SPY	ETF	206.88	207.05	206.84	206.98	39073.0
2015-10-26 07:00:00	SPY	ETF	206.92	206.98	206.79	206.9	512993.0
2015-10-26 08:00:00	SPY	ETF	206.87	207.27	206.8	207.21	558478.0
2015-10-26 09:00:00	SPY	ETF	207.2	207.39	206.72	206.79	9985730.0
2015-10-26 10:00:00	SPY	ETF	206.8	207.305	206.56	207.11	14142796.0
2015-10-26 11:00:00	SPY	ETF	207.11	207.2	206.83	206.88	4988164.0
2015-10-26 12:00:00	SPY	ETF	206.87	207.3623	206.73	207.1925	8258815.0
2015-10-26 13:00:00	SPY	ETF	207.19	207.37	206.96	206.975	7036627.0
2015-10-26 14:00:00	SPY	ETF	206.98	207.225	206.88	207.1	6548988.0
2015-10-26 15:00:00	SPY	ETF	207.1	207.18	206.93	206.97	11230723.0
2015-10-26 16:00:00	SPY	ETF	206.97	207.0574	206.8	206.94	4381745.0
2015-10-26 17:00:00	SPY	ETF	206.94	207.0	206.92	206.99	15520.0
2015-10-26 18:00:00	SPY	ETF	206.96	207.0	206.91	207.0	529554.0
2015-10-26 19:00:00	SPY	ETF	206.95	206.99	206.91	206.97	22728.0
2015-10-26 04:00:00	QQQ	ETF	112.29	112.29	112.29	112.29	100.0
2015-10-26 05:00:00	QQQ	ETF	112.36	112.42	112.29	112.39	15399.0
2015-10-26 06:00:00	QQQ	ETF	112.4	112.43	112.4	112.43	2300.0
2015-10-26 07:00:00	QQQ	ETF	112.43	112.43	112.36	112.41	57972.0
2015-10-26 08:00:00	QQQ	ETF	112.42	112.7	112.41	112.64	340631.0
2015-10-26 09:00:00	QQQ	ETF	112.65	112.77	112.31	112.37	5730744.0
2015-10-26 10:00:00	QQQ	ETF	112.37	113.01	112.27	112.94	4712678.0
2015-10-26 11:00:00	QQQ	ETF	112.95	112.98	112.59	112.625	2989318.0
2015-10-26 12:00:00	QQQ	ETF	112.62	113.045	112.56	112.9	1753191.0
2015-10-26 13:00:00	QQQ	ETF	112.89	113.07	112.68	112.69	3415857.0
2015-10-26 14:00:00	QQQ	ETF	112.7	112.92	112.64	112.9009	1676201.0
2015-10-26 15:00:00	QQQ	ETF	112.9	112.94	112.71	112.85	2847915.0
2015-10-26 16:00:00	QQQ	ETF	112.85	112.85	112.71	112.79	207328.0
2015-10-26 17:00:00	QQQ	ETF	112.78	112.81	112.78	112.8	915.0
2015-10-26 18:00:00	QQQ	ETF	112.8	112.8	112.76	112.76	9277.0
2015-10-26 19:00:00	QQQ	ETF	112.81	112.81	112.75	112.75	2496.0
2015-10-26 04:00:00	IWM	ETF	115.29	115.29	115.29	115.29	100.0
2015-10-26 08:00:00	IWM	ETF	115.34	115.59	115.33	115.54	15355.0
2015-10-26 09:00:00	IWM	ETF	115.57	115.87	115.26	115.33	2144555.0
2015-10-26 10:00:00	IWM	ETF	115.33	115.58	114.93	115.47	3362228.0
2015-10-26 11:00:00	IWM	ETF	115.49	115.6	115.15	115.2605	2135646.0
2015-10-26 12:00:00	IWM	ETF	115.2601	115.6	115.18	115.282	2031705.0
2015-10-26 13:00:00	IWM	ETF	115.28	115.48	115.13	115.13	1823469.0
2015-10-26 14:00:00	IWM	ETF	115.14	115.25	114.95	115.12	2102453.0
2015-10-26 15:00:00	IWM	ETF	115.12	115.33	115.04	115.08	3810860.0
2015-10-26 16:00:00	IWM	ETF	115.08	115.2932	114.97	115.0	667855.0
2015-10-26 17:00:00	IWM	ETF	114.97	115.04	114.97	115.04	1300.0
2015-10-26 18:00:00	IWM	ETF	115.2	115.2	115.2	115.2	1000.0
2015-10-26 07:00:00	DIA	ETF	175.9	175.9	175.9	175.9	200.0
2015-10-26 08:00:00	DIA	ETF	176.0	176.26	175.95	176.26	1900.0
2015-10-26 09:00:00	DIA	ETF	176.28	176.46	176.05	176.06	590208.0
2015-10-26 10:00:00	DIA	ETF	176.06	176.28	175.91	176.2	820515.0
2015-10-26 11:00:00	DIA	ETF	176.22	176.26	175.96	175.9899	311150.0
2015-10-26 12:00:00	DIA	ETF	175.99	176.27	175.87	176.2	416496.0

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

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