PREVIEW / etf_30min / 2012-04-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-17.parquet
  size:    281 KB
  rows:    9,448

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
2012-04-17 04:00:00	SPY	ETF	137.23	137.29	137.17	137.26	4200.0
2012-04-17 04:30:00	SPY	ETF	137.29	137.46	137.29	137.46	4600.0
2012-04-17 05:00:00	SPY	ETF	137.47	137.65	137.47	137.52	11300.0
2012-04-17 05:30:00	SPY	ETF	137.54	137.71	137.44	137.44	44050.0
2012-04-17 06:00:00	SPY	ETF	137.45	137.53	137.44	137.5	46500.0
2012-04-17 06:30:00	SPY	ETF	137.56	137.78	137.56	137.66	149130.0
2012-04-17 07:00:00	SPY	ETF	137.62	137.85	137.6	137.8	284324.0
2012-04-17 07:30:00	SPY	ETF	137.81	137.83	137.54	137.59	377079.0
2012-04-17 08:00:00	SPY	ETF	137.6	137.78	136.975	137.69	940618.0
2012-04-17 08:30:00	SPY	ETF	137.66	137.81	137.5	137.79	993212.0
2012-04-17 09:00:00	SPY	ETF	137.78	137.98	137.75	137.84	1570428.0
2012-04-17 09:30:00	SPY	ETF	137.84	138.15	137.8	137.95	17697150.0
2012-04-17 10:00:00	SPY	ETF	137.94	138.4	137.698	138.34	14956785.0
2012-04-17 10:30:00	SPY	ETF	138.34	138.65	138.3	138.578	9347508.0
2012-04-17 11:00:00	SPY	ETF	138.58	138.93	138.58	138.79	12999842.0
2012-04-17 11:30:00	SPY	ETF	138.788	138.86	138.71	138.82	5317749.0
2012-04-17 12:00:00	SPY	ETF	138.82	139.07	138.82	139.045	6352239.0
2012-04-17 12:30:00	SPY	ETF	139.05	139.2	139.04	139.1	5969706.0
2012-04-17 13:00:00	SPY	ETF	139.11	139.16	139.06	139.15	3591068.0
2012-04-17 13:30:00	SPY	ETF	139.15	139.25	139.09	139.172	4830101.0
2012-04-17 14:00:00	SPY	ETF	139.18	139.3	139.17	139.29	4917788.0
2012-04-17 14:30:00	SPY	ETF	139.28	139.36	139.12	139.23	7972301.0
2012-04-17 15:00:00	SPY	ETF	139.23	139.35	139.11	139.34	6964772.0
2012-04-17 15:30:00	SPY	ETF	139.34	139.34	139.06	139.09	19893976.0
2012-04-17 16:00:00	SPY	ETF	139.08	139.1791	137.02	138.88	15044941.0
2012-04-17 16:30:00	SPY	ETF	138.88	139.1396	138.81	138.85	1669967.0
2012-04-17 17:00:00	SPY	ETF	138.83	138.9	138.79	138.83	134386.0
2012-04-17 17:30:00	SPY	ETF	139.1398	139.1398	138.78	138.84	3768200.0
2012-04-17 18:00:00	SPY	ETF	138.82	138.92	138.81	138.92	142648.0
2012-04-17 18:30:00	SPY	ETF	138.93	138.93	138.85	138.89	27390.0
2012-04-17 19:00:00	SPY	ETF	138.87	138.96	138.87	138.96	13300.0
2012-04-17 19:30:00	SPY	ETF	138.92	138.98	138.92	138.98	67171.0
2012-04-17 05:00:00	QQQ	ETF	65.7	65.7	65.66	65.66	40100.0
2012-04-17 05:30:00	QQQ	ETF	65.7	65.72	65.7	65.72	20000.0
2012-04-17 06:00:00	QQQ	ETF	65.65	65.65	65.65	65.65	100.0
2012-04-17 06:30:00	QQQ	ETF	65.7	65.7	65.7	65.7	200.0
2012-04-17 07:00:00	QQQ	ETF	65.69	65.73	65.66	65.73	28000.0
2012-04-17 07:30:00	QQQ	ETF	65.72	65.72	65.63	65.63	33150.0
2012-04-17 08:00:00	QQQ	ETF	65.72	65.75	65.63	65.73	274544.0
2012-04-17 08:30:00	QQQ	ETF	65.73	65.8	65.6	65.76	543114.0
2012-04-17 09:00:00	QQQ	ETF	65.77	65.81	65.47	65.75	336417.0
2012-04-17 09:30:00	QQQ	ETF	65.75	66.12	65.63	66.08	6691546.0
2012-04-17 10:00:00	QQQ	ETF	66.09	66.3	65.95	66.2463	4233159.0
2012-04-17 10:30:00	QQQ	ETF	66.25	66.4	66.172	66.36	2367290.0
2012-04-17 11:00:00	QQQ	ETF	66.362	66.58	66.36	66.48	3793786.0
2012-04-17 11:30:00	QQQ	ETF	66.485	66.56	66.45	66.52	2411658.0
2012-04-17 12:00:00	QQQ	ETF	66.51	66.68	66.51	66.6601	2676910.0
2012-04-17 12:30:00	QQQ	ETF	66.67	66.8	66.66	66.749	2629768.0
2012-04-17 13:00:00	QQQ	ETF	66.75	66.795	66.69	66.795	1331880.0
2012-04-17 13:30:00	QQQ	ETF	66.79	66.87	66.77	66.835	2445757.0

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

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