PREVIEW / stock_30min / 2007-07-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-23.parquet
  size:    1.1 MB
  rows:    64,261
  symbols: 3,081

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-23 09:30:00	AAPL	Stock	5.1182	5.1239	5.0332	5.065	169085896.0
2007-07-23 10:00:00	AAPL	Stock	5.065	5.0871	5.0532	5.0789	76917876.0
2007-07-23 10:30:00	AAPL	Stock	5.0789	5.1375	5.0782	5.1371	118448316.0
2007-07-23 11:00:00	AAPL	Stock	5.1368	5.1507	5.1296	5.135	88859764.0
2007-07-23 11:30:00	AAPL	Stock	5.135	5.1446	5.1214	5.1371	56104272.0
2007-07-23 12:00:00	AAPL	Stock	5.1368	5.1586	5.13	5.1579	49931756.0
2007-07-23 12:30:00	AAPL	Stock	5.1579	5.1864	5.1521	5.18	90531000.0
2007-07-23 13:00:00	AAPL	Stock	5.1799	5.1821	5.1357	5.1411	65637012.0
2007-07-23 13:30:00	AAPL	Stock	5.1411	5.1554	5.1143	5.1264	52157364.0
2007-07-23 14:00:00	AAPL	Stock	5.1261	5.1393	5.12	5.1268	45483424.0
2007-07-23 14:30:00	AAPL	Stock	5.1275	5.1589	5.125	5.1454	44669940.0
2007-07-23 15:00:00	AAPL	Stock	5.1454	5.1611	5.1368	5.1439	52874920.0
2007-07-23 15:30:00	AAPL	Stock	5.1439	5.1464	5.1071	5.1318	83945176.0
2007-07-23 16:00:00	AAPL	Stock	5.1307	5.1321	5.1307	5.1321	8082592.0
2007-07-23 09:30:00	MSFT	Stock	31.36	31.39	31.15	31.208	4149018.0
2007-07-23 10:00:00	MSFT	Stock	31.2	31.3	31.17	31.3	3130840.0
2007-07-23 10:30:00	MSFT	Stock	31.3	31.5	31.27	31.49	7360224.0
2007-07-23 11:00:00	MSFT	Stock	31.5	31.52	31.42	31.448	4125054.0
2007-07-23 11:30:00	MSFT	Stock	31.45	31.51	31.37	31.43	3056831.0
2007-07-23 12:00:00	MSFT	Stock	31.42	31.45	31.33	31.358	2007284.0
2007-07-23 12:30:00	MSFT	Stock	31.35	31.41	31.34	31.405	2122549.0
2007-07-23 13:00:00	MSFT	Stock	31.405	31.43	31.37	31.39	1636427.0
2007-07-23 13:30:00	MSFT	Stock	31.392	31.42	31.31	31.33	2441935.0
2007-07-23 14:00:00	MSFT	Stock	31.33	31.4	31.26	31.28	3373610.0
2007-07-23 14:30:00	MSFT	Stock	31.27	31.37	31.27	31.34	2190114.0
2007-07-23 15:00:00	MSFT	Stock	31.34	31.35	31.28	31.29	2787305.0
2007-07-23 15:30:00	MSFT	Stock	31.29	31.29	31.12	31.17	8050603.0
2007-07-23 16:00:00	MSFT	Stock	31.17	31.19	31.17	31.19	1362398.0
2007-07-23 08:00:00	NVDA	Stock	0.7508	0.7508	0.7508	0.7508	54000.0
2007-07-23 09:00:00	NVDA	Stock	0.7483	0.7507	0.7467	0.7507	254340.0
2007-07-23 09:30:00	NVDA	Stock	0.749	0.7647	0.7473	0.7567	36840420.0
2007-07-23 10:00:00	NVDA	Stock	0.7567	0.7615	0.7508	0.7607	29948880.0
2007-07-23 10:30:00	NVDA	Stock	0.7612	0.7722	0.76	0.7705	46551900.0
2007-07-23 11:00:00	NVDA	Stock	0.7705	0.7747	0.7698	0.7723	34827120.0
2007-07-23 11:30:00	NVDA	Stock	0.7725	0.7735	0.7677	0.7685	24404820.0
2007-07-23 12:00:00	NVDA	Stock	0.7685	0.769	0.764	0.7645	15077580.0
2007-07-23 12:30:00	NVDA	Stock	0.7647	0.7687	0.7647	0.766	16869240.0
2007-07-23 13:00:00	NVDA	Stock	0.766	0.7665	0.7618	0.763	17330040.0
2007-07-23 13:30:00	NVDA	Stock	0.763	0.7657	0.7605	0.7618	10510020.0
2007-07-23 14:00:00	NVDA	Stock	0.7618	0.7642	0.7582	0.7582	20407080.0
2007-07-23 14:30:00	NVDA	Stock	0.7582	0.7637	0.758	0.7635	14896800.0
2007-07-23 15:00:00	NVDA	Stock	0.7633	0.7645	0.761	0.7618	18205500.0
2007-07-23 15:30:00	NVDA	Stock	0.762	0.7622	0.7563	0.7585	41561280.0
2007-07-23 16:00:00	NVDA	Stock	0.7585	0.7592	0.7568	0.7588	3800160.0
2007-07-23 16:30:00	NVDA	Stock	0.7583	0.7649	0.7583	0.7583	1492560.0
2007-07-23 17:00:00	NVDA	Stock	0.7583	0.7583	0.757	0.757	124500.0
2007-07-23 17:30:00	NVDA	Stock	0.757	0.757	0.757	0.757	6000.0
2007-07-23 07:00:00	AMZN	Stock	3.58	3.58	3.5775	3.5775	10000.0
2007-07-23 07:30:00	AMZN	Stock	3.6	3.6	3.6	3.6	4000.0
2007-07-23 08:00:00	AMZN	Stock	3.585	3.599	3.5805	3.599	104000.0

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

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