PREVIEW / etf_30min / 2015-10-15

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-15.parquet
  size:    385 KB
  rows:    12,873

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-15 04:00:00	SPY	ETF	200.29	200.5	200.2	200.37	11720.0
2015-10-15 04:30:00	SPY	ETF	200.43	200.59	200.39	200.58	23119.0
2015-10-15 05:00:00	SPY	ETF	200.61	200.61	200.4	200.57	6086.0
2015-10-15 05:30:00	SPY	ETF	200.53	200.69	200.43	200.61	34588.0
2015-10-15 06:00:00	SPY	ETF	200.51	200.54	200.43	200.47	130141.0
2015-10-15 06:30:00	SPY	ETF	200.45	200.6	200.37	200.49	60940.0
2015-10-15 07:00:00	SPY	ETF	200.44	200.54	200.25	200.45	90706.0
2015-10-15 07:30:00	SPY	ETF	200.44	200.55	200.17	200.29	246321.0
2015-10-15 08:00:00	SPY	ETF	200.29	200.6	199.94	200.56	317196.0
2015-10-15 08:30:00	SPY	ETF	200.56	200.56	199.91	200.24	1067898.0
2015-10-15 09:00:00	SPY	ETF	200.23	200.23	199.29	200.08	964915.0
2015-10-15 09:30:00	SPY	ETF	200.08	200.44	199.81	200.1498	11882871.0
2015-10-15 10:00:00	SPY	ETF	200.14	200.42	199.86	200.11	6289779.0
2015-10-15 10:30:00	SPY	ETF	200.11	200.7327	199.93	200.58	7738110.0
2015-10-15 11:00:00	SPY	ETF	200.58	200.68	200.19	200.46	4993748.0
2015-10-15 11:30:00	SPY	ETF	200.47	200.52	199.64	199.82	6360603.0
2015-10-15 12:00:00	SPY	ETF	199.82	200.459	199.76	200.44	7274511.0
2015-10-15 12:30:00	SPY	ETF	200.44	200.61	200.3018	200.58	5063026.0
2015-10-15 13:00:00	SPY	ETF	200.58	201.27	200.56	201.14	7550649.0
2015-10-15 13:30:00	SPY	ETF	201.15	201.391	201.0	201.24	6398197.0
2015-10-15 14:00:00	SPY	ETF	201.24	201.59	201.23	201.455	7684532.0
2015-10-15 14:30:00	SPY	ETF	201.46	201.97	201.43	201.84	8457063.0
2015-10-15 15:00:00	SPY	ETF	201.85	202.34	201.8	202.23	11717287.0
2015-10-15 15:30:00	SPY	ETF	202.22	202.33	201.98	202.33	21763507.0
2015-10-15 16:00:00	SPY	ETF	202.33	202.6	201.46	202.53	9278448.0
2015-10-15 16:30:00	SPY	ETF	202.53	202.57	202.47	202.52	3707217.0
2015-10-15 17:00:00	SPY	ETF	202.52	202.52	202.38	202.51	126789.0
2015-10-15 17:30:00	SPY	ETF	202.5	202.55	202.48	202.48	28635.0
2015-10-15 18:00:00	SPY	ETF	202.46	202.52	202.37	202.52	37039.0
2015-10-15 18:30:00	SPY	ETF	202.48	202.93	202.47	202.79	152269.0
2015-10-15 19:00:00	SPY	ETF	202.75	202.75	202.66	202.68	24750.0
2015-10-15 19:30:00	SPY	ETF	202.7	202.86	202.69	202.86	70009.0
2015-10-15 04:00:00	QQQ	ETF	106.45	106.45	106.4	106.43	3500.0
2015-10-15 04:30:00	QQQ	ETF	106.58	106.58	106.48	106.48	6488.0
2015-10-15 05:00:00	QQQ	ETF	106.6	106.61	106.55	106.55	1350.0
2015-10-15 05:30:00	QQQ	ETF	106.56	106.63	106.51	106.63	28300.0
2015-10-15 06:00:00	QQQ	ETF	106.6	106.6	106.56	106.56	800.0
2015-10-15 06:30:00	QQQ	ETF	106.46	106.55	106.46	106.46	3700.0
2015-10-15 07:00:00	QQQ	ETF	106.51	106.52	106.4	106.52	14762.0
2015-10-15 07:30:00	QQQ	ETF	106.53	106.55	106.44	106.47	21392.0
2015-10-15 08:00:00	QQQ	ETF	106.52	106.57	106.43	106.57	23137.0
2015-10-15 08:30:00	QQQ	ETF	106.55	106.55	106.23	106.39	87824.0
2015-10-15 09:00:00	QQQ	ETF	106.36	106.4	106.27	106.33	257517.0
2015-10-15 09:30:00	QQQ	ETF	106.32	106.88	106.22	106.71	4420461.0
2015-10-15 10:00:00	QQQ	ETF	106.71	106.82	106.45	106.56	2296899.0
2015-10-15 10:30:00	QQQ	ETF	106.56	106.94	106.44	106.825	2448687.0
2015-10-15 11:00:00	QQQ	ETF	106.82	106.93	106.59	106.7599	2224743.0
2015-10-15 11:30:00	QQQ	ETF	106.76	106.78	106.18	106.28	1867135.0
2015-10-15 12:00:00	QQQ	ETF	106.28	106.65	106.25	106.64	1435186.0
2015-10-15 12:30:00	QQQ	ETF	106.64	106.79	106.58	106.71	995801.0

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

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