PREVIEW / etf_1hour / 2015-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-03.parquet
  size:    246 KB
  rows:    7,817

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-11-03 04:00:00	SPY	ETF	209.92	209.98	209.83	209.91	27144.0
2015-11-03 05:00:00	SPY	ETF	209.99	209.99	209.8	209.8	10615.0
2015-11-03 06:00:00	SPY	ETF	209.87	209.87	209.67	209.68	25694.0
2015-11-03 07:00:00	SPY	ETF	209.71	209.77	209.56	209.69	215401.0
2015-11-03 08:00:00	SPY	ETF	209.68	210.39	209.54	209.77	421254.0
2015-11-03 09:00:00	SPY	ETF	209.77	210.21	209.7	209.87	10637165.0
2015-11-03 10:00:00	SPY	ETF	209.87	210.54	209.8611	210.31	10700974.0
2015-11-03 11:00:00	SPY	ETF	210.315	210.94	210.21	210.88	11029649.0
2015-11-03 12:00:00	SPY	ETF	210.885	210.94	210.56	210.8263	7359447.0
2015-11-03 13:00:00	SPY	ETF	210.825	211.23	210.77	211.1006	10550094.0
2015-11-03 14:00:00	SPY	ETF	211.105	211.66	211.08	211.415	23568747.0
2015-11-03 15:00:00	SPY	ETF	211.415	211.43	210.74	210.96	15261952.0
2015-11-03 16:00:00	SPY	ETF	210.95	211.0	210.78	210.9	4149183.0
2015-11-03 17:00:00	SPY	ETF	210.9	210.93	210.82	210.82	66165.0
2015-11-03 18:00:00	SPY	ETF	210.86	210.87	210.8	210.83	40767.0
2015-11-03 19:00:00	SPY	ETF	210.83	211.0	210.74	210.78	50753.0
2015-11-03 04:00:00	QQQ	ETF	114.44	114.44	114.35	114.43	1684.0
2015-11-03 05:00:00	QQQ	ETF	114.43	114.43	114.39	114.39	9794.0
2015-11-03 06:00:00	QQQ	ETF	114.4	114.4	114.3	114.3	17700.0
2015-11-03 07:00:00	QQQ	ETF	114.32	114.35	114.27	114.31	18485.0
2015-11-03 08:00:00	QQQ	ETF	114.34	114.38	114.21	114.3	68211.0
2015-11-03 09:00:00	QQQ	ETF	114.32	114.534	114.21	114.369	2325016.0
2015-11-03 10:00:00	QQQ	ETF	114.371	114.7	114.36	114.53	2526229.0
2015-11-03 11:00:00	QQQ	ETF	114.54	114.99	114.49	114.95	2523203.0
2015-11-03 12:00:00	QQQ	ETF	114.95	115.0299	114.835	114.95	1794269.0
2015-11-03 13:00:00	QQQ	ETF	114.95	115.2	114.9315	115.16	1622220.0
2015-11-03 14:00:00	QQQ	ETF	115.15	115.42	115.14	115.32	2850000.0
2015-11-03 15:00:00	QQQ	ETF	115.31	115.31	114.86	115.01	3775766.0
2015-11-03 16:00:00	QQQ	ETF	115.01	115.07	114.91	115.04	427018.0
2015-11-03 17:00:00	QQQ	ETF	115.05	115.05	115.01	115.02	4171.0
2015-11-03 18:00:00	QQQ	ETF	115.0	115.02	115.0	115.02	3530.0
2015-11-03 19:00:00	QQQ	ETF	114.99	114.99	114.96	114.99	35966.0
2015-11-03 07:00:00	IWM	ETF	117.46	117.46	117.33	117.45	15700.0
2015-11-03 08:00:00	IWM	ETF	117.43	117.51	117.35	117.43	33158.0
2015-11-03 09:00:00	IWM	ETF	117.5	117.96	117.39	117.53	2263250.0
2015-11-03 10:00:00	IWM	ETF	117.53	117.925	117.39	117.67	3102050.0
2015-11-03 11:00:00	IWM	ETF	117.68	118.59	117.63	118.529	3237272.0
2015-11-03 12:00:00	IWM	ETF	118.52	118.79	118.4067	118.71	2336437.0
2015-11-03 13:00:00	IWM	ETF	118.705	118.85	118.36	118.76	2944895.0
2015-11-03 14:00:00	IWM	ETF	118.76	119.0299	118.61	118.8	3582088.0
2015-11-03 15:00:00	IWM	ETF	118.81	118.82	118.32	118.34	6480872.0
2015-11-03 16:00:00	IWM	ETF	118.34	118.56	118.23	118.26	1183010.0
2015-11-03 17:00:00	IWM	ETF	118.27	118.27	118.23	118.27	1399.0
2015-11-03 19:00:00	IWM	ETF	118.39	118.39	118.35	118.35	1007.0
2015-11-03 07:00:00	DIA	ETF	177.66	177.66	177.6	177.6	1300.0
2015-11-03 08:00:00	DIA	ETF	177.62	177.85	177.6	177.71	968.0
2015-11-03 09:00:00	DIA	ETF	177.92	178.24	177.8	178.06	489728.0
2015-11-03 10:00:00	DIA	ETF	178.08	178.8	178.06	178.68	452313.0
2015-11-03 11:00:00	DIA	ETF	178.7	179.1	178.59	179.07	425699.0
2015-11-03 12:00:00	DIA	ETF	179.06	179.1	178.77	178.98	356974.0

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

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