PREVIEW / stock_30min / 2007-07-31

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-31.parquet
  size:    1.2 MB
  rows:    66,300
  symbols: 3,090

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-31 09:30:00	AAPL	Stock	5.1061	5.1243	5.0714	5.1011	139795656.0
2007-07-31 10:00:00	AAPL	Stock	5.1011	5.1179	4.9789	4.9879	190722560.0
2007-07-31 10:30:00	AAPL	Stock	4.9879	5.0929	4.8489	4.9111	338877504.0
2007-07-31 11:00:00	AAPL	Stock	4.9132	4.9454	4.8632	4.8882	139634376.0
2007-07-31 11:30:00	AAPL	Stock	4.8879	4.9143	4.8804	4.9054	66057712.0
2007-07-31 12:00:00	AAPL	Stock	4.9043	4.9214	4.8657	4.9029	106556324.0
2007-07-31 12:30:00	AAPL	Stock	4.9029	4.91	4.8768	4.8932	51506140.0
2007-07-31 13:00:00	AAPL	Stock	4.8936	4.915	4.8854	4.8904	50167488.0
2007-07-31 13:30:00	AAPL	Stock	4.8904	4.8979	4.8536	4.8732	76770148.0
2007-07-31 14:00:00	AAPL	Stock	4.8732	4.8957	4.845	4.8597	77725536.0
2007-07-31 14:30:00	AAPL	Stock	4.8589	4.8764	4.7921	4.835	137953648.0
2007-07-31 15:00:00	AAPL	Stock	4.8339	4.8839	4.8286	4.8543	98396956.0
2007-07-31 15:30:00	AAPL	Stock	4.8546	4.8643	4.6971	4.7029	207070472.0
2007-07-31 16:00:00	AAPL	Stock	4.7046	4.7057	4.7018	4.7057	16010176.0
2007-07-31 09:30:00	MSFT	Stock	29.71	29.716	29.09	29.54	7469642.0
2007-07-31 10:00:00	MSFT	Stock	29.54	29.6	29.5	29.5	4021367.0
2007-07-31 10:30:00	MSFT	Stock	29.505	29.68	29.43	29.54	4696845.0
2007-07-31 11:00:00	MSFT	Stock	29.55	29.61	29.5	29.605	2141431.0
2007-07-31 11:30:00	MSFT	Stock	29.6	29.68	29.58	29.64	2595286.0
2007-07-31 12:00:00	MSFT	Stock	29.64	29.65	29.51	29.6	2690949.0
2007-07-31 12:30:00	MSFT	Stock	29.61	29.63	29.51	29.53	1343419.0
2007-07-31 13:00:00	MSFT	Stock	29.53	29.7	29.52	29.61	3204311.0
2007-07-31 13:30:00	MSFT	Stock	29.61	29.62	29.5	29.6	3082123.0
2007-07-31 14:00:00	MSFT	Stock	29.6	29.63	29.42	29.44	3060922.0
2007-07-31 14:30:00	MSFT	Stock	29.44	29.45	29.21	29.21	5344702.0
2007-07-31 15:00:00	MSFT	Stock	29.22	29.3	29.15	29.18	5382790.0
2007-07-31 15:30:00	MSFT	Stock	29.18	29.208	28.98	28.98	9443358.0
2007-07-31 16:00:00	MSFT	Stock	28.99	28.99	28.98	28.99	3302890.0
2007-07-31 07:30:00	NVDA	Stock	0.7768	0.7768	0.7758	0.7758	96000.0
2007-07-31 08:00:00	NVDA	Stock	0.7733	0.7833	0.767	0.7793	1374600.0
2007-07-31 08:30:00	NVDA	Stock	0.7817	0.782	0.7792	0.7792	1077000.0
2007-07-31 09:00:00	NVDA	Stock	0.7783	0.7873	0.7762	0.7873	2445660.0
2007-07-31 09:30:00	NVDA	Stock	0.7875	0.795	0.7848	0.7893	112272540.0
2007-07-31 10:00:00	NVDA	Stock	0.7893	0.7988	0.7868	0.7908	88116900.0
2007-07-31 10:30:00	NVDA	Stock	0.7907	0.7908	0.7695	0.7767	74870280.0
2007-07-31 11:00:00	NVDA	Stock	0.7765	0.7818	0.7738	0.7788	35525580.0
2007-07-31 11:30:00	NVDA	Stock	0.7784	0.7835	0.7775	0.7833	24453660.0
2007-07-31 12:00:00	NVDA	Stock	0.7832	0.7917	0.7797	0.7836	30265200.0
2007-07-31 12:30:00	NVDA	Stock	0.7838	0.7842	0.7757	0.7782	19043580.0
2007-07-31 13:00:00	NVDA	Stock	0.7782	0.7792	0.7742	0.775	19670460.0
2007-07-31 13:30:00	NVDA	Stock	0.7749	0.7783	0.771	0.778	35038320.0
2007-07-31 14:00:00	NVDA	Stock	0.7778	0.7788	0.7717	0.7733	29431740.0
2007-07-31 14:30:00	NVDA	Stock	0.7737	0.774	0.7658	0.7668	52465200.0
2007-07-31 15:00:00	NVDA	Stock	0.7667	0.7712	0.7667	0.7682	41275500.0
2007-07-31 15:30:00	NVDA	Stock	0.768	0.77	0.7617	0.7625	91058820.0
2007-07-31 16:00:00	NVDA	Stock	0.7617	0.7667	0.7603	0.7617	19507140.0
2007-07-31 16:30:00	NVDA	Stock	0.7627	0.7627	0.7617	0.7617	2180460.0
2007-07-31 17:00:00	NVDA	Stock	0.7617	0.7627	0.7617	0.7617	67500.0
2007-07-31 17:30:00	NVDA	Stock	0.761	0.7625	0.761	0.7617	920400.0
2007-07-31 18:30:00	NVDA	Stock	0.7617	0.7617	0.7617	0.7617	6000.0

> showing 50 of 66,300 rows — these rows as CSV

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