PREVIEW / etf_30min / 2015-07-29

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-29.parquet
  size:    379 KB
  rows:    12,688

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-29 04:00:00	SPY	ETF	209.58	209.63	209.31	209.31	6150.0
2015-07-29 04:30:00	SPY	ETF	209.35	209.65	209.3	209.63	23438.0
2015-07-29 05:00:00	SPY	ETF	209.7	209.95	209.55	209.87	121332.0
2015-07-29 05:30:00	SPY	ETF	209.9	209.95	209.76	209.87	17401.0
2015-07-29 06:00:00	SPY	ETF	209.84	209.88	209.6	209.6	20100.0
2015-07-29 06:30:00	SPY	ETF	209.75	209.82	209.74	209.79	2679.0
2015-07-29 07:00:00	SPY	ETF	209.79	210.02	209.72	209.9	124811.0
2015-07-29 07:30:00	SPY	ETF	209.9	209.9	209.75	209.85	156994.0
2015-07-29 08:00:00	SPY	ETF	209.85	209.95	209.12	209.56	361625.0
2015-07-29 08:30:00	SPY	ETF	209.58	209.61	209.28	209.3	342428.0
2015-07-29 09:00:00	SPY	ETF	209.31	209.48	209.31	209.47	329593.0
2015-07-29 09:30:00	SPY	ETF	209.48	209.78	209.31	209.64	8327634.0
2015-07-29 10:00:00	SPY	ETF	209.63	209.9	209.43	209.705	6598789.0
2015-07-29 10:30:00	SPY	ETF	209.71	210.25	209.71	210.09	7558673.0
2015-07-29 11:00:00	SPY	ETF	210.09	210.44	209.92	210.28	5752966.0
2015-07-29 11:30:00	SPY	ETF	210.28	210.5	210.27	210.445	5091992.0
2015-07-29 12:00:00	SPY	ETF	210.44	210.47	210.14	210.27	3326894.0
2015-07-29 12:30:00	SPY	ETF	210.27	210.38	210.1	210.239	3331880.0
2015-07-29 13:00:00	SPY	ETF	210.23	210.33	210.18	210.235	2342174.0
2015-07-29 13:30:00	SPY	ETF	210.24	210.33	210.13	210.17	4060673.0
2015-07-29 14:00:00	SPY	ETF	210.18	210.84	209.79	210.36	17280580.0
2015-07-29 14:30:00	SPY	ETF	210.36	211.04	210.34	210.9	7502839.0
2015-07-29 15:00:00	SPY	ETF	210.905	210.95	210.66	210.84	8774067.0
2015-07-29 15:30:00	SPY	ETF	210.85	210.945	210.51	210.74	14747989.0
2015-07-29 16:00:00	SPY	ETF	210.74	210.9	210.62	210.69	4539985.0
2015-07-29 16:30:00	SPY	ETF	210.71	210.77	210.62	210.65	2408875.0
2015-07-29 17:00:00	SPY	ETF	210.66	210.74	210.62	210.64	93740.0
2015-07-29 17:30:00	SPY	ETF	210.63	210.64	210.59	210.59	553842.0
2015-07-29 18:00:00	SPY	ETF	210.58	210.58	210.45	210.47	208399.0
2015-07-29 18:30:00	SPY	ETF	210.53	210.54	210.42	210.43	23785.0
2015-07-29 19:00:00	SPY	ETF	210.5	210.5	210.44	210.463	27490.0
2015-07-29 19:30:00	SPY	ETF	210.5	210.54	210.5	210.53	56125.0
2015-07-29 04:00:00	QQQ	ETF	111.34	111.34	111.34	111.34	1000.0
2015-07-29 04:30:00	QQQ	ETF	111.33	111.33	111.33	111.33	650.0
2015-07-29 05:00:00	QQQ	ETF	111.44	111.49	111.44	111.49	65100.0
2015-07-29 06:00:00	QQQ	ETF	111.52	111.52	111.4	111.4	8300.0
2015-07-29 07:00:00	QQQ	ETF	111.5	111.6	111.47	111.59	6225.0
2015-07-29 07:30:00	QQQ	ETF	111.55	111.55	111.41	111.47	23000.0
2015-07-29 08:00:00	QQQ	ETF	111.59	111.59	111.33	111.38	91500.0
2015-07-29 08:30:00	QQQ	ETF	111.4	111.4	111.22	111.23	114118.0
2015-07-29 09:00:00	QQQ	ETF	111.22	111.45	111.22	111.36	109993.0
2015-07-29 09:30:00	QQQ	ETF	111.37	111.53	111.06	111.15	2913687.0
2015-07-29 10:00:00	QQQ	ETF	111.14	111.37	110.94	111.1915	1925622.0
2015-07-29 10:30:00	QQQ	ETF	111.2	111.465	111.2	111.35	1271583.0
2015-07-29 11:00:00	QQQ	ETF	111.34	111.48	111.22	111.3	1150552.0
2015-07-29 11:30:00	QQQ	ETF	111.3	111.5	111.26	111.45	766576.0
2015-07-29 12:00:00	QQQ	ETF	111.45	111.48	111.22	111.32	561147.0
2015-07-29 12:30:00	QQQ	ETF	111.31	111.4045	111.24	111.3201	998606.0
2015-07-29 13:00:00	QQQ	ETF	111.33	111.38	111.29	111.33	817478.0
2015-07-29 13:30:00	QQQ	ETF	111.335	111.36	111.19	111.25	859950.0

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

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