PREVIEW / etf_30min / 2015-07-17

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-17.parquet
  size:    369 KB
  rows:    12,681

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
2015-07-17 04:00:00	SPY	ETF	212.2	212.2	212.04	212.06	1680.0
2015-07-17 04:30:00	SPY	ETF	212.06	212.06	212.06	212.06	200.0
2015-07-17 05:00:00	SPY	ETF	212.06	212.09	212.04	212.09	2766.0
2015-07-17 05:30:00	SPY	ETF	212.18	212.18	212.14	212.14	2802.0
2015-07-17 06:00:00	SPY	ETF	212.15	212.16	212.15	212.15	6700.0
2015-07-17 06:30:00	SPY	ETF	212.16	212.23	212.16	212.2	1706.0
2015-07-17 07:00:00	SPY	ETF	212.2	212.29	212.14	212.29	22161.0
2015-07-17 07:30:00	SPY	ETF	212.27	212.33	212.26	212.31	50534.0
2015-07-17 08:00:00	SPY	ETF	212.3	212.38	212.29	212.38	65846.0
2015-07-17 08:30:00	SPY	ETF	212.4	212.42	212.29	212.3	238254.0
2015-07-17 09:00:00	SPY	ETF	212.32	212.44	212.25	212.27	727215.0
2015-07-17 09:30:00	SPY	ETF	212.29	212.34	211.89	212.04	15143159.0
2015-07-17 10:00:00	SPY	ETF	212.05	212.19	211.8	211.94	12666477.0
2015-07-17 10:30:00	SPY	ETF	211.94	212.12	211.87	212.05	4596644.0
2015-07-17 11:00:00	SPY	ETF	212.06	212.14	211.98	212.1	3011992.0
2015-07-17 11:30:00	SPY	ETF	212.1	212.2	211.98	212.02	3803963.0
2015-07-17 12:00:00	SPY	ETF	212.02	212.06	211.87	211.9964	3245264.0
2015-07-17 12:30:00	SPY	ETF	211.99	212.11	211.915	212.06	2394655.0
2015-07-17 13:00:00	SPY	ETF	212.06	212.11	212.01	212.05	3157093.0
2015-07-17 13:30:00	SPY	ETF	212.05	212.09	211.95	212.0	3705804.0
2015-07-17 14:00:00	SPY	ETF	212.0	212.29	211.98	212.265	3546380.0
2015-07-17 14:30:00	SPY	ETF	212.27	212.34	212.22	212.2632	3995532.0
2015-07-17 15:00:00	SPY	ETF	212.26	212.38	212.15	212.36	4933482.0
2015-07-17 15:30:00	SPY	ETF	212.365	212.55	212.32	212.45	14793468.0
2015-07-17 16:00:00	SPY	ETF	212.45	212.51	212.36	212.43	6307643.0
2015-07-17 16:30:00	SPY	ETF	212.43	212.5	212.43	212.47	650193.0
2015-07-17 17:00:00	SPY	ETF	212.45	212.55	212.43	212.51	108588.0
2015-07-17 17:30:00	SPY	ETF	212.51	212.51	212.47	212.47	65151.0
2015-07-17 18:00:00	SPY	ETF	212.48	212.51	212.48	212.49	860138.0
2015-07-17 18:30:00	SPY	ETF	212.49	212.49	212.43	212.43	7507.0
2015-07-17 19:00:00	SPY	ETF	212.46	212.49	212.46	212.48	2598.0
2015-07-17 19:30:00	SPY	ETF	212.5	212.56	212.48	212.55	13735.0
2015-07-17 05:00:00	QQQ	ETF	112.59	112.59	112.59	112.59	2500.0
2015-07-17 05:30:00	QQQ	ETF	112.68	112.69	112.68	112.69	377.0
2015-07-17 06:00:00	QQQ	ETF	112.52	112.52	112.52	112.52	100.0
2015-07-17 06:30:00	QQQ	ETF	112.55	112.56	112.54	112.55	6600.0
2015-07-17 07:00:00	QQQ	ETF	112.54	112.65	112.54	112.65	11505.0
2015-07-17 07:30:00	QQQ	ETF	112.64	112.64	112.6	112.62	14494.0
2015-07-17 08:00:00	QQQ	ETF	112.62	112.76	112.57	112.76	382408.0
2015-07-17 08:30:00	QQQ	ETF	112.7	112.78	112.7	112.74	97766.0
2015-07-17 09:00:00	QQQ	ETF	112.73	112.84	112.69	112.83	668705.0
2015-07-17 09:30:00	QQQ	ETF	112.84	112.94	112.65	112.911	5095714.0
2015-07-17 10:00:00	QQQ	ETF	112.915	113.075	112.83	112.97	4457960.0
2015-07-17 10:30:00	QQQ	ETF	112.97	113.13	112.92	113.09	3757395.0
2015-07-17 11:00:00	QQQ	ETF	113.09	113.171	113.04	113.17	1987504.0
2015-07-17 11:30:00	QQQ	ETF	113.16	113.255	113.062	113.11	1383222.0
2015-07-17 12:00:00	QQQ	ETF	113.105	113.135	112.98	113.08	1008805.0
2015-07-17 12:30:00	QQQ	ETF	113.085	113.16	113.04	113.11	594751.0
2015-07-17 13:00:00	QQQ	ETF	113.11	113.15	113.04	113.13	937469.0
2015-07-17 13:30:00	QQQ	ETF	113.13	113.19	113.07	113.14	511434.0

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

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