PREVIEW / stock_30min / 2007-01-04

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-04.parquet
  size:    990 KB
  rows:    53,411
  symbols: 2,486

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-04 06:30:00	AAPL	Stock	2.9989	2.9989	2.9989	2.9989	11200.0
2007-01-04 07:00:00	AAPL	Stock	2.9993	2.9993	2.9993	2.9993	14000.0
2007-01-04 07:30:00	AAPL	Stock	2.9943	3.0	2.9925	3.0	37800.0
2007-01-04 08:00:00	AAPL	Stock	3.0032	3.0032	2.9818	2.9871	1316476.0
2007-01-04 08:30:00	AAPL	Stock	2.9857	2.9929	2.9804	2.9893	983136.0
2007-01-04 09:00:00	AAPL	Stock	2.9893	3.0054	2.9825	3.0018	2332680.0
2007-01-04 09:30:00	AAPL	Stock	3.0018	3.035	2.9936	3.0243	130578868.0
2007-01-04 10:00:00	AAPL	Stock	3.0239	3.0296	3.0039	3.0161	91623924.0
2007-01-04 10:30:00	AAPL	Stock	3.0164	3.0639	3.0161	3.0589	108494092.0
2007-01-04 11:00:00	AAPL	Stock	3.0589	3.0679	3.0432	3.0479	72369808.0
2007-01-04 11:30:00	AAPL	Stock	3.0479	3.0679	3.0464	3.0536	55213872.0
2007-01-04 12:00:00	AAPL	Stock	3.0546	3.06	3.0379	3.0489	39440352.0
2007-01-04 12:30:00	AAPL	Stock	3.0489	3.0557	3.0446	3.05	21280308.0
2007-01-04 13:00:00	AAPL	Stock	3.05	3.0568	3.0321	3.0404	46841956.0
2007-01-04 13:30:00	AAPL	Stock	3.0404	3.0471	3.0271	3.0311	43033200.0
2007-01-04 14:00:00	AAPL	Stock	3.0311	3.0511	3.0311	3.0489	38221092.0
2007-01-04 14:30:00	AAPL	Stock	3.0489	3.0589	3.0393	3.0536	56337148.0
2007-01-04 15:00:00	AAPL	Stock	3.0539	3.0586	3.0471	3.055	41208412.0
2007-01-04 15:30:00	AAPL	Stock	3.0546	3.0696	3.0546	3.0586	78607788.0
2007-01-04 16:00:00	AAPL	Stock	3.0582	3.0607	3.0557	3.0582	795144.0
2007-01-04 16:30:00	AAPL	Stock	3.0593	3.06	3.0571	3.0593	259252.0
2007-01-04 17:00:00	AAPL	Stock	3.0571	3.0571	3.0561	3.0564	98280.0
2007-01-04 17:30:00	AAPL	Stock	2.9914	3.0593	2.9914	3.0593	245000.0
2007-01-04 18:00:00	AAPL	Stock	3.0593	3.0711	3.0589	3.065	5496848.0
2007-01-04 18:30:00	AAPL	Stock	3.065	3.0675	3.0643	3.0675	648116.0
2007-01-04 19:00:00	AAPL	Stock	3.0679	3.0714	3.0654	3.0707	185220.0
2007-01-04 19:30:00	AAPL	Stock	3.0707	3.0754	3.0696	3.0707	345800.0
2007-01-04 06:30:00	MSFT	Stock	29.78	29.78	29.78	29.78	154.0
2007-01-04 07:30:00	MSFT	Stock	29.78	29.78	29.77	29.77	3000.0
2007-01-04 08:00:00	MSFT	Stock	29.77	29.77	29.77	29.77	5010.0
2007-01-04 08:30:00	MSFT	Stock	29.8	29.8	29.78	29.78	1100.0
2007-01-04 09:00:00	MSFT	Stock	29.8	29.86	29.65	29.7	1088446.0
2007-01-04 09:30:00	MSFT	Stock	29.7	29.72	29.54	29.59	6248290.0
2007-01-04 10:00:00	MSFT	Stock	29.59	29.69	29.44	29.55	4250953.0
2007-01-04 10:30:00	MSFT	Stock	29.55	29.82	29.53	29.74	5639105.0
2007-01-04 11:00:00	MSFT	Stock	29.74	29.82	29.7	29.77	3097433.0
2007-01-04 11:30:00	MSFT	Stock	29.77	29.85	29.76	29.8	2157716.0
2007-01-04 12:00:00	MSFT	Stock	29.79	29.83	29.76	29.83	2310300.0
2007-01-04 12:30:00	MSFT	Stock	29.83	29.85	29.8	29.83	1411072.0
2007-01-04 13:00:00	MSFT	Stock	29.822	29.84	29.7	29.78	1678542.0
2007-01-04 13:30:00	MSFT	Stock	29.78	29.85	29.72	29.78	2091678.0
2007-01-04 14:00:00	MSFT	Stock	29.78	29.82	29.73	29.78	2237726.0
2007-01-04 14:30:00	MSFT	Stock	29.79	29.94	29.76	29.91	4093925.0
2007-01-04 15:00:00	MSFT	Stock	29.9	29.94	29.84	29.89	2698209.0
2007-01-04 15:30:00	MSFT	Stock	29.885	29.97	29.8	29.81	4683977.0
2007-01-04 16:00:00	MSFT	Stock	29.82	29.82	29.73	29.82	59307.0
2007-01-04 16:30:00	MSFT	Stock	29.81	29.81	29.81	29.81	1300.0
2007-01-04 17:00:00	MSFT	Stock	29.81	29.83	29.81	29.82	12990.0
2007-01-04 17:30:00	MSFT	Stock	30.049	30.049	29.81	29.81	66700.0
2007-01-04 18:00:00	MSFT	Stock	29.79	29.83	29.78	29.83	52781.0

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

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