PREVIEW / etf_30min / 2014-11-18

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-18.parquet
  size:    363 KB
  rows:    12,298

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-11-18 04:00:00	SPY	ETF	204.3	204.3	204.24	204.24	3500.0
2014-11-18 04:30:00	SPY	ETF	204.29	204.51	204.29	204.46	9600.0
2014-11-18 05:00:00	SPY	ETF	204.61	204.61	204.21	204.22	16200.0
2014-11-18 05:30:00	SPY	ETF	204.22	204.24	204.14	204.24	5800.0
2014-11-18 06:00:00	SPY	ETF	204.31	204.31	204.24	204.29	4700.0
2014-11-18 06:30:00	SPY	ETF	204.3	204.46	204.25	204.46	9598.0
2014-11-18 07:00:00	SPY	ETF	204.43	204.46	204.4	204.42	57323.0
2014-11-18 07:30:00	SPY	ETF	204.44	204.58	204.4	204.57	65929.0
2014-11-18 08:00:00	SPY	ETF	204.49	204.56	204.39	204.5	134180.0
2014-11-18 08:30:00	SPY	ETF	204.49	204.51	204.33	204.43	523324.0
2014-11-18 09:00:00	SPY	ETF	204.44	204.5	204.41	204.45	419926.0
2014-11-18 09:30:00	SPY	ETF	204.44	205.2	204.44	205.15	9549158.0
2014-11-18 10:00:00	SPY	ETF	205.16	205.3	205.0	205.0	7668938.0
2014-11-18 10:30:00	SPY	ETF	205.005	205.27	204.91	205.21	5092116.0
2014-11-18 11:00:00	SPY	ETF	205.211	205.31	205.14	205.17	3620717.0
2014-11-18 11:30:00	SPY	ETF	205.175	205.36	205.16	205.33	3739730.0
2014-11-18 12:00:00	SPY	ETF	205.34	205.4	205.22	205.32	4585104.0
2014-11-18 12:30:00	SPY	ETF	205.32	205.5	205.27	205.47	2825456.0
2014-11-18 13:00:00	SPY	ETF	205.48	205.63	205.43	205.61	3106904.0
2014-11-18 13:30:00	SPY	ETF	205.61	205.61	205.45	205.5599	2372672.0
2014-11-18 14:00:00	SPY	ETF	205.554	205.85	205.54	205.76	4090166.0
2014-11-18 14:30:00	SPY	ETF	205.76	205.9	205.69	205.73	3974980.0
2014-11-18 15:00:00	SPY	ETF	205.73	205.92	205.72	205.81	4106427.0
2014-11-18 15:30:00	SPY	ETF	205.81	205.825	205.46	205.55	12764135.0
2014-11-18 16:00:00	SPY	ETF	205.55	205.57	205.29	205.34	5469378.0
2014-11-18 16:30:00	SPY	ETF	205.34	205.41	205.3	205.34	517756.0
2014-11-18 17:00:00	SPY	ETF	205.35	205.55	205.35	205.38	624231.0
2014-11-18 17:30:00	SPY	ETF	205.38	205.45	205.34	205.44	65190.0
2014-11-18 18:00:00	SPY	ETF	205.42	205.42	205.21	205.24	115943.0
2014-11-18 18:30:00	SPY	ETF	205.26	205.28	205.25	205.25	20360.0
2014-11-18 19:00:00	SPY	ETF	205.26	205.33	205.26	205.3	13823.0
2014-11-18 19:30:00	SPY	ETF	205.29	205.32	205.26	205.3	10175.0
2014-11-18 04:00:00	QQQ	ETF	102.96	102.96	102.93	102.93	2600.0
2014-11-18 04:30:00	QQQ	ETF	103.02	103.02	103.02	103.02	1500.0
2014-11-18 05:00:00	QQQ	ETF	103.04	103.04	103.04	103.04	200.0
2014-11-18 05:30:00	QQQ	ETF	102.78	102.78	102.78	102.78	2000.0
2014-11-18 06:00:00	QQQ	ETF	102.81	102.82	102.8	102.8	2100.0
2014-11-18 06:30:00	QQQ	ETF	102.79	102.81	102.79	102.81	9100.0
2014-11-18 07:00:00	QQQ	ETF	102.87	102.9	102.87	102.87	3413.0
2014-11-18 07:30:00	QQQ	ETF	102.9	102.95	102.9	102.95	4521.0
2014-11-18 08:00:00	QQQ	ETF	102.93	102.97	102.93	102.95	30439.0
2014-11-18 08:30:00	QQQ	ETF	102.95	102.97	102.86	102.94	35469.0
2014-11-18 09:00:00	QQQ	ETF	102.96	103.02	102.96	103.0	186800.0
2014-11-18 09:30:00	QQQ	ETF	103.0	103.48	102.991	103.44	3257005.0
2014-11-18 10:00:00	QQQ	ETF	103.44	103.6	103.3931	103.42	1733848.0
2014-11-18 10:30:00	QQQ	ETF	103.41	103.505	103.34	103.45	1084508.0
2014-11-18 11:00:00	QQQ	ETF	103.459	103.4899	103.3001	103.33	823645.0
2014-11-18 11:30:00	QQQ	ETF	103.33	103.54	103.33	103.53	983537.0
2014-11-18 12:00:00	QQQ	ETF	103.5399	103.58	103.475	103.54	875697.0
2014-11-18 12:30:00	QQQ	ETF	103.544	103.64	103.5	103.62	658142.0

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

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