PREVIEW / etf_30min / 2012-12-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-06.parquet
  size:    282 KB
  rows:    9,634

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
2012-12-06 04:00:00	SPY	ETF	141.11	141.73	141.11	141.73	11577.0
2012-12-06 04:30:00	SPY	ETF	141.69	141.69	141.68	141.68	5200.0
2012-12-06 05:00:00	SPY	ETF	141.67	141.69	141.58	141.58	27058.0
2012-12-06 05:30:00	SPY	ETF	141.58	141.59	141.58	141.59	5200.0
2012-12-06 06:00:00	SPY	ETF	141.63	141.65	141.4	141.4	9160.0
2012-12-06 06:30:00	SPY	ETF	141.49	141.49	141.29	141.32	20250.0
2012-12-06 07:00:00	SPY	ETF	141.31	141.51	141.31	141.5	88347.0
2012-12-06 07:30:00	SPY	ETF	141.49	141.51	141.29	141.4	67380.0
2012-12-06 08:00:00	SPY	ETF	141.31	141.52	141.31	141.41	247124.0
2012-12-06 08:30:00	SPY	ETF	141.43	141.58	141.09	141.25	821076.0
2012-12-06 09:00:00	SPY	ETF	141.2	141.44	141.2	141.37	582324.0
2012-12-06 09:30:00	SPY	ETF	141.37	141.72	141.21	141.465	16477317.0
2012-12-06 10:00:00	SPY	ETF	141.46	141.55	141.16	141.42	8771634.0
2012-12-06 10:30:00	SPY	ETF	141.42	141.92	141.32	141.83	8012879.0
2012-12-06 11:00:00	SPY	ETF	141.83	141.92	141.72	141.85	4247605.0
2012-12-06 11:30:00	SPY	ETF	141.84	142.0	141.77	141.8017	4969778.0
2012-12-06 12:00:00	SPY	ETF	141.81	141.88	141.58	141.61	4740917.0
2012-12-06 12:30:00	SPY	ETF	141.61	141.67	141.49	141.49	5294502.0
2012-12-06 13:00:00	SPY	ETF	141.49	141.81	141.45	141.68	3794372.0
2012-12-06 13:30:00	SPY	ETF	141.68	141.88	141.68	141.87	2631249.0
2012-12-06 14:00:00	SPY	ETF	141.86	141.88	141.72	141.86	3371153.0
2012-12-06 14:30:00	SPY	ETF	141.865	141.96	141.71	141.785	4464950.0
2012-12-06 15:00:00	SPY	ETF	141.78	141.83	141.62	141.69	4798831.0
2012-12-06 15:30:00	SPY	ETF	141.68	142.04	141.655	141.96	10257619.0
2012-12-06 16:00:00	SPY	ETF	141.96	142.04	141.5402	142.0	5866430.0
2012-12-06 16:30:00	SPY	ETF	141.99	142.04	141.97	142.015	6310867.0
2012-12-06 17:00:00	SPY	ETF	142.02	142.04	141.7569	141.9	166926.0
2012-12-06 17:30:00	SPY	ETF	141.9	141.92	141.83	141.91	5629954.0
2012-12-06 18:00:00	SPY	ETF	141.91	142.06	141.89	142.06	64564.0
2012-12-06 18:30:00	SPY	ETF	142.04	142.06	141.96	142.03	12135.0
2012-12-06 19:00:00	SPY	ETF	142.05	142.12	142.03	142.05	36128.0
2012-12-06 19:30:00	SPY	ETF	142.08	142.11	142.05	142.08	23250.0
2012-12-06 05:00:00	QQQ	ETF	64.9	64.9	64.9	64.9	8000.0
2012-12-06 05:30:00	QQQ	ETF	64.94	64.94	64.94	64.94	300.0
2012-12-06 06:30:00	QQQ	ETF	64.86	64.86	64.86	64.86	100.0
2012-12-06 07:00:00	QQQ	ETF	64.86	64.86	64.8	64.83	12290.0
2012-12-06 07:30:00	QQQ	ETF	64.86	64.87	64.81	64.87	77110.0
2012-12-06 08:00:00	QQQ	ETF	64.82	65.19	64.75	64.78	2830315.0
2012-12-06 08:30:00	QQQ	ETF	64.79	64.82	64.65	64.72	127680.0
2012-12-06 09:00:00	QQQ	ETF	64.71	64.75	64.64	64.72	169524.0
2012-12-06 09:30:00	QQQ	ETF	64.71	65.064	64.53	64.9	7396068.0
2012-12-06 10:00:00	QQQ	ETF	64.9	65.09	64.78	64.95	6713646.0
2012-12-06 10:30:00	QQQ	ETF	64.95	65.38	64.9	65.35	4342916.0
2012-12-06 11:00:00	QQQ	ETF	65.35	65.37	65.23	65.3399	1891156.0
2012-12-06 11:30:00	QQQ	ETF	65.331	65.4801	65.3	65.38	2632564.0
2012-12-06 12:00:00	QQQ	ETF	65.38	65.43	65.16	65.1785	1764366.0
2012-12-06 12:30:00	QQQ	ETF	65.17	65.24	65.11	65.145	1445442.0
2012-12-06 13:00:00	QQQ	ETF	65.14	65.33	65.08	65.22	1448890.0
2012-12-06 13:30:00	QQQ	ETF	65.22	65.4	65.2	65.385	895700.0
2012-12-06 14:00:00	QQQ	ETF	65.4	65.41	65.2	65.33	1049508.0

> showing 50 of 9,634 rows — these rows as CSV

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