PREVIEW / etf_1hour / 2017-08-21

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-21.parquet
  size:    273 KB
  rows:    8,870

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
2017-08-21 04:00:00	SPY	ETF	242.43	242.45	242.27	242.41	12278.0
2017-08-21 05:00:00	SPY	ETF	242.41	242.66	242.41	242.61	5500.0
2017-08-21 06:00:00	SPY	ETF	242.66	243.04	242.65	242.86	19635.0
2017-08-21 07:00:00	SPY	ETF	242.88	243.06	242.86	242.94	95061.0
2017-08-21 08:00:00	SPY	ETF	242.88	242.95	242.73	242.82	297669.0
2017-08-21 09:00:00	SPY	ETF	242.8	242.85	242.25	242.32	6499226.0
2017-08-21 10:00:00	SPY	ETF	242.33	242.58	241.83	242.51	11813321.0
2017-08-21 11:00:00	SPY	ETF	242.5	243.05	242.3	242.83	7112334.0
2017-08-21 12:00:00	SPY	ETF	242.83	243.2	242.81	242.99	4086261.0
2017-08-21 13:00:00	SPY	ETF	242.99	243.0199	242.59	242.63	5538016.0
2017-08-21 14:00:00	SPY	ETF	242.63	242.78	242.48	242.68	5211506.0
2017-08-21 15:00:00	SPY	ETF	242.68	243.15	242.42	242.93	11839591.0
2017-08-21 16:00:00	SPY	ETF	242.94	243.09	242.9	243.07	9944461.0
2017-08-21 17:00:00	SPY	ETF	243.06	243.07	242.71	243.04	1943251.0
2017-08-21 18:00:00	SPY	ETF	243.04	243.18	242.99	243.09	70665.0
2017-08-21 19:00:00	SPY	ETF	243.07	243.19	243.06	243.18	32809.0
2017-08-21 04:00:00	QQQ	ETF	141.03	141.03	140.9	140.91	2050.0
2017-08-21 05:00:00	QQQ	ETF	141.02	141.08	141.01	141.02	2450.0
2017-08-21 06:00:00	QQQ	ETF	141.07	141.43	141.07	141.25	14427.0
2017-08-21 07:00:00	QQQ	ETF	141.29	141.43	141.27	141.32	187623.0
2017-08-21 08:00:00	QQQ	ETF	141.31	141.4	141.24	141.4	240842.0
2017-08-21 09:00:00	QQQ	ETF	141.4	141.53	140.9	140.98	3870108.0
2017-08-21 10:00:00	QQQ	ETF	140.97	141.01	140.18	140.5501	6861208.0
2017-08-21 11:00:00	QQQ	ETF	140.555	141.2	140.31	141.03	4356136.0
2017-08-21 12:00:00	QQQ	ETF	141.03	141.31	140.98	141.08	3137132.0
2017-08-21 13:00:00	QQQ	ETF	141.08	141.12	140.75	140.79	2709585.0
2017-08-21 14:00:00	QQQ	ETF	140.79	140.91	140.67	140.82	2239645.0
2017-08-21 15:00:00	QQQ	ETF	140.81	141.17	140.54	141.08	5983147.0
2017-08-21 16:00:00	QQQ	ETF	141.05	141.27	141.01	141.27	1113596.0
2017-08-21 17:00:00	QQQ	ETF	141.21	141.23	141.11	141.22	347873.0
2017-08-21 18:00:00	QQQ	ETF	141.22	141.33	141.21	141.24	38804.0
2017-08-21 19:00:00	QQQ	ETF	141.25	141.33	141.23	141.33	5032.0
2017-08-21 05:00:00	IWM	ETF	134.8	134.8	134.8	134.8	804.0
2017-08-21 07:00:00	IWM	ETF	134.99	135.16	134.99	135.08	23678.0
2017-08-21 08:00:00	IWM	ETF	135.04	135.04	134.77	134.84	53627.0
2017-08-21 09:00:00	IWM	ETF	134.72	134.87	134.39	134.44	2756783.0
2017-08-21 10:00:00	IWM	ETF	134.44	134.63	134.14	134.62	2937895.0
2017-08-21 11:00:00	IWM	ETF	134.61	134.84	134.43	134.68	2637660.0
2017-08-21 12:00:00	IWM	ETF	134.675	135.02	134.6253	134.99	1685274.0
2017-08-21 13:00:00	IWM	ETF	135.0	135.02	134.59	134.655	1167243.0
2017-08-21 14:00:00	IWM	ETF	134.66	134.91	134.65	134.81	1034035.0
2017-08-21 15:00:00	IWM	ETF	134.81	134.99	134.66	134.85	4661951.0
2017-08-21 16:00:00	IWM	ETF	134.83	134.93	134.68	134.795	955971.0
2017-08-21 17:00:00	IWM	ETF	134.83	134.83	134.78	134.78	675204.0
2017-08-21 18:00:00	IWM	ETF	134.85	134.95	134.85	134.95	2500.0
2017-08-21 19:00:00	IWM	ETF	134.82	134.89	134.82	134.89	598.0
2017-08-21 05:00:00	DIA	ETF	216.32	216.32	216.32	216.32	309.0
2017-08-21 06:00:00	DIA	ETF	216.56	216.56	216.56	216.56	205.0
2017-08-21 07:00:00	DIA	ETF	216.74	216.84	216.7	216.84	1200.0
2017-08-21 08:00:00	DIA	ETF	216.88	216.88	216.47	216.47	1100.0

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

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