PREVIEW / etf_30min / 2014-01-16

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-16.parquet
  size:    335 KB
  rows:    11,421

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-01-16 04:00:00	SPY	ETF	184.42	184.42	184.25	184.25	39680.0
2014-01-16 04:30:00	SPY	ETF	184.25	184.33	184.25	184.33	2328.0
2014-01-16 05:00:00	SPY	ETF	184.36	184.36	184.25	184.25	2844.0
2014-01-16 05:30:00	SPY	ETF	184.3	184.41	184.3	184.41	4525.0
2014-01-16 06:00:00	SPY	ETF	184.41	184.41	184.35	184.35	1543.0
2014-01-16 06:30:00	SPY	ETF	184.36	184.36	184.26	184.29	179807.0
2014-01-16 07:00:00	SPY	ETF	184.32	184.44	184.27	184.31	181684.0
2014-01-16 07:30:00	SPY	ETF	184.26	184.32	184.13	184.22	465116.0
2014-01-16 08:00:00	SPY	ETF	184.24	184.39	184.11	184.12	529903.0
2014-01-16 08:30:00	SPY	ETF	184.12	184.23	184.08	184.19	824699.0
2014-01-16 09:00:00	SPY	ETF	184.19	184.32	184.15	184.27	466643.0
2014-01-16 09:30:00	SPY	ETF	184.28	184.48	184.03	184.31	10665832.0
2014-01-16 10:00:00	SPY	ETF	184.31	184.46	184.14	184.33	6371532.0
2014-01-16 10:30:00	SPY	ETF	184.32	184.36	183.89	183.95	5051392.0
2014-01-16 11:00:00	SPY	ETF	183.95	184.17	183.83	184.11	4392772.0
2014-01-16 11:30:00	SPY	ETF	184.11	184.6618	184.06	184.28	4539388.0
2014-01-16 12:00:00	SPY	ETF	184.27	184.31	184.03	184.21	3101761.0
2014-01-16 12:30:00	SPY	ETF	184.2196	184.31	184.17	184.28	1506331.0
2014-01-16 13:00:00	SPY	ETF	184.28	184.5	184.15	184.43	3849972.0
2014-01-16 13:30:00	SPY	ETF	184.425	184.43	184.25	184.27	1656741.0
2014-01-16 14:00:00	SPY	ETF	184.27	184.35	184.16	184.26	3172223.0
2014-01-16 14:30:00	SPY	ETF	184.26	184.39	184.18	184.33	2611982.0
2014-01-16 15:00:00	SPY	ETF	184.331	184.35	184.21	184.28	4279455.0
2014-01-16 15:30:00	SPY	ETF	184.28	184.43	184.07	184.4	10818280.0
2014-01-16 16:00:00	SPY	ETF	184.4	184.42	183.96	184.01	4289414.0
2014-01-16 16:30:00	SPY	ETF	184.02	184.132	184.02	184.08	425250.0
2014-01-16 17:00:00	SPY	ETF	184.11	184.39	184.11	184.22	134421.0
2014-01-16 17:30:00	SPY	ETF	184.22	184.26	184.19	184.2	69320.0
2014-01-16 18:00:00	SPY	ETF	184.19	184.2	184.05	184.06	103004.0
2014-01-16 18:30:00	SPY	ETF	184.07	184.07	183.99	184.02	26667.0
2014-01-16 19:00:00	SPY	ETF	184.07	184.12	184.07	184.12	12400.0
2014-01-16 19:30:00	SPY	ETF	184.1	184.12	184.06	184.12	53199.0
2014-01-16 04:00:00	QQQ	ETF	88.27	88.27	88.27	88.27	896.0
2014-01-16 06:30:00	QQQ	ETF	88.26	88.27	88.26	88.27	450.0
2014-01-16 07:00:00	QQQ	ETF	88.3	88.3	88.3	88.3	200.0
2014-01-16 07:30:00	QQQ	ETF	88.27	88.28	88.21	88.24	94260.0
2014-01-16 08:00:00	QQQ	ETF	88.22	88.23	88.18	88.2	22984.0
2014-01-16 08:30:00	QQQ	ETF	88.19	88.25	88.19	88.21	127347.0
2014-01-16 09:00:00	QQQ	ETF	88.21	88.3	88.2	88.28	56253.0
2014-01-16 09:30:00	QQQ	ETF	88.28	88.42	88.16	88.33	3535576.0
2014-01-16 10:00:00	QQQ	ETF	88.32	88.47	88.27	88.45	1576411.0
2014-01-16 10:30:00	QQQ	ETF	88.45	88.4673	88.2	88.24	1232876.0
2014-01-16 11:00:00	QQQ	ETF	88.235	88.37	88.17	88.34	1070800.0
2014-01-16 11:30:00	QQQ	ETF	88.33	88.41	88.28	88.39	1892437.0
2014-01-16 12:00:00	QQQ	ETF	88.39	88.41	88.225	88.32	1473021.0
2014-01-16 12:30:00	QQQ	ETF	88.328	88.405	88.3	88.395	426050.0
2014-01-16 13:00:00	QQQ	ETF	88.4	88.51	88.35	88.48	724039.0
2014-01-16 13:30:00	QQQ	ETF	88.49	88.49	88.39	88.391	579523.0
2014-01-16 14:00:00	QQQ	ETF	88.39	88.45	88.31	88.4	1446114.0
2014-01-16 14:30:00	QQQ	ETF	88.41	88.44	88.36	88.411	565626.0

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

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