PREVIEW / etf_30min / 2016-05-12

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-12.parquet
  size:    389 KB
  rows:    13,173

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
2016-05-12 04:00:00	SPY	ETF	206.87	206.96	206.77	206.96	6993.0
2016-05-12 04:30:00	SPY	ETF	206.97	207.13	206.97	207.13	2753.0
2016-05-12 05:00:00	SPY	ETF	207.21	207.3	207.07	207.13	8611.0
2016-05-12 05:30:00	SPY	ETF	207.05	207.63	207.05	207.55	23068.0
2016-05-12 06:00:00	SPY	ETF	207.56	207.58	207.28	207.38	98448.0
2016-05-12 06:30:00	SPY	ETF	207.36	207.55	207.31	207.5	86148.0
2016-05-12 07:00:00	SPY	ETF	207.5	207.53	207.34	207.52	123221.0
2016-05-12 07:30:00	SPY	ETF	207.5	207.75	207.47	207.7	190748.0
2016-05-12 08:00:00	SPY	ETF	207.7	207.73	206.7	207.69	455831.0
2016-05-12 08:30:00	SPY	ETF	207.63	207.64	207.34	207.42	714033.0
2016-05-12 09:00:00	SPY	ETF	207.42	207.42	207.24	207.3	438890.0
2016-05-12 09:30:00	SPY	ETF	207.29	207.4899	206.62	206.63	9667424.0
2016-05-12 10:00:00	SPY	ETF	206.63	206.98	206.41	206.6	6964057.0
2016-05-12 10:30:00	SPY	ETF	206.6	206.7	206.16	206.35	6292425.0
2016-05-12 11:00:00	SPY	ETF	206.34	206.39	205.6	205.82	7585625.0
2016-05-12 11:30:00	SPY	ETF	205.82	205.98	205.5	205.53	4398419.0
2016-05-12 12:00:00	SPY	ETF	205.53	205.79	205.37	205.75	5208931.0
2016-05-12 12:30:00	SPY	ETF	205.74	206.1	205.45	206.095	4177064.0
2016-05-12 13:00:00	SPY	ETF	206.1	206.18	205.86	206.03	3140414.0
2016-05-12 13:30:00	SPY	ETF	206.04	206.34	205.66	206.3	4226611.0
2016-05-12 14:00:00	SPY	ETF	206.3	206.92	206.29	206.84	7577462.0
2016-05-12 14:30:00	SPY	ETF	206.83	207.18	206.64	206.955	4678201.0
2016-05-12 15:00:00	SPY	ETF	206.96	207.05	206.75	206.83	5494038.0
2016-05-12 15:30:00	SPY	ETF	206.83	206.86	206.28	206.56	10824977.0
2016-05-12 16:00:00	SPY	ETF	206.57	206.59	205.5159	206.43	4388875.0
2016-05-12 16:30:00	SPY	ETF	206.44	206.54	206.42	206.51	384603.0
2016-05-12 17:00:00	SPY	ETF	206.51	206.53	206.47	206.49	74199.0
2016-05-12 17:30:00	SPY	ETF	206.51	206.54	206.48	206.51	62604.0
2016-05-12 18:00:00	SPY	ETF	206.48	206.48	206.36	206.4	42348.0
2016-05-12 18:30:00	SPY	ETF	206.4	206.42	206.39	206.42	29278.0
2016-05-12 19:00:00	SPY	ETF	206.42	206.49	206.41	206.46	44762.0
2016-05-12 19:30:00	SPY	ETF	206.47	206.55	206.44	206.55	104794.0
2016-05-12 04:00:00	QQQ	ETF	106.46	106.61	106.46	106.56	896.0
2016-05-12 04:30:00	QQQ	ETF	106.62	106.75	106.62	106.75	500.0
2016-05-12 05:00:00	QQQ	ETF	106.73	106.73	106.73	106.73	998.0
2016-05-12 05:30:00	QQQ	ETF	106.9	106.91	106.9	106.91	400.0
2016-05-12 07:00:00	QQQ	ETF	106.89	106.89	106.81	106.86	14718.0
2016-05-12 07:30:00	QQQ	ETF	106.85	106.92	106.85	106.92	13160.0
2016-05-12 08:00:00	QQQ	ETF	106.85	106.9	106.84	106.86	23368.0
2016-05-12 08:30:00	QQQ	ETF	106.83	106.83	106.71	106.72	61131.0
2016-05-12 09:00:00	QQQ	ETF	106.69	106.74	106.65	106.69	86825.0
2016-05-12 09:30:00	QQQ	ETF	106.68	106.735	106.03	106.035	3780191.0
2016-05-12 10:00:00	QQQ	ETF	106.04	106.25	105.96	105.99	2979520.0
2016-05-12 10:30:00	QQQ	ETF	105.98	106.05	105.65	105.72	1905378.0
2016-05-12 11:00:00	QQQ	ETF	105.71	105.76	105.17	105.41	2725950.0
2016-05-12 11:30:00	QQQ	ETF	105.417	105.52	105.25	105.26	971648.0
2016-05-12 12:00:00	QQQ	ETF	105.2525	105.44	105.14	105.4099	1467764.0
2016-05-12 12:30:00	QQQ	ETF	105.4	105.58	105.21	105.5793	1152709.0
2016-05-12 13:00:00	QQQ	ETF	105.58	105.62	105.41	105.55	934256.0
2016-05-12 13:30:00	QQQ	ETF	105.54	105.77	105.2907	105.75	1279005.0

> showing 50 of 13,173 rows — these rows as CSV

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