PREVIEW / etf_30min / 2013-01-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-18.parquet
  size:    299 KB
  rows:    10,212

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-18 04:00:00	SPY	ETF	148.16	148.16	147.93	147.98	450.0
2013-01-18 04:30:00	SPY	ETF	148.0	148.0	148.0	148.0	1000.0
2013-01-18 05:00:00	SPY	ETF	147.96	147.96	147.91	147.91	2791.0
2013-01-18 06:00:00	SPY	ETF	148.02	148.03	147.91	147.91	18769.0
2013-01-18 06:30:00	SPY	ETF	147.91	147.95	147.88	147.95	22150.0
2013-01-18 07:00:00	SPY	ETF	147.91	147.98	147.8	147.89	169297.0
2013-01-18 07:30:00	SPY	ETF	147.89	148.06	147.89	147.93	77859.0
2013-01-18 08:00:00	SPY	ETF	147.94	148.12	147.84	148.09	555246.0
2013-01-18 08:30:00	SPY	ETF	148.08	148.08	147.98	148.0	197953.0
2013-01-18 09:00:00	SPY	ETF	148.0	148.09	147.93	147.97	1004395.0
2013-01-18 09:30:00	SPY	ETF	147.97	148.07	147.69	147.87	14004715.0
2013-01-18 10:00:00	SPY	ETF	147.87	147.9754	147.73	147.81	12370326.0
2013-01-18 10:30:00	SPY	ETF	147.805	147.9754	147.67	147.69	8456999.0
2013-01-18 11:00:00	SPY	ETF	147.685	147.8	147.49	147.7	37706051.0
2013-01-18 11:30:00	SPY	ETF	147.7	147.9754	147.43	147.55	7734388.0
2013-01-18 12:00:00	SPY	ETF	147.54	147.62	147.54	147.595	3438603.0
2013-01-18 12:30:00	SPY	ETF	147.595	147.86	147.57	147.81	6116242.0
2013-01-18 13:00:00	SPY	ETF	147.82	148.06	147.81	147.96	8693601.0
2013-01-18 13:30:00	SPY	ETF	147.9561	148.02	147.92	147.965	2946966.0
2013-01-18 14:00:00	SPY	ETF	147.965	148.04	147.94	148.03	2703555.0
2013-01-18 14:30:00	SPY	ETF	148.03	148.13	148.0	148.01	5355342.0
2013-01-18 15:00:00	SPY	ETF	148.01	148.08	147.97	148.08	5731857.0
2013-01-18 15:30:00	SPY	ETF	148.08	148.49	148.07	148.33	28832421.0
2013-01-18 16:00:00	SPY	ETF	148.33	148.4831	147.84	148.22	7944111.0
2013-01-18 16:30:00	SPY	ETF	148.24	148.35	148.23	148.29	5205956.0
2013-01-18 17:00:00	SPY	ETF	148.29	148.42	148.28	148.42	295907.0
2013-01-18 17:30:00	SPY	ETF	148.42	148.48	147.9755	148.44	6771611.0
2013-01-18 18:00:00	SPY	ETF	148.43	148.44	148.37	148.4	8801.0
2013-01-18 18:30:00	SPY	ETF	148.4	148.41	148.38	148.4	3018.0
2013-01-18 19:00:00	SPY	ETF	148.4	148.41	148.32	148.35	24973.0
2013-01-18 19:30:00	SPY	ETF	148.35	148.35	148.32	148.35	18385.0
2013-01-18 06:00:00	QQQ	ETF	67.11	67.12	67.11	67.12	344.0
2013-01-18 06:30:00	QQQ	ETF	67.03	67.03	67.03	67.03	1600.0
2013-01-18 07:00:00	QQQ	ETF	67.02	67.02	66.95	66.95	9800.0
2013-01-18 07:30:00	QQQ	ETF	67.0	67.05	67.0	67.02	36358.0
2013-01-18 08:00:00	QQQ	ETF	67.05	67.06	66.99	67.04	51556.0
2013-01-18 08:30:00	QQQ	ETF	67.02	67.04	67.0	67.02	104096.0
2013-01-18 09:00:00	QQQ	ETF	67.22	67.22	66.98	67.0	107103.0
2013-01-18 09:30:00	QQQ	ETF	67.0	67.14	66.88	67.07	4249876.0
2013-01-18 10:00:00	QQQ	ETF	67.07	67.1	66.98	67.02	2693688.0
2013-01-18 10:30:00	QQQ	ETF	67.02	67.03	66.88	66.91	2647488.0
2013-01-18 11:00:00	QQQ	ETF	66.91	66.921	66.79	66.8599	3656560.0
2013-01-18 11:30:00	QQQ	ETF	66.86	66.87	66.77	66.788	2233921.0
2013-01-18 12:00:00	QQQ	ETF	66.79	66.83	66.78	66.82	765670.0
2013-01-18 12:30:00	QQQ	ETF	66.8101	66.94	66.8	66.9175	1271438.0
2013-01-18 13:00:00	QQQ	ETF	66.92	67.02	66.91	66.97	1254354.0
2013-01-18 13:30:00	QQQ	ETF	66.9788	66.99	66.94	66.97	361991.0
2013-01-18 14:00:00	QQQ	ETF	66.975	66.995	66.95	66.96	473511.0
2013-01-18 14:30:00	QQQ	ETF	66.965	67.0	66.94	66.96	502464.0
2013-01-18 15:00:00	QQQ	ETF	66.96	67.0	66.92	67.0	725194.0

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

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