PREVIEW / stock_30min / 2007-08-09

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-09.parquet
  size:    1.2 MB
  rows:    67,047
  symbols: 3,088

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-09 09:30:00	AAPL	Stock	4.6825	4.7282	4.6643	4.7171	115856944.0
2007-08-09 10:00:00	AAPL	Stock	4.7175	4.73	4.6911	4.7193	68365780.0
2007-08-09 10:30:00	AAPL	Stock	4.7193	4.75	4.6932	4.7068	63878052.0
2007-08-09 11:00:00	AAPL	Stock	4.7068	4.7125	4.675	4.6907	52828188.0
2007-08-09 11:30:00	AAPL	Stock	4.6904	4.6989	4.6557	4.6664	55769728.0
2007-08-09 12:00:00	AAPL	Stock	4.6664	4.6821	4.6493	4.6782	48767068.0
2007-08-09 12:30:00	AAPL	Stock	4.6782	4.6782	4.6432	4.6514	43690500.0
2007-08-09 13:00:00	AAPL	Stock	4.6507	4.6601	4.635	4.6568	52025344.0
2007-08-09 13:30:00	AAPL	Stock	4.6571	4.6825	4.6536	4.6579	42706804.0
2007-08-09 14:00:00	AAPL	Stock	4.6582	4.6596	4.6321	4.6386	56502236.0
2007-08-09 14:30:00	AAPL	Stock	4.6386	4.6407	4.5243	4.5529	147326396.0
2007-08-09 15:00:00	AAPL	Stock	4.5529	4.5682	4.4675	4.5154	161827652.0
2007-08-09 15:30:00	AAPL	Stock	4.5154	4.5664	4.4821	4.5296	145088272.0
2007-08-09 16:00:00	AAPL	Stock	4.5293	4.5422	4.5139	4.5139	16314816.0
2007-08-09 09:30:00	MSFT	Stock	29.64	30.1	29.64	29.923	6267883.0
2007-08-09 10:00:00	MSFT	Stock	29.92	29.99	29.84	29.97	5228260.0
2007-08-09 10:30:00	MSFT	Stock	29.97	30.07	29.85	29.93	4319940.0
2007-08-09 11:00:00	MSFT	Stock	29.929	30.01	29.88	29.9	3693321.0
2007-08-09 11:30:00	MSFT	Stock	29.9	29.95	29.62	29.665	3210958.0
2007-08-09 12:00:00	MSFT	Stock	29.665	29.68	29.53	29.63	3440333.0
2007-08-09 12:30:00	MSFT	Stock	29.62	29.62	29.27	29.32	5899709.0
2007-08-09 13:00:00	MSFT	Stock	29.31	29.41	29.29	29.39	4874645.0
2007-08-09 13:30:00	MSFT	Stock	29.39	29.47	29.36	29.42	2077497.0
2007-08-09 14:00:00	MSFT	Stock	29.42	29.48	29.28	29.32	2870090.0
2007-08-09 14:30:00	MSFT	Stock	29.33	29.47	29.23	29.23	4806773.0
2007-08-09 15:00:00	MSFT	Stock	29.23	29.29	29.06	29.13	7576806.0
2007-08-09 15:30:00	MSFT	Stock	29.13	29.2	28.93	28.95	12312812.0
2007-08-09 16:00:00	MSFT	Stock	29.0	29.0	28.92	28.92	2298214.0
2007-08-09 17:00:00	MSFT	Stock	29.3	29.3	29.3	29.3	15000.0
2007-08-09 07:00:00	NVDA	Stock	0.7528	0.7565	0.7528	0.7565	78000.0
2007-08-09 07:30:00	NVDA	Stock	0.7565	0.7575	0.7542	0.7573	190200.0
2007-08-09 08:00:00	NVDA	Stock	0.7573	0.7692	0.7573	0.7683	1953960.0
2007-08-09 08:30:00	NVDA	Stock	0.768	0.7683	0.7567	0.7583	3610380.0
2007-08-09 09:00:00	NVDA	Stock	0.76	0.7642	0.748	0.7627	3789720.0
2007-08-09 09:30:00	NVDA	Stock	0.765	0.783	0.7475	0.777	127516020.0
2007-08-09 10:00:00	NVDA	Stock	0.7773	0.7882	0.7723	0.7808	107542020.0
2007-08-09 10:30:00	NVDA	Stock	0.7805	0.7845	0.7732	0.7827	58119180.0
2007-08-09 11:00:00	NVDA	Stock	0.7825	0.79	0.775	0.7757	67564080.0
2007-08-09 11:30:00	NVDA	Stock	0.7757	0.781	0.7667	0.779	62805480.0
2007-08-09 12:00:00	NVDA	Stock	0.779	0.785	0.7752	0.7847	38554680.0
2007-08-09 12:30:00	NVDA	Stock	0.7847	0.7847	0.7708	0.7713	45646680.0
2007-08-09 13:00:00	NVDA	Stock	0.7713	0.7717	0.7625	0.7648	64596360.0
2007-08-09 13:30:00	NVDA	Stock	0.7648	0.7873	0.7622	0.7677	43540680.0
2007-08-09 14:00:00	NVDA	Stock	0.7677	0.7677	0.7622	0.7622	36864780.0
2007-08-09 14:30:00	NVDA	Stock	0.7622	0.7868	0.76	0.7608	65008560.0
2007-08-09 15:00:00	NVDA	Stock	0.7608	0.7732	0.7583	0.7692	79669860.0
2007-08-09 15:30:00	NVDA	Stock	0.769	0.79	0.7675	0.7733	179500860.0
2007-08-09 16:00:00	NVDA	Stock	0.7688	0.7853	0.75	0.7832	28565640.0
2007-08-09 16:30:00	NVDA	Stock	0.7802	0.8142	0.7735	0.796	86950260.0
2007-08-09 17:00:00	NVDA	Stock	0.7958	0.8008	0.7582	0.765	61319220.0

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

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