PREVIEW / etf_30min / 2011-02-14

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-14.parquet
  size:    271 KB
  rows:    9,231

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
2011-02-14 04:00:00	SPY	ETF	133.12	133.19	133.12	133.15	12550.0
2011-02-14 04:30:00	SPY	ETF	133.11	133.11	133.11	133.11	2500.0
2011-02-14 05:00:00	SPY	ETF	133.08	133.1	133.08	133.1	300.0
2011-02-14 05:30:00	SPY	ETF	133.09	133.09	132.99	132.99	3600.0
2011-02-14 06:00:00	SPY	ETF	133.03	133.05	133.0	133.03	4800.0
2011-02-14 06:30:00	SPY	ETF	132.98	133.0	132.92	132.97	11250.0
2011-02-14 07:00:00	SPY	ETF	133.0	133.09	132.98	133.09	348650.0
2011-02-14 07:30:00	SPY	ETF	133.09	133.1	132.99	133.02	114923.0
2011-02-14 08:00:00	SPY	ETF	133.02	133.05	132.99	133.02	453029.0
2011-02-14 08:30:00	SPY	ETF	133.02	133.04	132.92	133.04	259908.0
2011-02-14 09:00:00	SPY	ETF	133.02	133.07	133.01	133.04	380981.0
2011-02-14 09:30:00	SPY	ETF	133.03	133.18	132.96	133.07	12696995.0
2011-02-14 10:00:00	SPY	ETF	133.07	133.3	133.06	133.2	8891307.0
2011-02-14 10:30:00	SPY	ETF	133.2	133.23	132.88	133.015	11372494.0
2011-02-14 11:00:00	SPY	ETF	133.02	133.18	132.93	133.121	5527648.0
2011-02-14 11:30:00	SPY	ETF	133.125	133.21	133.09	133.21	3145876.0
2011-02-14 12:00:00	SPY	ETF	133.21	133.36	133.18	133.3	3951687.0
2011-02-14 12:30:00	SPY	ETF	133.3	133.38	133.27	133.31	4148616.0
2011-02-14 13:00:00	SPY	ETF	133.31	133.36	133.22	133.295	2810774.0
2011-02-14 13:30:00	SPY	ETF	133.29	133.36	133.26	133.29	3226393.0
2011-02-14 14:00:00	SPY	ETF	133.29	133.33	133.23	133.32	3588450.0
2011-02-14 14:30:00	SPY	ETF	133.32	133.43	133.25	133.4	3332344.0
2011-02-14 15:00:00	SPY	ETF	133.41	133.44	133.29	133.31	4614769.0
2011-02-14 15:30:00	SPY	ETF	133.31	133.54	133.3	133.43	13858872.0
2011-02-14 16:00:00	SPY	ETF	133.42	133.46	133.1247	133.22	7341724.0
2011-02-14 16:30:00	SPY	ETF	133.21	133.44	133.01	133.02	8009553.0
2011-02-14 17:00:00	SPY	ETF	133.02	133.03	132.98	132.99	193306.0
2011-02-14 17:30:00	SPY	ETF	132.99	133.4424	132.9	132.97	1217674.0
2011-02-14 18:00:00	SPY	ETF	132.97	133.43	132.93	133.01	56626.0
2011-02-14 18:30:00	SPY	ETF	133.02	133.04	133.01	133.04	17100.0
2011-02-14 19:00:00	SPY	ETF	133.02	133.08	132.99	133.06	62028.0
2011-02-14 19:30:00	SPY	ETF	133.08	133.11	133.02	133.05	43525.0
2011-02-14 06:00:00	QQQ	ETF	58.37	58.37	58.37	58.37	100.0
2011-02-14 06:30:00	QQQ	ETF	58.38	58.4	58.38	58.39	2474.0
2011-02-14 07:00:00	QQQ	ETF	58.42	58.45	58.39	58.43	549503.0
2011-02-14 07:30:00	QQQ	ETF	58.43	58.43	58.37	58.38	96086.0
2011-02-14 08:00:00	QQQ	ETF	58.4	58.44	58.39	58.4	561160.0
2011-02-14 08:30:00	QQQ	ETF	58.4	58.41	58.38	58.41	43116.0
2011-02-14 09:00:00	QQQ	ETF	58.41	58.45	58.4	58.43	299341.0
2011-02-14 09:30:00	QQQ	ETF	58.43	58.55	58.38	58.51	5677509.0
2011-02-14 10:00:00	QQQ	ETF	58.51	58.64	58.49	58.59	4070754.0
2011-02-14 10:30:00	QQQ	ETF	58.59	58.65	58.44	58.5	3868262.0
2011-02-14 11:00:00	QQQ	ETF	58.5	58.59	58.47	58.54	2541718.0
2011-02-14 11:30:00	QQQ	ETF	58.53	58.61	58.52	58.575	2097403.0
2011-02-14 12:00:00	QQQ	ETF	58.58	58.66	58.55	58.61	1700712.0
2011-02-14 12:30:00	QQQ	ETF	58.61	58.65	58.59	58.595	2268054.0
2011-02-14 13:00:00	QQQ	ETF	58.59	58.62	58.55	58.579	735050.0
2011-02-14 13:30:00	QQQ	ETF	58.579	58.6	58.55	58.55	902882.0
2011-02-14 14:00:00	QQQ	ETF	58.55	58.57	58.52	58.55	1086556.0
2011-02-14 14:30:00	QQQ	ETF	58.55	58.59	58.52	58.56	983768.0

> showing 50 of 9,231 rows — these rows as CSV

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