PREVIEW / stock_30min / 2007-07-17

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-17.parquet
  size:    1.1 MB
  rows:    64,610
  symbols: 3,071

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-07-17 09:30:00	AAPL	Stock	4.9393	4.9593	4.9186	4.9229	97766032.0
2007-07-17 10:00:00	AAPL	Stock	4.9225	4.9514	4.9107	4.9454	84501816.0
2007-07-17 10:30:00	AAPL	Stock	4.9454	4.9689	4.9415	4.9664	78672300.0
2007-07-17 11:00:00	AAPL	Stock	4.9661	4.9821	4.9571	4.9611	76232856.0
2007-07-17 11:30:00	AAPL	Stock	4.9611	4.9682	4.9557	4.9614	35353892.0
2007-07-17 12:00:00	AAPL	Stock	4.9614	4.9632	4.9464	4.9532	34657056.0
2007-07-17 12:30:00	AAPL	Stock	4.9525	4.9643	4.9493	4.9589	30513588.0
2007-07-17 13:00:00	AAPL	Stock	4.9593	4.9629	4.9554	4.9589	22051036.0
2007-07-17 13:30:00	AAPL	Stock	4.9586	4.9857	4.9575	4.9689	39708564.0
2007-07-17 14:00:00	AAPL	Stock	4.9686	4.9818	4.9679	4.9757	40912004.0
2007-07-17 14:30:00	AAPL	Stock	4.9757	4.9804	4.9696	4.9714	33387312.0
2007-07-17 15:00:00	AAPL	Stock	4.9714	4.9725	4.9629	4.9686	35039536.0
2007-07-17 15:30:00	AAPL	Stock	4.9682	4.9721	4.9543	4.9593	65300256.0
2007-07-17 16:00:00	AAPL	Stock	4.9604	4.9611	4.9604	4.9611	9930872.0
2007-07-17 09:00:00	MSFT	Stock	30.02	30.02	30.02	30.02	500.0
2007-07-17 09:30:00	MSFT	Stock	30.01	30.4	30.01	30.385	6670644.0
2007-07-17 10:00:00	MSFT	Stock	30.38	30.53	30.32	30.47	9380874.0
2007-07-17 10:30:00	MSFT	Stock	30.47	30.5	30.44	30.48	5831445.0
2007-07-17 11:00:00	MSFT	Stock	30.475	30.49	30.35	30.36	4667751.0
2007-07-17 11:30:00	MSFT	Stock	30.35	30.48	30.35	30.46	2192136.0
2007-07-17 12:00:00	MSFT	Stock	30.45	30.55	30.45	30.5	4720303.0
2007-07-17 12:30:00	MSFT	Stock	30.5	30.53	30.44	30.51	2201863.0
2007-07-17 13:00:00	MSFT	Stock	30.5	30.57	30.445	30.52	3403775.0
2007-07-17 13:30:00	MSFT	Stock	30.52	30.7	30.51	30.67	4484843.0
2007-07-17 14:00:00	MSFT	Stock	30.67	30.82	30.65	30.78	5865362.0
2007-07-17 14:30:00	MSFT	Stock	30.775	30.84	30.76	30.781	3802768.0
2007-07-17 15:00:00	MSFT	Stock	30.788	30.83	30.74	30.802	5680723.0
2007-07-17 15:30:00	MSFT	Stock	30.81	30.88	30.65	30.75	13768299.0
2007-07-17 16:00:00	MSFT	Stock	30.75	30.78	30.75	30.78	2246625.0
2007-07-17 08:00:00	NVDA	Stock	0.7783	0.7783	0.7783	0.7783	38400.0
2007-07-17 08:30:00	NVDA	Stock	0.7867	0.787	0.7833	0.7833	150000.0
2007-07-17 09:00:00	NVDA	Stock	0.7815	0.7815	0.7795	0.7795	18000.0
2007-07-17 09:30:00	NVDA	Stock	0.7815	0.7955	0.7808	0.794	55174380.0
2007-07-17 10:00:00	NVDA	Stock	0.794	0.7972	0.793	0.7942	65342040.0
2007-07-17 10:30:00	NVDA	Stock	0.7942	0.7948	0.7905	0.7923	39665160.0
2007-07-17 11:00:00	NVDA	Stock	0.7923	0.7942	0.7892	0.7903	36877440.0
2007-07-17 11:30:00	NVDA	Stock	0.7902	0.7918	0.7847	0.7855	41054580.0
2007-07-17 12:00:00	NVDA	Stock	0.7853	0.787	0.783	0.783	50397840.0
2007-07-17 12:30:00	NVDA	Stock	0.7829	0.7857	0.7817	0.7828	28513140.0
2007-07-17 13:00:00	NVDA	Stock	0.7828	0.7842	0.7808	0.781	25245120.0
2007-07-17 13:30:00	NVDA	Stock	0.781	0.7887	0.7793	0.7853	41019120.0
2007-07-17 14:00:00	NVDA	Stock	0.7853	0.7873	0.7833	0.7848	33234180.0
2007-07-17 14:30:00	NVDA	Stock	0.7847	0.785	0.7802	0.7807	57047700.0
2007-07-17 15:00:00	NVDA	Stock	0.7807	0.7812	0.7773	0.7783	57419640.0
2007-07-17 15:30:00	NVDA	Stock	0.7783	0.7795	0.7743	0.7755	72000360.0
2007-07-17 16:00:00	NVDA	Stock	0.7755	0.7755	0.7658	0.7658	31700580.0
2007-07-17 16:30:00	NVDA	Stock	0.7658	0.7755	0.76	0.76	926640.0
2007-07-17 17:00:00	NVDA	Stock	0.76	0.7633	0.7592	0.7633	901980.0
2007-07-17 17:30:00	NVDA	Stock	0.7627	0.7665	0.7587	0.7587	390000.0
2007-07-17 18:00:00	NVDA	Stock	0.7587	0.7587	0.755	0.7553	475800.0

> showing 50 of 64,610 rows — these rows as CSV

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