PREVIEW / etf_30min / 2014-11-06

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-06.parquet
  size:    362 KB
  rows:    12,248

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-06 04:00:00	SPY	ETF	202.08	202.11	201.9	202.04	41872.0
2014-11-06 04:30:00	SPY	ETF	202.03	202.12	201.98	201.98	9312.0
2014-11-06 05:00:00	SPY	ETF	202.04	202.1	202.04	202.1	4160.0
2014-11-06 05:30:00	SPY	ETF	202.06	202.22	202.06	202.21	9078.0
2014-11-06 06:00:00	SPY	ETF	202.26	202.31	202.13	202.18	8793.0
2014-11-06 06:30:00	SPY	ETF	202.18	202.24	202.13	202.15	19227.0
2014-11-06 07:00:00	SPY	ETF	202.2	202.22	201.92	201.95	110523.0
2014-11-06 07:30:00	SPY	ETF	201.96	202.19	201.92	201.97	102780.0
2014-11-06 08:00:00	SPY	ETF	201.98	202.12	201.96	202.08	103855.0
2014-11-06 08:30:00	SPY	ETF	202.11	203.3	202.07	202.94	2989273.0
2014-11-06 09:00:00	SPY	ETF	202.94	203.03	202.38	202.38	2238580.0
2014-11-06 09:30:00	SPY	ETF	202.39	202.7	202.13	202.28	13109977.0
2014-11-06 10:00:00	SPY	ETF	202.29	202.39	201.64	202.05	9222165.0
2014-11-06 10:30:00	SPY	ETF	202.04	202.48	201.77	202.405	6323943.0
2014-11-06 11:00:00	SPY	ETF	202.4	202.8	202.36	202.75	7653608.0
2014-11-06 11:30:00	SPY	ETF	202.745	202.87	202.54	202.64	6514421.0
2014-11-06 12:00:00	SPY	ETF	202.65	202.79	202.5	202.72	4070394.0
2014-11-06 12:30:00	SPY	ETF	202.73	202.83	202.56	202.77	3086851.0
2014-11-06 13:00:00	SPY	ETF	202.78	202.96	202.7	202.94	6508583.0
2014-11-06 13:30:00	SPY	ETF	202.935	203.01	202.79	202.98	4178301.0
2014-11-06 14:00:00	SPY	ETF	202.98	202.99	202.83	202.95	2198437.0
2014-11-06 14:30:00	SPY	ETF	202.94	203.08	202.76	203.02	3393589.0
2014-11-06 15:00:00	SPY	ETF	203.01	203.04	202.8	203.01	3909128.0
2014-11-06 15:30:00	SPY	ETF	203.01	203.26	202.96	203.18	10810959.0
2014-11-06 16:00:00	SPY	ETF	203.19	203.39	203.15	203.35	4423578.0
2014-11-06 16:30:00	SPY	ETF	203.35	203.45	203.15	203.4	5471122.0
2014-11-06 17:00:00	SPY	ETF	203.4	203.43	203.33	203.37	62309.0
2014-11-06 17:30:00	SPY	ETF	203.36	203.36	203.3	203.3	64530.0
2014-11-06 18:00:00	SPY	ETF	203.3	203.34	203.23	203.34	111387.0
2014-11-06 18:30:00	SPY	ETF	203.35	203.39	203.31	203.39	37255.0
2014-11-06 19:00:00	SPY	ETF	203.4	203.44	203.35	203.41	37670.0
2014-11-06 19:30:00	SPY	ETF	203.4	203.44	202.402	203.44	160048.0
2014-11-06 04:00:00	QQQ	ETF	101.06	101.06	101.06	101.06	1000.0
2014-11-06 06:00:00	QQQ	ETF	101.26	101.26	101.16	101.16	2500.0
2014-11-06 06:30:00	QQQ	ETF	101.2	101.23	101.19	101.23	6300.0
2014-11-06 07:00:00	QQQ	ETF	101.24	101.24	101.08	101.08	54537.0
2014-11-06 07:30:00	QQQ	ETF	101.09	101.21	101.08	101.08	62175.0
2014-11-06 08:00:00	QQQ	ETF	101.17	101.18	101.1	101.16	82222.0
2014-11-06 08:30:00	QQQ	ETF	101.19	101.7	101.18	101.58	500362.0
2014-11-06 09:00:00	QQQ	ETF	101.6	101.62	101.3	101.33	411442.0
2014-11-06 09:30:00	QQQ	ETF	101.32	101.51	101.16	101.35	4786863.0
2014-11-06 10:00:00	QQQ	ETF	101.35	101.43	101.0	101.13	2851435.0
2014-11-06 10:30:00	QQQ	ETF	101.12	101.28	100.921	101.22	1805707.0
2014-11-06 11:00:00	QQQ	ETF	101.22	101.48	101.19	101.46	1561176.0
2014-11-06 11:30:00	QQQ	ETF	101.45	101.47	101.26	101.315	878274.0
2014-11-06 12:00:00	QQQ	ETF	101.315	101.32	101.21	101.2738	941596.0
2014-11-06 12:30:00	QQQ	ETF	101.28	101.36	101.215	101.29	630405.0
2014-11-06 13:00:00	QQQ	ETF	101.29	101.42	101.285	101.41	535638.0
2014-11-06 13:30:00	QQQ	ETF	101.41	101.46	101.33	101.45	567259.0
2014-11-06 14:00:00	QQQ	ETF	101.46	101.49	101.3801	101.48	643505.0

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

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