PREVIEW / etf_30min / 2013-01-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-22.parquet
  size:    314 KB
  rows:    10,713

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
2013-01-22 04:00:00	SPY	ETF	148.2	148.2	147.94	148.05	11821.0
2013-01-22 04:30:00	SPY	ETF	148.04	148.18	148.04	148.11	6200.0
2013-01-22 05:00:00	SPY	ETF	148.18	148.45	148.14	148.42	45300.0
2013-01-22 05:30:00	SPY	ETF	148.43	148.48	148.36	148.37	23411.0
2013-01-22 06:00:00	SPY	ETF	148.49	148.49	148.29	148.29	67485.0
2013-01-22 06:30:00	SPY	ETF	148.29	148.33	148.15	148.31	92016.0
2013-01-22 07:00:00	SPY	ETF	148.27	148.41	148.25	148.38	70107.0
2013-01-22 07:30:00	SPY	ETF	148.39	148.39	148.14	148.19	177442.0
2013-01-22 08:00:00	SPY	ETF	148.18	148.51	148.05	148.14	424232.0
2013-01-22 08:30:00	SPY	ETF	148.14	148.24	148.09	148.22	221959.0
2013-01-22 09:00:00	SPY	ETF	148.23	148.35	148.22	148.34	553737.0
2013-01-22 09:30:00	SPY	ETF	148.33	148.54	148.25	148.41	12986825.0
2013-01-22 10:00:00	SPY	ETF	148.42	148.42	148.02	148.0399	10226114.0
2013-01-22 10:30:00	SPY	ETF	148.04	148.484	147.98	148.27	8156288.0
2013-01-22 11:00:00	SPY	ETF	148.26	148.4	148.14	148.36	4448580.0
2013-01-22 11:30:00	SPY	ETF	148.37	148.49	148.25	148.445	5608435.0
2013-01-22 12:00:00	SPY	ETF	148.44	148.67	148.43	148.64	5451786.0
2013-01-22 12:30:00	SPY	ETF	148.64	148.77	148.61	148.62	4091625.0
2013-01-22 13:00:00	SPY	ETF	148.6201	148.84	148.61	148.75	2977479.0
2013-01-22 13:30:00	SPY	ETF	148.75	148.82	148.7	148.71	5515177.0
2013-01-22 14:00:00	SPY	ETF	148.71	148.9	148.68	148.87	3594053.0
2013-01-22 14:30:00	SPY	ETF	148.88	149.02	148.85	149.0	5379447.0
2013-01-22 15:00:00	SPY	ETF	149.0	149.0	148.81	148.94	4966978.0
2013-01-22 15:30:00	SPY	ETF	148.95	149.13	148.86	149.0901	13034246.0
2013-01-22 16:00:00	SPY	ETF	149.09	149.39	148.1883	149.31	12636736.0
2013-01-22 16:30:00	SPY	ETF	149.33	149.38	149.2602	149.37	2769300.0
2013-01-22 17:00:00	SPY	ETF	149.38	149.5	148.0983	149.42	2802050.0
2013-01-22 17:30:00	SPY	ETF	149.41	149.46	149.4	149.45	56854.0
2013-01-22 18:00:00	SPY	ETF	149.44	149.49	149.41	149.41	47973.0
2013-01-22 18:30:00	SPY	ETF	149.41	149.46	149.36	149.38	37199.0
2013-01-22 19:00:00	SPY	ETF	149.38	149.43	149.34	149.43	15429.0
2013-01-22 19:30:00	SPY	ETF	149.41	149.42	149.37	149.42	16738.0
2013-01-22 04:30:00	QQQ	ETF	66.94	66.94	66.94	66.94	100.0
2013-01-22 05:00:00	QQQ	ETF	66.98	67.1	66.98	67.1	500.0
2013-01-22 05:30:00	QQQ	ETF	67.2	67.2	67.2	67.2	200.0
2013-01-22 06:30:00	QQQ	ETF	67.1	67.1	67.1	67.1	200.0
2013-01-22 07:00:00	QQQ	ETF	67.1	67.18	67.1	67.16	10429.0
2013-01-22 07:30:00	QQQ	ETF	67.14	67.16	67.07	67.07	2200.0
2013-01-22 08:00:00	QQQ	ETF	67.09	67.14	67.0	67.05	18581.0
2013-01-22 08:30:00	QQQ	ETF	67.06	67.15	67.02	67.14	152211.0
2013-01-22 09:00:00	QQQ	ETF	67.14	67.17	67.11	67.15	94186.0
2013-01-22 09:30:00	QQQ	ETF	67.15	67.23	66.985	67.04	3738183.0
2013-01-22 10:00:00	QQQ	ETF	67.03	67.03	66.81	66.81	2763535.0
2013-01-22 10:30:00	QQQ	ETF	66.81	66.86	66.76	66.86	2472361.0
2013-01-22 11:00:00	QQQ	ETF	66.85	66.89	66.775	66.84	1533806.0
2013-01-22 11:30:00	QQQ	ETF	66.83	66.86	66.73	66.83	2035405.0
2013-01-22 12:00:00	QQQ	ETF	66.83	66.95	66.82	66.93	1520404.0
2013-01-22 12:30:00	QQQ	ETF	66.93	66.99	66.88	66.894	1041548.0
2013-01-22 13:00:00	QQQ	ETF	66.89	67.01	66.89	66.98	1433875.0
2013-01-22 13:30:00	QQQ	ETF	66.98	67.01	66.94	66.97	1360274.0

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

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