PREVIEW / etf_30min / 2017-08-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-07.parquet
  size:    421 KB
  rows:    14,628

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
2017-08-07 04:00:00	SPY	ETF	247.62	247.63	247.62	247.62	4610.0
2017-08-07 04:30:00	SPY	ETF	247.6	247.61	247.6	247.6	1300.0
2017-08-07 05:00:00	SPY	ETF	247.61	247.61	247.5	247.5	4900.0
2017-08-07 05:30:00	SPY	ETF	247.55	247.55	247.5	247.52	2800.0
2017-08-07 06:00:00	SPY	ETF	247.42	247.5	247.42	247.5	300.0
2017-08-07 06:30:00	SPY	ETF	247.45	247.49	247.45	247.49	1210.0
2017-08-07 07:00:00	SPY	ETF	247.52	247.52	247.45	247.47	17972.0
2017-08-07 07:30:00	SPY	ETF	247.43	247.43	247.36	247.41	7720.0
2017-08-07 08:00:00	SPY	ETF	247.41	247.56	247.37	247.54	50428.0
2017-08-07 08:30:00	SPY	ETF	247.53	247.53	247.45	247.46	592431.0
2017-08-07 09:00:00	SPY	ETF	247.46	247.53	247.45	247.49	145753.0
2017-08-07 09:30:00	SPY	ETF	247.49	247.6	247.37	247.57	2527544.0
2017-08-07 10:00:00	SPY	ETF	247.57	247.63	247.49	247.5015	2026444.0
2017-08-07 10:30:00	SPY	ETF	247.505	247.58	247.37	247.4668	2734966.0
2017-08-07 11:00:00	SPY	ETF	247.46	247.53	247.43	247.51	1273462.0
2017-08-07 11:30:00	SPY	ETF	247.52	247.66	247.49	247.61	1492553.0
2017-08-07 12:00:00	SPY	ETF	247.615	247.69	247.61	247.6401	1120383.0
2017-08-07 12:30:00	SPY	ETF	247.65	247.74	247.62	247.73	1971698.0
2017-08-07 13:00:00	SPY	ETF	247.74	247.75	247.69	247.75	807781.0
2017-08-07 13:30:00	SPY	ETF	247.75	247.76	247.6	247.6732	1046149.0
2017-08-07 14:00:00	SPY	ETF	247.6717	247.73	247.65	247.71	1449891.0
2017-08-07 14:30:00	SPY	ETF	247.719	247.77	247.7	247.71	1474711.0
2017-08-07 15:00:00	SPY	ETF	247.71	247.87	247.67	247.86	1906867.0
2017-08-07 15:30:00	SPY	ETF	247.86	247.87	247.71	247.85	5496703.0
2017-08-07 16:00:00	SPY	ETF	247.84	247.8765	247.79	247.85	4398060.0
2017-08-07 16:30:00	SPY	ETF	247.82	247.87	247.6573	247.85	560993.0
2017-08-07 17:00:00	SPY	ETF	247.83	247.86	247.82	247.82	2268.0
2017-08-07 17:30:00	SPY	ETF	247.85	247.85	247.84	247.85	1810.0
2017-08-07 18:00:00	SPY	ETF	247.82	247.82	247.67	247.7	107249.0
2017-08-07 18:30:00	SPY	ETF	247.71	247.74	247.7	247.72	3370.0
2017-08-07 19:00:00	SPY	ETF	247.72	247.72	247.72	247.72	21500.0
2017-08-07 19:30:00	SPY	ETF	247.72	247.74	247.72	247.73	7110.0
2017-08-07 04:00:00	QQQ	ETF	143.9	144.0	143.9	143.97	3075.0
2017-08-07 05:00:00	QQQ	ETF	143.88	143.88	143.85	143.85	2580.0
2017-08-07 05:30:00	QQQ	ETF	143.85	143.85	143.74	143.76	4488.0
2017-08-07 06:00:00	QQQ	ETF	143.77	143.77	143.77	143.77	633.0
2017-08-07 06:30:00	QQQ	ETF	143.75	143.86	143.75	143.85	5800.0
2017-08-07 07:00:00	QQQ	ETF	143.86	143.86	143.78	143.8	1825.0
2017-08-07 07:30:00	QQQ	ETF	143.73	143.79	143.69	143.79	3816.0
2017-08-07 08:00:00	QQQ	ETF	143.79	143.94	143.79	143.94	114421.0
2017-08-07 08:30:00	QQQ	ETF	143.91	143.91	143.84	143.84	103771.0
2017-08-07 09:00:00	QQQ	ETF	143.84	143.93	143.82	143.9	90962.0
2017-08-07 09:30:00	QQQ	ETF	143.89	144.045	143.71	144.01	2139049.0
2017-08-07 10:00:00	QQQ	ETF	144.02	144.14	143.935	144.05	1026950.0
2017-08-07 10:30:00	QQQ	ETF	144.06	144.21	143.995	144.15	1208417.0
2017-08-07 11:00:00	QQQ	ETF	144.14	144.36	144.09	144.34	1285117.0
2017-08-07 11:30:00	QQQ	ETF	144.34	144.39	144.28	144.32	891998.0
2017-08-07 12:00:00	QQQ	ETF	144.32	144.38	144.265	144.29	431424.0
2017-08-07 12:30:00	QQQ	ETF	144.3	144.369	144.21	144.369	547165.0
2017-08-07 13:00:00	QQQ	ETF	144.36	144.37	144.25	144.34	541269.0

> showing 50 of 14,628 rows — these rows as CSV

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