PREVIEW / etf_30min / 2014-07-14

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-14.parquet
  size:    338 KB
  rows:    11,893

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-07-14 04:00:00	SPY	ETF	196.9	197.28	196.9	197.28	1590.0
2014-07-14 04:30:00	SPY	ETF	197.43	197.43	197.43	197.43	1350.0
2014-07-14 05:00:00	SPY	ETF	197.31	197.38	197.31	197.32	1363.0
2014-07-14 05:30:00	SPY	ETF	197.28	197.38	197.22	197.34	8325.0
2014-07-14 06:00:00	SPY	ETF	197.33	197.4	197.33	197.33	4694.0
2014-07-14 06:30:00	SPY	ETF	197.36	197.39	197.31	197.31	56500.0
2014-07-14 07:00:00	SPY	ETF	197.31	197.39	197.31	197.35	123426.0
2014-07-14 07:30:00	SPY	ETF	197.34	197.5	197.29	197.5	480371.0
2014-07-14 08:00:00	SPY	ETF	197.48	197.62	196.9	197.53	695404.0
2014-07-14 08:30:00	SPY	ETF	197.53	197.55	197.48	197.51	111570.0
2014-07-14 09:00:00	SPY	ETF	197.5	197.67	196.6	197.62	847725.0
2014-07-14 09:30:00	SPY	ETF	197.61	197.78	197.44	197.61	8417446.0
2014-07-14 10:00:00	SPY	ETF	197.6	197.72	197.56	197.61	4165483.0
2014-07-14 10:30:00	SPY	ETF	197.61	197.82	197.61	197.745	3822735.0
2014-07-14 11:00:00	SPY	ETF	197.75	197.85	197.74	197.81	3362854.0
2014-07-14 11:30:00	SPY	ETF	197.8	197.86	197.68	197.695	2425965.0
2014-07-14 12:00:00	SPY	ETF	197.69	197.79	197.66	197.74	1816972.0
2014-07-14 12:30:00	SPY	ETF	197.74	197.77	197.52	197.6	2649839.0
2014-07-14 13:00:00	SPY	ETF	197.6	197.67	197.57	197.62	1972340.0
2014-07-14 13:30:00	SPY	ETF	197.625	197.71	197.595	197.665	2836458.0
2014-07-14 14:00:00	SPY	ETF	197.67	197.7	197.57	197.59	2573836.0
2014-07-14 14:30:00	SPY	ETF	197.58	197.72	197.57	197.715	3975372.0
2014-07-14 15:00:00	SPY	ETF	197.71	197.72	197.51	197.55	3697268.0
2014-07-14 15:30:00	SPY	ETF	197.54	197.63	197.48	197.59	8895513.0
2014-07-14 16:00:00	SPY	ETF	197.59	197.6558	197.53	197.56	3302502.0
2014-07-14 16:30:00	SPY	ETF	197.56	197.8	197.56	197.58	535029.0
2014-07-14 17:00:00	SPY	ETF	197.59	197.6	197.59	197.6	222435.0
2014-07-14 17:30:00	SPY	ETF	197.6	197.62	197.6	197.61	432933.0
2014-07-14 18:00:00	SPY	ETF	197.58	197.62	197.57	197.6	8210.0
2014-07-14 18:30:00	SPY	ETF	197.6	197.6	197.57	197.57	9367.0
2014-07-14 19:00:00	SPY	ETF	197.58	197.58	197.53	197.55	53035.0
2014-07-14 19:30:00	SPY	ETF	197.57	197.59	197.55	197.58	16595.0
2014-07-14 04:00:00	QQQ	ETF	95.33	95.69	95.33	95.69	600.0
2014-07-14 05:00:00	QQQ	ETF	95.58	95.71	95.58	95.71	2800.0
2014-07-14 06:00:00	QQQ	ETF	95.75	95.75	95.73	95.73	200.0
2014-07-14 07:00:00	QQQ	ETF	95.65	95.73	95.65	95.67	35700.0
2014-07-14 07:30:00	QQQ	ETF	95.68	95.73	95.65	95.73	126800.0
2014-07-14 08:00:00	QQQ	ETF	95.73	95.75	95.67	95.69	98095.0
2014-07-14 08:30:00	QQQ	ETF	95.7	95.72	95.67	95.68	67934.0
2014-07-14 09:00:00	QQQ	ETF	95.68	95.72	95.67	95.69	137683.0
2014-07-14 09:30:00	QQQ	ETF	95.7	95.76	95.535	95.71	3048948.0
2014-07-14 10:00:00	QQQ	ETF	95.7	95.8	95.7	95.72	1378091.0
2014-07-14 10:30:00	QQQ	ETF	95.7299	95.95	95.7299	95.91	1517496.0
2014-07-14 11:00:00	QQQ	ETF	95.92	96.055	95.92	96.02	1336730.0
2014-07-14 11:30:00	QQQ	ETF	96.02	96.03	95.88	95.91	1032574.0
2014-07-14 12:00:00	QQQ	ETF	95.905	96.03	95.88	95.9714	779348.0
2014-07-14 12:30:00	QQQ	ETF	95.975	95.99	95.81	95.86	625524.0
2014-07-14 13:00:00	QQQ	ETF	95.86	95.97	95.85	95.94	843828.0
2014-07-14 13:30:00	QQQ	ETF	95.945	96.01	95.9	95.9699	558733.0
2014-07-14 14:00:00	QQQ	ETF	95.9648	95.9774	95.87	95.87	434654.0

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

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