PREVIEW / etf_30min / 2011-11-28

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-28.parquet
  size:    292 KB
  rows:    9,894

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-11-28 04:00:00	SPY	ETF	118.53	119.06	118.53	118.95	38358.0
2011-11-28 04:30:00	SPY	ETF	118.99	119.32	118.99	119.24	9199.0
2011-11-28 05:00:00	SPY	ETF	119.28	119.48	119.25	119.3	120594.0
2011-11-28 05:30:00	SPY	ETF	119.23	119.23	119.0	119.11	144282.0
2011-11-28 06:00:00	SPY	ETF	119.16	119.2	119.0	119.05	119976.0
2011-11-28 06:30:00	SPY	ETF	119.05	119.22	118.98	119.1	168151.0
2011-11-28 07:00:00	SPY	ETF	119.1	119.23	118.9	118.92	855398.0
2011-11-28 07:30:00	SPY	ETF	118.92	119.19	118.9	119.09	815756.0
2011-11-28 08:00:00	SPY	ETF	119.08	119.21	118.6	119.2	1697248.0
2011-11-28 08:30:00	SPY	ETF	119.18	119.38	119.1	119.32	1597794.0
2011-11-28 09:00:00	SPY	ETF	119.32	119.6	119.31	119.53	3119909.0
2011-11-28 09:30:00	SPY	ETF	119.54	120.0	119.31	119.93	30069089.0
2011-11-28 10:00:00	SPY	ETF	119.92	120.12	119.76	119.97	15111571.0
2011-11-28 10:30:00	SPY	ETF	119.96	120.18	119.77	119.82	12622593.0
2011-11-28 11:00:00	SPY	ETF	119.81	120.01	119.77	119.99	10776401.0
2011-11-28 11:30:00	SPY	ETF	120.0	120.12	119.47	119.88	8711439.0
2011-11-28 12:00:00	SPY	ETF	119.87	119.94	119.68	119.69	6505974.0
2011-11-28 12:30:00	SPY	ETF	119.68	119.69	119.46	119.51	11176716.0
2011-11-28 13:00:00	SPY	ETF	119.5	119.88	119.41	119.85	10630651.0
2011-11-28 13:30:00	SPY	ETF	119.85	119.97	119.48	119.51	10911274.0
2011-11-28 14:00:00	SPY	ETF	119.51	119.88	119.45	119.65	7605012.0
2011-11-28 14:30:00	SPY	ETF	119.65	119.8053	119.24	119.36	11574456.0
2011-11-28 15:00:00	SPY	ETF	119.37	119.49	118.82	119.031	18924636.0
2011-11-28 15:30:00	SPY	ETF	119.03	119.75	118.9	119.71	26871878.0
2011-11-28 16:00:00	SPY	ETF	119.71	119.77	119.1946	119.66	7639257.0
2011-11-28 16:30:00	SPY	ETF	119.66	119.84	119.6	119.71	8118935.0
2011-11-28 17:00:00	SPY	ETF	119.7	119.76	119.6775	119.76	152327.0
2011-11-28 17:30:00	SPY	ETF	119.74	119.79	119.71	119.75	116682.0
2011-11-28 18:00:00	SPY	ETF	119.73	119.74	119.55	119.6	405213.0
2011-11-28 18:30:00	SPY	ETF	119.56	119.63	119.54	119.61	45299.0
2011-11-28 19:00:00	SPY	ETF	119.57	119.6	119.28	119.35	235247.0
2011-11-28 19:30:00	SPY	ETF	119.35	119.44	119.3	119.41	229998.0
2011-11-28 04:00:00	QQQ	ETF	53.82	54.05	53.82	54.05	9626.0
2011-11-28 04:30:00	QQQ	ETF	54.05	54.16	54.05	54.15	2200.0
2011-11-28 05:00:00	QQQ	ETF	54.17	54.21	54.12	54.12	3000.0
2011-11-28 05:30:00	QQQ	ETF	54.08	54.09	54.08	54.09	2100.0
2011-11-28 06:00:00	QQQ	ETF	54.1	54.15	54.1	54.12	6508.0
2011-11-28 06:30:00	QQQ	ETF	54.08	54.15	54.07	54.15	13200.0
2011-11-28 07:00:00	QQQ	ETF	54.13	54.13	54.03	54.03	41700.0
2011-11-28 07:30:00	QQQ	ETF	54.05	54.12	54.03	54.08	31724.0
2011-11-28 08:00:00	QQQ	ETF	54.05	54.13	54.04	54.12	194518.0
2011-11-28 08:30:00	QQQ	ETF	54.12	54.2	54.1	54.16	246135.0
2011-11-28 09:00:00	QQQ	ETF	54.17	54.24	54.13	54.17	740706.0
2011-11-28 09:30:00	QQQ	ETF	54.16	54.67	54.14	54.6195	7954467.0
2011-11-28 10:00:00	QQQ	ETF	54.61	54.74	54.55	54.64	3412409.0
2011-11-28 10:30:00	QQQ	ETF	54.64	54.77	54.59	54.64	2493116.0
2011-11-28 11:00:00	QQQ	ETF	54.64	54.73	54.6	54.72	1644146.0
2011-11-28 11:30:00	QQQ	ETF	54.72	54.79	54.67	54.69	2059378.0
2011-11-28 12:00:00	QQQ	ETF	54.69	54.76	54.65	54.65	1787497.0
2011-11-28 12:30:00	QQQ	ETF	54.65	54.655	54.53	54.56	1498009.0

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

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