PREVIEW / etf_1hour / 2015-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-28.parquet
  size:    245 KB
  rows:    7,803

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-07-28 04:00:00	SPY	ETF	207.74	208.16	207.74	208.16	4906.0
2015-07-28 05:00:00	SPY	ETF	208.24	208.39	208.14	208.37	64870.0
2015-07-28 06:00:00	SPY	ETF	208.34	208.41	208.07	208.07	355437.0
2015-07-28 07:00:00	SPY	ETF	208.1	208.18	207.99	208.1	272905.0
2015-07-28 08:00:00	SPY	ETF	208.07	208.25	207.88	208.01	917447.0
2015-07-28 09:00:00	SPY	ETF	208.01	208.01	206.95	207.54	15426880.0
2015-07-28 10:00:00	SPY	ETF	207.54	207.785	206.8	207.76	21056687.0
2015-07-28 11:00:00	SPY	ETF	207.765	208.28	207.7	208.24	15714991.0
2015-07-28 12:00:00	SPY	ETF	208.24	208.69	208.23	208.588	11538501.0
2015-07-28 13:00:00	SPY	ETF	208.58	209.22	208.55	209.18	10929828.0
2015-07-28 14:00:00	SPY	ETF	209.18	209.5	209.11	209.4265	13372718.0
2015-07-28 15:00:00	SPY	ETF	209.43	209.44	209.09	209.3	22772625.0
2015-07-28 16:00:00	SPY	ETF	209.29	209.53	209.08	209.43	7935106.0
2015-07-28 17:00:00	SPY	ETF	209.43	209.49	209.33	209.42	727613.0
2015-07-28 18:00:00	SPY	ETF	209.41	209.5	209.32	209.47	208366.0
2015-07-28 19:00:00	SPY	ETF	209.47	209.53	209.45	209.5	305123.0
2015-07-28 04:00:00	QQQ	ETF	110.68	110.77	110.64	110.77	6869.0
2015-07-28 05:00:00	QQQ	ETF	110.88	111.0	110.88	111.0	22550.0
2015-07-28 06:00:00	QQQ	ETF	110.97	111.0	110.83	110.83	34916.0
2015-07-28 07:00:00	QQQ	ETF	110.83	110.85	110.79	110.8	53619.0
2015-07-28 08:00:00	QQQ	ETF	110.8	110.9	110.73	110.78	174373.0
2015-07-28 09:00:00	QQQ	ETF	110.8	110.8	109.88	110.39	5411950.0
2015-07-28 10:00:00	QQQ	ETF	110.4	110.42	109.785	110.3	9440233.0
2015-07-28 11:00:00	QQQ	ETF	110.3	110.6	110.22	110.59	3358563.0
2015-07-28 12:00:00	QQQ	ETF	110.59	110.87	110.581	110.72	1980965.0
2015-07-28 13:00:00	QQQ	ETF	110.715	111.13	110.68	111.11	2793108.0
2015-07-28 14:00:00	QQQ	ETF	111.11	111.35	111.075	111.26	3101146.0
2015-07-28 15:00:00	QQQ	ETF	111.26	111.27	110.99	111.13	3636453.0
2015-07-28 16:00:00	QQQ	ETF	111.13	111.3	111.09	111.28	701103.0
2015-07-28 17:00:00	QQQ	ETF	111.28	111.3	111.26	111.29	85969.0
2015-07-28 18:00:00	QQQ	ETF	111.25	111.29	111.2	111.29	14059.0
2015-07-28 19:00:00	QQQ	ETF	111.26	111.29	111.25	111.25	2600.0
2015-07-28 07:00:00	IWM	ETF	121.22	121.26	121.17	121.23	8188.0
2015-07-28 08:00:00	IWM	ETF	121.25	121.31	120.99	121.08	62905.0
2015-07-28 09:00:00	IWM	ETF	120.98	121.02	119.339	120.3	7174856.0
2015-07-28 10:00:00	IWM	ETF	120.31	120.55	119.75	120.5	8248682.0
2015-07-28 11:00:00	IWM	ETF	120.49	121.115	120.48	121.1	5190490.0
2015-07-28 12:00:00	IWM	ETF	121.1	121.44	121.07	121.19	2587511.0
2015-07-28 13:00:00	IWM	ETF	121.2	121.7	121.17	121.65	3678061.0
2015-07-28 14:00:00	IWM	ETF	121.65	121.81	121.17	121.47	3684916.0
2015-07-28 15:00:00	IWM	ETF	121.47	121.6	121.29	121.6	4018115.0
2015-07-28 16:00:00	IWM	ETF	121.59	121.72	121.32	121.67	2550350.0
2015-07-28 17:00:00	IWM	ETF	121.65	121.65	121.6	121.63	802500.0
2015-07-28 18:00:00	IWM	ETF	121.55	121.68	121.55	121.68	1900.0
2015-07-28 05:00:00	DIA	ETF	175.3	175.47	175.3	175.45	17794.0
2015-07-28 07:00:00	DIA	ETF	175.28	175.3	175.28	175.3	3500.0
2015-07-28 08:00:00	DIA	ETF	175.27	175.407	175.27	175.407	2430.0
2015-07-28 09:00:00	DIA	ETF	175.0	175.0	174.31	174.79	1013608.0
2015-07-28 10:00:00	DIA	ETF	174.78	175.08	174.3	175.06	1248504.0
2015-07-28 11:00:00	DIA	ETF	175.05	175.42	174.93	175.28	781076.0

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

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