PREVIEW / etf_30min / 2012-10-11

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-11.parquet
  size:    283 KB
  rows:    9,532

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
2012-10-11 04:00:00	SPY	ETF	143.3	143.57	143.3	143.57	1418.0
2012-10-11 04:30:00	SPY	ETF	143.7	143.72	143.6	143.62	1844.0
2012-10-11 05:00:00	SPY	ETF	143.6	143.7	143.6	143.7	22699.0
2012-10-11 05:30:00	SPY	ETF	143.67	143.7	143.66	143.7	11300.0
2012-10-11 06:00:00	SPY	ETF	143.7	143.8	143.65	143.8	55350.0
2012-10-11 06:30:00	SPY	ETF	143.75	143.83	143.75	143.8	55633.0
2012-10-11 07:00:00	SPY	ETF	143.78	143.83	143.7	143.77	176459.0
2012-10-11 07:30:00	SPY	ETF	143.72	143.76	143.6	143.6	158889.0
2012-10-11 08:00:00	SPY	ETF	143.61	143.95	143.42	143.88	628710.0
2012-10-11 08:30:00	SPY	ETF	143.89	144.11	143.76	143.95	1982195.0
2012-10-11 09:00:00	SPY	ETF	143.94	144.28	143.28	144.27	1987628.0
2012-10-11 09:30:00	SPY	ETF	144.28	144.33	144.04	144.07	15695536.0
2012-10-11 10:00:00	SPY	ETF	144.08	144.32	143.99	144.22	8252031.0
2012-10-11 10:30:00	SPY	ETF	144.21	144.49	144.18	144.39	7082752.0
2012-10-11 11:00:00	SPY	ETF	144.39	144.48	144.03	144.15	10216985.0
2012-10-11 11:30:00	SPY	ETF	144.16	144.16	143.76	143.9	7661235.0
2012-10-11 12:00:00	SPY	ETF	143.9	144.03	143.79	143.87	4487707.0
2012-10-11 12:30:00	SPY	ETF	143.87	144.06	143.79	143.935	4435530.0
2012-10-11 13:00:00	SPY	ETF	143.935	144.04	143.73	143.803	5031682.0
2012-10-11 13:30:00	SPY	ETF	143.805	143.82	143.41	143.52	7233885.0
2012-10-11 14:00:00	SPY	ETF	143.52	143.7501	143.49	143.7	6917287.0
2012-10-11 14:30:00	SPY	ETF	143.7	143.73	143.44	143.53	6269178.0
2012-10-11 15:00:00	SPY	ETF	143.53	143.76	143.45	143.732	6073271.0
2012-10-11 15:30:00	SPY	ETF	143.737	143.74	143.36	143.4	15407341.0
2012-10-11 16:00:00	SPY	ETF	143.39	144.3262	143.29	143.36	9637767.0
2012-10-11 16:30:00	SPY	ETF	143.37	143.58	143.37	143.56	1105618.0
2012-10-11 17:00:00	SPY	ETF	143.563	143.65	143.3508	143.63	731492.0
2012-10-11 17:30:00	SPY	ETF	143.63	143.64	143.62	143.63	25728.0
2012-10-11 18:00:00	SPY	ETF	143.63	143.64	143.59	143.6	16905.0
2012-10-11 18:30:00	SPY	ETF	143.61	143.61	143.56	143.56	4621.0
2012-10-11 19:00:00	SPY	ETF	143.59	143.63	143.59	143.62	8300.0
2012-10-11 19:30:00	SPY	ETF	143.61	143.64	143.54	143.64	31810.0
2012-10-11 04:00:00	QQQ	ETF	67.01	67.12	67.01	67.12	933.0
2012-10-11 05:30:00	QQQ	ETF	67.26	67.26	67.26	67.26	700.0
2012-10-11 06:30:00	QQQ	ETF	67.29	67.29	67.29	67.29	5000.0
2012-10-11 07:00:00	QQQ	ETF	67.24	67.29	67.23	67.26	48823.0
2012-10-11 07:30:00	QQQ	ETF	67.22	67.25	67.18	67.18	22261.0
2012-10-11 08:00:00	QQQ	ETF	67.19	67.32	67.18	67.3	135795.0
2012-10-11 08:30:00	QQQ	ETF	67.3	67.49	67.28	67.34	132123.0
2012-10-11 09:00:00	QQQ	ETF	67.36	67.48	67.35	67.44	263119.0
2012-10-11 09:30:00	QQQ	ETF	67.44	67.46	67.25	67.33	2881768.0
2012-10-11 10:00:00	QQQ	ETF	67.33	67.43	67.29	67.35	1765688.0
2012-10-11 10:30:00	QQQ	ETF	67.35	67.47	67.31	67.34	2297817.0
2012-10-11 11:00:00	QQQ	ETF	67.34	67.36	67.065	67.19	2761269.0
2012-10-11 11:30:00	QQQ	ETF	67.18	67.18	66.87	66.98	3073869.0
2012-10-11 12:00:00	QQQ	ETF	66.97	67.1083	66.9	66.97	1055610.0
2012-10-11 12:30:00	QQQ	ETF	66.97	67.02	66.8808	66.96	914614.0
2012-10-11 13:00:00	QQQ	ETF	66.96	67.03	66.85	66.865	1164994.0
2012-10-11 13:30:00	QQQ	ETF	66.8684	66.8699	66.67	66.71	2187411.0
2012-10-11 14:00:00	QQQ	ETF	66.71	66.87	66.71	66.84	2094308.0

> showing 50 of 9,532 rows — these rows as CSV

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