PREVIEW / etf_30min / 2012-03-02

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-02.parquet
  size:    281 KB
  rows:    9,493

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
2012-03-02 04:00:00	SPY	ETF	137.69	137.75	137.62	137.65	18430.0
2012-03-02 04:30:00	SPY	ETF	137.65	137.65	137.6	137.64	6300.0
2012-03-02 05:00:00	SPY	ETF	137.62	137.71	137.62	137.71	100400.0
2012-03-02 05:30:00	SPY	ETF	137.65	137.67	137.58	137.65	20676.0
2012-03-02 06:00:00	SPY	ETF	137.65	137.66	137.64	137.64	11900.0
2012-03-02 06:30:00	SPY	ETF	137.68	137.75	137.6	137.65	19525.0
2012-03-02 07:00:00	SPY	ETF	137.65	137.65	137.43	137.44	129189.0
2012-03-02 07:30:00	SPY	ETF	137.43	137.48	137.32	137.47	177996.0
2012-03-02 08:00:00	SPY	ETF	137.47	137.6	137.37	137.55	359507.0
2012-03-02 08:30:00	SPY	ETF	137.55	137.64	137.46	137.61	445364.0
2012-03-02 09:00:00	SPY	ETF	137.62	137.73	137.55	137.65	690959.0
2012-03-02 09:30:00	SPY	ETF	137.64	137.74	137.41	137.47	10057996.0
2012-03-02 10:00:00	SPY	ETF	137.47	137.82	137.4	137.75	8645294.0
2012-03-02 10:30:00	SPY	ETF	137.75	137.77	137.52	137.55	7020932.0
2012-03-02 11:00:00	SPY	ETF	137.55	137.6	137.4	137.55	8232462.0
2012-03-02 11:30:00	SPY	ETF	137.54	137.6	137.22	137.325	11011400.0
2012-03-02 12:00:00	SPY	ETF	137.325	137.38	137.13	137.252	7754026.0
2012-03-02 12:30:00	SPY	ETF	137.25	137.385	137.21	137.29	5074726.0
2012-03-02 13:00:00	SPY	ETF	137.28	137.35	137.0	137.11	8210724.0
2012-03-02 13:30:00	SPY	ETF	137.11	137.29	137.1	137.28	4216956.0
2012-03-02 14:00:00	SPY	ETF	137.275	137.39	137.22	137.28	5208865.0
2012-03-02 14:30:00	SPY	ETF	137.27	137.39	137.23	137.385	5197773.0
2012-03-02 15:00:00	SPY	ETF	137.385	137.47	137.28	137.47	6660438.0
2012-03-02 15:30:00	SPY	ETF	137.47	137.59	137.25	137.32	17860091.0
2012-03-02 16:00:00	SPY	ETF	137.32	137.7749	137.1	137.33	7165906.0
2012-03-02 16:30:00	SPY	ETF	137.33	137.43	137.31	137.38	4209682.0
2012-03-02 17:00:00	SPY	ETF	137.38	137.4	137.36	137.38	33741.0
2012-03-02 17:30:00	SPY	ETF	137.38	137.4	137.3	137.36	22848.0
2012-03-02 18:00:00	SPY	ETF	137.35	137.43	137.35	137.41	16100.0
2012-03-02 18:30:00	SPY	ETF	137.38	137.47	137.37	137.41	52540.0
2012-03-02 19:00:00	SPY	ETF	137.39	137.41	137.39	137.39	7524.0
2012-03-02 19:30:00	SPY	ETF	137.39	137.41	137.37	137.37	25394.0
2012-03-02 06:30:00	QQQ	ETF	64.87	64.87	64.86	64.86	400.0
2012-03-02 07:00:00	QQQ	ETF	64.82	64.82	64.73	64.73	20750.0
2012-03-02 07:30:00	QQQ	ETF	64.72	64.75	64.67	64.75	63600.0
2012-03-02 08:00:00	QQQ	ETF	64.75	64.8	64.71	64.78	50635.0
2012-03-02 08:30:00	QQQ	ETF	64.78	64.81	64.75	64.8	88943.0
2012-03-02 09:00:00	QQQ	ETF	64.8	64.86	64.77	64.83	85337.0
2012-03-02 09:30:00	QQQ	ETF	64.83	64.96	64.78	64.89	3526091.0
2012-03-02 10:00:00	QQQ	ETF	64.89	65.07	64.87	65.02	3175369.0
2012-03-02 10:30:00	QQQ	ETF	65.03	65.035	64.91	64.94	3439811.0
2012-03-02 11:00:00	QQQ	ETF	64.95	65.06	64.915	65.04	1941604.0
2012-03-02 11:30:00	QQQ	ETF	65.04	65.0784	64.77	64.84	3660781.0
2012-03-02 12:00:00	QQQ	ETF	64.85	64.87	64.7	64.76	3702753.0
2012-03-02 12:30:00	QQQ	ETF	64.76	64.86	64.75	64.8005	1401108.0
2012-03-02 13:00:00	QQQ	ETF	64.8	64.83	64.66	64.71	1516114.0
2012-03-02 13:30:00	QQQ	ETF	64.7165	64.85	64.7165	64.84	1416464.0
2012-03-02 14:00:00	QQQ	ETF	64.83	64.9	64.81	64.86	1366712.0
2012-03-02 14:30:00	QQQ	ETF	64.855	64.88	64.82	64.862	770206.0
2012-03-02 15:00:00	QQQ	ETF	64.87	64.892	64.82	64.89	1658996.0

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

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