PREVIEW / etf_30min / 2011-04-13

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-13.parquet
  size:    278 KB
  rows:    9,202

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-13 04:00:00	SPY	ETF	131.65	131.79	131.65	131.79	500.0
2011-04-13 04:30:00	SPY	ETF	131.79	131.9	131.79	131.87	5350.0
2011-04-13 05:00:00	SPY	ETF	131.77	131.8	131.77	131.8	12200.0
2011-04-13 05:30:00	SPY	ETF	131.82	131.98	131.82	131.98	1875.0
2011-04-13 06:00:00	SPY	ETF	131.98	132.07	131.95	131.97	3350.0
2011-04-13 06:30:00	SPY	ETF	132.0	132.08	131.96	132.06	108000.0
2011-04-13 07:00:00	SPY	ETF	132.06	132.27	131.88	132.22	473942.0
2011-04-13 07:30:00	SPY	ETF	132.21	132.29	132.08	132.16	1009140.0
2011-04-13 08:00:00	SPY	ETF	132.15	132.18	132.0	132.11	915193.0
2011-04-13 08:30:00	SPY	ETF	132.1	132.29	132.08	132.21	920115.0
2011-04-13 09:00:00	SPY	ETF	132.21	132.21	132.04	132.07	1213067.0
2011-04-13 09:30:00	SPY	ETF	132.08	132.18	131.74	131.78	18584594.0
2011-04-13 10:00:00	SPY	ETF	131.77	131.84	131.53	131.82	13735780.0
2011-04-13 10:30:00	SPY	ETF	131.82	132.06	131.67	131.97	11574770.0
2011-04-13 11:00:00	SPY	ETF	131.98	131.98	131.57	131.61	6915467.0
2011-04-13 11:30:00	SPY	ETF	131.61	131.7	131.25	131.27	9947250.0
2011-04-13 12:00:00	SPY	ETF	131.28	131.5	131.25	131.35	6767737.0
2011-04-13 12:30:00	SPY	ETF	131.36	131.36	130.96	131.18	10056682.0
2011-04-13 13:00:00	SPY	ETF	131.17	131.38	131.15	131.31	5809764.0
2011-04-13 13:30:00	SPY	ETF	131.31	131.32	131.05	131.14	6341635.0
2011-04-13 14:00:00	SPY	ETF	131.14	131.5	131.05	131.44	8890451.0
2011-04-13 14:30:00	SPY	ETF	131.43	131.65	131.34	131.58	8789564.0
2011-04-13 15:00:00	SPY	ETF	131.58	131.81	131.5701	131.645	15358375.0
2011-04-13 15:30:00	SPY	ETF	131.65	131.79	131.44	131.46	14759592.0
2011-04-13 16:00:00	SPY	ETF	131.46	131.5015	131.28	131.36	11534225.0
2011-04-13 16:30:00	SPY	ETF	131.37	131.4	131.28	131.29	7430122.0
2011-04-13 17:00:00	SPY	ETF	131.29	131.33	131.21	131.27	135462.0
2011-04-13 17:30:00	SPY	ETF	131.28	131.33	131.26	131.27	24976.0
2011-04-13 18:00:00	SPY	ETF	131.26	131.49	131.25	131.29	38003.0
2011-04-13 18:30:00	SPY	ETF	131.29	131.29	131.07	131.12	109547.0
2011-04-13 19:00:00	SPY	ETF	131.12	131.14	131.04	131.05	21820.0
2011-04-13 19:30:00	SPY	ETF	131.08	131.21	131.05	131.19	73654.0
2011-04-13 04:00:00	QQQ	ETF	56.52	56.52	56.52	56.52	200.0
2011-04-13 04:30:00	QQQ	ETF	56.58	56.58	56.58	56.58	642.0
2011-04-13 05:00:00	QQQ	ETF	56.58	56.58	56.57	56.57	200.0
2011-04-13 05:30:00	QQQ	ETF	56.63	56.63	56.63	56.63	100.0
2011-04-13 06:00:00	QQQ	ETF	56.65	56.72	56.65	56.72	4500.0
2011-04-13 06:30:00	QQQ	ETF	56.7	56.72	56.7	56.72	11364.0
2011-04-13 07:00:00	QQQ	ETF	56.68	56.86	56.67	56.83	209526.0
2011-04-13 07:30:00	QQQ	ETF	56.83	56.87	56.77	56.8	41643.0
2011-04-13 08:00:00	QQQ	ETF	56.79	56.82	56.76	56.78	119615.0
2011-04-13 08:30:00	QQQ	ETF	56.79	56.84	56.79	56.79	212008.0
2011-04-13 09:00:00	QQQ	ETF	56.78	56.79	56.72	56.77	262529.0
2011-04-13 09:30:00	QQQ	ETF	56.77	56.83	56.67	56.7	5253937.0
2011-04-13 10:00:00	QQQ	ETF	56.69	56.8	56.58	56.78	4084991.0
2011-04-13 10:30:00	QQQ	ETF	56.7775	57.0	56.73	56.97	4241685.0
2011-04-13 11:00:00	QQQ	ETF	56.97	56.9799	56.81	56.84	2134555.0
2011-04-13 11:30:00	QQQ	ETF	56.83	56.8629	56.58	56.59	2540464.0
2011-04-13 12:00:00	QQQ	ETF	56.59	56.7287	56.57	56.66	1860200.0
2011-04-13 12:30:00	QQQ	ETF	56.66	56.66	56.4	56.54	2919484.0

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

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