PREVIEW / etf_30min / 2012-02-22

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-22.parquet
  size:    282 KB
  rows:    9,505

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-02-22 04:00:00	SPY	ETF	136.5	136.5	136.35	136.47	27380.0
2012-02-22 05:00:00	SPY	ETF	136.34	136.42	136.34	136.42	5340.0
2012-02-22 05:30:00	SPY	ETF	136.42	136.42	136.42	136.42	10000.0
2012-02-22 06:00:00	SPY	ETF	136.35	136.35	136.25	136.35	110600.0
2012-02-22 06:30:00	SPY	ETF	136.28	136.28	136.14	136.17	41275.0
2012-02-22 07:00:00	SPY	ETF	136.17	136.33	136.15	136.28	28735.0
2012-02-22 07:30:00	SPY	ETF	136.28	136.45	136.27	136.33	237995.0
2012-02-22 08:00:00	SPY	ETF	136.33	136.4716	136.12	136.23	851629.0
2012-02-22 08:30:00	SPY	ETF	136.23	136.38	136.15	136.38	561953.0
2012-02-22 09:00:00	SPY	ETF	136.37	136.41	136.19	136.25	1819539.0
2012-02-22 09:30:00	SPY	ETF	136.26	136.46	136.17	136.34	16076348.0
2012-02-22 10:00:00	SPY	ETF	136.34	136.55	136.07	136.31	19478720.0
2012-02-22 10:30:00	SPY	ETF	136.305	136.4	136.1	136.3	9432812.0
2012-02-22 11:00:00	SPY	ETF	136.31	136.46	136.15	136.2045	9637322.0
2012-02-22 11:30:00	SPY	ETF	136.21	136.26	135.85	135.95	9811401.0
2012-02-22 12:00:00	SPY	ETF	135.95	136.01	135.79	135.989	6348859.0
2012-02-22 12:30:00	SPY	ETF	135.98	136.04	135.92	135.9901	2943869.0
2012-02-22 13:00:00	SPY	ETF	135.995	136.32	135.97	136.26	5892656.0
2012-02-22 13:30:00	SPY	ETF	136.27	136.35	136.16	136.29	3772812.0
2012-02-22 14:00:00	SPY	ETF	136.29	136.37	136.23	136.3	4317103.0
2012-02-22 14:30:00	SPY	ETF	136.29	136.3	136.06	136.06	4693133.0
2012-02-22 15:00:00	SPY	ETF	136.06	136.25	136.0	136.11	6285859.0
2012-02-22 15:30:00	SPY	ETF	136.11	136.29	135.92	136.02	15707941.0
2012-02-22 16:00:00	SPY	ETF	136.01	136.3664	135.95	136.03	5079236.0
2012-02-22 16:30:00	SPY	ETF	136.05	136.15	136.05	136.15	88356.0
2012-02-22 17:00:00	SPY	ETF	136.15	136.15	135.96	136.0	329578.0
2012-02-22 17:30:00	SPY	ETF	136.0	136.02	135.96	136.0	41340.0
2012-02-22 18:00:00	SPY	ETF	136.0	136.03	135.97	136.0	87630.0
2012-02-22 18:30:00	SPY	ETF	135.99	136.05	135.96	136.03	125884.0
2012-02-22 19:00:00	SPY	ETF	136.04	136.04	135.97	135.97	42400.0
2012-02-22 19:30:00	SPY	ETF	135.98	135.99	135.83	135.85	203266.0
2012-02-22 20:00:00	SPY	ETF	135.85	135.85	135.85	135.85	500.0
2012-02-22 04:30:00	QQQ	ETF	63.64	63.68	63.64	63.68	700.0
2012-02-22 05:00:00	QQQ	ETF	63.58	63.58	63.58	63.58	1000.0
2012-02-22 05:30:00	QQQ	ETF	63.62	63.62	63.6	63.6	1200.0
2012-02-22 06:00:00	QQQ	ETF	63.54	63.54	63.54	63.54	100.0
2012-02-22 06:30:00	QQQ	ETF	63.55	63.55	63.52	63.52	8000.0
2012-02-22 07:00:00	QQQ	ETF	63.51	63.61	63.51	63.61	20400.0
2012-02-22 07:30:00	QQQ	ETF	63.57	63.61	63.55	63.55	56550.0
2012-02-22 08:00:00	QQQ	ETF	63.56	63.6	63.47	63.5	113847.0
2012-02-22 08:30:00	QQQ	ETF	63.51	63.575	63.48	63.56	133406.0
2012-02-22 09:00:00	QQQ	ETF	63.57	63.59	63.47	63.5	1303431.0
2012-02-22 09:30:00	QQQ	ETF	63.5	63.59	63.36	63.55	5930585.0
2012-02-22 10:00:00	QQQ	ETF	63.54	63.68	63.44	63.5	6360983.0
2012-02-22 10:30:00	QQQ	ETF	63.5	63.535	63.37	63.5	3988122.0
2012-02-22 11:00:00	QQQ	ETF	63.51	63.5883	63.41	63.451	3428756.0
2012-02-22 11:30:00	QQQ	ETF	63.45	63.48	63.26	63.34	3262643.0
2012-02-22 12:00:00	QQQ	ETF	63.345	63.345	63.23	63.335	1959075.0
2012-02-22 12:30:00	QQQ	ETF	63.34	63.35	63.28	63.31	1230109.0
2012-02-22 13:00:00	QQQ	ETF	63.31	63.49	63.2798	63.47	2781518.0

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

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