PREVIEW / etf_30min / 2014-09-19

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-19.parquet
  size:    350 KB
  rows:    11,770

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-09-19 04:00:00	SPY	ETF	201.75	201.75	201.48	201.59	9780.0
2014-09-19 05:00:00	SPY	ETF	201.65	201.7	201.6	201.63	1275.0
2014-09-19 05:30:00	SPY	ETF	201.55	201.59	201.49	201.49	7050.0
2014-09-19 06:00:00	SPY	ETF	201.46	201.61	201.46	201.58	27130.0
2014-09-19 06:30:00	SPY	ETF	201.52	201.56	201.47	201.52	60175.0
2014-09-19 07:00:00	SPY	ETF	201.52	201.57	201.4	201.42	124986.0
2014-09-19 07:30:00	SPY	ETF	201.42	201.5	201.29	201.37	128407.0
2014-09-19 08:00:00	SPY	ETF	201.47	202.45	201.23	201.36	294940.0
2014-09-19 08:30:00	SPY	ETF	201.35	201.59	201.35	201.54	840409.0
2014-09-19 09:00:00	SPY	ETF	201.54	201.82	201.36	201.54	2077878.0
2014-09-19 09:30:00	SPY	ETF	201.52	201.73	201.3	201.46	16874093.0
2014-09-19 10:00:00	SPY	ETF	201.45	201.899	201.18	201.19	10827625.0
2014-09-19 10:30:00	SPY	ETF	201.19	201.275	201.03	201.185	7067981.0
2014-09-19 11:00:00	SPY	ETF	201.19	201.33	201.12	201.14	4185770.0
2014-09-19 11:30:00	SPY	ETF	201.14	201.155	200.88	200.99	6228912.0
2014-09-19 12:00:00	SPY	ETF	200.99	201.02	200.62	200.81	8232540.0
2014-09-19 12:30:00	SPY	ETF	200.81	200.93	200.55	200.68	4948106.0
2014-09-19 13:00:00	SPY	ETF	200.68	200.7	200.29	200.56	7004410.0
2014-09-19 13:30:00	SPY	ETF	200.56	200.79	200.53	200.69	4790916.0
2014-09-19 14:00:00	SPY	ETF	200.7	200.91	200.65	200.89	3696971.0
2014-09-19 14:30:00	SPY	ETF	200.89	201.05	200.79	201.01	5740831.0
2014-09-19 15:00:00	SPY	ETF	201.015	201.07	200.86	200.88	4731017.0
2014-09-19 15:30:00	SPY	ETF	200.88	201.09	200.68	200.73	15019081.0
2014-09-19 16:00:00	SPY	ETF	200.71	200.96	200.58	200.79	9242683.0
2014-09-19 16:30:00	SPY	ETF	200.79	200.79	200.48	200.56	4000695.0
2014-09-19 17:00:00	SPY	ETF	200.55	200.6	200.45	200.53	827758.0
2014-09-19 17:30:00	SPY	ETF	200.5	200.5	200.3	200.38	165396.0
2014-09-19 18:00:00	SPY	ETF	200.35	200.43	200.34	200.35	119463.0
2014-09-19 18:30:00	SPY	ETF	200.35	200.35	200.3	200.3	42859.0
2014-09-19 19:00:00	SPY	ETF	200.34	200.35	200.33	200.35	10600.0
2014-09-19 19:30:00	SPY	ETF	200.33	200.35	200.28	200.28	19714.0
2014-09-19 04:00:00	QQQ	ETF	100.45	100.46	100.4	100.46	21498.0
2014-09-19 04:30:00	QQQ	ETF	100.49	100.49	100.48	100.48	1600.0
2014-09-19 05:00:00	QQQ	ETF	100.49	100.49	100.49	100.49	564.0
2014-09-19 05:30:00	QQQ	ETF	100.47	100.47	100.44	100.45	3300.0
2014-09-19 06:00:00	QQQ	ETF	100.47	100.47	100.44	100.44	30000.0
2014-09-19 06:30:00	QQQ	ETF	100.42	100.44	100.42	100.44	10575.0
2014-09-19 07:00:00	QQQ	ETF	100.44	100.46	100.38	100.4	50334.0
2014-09-19 07:30:00	QQQ	ETF	100.4	100.42	100.33	100.34	45900.0
2014-09-19 08:00:00	QQQ	ETF	100.37	100.37	100.31	100.34	40143.0
2014-09-19 08:30:00	QQQ	ETF	100.34	100.45	100.34	100.44	205137.0
2014-09-19 09:00:00	QQQ	ETF	100.44	100.47	100.36	100.44	803418.0
2014-09-19 09:30:00	QQQ	ETF	100.45	100.47	100.23	100.3773	5424795.0
2014-09-19 10:00:00	QQQ	ETF	100.37	100.43	100.22	100.22	3910499.0
2014-09-19 10:30:00	QQQ	ETF	100.22	100.28	100.09	100.251	2449787.0
2014-09-19 11:00:00	QQQ	ETF	100.25	100.335	100.18	100.19	1573311.0
2014-09-19 11:30:00	QQQ	ETF	100.19	100.195	99.965	100.08	2978213.0
2014-09-19 12:00:00	QQQ	ETF	100.0801	100.0939	99.68	99.73	3597652.0
2014-09-19 12:30:00	QQQ	ETF	99.73	99.77	99.6	99.74	3140108.0
2014-09-19 13:00:00	QQQ	ETF	99.74	99.77	99.58	99.761	1815322.0

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

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