PREVIEW / etf_30min / 2015-06-25

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-25.parquet
  size:    368 KB
  rows:    12,584

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-06-25 04:00:00	SPY	ETF	211.0	211.7	211.0	211.66	22069.0
2015-06-25 04:30:00	SPY	ETF	211.66	211.66	211.28	211.31	26828.0
2015-06-25 05:00:00	SPY	ETF	211.31	211.35	211.18	211.28	13805.0
2015-06-25 05:30:00	SPY	ETF	211.2	211.32	211.04	211.21	70905.0
2015-06-25 06:00:00	SPY	ETF	211.22	211.66	211.15	211.33	144309.0
2015-06-25 06:30:00	SPY	ETF	211.48	211.52	211.17	211.36	66931.0
2015-06-25 07:00:00	SPY	ETF	211.34	211.51	211.12	211.19	212033.0
2015-06-25 07:30:00	SPY	ETF	211.21	211.26	211.03	211.11	292574.0
2015-06-25 08:00:00	SPY	ETF	211.49	211.49	210.92	210.92	228631.0
2015-06-25 08:30:00	SPY	ETF	210.97	211.258	210.86	211.11	496760.0
2015-06-25 09:00:00	SPY	ETF	211.11	211.15	210.97	211.1	328417.0
2015-06-25 09:30:00	SPY	ETF	211.1	211.21	210.31	210.78	11998284.0
2015-06-25 10:00:00	SPY	ETF	210.78	211.03	210.57	210.97	4640506.0
2015-06-25 10:30:00	SPY	ETF	210.97	211.0	210.64	210.943	4266198.0
2015-06-25 11:00:00	SPY	ETF	210.95	211.25	210.92	210.99	4731315.0
2015-06-25 11:30:00	SPY	ETF	210.99	211.08	210.84	210.98	6104431.0
2015-06-25 12:00:00	SPY	ETF	210.976	211.015	210.6	210.61	3411492.0
2015-06-25 12:30:00	SPY	ETF	210.6	210.71	210.52	210.66	4627130.0
2015-06-25 13:00:00	SPY	ETF	210.66	210.77	210.57	210.655	2780567.0
2015-06-25 13:30:00	SPY	ETF	210.66	210.66	210.5	210.605	2504642.0
2015-06-25 14:00:00	SPY	ETF	210.61	210.61	209.77	209.85	6120189.0
2015-06-25 14:30:00	SPY	ETF	209.845	210.1	209.81	210.0201	7215513.0
2015-06-25 15:00:00	SPY	ETF	210.025	210.36	209.97	210.17	6621179.0
2015-06-25 15:30:00	SPY	ETF	210.17	210.21	209.81	209.81	11481445.0
2015-06-25 16:00:00	SPY	ETF	209.82	210.95	209.73	209.91	8955918.0
2015-06-25 16:30:00	SPY	ETF	209.92	210.4796	209.82	209.9	2394406.0
2015-06-25 17:00:00	SPY	ETF	209.897	209.98	209.86	209.93	660377.0
2015-06-25 17:30:00	SPY	ETF	209.93	209.96	209.86	209.96	1014769.0
2015-06-25 18:00:00	SPY	ETF	209.97	209.97	209.88	209.97	38440.0
2015-06-25 18:30:00	SPY	ETF	209.97	209.99	209.95	209.98	8590.0
2015-06-25 19:00:00	SPY	ETF	209.98	209.99	209.95	209.95	2900.0
2015-06-25 19:30:00	SPY	ETF	209.95	209.99	209.91	209.99	18310.0
2015-06-25 04:00:00	QQQ	ETF	110.57	110.85	110.57	110.85	300.0
2015-06-25 04:30:00	QQQ	ETF	110.9	110.9	110.81	110.81	6450.0
2015-06-25 05:30:00	QQQ	ETF	110.51	110.56	110.51	110.56	10000.0
2015-06-25 06:00:00	QQQ	ETF	110.86	110.86	110.86	110.86	15700.0
2015-06-25 06:30:00	QQQ	ETF	110.74	110.74	110.71	110.71	10300.0
2015-06-25 07:00:00	QQQ	ETF	110.68	110.74	110.61	110.61	19852.0
2015-06-25 07:30:00	QQQ	ETF	110.63	110.64	110.56	110.56	5655.0
2015-06-25 08:00:00	QQQ	ETF	110.73	110.73	110.57	110.57	30749.0
2015-06-25 08:30:00	QQQ	ETF	110.58	110.62	110.49	110.62	27454.0
2015-06-25 09:00:00	QQQ	ETF	110.59	110.65	110.58	110.64	18448.0
2015-06-25 09:30:00	QQQ	ETF	110.65	110.69	110.24	110.47	2615196.0
2015-06-25 10:00:00	QQQ	ETF	110.495	110.649	110.35	110.57	1005649.0
2015-06-25 10:30:00	QQQ	ETF	110.57	110.59	110.38	110.585	592537.0
2015-06-25 11:00:00	QQQ	ETF	110.59	110.76	110.58	110.64	729323.0
2015-06-25 11:30:00	QQQ	ETF	110.64	110.69	110.57	110.61	721916.0
2015-06-25 12:00:00	QQQ	ETF	110.61	110.64	110.39	110.4	790338.0
2015-06-25 12:30:00	QQQ	ETF	110.4	110.47	110.355	110.43	416596.0
2015-06-25 13:00:00	QQQ	ETF	110.435	110.47	110.37	110.4	404192.0

> showing 50 of 12,584 rows — these rows as CSV

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