PREVIEW / etf_30min / 2015-05-21

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-21.parquet
  size:    362 KB
  rows:    12,380

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-05-21 04:00:00	SPY	ETF	212.37	212.5	212.31	212.31	4855.0
2015-05-21 04:30:00	SPY	ETF	212.43	212.43	212.32	212.32	2300.0
2015-05-21 05:00:00	SPY	ETF	212.35	212.35	212.28	212.28	1400.0
2015-05-21 05:30:00	SPY	ETF	212.4	212.43	212.36	212.36	2602.0
2015-05-21 06:00:00	SPY	ETF	212.37	212.4	212.31	212.38	2249.0
2015-05-21 06:30:00	SPY	ETF	212.4	212.43	212.37	212.37	25344.0
2015-05-21 07:00:00	SPY	ETF	212.39	212.63	212.38	212.61	81248.0
2015-05-21 07:30:00	SPY	ETF	212.57	212.65	212.54	212.57	138001.0
2015-05-21 08:00:00	SPY	ETF	212.63	212.63	212.44	212.47	206668.0
2015-05-21 08:30:00	SPY	ETF	212.47	212.59	212.42	212.55	174514.0
2015-05-21 09:00:00	SPY	ETF	212.56	212.77	212.51	212.71	400194.0
2015-05-21 09:30:00	SPY	ETF	212.71	212.96	212.51	212.84	6999257.0
2015-05-21 10:00:00	SPY	ETF	212.84	213.29	212.74	213.19	5253223.0
2015-05-21 10:30:00	SPY	ETF	213.19	213.37	213.15	213.235	3143771.0
2015-05-21 11:00:00	SPY	ETF	213.235	213.55	213.235	213.55	4096456.0
2015-05-21 11:30:00	SPY	ETF	213.55	213.6	213.34	213.495	4025368.0
2015-05-21 12:00:00	SPY	ETF	213.49	213.57	213.39	213.54	1866995.0
2015-05-21 12:30:00	SPY	ETF	213.53	213.64	213.39	213.465	2775068.0
2015-05-21 13:00:00	SPY	ETF	213.469	213.55	213.36	213.41	1971425.0
2015-05-21 13:30:00	SPY	ETF	213.405	213.49	213.15	213.19	3280729.0
2015-05-21 14:00:00	SPY	ETF	213.2	213.49	213.15	213.474	2879540.0
2015-05-21 14:30:00	SPY	ETF	213.48	213.58	213.41	213.48	2695715.0
2015-05-21 15:00:00	SPY	ETF	213.48	213.55	213.21	213.39	5210945.0
2015-05-21 15:30:00	SPY	ETF	213.385	213.75	213.32	213.47	14297667.0
2015-05-21 16:00:00	SPY	ETF	213.5	213.51	213.31	213.39	3975911.0
2015-05-21 16:30:00	SPY	ETF	213.4	213.44	213.39	213.41	294342.0
2015-05-21 17:00:00	SPY	ETF	213.41	213.44	213.4	213.43	24567.0
2015-05-21 17:30:00	SPY	ETF	213.43	213.46	213.41	213.44	56485.0
2015-05-21 18:00:00	SPY	ETF	213.45	213.5	213.34	213.42	121061.0
2015-05-21 18:30:00	SPY	ETF	213.44	213.44	213.4	213.4	9610.0
2015-05-21 19:00:00	SPY	ETF	213.41	213.45	213.4	213.44	7180.0
2015-05-21 19:30:00	SPY	ETF	213.42	213.42	213.29	213.35	55553.0
2015-05-21 04:00:00	QQQ	ETF	109.58	109.6	109.58	109.6	450.0
2015-05-21 04:30:00	QQQ	ETF	109.7	109.7	109.7	109.7	1000.0
2015-05-21 06:00:00	QQQ	ETF	109.63	109.65	109.63	109.65	10000.0
2015-05-21 06:30:00	QQQ	ETF	109.65	109.65	109.62	109.62	2250.0
2015-05-21 07:00:00	QQQ	ETF	109.65	109.76	109.64	109.73	11351.0
2015-05-21 07:30:00	QQQ	ETF	109.72	109.76	109.72	109.74	8500.0
2015-05-21 08:00:00	QQQ	ETF	109.77	109.77	109.65	109.74	56908.0
2015-05-21 08:30:00	QQQ	ETF	109.74	109.77	109.67	109.72	60135.0
2015-05-21 09:00:00	QQQ	ETF	109.72	109.85	109.71	109.83	97395.0
2015-05-21 09:30:00	QQQ	ETF	109.82	109.99	109.66	109.95	1880264.0
2015-05-21 10:00:00	QQQ	ETF	109.9404	110.33	109.87	110.27	1571055.0
2015-05-21 10:30:00	QQQ	ETF	110.28	110.46	110.255	110.4	789946.0
2015-05-21 11:00:00	QQQ	ETF	110.41	110.63	110.41	110.609	1530891.0
2015-05-21 11:30:00	QQQ	ETF	110.61	110.64	110.45	110.53	817769.0
2015-05-21 12:00:00	QQQ	ETF	110.535	110.64	110.4951	110.61	611891.0
2015-05-21 12:30:00	QQQ	ETF	110.62	110.68	110.55	110.57	1123168.0
2015-05-21 13:00:00	QQQ	ETF	110.57	110.62	110.52	110.55	493087.0
2015-05-21 13:30:00	QQQ	ETF	110.55	110.604	110.34	110.39	1672980.0

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

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