PREVIEW / etf_30min / 2014-04-23

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-23.parquet
  size:    322 KB
  rows:    11,249

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-04-23 04:00:00	SPY	ETF	188.0	188.1	188.0	188.1	4100.0
2014-04-23 05:00:00	SPY	ETF	187.97	187.97	187.84	187.94	11401.0
2014-04-23 05:30:00	SPY	ETF	187.89	187.97	187.72	187.72	2853.0
2014-04-23 06:00:00	SPY	ETF	187.72	187.78	187.7	187.78	1850.0
2014-04-23 06:30:00	SPY	ETF	187.74	187.78	187.73	187.74	3079.0
2014-04-23 07:00:00	SPY	ETF	187.75	187.77	187.68	187.72	69012.0
2014-04-23 07:30:00	SPY	ETF	187.71	187.83	187.68	187.7	113297.0
2014-04-23 08:00:00	SPY	ETF	187.7	187.78	187.55	187.64	235943.0
2014-04-23 08:30:00	SPY	ETF	187.64	187.83	187.64	187.77	283806.0
2014-04-23 09:00:00	SPY	ETF	187.78	187.82	187.73	187.81	264744.0
2014-04-23 09:30:00	SPY	ETF	187.81	187.92	187.49	187.64	8380958.0
2014-04-23 10:00:00	SPY	ETF	187.6401	187.75	187.3	187.7	9414613.0
2014-04-23 10:30:00	SPY	ETF	187.69	187.9	187.57	187.73	5247114.0
2014-04-23 11:00:00	SPY	ETF	187.72	187.81	187.41	187.548	5013875.0
2014-04-23 11:30:00	SPY	ETF	187.55	187.82	187.515	187.761	3252069.0
2014-04-23 12:00:00	SPY	ETF	187.77	187.79	187.51	187.62	2636076.0
2014-04-23 12:30:00	SPY	ETF	187.6163	187.78	187.57	187.715	2240912.0
2014-04-23 13:00:00	SPY	ETF	187.71	187.78	187.6	187.71	2054915.0
2014-04-23 13:30:00	SPY	ETF	187.71	187.765	187.46	187.57	3479155.0
2014-04-23 14:00:00	SPY	ETF	187.57	187.61	187.4	187.515	5043755.0
2014-04-23 14:30:00	SPY	ETF	187.51	187.8	187.37	187.53	3786097.0
2014-04-23 15:00:00	SPY	ETF	187.53	187.67	187.5	187.54	4826391.0
2014-04-23 15:30:00	SPY	ETF	187.54	187.64	187.44	187.46	9361437.0
2014-04-23 16:00:00	SPY	ETF	187.47	187.86	187.44	187.71	4140503.0
2014-04-23 16:30:00	SPY	ETF	187.74	188.47	187.7	188.36	1530691.0
2014-04-23 17:00:00	SPY	ETF	188.34	188.6	188.34	188.49	498075.0
2014-04-23 17:30:00	SPY	ETF	188.49	188.52	188.42	188.49	80158.0
2014-04-23 18:00:00	SPY	ETF	188.45	188.49	188.31	188.44	135082.0
2014-04-23 18:30:00	SPY	ETF	188.41	188.43	188.36	188.39	61549.0
2014-04-23 19:00:00	SPY	ETF	188.39	188.44	188.38	188.41	13235.0
2014-04-23 19:30:00	SPY	ETF	188.41	188.44	188.39	188.43	33420.0
2014-04-23 05:00:00	QQQ	ETF	87.56	87.65	87.56	87.65	7050.0
2014-04-23 05:30:00	QQQ	ETF	87.55	87.55	87.55	87.55	100.0
2014-04-23 06:30:00	QQQ	ETF	87.5	87.5	87.5	87.5	200.0
2014-04-23 07:00:00	QQQ	ETF	87.5	87.53	87.46	87.53	16900.0
2014-04-23 07:30:00	QQQ	ETF	87.54	87.57	87.45	87.45	55706.0
2014-04-23 08:00:00	QQQ	ETF	87.45	87.5	87.41	87.47	43164.0
2014-04-23 08:30:00	QQQ	ETF	87.47	87.56	87.46	87.52	62960.0
2014-04-23 09:00:00	QQQ	ETF	87.53	87.56	87.48	87.54	727374.0
2014-04-23 09:30:00	QQQ	ETF	87.55	87.56	87.0398	87.11	5016986.0
2014-04-23 10:00:00	QQQ	ETF	87.11	87.14	86.85	87.0599	4806803.0
2014-04-23 10:30:00	QQQ	ETF	87.06	87.17	86.93	87.07	2038102.0
2014-04-23 11:00:00	QQQ	ETF	87.07	87.14	86.891	86.96	1906788.0
2014-04-23 11:30:00	QQQ	ETF	86.97	87.13	86.95	87.109	1199320.0
2014-04-23 12:00:00	QQQ	ETF	87.1	87.11	86.87	86.95	937966.0
2014-04-23 12:30:00	QQQ	ETF	86.94	87.03	86.92	86.99	697010.0
2014-04-23 13:00:00	QQQ	ETF	87.0	87.02	86.89	86.97	557180.0
2014-04-23 13:30:00	QQQ	ETF	86.97	87.0	86.7701	86.82	1265185.0
2014-04-23 14:00:00	QQQ	ETF	86.83	86.86	86.73	86.81	1691886.0
2014-04-23 14:30:00	QQQ	ETF	86.8	86.8499	86.72	86.81	1494170.0

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

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