PREVIEW / etf_30min / 2013-11-14

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-14.parquet
  size:    327 KB
  rows:    11,117

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
2013-11-14 04:00:00	SPY	ETF	178.78	179.0	178.78	178.94	7892.0
2013-11-14 04:30:00	SPY	ETF	178.95	178.99	178.93	178.94	2100.0
2013-11-14 05:00:00	SPY	ETF	178.93	178.93	178.83	178.83	2300.0
2013-11-14 05:30:00	SPY	ETF	178.83	178.9	178.83	178.9	7673.0
2013-11-14 06:00:00	SPY	ETF	178.85	178.85	178.7	178.71	25241.0
2013-11-14 06:30:00	SPY	ETF	178.71	178.78	178.61	178.65	38750.0
2013-11-14 07:00:00	SPY	ETF	178.67	178.73	178.59	178.61	301592.0
2013-11-14 07:30:00	SPY	ETF	178.63	178.7	178.56	178.67	80413.0
2013-11-14 08:00:00	SPY	ETF	178.67	178.9	178.6	178.74	622808.0
2013-11-14 08:30:00	SPY	ETF	178.75	178.82	178.59	178.61	735232.0
2013-11-14 09:00:00	SPY	ETF	178.6	178.64	178.49	178.55	773936.0
2013-11-14 09:30:00	SPY	ETF	178.54	178.75	178.3	178.56	12629327.0
2013-11-14 10:00:00	SPY	ETF	178.57	178.72	178.25	178.47	9355315.0
2013-11-14 10:30:00	SPY	ETF	178.48	179.08	178.431	178.89	11831187.0
2013-11-14 11:00:00	SPY	ETF	178.89	179.36	178.8	179.13	9283472.0
2013-11-14 11:30:00	SPY	ETF	179.13	179.19	178.91	178.98	6005032.0
2013-11-14 12:00:00	SPY	ETF	178.985	179.13	178.96	179.061	2597292.0
2013-11-14 12:30:00	SPY	ETF	179.0701	179.17	178.93	178.98	6686683.0
2013-11-14 13:00:00	SPY	ETF	178.98	179.19	178.96	179.09	4224150.0
2013-11-14 13:30:00	SPY	ETF	179.09	179.15	179.01	179.13	3081711.0
2013-11-14 14:00:00	SPY	ETF	179.14	179.3	179.04	179.25	5520431.0
2013-11-14 14:30:00	SPY	ETF	179.26	179.28	179.095	179.151	5035977.0
2013-11-14 15:00:00	SPY	ETF	179.155	179.4	179.12	179.275	5014145.0
2013-11-14 15:30:00	SPY	ETF	179.28	179.42	179.22	179.31	12011453.0
2013-11-14 16:00:00	SPY	ETF	179.31	179.3628	179.08	179.26	5357449.0
2013-11-14 16:30:00	SPY	ETF	179.27	179.31	179.26	179.31	224142.0
2013-11-14 17:00:00	SPY	ETF	179.32	179.32	179.26	179.29	234732.0
2013-11-14 17:30:00	SPY	ETF	179.28	179.29	179.23	179.28	61601.0
2013-11-14 18:00:00	SPY	ETF	179.29	179.29	179.18	179.23	117758.0
2013-11-14 18:30:00	SPY	ETF	179.24	179.27	179.22	179.26	12493.0
2013-11-14 19:00:00	SPY	ETF	179.22	179.27	179.21	179.24	59392.0
2013-11-14 19:30:00	SPY	ETF	179.25	179.27	179.21	179.25	55291.0
2013-11-14 04:00:00	QQQ	ETF	83.43	83.43	83.3	83.42	9900.0
2013-11-14 04:30:00	QQQ	ETF	83.4	83.4	83.4	83.4	1000.0
2013-11-14 05:00:00	QQQ	ETF	83.36	83.36	83.36	83.36	1000.0
2013-11-14 05:30:00	QQQ	ETF	83.36	83.36	83.35	83.35	800.0
2013-11-14 06:00:00	QQQ	ETF	83.34	83.34	83.26	83.26	6700.0
2013-11-14 06:30:00	QQQ	ETF	83.28	83.3	83.26	83.26	59400.0
2013-11-14 07:00:00	QQQ	ETF	83.26	83.32	83.26	83.26	191675.0
2013-11-14 07:30:00	QQQ	ETF	83.28	83.32	83.24	83.32	40349.0
2013-11-14 08:00:00	QQQ	ETF	83.32	83.39	83.28	83.35	96518.0
2013-11-14 08:30:00	QQQ	ETF	83.35	83.42	83.26	83.27	137705.0
2013-11-14 09:00:00	QQQ	ETF	83.26	83.32	83.23	83.3	250023.0
2013-11-14 09:30:00	QQQ	ETF	83.29	83.47	83.14	83.455	6134014.0
2013-11-14 10:00:00	QQQ	ETF	83.45	83.47	83.23	83.37	3735459.0
2013-11-14 10:30:00	QQQ	ETF	83.38	83.64	83.36	83.52	2755507.0
2013-11-14 11:00:00	QQQ	ETF	83.52	83.75	83.48	83.67	1980916.0
2013-11-14 11:30:00	QQQ	ETF	83.67	83.69	83.53	83.53	1167647.0
2013-11-14 12:00:00	QQQ	ETF	83.54	83.57	83.4401	83.5299	926205.0
2013-11-14 12:30:00	QQQ	ETF	83.53	83.6	83.51	83.54	750312.0

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

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