PREVIEW / etf_30min / 2013-03-27

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-27.parquet
  size:    302 KB
  rows:    10,243

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
2013-03-27 04:00:00	SPY	ETF	156.33	156.35	156.15	156.15	2900.0
2013-03-27 04:30:00	SPY	ETF	156.25	156.27	156.22	156.22	1400.0
2013-03-27 05:00:00	SPY	ETF	156.28	156.29	156.03	156.05	4700.0
2013-03-27 05:30:00	SPY	ETF	155.98	156.0	155.74	155.74	61550.0
2013-03-27 06:00:00	SPY	ETF	155.76	155.89	155.51	155.54	144201.0
2013-03-27 06:30:00	SPY	ETF	155.56	155.61	155.46	155.59	210985.0
2013-03-27 07:00:00	SPY	ETF	155.55	155.59	155.46	155.46	192743.0
2013-03-27 07:30:00	SPY	ETF	155.48	155.49	155.28	155.39	490732.0
2013-03-27 08:00:00	SPY	ETF	155.39	155.59	155.22	155.46	772952.0
2013-03-27 08:30:00	SPY	ETF	155.43	155.58	155.39	155.39	410882.0
2013-03-27 09:00:00	SPY	ETF	155.4	155.5	155.18	155.25	891063.0
2013-03-27 09:30:00	SPY	ETF	155.26	155.4	155.0	155.26	13666662.0
2013-03-27 10:00:00	SPY	ETF	155.26	155.531	155.1	155.4299	9881520.0
2013-03-27 10:30:00	SPY	ETF	155.43	155.72	155.42	155.59	7808724.0
2013-03-27 11:00:00	SPY	ETF	155.59	155.82	155.51	155.72	5480082.0
2013-03-27 11:30:00	SPY	ETF	155.73	155.97	155.69	155.815	7139884.0
2013-03-27 12:00:00	SPY	ETF	155.84	155.93	155.76	155.79	4149684.0
2013-03-27 12:30:00	SPY	ETF	155.795	155.9	155.73	155.8117	3810990.0
2013-03-27 13:00:00	SPY	ETF	155.81	155.84	155.6	155.73	6527096.0
2013-03-27 13:30:00	SPY	ETF	155.73	155.95	155.6807	155.931	3938378.0
2013-03-27 14:00:00	SPY	ETF	155.931	156.1	155.9	156.055	6377981.0
2013-03-27 14:30:00	SPY	ETF	156.06	156.14	155.97	156.071	5027440.0
2013-03-27 15:00:00	SPY	ETF	156.0712	156.2	155.95	156.16	4734590.0
2013-03-27 15:30:00	SPY	ETF	156.16	156.245	156.02	156.13	11105142.0
2013-03-27 16:00:00	SPY	ETF	156.14	156.18	155.4494	156.05	6174346.0
2013-03-27 16:30:00	SPY	ETF	156.05	156.13	156.05	156.12	243920.0
2013-03-27 17:00:00	SPY	ETF	156.11	156.14	156.08	156.09	35550.0
2013-03-27 17:30:00	SPY	ETF	156.08	156.13	156.08	156.1	25021.0
2013-03-27 18:00:00	SPY	ETF	156.1	156.12	156.0	156.12	40632.0
2013-03-27 18:30:00	SPY	ETF	156.1	156.12	156.06	156.06	3110.0
2013-03-27 19:00:00	SPY	ETF	156.06	156.07	156.05	156.07	4716.0
2013-03-27 19:30:00	SPY	ETF	156.07	156.07	155.98	155.99	42302.0
2013-03-27 04:30:00	QQQ	ETF	68.78	68.78	68.78	68.78	1000.0
2013-03-27 05:00:00	QQQ	ETF	68.7	68.7	68.7	68.7	800.0
2013-03-27 05:30:00	QQQ	ETF	68.67	68.67	68.67	68.67	1700.0
2013-03-27 06:00:00	QQQ	ETF	68.61	68.61	68.61	68.61	800.0
2013-03-27 06:30:00	QQQ	ETF	68.5	68.53	68.49	68.5	2300.0
2013-03-27 07:00:00	QQQ	ETF	68.49	68.49	68.46	68.48	850.0
2013-03-27 07:30:00	QQQ	ETF	68.42	68.43	68.35	68.37	17750.0
2013-03-27 08:00:00	QQQ	ETF	68.39	68.45	68.34	68.39	55081.0
2013-03-27 08:30:00	QQQ	ETF	68.4	68.46	68.38	68.4	47878.0
2013-03-27 09:00:00	QQQ	ETF	68.38	68.44	68.24	68.26	146322.0
2013-03-27 09:30:00	QQQ	ETF	68.25	68.4185	68.14	68.35	3479527.0
2013-03-27 10:00:00	QQQ	ETF	68.35	68.4001	68.19	68.36	2177616.0
2013-03-27 10:30:00	QQQ	ETF	68.37	68.61	68.36	68.54	2110486.0
2013-03-27 11:00:00	QQQ	ETF	68.54	68.64	68.485	68.59	965639.0
2013-03-27 11:30:00	QQQ	ETF	68.59	68.69	68.575	68.62	2038345.0
2013-03-27 12:00:00	QQQ	ETF	68.63	68.65	68.58	68.59	699272.0
2013-03-27 12:30:00	QQQ	ETF	68.6	68.64	68.5301	68.5981	1022078.0
2013-03-27 13:00:00	QQQ	ETF	68.6	68.625	68.52	68.5901	718549.0

> showing 50 of 10,243 rows — these rows as CSV

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