PREVIEW / etf_30min / 2015-09-16

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-16.parquet
  size:    375 KB
  rows:    12,671

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-09-16 04:00:00	SPY	ETF	198.55	198.68	198.36	198.5	9497.0
2015-09-16 04:30:00	SPY	ETF	198.45	198.6	198.3	198.4	20010.0
2015-09-16 05:00:00	SPY	ETF	198.43	198.68	198.36	198.46	16266.0
2015-09-16 05:30:00	SPY	ETF	198.43	198.55	198.3	198.3	10269.0
2015-09-16 06:00:00	SPY	ETF	198.28	198.42	198.2	198.34	50509.0
2015-09-16 06:30:00	SPY	ETF	198.23	198.59	198.2	198.59	26600.0
2015-09-16 07:00:00	SPY	ETF	198.6	198.79	198.51	198.69	326681.0
2015-09-16 07:30:00	SPY	ETF	198.66	198.75	198.53	198.75	86565.0
2015-09-16 08:00:00	SPY	ETF	198.7	198.73	198.06	198.53	233797.0
2015-09-16 08:30:00	SPY	ETF	198.59	198.72	198.36	198.47	433090.0
2015-09-16 09:00:00	SPY	ETF	198.48	198.84	198.46	198.83	558739.0
2015-09-16 09:30:00	SPY	ETF	198.82	199.12	198.48	198.68	10024600.0
2015-09-16 10:00:00	SPY	ETF	198.69	199.06	198.41	198.89	5654778.0
2015-09-16 10:30:00	SPY	ETF	198.885	199.02	198.58	198.81	4294225.0
2015-09-16 11:00:00	SPY	ETF	198.81	199.75	198.72	199.69	9180274.0
2015-09-16 11:30:00	SPY	ETF	199.69	199.735	199.41	199.66	5319319.0
2015-09-16 12:00:00	SPY	ETF	199.67	199.9	199.51	199.879	4709236.0
2015-09-16 12:30:00	SPY	ETF	199.87	200.09	199.75	200.0402	4872946.0
2015-09-16 13:00:00	SPY	ETF	200.03	200.035	199.56	199.61	3841769.0
2015-09-16 13:30:00	SPY	ETF	199.61	199.86	199.55	199.84	3754472.0
2015-09-16 14:00:00	SPY	ETF	199.85	199.855	199.22	199.3701	5305151.0
2015-09-16 14:30:00	SPY	ETF	199.375	200.06	199.26	199.97	5769541.0
2015-09-16 15:00:00	SPY	ETF	199.97	200.29	199.84	200.24	8348292.0
2015-09-16 15:30:00	SPY	ETF	200.25	200.41	200.09	200.19	16682758.0
2015-09-16 16:00:00	SPY	ETF	200.21	200.63	198.4773	200.43	6410670.0
2015-09-16 16:30:00	SPY	ETF	200.44	200.49	200.4	200.45	2134480.0
2015-09-16 17:00:00	SPY	ETF	200.47	200.53	200.197	200.46	166162.0
2015-09-16 17:30:00	SPY	ETF	200.47	200.52	200.38	200.38	76196.0
2015-09-16 18:00:00	SPY	ETF	200.42	200.43	200.3	200.3	177695.0
2015-09-16 18:30:00	SPY	ETF	200.32	200.38	200.28	200.37	29812.0
2015-09-16 19:00:00	SPY	ETF	200.38	200.4	200.36	200.36	12109.0
2015-09-16 19:30:00	SPY	ETF	200.35	200.35	200.24	200.25	85516.0
2015-09-16 04:00:00	QQQ	ETF	106.51	106.51	106.51	106.51	200.0
2015-09-16 04:30:00	QQQ	ETF	106.47	106.49	106.39	106.42	13800.0
2015-09-16 05:00:00	QQQ	ETF	106.46	106.48	106.46	106.48	1500.0
2015-09-16 05:30:00	QQQ	ETF	106.46	106.46	106.39	106.39	4000.0
2015-09-16 06:00:00	QQQ	ETF	106.39	106.44	106.36	106.36	3100.0
2015-09-16 06:30:00	QQQ	ETF	106.39	106.54	106.39	106.54	6000.0
2015-09-16 07:00:00	QQQ	ETF	106.56	106.63	106.53	106.6	27234.0
2015-09-16 07:30:00	QQQ	ETF	106.54	106.61	106.52	106.61	9697.0
2015-09-16 08:00:00	QQQ	ETF	106.64	106.64	106.44	106.52	31152.0
2015-09-16 08:30:00	QQQ	ETF	106.51	106.56	106.4	106.44	117272.0
2015-09-16 09:00:00	QQQ	ETF	106.45	106.56	106.44	106.52	92018.0
2015-09-16 09:30:00	QQQ	ETF	106.51	106.71	106.15	106.27	3350509.0
2015-09-16 10:00:00	QQQ	ETF	106.28	106.55	106.14	106.41	1645631.0
2015-09-16 10:30:00	QQQ	ETF	106.41	106.52	106.24	106.34	1297415.0
2015-09-16 11:00:00	QQQ	ETF	106.35	106.86	106.27	106.81	2226857.0
2015-09-16 11:30:00	QQQ	ETF	106.83	106.84	106.59	106.77	1109216.0
2015-09-16 12:00:00	QQQ	ETF	106.779	106.9079	106.67	106.9019	1371091.0
2015-09-16 12:30:00	QQQ	ETF	106.915	107.03	106.81	106.96	1234761.0

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

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