PREVIEW / etf_30min / 2011-03-29

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-29.parquet
  size:    271 KB
  rows:    9,030

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
2011-03-29 04:00:00	SPY	ETF	130.9	130.97	130.89	130.89	2200.0
2011-03-29 04:30:00	SPY	ETF	130.96	131.1	130.89	131.07	1600.0
2011-03-29 05:00:00	SPY	ETF	131.09	131.11	130.79	130.8	16400.0
2011-03-29 05:30:00	SPY	ETF	130.78	130.87	130.78	130.86	21100.0
2011-03-29 06:00:00	SPY	ETF	130.86	130.87	130.8	130.8	650.0
2011-03-29 06:30:00	SPY	ETF	130.87	130.9	130.71	130.71	21500.0
2011-03-29 07:00:00	SPY	ETF	130.79	130.92	130.71	130.76	100878.0
2011-03-29 07:30:00	SPY	ETF	130.76	131.0	130.73	130.99	909792.0
2011-03-29 08:00:00	SPY	ETF	130.96	131.0	130.68	130.92	683381.0
2011-03-29 08:30:00	SPY	ETF	130.93	130.97	130.81	130.88	527158.0
2011-03-29 09:00:00	SPY	ETF	130.87	130.97	130.8	130.88	994810.0
2011-03-29 09:30:00	SPY	ETF	130.87	130.93	130.44	130.59	18722254.0
2011-03-29 10:00:00	SPY	ETF	130.62	131.21	130.5	131.03	17317512.0
2011-03-29 10:30:00	SPY	ETF	131.03	131.25	130.96	131.17	6471002.0
2011-03-29 11:00:00	SPY	ETF	131.17	131.5	131.12	131.47	10040021.0
2011-03-29 11:30:00	SPY	ETF	131.465	131.56	131.41	131.46	6488473.0
2011-03-29 12:00:00	SPY	ETF	131.465	131.56	131.37	131.38	5164290.0
2011-03-29 12:30:00	SPY	ETF	131.39	131.51	131.35	131.48	5567193.0
2011-03-29 13:00:00	SPY	ETF	131.482	131.56	131.4	131.44	6032092.0
2011-03-29 13:30:00	SPY	ETF	131.43	131.52	131.41	131.5	4377948.0
2011-03-29 14:00:00	SPY	ETF	131.5	131.74	131.48	131.61	11205839.0
2011-03-29 14:30:00	SPY	ETF	131.61	131.81	131.6	131.7601	4638146.0
2011-03-29 15:00:00	SPY	ETF	131.77	131.85	131.6408	131.8	7980625.0
2011-03-29 15:30:00	SPY	ETF	131.8	131.9	131.7	131.84	11989161.0
2011-03-29 16:00:00	SPY	ETF	131.85	132.29	131.4	132.01	7822117.0
2011-03-29 16:30:00	SPY	ETF	132.01	132.22	130.6605	132.13	1405106.0
2011-03-29 17:00:00	SPY	ETF	132.13	132.17	132.08	132.13	148791.0
2011-03-29 17:30:00	SPY	ETF	132.16	132.2	132.11	132.17	52816.0
2011-03-29 18:00:00	SPY	ETF	132.17	132.17	131.86	132.01	304331.0
2011-03-29 18:30:00	SPY	ETF	132.01	132.01	131.9	131.93	136022.0
2011-03-29 19:00:00	SPY	ETF	131.94	131.96	131.88	131.91	125522.0
2011-03-29 19:30:00	SPY	ETF	131.9	131.96	131.9	131.95	39646.0
2011-03-29 20:00:00	SPY	ETF	131.96	131.96	131.96	131.96	100.0
2011-03-29 04:00:00	QQQ	ETF	56.61	56.61	56.58	56.58	531.0
2011-03-29 04:30:00	QQQ	ETF	56.61	56.64	56.61	56.64	700.0
2011-03-29 06:00:00	QQQ	ETF	56.52	56.52	56.52	56.52	400.0
2011-03-29 06:30:00	QQQ	ETF	56.52	56.52	56.52	56.52	500.0
2011-03-29 07:00:00	QQQ	ETF	56.49	56.58	56.49	56.5	15968.0
2011-03-29 07:30:00	QQQ	ETF	56.49	56.55	56.45	56.54	13091.0
2011-03-29 08:00:00	QQQ	ETF	56.55	56.55	56.48	56.49	199452.0
2011-03-29 08:30:00	QQQ	ETF	56.48	56.5	56.38	56.41	167136.0
2011-03-29 09:00:00	QQQ	ETF	56.41	56.44	56.38	56.41	156208.0
2011-03-29 09:30:00	QQQ	ETF	56.41	56.52	56.23	56.45	5465812.0
2011-03-29 10:00:00	QQQ	ETF	56.45	56.82	56.43	56.75	4596400.0
2011-03-29 10:30:00	QQQ	ETF	56.7508	56.83	56.7	56.79	2195526.0
2011-03-29 11:00:00	QQQ	ETF	56.79	56.985	56.79	56.94	3835582.0
2011-03-29 11:30:00	QQQ	ETF	56.94	56.985	56.89	56.96	1782563.0
2011-03-29 12:00:00	QQQ	ETF	56.96	56.98	56.861	56.87	1737085.0
2011-03-29 12:30:00	QQQ	ETF	56.8616	56.92	56.83	56.9	2141894.0
2011-03-29 13:00:00	QQQ	ETF	56.9075	56.92	56.79	56.8025	2011342.0

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

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