PREVIEW / etf_30min / 2015-11-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-23.parquet
  size:    381 KB
  rows:    12,828

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-11-23 04:00:00	SPY	ETF	209.4	209.45	209.2	209.29	2950.0
2015-11-23 04:30:00	SPY	ETF	209.21	209.29	209.06	209.09	7742.0
2015-11-23 05:00:00	SPY	ETF	209.07	209.26	209.07	209.21	7448.0
2015-11-23 05:30:00	SPY	ETF	209.23	209.26	209.07	209.11	10400.0
2015-11-23 06:00:00	SPY	ETF	209.08	209.1	208.91	208.92	13357.0
2015-11-23 06:30:00	SPY	ETF	208.95	209.51	208.93	209.41	31186.0
2015-11-23 07:00:00	SPY	ETF	209.33	209.76	209.26	209.72	212183.0
2015-11-23 07:30:00	SPY	ETF	209.63	209.65	209.33	209.46	65222.0
2015-11-23 08:00:00	SPY	ETF	209.34	209.54	209.28	209.48	201132.0
2015-11-23 08:30:00	SPY	ETF	209.5	209.54	209.21	209.21	248262.0
2015-11-23 09:00:00	SPY	ETF	209.21	209.44	209.21	209.38	224569.0
2015-11-23 09:30:00	SPY	ETF	209.38	209.68	209.15	209.295	7506318.0
2015-11-23 10:00:00	SPY	ETF	209.29	209.98	209.14	209.77	6811211.0
2015-11-23 10:30:00	SPY	ETF	209.77	209.95	209.63	209.95	3911744.0
2015-11-23 11:00:00	SPY	ETF	209.945	209.945	209.69	209.835	3947475.0
2015-11-23 11:30:00	SPY	ETF	209.83	209.93	209.64	209.84	3125795.0
2015-11-23 12:00:00	SPY	ETF	209.83	209.86	209.53	209.63	2514565.0
2015-11-23 12:30:00	SPY	ETF	209.63	209.72	209.51	209.6531	2293151.0
2015-11-23 13:00:00	SPY	ETF	209.655	209.76	209.51	209.58	1929661.0
2015-11-23 13:30:00	SPY	ETF	209.5711	209.63	209.24	209.25	2579530.0
2015-11-23 14:00:00	SPY	ETF	209.245	209.31	208.69	208.81	6962475.0
2015-11-23 14:30:00	SPY	ETF	208.8	208.9	208.52	208.86	5567674.0
2015-11-23 15:00:00	SPY	ETF	208.86	209.1	208.83	209.05	4746443.0
2015-11-23 15:30:00	SPY	ETF	209.05	209.22	208.96	209.06	8463986.0
2015-11-23 16:00:00	SPY	ETF	209.05	209.19	209.01	209.13	2095860.0
2015-11-23 16:30:00	SPY	ETF	209.13	209.32	209.04	209.04	812593.0
2015-11-23 17:00:00	SPY	ETF	209.06	209.08	209.0	209.0	57511.0
2015-11-23 17:30:00	SPY	ETF	209.0	209.04	209.0	209.0	17528.0
2015-11-23 18:00:00	SPY	ETF	209.01	209.13	208.91	209.11	84464.0
2015-11-23 18:30:00	SPY	ETF	209.07	209.17	209.05	209.17	9645.0
2015-11-23 19:00:00	SPY	ETF	209.19	209.2	209.07	209.2	14725.0
2015-11-23 19:30:00	SPY	ETF	209.15	209.22	209.13	209.15	27389.0
2015-11-23 04:00:00	QQQ	ETF	114.51	114.51	114.51	114.51	100.0
2015-11-23 04:30:00	QQQ	ETF	114.44	114.45	114.37	114.37	10700.0
2015-11-23 06:30:00	QQQ	ETF	114.21	114.47	114.21	114.47	500.0
2015-11-23 07:00:00	QQQ	ETF	114.47	114.66	114.47	114.66	9350.0
2015-11-23 07:30:00	QQQ	ETF	114.59	114.59	114.46	114.49	12900.0
2015-11-23 08:00:00	QQQ	ETF	114.5	114.6	114.45	114.58	23276.0
2015-11-23 08:30:00	QQQ	ETF	114.56	114.56	114.43	114.43	22079.0
2015-11-23 09:00:00	QQQ	ETF	114.43	114.62	114.43	114.52	217686.0
2015-11-23 09:30:00	QQQ	ETF	114.53	114.74	114.35	114.62	2405531.0
2015-11-23 10:00:00	QQQ	ETF	114.63	114.94	114.5	114.73	2017983.0
2015-11-23 10:30:00	QQQ	ETF	114.74	114.82	114.63	114.81	1352549.0
2015-11-23 11:00:00	QQQ	ETF	114.815	114.815	114.57	114.62	1075191.0
2015-11-23 11:30:00	QQQ	ETF	114.62	114.68	114.48	114.6	1319930.0
2015-11-23 12:00:00	QQQ	ETF	114.6	114.6068	114.39	114.49	1280263.0
2015-11-23 12:30:00	QQQ	ETF	114.485	114.56	114.39	114.5	511276.0
2015-11-23 13:00:00	QQQ	ETF	114.51	114.57	114.38	114.44	652811.0
2015-11-23 13:30:00	QQQ	ETF	114.43	114.4765	114.19	114.2	673191.0
2015-11-23 14:00:00	QQQ	ETF	114.19	114.225	113.79	113.84	1675617.0

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

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