PREVIEW / stock_30min / 2007-06-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-27.parquet
  size:    1.1 MB
  rows:    64,369
  symbols: 3,050

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-06-27 09:30:00	AAPL	Stock	4.3075	4.3375	4.2746	4.305	169015980.0
2007-06-27 10:00:00	AAPL	Stock	4.3046	4.3121	4.2593	4.2729	120028944.0
2007-06-27 10:30:00	AAPL	Stock	4.2725	4.3	4.2604	4.2796	77577696.0
2007-06-27 11:00:00	AAPL	Stock	4.2796	4.3214	4.2679	4.3057	82216428.0
2007-06-27 11:30:00	AAPL	Stock	4.3064	4.3068	4.2907	4.2939	37530360.0
2007-06-27 12:00:00	AAPL	Stock	4.2936	4.3125	4.2936	4.3029	36936676.0
2007-06-27 12:30:00	AAPL	Stock	4.3025	4.3107	4.2961	4.31	26204192.0
2007-06-27 13:00:00	AAPL	Stock	4.3104	4.3179	4.3011	4.3064	30478364.0
2007-06-27 13:30:00	AAPL	Stock	4.3064	4.3075	4.2782	4.2839	54940704.0
2007-06-27 14:00:00	AAPL	Stock	4.2836	4.3064	4.2807	4.2996	45551184.0
2007-06-27 14:30:00	AAPL	Stock	4.2993	4.3357	4.2964	4.3186	78894676.0
2007-06-27 15:00:00	AAPL	Stock	4.3186	4.3418	4.3143	4.3343	70608636.0
2007-06-27 15:30:00	AAPL	Stock	4.3339	4.3586	4.3336	4.3568	97203904.0
2007-06-27 16:00:00	AAPL	Stock	4.3568	4.3568	4.3532	4.3532	8557528.0
2007-06-27 09:30:00	MSFT	Stock	29.36	29.71	29.36	29.63	4874868.0
2007-06-27 10:00:00	MSFT	Stock	29.63	29.67	29.58	29.65	3662823.0
2007-06-27 10:30:00	MSFT	Stock	29.65	29.72	29.59	29.62	3269613.0
2007-06-27 11:00:00	MSFT	Stock	29.62	29.72	29.61	29.69	2171217.0
2007-06-27 11:30:00	MSFT	Stock	29.68	29.69	29.57	29.595	2337170.0
2007-06-27 12:00:00	MSFT	Stock	29.59	29.66	29.59	29.63	1940765.0
2007-06-27 12:30:00	MSFT	Stock	29.63	29.71	29.62	29.65	2349031.0
2007-06-27 13:00:00	MSFT	Stock	29.66	29.7	29.62	29.67	2469594.0
2007-06-27 13:30:00	MSFT	Stock	29.66	29.69	29.62	29.69	2082988.0
2007-06-27 14:00:00	MSFT	Stock	29.69	29.85	29.685	29.82	3259611.0
2007-06-27 14:30:00	MSFT	Stock	29.82	29.89	29.81	29.86	2870385.0
2007-06-27 15:00:00	MSFT	Stock	29.85	29.9	29.8	29.88	3844693.0
2007-06-27 15:30:00	MSFT	Stock	29.89	29.95	29.83	29.88	6529268.0
2007-06-27 16:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	1679194.0
2007-06-27 08:30:00	NVDA	Stock	0.6748	0.6748	0.6748	0.6748	1266480.0
2007-06-27 09:00:00	NVDA	Stock	0.6742	0.6745	0.6715	0.6745	330000.0
2007-06-27 09:30:00	NVDA	Stock	0.6723	0.684	0.6717	0.682	66256500.0
2007-06-27 10:00:00	NVDA	Stock	0.682	0.6898	0.6805	0.6887	65020320.0
2007-06-27 10:30:00	NVDA	Stock	0.6887	0.6933	0.683	0.683	60289740.0
2007-06-27 11:00:00	NVDA	Stock	0.683	0.6902	0.6818	0.689	60893040.0
2007-06-27 11:30:00	NVDA	Stock	0.689	0.689	0.681	0.6848	41612160.0
2007-06-27 12:00:00	NVDA	Stock	0.6847	0.6885	0.6847	0.6878	31276380.0
2007-06-27 12:30:00	NVDA	Stock	0.6879	0.691	0.687	0.6885	23185260.0
2007-06-27 13:00:00	NVDA	Stock	0.6887	0.6887	0.6838	0.6845	19352340.0
2007-06-27 13:30:00	NVDA	Stock	0.6843	0.6867	0.6817	0.6858	28215720.0
2007-06-27 14:00:00	NVDA	Stock	0.6857	0.6903	0.6855	0.69	31983120.0
2007-06-27 14:30:00	NVDA	Stock	0.6902	0.6915	0.6893	0.6905	33283200.0
2007-06-27 15:00:00	NVDA	Stock	0.6905	0.694	0.6901	0.6933	48201060.0
2007-06-27 15:30:00	NVDA	Stock	0.6932	0.694	0.692	0.6935	68085660.0
2007-06-27 16:00:00	NVDA	Stock	0.6937	0.703	0.6932	0.695	11429220.0
2007-06-27 16:30:00	NVDA	Stock	0.6952	0.6952	0.695	0.695	113100.0
2007-06-27 17:00:00	NVDA	Stock	0.695	0.695	0.6947	0.6947	42000.0
2007-06-27 17:30:00	NVDA	Stock	0.6947	0.6947	0.6947	0.6947	18000.0
2007-06-27 18:30:00	NVDA	Stock	0.6947	0.6947	0.6947	0.6947	24000.0
2007-06-27 19:00:00	NVDA	Stock	0.6947	0.6947	0.6947	0.6947	6000.0
2007-06-27 19:30:00	NVDA	Stock	0.6937	0.6937	0.6937	0.6937	6000.0

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

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