PREVIEW / etf_30min / 2012-03-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-13.parquet
  size:    300 KB
  rows:    9,923

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-03-13 04:00:00	SPY	ETF	138.03	138.34	138.03	138.34	12048.0
2012-03-13 04:30:00	SPY	ETF	138.35	138.35	138.26	138.26	1088.0
2012-03-13 05:00:00	SPY	ETF	138.3	138.4	138.3	138.4	5324.0
2012-03-13 05:30:00	SPY	ETF	138.4	138.55	138.4	138.55	15453.0
2012-03-13 06:00:00	SPY	ETF	138.58	138.6	138.5	138.52	5850.0
2012-03-13 06:30:00	SPY	ETF	138.52	138.57	138.49	138.54	55350.0
2012-03-13 07:00:00	SPY	ETF	138.55	138.55	138.44	138.47	99662.0
2012-03-13 07:30:00	SPY	ETF	138.48	138.58	138.42	138.45	113206.0
2012-03-13 08:00:00	SPY	ETF	138.42	138.6385	138.39	138.42	263247.0
2012-03-13 08:30:00	SPY	ETF	138.43	138.49	138.23	138.27	1012128.0
2012-03-13 09:00:00	SPY	ETF	138.28	138.33	138.16	138.33	950273.0
2012-03-13 09:30:00	SPY	ETF	138.32	138.39	138.12	138.17	13855367.0
2012-03-13 10:00:00	SPY	ETF	138.17	138.29	138.09	138.2599	9979861.0
2012-03-13 10:30:00	SPY	ETF	138.26	138.53	138.26	138.49	9931029.0
2012-03-13 11:00:00	SPY	ETF	138.48	138.66	138.48	138.62	9147842.0
2012-03-13 11:30:00	SPY	ETF	138.62	138.85	138.6	138.76	13182974.0
2012-03-13 12:00:00	SPY	ETF	138.76	138.81	138.72	138.79	5956842.0
2012-03-13 12:30:00	SPY	ETF	138.79	138.91	138.73	138.9	6358265.0
2012-03-13 13:00:00	SPY	ETF	138.9	138.98	138.87	138.91	4580767.0
2012-03-13 13:30:00	SPY	ETF	138.91	138.91	138.78	138.8	3109739.0
2012-03-13 14:00:00	SPY	ETF	138.81	139.04	138.7	138.75	10396108.0
2012-03-13 14:30:00	SPY	ETF	138.76	138.94	138.6	138.77	9721247.0
2012-03-13 15:00:00	SPY	ETF	138.77	139.84	138.765	139.595	28128723.0
2012-03-13 15:30:00	SPY	ETF	139.6	140.13	139.55	140.06	34197312.0
2012-03-13 16:00:00	SPY	ETF	140.07	140.19	138.64	139.98	8422038.0
2012-03-13 16:30:00	SPY	ETF	140.04	140.35	139.67	140.26	8286354.0
2012-03-13 17:00:00	SPY	ETF	140.24	140.29	138.66	140.15	1174768.0
2012-03-13 17:30:00	SPY	ETF	140.11	140.14	140.03	140.05	200635.0
2012-03-13 18:00:00	SPY	ETF	140.06	140.1	140.01	140.05	914458.0
2012-03-13 18:30:00	SPY	ETF	140.01	140.2	140.01	140.16	22067.0
2012-03-13 19:00:00	SPY	ETF	140.17	140.17	140.05	140.08	42794.0
2012-03-13 19:30:00	SPY	ETF	140.07	140.09	140.04	140.04	105584.0
2012-03-13 04:00:00	QQQ	ETF	65.26	65.26	65.26	65.26	500.0
2012-03-13 05:30:00	QQQ	ETF	65.43	65.48	65.43	65.48	200.0
2012-03-13 06:00:00	QQQ	ETF	65.5	65.5	65.5	65.5	100.0
2012-03-13 06:30:00	QQQ	ETF	65.51	65.51	65.51	65.51	2000.0
2012-03-13 07:00:00	QQQ	ETF	65.48	65.51	65.46	65.46	18900.0
2012-03-13 07:30:00	QQQ	ETF	65.48	65.52	65.44	65.45	33585.0
2012-03-13 08:00:00	QQQ	ETF	65.43	65.46	65.42	65.42	34018.0
2012-03-13 08:30:00	QQQ	ETF	65.45	65.46	65.36	65.37	115266.0
2012-03-13 09:00:00	QQQ	ETF	65.38	65.43	65.33	65.42	218537.0
2012-03-13 09:30:00	QQQ	ETF	65.42	65.5	65.31	65.41	7258754.0
2012-03-13 10:00:00	QQQ	ETF	65.4	65.41	65.27	65.3895	5636239.0
2012-03-13 10:30:00	QQQ	ETF	65.39	65.56	65.39	65.54	2769295.0
2012-03-13 11:00:00	QQQ	ETF	65.532	65.62	65.51	65.61	2182477.0
2012-03-13 11:30:00	QQQ	ETF	65.61	65.77	65.6	65.7	4014346.0
2012-03-13 12:00:00	QQQ	ETF	65.7	65.74	65.675	65.73	2619192.0
2012-03-13 12:30:00	QQQ	ETF	65.74	65.81	65.7	65.79	3311093.0
2012-03-13 13:00:00	QQQ	ETF	65.8	65.83	65.77	65.8037	2017500.0
2012-03-13 13:30:00	QQQ	ETF	65.8	65.8	65.77	65.79	962044.0

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

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