PREVIEW / stock_30min / 2007-08-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-27.parquet
  size:    1.1 MB
  rows:    63,522
  symbols: 3,109

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-27 09:30:00	AAPL	Stock	4.764	4.78	4.74	4.7743	126891492.0
2007-08-27 10:00:00	AAPL	Stock	4.7746	4.805	4.7564	4.7944	79611084.0
2007-08-27 10:30:00	AAPL	Stock	4.795	4.8093	4.7682	4.7786	57626268.0
2007-08-27 11:00:00	AAPL	Stock	4.7782	4.7789	4.7514	4.7618	43286432.0
2007-08-27 11:30:00	AAPL	Stock	4.7614	4.7711	4.7518	4.7586	25483948.0
2007-08-27 12:00:00	AAPL	Stock	4.7589	4.7657	4.7464	4.7575	35521416.0
2007-08-27 12:30:00	AAPL	Stock	4.7579	4.7707	4.7557	4.7646	25824176.0
2007-08-27 13:00:00	AAPL	Stock	4.765	4.7811	4.7621	4.7679	27348692.0
2007-08-27 13:30:00	AAPL	Stock	4.7671	4.7711	4.75	4.7582	25459476.0
2007-08-27 14:00:00	AAPL	Stock	4.7582	4.775	4.7546	4.7668	24586800.0
2007-08-27 14:30:00	AAPL	Stock	4.7671	4.7732	4.7511	4.7572	32049192.0
2007-08-27 15:00:00	AAPL	Stock	4.7575	4.7596	4.7411	4.7432	43075592.0
2007-08-27 15:30:00	AAPL	Stock	4.7429	4.7529	4.7179	4.725	71176504.0
2007-08-27 16:00:00	AAPL	Stock	4.725	4.7254	4.7193	4.7232	2873892.0
2007-08-27 09:30:00	MSFT	Stock	28.61	28.77	28.54	28.65	2388496.0
2007-08-27 10:00:00	MSFT	Stock	28.66	28.69	28.54	28.57	2188080.0
2007-08-27 10:30:00	MSFT	Stock	28.57	28.58	28.5	28.503	1331877.0
2007-08-27 11:00:00	MSFT	Stock	28.51	28.51	28.44	28.5	1461979.0
2007-08-27 11:30:00	MSFT	Stock	28.5	28.5	28.42	28.44	948639.0
2007-08-27 12:00:00	MSFT	Stock	28.45	28.47	28.4	28.47	981453.0
2007-08-27 12:30:00	MSFT	Stock	28.46	28.55	28.46	28.53	1273271.0
2007-08-27 13:00:00	MSFT	Stock	28.53	28.58	28.51	28.54	1450822.0
2007-08-27 13:30:00	MSFT	Stock	28.53	28.58	28.5	28.562	1535932.0
2007-08-27 14:00:00	MSFT	Stock	28.562	28.6	28.53	28.57	1468485.0
2007-08-27 14:30:00	MSFT	Stock	28.56	28.61	28.5	28.51	1022924.0
2007-08-27 15:00:00	MSFT	Stock	28.51	28.52	28.43	28.46	1649458.0
2007-08-27 15:30:00	MSFT	Stock	28.45	28.51	28.44	28.49	3533460.0
2007-08-27 16:00:00	MSFT	Stock	28.48	28.49	28.48	28.49	1063270.0
2007-08-27 07:30:00	NVDA	Stock	0.8053	0.8053	0.8053	0.8053	6000.0
2007-08-27 08:30:00	NVDA	Stock	0.8082	0.8082	0.8025	0.8025	138000.0
2007-08-27 09:00:00	NVDA	Stock	0.8025	0.804	0.8	0.8	450000.0
2007-08-27 09:30:00	NVDA	Stock	0.8038	0.8148	0.8005	0.8143	46811700.0
2007-08-27 10:00:00	NVDA	Stock	0.8145	0.8213	0.8113	0.8208	63926820.0
2007-08-27 10:30:00	NVDA	Stock	0.8207	0.8265	0.8175	0.8183	52247640.0
2007-08-27 11:00:00	NVDA	Stock	0.818	0.821	0.814	0.8187	35386440.0
2007-08-27 11:30:00	NVDA	Stock	0.8185	0.8242	0.8172	0.8227	36159060.0
2007-08-27 12:00:00	NVDA	Stock	0.8227	0.8233	0.8175	0.8177	24911820.0
2007-08-27 12:30:00	NVDA	Stock	0.8177	0.8233	0.8168	0.8225	26534400.0
2007-08-27 13:00:00	NVDA	Stock	0.8225	0.8253	0.8212	0.8253	28761120.0
2007-08-27 13:30:00	NVDA	Stock	0.8253	0.8265	0.823	0.8238	31996140.0
2007-08-27 14:00:00	NVDA	Stock	0.8237	0.8275	0.8228	0.8268	30327240.0
2007-08-27 14:30:00	NVDA	Stock	0.827	0.8308	0.8252	0.8258	41743320.0
2007-08-27 15:00:00	NVDA	Stock	0.8257	0.829	0.8237	0.8262	45121380.0
2007-08-27 15:30:00	NVDA	Stock	0.8262	0.829	0.8212	0.8227	64225860.0
2007-08-27 16:00:00	NVDA	Stock	0.8227	0.8227	0.8207	0.8207	7053240.0
2007-08-27 16:30:00	NVDA	Stock	0.8223	0.8223	0.821	0.8222	14436300.0
2007-08-27 17:00:00	NVDA	Stock	0.8222	0.8222	0.8222	0.8222	24000.0
2007-08-27 17:30:00	NVDA	Stock	0.8232	0.8232	0.8232	0.8232	42600.0
2007-08-27 18:00:00	NVDA	Stock	0.8267	0.8288	0.8267	0.8267	201240.0
2007-08-27 18:30:00	NVDA	Stock	0.8258	0.8258	0.825	0.825	119160.0

> showing 50 of 63,522 rows — these rows as CSV

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