PREVIEW / etf_30min / 2012-03-05

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-05.parquet
  size:    288 KB
  rows:    9,683

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-03-05 04:00:00	SPY	ETF	136.8	136.8	136.58	136.64	179273.0
2012-03-05 04:30:00	SPY	ETF	136.66	136.66	136.57	136.61	28300.0
2012-03-05 05:00:00	SPY	ETF	136.72	136.77	136.71	136.77	6300.0
2012-03-05 05:30:00	SPY	ETF	136.74	136.81	136.73	136.81	3415.0
2012-03-05 06:00:00	SPY	ETF	136.76	136.76	136.76	136.76	10200.0
2012-03-05 06:30:00	SPY	ETF	136.77	136.81	136.69	136.69	32700.0
2012-03-05 07:00:00	SPY	ETF	136.7	136.83	136.66	136.79	63240.0
2012-03-05 07:30:00	SPY	ETF	136.81	136.95	136.81	136.93	85774.0
2012-03-05 08:00:00	SPY	ETF	136.95	137.2	136.95	137.16	707558.0
2012-03-05 08:30:00	SPY	ETF	137.16	137.17	137.06	137.09	297969.0
2012-03-05 09:00:00	SPY	ETF	137.07	137.15	137.03	137.09	634981.0
2012-03-05 09:30:00	SPY	ETF	137.1	137.12	136.8	136.94	12401619.0
2012-03-05 10:00:00	SPY	ETF	136.93	137.2	136.43	136.51	19430666.0
2012-03-05 10:30:00	SPY	ETF	136.5	136.73	136.42	136.61	9522686.0
2012-03-05 11:00:00	SPY	ETF	136.6	136.75	136.28	136.53	12402167.0
2012-03-05 11:30:00	SPY	ETF	136.53	136.625	136.39	136.4703	7562280.0
2012-03-05 12:00:00	SPY	ETF	136.4715	136.59	136.42	136.49	3836954.0
2012-03-05 12:30:00	SPY	ETF	136.49	136.55	136.34	136.3716	3069854.0
2012-03-05 13:00:00	SPY	ETF	136.37	136.6	136.35	136.58	4542364.0
2012-03-05 13:30:00	SPY	ETF	136.59	136.61	136.39	136.45	3859226.0
2012-03-05 14:00:00	SPY	ETF	136.45	136.71	136.45	136.68	7889881.0
2012-03-05 14:30:00	SPY	ETF	136.675	136.87	136.53	136.8	8128249.0
2012-03-05 15:00:00	SPY	ETF	136.81	136.97	136.77	136.92	7673645.0
2012-03-05 15:30:00	SPY	ETF	136.925	136.96	136.74	136.79	16103351.0
2012-03-05 16:00:00	SPY	ETF	136.78	136.93	136.679	136.88	11631434.0
2012-03-05 16:30:00	SPY	ETF	136.86	137.3362	136.7016	136.81	2755944.0
2012-03-05 17:00:00	SPY	ETF	136.81	136.83	136.76	136.78	129247.0
2012-03-05 17:30:00	SPY	ETF	136.81	136.81	136.74	136.78	44413.0
2012-03-05 18:00:00	SPY	ETF	136.8	136.89	136.8	136.8	37800.0
2012-03-05 18:30:00	SPY	ETF	136.8	136.94	136.8	136.92	45948.0
2012-03-05 19:00:00	SPY	ETF	136.94	137.03	136.91	136.93	94265.0
2012-03-05 19:30:00	SPY	ETF	136.93	136.98	136.92	136.94	46800.0
2012-03-05 04:00:00	QQQ	ETF	64.7	64.7	64.7	64.7	100.0
2012-03-05 07:00:00	QQQ	ETF	64.65	64.67	64.63	64.67	72946.0
2012-03-05 07:30:00	QQQ	ETF	64.67	64.73	64.67	64.73	45651.0
2012-03-05 08:00:00	QQQ	ETF	64.73	64.84	64.73	64.84	93776.0
2012-03-05 08:30:00	QQQ	ETF	64.84	64.86	64.8	64.81	86615.0
2012-03-05 09:00:00	QQQ	ETF	64.82	64.84	64.81	64.83	184600.0
2012-03-05 09:30:00	QQQ	ETF	64.83	64.83	64.72	64.78	3626319.0
2012-03-05 10:00:00	QQQ	ETF	64.78	64.91	64.51	64.54	5611346.0
2012-03-05 10:30:00	QQQ	ETF	64.55	64.59	64.44	64.47	3137862.0
2012-03-05 11:00:00	QQQ	ETF	64.48	64.53	63.99	64.26	7313454.0
2012-03-05 11:30:00	QQQ	ETF	64.2513	64.33	64.1585	64.24	3235177.0
2012-03-05 12:00:00	QQQ	ETF	64.24	64.33	64.05	64.12	2730808.0
2012-03-05 12:30:00	QQQ	ETF	64.115	64.185	64.06	64.12	1540425.0
2012-03-05 13:00:00	QQQ	ETF	64.12	64.24	64.0915	64.21	1980574.0
2012-03-05 13:30:00	QQQ	ETF	64.21	64.22	64.0	64.06	2107412.0
2012-03-05 14:00:00	QQQ	ETF	64.0699	64.17	64.04	64.14	2041305.0
2012-03-05 14:30:00	QQQ	ETF	64.1485	64.23	64.02	64.21	3389688.0
2012-03-05 15:00:00	QQQ	ETF	64.22	64.37	64.2015	64.31	2262821.0

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

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