PREVIEW / etf_30min / 2015-05-15

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-15.parquet
  size:    367 KB
  rows:    12,570

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-05-15 04:00:00	SPY	ETF	212.45	212.79	212.45	212.7	16590.0
2015-05-15 04:30:00	SPY	ETF	212.72	212.75	212.7	212.72	4400.0
2015-05-15 05:00:00	SPY	ETF	212.74	212.76	212.7	212.76	1900.0
2015-05-15 05:30:00	SPY	ETF	212.72	212.75	212.7	212.72	25950.0
2015-05-15 06:00:00	SPY	ETF	212.74	212.81	212.7	212.74	29400.0
2015-05-15 06:30:00	SPY	ETF	212.73	212.73	212.6	212.6	51194.0
2015-05-15 07:00:00	SPY	ETF	212.56	212.61	212.5	212.55	35121.0
2015-05-15 07:30:00	SPY	ETF	212.5	212.69	212.47	212.69	108607.0
2015-05-15 08:00:00	SPY	ETF	212.66	212.72	212.46	212.46	302785.0
2015-05-15 08:30:00	SPY	ETF	212.47	212.6	212.45	212.48	250839.0
2015-05-15 09:00:00	SPY	ETF	212.48	212.5	212.33	212.45	856517.0
2015-05-15 09:30:00	SPY	ETF	212.44	212.61	212.12	212.27	10691223.0
2015-05-15 10:00:00	SPY	ETF	212.26	212.26	211.86	212.13	9118144.0
2015-05-15 10:30:00	SPY	ETF	212.13	212.37	211.95	212.29	5706138.0
2015-05-15 11:00:00	SPY	ETF	212.285	212.42	211.99	212.0501	4198208.0
2015-05-15 11:30:00	SPY	ETF	212.06	212.25	211.94	212.075	3288013.0
2015-05-15 12:00:00	SPY	ETF	212.08	212.15	211.94	212.04	2747526.0
2015-05-15 12:30:00	SPY	ETF	212.04	212.22	212.01	212.16	2863457.0
2015-05-15 13:00:00	SPY	ETF	212.16	212.23	212.04	212.09	2629169.0
2015-05-15 13:30:00	SPY	ETF	212.09	212.2057	212.05	212.09	1628134.0
2015-05-15 14:00:00	SPY	ETF	212.09	212.18	211.97	212.145	2212454.0
2015-05-15 14:30:00	SPY	ETF	212.145	212.39	212.14	212.32	4230370.0
2015-05-15 15:00:00	SPY	ETF	212.32	212.42	212.22	212.26	4616032.0
2015-05-15 15:30:00	SPY	ETF	212.26	212.48	212.23	212.47	9837007.0
2015-05-15 16:00:00	SPY	ETF	212.47	212.49	212.0	212.43	3192840.0
2015-05-15 16:30:00	SPY	ETF	212.42	212.56	212.26	212.56	4774529.0
2015-05-15 17:00:00	SPY	ETF	212.56	212.56	212.5	212.52	263939.0
2015-05-15 17:30:00	SPY	ETF	212.53	212.54	212.48	212.54	25673.0
2015-05-15 18:00:00	SPY	ETF	212.54	212.55	212.48	212.51	49737.0
2015-05-15 18:30:00	SPY	ETF	212.55	212.59	212.5	212.5	13633.0
2015-05-15 19:00:00	SPY	ETF	212.5	212.51	212.48	212.48	5230.0
2015-05-15 19:30:00	SPY	ETF	212.48	212.56	212.47	212.56	40687.0
2015-05-15 04:00:00	QQQ	ETF	109.79	109.8	109.79	109.8	650.0
2015-05-15 04:30:00	QQQ	ETF	109.92	109.95	109.89	109.89	1000.0
2015-05-15 05:30:00	QQQ	ETF	110.0	110.0	110.0	110.0	200.0
2015-05-15 06:00:00	QQQ	ETF	110.01	110.01	109.98	109.98	19200.0
2015-05-15 06:30:00	QQQ	ETF	109.97	110.0	109.92	109.92	33400.0
2015-05-15 07:00:00	QQQ	ETF	109.93	109.94	109.89	109.92	38489.0
2015-05-15 07:30:00	QQQ	ETF	109.9	109.96	109.9	109.96	30554.0
2015-05-15 08:00:00	QQQ	ETF	109.94	109.95	109.81	109.83	106957.0
2015-05-15 08:30:00	QQQ	ETF	109.84	109.9	109.8	109.84	102572.0
2015-05-15 09:00:00	QQQ	ETF	109.82	109.9	109.78	109.88	230896.0
2015-05-15 09:30:00	QQQ	ETF	109.86	110.01	109.53	109.6199	4025950.0
2015-05-15 10:00:00	QQQ	ETF	109.59	109.604	109.36	109.56	2969575.0
2015-05-15 10:30:00	QQQ	ETF	109.56	109.6899	109.43	109.66	1473449.0
2015-05-15 11:00:00	QQQ	ETF	109.65	109.72	109.45	109.45	1270038.0
2015-05-15 11:30:00	QQQ	ETF	109.455	109.5101	109.37	109.49	1079299.0
2015-05-15 12:00:00	QQQ	ETF	109.49	109.5245	109.4056	109.45	820171.0
2015-05-15 12:30:00	QQQ	ETF	109.45	109.56	109.43	109.4813	634608.0
2015-05-15 13:00:00	QQQ	ETF	109.485	109.56	109.39	109.41	609844.0

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

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