PREVIEW / etf_30min / 2012-03-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-06.parquet
  size:    306 KB
  rows:    10,353

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-06 04:00:00	SPY	ETF	136.52	136.52	136.0	136.0	33874.0
2012-03-06 04:30:00	SPY	ETF	135.85	135.98	135.82	135.84	10932.0
2012-03-06 05:00:00	SPY	ETF	135.95	135.95	135.72	135.75	25450.0
2012-03-06 05:30:00	SPY	ETF	135.73	135.83	135.73	135.75	2650.0
2012-03-06 06:00:00	SPY	ETF	135.79	135.86	135.75	135.86	18800.0
2012-03-06 06:30:00	SPY	ETF	135.89	135.9	135.7	135.76	157460.0
2012-03-06 07:00:00	SPY	ETF	135.75	135.92	135.7	135.92	372948.0
2012-03-06 07:30:00	SPY	ETF	135.92	135.95	135.79	135.83	448062.0
2012-03-06 08:00:00	SPY	ETF	135.85	136.41	135.75	135.78	936997.0
2012-03-06 08:30:00	SPY	ETF	135.78	135.88	135.62	135.69	1081557.0
2012-03-06 09:00:00	SPY	ETF	135.69	135.69	135.31	135.35	2763434.0
2012-03-06 09:30:00	SPY	ETF	135.35	135.43	135.02	135.1	27175711.0
2012-03-06 10:00:00	SPY	ETF	135.1	135.22	134.78	134.95	16786529.0
2012-03-06 10:30:00	SPY	ETF	134.95	135.16	134.8	134.88	12545381.0
2012-03-06 11:00:00	SPY	ETF	134.88	135.16	134.85	135.149	14847102.0
2012-03-06 11:30:00	SPY	ETF	135.15	135.15	134.75	134.84	14713474.0
2012-03-06 12:00:00	SPY	ETF	134.83	134.92	134.58	134.6179	8867142.0
2012-03-06 12:30:00	SPY	ETF	134.62	134.82	134.61	134.72	6970777.0
2012-03-06 13:00:00	SPY	ETF	134.72	134.825	134.56	134.61	7108313.0
2012-03-06 13:30:00	SPY	ETF	134.63	134.77	134.54	134.65	6743821.0
2012-03-06 14:00:00	SPY	ETF	134.66	134.795	134.46	134.5	9151677.0
2012-03-06 14:30:00	SPY	ETF	134.505	134.58	134.36	134.42	9175790.0
2012-03-06 15:00:00	SPY	ETF	134.425	134.96	134.42	134.59	9878429.0
2012-03-06 15:30:00	SPY	ETF	134.585	134.86	134.47	134.7	25517405.0
2012-03-06 16:00:00	SPY	ETF	134.71	136.8123	134.49	134.6	18735192.0
2012-03-06 16:30:00	SPY	ETF	134.63	134.79	134.48	134.7	5056978.0
2012-03-06 17:00:00	SPY	ETF	134.7	134.72	134.65	134.72	98925.0
2012-03-06 17:30:00	SPY	ETF	134.72	134.73	134.67	134.69	48345.0
2012-03-06 18:00:00	SPY	ETF	134.72	134.82	134.72	134.8	59749.0
2012-03-06 18:30:00	SPY	ETF	134.8	134.97	134.78	134.95	130514.0
2012-03-06 19:00:00	SPY	ETF	134.91	134.99	134.89	134.98	105159.0
2012-03-06 19:30:00	SPY	ETF	134.95	134.99	134.87	134.96	57329.0
2012-03-06 04:30:00	QQQ	ETF	63.85	63.85	63.8	63.8	300.0
2012-03-06 05:00:00	QQQ	ETF	63.75	63.78	63.75	63.78	19915.0
2012-03-06 06:00:00	QQQ	ETF	63.77	63.77	63.77	63.77	20100.0
2012-03-06 06:30:00	QQQ	ETF	63.75	63.75	63.65	63.71	70850.0
2012-03-06 07:00:00	QQQ	ETF	63.69	63.75	63.66	63.75	186130.0
2012-03-06 07:30:00	QQQ	ETF	63.77	63.8	63.75	63.77	24811.0
2012-03-06 08:00:00	QQQ	ETF	63.75	63.79	63.7	63.71	330041.0
2012-03-06 08:30:00	QQQ	ETF	63.71	63.77	63.67	63.72	2008714.0
2012-03-06 09:00:00	QQQ	ETF	63.71	63.72	63.55	63.58	2026933.0
2012-03-06 09:30:00	QQQ	ETF	63.59	63.72	63.42	63.46	10388546.0
2012-03-06 10:00:00	QQQ	ETF	63.46	63.515	63.23	63.33	6519614.0
2012-03-06 10:30:00	QQQ	ETF	63.32	63.51	63.32	63.395	4429304.0
2012-03-06 11:00:00	QQQ	ETF	63.385	63.67	63.36	63.655	2926218.0
2012-03-06 11:30:00	QQQ	ETF	63.65	63.665	63.3706	63.44	2946220.0
2012-03-06 12:00:00	QQQ	ETF	63.445	63.5199	63.33	63.36	2185514.0
2012-03-06 12:30:00	QQQ	ETF	63.36	63.53	63.36	63.46	2441060.0
2012-03-06 13:00:00	QQQ	ETF	63.46	63.58	63.4	63.43	1935076.0
2012-03-06 13:30:00	QQQ	ETF	63.43	63.64	63.37	63.4799	2330407.0

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

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