PREVIEW / etf_30min / 2011-02-02

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-02.parquet
  size:    268 KB
  rows:    9,000

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-02 04:00:00	SPY	ETF	130.76	130.76	130.66	130.71	6200.0
2011-02-02 04:30:00	SPY	ETF	130.72	130.73	130.68	130.68	622.0
2011-02-02 05:00:00	SPY	ETF	130.75	130.75	130.72	130.72	200.0
2011-02-02 05:30:00	SPY	ETF	130.75	130.9	130.75	130.86	6500.0
2011-02-02 06:00:00	SPY	ETF	130.82	130.91	130.82	130.83	23100.0
2011-02-02 06:30:00	SPY	ETF	130.82	130.82	130.7	130.71	10500.0
2011-02-02 07:00:00	SPY	ETF	130.63	130.74	130.63	130.71	35300.0
2011-02-02 07:30:00	SPY	ETF	130.69	130.74	130.61	130.64	229289.0
2011-02-02 08:00:00	SPY	ETF	130.64	130.7	130.45	130.5	808769.0
2011-02-02 08:30:00	SPY	ETF	130.49	130.53	130.37	130.46	797559.0
2011-02-02 09:00:00	SPY	ETF	130.46	130.46	130.19	130.4	1379512.0
2011-02-02 09:30:00	SPY	ETF	130.4	130.74	130.34	130.6901	15155942.0
2011-02-02 10:00:00	SPY	ETF	130.7	130.78	130.38	130.74	10635729.0
2011-02-02 10:30:00	SPY	ETF	130.74	130.84	130.58	130.65	9165777.0
2011-02-02 11:00:00	SPY	ETF	130.66	130.67	130.39	130.59	8125482.0
2011-02-02 11:30:00	SPY	ETF	130.59	130.68	130.52	130.64	4909654.0
2011-02-02 12:00:00	SPY	ETF	130.65	130.67	130.39	130.39	6033826.0
2011-02-02 12:30:00	SPY	ETF	130.4	130.6	130.395	130.5499	4765675.0
2011-02-02 13:00:00	SPY	ETF	130.55	130.64	130.52	130.61	4748154.0
2011-02-02 13:30:00	SPY	ETF	130.61	130.66	130.48	130.54	3590408.0
2011-02-02 14:00:00	SPY	ETF	130.535	130.8381	130.48	130.61	4821983.0
2011-02-02 14:30:00	SPY	ETF	130.61	130.71	130.55	130.67	5192515.0
2011-02-02 15:00:00	SPY	ETF	130.67	130.838	130.49	130.5	7205991.0
2011-02-02 15:30:00	SPY	ETF	130.5	130.838	130.33	130.47	18514373.0
2011-02-02 16:00:00	SPY	ETF	130.47	130.785	130.41	130.45	6256982.0
2011-02-02 16:30:00	SPY	ETF	130.445	130.838	130.38	130.46	2163767.0
2011-02-02 17:00:00	SPY	ETF	130.46	130.47	130.41	130.47	75294.0
2011-02-02 17:30:00	SPY	ETF	130.46	130.46	130.42	130.43	36265.0
2011-02-02 18:00:00	SPY	ETF	130.45	130.838	130.42	130.43	638399.0
2011-02-02 18:30:00	SPY	ETF	130.43	130.49	130.43	130.47	7134.0
2011-02-02 19:00:00	SPY	ETF	130.43	130.47	130.42	130.45	13000.0
2011-02-02 19:30:00	SPY	ETF	130.47	130.52	130.43	130.46	21241.0
2011-02-02 05:30:00	QQQ	ETF	57.02	57.05	57.02	57.05	10200.0
2011-02-02 07:00:00	QQQ	ETF	56.99	57.01	56.97	57.01	2100.0
2011-02-02 07:30:00	QQQ	ETF	57.01	57.02	57.0	57.01	27020.0
2011-02-02 08:00:00	QQQ	ETF	57.01	57.02	56.94	56.96	777999.0
2011-02-02 08:30:00	QQQ	ETF	56.96	56.97	56.88	56.93	807720.0
2011-02-02 09:00:00	QQQ	ETF	56.94	56.94	56.8	56.91	436492.0
2011-02-02 09:30:00	QQQ	ETF	56.92	57.05	56.89	57.03	8978550.0
2011-02-02 10:00:00	QQQ	ETF	57.0284	57.15	56.84	57.1205	4156682.0
2011-02-02 10:30:00	QQQ	ETF	57.12	57.17	57.02	57.06	4172373.0
2011-02-02 11:00:00	QQQ	ETF	57.06	57.065	56.92	57.02	4019454.0
2011-02-02 11:30:00	QQQ	ETF	57.03	57.1	57.0	57.09	1671238.0
2011-02-02 12:00:00	QQQ	ETF	57.09	57.1	56.9404	56.96	1184789.0
2011-02-02 12:30:00	QQQ	ETF	56.96	57.05	56.96	57.0	2509333.0
2011-02-02 13:00:00	QQQ	ETF	57.01	57.02	56.96	56.995	2972033.0
2011-02-02 13:30:00	QQQ	ETF	56.99	57.022	56.951	56.98	1054678.0
2011-02-02 14:00:00	QQQ	ETF	56.98	57.05	56.96	57.04	980563.0
2011-02-02 14:30:00	QQQ	ETF	57.031	57.08	57.0	57.07	2139972.0
2011-02-02 15:00:00	QQQ	ETF	57.06	57.12	56.93	56.94	1975571.0

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

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