PREVIEW / etf_30min / 2011-04-19

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-19.parquet
  size:    279 KB
  rows:    9,187

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-04-19 04:00:00	SPY	ETF	130.34	130.34	130.24	130.3	1099.0
2011-04-19 04:30:00	SPY	ETF	130.31	130.35	130.31	130.34	1800.0
2011-04-19 05:00:00	SPY	ETF	130.35	130.44	130.35	130.42	2160.0
2011-04-19 05:30:00	SPY	ETF	130.47	130.59	130.47	130.59	4183.0
2011-04-19 06:00:00	SPY	ETF	130.59	130.59	130.42	130.45	21083.0
2011-04-19 06:30:00	SPY	ETF	130.41	130.51	130.41	130.49	10400.0
2011-04-19 07:00:00	SPY	ETF	130.55	130.71	130.53	130.63	128050.0
2011-04-19 07:30:00	SPY	ETF	130.66	130.81	130.64	130.75	478833.0
2011-04-19 08:00:00	SPY	ETF	130.72	130.86	130.62	130.68	1069764.0
2011-04-19 08:30:00	SPY	ETF	130.79	130.91	130.73	130.76	1077415.0
2011-04-19 09:00:00	SPY	ETF	130.76	130.82	130.53	130.76	668578.0
2011-04-19 09:30:00	SPY	ETF	130.76	131.07	130.61	130.79	18244404.0
2011-04-19 10:00:00	SPY	ETF	130.8	131.03	130.63	130.96	9829482.0
2011-04-19 10:30:00	SPY	ETF	130.95	130.96	130.65	130.68	10107694.0
2011-04-19 11:00:00	SPY	ETF	130.68	130.725	130.44	130.5	9679359.0
2011-04-19 11:30:00	SPY	ETF	130.5	130.68	130.47	130.65	5741697.0
2011-04-19 12:00:00	SPY	ETF	130.66	130.78	130.6	130.7	3980335.0
2011-04-19 12:30:00	SPY	ETF	130.7	130.81	130.66	130.75	5365376.0
2011-04-19 13:00:00	SPY	ETF	130.75	131.01	130.745	130.95	8844912.0
2011-04-19 13:30:00	SPY	ETF	130.96	131.22	130.925	131.12	10563298.0
2011-04-19 14:00:00	SPY	ETF	131.12	131.23	131.05	131.09	4830730.0
2011-04-19 14:30:00	SPY	ETF	131.09	131.23	131.04	131.1	3914069.0
2011-04-19 15:00:00	SPY	ETF	131.09	131.29	131.09	131.1501	5452054.0
2011-04-19 15:30:00	SPY	ETF	131.16	131.35	131.12	131.29	14113289.0
2011-04-19 16:00:00	SPY	ETF	131.28	131.75	130.5801	131.47	7523005.0
2011-04-19 16:30:00	SPY	ETF	131.46	131.72	131.29	131.55	1413877.0
2011-04-19 17:00:00	SPY	ETF	131.56	131.84	131.51	131.75	371985.0
2011-04-19 17:30:00	SPY	ETF	131.8	131.83	131.7	131.75	102565.0
2011-04-19 18:00:00	SPY	ETF	131.76	131.82	131.71	131.71	60785.0
2011-04-19 18:30:00	SPY	ETF	131.71	131.77	131.69	131.69	28928.0
2011-04-19 19:00:00	SPY	ETF	131.7	131.78	131.7	131.76	31064.0
2011-04-19 19:30:00	SPY	ETF	131.77	131.81	131.74	131.79	36932.0
2011-04-19 06:00:00	QQQ	ETF	56.29	56.29	56.29	56.29	100.0
2011-04-19 06:30:00	QQQ	ETF	56.26	56.26	56.26	56.26	400.0
2011-04-19 07:00:00	QQQ	ETF	56.27	56.37	56.27	56.37	12122.0
2011-04-19 07:30:00	QQQ	ETF	56.36	56.4	56.35	56.38	44588.0
2011-04-19 08:00:00	QQQ	ETF	56.34	56.42	56.33	56.34	108074.0
2011-04-19 08:30:00	QQQ	ETF	56.45	56.45	56.38	56.4	182695.0
2011-04-19 09:00:00	QQQ	ETF	56.4	56.4	56.37	56.38	153323.0
2011-04-19 09:30:00	QQQ	ETF	56.39	56.46	56.2313	56.3	4125565.0
2011-04-19 10:00:00	QQQ	ETF	56.3	56.41	56.23	56.37	2564776.0
2011-04-19 10:30:00	QQQ	ETF	56.37	56.38	56.17	56.21	2737469.0
2011-04-19 11:00:00	QQQ	ETF	56.21	56.27	56.1	56.14	1996845.0
2011-04-19 11:30:00	QQQ	ETF	56.1313	56.22	56.12	56.19	1066283.0
2011-04-19 12:00:00	QQQ	ETF	56.191	56.24	56.14	56.21	1094159.0
2011-04-19 12:30:00	QQQ	ETF	56.2	56.27	56.19	56.23	857354.0
2011-04-19 13:00:00	QQQ	ETF	56.22	56.37	56.22	56.34	1997779.0
2011-04-19 13:30:00	QQQ	ETF	56.345	56.47	56.33	56.41	2330020.0
2011-04-19 14:00:00	QQQ	ETF	56.41	56.42	56.34	56.35	1537380.0
2011-04-19 14:30:00	QQQ	ETF	56.35	56.46	56.33	56.43	1296458.0

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

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