PREVIEW / etf_30min / 2010-06-24

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-24.parquet
  size:    254 KB
  rows:    8,392

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-06-24 04:00:00	SPY	ETF	108.65	108.7	108.5	108.5	500.0
2010-06-24 04:30:00	SPY	ETF	108.26	108.4	108.2	108.4	22096.0
2010-06-24 05:00:00	SPY	ETF	108.41	108.46	108.41	108.46	200.0
2010-06-24 05:30:00	SPY	ETF	108.5	108.55	108.49	108.49	15600.0
2010-06-24 06:00:00	SPY	ETF	108.49	108.61	108.49	108.6	2700.0
2010-06-24 06:30:00	SPY	ETF	108.54	108.58	108.49	108.56	16700.0
2010-06-24 07:00:00	SPY	ETF	108.54	108.67	108.45	108.46	215135.0
2010-06-24 07:30:00	SPY	ETF	108.44	108.54	108.26	108.39	440693.0
2010-06-24 08:00:00	SPY	ETF	108.39	108.48	108.21	108.27	1607374.0
2010-06-24 08:30:00	SPY	ETF	108.34	108.85	108.26	108.63	4060965.0
2010-06-24 09:00:00	SPY	ETF	108.63	108.82	108.56	108.68	1428388.0
2010-06-24 09:30:00	SPY	ETF	108.69	108.83	107.87	108.02	25362857.0
2010-06-24 10:00:00	SPY	ETF	108.02	108.58	108.01	108.45	20642004.0
2010-06-24 10:30:00	SPY	ETF	108.45	108.46	107.72	108.01	19263290.0
2010-06-24 11:00:00	SPY	ETF	108.01	108.02	107.44	107.73	22802151.0
2010-06-24 11:30:00	SPY	ETF	107.73	108.04	107.64	107.93	14146634.0
2010-06-24 12:00:00	SPY	ETF	107.93	108.25	107.87	107.9	11497238.0
2010-06-24 12:30:00	SPY	ETF	107.9	108.08	107.67	108.01	8032657.0
2010-06-24 13:00:00	SPY	ETF	108.0001	108.31	107.86	108.08	8701562.0
2010-06-24 13:30:00	SPY	ETF	108.08	108.65	108.05	108.57	11555727.0
2010-06-24 14:00:00	SPY	ETF	108.58	108.61	108.19	108.28	7787685.0
2010-06-24 14:30:00	SPY	ETF	108.28	108.29	107.57	107.7	17830340.0
2010-06-24 15:00:00	SPY	ETF	107.71	107.9	107.14	107.55	30566721.0
2010-06-24 15:30:00	SPY	ETF	107.55	107.65	107.14	107.44	41338909.0
2010-06-24 16:00:00	SPY	ETF	107.44	109.2206	107.197	107.54	7996103.0
2010-06-24 16:30:00	SPY	ETF	107.53	109.23	107.47	107.78	1835763.0
2010-06-24 17:00:00	SPY	ETF	107.78	107.81	107.72	107.75	131092.0
2010-06-24 17:30:00	SPY	ETF	107.75	109.2206	107.39	107.8	2340367.0
2010-06-24 18:00:00	SPY	ETF	107.8	107.81	107.47	107.78	295885.0
2010-06-24 18:30:00	SPY	ETF	107.78	107.78	107.68	107.68	29891.0
2010-06-24 19:00:00	SPY	ETF	107.68	107.77	107.66	107.68	33103.0
2010-06-24 19:30:00	SPY	ETF	107.67	107.77	107.65	107.76	69745.0
2010-06-24 04:00:00	QQQ	ETF	45.75	45.75	45.7	45.7	200.0
2010-06-24 04:30:00	QQQ	ETF	45.6	45.6	45.6	45.6	200.0
2010-06-24 05:30:00	QQQ	ETF	45.71	45.71	45.71	45.71	500.0
2010-06-24 06:30:00	QQQ	ETF	45.75	45.75	45.7	45.7	44000.0
2010-06-24 07:00:00	QQQ	ETF	45.7	45.74	45.65	45.67	130345.0
2010-06-24 07:30:00	QQQ	ETF	45.67	45.67	45.62	45.64	65822.0
2010-06-24 08:00:00	QQQ	ETF	45.66	45.7	45.64	45.67	498390.0
2010-06-24 08:30:00	QQQ	ETF	45.7	45.88	45.68	45.8	1101957.0
2010-06-24 09:00:00	QQQ	ETF	45.81	46.05	45.79	45.84	404838.0
2010-06-24 09:30:00	QQQ	ETF	45.84	45.99	45.47	45.52	12529990.0
2010-06-24 10:00:00	QQQ	ETF	45.52	45.84	45.51	45.76	9712941.0
2010-06-24 10:30:00	QQQ	ETF	45.76	45.77	45.42	45.56	7291663.0
2010-06-24 11:00:00	QQQ	ETF	45.56	45.56	45.31	45.47	6769689.0
2010-06-24 11:30:00	QQQ	ETF	45.4668	45.63	45.43	45.561	3661134.0
2010-06-24 12:00:00	QQQ	ETF	45.57	45.7	45.52	45.55	5040982.0
2010-06-24 12:30:00	QQQ	ETF	45.54	45.59	45.42	45.56	2774721.0
2010-06-24 13:00:00	QQQ	ETF	45.56	45.76	45.5	45.6402	6302230.0
2010-06-24 13:30:00	QQQ	ETF	45.64	45.95	45.62	45.91	8850007.0

> showing 50 of 8,392 rows — these rows as CSV

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