PREVIEW / etf_30min / 2010-01-25

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-25.parquet
  size:    251 KB
  rows:    8,377

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-25 04:00:00	SPY	ETF	110.08	110.55	110.08	110.48	33855.0
2010-01-25 04:30:00	SPY	ETF	110.46	110.52	110.43	110.44	5220.0
2010-01-25 05:00:00	SPY	ETF	110.54	110.63	110.53	110.53	10900.0
2010-01-25 05:30:00	SPY	ETF	110.62	110.7	110.6	110.62	32400.0
2010-01-25 06:00:00	SPY	ETF	110.6	110.67	110.49	110.59	23842.0
2010-01-25 06:30:00	SPY	ETF	110.53	110.62	110.4	110.49	33293.0
2010-01-25 07:00:00	SPY	ETF	110.49	110.54	110.35	110.54	180409.0
2010-01-25 07:30:00	SPY	ETF	110.5	110.52	110.15	110.25	365318.0
2010-01-25 08:00:00	SPY	ETF	110.22	110.41	110.06	110.33	1572382.0
2010-01-25 08:30:00	SPY	ETF	110.33	110.35	110.16	110.25	1065527.0
2010-01-25 09:00:00	SPY	ETF	110.24	110.46	110.2	110.21	2125781.0
2010-01-25 09:30:00	SPY	ETF	110.21	110.35	110.02	110.17	27436349.0
2010-01-25 10:00:00	SPY	ETF	110.16	110.37	109.64	110.05	30983177.0
2010-01-25 10:30:00	SPY	ETF	110.055	110.12	109.73	109.96	12314461.0
2010-01-25 11:00:00	SPY	ETF	109.96	110.01	109.52	109.72	14248561.0
2010-01-25 11:30:00	SPY	ETF	109.72	109.97	109.41	109.825	16717938.0
2010-01-25 12:00:00	SPY	ETF	109.8	110.17	109.8	109.95	8731967.0
2010-01-25 12:30:00	SPY	ETF	109.95	110.2	109.94	110.1	4505996.0
2010-01-25 13:00:00	SPY	ETF	110.1	110.23	109.97	110.13	5181341.0
2010-01-25 13:30:00	SPY	ETF	110.13	110.17	109.89	110.02	5775962.0
2010-01-25 14:00:00	SPY	ETF	110.0199	110.23	109.87	110.22	5205541.0
2010-01-25 14:30:00	SPY	ETF	110.22	110.39	110.0	110.365	7744791.0
2010-01-25 15:00:00	SPY	ETF	110.38	110.41	110.07	110.1	12711756.0
2010-01-25 15:30:00	SPY	ETF	110.09	110.27	109.73	109.75	18892089.0
2010-01-25 16:00:00	SPY	ETF	109.77	110.38	109.1445	110.08	6439770.0
2010-01-25 16:30:00	SPY	ETF	110.1	110.1	109.44	109.81	2711640.0
2010-01-25 17:00:00	SPY	ETF	109.8	109.81	109.5	109.6	598768.0
2010-01-25 17:30:00	SPY	ETF	109.6	109.76	109.6	109.75	108022.0
2010-01-25 18:00:00	SPY	ETF	109.73	109.77	109.69	109.7	38854.0
2010-01-25 18:30:00	SPY	ETF	109.7	109.73	109.64	109.7	10960.0
2010-01-25 19:00:00	SPY	ETF	109.73	109.89	109.72	109.87	114917.0
2010-01-25 19:30:00	SPY	ETF	109.8	109.91	109.8	109.86	21370.0
2010-01-25 04:00:00	QQQ	ETF	44.48	44.5	44.46	44.46	1476.0
2010-01-25 04:30:00	QQQ	ETF	44.5	44.5	44.5	44.5	300.0
2010-01-25 05:00:00	QQQ	ETF	44.52	44.52	44.52	44.52	200.0
2010-01-25 05:30:00	QQQ	ETF	44.57	44.57	44.57	44.57	100.0
2010-01-25 06:00:00	QQQ	ETF	44.54	44.58	44.54	44.54	4898.0
2010-01-25 06:30:00	QQQ	ETF	44.51	44.53	44.47	44.47	5400.0
2010-01-25 07:00:00	QQQ	ETF	44.49	44.51	44.4	44.48	75786.0
2010-01-25 07:30:00	QQQ	ETF	44.49	44.5	44.37	44.38	125014.0
2010-01-25 08:00:00	QQQ	ETF	44.4	44.48	44.16	44.46	727048.0
2010-01-25 08:30:00	QQQ	ETF	44.46	44.5	44.41	44.42	489103.0
2010-01-25 09:00:00	QQQ	ETF	44.42	44.53	44.38	44.39	1309564.0
2010-01-25 09:30:00	QQQ	ETF	44.39	44.51	44.35	44.47	13478742.0
2010-01-25 10:00:00	QQQ	ETF	44.47	44.6	44.35	44.54	25924126.0
2010-01-25 10:30:00	QQQ	ETF	44.54	44.58	44.37	44.48	9867118.0
2010-01-25 11:00:00	QQQ	ETF	44.48	44.4914	44.2	44.23	12064173.0
2010-01-25 11:30:00	QQQ	ETF	44.2325	44.29	44.12	44.24	6625891.0
2010-01-25 12:00:00	QQQ	ETF	44.2401	44.37	44.23	44.27	4662402.0
2010-01-25 12:30:00	QQQ	ETF	44.27	44.44	44.27	44.4	3570395.0

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

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