PREVIEW / etf_30min / 2011-04-15

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-15.parquet
  size:    271 KB
  rows:    9,095

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-15 04:00:00	SPY	ETF	131.15	131.22	131.1	131.17	5383.0
2011-04-15 04:30:00	SPY	ETF	131.17	131.2	131.15	131.2	2500.0
2011-04-15 05:00:00	SPY	ETF	131.18	131.18	131.05	131.1	18200.0
2011-04-15 05:30:00	SPY	ETF	131.17	131.26	131.17	131.26	6000.0
2011-04-15 06:00:00	SPY	ETF	131.28	131.3	131.25	131.25	6300.0
2011-04-15 06:30:00	SPY	ETF	131.25	131.33	131.25	131.3	16605.0
2011-04-15 07:00:00	SPY	ETF	131.28	131.36	131.18	131.32	122147.0
2011-04-15 07:30:00	SPY	ETF	131.3	131.3	131.2	131.23	157442.0
2011-04-15 08:00:00	SPY	ETF	131.23	131.23	131.07	131.1	387612.0
2011-04-15 08:30:00	SPY	ETF	131.1	131.52	131.1	131.44	1576924.0
2011-04-15 09:00:00	SPY	ETF	131.44	131.87	131.41	131.8	1494998.0
2011-04-15 09:30:00	SPY	ETF	131.8	131.93	131.41	131.77	20990279.0
2011-04-15 10:00:00	SPY	ETF	131.77	132.08	131.67	131.775	13637307.0
2011-04-15 10:30:00	SPY	ETF	131.775	131.91	131.51	131.82	11869779.0
2011-04-15 11:00:00	SPY	ETF	131.83	131.98	131.66	131.98	8461649.0
2011-04-15 11:30:00	SPY	ETF	131.98	132.06	131.93	131.965	4613660.0
2011-04-15 12:00:00	SPY	ETF	131.97	132.29	131.97	132.19	9684102.0
2011-04-15 12:30:00	SPY	ETF	132.19	132.32	132.15	132.319	5526013.0
2011-04-15 13:00:00	SPY	ETF	132.32	132.37	132.12	132.13	5774372.0
2011-04-15 13:30:00	SPY	ETF	132.13	132.21	132.09	132.11	3911668.0
2011-04-15 14:00:00	SPY	ETF	132.11	132.23	132.09	132.19	4510567.0
2011-04-15 14:30:00	SPY	ETF	132.18	132.26	131.5134	132.19	7634371.0
2011-04-15 15:00:00	SPY	ETF	132.19	132.22	131.87	132.0	11107885.0
2011-04-15 15:30:00	SPY	ETF	132.0	132.08	131.88	132.05	24285112.0
2011-04-15 16:00:00	SPY	ETF	132.05	132.37	131.5134	132.31	15609070.0
2011-04-15 16:30:00	SPY	ETF	132.32	132.32	131.9292	131.99	8028503.0
2011-04-15 17:00:00	SPY	ETF	132.0	132.01	131.5134	131.97	3209582.0
2011-04-15 17:30:00	SPY	ETF	131.97	132.0639	131.95	132.0	3220932.0
2011-04-15 18:00:00	SPY	ETF	132.12	132.12	132.04	132.08	97386.0
2011-04-15 18:30:00	SPY	ETF	132.08	132.15	132.03	132.15	101200.0
2011-04-15 19:00:00	SPY	ETF	132.16	132.2	132.15	132.2	24695.0
2011-04-15 19:30:00	SPY	ETF	132.18	132.2	132.1	132.17	29914.0
2011-04-15 05:00:00	QQQ	ETF	56.42	56.42	56.42	56.42	400.0
2011-04-15 05:30:00	QQQ	ETF	56.44	56.45	56.42	56.45	6439.0
2011-04-15 06:30:00	QQQ	ETF	56.52	56.53	56.52	56.53	300.0
2011-04-15 07:00:00	QQQ	ETF	56.5	56.54	56.48	56.48	53520.0
2011-04-15 07:30:00	QQQ	ETF	56.49	56.49	56.47	56.49	13687.0
2011-04-15 08:00:00	QQQ	ETF	56.49	56.49	56.38	56.41	264226.0
2011-04-15 08:30:00	QQQ	ETF	56.4	56.52	56.39	56.5	146674.0
2011-04-15 09:00:00	QQQ	ETF	56.5	56.65	56.48	56.53	848651.0
2011-04-15 09:30:00	QQQ	ETF	56.53	56.59	56.28	56.43	9217473.0
2011-04-15 10:00:00	QQQ	ETF	56.43	56.63	56.425	56.52	5367203.0
2011-04-15 10:30:00	QQQ	ETF	56.53	56.63	56.43	56.59	6886777.0
2011-04-15 11:00:00	QQQ	ETF	56.59	56.71	56.56	56.71	2222737.0
2011-04-15 11:30:00	QQQ	ETF	56.71	56.741	56.64	56.65	1579552.0
2011-04-15 12:00:00	QQQ	ETF	56.65	56.77	56.65	56.73	1925955.0
2011-04-15 12:30:00	QQQ	ETF	56.73	56.85	56.73	56.83	5452137.0
2011-04-15 13:00:00	QQQ	ETF	56.83	56.87	56.71	56.72	4631208.0
2011-04-15 13:30:00	QQQ	ETF	56.71	56.73	56.68	56.69	1853043.0
2011-04-15 14:00:00	QQQ	ETF	56.69	56.74	56.67	56.73	1450507.0

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

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