PREVIEW / etf_30min / 2012-04-16

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-16.parquet
  size:    281 KB
  rows:    9,486

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-04-16 04:00:00	SPY	ETF	137.0	137.0	136.96	136.96	300.0
2012-04-16 04:30:00	SPY	ETF	136.87	137.29	136.87	137.29	58220.0
2012-04-16 05:00:00	SPY	ETF	137.24	137.31	137.17	137.31	16000.0
2012-04-16 05:30:00	SPY	ETF	137.29	137.43	137.24	137.43	47899.0
2012-04-16 06:00:00	SPY	ETF	137.49	137.59	137.47	137.55	9004.0
2012-04-16 06:30:00	SPY	ETF	137.48	137.5	137.42	137.45	62790.0
2012-04-16 07:00:00	SPY	ETF	137.43	137.5	137.43	137.48	263550.0
2012-04-16 07:30:00	SPY	ETF	137.48	137.49	137.11	137.17	406012.0
2012-04-16 08:00:00	SPY	ETF	137.17	137.49	136.65	137.25	1219370.0
2012-04-16 08:30:00	SPY	ETF	137.25	137.84	137.2	137.7	2473221.0
2012-04-16 09:00:00	SPY	ETF	137.71	137.92	137.7	137.84	994236.0
2012-04-16 09:30:00	SPY	ETF	137.84	138.04	137.21	137.27	21173389.0
2012-04-16 10:00:00	SPY	ETF	137.27	137.3	136.58	136.91	24171969.0
2012-04-16 10:30:00	SPY	ETF	136.9	137.21	136.735	137.035	11164723.0
2012-04-16 11:00:00	SPY	ETF	137.035	137.22	136.94	137.01	6497090.0
2012-04-16 11:30:00	SPY	ETF	137.01	137.05	136.72	136.78	8878076.0
2012-04-16 12:00:00	SPY	ETF	136.77	137.08	136.68	136.87	6923436.0
2012-04-16 12:30:00	SPY	ETF	136.87	137.18	136.7	137.15	7427858.0
2012-04-16 13:00:00	SPY	ETF	137.15	137.19	136.94	137.045	5369707.0
2012-04-16 13:30:00	SPY	ETF	137.04	137.68	137.011	137.5686	9768164.0
2012-04-16 14:00:00	SPY	ETF	137.56	137.6	137.28	137.34	6721784.0
2012-04-16 14:30:00	SPY	ETF	137.33	137.56	137.29	137.31	6053090.0
2012-04-16 15:00:00	SPY	ETF	137.31	137.36	137.12	137.225	6336845.0
2012-04-16 15:30:00	SPY	ETF	137.21	137.33	136.98	136.99	15644160.0
2012-04-16 16:00:00	SPY	ETF	136.98	137.0972	136.78	136.92	3553003.0
2012-04-16 16:30:00	SPY	ETF	136.92	137.07	136.91	136.99	446102.0
2012-04-16 17:00:00	SPY	ETF	136.99	136.99	136.95	136.95	64790.0
2012-04-16 17:30:00	SPY	ETF	136.94	136.97	136.93	136.97	18178.0
2012-04-16 18:00:00	SPY	ETF	136.94	136.95	136.9	136.91	97049.0
2012-04-16 18:30:00	SPY	ETF	136.92	136.95	136.9	136.95	6300.0
2012-04-16 19:00:00	SPY	ETF	136.94	136.95	136.9	136.94	47610.0
2012-04-16 19:30:00	SPY	ETF	136.92	136.96	136.89	136.94	11130.0
2012-04-16 04:00:00	QQQ	ETF	66.19	66.19	66.19	66.19	700.0
2012-04-16 06:30:00	QQQ	ETF	66.37	66.37	66.32	66.33	28500.0
2012-04-16 07:00:00	QQQ	ETF	66.34	66.35	66.33	66.33	14400.0
2012-04-16 07:30:00	QQQ	ETF	66.35	66.35	66.2	66.2	97200.0
2012-04-16 08:00:00	QQQ	ETF	66.23	66.33	66.21	66.33	61707.0
2012-04-16 08:30:00	QQQ	ETF	66.34	66.54	66.32	66.5	310001.0
2012-04-16 09:00:00	QQQ	ETF	66.49	66.55	66.49	66.52	117793.0
2012-04-16 09:30:00	QQQ	ETF	66.53	66.56	65.45	65.53	11318764.0
2012-04-16 10:00:00	QQQ	ETF	65.52	65.64	65.24	65.49	10092160.0
2012-04-16 10:30:00	QQQ	ETF	65.48	65.78	65.43	65.67	4768324.0
2012-04-16 11:00:00	QQQ	ETF	65.66	65.72	65.57	65.63	2221493.0
2012-04-16 11:30:00	QQQ	ETF	65.63	65.65	65.4	65.42	2184938.0
2012-04-16 12:00:00	QQQ	ETF	65.41	65.6	65.36	65.45	1669835.0
2012-04-16 12:30:00	QQQ	ETF	65.45	65.56	65.34	65.55	1631727.0
2012-04-16 13:00:00	QQQ	ETF	65.545	65.59	65.39	65.46	1707417.0
2012-04-16 13:30:00	QQQ	ETF	65.4582	65.74	65.43	65.67	3072842.0
2012-04-16 14:00:00	QQQ	ETF	65.67	65.71	65.55	65.64	1715782.0
2012-04-16 14:30:00	QQQ	ETF	65.63	65.84	65.62	65.65	1986477.0

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

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