PREVIEW / etf_30min / 2013-07-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-25.parquet
  size:    317 KB
  rows:    10,698

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-07-25 04:00:00	SPY	ETF	168.38	168.5	168.35	168.4	12600.0
2013-07-25 04:30:00	SPY	ETF	168.36	168.38	168.01	168.05	17700.0
2013-07-25 05:00:00	SPY	ETF	168.04	168.1	167.64	167.64	62980.0
2013-07-25 05:30:00	SPY	ETF	167.7	167.88	167.7	167.73	65000.0
2013-07-25 06:00:00	SPY	ETF	167.68	167.83	167.65	167.7	44801.0
2013-07-25 06:30:00	SPY	ETF	167.74	167.88	167.7	167.88	115280.0
2013-07-25 07:00:00	SPY	ETF	167.88	168.11	167.88	168.05	261221.0
2013-07-25 07:30:00	SPY	ETF	168.01	168.2	168.0	168.11	218425.0
2013-07-25 08:00:00	SPY	ETF	167.87	168.25	167.87	168.1	365534.0
2013-07-25 08:30:00	SPY	ETF	168.15	168.33	167.99	168.1	481988.0
2013-07-25 09:00:00	SPY	ETF	168.13	168.24	168.05	168.22	679292.0
2013-07-25 09:30:00	SPY	ETF	168.22	168.55	167.97	168.43	14345421.0
2013-07-25 10:00:00	SPY	ETF	168.43	168.67	168.43	168.465	6656732.0
2013-07-25 10:30:00	SPY	ETF	168.47	168.56	168.29	168.45	5324684.0
2013-07-25 11:00:00	SPY	ETF	168.46	168.46	167.97	168.0299	5945262.0
2013-07-25 11:30:00	SPY	ETF	168.03	168.19	167.94	168.13	5506401.0
2013-07-25 12:00:00	SPY	ETF	168.1201	168.5	168.07	168.45	4407911.0
2013-07-25 12:30:00	SPY	ETF	168.45	168.823	168.435	168.79	6226902.0
2013-07-25 13:00:00	SPY	ETF	168.79	168.86	168.675	168.77	3005277.0
2013-07-25 13:30:00	SPY	ETF	168.77	168.84	168.66	168.72	2853570.0
2013-07-25 14:00:00	SPY	ETF	168.72	168.92	168.52	168.579	5122292.0
2013-07-25 14:30:00	SPY	ETF	168.579	168.75	168.44	168.455	4381388.0
2013-07-25 15:00:00	SPY	ETF	168.45	169.01	168.44	168.85	9619334.0
2013-07-25 15:30:00	SPY	ETF	168.85	169.08	168.81	168.95	12475731.0
2013-07-25 16:00:00	SPY	ETF	168.94	168.98	168.46	168.85	8267531.0
2013-07-25 16:30:00	SPY	ETF	168.84	168.99	168.4928	168.98	7591472.0
2013-07-25 17:00:00	SPY	ETF	168.99	169.05	168.95	169.02	102237.0
2013-07-25 17:30:00	SPY	ETF	169.02	169.03	168.99	168.99	23694.0
2013-07-25 18:00:00	SPY	ETF	169.0	169.08	168.95	169.07	37677.0
2013-07-25 18:30:00	SPY	ETF	169.04	169.09	169.04	169.07	4200.0
2013-07-25 19:00:00	SPY	ETF	169.06	169.08	169.02	169.04	15055.0
2013-07-25 19:30:00	SPY	ETF	169.05	169.06	169.0	169.04	32750.0
2013-07-25 04:00:00	QQQ	ETF	74.77	74.8	74.74	74.78	12700.0
2013-07-25 04:30:00	QQQ	ETF	74.76	74.76	74.58	74.58	11400.0
2013-07-25 05:00:00	QQQ	ETF	74.56	74.58	74.38	74.38	16000.0
2013-07-25 05:30:00	QQQ	ETF	74.4	74.44	74.34	74.34	13688.0
2013-07-25 06:00:00	QQQ	ETF	74.32	74.38	74.32	74.36	6200.0
2013-07-25 06:30:00	QQQ	ETF	74.38	74.44	74.37	74.44	9700.0
2013-07-25 07:00:00	QQQ	ETF	74.46	74.71	74.46	74.71	30650.0
2013-07-25 07:30:00	QQQ	ETF	74.72	74.82	74.72	74.81	24150.0
2013-07-25 08:00:00	QQQ	ETF	74.82	74.88	74.46	74.85	428778.0
2013-07-25 08:30:00	QQQ	ETF	74.85	74.95	74.83	74.89	186220.0
2013-07-25 09:00:00	QQQ	ETF	74.89	74.96	74.82	74.89	255622.0
2013-07-25 09:30:00	QQQ	ETF	74.89	74.89	74.535	74.8	3167513.0
2013-07-25 10:00:00	QQQ	ETF	74.8	74.91	74.79	74.7999	1159327.0
2013-07-25 10:30:00	QQQ	ETF	74.8	74.83	74.71	74.73	1174740.0
2013-07-25 11:00:00	QQQ	ETF	74.74	74.74	74.46	74.5	1834883.0
2013-07-25 11:30:00	QQQ	ETF	74.51	74.619	74.47	74.571	1420314.0
2013-07-25 12:00:00	QQQ	ETF	74.58	74.8075	74.56	74.791	1476639.0
2013-07-25 12:30:00	QQQ	ETF	74.8	74.97	74.79	74.9501	954622.0

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

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