PREVIEW / etf_30min / 2015-03-11

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-11.parquet
  size:    375 KB
  rows:    12,646

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-03-11 04:00:00	SPY	ETF	205.35	205.52	204.99	205.52	78433.0
2015-03-11 04:30:00	SPY	ETF	205.52	205.56	205.48	205.51	1300.0
2015-03-11 05:00:00	SPY	ETF	205.5	205.64	205.42	205.45	18017.0
2015-03-11 05:30:00	SPY	ETF	205.47	205.67	205.45	205.65	20178.0
2015-03-11 06:00:00	SPY	ETF	205.64	205.74	205.6	205.63	28658.0
2015-03-11 06:30:00	SPY	ETF	205.66	205.71	205.55	205.65	99583.0
2015-03-11 07:00:00	SPY	ETF	205.65	205.7	205.4	205.48	116632.0
2015-03-11 07:30:00	SPY	ETF	205.5	205.53	205.25	205.35	275202.0
2015-03-11 08:00:00	SPY	ETF	205.37	205.67	205.25	205.48	354974.0
2015-03-11 08:30:00	SPY	ETF	205.48	205.66	205.4	205.46	608381.0
2015-03-11 09:00:00	SPY	ETF	205.47	205.47	205.2	205.28	939401.0
2015-03-11 09:30:00	SPY	ETF	205.29	205.46	205.01	205.27	11139558.0
2015-03-11 10:00:00	SPY	ETF	205.26	205.5	205.01	205.239	8144234.0
2015-03-11 10:30:00	SPY	ETF	205.235	205.28	204.51	204.8	10251357.0
2015-03-11 11:00:00	SPY	ETF	204.79	205.25	204.72	205.225	7724019.0
2015-03-11 11:30:00	SPY	ETF	205.22	205.335	205.04	205.1799	4558257.0
2015-03-11 12:00:00	SPY	ETF	205.18	205.32	204.89	205.03	4316795.0
2015-03-11 12:30:00	SPY	ETF	205.03	205.37	204.93	205.2061	4541594.0
2015-03-11 13:00:00	SPY	ETF	205.2	205.345	205.09	205.19	3447144.0
2015-03-11 13:30:00	SPY	ETF	205.2	205.21	204.52	204.8	7962345.0
2015-03-11 14:00:00	SPY	ETF	204.805	205.21	204.74	205.06	6290732.0
2015-03-11 14:30:00	SPY	ETF	205.07	205.25	204.86	205.191	4535386.0
2015-03-11 15:00:00	SPY	ETF	205.19	205.2	204.58	204.6	7175796.0
2015-03-11 15:30:00	SPY	ETF	204.6	204.72	204.4	204.51	16046471.0
2015-03-11 16:00:00	SPY	ETF	204.5	204.93	204.38	204.6	4303023.0
2015-03-11 16:30:00	SPY	ETF	204.59	204.83	204.5	204.75	739912.0
2015-03-11 17:00:00	SPY	ETF	204.75	204.84	204.7	204.7	192328.0
2015-03-11 17:30:00	SPY	ETF	204.71	204.71	204.66	204.7	15363.0
2015-03-11 18:00:00	SPY	ETF	204.72	204.76	204.44	204.52	193878.0
2015-03-11 18:30:00	SPY	ETF	204.52	204.6	204.52	204.6	14526.0
2015-03-11 19:00:00	SPY	ETF	204.6	204.61	204.5	204.57	853158.0
2015-03-11 19:30:00	SPY	ETF	204.55	204.59	204.5	204.56	16427.0
2015-03-11 04:00:00	QQQ	ETF	105.85	105.85	105.82	105.82	6930.0
2015-03-11 05:00:00	QQQ	ETF	106.03	106.07	105.97	105.97	22200.0
2015-03-11 05:30:00	QQQ	ETF	106.0	106.05	106.0	106.05	36800.0
2015-03-11 06:00:00	QQQ	ETF	106.06	106.1	106.06	106.08	6800.0
2015-03-11 06:30:00	QQQ	ETF	106.08	106.08	106.04	106.08	11400.0
2015-03-11 07:00:00	QQQ	ETF	106.08	106.08	105.98	105.98	18348.0
2015-03-11 07:30:00	QQQ	ETF	106.02	106.02	105.9	105.96	61133.0
2015-03-11 08:00:00	QQQ	ETF	106.09	106.09	105.92	105.99	46950.0
2015-03-11 08:30:00	QQQ	ETF	106.01	106.05	105.96	105.96	44006.0
2015-03-11 09:00:00	QQQ	ETF	105.96	105.96	105.86	105.86	48550.0
2015-03-11 09:30:00	QQQ	ETF	105.875	105.9	105.52	105.85	3346546.0
2015-03-11 10:00:00	QQQ	ETF	105.84	106.01	105.62	105.749	2691935.0
2015-03-11 10:30:00	QQQ	ETF	105.74	105.82	105.35	105.48	2023231.0
2015-03-11 11:00:00	QQQ	ETF	105.481	105.77	105.46	105.76	1779418.0
2015-03-11 11:30:00	QQQ	ETF	105.76	105.86	105.66	105.76	1048574.0
2015-03-11 12:00:00	QQQ	ETF	105.77	105.82	105.52	105.605	1049103.0
2015-03-11 12:30:00	QQQ	ETF	105.61	105.77	105.55	105.6346	660056.0
2015-03-11 13:00:00	QQQ	ETF	105.635	105.67	105.5	105.6	743207.0

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

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