PREVIEW / etf_30min / 2014-03-14

all etf 30-min files

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

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-03-14 04:00:00	SPY	ETF	184.91	185.5	184.91	185.47	20775.0
2014-03-14 04:30:00	SPY	ETF	185.42	185.43	185.12	185.31	6150.0
2014-03-14 05:00:00	SPY	ETF	185.32	185.48	185.32	185.4	77743.0
2014-03-14 05:30:00	SPY	ETF	185.36	185.52	185.36	185.5	48274.0
2014-03-14 06:00:00	SPY	ETF	185.56	185.58	185.48	185.48	70695.0
2014-03-14 06:30:00	SPY	ETF	185.45	185.54	185.35	185.5	157130.0
2014-03-14 07:00:00	SPY	ETF	185.48	185.49	185.27	185.33	182482.0
2014-03-14 07:30:00	SPY	ETF	185.33	185.38	185.08	185.1	199457.0
2014-03-14 08:00:00	SPY	ETF	185.27	185.38	184.74	184.9	1012169.0
2014-03-14 08:30:00	SPY	ETF	184.91	185.1	184.45	185.0	1596837.0
2014-03-14 09:00:00	SPY	ETF	185.0	185.12	184.67	184.78	1709451.0
2014-03-14 09:30:00	SPY	ETF	184.8	185.71	184.79	185.06	18970821.0
2014-03-14 10:00:00	SPY	ETF	185.07	185.8	185.055	185.4035	11830155.0
2014-03-14 10:30:00	SPY	ETF	185.41	185.5401	184.96	185.02	7107225.0
2014-03-14 11:00:00	SPY	ETF	185.02	185.1	184.53	184.76	10190878.0
2014-03-14 11:30:00	SPY	ETF	184.76	185.72	184.67	185.55	17680123.0
2014-03-14 12:00:00	SPY	ETF	185.56	185.62	185.09	185.11	8945830.0
2014-03-14 12:30:00	SPY	ETF	185.11	185.46	184.92	185.4	11043741.0
2014-03-14 13:00:00	SPY	ETF	185.4	185.48	185.0	185.14	4934446.0
2014-03-14 13:30:00	SPY	ETF	185.15	185.25	184.88	185.115	5248626.0
2014-03-14 14:00:00	SPY	ETF	185.11	185.18	184.95	185.1163	4556282.0
2014-03-14 14:30:00	SPY	ETF	185.119	185.12	184.56	184.59	5742114.0
2014-03-14 15:00:00	SPY	ETF	184.59	184.87	184.56	184.76	9803845.0
2014-03-14 15:30:00	SPY	ETF	184.76	184.98	184.44	184.61	18914868.0
2014-03-14 16:00:00	SPY	ETF	184.62	185.1442	184.44	184.5	7905347.0
2014-03-14 16:30:00	SPY	ETF	184.5	185.39	184.44	184.5	1416615.0
2014-03-14 17:00:00	SPY	ETF	184.49	184.66	184.48	184.48	3566929.0
2014-03-14 17:30:00	SPY	ETF	184.46	184.74	184.46	184.69	111753.0
2014-03-14 18:00:00	SPY	ETF	184.67	184.79	184.67	184.79	90189.0
2014-03-14 18:30:00	SPY	ETF	184.79	184.82	184.7	184.72	46171.0
2014-03-14 19:00:00	SPY	ETF	184.73	184.74	184.71	184.74	8485.0
2014-03-14 19:30:00	SPY	ETF	184.72	184.76	184.67	184.67	31146.0
2014-03-14 04:00:00	QQQ	ETF	89.29	89.29	89.29	89.29	2500.0
2014-03-14 06:00:00	QQQ	ETF	89.43	89.45	89.4	89.42	3000.0
2014-03-14 06:30:00	QQQ	ETF	89.36	89.37	89.33	89.37	12400.0
2014-03-14 07:00:00	QQQ	ETF	89.38	89.38	89.31	89.34	7200.0
2014-03-14 07:30:00	QQQ	ETF	89.33	89.46	89.23	89.25	116048.0
2014-03-14 08:00:00	QQQ	ETF	89.3	89.33	89.09	89.09	29386.0
2014-03-14 08:30:00	QQQ	ETF	89.1	89.25	88.94	89.25	229986.0
2014-03-14 09:00:00	QQQ	ETF	89.26	89.29	88.95	88.98	414544.0
2014-03-14 09:30:00	QQQ	ETF	88.98	89.38	88.9	88.92	6396819.0
2014-03-14 10:00:00	QQQ	ETF	88.91	89.3525	88.91	89.19	3684124.0
2014-03-14 10:30:00	QQQ	ETF	89.2	89.205	88.82	88.87	2005586.0
2014-03-14 11:00:00	QQQ	ETF	88.87	88.92	88.64	88.8	2705247.0
2014-03-14 11:30:00	QQQ	ETF	88.81	89.3466	88.795	89.28	4576479.0
2014-03-14 12:00:00	QQQ	ETF	89.28	89.3	89.07	89.08	1594113.0
2014-03-14 12:30:00	QQQ	ETF	89.09	89.24	88.95	89.16	2469935.0
2014-03-14 13:00:00	QQQ	ETF	89.17	89.21	88.95	89.0301	1074321.0
2014-03-14 13:30:00	QQQ	ETF	89.04	89.08	88.85	88.955	1371382.0
2014-03-14 14:00:00	QQQ	ETF	88.95	88.97	88.83	88.93	1300143.0

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

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