PREVIEW / stock_30min / 2007-10-25

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-25.parquet
  size:    1.2 MB
  rows:    67,419
  symbols: 3,167

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-10-25 04:00:00	AAPL	Stock	6.6429	6.6607	6.6393	6.6607	42000.0
2007-10-25 04:30:00	AAPL	Stock	6.6518	6.6518	6.6518	6.6518	5600.0
2007-10-25 05:30:00	AAPL	Stock	6.66	6.675	6.66	6.675	89600.0
2007-10-25 06:00:00	AAPL	Stock	6.6786	6.7204	6.6786	6.7204	70000.0
2007-10-25 06:30:00	AAPL	Stock	6.7321	6.7321	6.715	6.7229	80640.0
2007-10-25 07:00:00	AAPL	Stock	6.7229	6.75	6.7182	6.75	640080.0
2007-10-25 07:30:00	AAPL	Stock	6.75	6.7675	6.7439	6.75	2550716.0
2007-10-25 08:00:00	AAPL	Stock	6.7432	6.7564	6.6693	6.6732	13785184.0
2007-10-25 08:30:00	AAPL	Stock	6.6714	6.6925	6.67	6.6757	10121916.0
2007-10-25 09:00:00	AAPL	Stock	6.6732	6.6746	6.5896	6.6046	12928916.0
2007-10-25 09:30:00	AAPL	Stock	6.6025	6.6214	6.5271	6.5396	151764984.0
2007-10-25 10:00:00	AAPL	Stock	6.54	6.6393	6.5368	6.6139	143442936.0
2007-10-25 10:30:00	AAPL	Stock	6.6136	6.6161	6.5786	6.5904	51875796.0
2007-10-25 11:00:00	AAPL	Stock	6.5911	6.5986	6.5536	6.5907	44692676.0
2007-10-25 11:30:00	AAPL	Stock	6.5896	6.6229	6.55	6.5521	52923500.0
2007-10-25 12:00:00	AAPL	Stock	6.5521	6.5854	6.54	6.5814	48245904.0
2007-10-25 12:30:00	AAPL	Stock	6.5807	6.5857	6.5546	6.5679	34430116.0
2007-10-25 13:00:00	AAPL	Stock	6.5686	6.5696	6.535	6.5554	54565420.0
2007-10-25 13:30:00	AAPL	Stock	6.555	6.5668	6.5271	6.5457	42700728.0
2007-10-25 14:00:00	AAPL	Stock	6.5457	6.5464	6.4879	6.5352	88343976.0
2007-10-25 14:30:00	AAPL	Stock	6.5339	6.5571	6.525	6.5514	62121388.0
2007-10-25 15:00:00	AAPL	Stock	6.5479	6.5564	6.5071	6.5296	67115692.0
2007-10-25 15:30:00	AAPL	Stock	6.5286	6.5618	6.5143	6.5279	75243112.0
2007-10-25 16:00:00	AAPL	Stock	6.5275	6.5979	6.5214	6.5771	9429700.0
2007-10-25 16:30:00	AAPL	Stock	6.5768	6.5979	6.5308	6.5943	2412032.0
2007-10-25 17:00:00	AAPL	Stock	6.5893	6.5893	6.5607	6.5768	1064448.0
2007-10-25 17:30:00	AAPL	Stock	6.5718	6.575	6.5279	6.5279	479080.0
2007-10-25 18:00:00	AAPL	Stock	6.5714	6.5821	6.5536	6.5757	1278760.0
2007-10-25 18:30:00	AAPL	Stock	6.5761	6.5839	6.5714	6.5768	506660.0
2007-10-25 19:00:00	AAPL	Stock	6.575	6.5768	6.5714	6.575	538804.0
2007-10-25 19:30:00	AAPL	Stock	6.5714	6.5782	6.5714	6.5775	131096.0
2007-10-25 04:00:00	MSFT	Stock	31.61	31.61	31.61	31.61	300.0
2007-10-25 07:00:00	MSFT	Stock	31.69	31.69	31.55	31.55	10500.0
2007-10-25 07:30:00	MSFT	Stock	31.51	31.51	31.44	31.5	6900.0
2007-10-25 08:00:00	MSFT	Stock	31.5	31.73	31.5	31.7	153225.0
2007-10-25 08:30:00	MSFT	Stock	31.69	31.71	31.64	31.65	532857.0
2007-10-25 09:00:00	MSFT	Stock	31.64	31.65	31.25	31.57	150574.0
2007-10-25 09:30:00	MSFT	Stock	31.6	31.74	31.49	31.71	19310425.0
2007-10-25 10:00:00	MSFT	Stock	31.7	32.12	31.65	31.94	21054828.0
2007-10-25 10:30:00	MSFT	Stock	31.94	31.94	31.76	31.89	8205917.0
2007-10-25 11:00:00	MSFT	Stock	31.89	31.91	31.75	31.8	7137676.0
2007-10-25 11:30:00	MSFT	Stock	31.82	32.0	31.8	31.84	8910363.0
2007-10-25 12:00:00	MSFT	Stock	31.84	31.91	31.76	31.788	5290701.0
2007-10-25 12:30:00	MSFT	Stock	31.78	31.82	31.75	31.77	4527682.0
2007-10-25 13:00:00	MSFT	Stock	31.76	31.88	31.73	31.83	7300479.0
2007-10-25 13:30:00	MSFT	Stock	31.83	31.97	31.83	31.97	5700723.0
2007-10-25 14:00:00	MSFT	Stock	31.968	31.99	31.91	31.97	6543669.0
2007-10-25 14:30:00	MSFT	Stock	31.97	32.19	31.96	32.15	9501847.0
2007-10-25 15:00:00	MSFT	Stock	32.16	32.21	32.09	32.11	9266039.0
2007-10-25 15:30:00	MSFT	Stock	32.11	32.22	31.99	32.0	19251822.0

> showing 50 of 67,419 rows — these rows as CSV

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