PREVIEW / etf_30min / 2015-07-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-23.parquet
  size:    385 KB
  rows:    12,863

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-07-23 04:00:00	SPY	ETF	211.68	211.7	211.67	211.68	625.0
2015-07-23 04:30:00	SPY	ETF	211.63	211.63	211.56	211.56	500.0
2015-07-23 05:00:00	SPY	ETF	211.68	211.68	211.63	211.63	26500.0
2015-07-23 05:30:00	SPY	ETF	211.66	211.71	211.63	211.7	24000.0
2015-07-23 06:00:00	SPY	ETF	211.82	211.82	211.71	211.73	54347.0
2015-07-23 06:30:00	SPY	ETF	211.72	211.76	211.62	211.62	28442.0
2015-07-23 07:00:00	SPY	ETF	211.69	211.73	211.45	211.45	89985.0
2015-07-23 07:30:00	SPY	ETF	211.45	211.67	211.4	211.6	108428.0
2015-07-23 08:00:00	SPY	ETF	211.58	211.98	211.43	211.47	221781.0
2015-07-23 08:30:00	SPY	ETF	211.49	211.54	211.36	211.37	292127.0
2015-07-23 09:00:00	SPY	ETF	211.38	211.6	211.29	211.51	430602.0
2015-07-23 09:30:00	SPY	ETF	211.53	211.65	211.03	211.17	7488821.0
2015-07-23 10:00:00	SPY	ETF	211.17	211.53	211.02	211.5	4805984.0
2015-07-23 10:30:00	SPY	ETF	211.52	211.63	211.34	211.4306	3583776.0
2015-07-23 11:00:00	SPY	ETF	211.45	211.48	210.93	210.98	4238460.0
2015-07-23 11:30:00	SPY	ETF	210.98	211.03	210.44	210.51	6920556.0
2015-07-23 12:00:00	SPY	ETF	210.515	210.56	210.13	210.3	8336244.0
2015-07-23 12:30:00	SPY	ETF	210.29	210.4	210.17	210.34	4305233.0
2015-07-23 13:00:00	SPY	ETF	210.34	210.45	210.15	210.3291	3669297.0
2015-07-23 13:30:00	SPY	ETF	210.32	210.75	210.18	210.68	4490886.0
2015-07-23 14:00:00	SPY	ETF	210.69	210.7	210.37	210.49	6756333.0
2015-07-23 14:30:00	SPY	ETF	210.49	211.3258	210.07	210.18	5069910.0
2015-07-23 15:00:00	SPY	ETF	210.17	210.18	209.75	209.95	10250464.0
2015-07-23 15:30:00	SPY	ETF	209.955	210.23	209.795	210.17	12502921.0
2015-07-23 16:00:00	SPY	ETF	210.17	210.55	210.0	210.55	3062069.0
2015-07-23 16:30:00	SPY	ETF	210.55	210.74	210.18	210.73	1923436.0
2015-07-23 17:00:00	SPY	ETF	210.72	210.8	210.14	210.75	212847.0
2015-07-23 17:30:00	SPY	ETF	210.76	210.77	210.71	210.72	11350.0
2015-07-23 18:00:00	SPY	ETF	210.72	210.75	210.63	210.63	45850.0
2015-07-23 18:30:00	SPY	ETF	210.64	210.68	210.62	210.66	37428.0
2015-07-23 19:00:00	SPY	ETF	210.68	210.68	210.54	210.57	16291.0
2015-07-23 19:30:00	SPY	ETF	210.58	210.6	210.52	210.6	34807.0
2015-07-23 06:00:00	QQQ	ETF	113.04	113.04	113.04	113.04	500.0
2015-07-23 06:30:00	QQQ	ETF	113.01	113.01	113.01	113.01	200.0
2015-07-23 07:00:00	QQQ	ETF	112.9	112.91	112.87	112.87	16547.0
2015-07-23 07:30:00	QQQ	ETF	112.84	112.93	112.83	112.88	31367.0
2015-07-23 08:00:00	QQQ	ETF	112.88	112.88	112.8	112.8	7619.0
2015-07-23 08:30:00	QQQ	ETF	112.8	112.87	112.69	112.69	81057.0
2015-07-23 09:00:00	QQQ	ETF	112.68	112.87	112.66	112.74	139559.0
2015-07-23 09:30:00	QQQ	ETF	112.73	112.91	112.52	112.69	2892257.0
2015-07-23 10:00:00	QQQ	ETF	112.69	113.06	112.61	113.05	1744271.0
2015-07-23 10:30:00	QQQ	ETF	113.06	113.07	112.89	113.03	1020853.0
2015-07-23 11:00:00	QQQ	ETF	113.035	113.1	112.795	112.83	857786.0
2015-07-23 11:30:00	QQQ	ETF	112.83	112.835	112.46	112.52	1760444.0
2015-07-23 12:00:00	QQQ	ETF	112.52	112.54	112.27	112.37	1764716.0
2015-07-23 12:30:00	QQQ	ETF	112.34	112.46	112.27	112.38	933654.0
2015-07-23 13:00:00	QQQ	ETF	112.385	112.42	112.23	112.3565	632898.0
2015-07-23 13:30:00	QQQ	ETF	112.36	112.62	112.19	112.564	1108872.0
2015-07-23 14:00:00	QQQ	ETF	112.57	112.58	112.35	112.44	555756.0
2015-07-23 14:30:00	QQQ	ETF	112.4345	112.54	112.17	112.21	1333982.0

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

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