PREVIEW / etf_30min / 2015-02-24

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-24.parquet
  size:    379 KB
  rows:    12,757

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
2015-02-24 04:00:00	SPY	ETF	211.08	211.18	211.03	211.17	800.0
2015-02-24 04:30:00	SPY	ETF	211.17	211.17	211.07	211.1	3300.0
2015-02-24 05:00:00	SPY	ETF	211.1	211.15	211.1	211.15	6400.0
2015-02-24 05:30:00	SPY	ETF	211.14	211.14	211.14	211.14	246.0
2015-02-24 06:00:00	SPY	ETF	211.17	211.28	211.17	211.2	11250.0
2015-02-24 06:30:00	SPY	ETF	211.25	211.25	211.2	211.2	9700.0
2015-02-24 07:00:00	SPY	ETF	211.25	211.25	211.06	211.15	185960.0
2015-02-24 07:30:00	SPY	ETF	211.18	211.18	211.04	211.15	27719.0
2015-02-24 08:00:00	SPY	ETF	211.141	211.17	211.09	211.15	79453.0
2015-02-24 08:30:00	SPY	ETF	211.15	211.23	211.08	211.21	439945.0
2015-02-24 09:00:00	SPY	ETF	211.22	211.25	211.07	211.12	656377.0
2015-02-24 09:30:00	SPY	ETF	211.12	211.36	211.03	211.14	8144957.0
2015-02-24 10:00:00	SPY	ETF	211.15	211.66	210.76	211.57	10903629.0
2015-02-24 10:30:00	SPY	ETF	211.57	211.62	211.42	211.56	3718745.0
2015-02-24 11:00:00	SPY	ETF	211.55	211.91	211.52	211.795	4702913.0
2015-02-24 11:30:00	SPY	ETF	211.795	211.87	211.58	211.59	2985123.0
2015-02-24 12:00:00	SPY	ETF	211.59	211.7	211.51	211.54	2252853.0
2015-02-24 12:30:00	SPY	ETF	211.54	211.6	211.11	211.52	3976079.0
2015-02-24 13:00:00	SPY	ETF	211.52	211.58	211.375	211.48	1920788.0
2015-02-24 13:30:00	SPY	ETF	211.485	211.73	211.48	211.675	2185400.0
2015-02-24 14:00:00	SPY	ETF	211.68	211.73	211.51	211.58	2982076.0
2015-02-24 14:30:00	SPY	ETF	211.58	211.78	211.49	211.7555	2556003.0
2015-02-24 15:00:00	SPY	ETF	211.74	211.96	211.735	211.945	4511516.0
2015-02-24 15:30:00	SPY	ETF	211.95	212.05	211.72	211.84	12742588.0
2015-02-24 16:00:00	SPY	ETF	211.83	211.88	211.1974	211.82	4253327.0
2015-02-24 16:30:00	SPY	ETF	211.82	211.93	211.3999	211.9	1274067.0
2015-02-24 17:00:00	SPY	ETF	211.89	211.89	211.82	211.86	34974.0
2015-02-24 17:30:00	SPY	ETF	211.86	211.88	211.83	211.85	25754.0
2015-02-24 18:00:00	SPY	ETF	211.84	211.88	211.81	211.86	54311.0
2015-02-24 18:30:00	SPY	ETF	211.86	211.86	211.82	211.82	16264.0
2015-02-24 19:00:00	SPY	ETF	211.82	211.84	211.69	211.72	139247.0
2015-02-24 19:30:00	SPY	ETF	211.75	211.815	211.75	211.815	38476.0
2015-02-24 04:00:00	QQQ	ETF	108.4	108.4	108.4	108.4	200.0
2015-02-24 06:30:00	QQQ	ETF	108.45	108.45	108.45	108.45	1500.0
2015-02-24 07:00:00	QQQ	ETF	108.46	108.46	108.39	108.39	15475.0
2015-02-24 07:30:00	QQQ	ETF	108.42	108.42	108.35	108.4	25900.0
2015-02-24 08:00:00	QQQ	ETF	108.41	108.41	108.37	108.39	32031.0
2015-02-24 08:30:00	QQQ	ETF	108.4	108.45	108.4	108.43	31912.0
2015-02-24 09:00:00	QQQ	ETF	108.43	108.43	108.36	108.39	45315.0
2015-02-24 09:30:00	QQQ	ETF	108.38	108.43	108.15	108.22	2389384.0
2015-02-24 10:00:00	QQQ	ETF	108.23	108.5	108.05	108.44	2737756.0
2015-02-24 10:30:00	QQQ	ETF	108.44	108.49	108.36	108.48	1176501.0
2015-02-24 11:00:00	QQQ	ETF	108.47	108.68	108.4428	108.68	1874348.0
2015-02-24 11:30:00	QQQ	ETF	108.67	108.71	108.52	108.52	971994.0
2015-02-24 12:00:00	QQQ	ETF	108.51	108.595	108.46	108.46	580497.0
2015-02-24 12:30:00	QQQ	ETF	108.45	108.46	108.24	108.42	851345.0
2015-02-24 13:00:00	QQQ	ETF	108.42	108.46	108.36	108.44	397059.0
2015-02-24 13:30:00	QQQ	ETF	108.44	108.61	108.44	108.58	377674.0
2015-02-24 14:00:00	QQQ	ETF	108.58	108.6	108.49	108.53	489210.0
2015-02-24 14:30:00	QQQ	ETF	108.52	108.65	108.491	108.62	449867.0

> showing 50 of 12,757 rows — these rows as CSV

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