PREVIEW / etf_30min / 2010-12-22

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-22.parquet
  size:    263 KB
  rows:    9,006

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
2010-12-22 05:00:00	SPY	ETF	125.4	125.43	125.4	125.43	10800.0
2010-12-22 05:30:00	SPY	ETF	125.44	125.44	125.44	125.44	2100.0
2010-12-22 06:30:00	SPY	ETF	125.4	125.4	125.4	125.4	200.0
2010-12-22 07:00:00	SPY	ETF	125.41	125.49	125.4	125.47	44773.0
2010-12-22 07:30:00	SPY	ETF	125.45	125.46	125.41	125.42	262640.0
2010-12-22 08:00:00	SPY	ETF	125.43	125.57	125.27	125.53	434410.0
2010-12-22 08:30:00	SPY	ETF	125.52	125.52	125.38	125.44	683836.0
2010-12-22 09:00:00	SPY	ETF	125.44	125.49	125.25	125.49	336754.0
2010-12-22 09:30:00	SPY	ETF	125.48	125.56	125.41	125.52	9166811.0
2010-12-22 10:00:00	SPY	ETF	125.52	125.6	125.45	125.55	7628446.0
2010-12-22 10:30:00	SPY	ETF	125.55	125.63	125.5	125.63	4766850.0
2010-12-22 11:00:00	SPY	ETF	125.63	125.63	125.57	125.62	4549850.0
2010-12-22 11:30:00	SPY	ETF	125.615	125.71	125.6	125.675	3714923.0
2010-12-22 12:00:00	SPY	ETF	125.68	125.81	125.66	125.795	3415576.0
2010-12-22 12:30:00	SPY	ETF	125.8	125.82	125.71	125.7716	2960694.0
2010-12-22 13:00:00	SPY	ETF	125.78	125.78	125.69	125.7299	3293852.0
2010-12-22 13:30:00	SPY	ETF	125.72	125.725	125.53	125.58	4679741.0
2010-12-22 14:00:00	SPY	ETF	125.5899	125.65	125.5862	125.62	3084829.0
2010-12-22 14:30:00	SPY	ETF	125.6201	125.69	125.59	125.68	3481288.0
2010-12-22 15:00:00	SPY	ETF	125.68	125.76	125.66	125.699	3278201.0
2010-12-22 15:30:00	SPY	ETF	125.69	125.82	125.63	125.78	12410451.0
2010-12-22 16:00:00	SPY	ETF	125.77	125.84	125.595	125.83	7517975.0
2010-12-22 16:30:00	SPY	ETF	125.82	125.83	125.76	125.78	228014.0
2010-12-22 17:00:00	SPY	ETF	125.79	125.81	125.79	125.79	11900.0
2010-12-22 17:30:00	SPY	ETF	125.82	125.82	125.79	125.79	7700.0
2010-12-22 18:00:00	SPY	ETF	125.81	125.81	125.76	125.76	16306.0
2010-12-22 18:30:00	SPY	ETF	125.76	125.79	125.74	125.74	8329.0
2010-12-22 19:00:00	SPY	ETF	125.79	125.81	125.78	125.81	6228.0
2010-12-22 19:30:00	SPY	ETF	125.78	125.78	125.7	125.76	27791.0
2010-12-22 04:00:00	QQQ	ETF	54.81	54.81	54.81	54.81	200.0
2010-12-22 05:30:00	QQQ	ETF	54.86	54.86	54.86	54.86	200.0
2010-12-22 06:30:00	QQQ	ETF	54.86	54.86	54.86	54.86	200.0
2010-12-22 07:00:00	QQQ	ETF	54.85	54.86	54.83	54.85	16100.0
2010-12-22 07:30:00	QQQ	ETF	54.85	54.87	54.85	54.87	16400.0
2010-12-22 08:00:00	QQQ	ETF	54.87	54.9	54.8	54.8	104604.0
2010-12-22 08:30:00	QQQ	ETF	54.8	54.86	54.75	54.83	210975.0
2010-12-22 09:00:00	QQQ	ETF	54.83	54.86	54.83	54.86	54009.0
2010-12-22 09:30:00	QQQ	ETF	54.86	54.92	54.8	54.84	4795780.0
2010-12-22 10:00:00	QQQ	ETF	54.84	54.87	54.79	54.82	2624147.0
2010-12-22 10:30:00	QQQ	ETF	54.81	54.86	54.79	54.86	1961763.0
2010-12-22 11:00:00	QQQ	ETF	54.86	54.88	54.845	54.87	1185144.0
2010-12-22 11:30:00	QQQ	ETF	54.87	54.95	54.87	54.9	3127896.0
2010-12-22 12:00:00	QQQ	ETF	54.9	54.95	54.88	54.945	1832364.0
2010-12-22 12:30:00	QQQ	ETF	54.95	54.96	54.84	54.8702	2452950.0
2010-12-22 13:00:00	QQQ	ETF	54.875	54.89	54.86	54.8801	799170.0
2010-12-22 13:30:00	QQQ	ETF	54.885	54.89	54.8	54.82	1838025.0
2010-12-22 14:00:00	QQQ	ETF	54.8119	54.84	54.81	54.84	671292.0
2010-12-22 14:30:00	QQQ	ETF	54.84	54.88	54.82	54.87	786613.0
2010-12-22 15:00:00	QQQ	ETF	54.87	54.9	54.86	54.88	664811.0
2010-12-22 15:30:00	QQQ	ETF	54.88	54.94	54.85	54.882	5364800.0

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

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