PREVIEW / etf_30min / 2014-04-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-24.parquet
  size:    329 KB
  rows:    11,230

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
2014-04-24 04:00:00	SPY	ETF	188.52	188.52	188.5	188.5	1315.0
2014-04-24 04:30:00	SPY	ETF	188.51	188.53	188.5	188.52	1527.0
2014-04-24 05:00:00	SPY	ETF	188.52	188.53	188.43	188.53	5866.0
2014-04-24 05:30:00	SPY	ETF	188.5	188.52	188.48	188.48	917.0
2014-04-24 06:00:00	SPY	ETF	188.44	188.68	188.44	188.65	18570.0
2014-04-24 06:30:00	SPY	ETF	188.65	188.69	188.58	188.58	4102.0
2014-04-24 07:00:00	SPY	ETF	188.63	188.64	188.41	188.46	89839.0
2014-04-24 07:30:00	SPY	ETF	188.48	188.67	188.41	188.46	380876.0
2014-04-24 08:00:00	SPY	ETF	188.6	188.63	188.42	188.61	266117.0
2014-04-24 08:30:00	SPY	ETF	188.6	188.79	188.51	188.52	785756.0
2014-04-24 09:00:00	SPY	ETF	188.52	188.54	188.3	188.38	1151434.0
2014-04-24 09:30:00	SPY	ETF	188.37	188.39	187.06	187.47	17646111.0
2014-04-24 10:00:00	SPY	ETF	187.48	187.72	186.93	187.7	12212488.0
2014-04-24 10:30:00	SPY	ETF	187.7	187.815	187.43	187.64	6530355.0
2014-04-24 11:00:00	SPY	ETF	187.64	188.23	187.53	188.11	6775076.0
2014-04-24 11:30:00	SPY	ETF	188.11	188.3	188.0	188.0899	4748613.0
2014-04-24 12:00:00	SPY	ETF	188.08	188.24	187.95	188.0	4571630.0
2014-04-24 12:30:00	SPY	ETF	187.995	188.2	187.96	188.17	2493268.0
2014-04-24 13:00:00	SPY	ETF	188.165	188.22	188.05	188.06	2166661.0
2014-04-24 13:30:00	SPY	ETF	188.06	188.06	187.46	187.5	6418792.0
2014-04-24 14:00:00	SPY	ETF	187.5001	187.76	187.44	187.65	4688319.0
2014-04-24 14:30:00	SPY	ETF	187.65	187.86	187.57	187.75	3362396.0
2014-04-24 15:00:00	SPY	ETF	187.74	187.96	187.72	187.81	2943255.0
2014-04-24 15:30:00	SPY	ETF	187.8001	187.9	187.67	187.82	6303121.0
2014-04-24 16:00:00	SPY	ETF	187.83	188.09	187.79	187.92	3061304.0
2014-04-24 16:30:00	SPY	ETF	187.92	188.02	187.87	187.94	394489.0
2014-04-24 17:00:00	SPY	ETF	187.92	187.95	187.84	187.85	65550.0
2014-04-24 17:30:00	SPY	ETF	187.9	187.9	187.83	187.83	37774.0
2014-04-24 18:00:00	SPY	ETF	187.81	187.82	187.65	187.67	42221.0
2014-04-24 18:30:00	SPY	ETF	187.7	187.79	187.7	187.79	8500.0
2014-04-24 19:00:00	SPY	ETF	187.76	187.79	187.76	187.76	2100.0
2014-04-24 19:30:00	SPY	ETF	187.79	187.84	187.79	187.79	6445.0
2014-04-24 04:00:00	QQQ	ETF	87.89	88.0	87.89	87.99	1671.0
2014-04-24 04:30:00	QQQ	ETF	88.0	88.0	88.0	88.0	9450.0
2014-04-24 05:00:00	QQQ	ETF	87.98	87.98	87.94	87.96	4632.0
2014-04-24 06:00:00	QQQ	ETF	88.0	88.22	88.0	88.19	4234.0
2014-04-24 06:30:00	QQQ	ETF	88.2	88.24	88.2	88.2	36000.0
2014-04-24 07:00:00	QQQ	ETF	88.2	88.2	88.06	88.14	59025.0
2014-04-24 07:30:00	QQQ	ETF	88.14	88.19	88.11	88.12	114187.0
2014-04-24 08:00:00	QQQ	ETF	88.15	88.22	88.08	88.22	208240.0
2014-04-24 08:30:00	QQQ	ETF	88.25	88.47	88.25	88.3	740947.0
2014-04-24 09:00:00	QQQ	ETF	88.29	88.32	88.14	88.22	997767.0
2014-04-24 09:30:00	QQQ	ETF	88.2	88.21	86.93	87.14	14299982.0
2014-04-24 10:00:00	QQQ	ETF	87.14	87.33	86.65	87.31	8572615.0
2014-04-24 10:30:00	QQQ	ETF	87.31	87.371	87.12	87.35	4361493.0
2014-04-24 11:00:00	QQQ	ETF	87.34	87.74	87.24	87.67	3133461.0
2014-04-24 11:30:00	QQQ	ETF	87.67	87.74	87.55	87.6301	1557847.0
2014-04-24 12:00:00	QQQ	ETF	87.63	87.77	87.54	87.61	1130067.0
2014-04-24 12:30:00	QQQ	ETF	87.61	87.75	87.6	87.72	1027846.0
2014-04-24 13:00:00	QQQ	ETF	87.73	87.76	87.67	87.67	492480.0

> showing 50 of 11,230 rows — these rows as CSV

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