PREVIEW / etf_30min / 2014-05-28

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-28.parquet
  size:    325 KB
  rows:    11,347

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-05-28 04:00:00	SPY	ETF	191.55	191.64	191.55	191.64	1870.0
2014-05-28 04:30:00	SPY	ETF	191.63	191.7	191.62	191.67	704.0
2014-05-28 05:00:00	SPY	ETF	191.66	191.66	191.65	191.65	437.0
2014-05-28 05:30:00	SPY	ETF	191.7	191.86	191.62	191.86	18729.0
2014-05-28 06:00:00	SPY	ETF	191.84	191.9	191.83	191.9	8619.0
2014-05-28 06:30:00	SPY	ETF	191.9	191.98	191.83	191.84	19215.0
2014-05-28 07:00:00	SPY	ETF	191.84	191.97	191.78	191.78	150009.0
2014-05-28 07:30:00	SPY	ETF	191.79	191.83	191.77	191.79	35471.0
2014-05-28 08:00:00	SPY	ETF	191.78	191.9	191.77	191.78	210661.0
2014-05-28 08:30:00	SPY	ETF	191.76	191.76	191.43	191.46	767303.0
2014-05-28 09:00:00	SPY	ETF	191.46	191.61	191.43	191.52	555039.0
2014-05-28 09:30:00	SPY	ETF	191.52	191.73	191.34	191.41	8892778.0
2014-05-28 10:00:00	SPY	ETF	191.41	191.44	191.145	191.375	7234850.0
2014-05-28 10:30:00	SPY	ETF	191.37	191.38	191.06	191.32	4608588.0
2014-05-28 11:00:00	SPY	ETF	191.32	191.55	191.29	191.46	3341088.0
2014-05-28 11:30:00	SPY	ETF	191.46	191.68	191.455	191.55	2531627.0
2014-05-28 12:00:00	SPY	ETF	191.55	191.74	191.47	191.49	3408173.0
2014-05-28 12:30:00	SPY	ETF	191.499	191.57	191.42	191.53	1923479.0
2014-05-28 13:00:00	SPY	ETF	191.53	191.73	191.5	191.655	2644870.0
2014-05-28 13:30:00	SPY	ETF	191.66	191.82	191.61	191.765	2811020.0
2014-05-28 14:00:00	SPY	ETF	191.76	191.82	191.62	191.655	3255841.0
2014-05-28 14:30:00	SPY	ETF	191.66	191.71	191.53	191.66	4390658.0
2014-05-28 15:00:00	SPY	ETF	191.66	191.8	191.63	191.71	3826381.0
2014-05-28 15:30:00	SPY	ETF	191.705	191.77	191.32	191.35	11038668.0
2014-05-28 16:00:00	SPY	ETF	191.35	191.56	191.32	191.52	3353099.0
2014-05-28 16:30:00	SPY	ETF	191.52	191.59	191.48	191.52	312534.0
2014-05-28 17:00:00	SPY	ETF	191.52	191.55	191.5	191.51	41560.0
2014-05-28 17:30:00	SPY	ETF	191.51	191.53	191.5	191.53	6960.0
2014-05-28 18:00:00	SPY	ETF	191.52	191.52	191.47	191.47	4270.0
2014-05-28 18:30:00	SPY	ETF	191.48	191.54	191.46	191.54	5445.0
2014-05-28 19:00:00	SPY	ETF	191.47	191.47	191.45	191.45	3455.0
2014-05-28 19:30:00	SPY	ETF	191.45	191.48	191.42	191.44	7059.0
2014-05-28 04:00:00	QQQ	ETF	91.01	91.01	91.01	91.01	300.0
2014-05-28 04:30:00	QQQ	ETF	91.07	91.07	91.07	91.07	100.0
2014-05-28 05:30:00	QQQ	ETF	91.16	91.16	91.16	91.16	10042.0
2014-05-28 06:00:00	QQQ	ETF	91.17	91.17	91.17	91.17	4900.0
2014-05-28 06:30:00	QQQ	ETF	91.19	91.19	91.14	91.14	350.0
2014-05-28 07:00:00	QQQ	ETF	91.17	91.17	91.1	91.1	27330.0
2014-05-28 07:30:00	QQQ	ETF	91.09	91.11	91.04	91.04	67055.0
2014-05-28 08:00:00	QQQ	ETF	91.09	91.09	91.04	91.07	39163.0
2014-05-28 08:30:00	QQQ	ETF	91.05	91.06	90.89	90.9	155486.0
2014-05-28 09:00:00	QQQ	ETF	90.9	90.97	90.88	90.95	373353.0
2014-05-28 09:30:00	QQQ	ETF	90.97	91.04	90.76	90.85	5635044.0
2014-05-28 10:00:00	QQQ	ETF	90.85	90.94	90.69	90.92	3890295.0
2014-05-28 10:30:00	QQQ	ETF	90.92	90.92	90.645	90.8	1693755.0
2014-05-28 11:00:00	QQQ	ETF	90.79	90.93	90.77	90.89	1158314.0
2014-05-28 11:30:00	QQQ	ETF	90.89	91.07	90.89	90.95	1919394.0
2014-05-28 12:00:00	QQQ	ETF	90.959	91.1	90.88	90.89	1143364.0
2014-05-28 12:30:00	QQQ	ETF	90.89	90.94	90.85	90.93	674346.0
2014-05-28 13:00:00	QQQ	ETF	90.94	91.1	90.92	91.02	949284.0

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

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