PREVIEW / etf_1hour / 2015-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-22.parquet
  size:    245 KB
  rows:    7,846

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-09-22 04:00:00	SPY	ETF	195.75	195.75	194.18	194.75	114498.0
2015-09-22 05:00:00	SPY	ETF	194.47	194.6	193.91	194.05	210204.0
2015-09-22 06:00:00	SPY	ETF	194.05	194.35	193.6	194.29	212571.0
2015-09-22 07:00:00	SPY	ETF	194.35	194.52	194.01	194.38	1065526.0
2015-09-22 08:00:00	SPY	ETF	194.4	196.66	193.37	193.74	3581203.0
2015-09-22 09:00:00	SPY	ETF	193.75	194.36	193.61	194.04	15223118.0
2015-09-22 10:00:00	SPY	ETF	194.03	194.46	192.87	193.22	23569465.0
2015-09-22 11:00:00	SPY	ETF	193.225	193.5	192.95	193.26	15155232.0
2015-09-22 12:00:00	SPY	ETF	193.25	193.78	192.73	192.77	14542136.0
2015-09-22 13:00:00	SPY	ETF	192.7601	193.29	192.56	193.13	13305535.0
2015-09-22 14:00:00	SPY	ETF	193.13	193.55	192.8	193.43	17001248.0
2015-09-22 15:00:00	SPY	ETF	193.43	194.29	193.08	193.88	28674096.0
2015-09-22 16:00:00	SPY	ETF	193.89	194.32	193.37	193.79	10922750.0
2015-09-22 17:00:00	SPY	ETF	193.79	193.91	193.72	193.85	6295977.0
2015-09-22 18:00:00	SPY	ETF	193.83	193.85	193.31	193.5	268273.0
2015-09-22 19:00:00	SPY	ETF	193.5	193.54	193.36	193.53	92822.0
2015-09-22 04:00:00	QQQ	ETF	105.33	105.33	104.45	104.46	84292.0
2015-09-22 05:00:00	QQQ	ETF	104.57	104.64	104.19	104.19	25500.0
2015-09-22 06:00:00	QQQ	ETF	104.2	104.28	103.85	104.27	67880.0
2015-09-22 07:00:00	QQQ	ETF	104.25	104.38	104.12	104.32	155482.0
2015-09-22 08:00:00	QQQ	ETF	104.32	104.34	103.82	103.96	810957.0
2015-09-22 09:00:00	QQQ	ETF	104.0	104.4225	103.88	103.9999	6889323.0
2015-09-22 10:00:00	QQQ	ETF	103.99	104.34	103.39	103.57	7865065.0
2015-09-22 11:00:00	QQQ	ETF	103.57	103.725	103.32	103.54	5882374.0
2015-09-22 12:00:00	QQQ	ETF	103.54	103.83	103.225	103.2599	4135813.0
2015-09-22 13:00:00	QQQ	ETF	103.25	103.55	103.13	103.5	3764726.0
2015-09-22 14:00:00	QQQ	ETF	103.5	103.8623	103.34	103.8	4313129.0
2015-09-22 15:00:00	QQQ	ETF	103.7986	104.28	103.584	104.12	7234090.0
2015-09-22 16:00:00	QQQ	ETF	104.11	104.4	104.1	104.13	1223939.0
2015-09-22 17:00:00	QQQ	ETF	104.12	104.12	104.05	104.06	24112.0
2015-09-22 18:00:00	QQQ	ETF	104.05	104.05	103.9	103.98	23336.0
2015-09-22 19:00:00	QQQ	ETF	103.96	103.99	103.88	103.98	15567.0
2015-09-22 04:00:00	IWM	ETF	115.08	115.08	114.25	114.25	15199.0
2015-09-22 05:00:00	IWM	ETF	114.25	114.25	113.96	114.21	14000.0
2015-09-22 06:00:00	IWM	ETF	113.96	114.29	113.96	114.15	119501.0
2015-09-22 07:00:00	IWM	ETF	114.25	114.43	114.23	114.42	60815.0
2015-09-22 08:00:00	IWM	ETF	114.43	115.51	113.95	114.22	265842.0
2015-09-22 09:00:00	IWM	ETF	114.23	114.73	114.06	114.36	4049380.0
2015-09-22 10:00:00	IWM	ETF	114.35	114.73	113.715	113.9101	6489614.0
2015-09-22 11:00:00	IWM	ETF	113.92	114.02	113.34	113.52	4784423.0
2015-09-22 12:00:00	IWM	ETF	113.51	113.84	113.2	113.31	3237773.0
2015-09-22 13:00:00	IWM	ETF	113.3	113.5401	113.05	113.23	2733633.0
2015-09-22 14:00:00	IWM	ETF	113.22	113.69	113.1	113.54	3065802.0
2015-09-22 15:00:00	IWM	ETF	113.53	113.94	113.35	113.79	5444614.0
2015-09-22 16:00:00	IWM	ETF	113.78	113.99	113.76	113.79	1001744.0
2015-09-22 17:00:00	IWM	ETF	113.85	113.9	113.85	113.9	2529.0
2015-09-22 18:00:00	IWM	ETF	113.84	113.84	113.84	113.84	300.0
2015-09-22 19:00:00	IWM	ETF	113.55	113.59	113.55	113.59	1830.0
2015-09-22 04:00:00	DIA	ETF	163.25	163.25	163.25	163.25	100.0
2015-09-22 06:00:00	DIA	ETF	162.95	163.2	162.95	163.2	500.0

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

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