PREVIEW / etf_30min / 2012-02-29

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-29.parquet
  size:    301 KB
  rows:    10,090

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-29 04:00:00	SPY	ETF	137.51	137.79	137.51	137.73	5760.0
2012-02-29 04:30:00	SPY	ETF	137.8	137.82	137.8	137.82	4000.0
2012-02-29 05:00:00	SPY	ETF	137.84	137.98	137.59	137.95	102079.0
2012-02-29 05:30:00	SPY	ETF	137.99	138.11	137.66	137.7	26881.0
2012-02-29 06:00:00	SPY	ETF	137.8	137.8	137.7	137.75	15434.0
2012-02-29 06:30:00	SPY	ETF	137.73	137.77	137.59	137.77	53734.0
2012-02-29 07:00:00	SPY	ETF	137.78	137.93	137.78	137.88	276865.0
2012-02-29 07:30:00	SPY	ETF	137.84	137.88	137.72	137.75	242161.0
2012-02-29 08:00:00	SPY	ETF	137.73	137.86	137.64	137.8	415877.0
2012-02-29 08:30:00	SPY	ETF	137.8	138.06	137.7	137.7	829725.0
2012-02-29 09:00:00	SPY	ETF	137.7	137.81	137.65	137.75	871737.0
2012-02-29 09:30:00	SPY	ETF	137.76	138.12	137.73	138.09	14860148.0
2012-02-29 10:00:00	SPY	ETF	138.09	138.19	137.7	137.81	18478245.0
2012-02-29 10:30:00	SPY	ETF	137.81	137.81	136.88	137.25	21914837.0
2012-02-29 11:00:00	SPY	ETF	137.24	137.36	136.85	136.85	15653850.0
2012-02-29 11:30:00	SPY	ETF	136.85	137.35	136.79	137.28	11958398.0
2012-02-29 12:00:00	SPY	ETF	137.28	137.5706	137.16	137.4901	10254761.0
2012-02-29 12:30:00	SPY	ETF	137.495	137.52	137.2615	137.385	7243451.0
2012-02-29 13:00:00	SPY	ETF	137.39	137.51	137.24	137.34	5491167.0
2012-02-29 13:30:00	SPY	ETF	137.33	137.61	137.27	137.545	6683122.0
2012-02-29 14:00:00	SPY	ETF	137.54	137.685	137.41	137.51	6042520.0
2012-02-29 14:30:00	SPY	ETF	137.51	137.53	137.27	137.2815	7475264.0
2012-02-29 15:00:00	SPY	ETF	137.29	137.5706	137.05	137.125	9749559.0
2012-02-29 15:30:00	SPY	ETF	137.12	137.14	136.72	136.88	26862075.0
2012-02-29 16:00:00	SPY	ETF	136.88	137.3922	136.17	136.73	15958962.0
2012-02-29 16:30:00	SPY	ETF	136.72	137.34	136.43	136.51	845401.0
2012-02-29 17:00:00	SPY	ETF	136.53	136.97	136.38	136.4	1685503.0
2012-02-29 17:30:00	SPY	ETF	136.47	136.51	136.42	136.49	69283.0
2012-02-29 18:00:00	SPY	ETF	136.49	136.61	136.49	136.61	138216.0
2012-02-29 18:30:00	SPY	ETF	136.58	136.69	136.57	136.68	36040.0
2012-02-29 19:00:00	SPY	ETF	136.68	136.79	136.4	136.78	89927.0
2012-02-29 19:30:00	SPY	ETF	136.75	136.85	136.73	136.85	71493.0
2012-02-29 05:00:00	QQQ	ETF	64.76	64.76	64.76	64.76	500.0
2012-02-29 06:00:00	QQQ	ETF	64.68	64.68	64.68	64.68	500.0
2012-02-29 06:30:00	QQQ	ETF	64.68	64.7	64.68	64.7	1765.0
2012-02-29 07:00:00	QQQ	ETF	64.76	64.78	64.73	64.74	42200.0
2012-02-29 07:30:00	QQQ	ETF	64.73	64.76	64.7	64.71	33950.0
2012-02-29 08:00:00	QQQ	ETF	64.7	64.76	64.66	64.73	198445.0
2012-02-29 08:30:00	QQQ	ETF	64.73	64.82	64.7	64.7	170377.0
2012-02-29 09:00:00	QQQ	ETF	64.69	64.74	64.69	64.73	287183.0
2012-02-29 09:30:00	QQQ	ETF	64.74	64.95	64.73	64.93	6822421.0
2012-02-29 10:00:00	QQQ	ETF	64.93	64.96	64.7315	64.82	6125944.0
2012-02-29 10:30:00	QQQ	ETF	64.81	64.84	64.44	64.62	6504338.0
2012-02-29 11:00:00	QQQ	ETF	64.62	64.69	64.43	64.44	5071201.0
2012-02-29 11:30:00	QQQ	ETF	64.44	64.67	64.4	64.62	3158256.0
2012-02-29 12:00:00	QQQ	ETF	64.62	64.71	64.53	64.7	4017077.0
2012-02-29 12:30:00	QQQ	ETF	64.7	64.72	64.59	64.625	1620807.0
2012-02-29 13:00:00	QQQ	ETF	64.63	64.68	64.53	64.56	1952829.0
2012-02-29 13:30:00	QQQ	ETF	64.56	64.69	64.52	64.67	2059657.0
2012-02-29 14:00:00	QQQ	ETF	64.67	64.75	64.61	64.67	1874309.0

> showing 50 of 10,090 rows — these rows as CSV

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