PREVIEW / etf_30min / 2012-01-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-06.parquet
  size:    277 KB
  rows:    9,384

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-01-06 04:00:00	SPY	ETF	127.69	127.86	127.69	127.86	400.0
2012-01-06 04:30:00	SPY	ETF	127.73	127.8	127.73	127.8	600.0
2012-01-06 05:30:00	SPY	ETF	127.84	127.84	127.76	127.8	6000.0
2012-01-06 06:00:00	SPY	ETF	127.75	127.75	127.61	127.75	7149.0
2012-01-06 06:30:00	SPY	ETF	127.76	127.95	127.76	127.94	9900.0
2012-01-06 07:00:00	SPY	ETF	127.95	128.07	127.88	127.91	75300.0
2012-01-06 07:30:00	SPY	ETF	127.94	128.05	127.93	127.95	97617.0
2012-01-06 08:00:00	SPY	ETF	127.95	128.15	127.4	128.11	1690202.0
2012-01-06 08:30:00	SPY	ETF	128.05	128.7	128.02	128.11	6872160.0
2012-01-06 09:00:00	SPY	ETF	128.11	128.27	127.91	128.2	2148275.0
2012-01-06 09:30:00	SPY	ETF	128.2	128.22	127.29	127.44	22651720.0
2012-01-06 10:00:00	SPY	ETF	127.44	127.74	127.32	127.58	13849753.0
2012-01-06 10:30:00	SPY	ETF	127.58	127.94	127.575	127.7	12203070.0
2012-01-06 11:00:00	SPY	ETF	127.7	128.04	127.6911	127.93	7463202.0
2012-01-06 11:30:00	SPY	ETF	127.93	128.16	127.895	128.04	6878379.0
2012-01-06 12:00:00	SPY	ETF	128.03	128.08	127.89	128.02	5667670.0
2012-01-06 12:30:00	SPY	ETF	128.02	128.09	127.73	127.82	6696245.0
2012-01-06 13:00:00	SPY	ETF	127.82	127.93	127.72	127.73	5219050.0
2012-01-06 13:30:00	SPY	ETF	127.731	128.14	127.64	128.0	7335529.0
2012-01-06 14:00:00	SPY	ETF	128.0	128.08	127.86	127.99	5526932.0
2012-01-06 14:30:00	SPY	ETF	127.99	128.05	127.83	127.85	4894782.0
2012-01-06 15:00:00	SPY	ETF	127.85	127.95	127.73	127.815	5569044.0
2012-01-06 15:30:00	SPY	ETF	127.83	127.96	127.65	127.79	19728523.0
2012-01-06 16:00:00	SPY	ETF	127.8	128.0756	127.5448	127.88	10546149.0
2012-01-06 16:30:00	SPY	ETF	127.87	128.0	127.87	127.97	353432.0
2012-01-06 17:00:00	SPY	ETF	127.94	127.96	127.87	127.89	78030.0
2012-01-06 17:30:00	SPY	ETF	127.88	127.93	127.82	127.91	115515.0
2012-01-06 18:00:00	SPY	ETF	127.82	127.94	127.82	127.89	1620104.0
2012-01-06 18:30:00	SPY	ETF	127.89	127.9	127.87	127.9	9073.0
2012-01-06 19:00:00	SPY	ETF	127.89	127.92	127.89	127.89	25140.0
2012-01-06 19:30:00	SPY	ETF	127.9	127.9	127.78	127.9	59704.0
2012-01-06 05:30:00	QQQ	ETF	57.57	57.57	57.55	57.55	1100.0
2012-01-06 06:00:00	QQQ	ETF	57.46	57.48	57.46	57.48	4100.0
2012-01-06 06:30:00	QQQ	ETF	57.61	57.61	57.6	57.6	1016.0
2012-01-06 07:00:00	QQQ	ETF	57.62	57.62	57.55	57.57	99542.0
2012-01-06 07:30:00	QQQ	ETF	57.57	57.6	57.55	57.56	87058.0
2012-01-06 08:00:00	QQQ	ETF	57.55	57.64	57.53	57.58	155539.0
2012-01-06 08:30:00	QQQ	ETF	57.58	57.79	57.54	57.56	860923.0
2012-01-06 09:00:00	QQQ	ETF	57.56	57.64	57.48	57.64	374808.0
2012-01-06 09:30:00	QQQ	ETF	57.65	57.69	57.4	57.49	4129162.0
2012-01-06 10:00:00	QQQ	ETF	57.489	57.64	57.42	57.585	3154395.0
2012-01-06 10:30:00	QQQ	ETF	57.57	57.71	57.55	57.59	3736633.0
2012-01-06 11:00:00	QQQ	ETF	57.6	57.75	57.6	57.7099	3706309.0
2012-01-06 11:30:00	QQQ	ETF	57.71	57.87	57.7	57.8	2965743.0
2012-01-06 12:00:00	QQQ	ETF	57.805	57.83	57.75	57.81	1998753.0
2012-01-06 12:30:00	QQQ	ETF	57.8	57.84	57.71	57.73	1373985.0
2012-01-06 13:00:00	QQQ	ETF	57.73	57.7799	57.68	57.755	2713139.0
2012-01-06 13:30:00	QQQ	ETF	57.76	57.94	57.7	57.849	3167516.0
2012-01-06 14:00:00	QQQ	ETF	57.845	57.875	57.79	57.86	1780938.0
2012-01-06 14:30:00	QQQ	ETF	57.8551	57.89	57.8	57.81	2797680.0

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

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