PREVIEW / etf_30min / 2016-04-05

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-05.parquet
  size:    390 KB
  rows:    13,347

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-04-05 04:00:00	SPY	ETF	205.25	205.4	204.58	204.58	43407.0
2016-04-05 04:30:00	SPY	ETF	204.62	204.76	204.4	204.73	45060.0
2016-04-05 05:00:00	SPY	ETF	204.8	204.8	204.55	204.7	51835.0
2016-04-05 05:30:00	SPY	ETF	204.62	204.65	204.21	204.39	107621.0
2016-04-05 06:00:00	SPY	ETF	204.38	204.51	204.33	204.4	23511.0
2016-04-05 06:30:00	SPY	ETF	204.45	204.69	204.31	204.67	49526.0
2016-04-05 07:00:00	SPY	ETF	204.69	204.9	204.6	204.89	196152.0
2016-04-05 07:30:00	SPY	ETF	204.89	204.89	204.49	204.6	360102.0
2016-04-05 08:00:00	SPY	ETF	204.6	204.84	204.48	204.72	627813.0
2016-04-05 08:30:00	SPY	ETF	204.7	204.7	204.4	204.6	529565.0
2016-04-05 09:00:00	SPY	ETF	204.58	204.75	204.42	204.68	511345.0
2016-04-05 09:30:00	SPY	ETF	204.67	205.0	204.16	204.6	14096222.0
2016-04-05 10:00:00	SPY	ETF	204.6	205.26	204.6	205.06	9156997.0
2016-04-05 10:30:00	SPY	ETF	205.06	205.06	204.38	204.45	4243817.0
2016-04-05 11:00:00	SPY	ETF	204.45	204.9201	204.39	204.78	3911777.0
2016-04-05 11:30:00	SPY	ETF	204.78	206.2642	204.41	204.58	4446764.0
2016-04-05 12:00:00	SPY	ETF	204.585	204.8	204.2	204.36	4102060.0
2016-04-05 12:30:00	SPY	ETF	204.355	204.57	204.22	204.3053	3962375.0
2016-04-05 13:00:00	SPY	ETF	204.31	204.59	204.11	204.57	3924660.0
2016-04-05 13:30:00	SPY	ETF	204.58	204.74	204.31	204.54	3664456.0
2016-04-05 14:00:00	SPY	ETF	204.54	204.82	204.451	204.7601	3378320.0
2016-04-05 14:30:00	SPY	ETF	204.76	205.04	204.76	204.92	3185700.0
2016-04-05 15:00:00	SPY	ETF	204.93	204.97	204.44	204.5	4561685.0
2016-04-05 15:30:00	SPY	ETF	204.5	204.64	203.89	204.19	20188423.0
2016-04-05 16:00:00	SPY	ETF	204.19	204.52	204.1637	204.35	4088382.0
2016-04-05 16:30:00	SPY	ETF	204.36	204.66	204.14	204.61	477509.0
2016-04-05 17:00:00	SPY	ETF	204.63	205.04	204.4	204.61	7178380.0
2016-04-05 17:30:00	SPY	ETF	204.6	204.67	204.57	204.63	840848.0
2016-04-05 18:00:00	SPY	ETF	204.64	204.73	204.58	204.61	91271.0
2016-04-05 18:30:00	SPY	ETF	204.67	204.7	204.63	204.63	35202.0
2016-04-05 19:00:00	SPY	ETF	204.63	204.76	204.63	204.76	14378.0
2016-04-05 19:30:00	SPY	ETF	204.75	204.78	204.68	204.76	63643.0
2016-04-05 04:00:00	QQQ	ETF	109.43	109.43	109.12	109.12	1720.0
2016-04-05 04:30:00	QQQ	ETF	109.0	109.12	109.0	109.11	1485.0
2016-04-05 05:00:00	QQQ	ETF	109.11	109.11	109.11	109.11	149.0
2016-04-05 05:30:00	QQQ	ETF	109.14	109.14	108.98	108.98	12300.0
2016-04-05 06:00:00	QQQ	ETF	109.05	109.1	109.04	109.1	562.0
2016-04-05 06:30:00	QQQ	ETF	109.11	109.21	109.11	109.15	883.0
2016-04-05 07:00:00	QQQ	ETF	109.17	109.25	109.14	109.24	14282.0
2016-04-05 07:30:00	QQQ	ETF	109.22	109.22	108.98	109.03	160804.0
2016-04-05 08:00:00	QQQ	ETF	109.05	109.25	109.0	109.1	41841.0
2016-04-05 08:30:00	QQQ	ETF	109.06	109.08	108.95	109.06	96072.0
2016-04-05 09:00:00	QQQ	ETF	109.06	109.13	108.95	109.09	80395.0
2016-04-05 09:30:00	QQQ	ETF	109.09	109.2101	108.77	109.01	2858339.0
2016-04-05 10:00:00	QQQ	ETF	109.01	109.5	109.006	109.485	2163692.0
2016-04-05 10:30:00	QQQ	ETF	109.48	109.49	109.11	109.15	1085863.0
2016-04-05 11:00:00	QQQ	ETF	109.1499	109.34	109.09	109.27	955830.0
2016-04-05 11:30:00	QQQ	ETF	109.28	109.3801	108.94	109.0	884026.0
2016-04-05 12:00:00	QQQ	ETF	109.0	109.14	108.76	108.81	862970.0
2016-04-05 12:30:00	QQQ	ETF	108.8	108.97	108.74	108.87	878746.0

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

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