PREVIEW / stock_30min / 2007-08-28

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-28.parquet
  size:    1.1 MB
  rows:    65,017
  symbols: 3,099

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-08-28 09:30:00	AAPL	Stock	4.6757	4.7086	4.6514	4.6979	105625940.0
2007-08-28 10:00:00	AAPL	Stock	4.6957	4.7289	4.6875	4.6961	94763396.0
2007-08-28 10:30:00	AAPL	Stock	4.6961	4.6996	4.6627	4.6725	61739832.0
2007-08-28 11:00:00	AAPL	Stock	4.6718	4.6725	4.6071	4.62	115185952.0
2007-08-28 11:30:00	AAPL	Stock	4.6196	4.6321	4.54	4.5714	131193384.0
2007-08-28 12:00:00	AAPL	Stock	4.5714	4.585	4.5589	4.5756	64178884.0
2007-08-28 12:30:00	AAPL	Stock	4.5761	4.5986	4.5761	4.5921	48405644.0
2007-08-28 13:00:00	AAPL	Stock	4.5925	4.6011	4.5807	4.5961	36836744.0
2007-08-28 13:30:00	AAPL	Stock	4.5961	4.6321	4.5929	4.6225	60209128.0
2007-08-28 14:00:00	AAPL	Stock	4.6229	4.6293	4.5829	4.6139	79808904.0
2007-08-28 14:30:00	AAPL	Stock	4.6143	4.62	4.5714	4.5786	62970684.0
2007-08-28 15:00:00	AAPL	Stock	4.5782	4.6018	4.5586	4.5775	67434276.0
2007-08-28 15:30:00	AAPL	Stock	4.5771	4.6236	4.5225	4.5319	129886596.0
2007-08-28 16:00:00	AAPL	Stock	4.5296	4.5329	4.5293	4.5293	14503860.0
2007-08-28 09:30:00	MSFT	Stock	28.3	28.43	28.23	28.29	2289002.0
2007-08-28 10:00:00	MSFT	Stock	28.29	28.38	28.25	28.34	1915013.0
2007-08-28 10:30:00	MSFT	Stock	28.34	28.39	28.265	28.31	1781269.0
2007-08-28 11:00:00	MSFT	Stock	28.301	28.31	28.21	28.249	1693232.0
2007-08-28 11:30:00	MSFT	Stock	28.25	28.32	28.24	28.31	1318547.0
2007-08-28 12:00:00	MSFT	Stock	28.3	28.38	28.3	28.38	1914210.0
2007-08-28 12:30:00	MSFT	Stock	28.37	28.42	28.32	28.4	2706178.0
2007-08-28 13:00:00	MSFT	Stock	28.4	28.41	28.32	28.361	1134726.0
2007-08-28 13:30:00	MSFT	Stock	28.37	28.41	28.34	28.37	1063003.0
2007-08-28 14:00:00	MSFT	Stock	28.38	28.4	28.27	28.32	1739210.0
2007-08-28 14:30:00	MSFT	Stock	28.33	28.33	28.15	28.17	2062340.0
2007-08-28 15:00:00	MSFT	Stock	28.178	28.24	28.13	28.14	1852106.0
2007-08-28 15:30:00	MSFT	Stock	28.14	28.15	27.91	27.93	8161492.0
2007-08-28 16:00:00	MSFT	Stock	27.93	27.93	27.93	27.93	2978236.0
2007-08-28 08:00:00	NVDA	Stock	0.825	0.8263	0.8183	0.8217	570600.0
2007-08-28 08:30:00	NVDA	Stock	0.8263	0.8263	0.8203	0.8203	210720.0
2007-08-28 09:00:00	NVDA	Stock	0.8225	0.8248	0.8203	0.8247	718740.0
2007-08-28 09:30:00	NVDA	Stock	0.825	0.8283	0.8125	0.8178	46521660.0
2007-08-28 10:00:00	NVDA	Stock	0.818	0.8202	0.8073	0.81	53108220.0
2007-08-28 10:30:00	NVDA	Stock	0.81	0.81	0.7977	0.7988	41395920.0
2007-08-28 11:00:00	NVDA	Stock	0.7988	0.799	0.7893	0.7912	40975980.0
2007-08-28 11:30:00	NVDA	Stock	0.7912	0.7945	0.7868	0.79	32118360.0
2007-08-28 12:00:00	NVDA	Stock	0.7898	0.794	0.7877	0.789	27023580.0
2007-08-28 12:30:00	NVDA	Stock	0.789	0.7898	0.785	0.7893	26668860.0
2007-08-28 13:00:00	NVDA	Stock	0.7893	0.7893	0.7838	0.7855	20675760.0
2007-08-28 13:30:00	NVDA	Stock	0.7855	0.7892	0.7845	0.7878	19812900.0
2007-08-28 14:00:00	NVDA	Stock	0.788	0.7888	0.7837	0.7855	30818100.0
2007-08-28 14:30:00	NVDA	Stock	0.7855	0.7872	0.7772	0.7787	39849240.0
2007-08-28 15:00:00	NVDA	Stock	0.7787	0.7796	0.7725	0.7757	50094180.0
2007-08-28 15:30:00	NVDA	Stock	0.7757	0.7758	0.7703	0.7723	68935080.0
2007-08-28 16:00:00	NVDA	Stock	0.7723	0.775	0.7717	0.775	19399680.0
2007-08-28 16:30:00	NVDA	Stock	0.7757	0.7798	0.7757	0.7798	852780.0
2007-08-28 17:00:00	NVDA	Stock	0.7787	0.7787	0.7772	0.7772	1916700.0
2007-08-28 17:30:00	NVDA	Stock	0.7772	0.778	0.7772	0.7773	69300.0
2007-08-28 18:00:00	NVDA	Stock	0.778	0.778	0.7773	0.7773	36000.0
2007-08-28 18:30:00	NVDA	Stock	0.778	0.778	0.778	0.778	12000.0

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

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