PREVIEW / stock_30min / 2007-01-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-23.parquet
  size:    989 KB
  rows:    53,538
  symbols: 2,499

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
2007-01-23 05:30:00	AAPL	Stock	3.0932	3.0932	3.0932	3.0932	28000.0
2007-01-23 06:00:00	AAPL	Stock	3.0932	3.0932	3.0911	3.0932	28000.0
2007-01-23 07:00:00	AAPL	Stock	3.0914	3.0914	3.0807	3.0807	67200.0
2007-01-23 07:30:00	AAPL	Stock	3.0786	3.0821	3.0489	3.0557	823480.0
2007-01-23 08:00:00	AAPL	Stock	3.0571	3.0732	3.0554	3.0689	4254544.0
2007-01-23 08:30:00	AAPL	Stock	3.0679	3.0786	3.0643	3.0714	5915756.0
2007-01-23 09:00:00	AAPL	Stock	3.0714	3.075	3.0571	3.0611	7755468.0
2007-01-23 09:30:00	AAPL	Stock	3.0614	3.1125	3.0539	3.09	244586412.0
2007-01-23 10:00:00	AAPL	Stock	3.0914	3.0925	3.0596	3.0725	143487708.0
2007-01-23 10:30:00	AAPL	Stock	3.0729	3.0943	3.0679	3.0936	82034176.0
2007-01-23 11:00:00	AAPL	Stock	3.0921	3.1186	3.0896	3.1	136740968.0
2007-01-23 11:30:00	AAPL	Stock	3.1004	3.1254	3.0961	3.1186	84949900.0
2007-01-23 12:00:00	AAPL	Stock	3.1185	3.1232	3.1079	3.1139	55471248.0
2007-01-23 12:30:00	AAPL	Stock	3.1136	3.1246	3.1107	3.1143	50260112.0
2007-01-23 13:00:00	AAPL	Stock	3.1136	3.1207	3.1125	3.1175	32723152.0
2007-01-23 13:30:00	AAPL	Stock	3.1171	3.1175	3.095	3.097	46910332.0
2007-01-23 14:00:00	AAPL	Stock	3.0971	3.1021	3.0864	3.0893	54324060.0
2007-01-23 14:30:00	AAPL	Stock	3.0893	3.0893	3.0661	3.0768	93877560.0
2007-01-23 15:00:00	AAPL	Stock	3.0764	3.0806	3.0636	3.0718	61252884.0
2007-01-23 15:30:00	AAPL	Stock	3.0717	3.0732	3.0554	3.0604	88328576.0
2007-01-23 16:00:00	AAPL	Stock	3.0625	3.0732	3.0604	3.0629	1617308.0
2007-01-23 16:30:00	AAPL	Stock	3.0629	3.0654	3.0607	3.0625	460852.0
2007-01-23 17:00:00	AAPL	Stock	3.0625	3.0732	3.0607	3.0693	725144.0
2007-01-23 17:30:00	AAPL	Stock	3.0679	3.0761	3.0671	3.0761	366856.0
2007-01-23 18:00:00	AAPL	Stock	3.0764	3.0782	3.0736	3.0782	520772.0
2007-01-23 18:30:00	AAPL	Stock	3.0764	3.0782	3.0606	3.0754	316876.0
2007-01-23 19:00:00	AAPL	Stock	3.0754	3.0779	3.075	3.0754	112252.0
2007-01-23 19:30:00	AAPL	Stock	3.0757	3.0757	3.0721	3.0732	58800.0
2007-01-23 07:00:00	MSFT	Stock	30.68	30.68	30.68	30.68	100.0
2007-01-23 08:00:00	MSFT	Stock	30.67	30.67	30.67	30.67	250.0
2007-01-23 08:30:00	MSFT	Stock	30.62	30.65	30.62	30.65	3800.0
2007-01-23 09:00:00	MSFT	Stock	30.66	30.67	30.61	30.63	26665.0
2007-01-23 09:30:00	MSFT	Stock	30.63	30.9	30.52	30.88	5415410.0
2007-01-23 10:00:00	MSFT	Stock	30.89	30.89	30.72	30.78	3925639.0
2007-01-23 10:30:00	MSFT	Stock	30.78	30.81	30.69	30.72	2785515.0
2007-01-23 11:00:00	MSFT	Stock	30.71	30.76	30.67	30.71	4121637.0
2007-01-23 11:30:00	MSFT	Stock	30.71	30.76	30.67	30.75	2165044.0
2007-01-23 12:00:00	MSFT	Stock	30.74	30.75	30.65	30.739	2950090.0
2007-01-23 12:30:00	MSFT	Stock	30.73	30.77	30.69	30.73	2390577.0
2007-01-23 13:00:00	MSFT	Stock	30.72	30.82	30.72	30.82	2627041.0
2007-01-23 13:30:00	MSFT	Stock	30.82	30.92	30.8	30.9	3979758.0
2007-01-23 14:00:00	MSFT	Stock	30.91	30.96	30.8	30.8	3449545.0
2007-01-23 14:30:00	MSFT	Stock	30.8	30.81	30.66	30.72	3723801.0
2007-01-23 15:00:00	MSFT	Stock	30.72	30.87	30.72	30.797	2971929.0
2007-01-23 15:30:00	MSFT	Stock	30.79	30.84	30.73	30.75	4775574.0
2007-01-23 16:00:00	MSFT	Stock	30.75	30.798	30.74	30.798	102785.0
2007-01-23 16:30:00	MSFT	Stock	30.69	30.71	30.69	30.71	1700.0
2007-01-23 17:00:00	MSFT	Stock	30.71	30.71	30.71	30.71	300.0
2007-01-23 17:30:00	MSFT	Stock	30.73	30.77	30.73	30.77	4090.0
2007-01-23 18:00:00	MSFT	Stock	30.77	30.81	30.77	30.81	3850.0

> showing 50 of 53,538 rows — these rows as CSV

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