PREVIEW / etf_30min / 2014-08-06

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-06.parquet
  size:    347 KB
  rows:    11,730

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-08-06 04:00:00	SPY	ETF	192.2	192.23	192.08	192.08	22980.0
2014-08-06 04:30:00	SPY	ETF	192.07	192.57	191.73	192.56	94038.0
2014-08-06 05:00:00	SPY	ETF	191.69	191.76	191.55	191.56	22442.0
2014-08-06 05:30:00	SPY	ETF	191.55	191.7	191.44	191.6	22996.0
2014-08-06 06:00:00	SPY	ETF	191.62	191.62	190.96	191.0	169462.0
2014-08-06 06:30:00	SPY	ETF	191.0	191.32	190.85	191.15	233735.0
2014-08-06 07:00:00	SPY	ETF	191.17	191.39	191.1	191.33	266798.0
2014-08-06 07:30:00	SPY	ETF	191.39	191.43	191.17	191.18	252834.0
2014-08-06 08:00:00	SPY	ETF	191.39	192.1	191.07	191.22	734829.0
2014-08-06 08:30:00	SPY	ETF	191.19	191.41	191.02	191.14	921754.0
2014-08-06 09:00:00	SPY	ETF	191.13	191.25	190.97	191.09	1536055.0
2014-08-06 09:30:00	SPY	ETF	191.11	192.11	191.08	191.77	14809666.0
2014-08-06 10:00:00	SPY	ETF	191.76	192.43	191.74	192.41	11345001.0
2014-08-06 10:30:00	SPY	ETF	192.42	192.74	192.08	192.71	7974356.0
2014-08-06 11:00:00	SPY	ETF	192.71	192.81	192.3	192.32	6555791.0
2014-08-06 11:30:00	SPY	ETF	192.32	192.85	192.3	192.78	5044479.0
2014-08-06 12:00:00	SPY	ETF	192.78	192.89	192.31	192.44	6051684.0
2014-08-06 12:30:00	SPY	ETF	192.44	192.81	192.35	192.41	4859188.0
2014-08-06 13:00:00	SPY	ETF	192.41	192.51	192.21	192.26	3386392.0
2014-08-06 13:30:00	SPY	ETF	192.26	192.4	191.92	191.975	4887631.0
2014-08-06 14:00:00	SPY	ETF	191.96	192.19	191.84	192.155	3351440.0
2014-08-06 14:30:00	SPY	ETF	192.16	192.29	191.85	192.1241	4547673.0
2014-08-06 15:00:00	SPY	ETF	192.12	192.33	192.05	192.12	5033372.0
2014-08-06 15:30:00	SPY	ETF	192.12	192.22	191.96	192.05	8132337.0
2014-08-06 16:00:00	SPY	ETF	192.05	192.6806	191.2	192.03	3191661.0
2014-08-06 16:30:00	SPY	ETF	192.03	192.08	192.01	192.06	616274.0
2014-08-06 17:00:00	SPY	ETF	192.07	192.07	192.02	192.03	46732.0
2014-08-06 17:30:00	SPY	ETF	192.05	192.07	192.05	192.05	6900.0
2014-08-06 18:00:00	SPY	ETF	192.04	192.07	191.93	191.94	75695.0
2014-08-06 18:30:00	SPY	ETF	191.94	192.02	191.92	191.97	32205.0
2014-08-06 19:00:00	SPY	ETF	191.98	192.02	191.96	192.02	13851.0
2014-08-06 19:30:00	SPY	ETF	192.03	192.16	192.03	192.15	66875.0
2014-08-06 04:00:00	QQQ	ETF	94.77	94.77	94.77	94.77	250.0
2014-08-06 04:30:00	QQQ	ETF	94.55	94.62	94.55	94.55	21298.0
2014-08-06 05:00:00	QQQ	ETF	94.49	94.49	94.45	94.45	22800.0
2014-08-06 05:30:00	QQQ	ETF	94.41	94.46	94.4	94.46	11300.0
2014-08-06 06:00:00	QQQ	ETF	94.46	94.46	94.07	94.08	31087.0
2014-08-06 06:30:00	QQQ	ETF	94.0	94.21	93.99	94.15	55724.0
2014-08-06 07:00:00	QQQ	ETF	94.14	94.23	94.08	94.2	55265.0
2014-08-06 07:30:00	QQQ	ETF	94.19	94.22	94.12	94.15	225896.0
2014-08-06 08:00:00	QQQ	ETF	94.16	94.245	94.06	94.13	640550.0
2014-08-06 08:30:00	QQQ	ETF	94.13	94.22	94.04	94.09	179036.0
2014-08-06 09:00:00	QQQ	ETF	94.09	94.1	93.97	93.99	470472.0
2014-08-06 09:30:00	QQQ	ETF	93.99	94.49	93.92	94.27	6221657.0
2014-08-06 10:00:00	QQQ	ETF	94.27	94.74	94.27	94.73	4622573.0
2014-08-06 10:30:00	QQQ	ETF	94.73	94.9	94.56	94.88	3180307.0
2014-08-06 11:00:00	QQQ	ETF	94.87	94.97	94.71	94.77	2155118.0
2014-08-06 11:30:00	QQQ	ETF	94.77	95.09	94.76	95.03	1753546.0
2014-08-06 12:00:00	QQQ	ETF	95.03	95.11	94.79	94.83	1993522.0
2014-08-06 12:30:00	QQQ	ETF	94.84	95.03	94.82	94.86	1368326.0

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

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