PREVIEW / etf_30min / 2014-06-16

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-16.parquet
  size:    324 KB
  rows:    11,185

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
2014-06-16 04:00:00	SPY	ETF	193.7	193.7	193.53	193.53	535.0
2014-06-16 06:00:00	SPY	ETF	193.99	194.42	193.53	193.72	70531.0
2014-06-16 06:30:00	SPY	ETF	193.71	193.78	193.65	193.67	31075.0
2014-06-16 07:00:00	SPY	ETF	193.71	193.77	193.6	193.62	77775.0
2014-06-16 07:30:00	SPY	ETF	193.66	193.77	193.66	193.73	114986.0
2014-06-16 08:00:00	SPY	ETF	193.777	193.78	193.64	193.78	351105.0
2014-06-16 08:30:00	SPY	ETF	193.78	193.9	193.76	193.85	686147.0
2014-06-16 09:00:00	SPY	ETF	193.86	193.98	193.8	193.9	1630464.0
2014-06-16 09:30:00	SPY	ETF	193.89	194.42	193.73	194.27	11628000.0
2014-06-16 10:00:00	SPY	ETF	194.28	194.7	194.25	194.55	7577119.0
2014-06-16 10:30:00	SPY	ETF	194.55	194.67	194.44	194.47	4389152.0
2014-06-16 11:00:00	SPY	ETF	194.48	194.49	193.88	193.96	6928435.0
2014-06-16 11:30:00	SPY	ETF	193.955	193.97	193.66	193.865	5382636.0
2014-06-16 12:00:00	SPY	ETF	193.87	194.23	193.81	194.205	2912167.0
2014-06-16 12:30:00	SPY	ETF	194.2	194.25	194.01	194.21	3363221.0
2014-06-16 13:00:00	SPY	ETF	194.2	194.47	194.15	194.42	2246717.0
2014-06-16 13:30:00	SPY	ETF	194.42	194.569	194.21	194.29	5380234.0
2014-06-16 14:00:00	SPY	ETF	194.28	194.395	194.22	194.33	4470324.0
2014-06-16 14:30:00	SPY	ETF	194.33	194.4	194.17	194.17	2302087.0
2014-06-16 15:00:00	SPY	ETF	194.18	194.19	193.97	194.13	3375463.0
2014-06-16 15:30:00	SPY	ETF	194.13	194.37	194.11	194.3	8397570.0
2014-06-16 16:00:00	SPY	ETF	194.3	194.604	194.1526	194.3	5291009.0
2014-06-16 16:30:00	SPY	ETF	194.28	194.29	194.1781	194.29	7947339.0
2014-06-16 17:00:00	SPY	ETF	194.3	194.32	194.26	194.3	538502.0
2014-06-16 17:30:00	SPY	ETF	194.3	194.31	194.3	194.31	2400.0
2014-06-16 18:00:00	SPY	ETF	194.3	194.39	194.3	194.35	8860.0
2014-06-16 18:30:00	SPY	ETF	194.37	194.37	194.32	194.32	11425.0
2014-06-16 19:00:00	SPY	ETF	194.36	194.36	194.34	194.35	23820.0
2014-06-16 19:30:00	SPY	ETF	194.34	194.36	194.33	194.33	19564.0
2014-06-16 07:00:00	QQQ	ETF	92.11	92.11	92.08	92.1	2300.0
2014-06-16 07:30:00	QQQ	ETF	92.08	92.08	92.08	92.08	400.0
2014-06-16 08:00:00	QQQ	ETF	92.05	92.1	92.04	92.1	5350.0
2014-06-16 08:30:00	QQQ	ETF	92.15	92.19	92.12	92.17	73745.0
2014-06-16 09:00:00	QQQ	ETF	92.16	92.22	92.15	92.16	91072.0
2014-06-16 09:30:00	QQQ	ETF	92.16	92.52	92.06	92.43	3479892.0
2014-06-16 10:00:00	QQQ	ETF	92.44	92.67	92.39	92.455	2302320.0
2014-06-16 10:30:00	QQQ	ETF	92.455	92.57	92.385	92.42	1100354.0
2014-06-16 11:00:00	QQQ	ETF	92.42	92.43	92.1	92.15	1549661.0
2014-06-16 11:30:00	QQQ	ETF	92.14	92.14	91.96	92.13	1307638.0
2014-06-16 12:00:00	QQQ	ETF	92.13	92.33	92.1	92.3	1012030.0
2014-06-16 12:30:00	QQQ	ETF	92.305	92.345	92.191	92.3	611164.0
2014-06-16 13:00:00	QQQ	ETF	92.304	92.44	92.28	92.41	973400.0
2014-06-16 13:30:00	QQQ	ETF	92.41	92.48	92.215	92.26	747829.0
2014-06-16 14:00:00	QQQ	ETF	92.25	92.405	92.245	92.37	690933.0
2014-06-16 14:30:00	QQQ	ETF	92.375	92.46	92.33	92.3374	491307.0
2014-06-16 15:00:00	QQQ	ETF	92.33	92.36	92.22	92.3	684949.0
2014-06-16 15:30:00	QQQ	ETF	92.31	92.43	92.299	92.39	1900047.0
2014-06-16 16:00:00	QQQ	ETF	92.4	92.43	92.3143	92.42	3026450.0
2014-06-16 16:30:00	QQQ	ETF	92.41	92.41	92.41	92.41	300.0
2014-06-16 17:00:00	QQQ	ETF	92.43	92.43	92.43	92.43	200.0

> showing 50 of 11,185 rows — these rows as CSV

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