PREVIEW / etf_1hour / 2017-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-02-28.parquet
  size:    278 KB
  rows:    8,998

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-02-28 04:00:00	SPY	ETF	236.94	237.05	236.86	237.05	2550.0
2017-02-28 05:00:00	SPY	ETF	237.05	237.1	236.9	236.9	1305.0
2017-02-28 06:00:00	SPY	ETF	237.02	237.06	237.02	237.04	2405.0
2017-02-28 07:00:00	SPY	ETF	237.01	237.01	236.88	236.88	64153.0
2017-02-28 08:00:00	SPY	ETF	236.89	237.01	236.76	236.87	141865.0
2017-02-28 09:00:00	SPY	ETF	236.88	236.9	236.61	236.6899	6581407.0
2017-02-28 10:00:00	SPY	ETF	236.69	236.95	236.67	236.91	6523678.0
2017-02-28 11:00:00	SPY	ETF	236.91	236.94	236.75	236.79	4850577.0
2017-02-28 12:00:00	SPY	ETF	236.79	236.8	236.015	236.38	8848204.0
2017-02-28 13:00:00	SPY	ETF	236.39	236.63	236.35	236.62	7846794.0
2017-02-28 14:00:00	SPY	ETF	236.62	236.6685	236.23	236.4865	8687185.0
2017-02-28 15:00:00	SPY	ETF	236.495	236.69	236.16	236.51	24273017.0
2017-02-28 16:00:00	SPY	ETF	236.51	236.72	236.2573	236.7	23638486.0
2017-02-28 17:00:00	SPY	ETF	236.69	236.74	236.47	236.69	2461555.0
2017-02-28 18:00:00	SPY	ETF	236.69	236.77	236.47	236.72	133072.0
2017-02-28 19:00:00	SPY	ETF	236.73	236.93	236.7	236.93	91940.0
2017-02-28 05:00:00	QQQ	ETF	130.38	130.38	130.38	130.38	100.0
2017-02-28 06:00:00	QQQ	ETF	130.38	130.39	130.38	130.39	1421.0
2017-02-28 07:00:00	QQQ	ETF	130.41	130.44	130.4	130.44	50197.0
2017-02-28 08:00:00	QQQ	ETF	130.38	130.42	130.34	130.42	53956.0
2017-02-28 09:00:00	QQQ	ETF	130.41	130.45	130.19	130.24	1374471.0
2017-02-28 10:00:00	QQQ	ETF	130.24	130.32	130.11	130.26	1199242.0
2017-02-28 11:00:00	QQQ	ETF	130.25	130.34	130.18	130.19	794366.0
2017-02-28 12:00:00	QQQ	ETF	130.19	130.21	129.66	129.88	2063808.0
2017-02-28 13:00:00	QQQ	ETF	129.88	130.06	129.86	130.06	1263787.0
2017-02-28 14:00:00	QQQ	ETF	130.055	130.08	129.855	129.98	1358148.0
2017-02-28 15:00:00	QQQ	ETF	129.98	130.06	129.77	130.0	2871676.0
2017-02-28 16:00:00	QQQ	ETF	130.01	130.1	129.95	130.1	303779.0
2017-02-28 17:00:00	QQQ	ETF	130.09	130.1	130.0	130.05	1483151.0
2017-02-28 18:00:00	QQQ	ETF	130.07	130.11	130.01	130.01	11270.0
2017-02-28 19:00:00	QQQ	ETF	130.02	130.21	130.02	130.21	28776.0
2017-02-28 06:00:00	IWM	ETF	139.75	139.75	139.73	139.73	1100.0
2017-02-28 07:00:00	IWM	ETF	139.72	139.73	139.61	139.7	54836.0
2017-02-28 08:00:00	IWM	ETF	139.58	139.6	139.38	139.46	104824.0
2017-02-28 09:00:00	IWM	ETF	139.5	139.55	138.835	138.91	2507587.0
2017-02-28 10:00:00	IWM	ETF	138.905	139.12	138.6	139.085	4108316.0
2017-02-28 11:00:00	IWM	ETF	139.08	139.14	138.69	138.72	2713731.0
2017-02-28 12:00:00	IWM	ETF	138.72	138.77	137.94	138.03	3841482.0
2017-02-28 13:00:00	IWM	ETF	138.03	138.29	137.97	138.165	2711861.0
2017-02-28 14:00:00	IWM	ETF	138.18	138.2	137.84	137.991	3742458.0
2017-02-28 15:00:00	IWM	ETF	137.99	138.1399	137.76	137.85	7180410.0
2017-02-28 16:00:00	IWM	ETF	137.85	140.007	137.48	137.68	2293854.0
2017-02-28 17:00:00	IWM	ETF	137.73	137.84	137.7	137.75	36895.0
2017-02-28 18:00:00	IWM	ETF	137.72	137.75	137.67	137.75	4795.0
2017-02-28 19:00:00	IWM	ETF	137.75	137.98	137.75	137.95	19531.0
2017-02-28 08:00:00	DIA	ETF	208.05	208.19	208.04	208.11	6180.0
2017-02-28 09:00:00	DIA	ETF	208.16	208.1895	208.01	208.09	267367.0
2017-02-28 10:00:00	DIA	ETF	208.09	208.285	208.08	208.285	215257.0
2017-02-28 11:00:00	DIA	ETF	208.28	208.31	208.17	208.227	182253.0
2017-02-28 12:00:00	DIA	ETF	208.22	208.23	207.68	207.93	522066.0

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

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