PREVIEW / etf_1hour / 2015-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-16.parquet
  size:    253 KB
  rows:    8,092

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-12-16 04:00:00	SPY	ETF	205.48	205.94	205.48	205.94	11898.0
2015-12-16 05:00:00	SPY	ETF	205.95	206.6	205.82	206.41	34165.0
2015-12-16 06:00:00	SPY	ETF	206.25	206.54	206.12	206.25	47745.0
2015-12-16 07:00:00	SPY	ETF	206.25	206.3	205.97	206.12	136982.0
2015-12-16 08:00:00	SPY	ETF	205.89	206.5	205.42	206.35	859299.0
2015-12-16 09:00:00	SPY	ETF	206.37	206.78	205.03	206.16	13830342.0
2015-12-16 10:00:00	SPY	ETF	206.17	206.37	205.475	205.72	20590051.0
2015-12-16 11:00:00	SPY	ETF	205.72	205.79	205.3201	205.65	13735705.0
2015-12-16 12:00:00	SPY	ETF	205.65	205.88	205.36	205.42	10442392.0
2015-12-16 13:00:00	SPY	ETF	205.43	206.36	205.315	206.2525	10297062.0
2015-12-16 14:00:00	SPY	ETF	206.19	207.76	204.8	207.68	53437789.0
2015-12-16 15:00:00	SPY	ETF	207.69	208.39	207.03	207.98	54419787.0
2015-12-16 16:00:00	SPY	ETF	207.99	208.23	207.53	207.53	12277622.0
2015-12-16 17:00:00	SPY	ETF	207.55	207.72	207.54	207.63	466966.0
2015-12-16 18:00:00	SPY	ETF	207.63	207.9	207.52	207.82	296221.0
2015-12-16 19:00:00	SPY	ETF	207.85	207.86	207.57	207.57	117249.0
2015-12-16 04:00:00	QQQ	ETF	112.7	112.84	112.7	112.84	500.0
2015-12-16 05:00:00	QQQ	ETF	112.94	113.26	112.94	113.15	14000.0
2015-12-16 06:00:00	QQQ	ETF	113.11	113.28	113.04	113.07	5770.0
2015-12-16 07:00:00	QQQ	ETF	113.07	113.08	112.89	112.94	101112.0
2015-12-16 08:00:00	QQQ	ETF	113.01	113.12	112.9	113.1	63645.0
2015-12-16 09:00:00	QQQ	ETF	113.09	113.3	112.73	112.75	2921884.0
2015-12-16 10:00:00	QQQ	ETF	112.75	112.8452	112.23	112.549	4970907.0
2015-12-16 11:00:00	QQQ	ETF	112.54	112.62	112.33	112.45	2274481.0
2015-12-16 12:00:00	QQQ	ETF	112.43	112.54	112.26	112.28	1895541.0
2015-12-16 13:00:00	QQQ	ETF	112.29	112.81	112.21	112.74	4216929.0
2015-12-16 14:00:00	QQQ	ETF	112.7	113.78	111.89	113.7662	12502035.0
2015-12-16 15:00:00	QQQ	ETF	113.77	114.17	113.34	113.96	7467960.0
2015-12-16 16:00:00	QQQ	ETF	113.96	114.1	113.74	113.75	791474.0
2015-12-16 17:00:00	QQQ	ETF	113.7	113.82	113.7	113.78	20873.0
2015-12-16 18:00:00	QQQ	ETF	113.79	113.89	113.72	113.88	26967.0
2015-12-16 19:00:00	QQQ	ETF	113.8	113.88	113.75	113.75	18220.0
2015-12-16 04:00:00	IWM	ETF	113.09	113.2	113.09	113.2	2200.0
2015-12-16 05:00:00	IWM	ETF	113.31	113.53	113.16	113.51	61188.0
2015-12-16 06:00:00	IWM	ETF	113.42	113.6	113.42	113.54	20020.0
2015-12-16 07:00:00	IWM	ETF	113.41	113.5	113.32	113.45	33575.0
2015-12-16 08:00:00	IWM	ETF	113.47	113.66	113.35	113.6	100757.0
2015-12-16 09:00:00	IWM	ETF	113.56	113.79	113.27	113.5	4481190.0
2015-12-16 10:00:00	IWM	ETF	113.51	113.715	113.065	113.15	5619196.0
2015-12-16 11:00:00	IWM	ETF	113.15	113.29	112.83	113.18	3314347.0
2015-12-16 12:00:00	IWM	ETF	113.1851	113.5	112.97	113.02	3972903.0
2015-12-16 13:00:00	IWM	ETF	113.04	113.7	112.975	113.64	2615413.0
2015-12-16 14:00:00	IWM	ETF	113.58	114.08	112.9	114.01	9520785.0
2015-12-16 15:00:00	IWM	ETF	114.01	114.645	113.69	114.44	9696297.0
2015-12-16 16:00:00	IWM	ETF	114.45	114.53	114.21	114.33	1513301.0
2015-12-16 17:00:00	IWM	ETF	114.3	114.4	114.26	114.4	130550.0
2015-12-16 18:00:00	IWM	ETF	114.42	114.42	114.42	114.42	100.0
2015-12-16 19:00:00	IWM	ETF	114.34	114.34	114.29	114.29	1255.0
2015-12-16 05:00:00	DIA	ETF	176.69	176.73	176.69	176.73	200.0
2015-12-16 06:00:00	DIA	ETF	176.7	176.7	176.7	176.7	100.0

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

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