PREVIEW / etf_30min / 2016-01-11

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-11.parquet
  size:    415 KB
  rows:    13,902

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
2016-01-11 04:00:00	SPY	ETF	193.11	193.23	192.5	192.6	24556.0
2016-01-11 04:30:00	SPY	ETF	192.66	192.83	192.49	192.72	11595.0
2016-01-11 05:00:00	SPY	ETF	192.8	192.83	192.39	192.39	10586.0
2016-01-11 05:30:00	SPY	ETF	192.5	192.5	191.97	192.47	13667.0
2016-01-11 06:00:00	SPY	ETF	192.26	192.75	192.05	192.48	38934.0
2016-01-11 06:30:00	SPY	ETF	192.58	192.8	192.42	192.67	49784.0
2016-01-11 07:00:00	SPY	ETF	192.56	192.79	192.5	192.72	108736.0
2016-01-11 07:30:00	SPY	ETF	192.61	192.61	192.27	192.5	182304.0
2016-01-11 08:00:00	SPY	ETF	192.07	193.37	191.22	192.99	871256.0
2016-01-11 08:30:00	SPY	ETF	192.97	193.1	192.7	192.91	547388.0
2016-01-11 09:00:00	SPY	ETF	192.95	193.11	192.51	193.01	888849.0
2016-01-11 09:30:00	SPY	ETF	193.01	193.41	191.925	192.095	17988928.0
2016-01-11 10:00:00	SPY	ETF	192.09	192.57	191.77	192.29	11456775.0
2016-01-11 10:30:00	SPY	ETF	192.3	192.85	191.35	191.49	11609916.0
2016-01-11 11:00:00	SPY	ETF	191.5	191.87	191.06	191.5631	12187478.0
2016-01-11 11:30:00	SPY	ETF	191.57	192.4	191.2	192.11	9003683.0
2016-01-11 12:00:00	SPY	ETF	192.12	192.1799	191.16	191.24	9122552.0
2016-01-11 12:30:00	SPY	ETF	191.225	191.57	191.07	191.32	6324295.0
2016-01-11 13:00:00	SPY	ETF	191.33	191.55	190.5	190.56	8520962.0
2016-01-11 13:30:00	SPY	ETF	190.56	190.82	189.82	190.185	11807294.0
2016-01-11 14:00:00	SPY	ETF	190.18	191.45	189.99	191.242	13503371.0
2016-01-11 14:30:00	SPY	ETF	191.25	191.57	190.81	190.97	9339016.0
2016-01-11 15:00:00	SPY	ETF	190.98	192.0	190.25	191.89	15697410.0
2016-01-11 15:30:00	SPY	ETF	191.885	192.79	191.83	192.08	26054683.0
2016-01-11 16:00:00	SPY	ETF	192.08	192.38	191.67	192.0	4788007.0
2016-01-11 16:30:00	SPY	ETF	192.0	192.06	191.75	191.84	493110.0
2016-01-11 17:00:00	SPY	ETF	191.87	191.87	191.77	191.77	74144.0
2016-01-11 17:30:00	SPY	ETF	191.79	192.11	191.77	191.9	583073.0
2016-01-11 18:00:00	SPY	ETF	191.92	192.25	191.85	192.05	155056.0
2016-01-11 18:30:00	SPY	ETF	192.09	192.45	191.99	192.42	118417.0
2016-01-11 19:00:00	SPY	ETF	192.44	192.5	192.17	192.33	139115.0
2016-01-11 19:30:00	SPY	ETF	192.33	192.54	192.21	192.41	63994.0
2016-01-11 04:00:00	QQQ	ETF	104.39	104.52	104.37	104.45	4600.0
2016-01-11 04:30:00	QQQ	ETF	104.46	104.46	104.42	104.42	2000.0
2016-01-11 05:00:00	QQQ	ETF	104.41	104.41	104.33	104.33	11100.0
2016-01-11 05:30:00	QQQ	ETF	104.26	104.27	104.06	104.06	5513.0
2016-01-11 06:00:00	QQQ	ETF	104.21	104.38	104.13	104.38	1400.0
2016-01-11 06:30:00	QQQ	ETF	104.37	104.54	104.37	104.44	8500.0
2016-01-11 07:00:00	QQQ	ETF	104.43	104.55	104.39	104.46	30100.0
2016-01-11 07:30:00	QQQ	ETF	104.43	104.45	104.31	104.36	13502.0
2016-01-11 08:00:00	QQQ	ETF	104.42	104.8	104.37	104.61	199445.0
2016-01-11 08:30:00	QQQ	ETF	104.63	104.76	104.56	104.69	34355.0
2016-01-11 09:00:00	QQQ	ETF	104.7	104.83	104.54	104.77	225289.0
2016-01-11 09:30:00	QQQ	ETF	104.79	105.06	104.08	104.19	4656193.0
2016-01-11 10:00:00	QQQ	ETF	104.18	104.58	104.05	104.321	3015329.0
2016-01-11 10:30:00	QQQ	ETF	104.32	104.585	103.64	103.75	3288771.0
2016-01-11 11:00:00	QQQ	ETF	103.75	103.9	103.5	103.69	2398949.0
2016-01-11 11:30:00	QQQ	ETF	103.69	104.41	103.475	104.18	2909281.0
2016-01-11 12:00:00	QQQ	ETF	104.2	104.22	103.525	103.585	2130085.0
2016-01-11 12:30:00	QQQ	ETF	103.57	103.8	103.475	103.63	1828530.0

> showing 50 of 13,902 rows — these rows as CSV

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