PREVIEW / etf_30min / 2010-01-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-26.parquet
  size:    252 KB
  rows:    8,307

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-01-26 04:00:00	SPY	ETF	109.09	109.27	109.09	109.24	5236.0
2010-01-26 04:30:00	SPY	ETF	109.11	109.22	109.0	109.07	3300.0
2010-01-26 05:00:00	SPY	ETF	108.94	108.94	108.83	108.89	9023.0
2010-01-26 05:30:00	SPY	ETF	108.86	109.08	108.86	109.08	2550.0
2010-01-26 06:00:00	SPY	ETF	109.07	109.08	109.07	109.07	700.0
2010-01-26 06:30:00	SPY	ETF	109.0	109.17	109.0	109.11	60639.0
2010-01-26 07:00:00	SPY	ETF	109.11	109.2	109.05	109.2	181365.0
2010-01-26 07:30:00	SPY	ETF	109.2	109.51	109.2	109.47	583451.0
2010-01-26 08:00:00	SPY	ETF	109.45	109.64	109.31	109.33	1330751.0
2010-01-26 08:30:00	SPY	ETF	109.32	109.48	108.7	109.36	724865.0
2010-01-26 09:00:00	SPY	ETF	109.36	109.41	109.17	109.34	2675783.0
2010-01-26 09:30:00	SPY	ETF	109.34	109.64	109.04	109.33	30855841.0
2010-01-26 10:00:00	SPY	ETF	109.33	110.07	109.23	109.8001	23572313.0
2010-01-26 10:30:00	SPY	ETF	109.8001	110.1	109.4	109.69	13928561.0
2010-01-26 11:00:00	SPY	ETF	109.72	110.03	109.67	110.0199	11208378.0
2010-01-26 11:30:00	SPY	ETF	110.02	110.27	109.94	110.14	12133794.0
2010-01-26 12:00:00	SPY	ETF	110.15	110.3	110.11	110.26	9498027.0
2010-01-26 12:30:00	SPY	ETF	110.25	110.47	110.18	110.43	8663517.0
2010-01-26 13:00:00	SPY	ETF	110.43	110.44	110.15	110.23	7388595.0
2010-01-26 13:30:00	SPY	ETF	110.23	110.43	110.2	110.43	5218796.0
2010-01-26 14:00:00	SPY	ETF	110.43	110.46	110.04	110.07	11178812.0
2010-01-26 14:30:00	SPY	ETF	110.07	110.2	109.93	110.17	15647043.0
2010-01-26 15:00:00	SPY	ETF	110.16	110.18	109.67	109.73	14593859.0
2010-01-26 15:30:00	SPY	ETF	109.74	109.86	109.2	109.3	31724882.0
2010-01-26 16:00:00	SPY	ETF	109.28	110.3511	109.02	109.18	6422853.0
2010-01-26 16:30:00	SPY	ETF	109.19	109.35	109.1	109.35	1905005.0
2010-01-26 17:00:00	SPY	ETF	109.35	109.7786	109.33	109.38	765249.0
2010-01-26 17:30:00	SPY	ETF	109.4	109.44	109.3	109.32	257985.0
2010-01-26 18:00:00	SPY	ETF	109.36	109.7	109.36	109.48	216287.0
2010-01-26 18:30:00	SPY	ETF	109.48	109.5	109.45	109.48	18438.0
2010-01-26 19:00:00	SPY	ETF	109.47	109.48	109.22	109.45	103358.0
2010-01-26 19:30:00	SPY	ETF	109.4	109.58	109.4	109.51	41967.0
2010-01-26 04:00:00	QQQ	ETF	44.18	44.18	44.18	44.18	390.0
2010-01-26 04:30:00	QQQ	ETF	44.15	44.15	44.12	44.12	517.0
2010-01-26 05:00:00	QQQ	ETF	44.07	44.09	44.07	44.09	1300.0
2010-01-26 05:30:00	QQQ	ETF	44.16	44.21	44.16	44.21	1800.0
2010-01-26 06:00:00	QQQ	ETF	44.2	44.2	44.14	44.14	2400.0
2010-01-26 06:30:00	QQQ	ETF	44.17	44.18	44.15	44.18	3226.0
2010-01-26 07:00:00	QQQ	ETF	44.16	44.22	44.15	44.22	119809.0
2010-01-26 07:30:00	QQQ	ETF	44.24	44.35	44.24	44.33	128979.0
2010-01-26 08:00:00	QQQ	ETF	44.32	44.38	44.17	44.29	650183.0
2010-01-26 08:30:00	QQQ	ETF	44.29	44.34	43.95	44.29	411147.0
2010-01-26 09:00:00	QQQ	ETF	44.28	44.29	44.17	44.28	1736136.0
2010-01-26 09:30:00	QQQ	ETF	44.28	44.29	44.05	44.15	17431405.0
2010-01-26 10:00:00	QQQ	ETF	44.16	44.58	44.11	44.44	22745170.0
2010-01-26 10:30:00	QQQ	ETF	44.44	44.55	44.38	44.46	6921764.0
2010-01-26 11:00:00	QQQ	ETF	44.45	44.56	44.43	44.56	7404933.0
2010-01-26 11:30:00	QQQ	ETF	44.56	44.72	44.54	44.68	5414976.0
2010-01-26 12:00:00	QQQ	ETF	44.68	44.82	44.65	44.8099	7155492.0
2010-01-26 12:30:00	QQQ	ETF	44.81	44.89	44.74	44.87	5927813.0

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

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