PREVIEW / etf_30min / 2014-11-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-07.parquet
  size:    356 KB
  rows:    11,970

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-07 04:00:00	SPY	ETF	203.41	203.72	203.41	203.68	5920.0
2014-11-07 04:30:00	SPY	ETF	203.67	203.67	203.54	203.61	8315.0
2014-11-07 05:00:00	SPY	ETF	203.67	203.67	203.56	203.57	10753.0
2014-11-07 05:30:00	SPY	ETF	203.57	203.57	203.17	203.3	133189.0
2014-11-07 06:00:00	SPY	ETF	203.27	203.35	203.17	203.27	10312.0
2014-11-07 06:30:00	SPY	ETF	203.2	203.37	203.2	203.37	16612.0
2014-11-07 07:00:00	SPY	ETF	203.37	203.48	203.32	203.43	26591.0
2014-11-07 07:30:00	SPY	ETF	203.42	203.42	203.22	203.33	177962.0
2014-11-07 08:00:00	SPY	ETF	203.36	203.5	203.26	203.43	587967.0
2014-11-07 08:30:00	SPY	ETF	203.5	203.85	203.15	203.48	2233445.0
2014-11-07 09:00:00	SPY	ETF	203.5	203.5	202.93	203.16	1629019.0
2014-11-07 09:30:00	SPY	ETF	203.17	203.27	202.65	202.9	10448249.0
2014-11-07 10:00:00	SPY	ETF	202.9	203.22	202.79	202.87	6216911.0
2014-11-07 10:30:00	SPY	ETF	202.87	203.4	202.61	203.34	6822195.0
2014-11-07 11:00:00	SPY	ETF	203.35	203.53	203.27	203.52	4929170.0
2014-11-07 11:30:00	SPY	ETF	203.51	203.5999	203.3001	203.31	3312412.0
2014-11-07 12:00:00	SPY	ETF	203.32	203.49	203.21	203.43	3222345.0
2014-11-07 12:30:00	SPY	ETF	203.44	203.44	203.27	203.3466	3008675.0
2014-11-07 13:00:00	SPY	ETF	203.35	203.45	203.28	203.41	2779386.0
2014-11-07 13:30:00	SPY	ETF	203.4	203.53	203.37	203.37	3764207.0
2014-11-07 14:00:00	SPY	ETF	203.38	203.44	203.16	203.22	3976806.0
2014-11-07 14:30:00	SPY	ETF	203.22	203.27	202.95	203.02	4765584.0
2014-11-07 15:00:00	SPY	ETF	203.02	203.21	202.81	202.81	5758619.0
2014-11-07 15:30:00	SPY	ETF	202.82	203.38	202.76	203.37	12091949.0
2014-11-07 16:00:00	SPY	ETF	203.37	203.4	203.1	203.12	5224794.0
2014-11-07 16:30:00	SPY	ETF	203.12	203.34	203.03	203.13	2422012.0
2014-11-07 17:00:00	SPY	ETF	203.15	203.17	203.11	203.13	287314.0
2014-11-07 17:30:00	SPY	ETF	203.13	203.14	203.08	203.14	45633.0
2014-11-07 18:00:00	SPY	ETF	203.14	203.15	203.06	203.07	37852.0
2014-11-07 18:30:00	SPY	ETF	203.09	203.14	203.07	203.14	8848.0
2014-11-07 19:00:00	SPY	ETF	203.14	203.14	203.13	203.13	3150.0
2014-11-07 19:30:00	SPY	ETF	203.15	203.17	203.15	203.16	15835.0
2014-11-07 04:00:00	QQQ	ETF	101.85	102.07	101.85	102.06	500.0
2014-11-07 07:00:00	QQQ	ETF	101.88	101.97	101.84	101.92	11550.0
2014-11-07 07:30:00	QQQ	ETF	101.87	101.9	101.83	101.87	16720.0
2014-11-07 08:00:00	QQQ	ETF	101.9	101.98	101.83	101.9	75504.0
2014-11-07 08:30:00	QQQ	ETF	101.85	102.11	101.69	101.95	302956.0
2014-11-07 09:00:00	QQQ	ETF	101.91	101.91	101.69	101.87	617376.0
2014-11-07 09:30:00	QQQ	ETF	101.87	101.91	101.4098	101.51	4175527.0
2014-11-07 10:00:00	QQQ	ETF	101.5	101.5	101.16	101.2	1968674.0
2014-11-07 10:30:00	QQQ	ETF	101.21	101.54	101.07	101.47	1826846.0
2014-11-07 11:00:00	QQQ	ETF	101.47	101.5999	101.365	101.589	915581.0
2014-11-07 11:30:00	QQQ	ETF	101.59	101.61	101.42	101.43	703032.0
2014-11-07 12:00:00	QQQ	ETF	101.44	101.55	101.395	101.51	578641.0
2014-11-07 12:30:00	QQQ	ETF	101.51	101.55	101.45	101.504	558674.0
2014-11-07 13:00:00	QQQ	ETF	101.51	101.59	101.47	101.59	443198.0
2014-11-07 13:30:00	QQQ	ETF	101.59	101.73	101.59	101.63	940671.0
2014-11-07 14:00:00	QQQ	ETF	101.64	101.66	101.43	101.48	633956.0
2014-11-07 14:30:00	QQQ	ETF	101.48	101.519	101.385	101.4166	559929.0
2014-11-07 15:00:00	QQQ	ETF	101.42	101.53	101.3	101.31	938027.0

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

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