PREVIEW / etf_1hour / 2016-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-03-17.parquet
  size:    255 KB
  rows:    8,135

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
2016-03-17 04:00:00	SPY	ETF	203.94	204.27	203.93	204.06	24592.0
2016-03-17 05:00:00	SPY	ETF	204.0	204.0	202.89	203.07	60939.0
2016-03-17 06:00:00	SPY	ETF	202.86	203.13	202.17	202.5	170599.0
2016-03-17 07:00:00	SPY	ETF	202.56	202.8	202.41	202.47	411411.0
2016-03-17 08:00:00	SPY	ETF	202.47	203.76	202.3	202.81	1471724.0
2016-03-17 09:00:00	SPY	ETF	202.82	203.48	202.74	203.015	8661712.0
2016-03-17 10:00:00	SPY	ETF	203.02	203.88	202.77	203.84	13862220.0
2016-03-17 11:00:00	SPY	ETF	203.85	204.12	203.705	204.06	17454253.0
2016-03-17 12:00:00	SPY	ETF	204.07	204.67	203.895	204.49	14430668.0
2016-03-17 13:00:00	SPY	ETF	204.5	204.91	204.25	204.9	14361379.0
2016-03-17 14:00:00	SPY	ETF	204.89	205.23	204.69	204.71	16495232.0
2016-03-17 15:00:00	SPY	ETF	204.71	205.14	204.61	204.65	26362469.0
2016-03-17 16:00:00	SPY	ETF	204.65	204.86	203.2993	204.7	10659942.0
2016-03-17 17:00:00	SPY	ETF	204.71	204.75	204.64	204.7	1148267.0
2016-03-17 18:00:00	SPY	ETF	204.7	204.79	204.634	204.78	1810663.0
2016-03-17 19:00:00	SPY	ETF	204.78	204.93	204.65	204.77	122244.0
2016-03-17 04:00:00	QQQ	ETF	107.82	107.96	107.82	107.86	2200.0
2016-03-17 05:00:00	QQQ	ETF	107.81	107.81	107.09	107.09	5200.0
2016-03-17 06:00:00	QQQ	ETF	107.2	107.2	106.75	106.94	18735.0
2016-03-17 07:00:00	QQQ	ETF	106.9	107.0	106.81	106.83	56244.0
2016-03-17 08:00:00	QQQ	ETF	106.85	107.09	106.79	107.01	150556.0
2016-03-17 09:00:00	QQQ	ETF	107.02	107.54	106.99	107.075	2954390.0
2016-03-17 10:00:00	QQQ	ETF	107.08	107.3534	106.87	107.35	3484434.0
2016-03-17 11:00:00	QQQ	ETF	107.34	107.39	107.18	107.301	2321105.0
2016-03-17 12:00:00	QQQ	ETF	107.31	107.7	107.2	107.5364	2606383.0
2016-03-17 13:00:00	QQQ	ETF	107.54	107.68	107.34	107.6	3245595.0
2016-03-17 14:00:00	QQQ	ETF	107.6	107.77	107.32	107.335	3692811.0
2016-03-17 15:00:00	QQQ	ETF	107.338	107.76	107.33	107.49	4985684.0
2016-03-17 16:00:00	QQQ	ETF	107.51	107.64	107.49	107.63	1510940.0
2016-03-17 17:00:00	QQQ	ETF	107.61	107.61	107.53	107.55	804287.0
2016-03-17 18:00:00	QQQ	ETF	107.458	107.61	107.458	107.6	5167.0
2016-03-17 19:00:00	QQQ	ETF	107.6	107.75	107.59	107.75	6640.0
2016-03-17 04:00:00	IWM	ETF	107.27	107.3	107.27	107.3	2000.0
2016-03-17 05:00:00	IWM	ETF	106.98	107.15	106.77	106.77	3400.0
2016-03-17 06:00:00	IWM	ETF	106.69	106.69	106.09	106.25	34100.0
2016-03-17 07:00:00	IWM	ETF	106.3	106.46	106.23	106.37	18160.0
2016-03-17 08:00:00	IWM	ETF	106.36	106.58	106.22	106.45	57545.0
2016-03-17 09:00:00	IWM	ETF	106.47	107.0	106.33	106.66	4130533.0
2016-03-17 10:00:00	IWM	ETF	106.67	107.47	106.53	107.43	4690943.0
2016-03-17 11:00:00	IWM	ETF	107.44	107.49	107.2	107.42	2825986.0
2016-03-17 12:00:00	IWM	ETF	107.43	108.17	107.28	108.158	4870039.0
2016-03-17 13:00:00	IWM	ETF	108.16	108.38	107.83	108.33	4883147.0
2016-03-17 14:00:00	IWM	ETF	108.32	108.65	108.18	108.485	4369877.0
2016-03-17 15:00:00	IWM	ETF	108.49	109.1	108.48	108.62	9054071.0
2016-03-17 16:00:00	IWM	ETF	108.63	108.68	108.51	108.6	1162562.0
2016-03-17 17:00:00	IWM	ETF	108.6	108.6	108.52	108.52	2486.0
2016-03-17 18:00:00	IWM	ETF	108.56	108.68	108.56	108.68	4700.0
2016-03-17 19:00:00	IWM	ETF	108.68	108.85	108.66	108.85	10552.0
2016-03-17 04:00:00	DIA	ETF	174.1	174.1	174.1	174.1	2000.0
2016-03-17 07:00:00	DIA	ETF	172.7	173.11	172.7	173.11	1350.0

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

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