PREVIEW / etf_30min / 2011-07-11

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-11.parquet
  size:    289 KB
  rows:    9,693

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-07-11 04:00:00	SPY	ETF	133.9	133.9	133.45	133.45	21692.0
2011-07-11 04:30:00	SPY	ETF	133.46	133.61	133.4	133.61	5600.0
2011-07-11 05:00:00	SPY	ETF	133.49	133.5	133.3	133.5	23366.0
2011-07-11 05:30:00	SPY	ETF	133.4	133.45	133.39	133.4	800.0
2011-07-11 06:00:00	SPY	ETF	133.4	133.45	133.3	133.45	8650.0
2011-07-11 06:30:00	SPY	ETF	133.47	133.47	133.32	133.34	16005.0
2011-07-11 07:00:00	SPY	ETF	133.33	133.36	133.12	133.27	1156745.0
2011-07-11 07:30:00	SPY	ETF	133.27	133.32	132.85	132.94	760828.0
2011-07-11 08:00:00	SPY	ETF	132.94	133.24	132.69	132.73	4293598.0
2011-07-11 08:30:00	SPY	ETF	132.73	133.01	132.6728	132.89	1497162.0
2011-07-11 09:00:00	SPY	ETF	132.88	132.97	132.65	132.76	2211582.0
2011-07-11 09:30:00	SPY	ETF	132.75	133.18	132.71	132.94	18704864.0
2011-07-11 10:00:00	SPY	ETF	132.94	133.005	132.35	132.4597	16263374.0
2011-07-11 10:30:00	SPY	ETF	132.46	132.51	132.01	132.02	15718957.0
2011-07-11 11:00:00	SPY	ETF	132.02	132.42	131.91	132.41	16825872.0
2011-07-11 11:30:00	SPY	ETF	132.4	132.5	132.25	132.299	9389314.0
2011-07-11 12:00:00	SPY	ETF	132.29	132.45	132.2	132.39	4545697.0
2011-07-11 12:30:00	SPY	ETF	132.4	132.415	132.1	132.16	5719553.0
2011-07-11 13:00:00	SPY	ETF	132.165	132.21	131.84	132.0	8424422.0
2011-07-11 13:30:00	SPY	ETF	132.0	132.2	131.9	132.18	5962175.0
2011-07-11 14:00:00	SPY	ETF	132.17	132.225	131.88	131.95	6484234.0
2011-07-11 14:30:00	SPY	ETF	131.95	132.03	131.75	131.89	9009087.0
2011-07-11 15:00:00	SPY	ETF	131.89	132.0	131.68	131.97	11929905.0
2011-07-11 15:30:00	SPY	ETF	131.97	132.05	131.66	131.99	29939402.0
2011-07-11 16:00:00	SPY	ETF	131.98	134.4174	131.98	132.26	13919134.0
2011-07-11 16:30:00	SPY	ETF	132.26	134.4174	132.19	132.26	7165231.0
2011-07-11 17:00:00	SPY	ETF	132.26	132.26	132.11	132.11	280797.0
2011-07-11 17:30:00	SPY	ETF	132.14	132.18	132.12	132.17	42659.0
2011-07-11 18:00:00	SPY	ETF	132.17	132.31	131.96	132.25	654502.0
2011-07-11 18:30:00	SPY	ETF	132.26	132.27	132.17	132.17	70315.0
2011-07-11 19:00:00	SPY	ETF	132.17	132.22	132.11	132.13	104345.0
2011-07-11 19:30:00	SPY	ETF	132.13	132.24	132.1	132.2	114802.0
2011-07-11 04:00:00	QQQ	ETF	59.02	59.02	58.66	58.66	10058.0
2011-07-11 06:00:00	QQQ	ETF	58.59	58.63	58.59	58.63	4700.0
2011-07-11 06:30:00	QQQ	ETF	58.57	58.66	58.56	58.56	21700.0
2011-07-11 07:00:00	QQQ	ETF	58.59	58.59	58.45	58.55	408540.0
2011-07-11 07:30:00	QQQ	ETF	58.6	58.6	58.4	58.42	177590.0
2011-07-11 08:00:00	QQQ	ETF	58.54	58.54	58.38	58.4	2051661.0
2011-07-11 08:30:00	QQQ	ETF	58.41	58.52	58.41	58.45	628254.0
2011-07-11 09:00:00	QQQ	ETF	58.45	58.49	58.37	58.41	600314.0
2011-07-11 09:30:00	QQQ	ETF	58.41	58.71	58.4	58.58	6587301.0
2011-07-11 10:00:00	QQQ	ETF	58.58	58.62	58.29	58.35	6038837.0
2011-07-11 10:30:00	QQQ	ETF	58.34	58.375	58.08	58.0826	5281246.0
2011-07-11 11:00:00	QQQ	ETF	58.09	58.14	57.95	58.13	3937785.0
2011-07-11 11:30:00	QQQ	ETF	58.13	58.2	58.055	58.12	2630472.0
2011-07-11 12:00:00	QQQ	ETF	58.1101	58.13	57.99	58.085	1538438.0
2011-07-11 12:30:00	QQQ	ETF	58.09	58.1	57.95	58.0	950112.0
2011-07-11 13:00:00	QQQ	ETF	58.0	58.0284	57.84	57.92	1491114.0
2011-07-11 13:30:00	QQQ	ETF	57.92	58.01	57.87	58.008	1821200.0
2011-07-11 14:00:00	QQQ	ETF	58.0	58.03	57.84	57.8722	1853031.0

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

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