PREVIEW / etf_30min / 2012-10-22

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-22.parquet
  size:    289 KB
  rows:    9,680

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-10-22 04:00:00	SPY	ETF	143.01	143.23	143.01	143.23	920.0
2012-10-22 04:30:00	SPY	ETF	143.3	143.46	143.23	143.46	3550.0
2012-10-22 05:00:00	SPY	ETF	143.48	143.65	143.48	143.6	11525.0
2012-10-22 05:30:00	SPY	ETF	143.55	143.6	143.55	143.6	7800.0
2012-10-22 06:00:00	SPY	ETF	143.56	143.64	143.53	143.61	53249.0
2012-10-22 06:30:00	SPY	ETF	143.6	143.61	143.47	143.48	87442.0
2012-10-22 07:00:00	SPY	ETF	143.53	143.61	143.53	143.59	96268.0
2012-10-22 07:30:00	SPY	ETF	143.6	143.61	143.28	143.34	173559.0
2012-10-22 08:00:00	SPY	ETF	143.34	143.62	143.11	143.28	745746.0
2012-10-22 08:30:00	SPY	ETF	143.28	143.3	143.14	143.17	404235.0
2012-10-22 09:00:00	SPY	ETF	143.18	143.27	143.13	143.16	673818.0
2012-10-22 09:30:00	SPY	ETF	143.15	143.47	143.02	143.31	14238662.0
2012-10-22 10:00:00	SPY	ETF	143.32	143.67	143.28	143.49	10218779.0
2012-10-22 10:30:00	SPY	ETF	143.49	143.51	143.13	143.25	7327976.0
2012-10-22 11:00:00	SPY	ETF	143.24	143.32	142.81	142.979	8696029.0
2012-10-22 11:30:00	SPY	ETF	142.98	143.33	142.9	143.18	5602996.0
2012-10-22 12:00:00	SPY	ETF	143.185	143.25	143.0201	143.11	4982062.0
2012-10-22 12:30:00	SPY	ETF	143.11	143.17	142.925	142.98	3421484.0
2012-10-22 13:00:00	SPY	ETF	142.985	143.07	142.49	142.52	8776370.0
2012-10-22 13:30:00	SPY	ETF	142.52	142.66	142.28	142.529	8251560.0
2012-10-22 14:00:00	SPY	ETF	142.53	142.77	142.45	142.61	7714236.0
2012-10-22 14:30:00	SPY	ETF	142.61	142.74	142.47	142.549	6506928.0
2012-10-22 15:00:00	SPY	ETF	142.54	142.94	142.39	142.91	11055070.0
2012-10-22 15:30:00	SPY	ETF	142.92	143.56	142.78	143.43	15372820.0
2012-10-22 16:00:00	SPY	ETF	143.44	143.7	142.29	143.65	4940893.0
2012-10-22 16:30:00	SPY	ETF	143.66	143.85	143.66	143.8	664822.0
2012-10-22 17:00:00	SPY	ETF	143.8	143.83	143.77	143.81	96536.0
2012-10-22 17:30:00	SPY	ETF	143.79	143.81	143.73	143.76	98276.0
2012-10-22 18:00:00	SPY	ETF	143.76	143.77	143.71	143.75	24152.0
2012-10-22 18:30:00	SPY	ETF	143.75	143.77	143.74	143.75	30069.0
2012-10-22 19:00:00	SPY	ETF	143.74	143.89	143.7	143.87	81599.0
2012-10-22 19:30:00	SPY	ETF	143.87	143.9	143.84	143.89	45700.0
2012-10-22 04:00:00	QQQ	ETF	65.71	65.71	65.71	65.71	600.0
2012-10-22 04:30:00	QQQ	ETF	65.78	65.88	65.78	65.88	1600.0
2012-10-22 05:00:00	QQQ	ETF	65.87	65.94	65.87	65.94	5500.0
2012-10-22 06:00:00	QQQ	ETF	65.88	65.9	65.88	65.9	400.0
2012-10-22 06:30:00	QQQ	ETF	65.89	65.89	65.89	65.89	1000.0
2012-10-22 07:00:00	QQQ	ETF	65.88	65.91	65.87	65.9	15156.0
2012-10-22 07:30:00	QQQ	ETF	65.9	65.92	65.76	65.8	63830.0
2012-10-22 08:00:00	QQQ	ETF	65.78	65.83	65.67	65.76	144118.0
2012-10-22 08:30:00	QQQ	ETF	65.77	65.77	65.65	65.66	93716.0
2012-10-22 09:00:00	QQQ	ETF	65.67	65.73	65.61	65.61	349864.0
2012-10-22 09:30:00	QQQ	ETF	65.62	65.9	65.62	65.84	4542087.0
2012-10-22 10:00:00	QQQ	ETF	65.845	66.04	65.83	65.98	3491968.0
2012-10-22 10:30:00	QQQ	ETF	65.98	66.02	65.73	65.78	1723426.0
2012-10-22 11:00:00	QQQ	ETF	65.77	65.85	65.63	65.77	1929528.0
2012-10-22 11:30:00	QQQ	ETF	65.77	65.94	65.72	65.8601	1345207.0
2012-10-22 12:00:00	QQQ	ETF	65.865	65.91	65.79	65.835	1300637.0
2012-10-22 12:30:00	QQQ	ETF	65.835	65.8975	65.745	65.8101	1157981.0
2012-10-22 13:00:00	QQQ	ETF	65.82	65.87	65.58	65.61	2010060.0

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

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