PREVIEW / etf_1hour / 2015-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-14.parquet
  size:    236 KB
  rows:    7,491

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-04-14 04:00:00	SPY	ETF	209.58	209.73	209.21	209.21	13730.0
2015-04-14 05:00:00	SPY	ETF	209.14	209.14	208.46	208.74	35737.0
2015-04-14 06:00:00	SPY	ETF	208.69	209.02	208.69	208.82	68751.0
2015-04-14 07:00:00	SPY	ETF	208.82	209.17	208.79	208.89	306850.0
2015-04-14 08:00:00	SPY	ETF	208.89	209.77	208.73	209.0	1003453.0
2015-04-14 09:00:00	SPY	ETF	208.99	209.5	208.56	208.73	11763557.0
2015-04-14 10:00:00	SPY	ETF	208.73	208.75	208.1	208.575	17010703.0
2015-04-14 11:00:00	SPY	ETF	208.58	209.33	208.42	209.19	10494808.0
2015-04-14 12:00:00	SPY	ETF	209.2	209.71	209.15	209.41	6263047.0
2015-04-14 13:00:00	SPY	ETF	209.41	209.475	209.23	209.355	3167355.0
2015-04-14 14:00:00	SPY	ETF	209.35	209.42	209.09	209.37	5121191.0
2015-04-14 15:00:00	SPY	ETF	209.37	209.6	209.19	209.48	13884618.0
2015-04-14 16:00:00	SPY	ETF	209.48	209.7	209.3137	209.62	4608381.0
2015-04-14 17:00:00	SPY	ETF	209.62	209.68	209.61	209.66	59779.0
2015-04-14 18:00:00	SPY	ETF	209.67	209.68	209.58	209.66	90827.0
2015-04-14 19:00:00	SPY	ETF	209.62	209.63	209.52	209.55	211649.0
2015-04-14 05:00:00	QQQ	ETF	107.24	107.24	107.04	107.12	500.0
2015-04-14 06:00:00	QQQ	ETF	107.25	107.27	107.23	107.24	19800.0
2015-04-14 07:00:00	QQQ	ETF	107.26	107.49	107.23	107.35	44958.0
2015-04-14 08:00:00	QQQ	ETF	107.35	107.51	107.29	107.48	114578.0
2015-04-14 09:00:00	QQQ	ETF	107.46	107.68	106.87	106.96	5413912.0
2015-04-14 10:00:00	QQQ	ETF	106.96	107.04	106.56	106.755	4907740.0
2015-04-14 11:00:00	QQQ	ETF	106.75	107.11	106.66	106.925	3205671.0
2015-04-14 12:00:00	QQQ	ETF	106.93	107.32	106.91	107.06	2424038.0
2015-04-14 13:00:00	QQQ	ETF	107.06	107.08	106.9	107.0	1525335.0
2015-04-14 14:00:00	QQQ	ETF	107.0	107.12	106.9	107.08	949176.0
2015-04-14 15:00:00	QQQ	ETF	107.08	107.21	107.0249	107.17	3030543.0
2015-04-14 16:00:00	QQQ	ETF	107.17	107.33	107.1699	107.29	394883.0
2015-04-14 17:00:00	QQQ	ETF	107.29	107.38	107.29	107.36	40677.0
2015-04-14 18:00:00	QQQ	ETF	107.36	107.37	107.27	107.31	17059.0
2015-04-14 19:00:00	QQQ	ETF	107.28	107.28	107.25	107.25	4306.0
2015-04-14 05:00:00	IWM	ETF	125.45	125.45	125.35	125.35	2000.0
2015-04-14 07:00:00	IWM	ETF	125.75	126.0	125.75	125.88	14520.0
2015-04-14 08:00:00	IWM	ETF	125.86	125.96	125.68	125.86	61150.0
2015-04-14 09:00:00	IWM	ETF	125.82	126.08	125.31	125.36	1771173.0
2015-04-14 10:00:00	IWM	ETF	125.34	125.4099	124.78	125.31	4304843.0
2015-04-14 11:00:00	IWM	ETF	125.305	125.91	125.21	125.78	2668717.0
2015-04-14 12:00:00	IWM	ETF	125.78	125.96	125.675	125.7	873447.0
2015-04-14 13:00:00	IWM	ETF	125.705	125.73	125.55	125.65	882103.0
2015-04-14 14:00:00	IWM	ETF	125.65	125.79	125.51	125.68	1030687.0
2015-04-14 15:00:00	IWM	ETF	125.68	125.78	125.55	125.67	3173661.0
2015-04-14 16:00:00	IWM	ETF	125.68	125.77	124.9187	125.71	742101.0
2015-04-14 17:00:00	IWM	ETF	125.72	125.82	125.72	125.8	181691.0
2015-04-14 07:00:00	DIA	ETF	179.85	179.85	179.85	179.85	100.0
2015-04-14 08:00:00	DIA	ETF	179.67	179.74	179.4	179.55	3940.0
2015-04-14 09:00:00	DIA	ETF	179.5	180.16	179.34	179.46	754819.0
2015-04-14 10:00:00	DIA	ETF	179.46	179.47	178.8	179.24	815913.0
2015-04-14 11:00:00	DIA	ETF	179.22	180.04	179.08	179.97	1207422.0
2015-04-14 12:00:00	DIA	ETF	179.99	180.54	179.95	180.32	701885.0
2015-04-14 13:00:00	DIA	ETF	180.33	180.38	180.07	180.19	212033.0

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

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