PREVIEW / stock_30min / 2007-09-19

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-19.parquet
  size:    1.1 MB
  rows:    65,422
  symbols: 3,134

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-09-19 09:30:00	AAPL	Stock	5.1071	5.1129	5.0714	5.0821	144159008.0
2007-09-19 10:00:00	AAPL	Stock	5.0814	5.0943	5.0625	5.0818	86076788.0
2007-09-19 10:30:00	AAPL	Stock	5.0814	5.0939	5.0786	5.0905	51201388.0
2007-09-19 11:00:00	AAPL	Stock	5.0907	5.1089	5.0821	5.0896	59638236.0
2007-09-19 11:30:00	AAPL	Stock	5.09	5.0964	5.0807	5.09	44115036.0
2007-09-19 12:00:00	AAPL	Stock	5.09	5.0939	5.0757	5.0786	42562156.0
2007-09-19 12:30:00	AAPL	Stock	5.0786	5.0907	5.0664	5.0825	45664864.0
2007-09-19 13:00:00	AAPL	Stock	5.0825	5.0829	5.0589	5.0618	49444360.0
2007-09-19 13:30:00	AAPL	Stock	5.0621	5.0857	5.0589	5.0761	36438416.0
2007-09-19 14:00:00	AAPL	Stock	5.0761	5.0818	5.0446	5.0486	49190988.0
2007-09-19 14:30:00	AAPL	Stock	5.0486	5.0714	5.0482	5.0636	37976260.0
2007-09-19 15:00:00	AAPL	Stock	5.0636	5.075	5.0579	5.0654	41286476.0
2007-09-19 15:30:00	AAPL	Stock	5.065	5.0668	4.9786	5.0282	209572076.0
2007-09-19 16:00:00	AAPL	Stock	5.0268	5.0282	5.0257	5.0275	8929900.0
2007-09-19 09:30:00	MSFT	Stock	28.87	28.91	28.55	28.618	8063934.0
2007-09-19 10:00:00	MSFT	Stock	28.62	28.71	28.59	28.68	5709735.0
2007-09-19 10:30:00	MSFT	Stock	28.68	28.68	28.56	28.638	7858585.0
2007-09-19 11:00:00	MSFT	Stock	28.64	28.64	28.57	28.6	5267096.0
2007-09-19 11:30:00	MSFT	Stock	28.6	28.61	28.44	28.498	7219839.0
2007-09-19 12:00:00	MSFT	Stock	28.5	28.55	28.45	28.46	3225122.0
2007-09-19 12:30:00	MSFT	Stock	28.46	28.49	28.44	28.48	5240267.0
2007-09-19 13:00:00	MSFT	Stock	28.48	28.48	28.36	28.39	5326187.0
2007-09-19 13:30:00	MSFT	Stock	28.39	28.39	28.34	28.35	4682856.0
2007-09-19 14:00:00	MSFT	Stock	28.36	28.38	28.3	28.37	5667164.0
2007-09-19 14:30:00	MSFT	Stock	28.37	28.59	28.35	28.58	8311214.0
2007-09-19 15:00:00	MSFT	Stock	28.58	28.65	28.56	28.6	4754001.0
2007-09-19 15:30:00	MSFT	Stock	28.6	28.67	28.53	28.67	6978614.0
2007-09-19 16:00:00	MSFT	Stock	28.67	28.67	28.65	28.67	2363765.0
2007-09-19 08:00:00	NVDA	Stock	0.8812	0.8812	0.875	0.88	201680.0
2007-09-19 08:30:00	NVDA	Stock	0.88	0.8908	0.88	0.8908	350280.0
2007-09-19 09:00:00	NVDA	Stock	0.8898	0.89	0.8825	0.8838	595120.0
2007-09-19 09:30:00	NVDA	Stock	0.8832	0.9	0.8828	0.8878	80500720.0
2007-09-19 10:00:00	NVDA	Stock	0.8875	0.8878	0.878	0.8838	61469360.0
2007-09-19 10:30:00	NVDA	Stock	0.8838	0.8838	0.8755	0.8815	39230480.0
2007-09-19 11:00:00	NVDA	Stock	0.8812	0.8832	0.8725	0.8728	35253000.0
2007-09-19 11:30:00	NVDA	Stock	0.8728	0.875	0.8628	0.8635	38895040.0
2007-09-19 12:00:00	NVDA	Stock	0.8635	0.8702	0.8622	0.869	24452760.0
2007-09-19 12:30:00	NVDA	Stock	0.8688	0.871	0.8665	0.87	15187560.0
2007-09-19 13:00:00	NVDA	Stock	0.87	0.8704	0.8665	0.8678	18017760.0
2007-09-19 13:30:00	NVDA	Stock	0.8678	0.87	0.864	0.8672	21190760.0
2007-09-19 14:00:00	NVDA	Stock	0.8675	0.8678	0.8552	0.8562	30535400.0
2007-09-19 14:30:00	NVDA	Stock	0.8562	0.8598	0.8505	0.8578	35255760.0
2007-09-19 15:00:00	NVDA	Stock	0.8578	0.8632	0.8562	0.8592	27079880.0
2007-09-19 15:30:00	NVDA	Stock	0.8595	0.8615	0.8562	0.86	39371480.0
2007-09-19 16:00:00	NVDA	Stock	0.8602	0.8622	0.8585	0.859	8386120.0
2007-09-19 17:30:00	NVDA	Stock	0.8602	0.8602	0.8602	0.8602	49960.0
2007-09-19 18:00:00	NVDA	Stock	0.8602	0.8602	0.8602	0.8602	10040.0
2007-09-19 18:30:00	NVDA	Stock	0.8588	0.8588	0.8588	0.8588	6000.0
2007-09-19 19:00:00	NVDA	Stock	0.859	0.859	0.859	0.859	6000.0
2007-09-19 06:30:00	AMZN	Stock	4.4	4.41	4.4	4.41	6200.0

> showing 50 of 65,422 rows — these rows as CSV

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