PREVIEW / etf_30min / 2012-09-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-06.parquet
  size:    298 KB
  rows:    10,151

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-09-06 04:00:00	SPY	ETF	141.3	141.96	141.3	141.9	35540.0
2012-09-06 04:30:00	SPY	ETF	141.85	141.96	141.85	141.91	11900.0
2012-09-06 05:00:00	SPY	ETF	141.87	141.95	141.87	141.9	3992.0
2012-09-06 05:30:00	SPY	ETF	141.82	141.85	141.8	141.8	60250.0
2012-09-06 06:00:00	SPY	ETF	141.8	141.83	141.78	141.81	56194.0
2012-09-06 06:30:00	SPY	ETF	141.84	141.92	141.73	141.76	128560.0
2012-09-06 07:00:00	SPY	ETF	141.79	141.82	141.68	141.7	284543.0
2012-09-06 07:30:00	SPY	ETF	141.69	141.8	141.5	141.76	393017.0
2012-09-06 08:00:00	SPY	ETF	141.75	141.92	141.65	141.9	805903.0
2012-09-06 08:30:00	SPY	ETF	141.87	142.06	141.38	141.63	3471453.0
2012-09-06 09:00:00	SPY	ETF	141.63	141.91	141.62	141.75	1513195.0
2012-09-06 09:30:00	SPY	ETF	141.76	142.57	141.75	142.5038	19351002.0
2012-09-06 10:00:00	SPY	ETF	142.51	143.02	142.51	143.0	15415548.0
2012-09-06 10:30:00	SPY	ETF	143.0	143.52	142.99	143.49	15651121.0
2012-09-06 11:00:00	SPY	ETF	143.48	143.55	143.27	143.39	10207117.0
2012-09-06 11:30:00	SPY	ETF	143.39	143.66	143.38	143.57	8517121.0
2012-09-06 12:00:00	SPY	ETF	143.56	143.71	143.5	143.58	4940263.0
2012-09-06 12:30:00	SPY	ETF	143.58	143.7	143.55	143.62	3420029.0
2012-09-06 13:00:00	SPY	ETF	143.63	143.65	143.52	143.55	3382006.0
2012-09-06 13:30:00	SPY	ETF	143.5401	143.68	143.52	143.64	5020832.0
2012-09-06 14:00:00	SPY	ETF	143.63	143.67	143.47	143.58	5854344.0
2012-09-06 14:30:00	SPY	ETF	143.57	143.71	143.53	143.59	6095486.0
2012-09-06 15:00:00	SPY	ETF	143.58	143.58	143.385	143.48	12561739.0
2012-09-06 15:30:00	SPY	ETF	143.48	143.78	143.47	143.74	21214508.0
2012-09-06 16:00:00	SPY	ETF	143.73	143.87	140.9025	143.75	5194789.0
2012-09-06 16:30:00	SPY	ETF	143.76	143.88	143.76	143.88	8426185.0
2012-09-06 17:00:00	SPY	ETF	143.89	143.93	143.87	143.89	264239.0
2012-09-06 17:30:00	SPY	ETF	143.78	143.92	143.77	143.8	131120.0
2012-09-06 18:00:00	SPY	ETF	143.81	143.83	143.78	143.78	125878.0
2012-09-06 18:30:00	SPY	ETF	143.78	143.81	143.75	143.75	109235.0
2012-09-06 19:00:00	SPY	ETF	143.75	143.82	143.74	143.77	33145.0
2012-09-06 19:30:00	SPY	ETF	143.79	143.82	143.78	143.81	32640.0
2012-09-06 04:00:00	QQQ	ETF	68.33	68.45	68.33	68.45	1400.0
2012-09-06 04:30:00	QQQ	ETF	68.45	68.45	68.45	68.45	273.0
2012-09-06 05:30:00	QQQ	ETF	68.41	68.41	68.41	68.41	100.0
2012-09-06 06:00:00	QQQ	ETF	68.4	68.4	68.4	68.4	200.0
2012-09-06 06:30:00	QQQ	ETF	68.42	68.44	68.42	68.44	1300.0
2012-09-06 07:00:00	QQQ	ETF	68.41	68.41	68.37	68.39	38967.0
2012-09-06 07:30:00	QQQ	ETF	68.36	68.38	68.26	68.37	25715.0
2012-09-06 08:00:00	QQQ	ETF	68.36	68.48	68.33	68.42	171475.0
2012-09-06 08:30:00	QQQ	ETF	68.38	68.46	68.2	68.34	530796.0
2012-09-06 09:00:00	QQQ	ETF	68.32	68.47	68.32	68.41	598195.0
2012-09-06 09:30:00	QQQ	ETF	68.42	68.82	68.42	68.81	5916118.0
2012-09-06 10:00:00	QQQ	ETF	68.82	69.12	68.815	69.1	5079132.0
2012-09-06 10:30:00	QQQ	ETF	69.1	69.27	69.08	69.253	3531567.0
2012-09-06 11:00:00	QQQ	ETF	69.26	69.29	69.17	69.2599	3301271.0
2012-09-06 11:30:00	QQQ	ETF	69.26	69.4	69.25	69.37	2575265.0
2012-09-06 12:00:00	QQQ	ETF	69.371	69.48	69.365	69.42	1525511.0
2012-09-06 12:30:00	QQQ	ETF	69.42	69.45	69.38	69.4099	886558.0
2012-09-06 13:00:00	QQQ	ETF	69.4	69.45	69.37	69.43	826338.0

> showing 50 of 10,151 rows — these rows as CSV

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