PREVIEW / etf_30min / 2014-06-06

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-06.parquet
  size:    328 KB
  rows:    11,370

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
2014-06-06 04:00:00	SPY	ETF	194.46	194.5	194.46	194.5	4201.0
2014-06-06 04:30:00	SPY	ETF	194.61	194.61	194.61	194.61	100.0
2014-06-06 05:00:00	SPY	ETF	194.59	194.64	194.58	194.64	520.0
2014-06-06 05:30:00	SPY	ETF	194.51	194.72	194.51	194.65	4400.0
2014-06-06 06:00:00	SPY	ETF	194.68	194.71	194.62	194.7	16705.0
2014-06-06 06:30:00	SPY	ETF	194.65	194.7	194.65	194.65	58020.0
2014-06-06 07:00:00	SPY	ETF	194.66	194.66	194.61	194.64	10785.0
2014-06-06 07:30:00	SPY	ETF	194.63	194.65	194.5	194.55	223932.0
2014-06-06 08:00:00	SPY	ETF	194.56	194.63	194.45	194.51	499543.0
2014-06-06 08:30:00	SPY	ETF	194.51	194.96	194.49	194.88	1928383.0
2014-06-06 09:00:00	SPY	ETF	194.87	194.9	194.75	194.84	465265.0
2014-06-06 09:30:00	SPY	ETF	194.87	195.19	194.78	195.18	9399560.0
2014-06-06 10:00:00	SPY	ETF	195.19	195.28	195.04	195.2001	6417435.0
2014-06-06 10:30:00	SPY	ETF	195.21	195.29	195.14	195.26	4002150.0
2014-06-06 11:00:00	SPY	ETF	195.26	195.4	195.195	195.23	4753005.0
2014-06-06 11:30:00	SPY	ETF	195.22	195.33	195.18	195.22	2712186.0
2014-06-06 12:00:00	SPY	ETF	195.23	195.3	195.21	195.26	2003559.0
2014-06-06 12:30:00	SPY	ETF	195.26	195.43	195.251	195.34	3173446.0
2014-06-06 13:00:00	SPY	ETF	195.34	195.39	195.23	195.35	2022010.0
2014-06-06 13:30:00	SPY	ETF	195.35	195.4	195.27	195.33	2096619.0
2014-06-06 14:00:00	SPY	ETF	195.33	195.39	195.28	195.36	2141517.0
2014-06-06 14:30:00	SPY	ETF	195.35	195.36	195.22	195.24	3196729.0
2014-06-06 15:00:00	SPY	ETF	195.24	195.37	195.2	195.34	5323416.0
2014-06-06 15:30:00	SPY	ETF	195.335	195.38	195.09	195.38	13147459.0
2014-06-06 16:00:00	SPY	ETF	195.37	195.55	195.35	195.54	11448920.0
2014-06-06 16:30:00	SPY	ETF	195.52	195.55	195.417	195.52	2806803.0
2014-06-06 17:00:00	SPY	ETF	195.52	195.57	195.52	195.52	107160.0
2014-06-06 17:30:00	SPY	ETF	195.52	195.58	195.52	195.57	21069.0
2014-06-06 18:00:00	SPY	ETF	195.55	195.61	195.55	195.57	9029.0
2014-06-06 18:30:00	SPY	ETF	195.58	195.61	195.56	195.56	4824.0
2014-06-06 19:00:00	SPY	ETF	195.59	195.61	195.58	195.59	3013.0
2014-06-06 19:30:00	SPY	ETF	195.61	195.63	195.56	195.59	18276.0
2014-06-06 04:00:00	QQQ	ETF	92.43	92.43	92.43	92.43	100.0
2014-06-06 06:00:00	QQQ	ETF	92.45	92.45	92.45	92.45	500.0
2014-06-06 06:30:00	QQQ	ETF	92.47	92.47	92.47	92.47	100.0
2014-06-06 07:00:00	QQQ	ETF	92.45	92.45	92.45	92.45	1000.0
2014-06-06 07:30:00	QQQ	ETF	92.42	92.43	92.4	92.41	6500.0
2014-06-06 08:00:00	QQQ	ETF	92.39	92.4	92.33	92.38	57925.0
2014-06-06 08:30:00	QQQ	ETF	92.42	92.65	92.38	92.64	399112.0
2014-06-06 09:00:00	QQQ	ETF	92.64	92.67	92.58	92.65	154343.0
2014-06-06 09:30:00	QQQ	ETF	92.65	92.7	92.45	92.67	4078798.0
2014-06-06 10:00:00	QQQ	ETF	92.67	92.685	92.45	92.61	2499777.0
2014-06-06 10:30:00	QQQ	ETF	92.61	92.65	92.53	92.6499	910510.0
2014-06-06 11:00:00	QQQ	ETF	92.65	92.7601	92.63	92.7075	1415280.0
2014-06-06 11:30:00	QQQ	ETF	92.71	92.74	92.62	92.64	1021337.0
2014-06-06 12:00:00	QQQ	ETF	92.64	92.68	92.61	92.63	420988.0
2014-06-06 12:30:00	QQQ	ETF	92.63	92.74	92.6235	92.68	691127.0
2014-06-06 13:00:00	QQQ	ETF	92.69	92.7	92.5301	92.63	1084730.0
2014-06-06 13:30:00	QQQ	ETF	92.635	92.67	92.58	92.62	495481.0
2014-06-06 14:00:00	QQQ	ETF	92.62	92.72	92.59	92.7	986704.0

> showing 50 of 11,370 rows — these rows as CSV

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