PREVIEW / etf_30min / 2017-10-27

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-27.parquet
  size:    450 KB
  rows:    15,481

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-10-27 04:00:00	SPY	ETF	256.35	256.56	256.34	256.36	6744.0
2017-10-27 04:30:00	SPY	ETF	256.44	256.48	256.44	256.48	5500.0
2017-10-27 05:00:00	SPY	ETF	256.53	256.62	256.53	256.62	700.0
2017-10-27 05:30:00	SPY	ETF	256.65	256.76	256.65	256.67	8510.0
2017-10-27 06:00:00	SPY	ETF	256.7	256.7	256.58	256.58	1725.0
2017-10-27 06:30:00	SPY	ETF	256.54	256.65	256.54	256.65	4267.0
2017-10-27 07:00:00	SPY	ETF	256.62	256.69	256.57	256.57	39015.0
2017-10-27 07:30:00	SPY	ETF	256.58	256.62	256.55	256.56	86320.0
2017-10-27 08:00:00	SPY	ETF	256.57	256.62	256.17	256.44	248233.0
2017-10-27 08:30:00	SPY	ETF	256.46	256.56	256.38	256.5	233921.0
2017-10-27 09:00:00	SPY	ETF	256.5	256.65	256.43	256.52	350822.0
2017-10-27 09:30:00	SPY	ETF	256.47	256.63	256.16	256.51	7542695.0
2017-10-27 10:00:00	SPY	ETF	256.515	257.08	256.5	256.78	6591016.0
2017-10-27 10:30:00	SPY	ETF	256.79	256.99	256.73	256.93	2539352.0
2017-10-27 11:00:00	SPY	ETF	256.92	257.34	256.92	257.31	3873136.0
2017-10-27 11:30:00	SPY	ETF	257.315	257.51	257.31	257.455	3135531.0
2017-10-27 12:00:00	SPY	ETF	257.455	257.69	257.435	257.55	2284321.0
2017-10-27 12:30:00	SPY	ETF	257.54	257.745	257.52	257.6	1900266.0
2017-10-27 13:00:00	SPY	ETF	257.6	257.71	257.45	257.475	2348507.0
2017-10-27 13:30:00	SPY	ETF	257.475	257.7	257.47	257.69	1840254.0
2017-10-27 14:00:00	SPY	ETF	257.68	257.89	257.64	257.71	3112655.0
2017-10-27 14:30:00	SPY	ETF	257.71	257.76	257.55	257.64	3966219.0
2017-10-27 15:00:00	SPY	ETF	257.64	257.76	257.58	257.7	3619812.0
2017-10-27 15:30:00	SPY	ETF	257.705	257.76	257.43	257.68	22342298.0
2017-10-27 16:00:00	SPY	ETF	257.68	257.71	257.4	257.65	14809722.0
2017-10-27 16:30:00	SPY	ETF	257.65	257.71	257.52	257.52	868722.0
2017-10-27 17:00:00	SPY	ETF	257.52	257.56	257.49	257.52	379259.0
2017-10-27 17:30:00	SPY	ETF	257.52	257.67	257.41	257.6	153519.0
2017-10-27 18:00:00	SPY	ETF	257.59	257.59	257.52	257.55	26040.0
2017-10-27 18:30:00	SPY	ETF	257.56	257.62	257.56	257.61	16766.0
2017-10-27 19:00:00	SPY	ETF	257.61	257.63	257.59	257.63	8182.0
2017-10-27 19:30:00	SPY	ETF	257.61	257.65	257.56	257.58	117200.0
2017-10-27 04:00:00	QQQ	ETF	148.73	148.73	148.65	148.72	1429.0
2017-10-27 04:30:00	QQQ	ETF	148.74	148.74	148.68	148.68	3000.0
2017-10-27 05:00:00	QQQ	ETF	148.77	148.82	148.73	148.82	8290.0
2017-10-27 05:30:00	QQQ	ETF	148.82	148.91	148.82	148.89	14950.0
2017-10-27 06:00:00	QQQ	ETF	148.89	149.0	148.88	148.92	18775.0
2017-10-27 06:30:00	QQQ	ETF	148.93	148.95	148.91	148.92	4200.0
2017-10-27 07:00:00	QQQ	ETF	148.92	148.97	148.82	148.85	39166.0
2017-10-27 07:30:00	QQQ	ETF	148.85	149.07	148.85	149.01	161615.0
2017-10-27 08:00:00	QQQ	ETF	146.96	149.2	146.96	149.15	368051.0
2017-10-27 08:30:00	QQQ	ETF	149.15	149.46	149.15	149.41	469878.0
2017-10-27 09:00:00	QQQ	ETF	149.39	149.48	149.33	149.33	439053.0
2017-10-27 09:30:00	QQQ	ETF	149.33	149.93	149.2	149.79	7795224.0
2017-10-27 10:00:00	QQQ	ETF	149.8	150.48	149.75	150.18	5480103.0
2017-10-27 10:30:00	QQQ	ETF	150.18	150.3	150.09	150.09	2075364.0
2017-10-27 11:00:00	QQQ	ETF	150.1	150.6175	150.09	150.585	2561377.0
2017-10-27 11:30:00	QQQ	ETF	150.585	150.99	150.585	150.866	3676216.0
2017-10-27 12:00:00	QQQ	ETF	150.86	151.14	150.82	151.105	3145198.0
2017-10-27 12:30:00	QQQ	ETF	151.11	151.27	151.04	151.075	3017056.0

> showing 50 of 15,481 rows — these rows as CSV

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