PREVIEW / etf_1hour / 2015-10-08

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-08.parquet
  size:    241 KB
  rows:    7,638

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-10-08 04:00:00	SPY	ETF	198.25	198.69	198.1	198.12	53111.0
2015-10-08 05:00:00	SPY	ETF	198.12	198.62	198.01	198.42	67710.0
2015-10-08 06:00:00	SPY	ETF	198.45	198.96	198.45	198.67	166438.0
2015-10-08 07:00:00	SPY	ETF	198.69	198.96	198.59	198.88	326827.0
2015-10-08 08:00:00	SPY	ETF	198.73	199.41	198.33	198.61	980246.0
2015-10-08 09:00:00	SPY	ETF	198.61	199.17	198.47	199.0	12271157.0
2015-10-08 10:00:00	SPY	ETF	198.99	199.29	198.69	199.14	11923571.0
2015-10-08 11:00:00	SPY	ETF	199.14	199.43	198.68	199.36	12471769.0
2015-10-08 12:00:00	SPY	ETF	199.37	199.65	198.75	198.95	12670783.0
2015-10-08 13:00:00	SPY	ETF	198.9427	199.6	198.87	199.55	9282927.0
2015-10-08 14:00:00	SPY	ETF	199.55	200.94	199.31	200.81	38772261.0
2015-10-08 15:00:00	SPY	ETF	200.81	201.55	200.77	201.22	44288166.0
2015-10-08 16:00:00	SPY	ETF	201.19	201.4	201.08	201.26	6423906.0
2015-10-08 17:00:00	SPY	ETF	201.25	201.32	201.07	201.08	152549.0
2015-10-08 18:00:00	SPY	ETF	201.1	201.21	201.04	201.16	1126384.0
2015-10-08 19:00:00	SPY	ETF	201.2	201.3	201.14	201.19	113495.0
2015-10-08 04:00:00	QQQ	ETF	104.92	105.0	104.92	104.92	4300.0
2015-10-08 05:00:00	QQQ	ETF	104.97	105.14	104.97	105.07	12270.0
2015-10-08 06:00:00	QQQ	ETF	105.08	105.34	105.08	105.24	3298.0
2015-10-08 07:00:00	QQQ	ETF	105.27	105.37	105.25	105.32	24100.0
2015-10-08 08:00:00	QQQ	ETF	105.33	105.63	105.06	105.15	108824.0
2015-10-08 09:00:00	QQQ	ETF	105.11	105.29	104.86	105.09	7187444.0
2015-10-08 10:00:00	QQQ	ETF	105.09	105.25	104.6801	104.87	4783985.0
2015-10-08 11:00:00	QQQ	ETF	104.87	104.94	104.38	104.77	3488954.0
2015-10-08 12:00:00	QQQ	ETF	104.77	104.97	104.21	104.35	3638321.0
2015-10-08 13:00:00	QQQ	ETF	104.36	104.83	104.33	104.829	2862132.0
2015-10-08 14:00:00	QQQ	ETF	104.83	105.83	104.73	105.75	11441634.0
2015-10-08 15:00:00	QQQ	ETF	105.75	106.23	105.705	106.025	12622333.0
2015-10-08 16:00:00	QQQ	ETF	106.04	106.22	105.95	106.07	805218.0
2015-10-08 17:00:00	QQQ	ETF	106.09	106.09	105.98	105.98	6224.0
2015-10-08 18:00:00	QQQ	ETF	105.99	106.02	105.98	106.02	23024.0
2015-10-08 19:00:00	QQQ	ETF	106.07	106.1	106.03	106.1	27785.0
2015-10-08 04:00:00	IWM	ETF	114.3	114.3	113.98	113.98	329.0
2015-10-08 07:00:00	IWM	ETF	114.27	114.32	114.26	114.32	5100.0
2015-10-08 08:00:00	IWM	ETF	114.38	114.39	114.08	114.24	87049.0
2015-10-08 09:00:00	IWM	ETF	114.22	114.52	113.95	114.375	3144859.0
2015-10-08 10:00:00	IWM	ETF	114.38	114.76	114.23	114.61	5037830.0
2015-10-08 11:00:00	IWM	ETF	114.61	114.72	114.08	114.57	3341807.0
2015-10-08 12:00:00	IWM	ETF	114.58	114.87	114.1385	114.37	3786509.0
2015-10-08 13:00:00	IWM	ETF	114.38	114.68	114.23	114.6673	2773528.0
2015-10-08 14:00:00	IWM	ETF	114.68	115.46	114.44	115.33	8251974.0
2015-10-08 15:00:00	IWM	ETF	115.33	115.75	115.27	115.54	8687148.0
2015-10-08 16:00:00	IWM	ETF	115.55	115.67	115.4	115.49	3050916.0
2015-10-08 17:00:00	IWM	ETF	115.46	115.48	115.46	115.48	500.0
2015-10-08 18:00:00	IWM	ETF	115.41	115.51	115.41	115.42	14700.0
2015-10-08 19:00:00	IWM	ETF	115.42	115.44	115.42	115.43	400.0
2015-10-08 07:00:00	DIA	ETF	168.46	168.46	168.44	168.44	475.0
2015-10-08 08:00:00	DIA	ETF	168.58	168.95	168.2	168.32	4637.0
2015-10-08 09:00:00	DIA	ETF	168.37	168.88	168.37	168.77	555766.0
2015-10-08 10:00:00	DIA	ETF	168.76	169.0	168.57	168.9	508384.0

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

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