PREVIEW / stock_30min / 2007-07-16

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-16.parquet
  size:    1.1 MB
  rows:    64,818
  symbols: 3,070

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-16 09:30:00	AAPL	Stock	4.9425	4.9993	4.9289	4.9493	209116264.0
2007-07-16 10:00:00	AAPL	Stock	4.9514	4.9639	4.9368	4.955	126977816.0
2007-07-16 10:30:00	AAPL	Stock	4.955	4.9882	4.9436	4.9729	88286352.0
2007-07-16 11:00:00	AAPL	Stock	4.9734	4.9882	4.9657	4.9821	47373480.0
2007-07-16 11:30:00	AAPL	Stock	4.9825	4.9843	4.9643	4.9754	41560064.0
2007-07-16 12:00:00	AAPL	Stock	4.9757	4.9789	4.9561	4.9611	38485552.0
2007-07-16 12:30:00	AAPL	Stock	4.9611	4.9711	4.9611	4.9654	23883748.0
2007-07-16 13:00:00	AAPL	Stock	4.9654	4.9725	4.9443	4.9479	43609692.0
2007-07-16 13:30:00	AAPL	Stock	4.9479	4.9493	4.9164	4.9254	78797992.0
2007-07-16 14:00:00	AAPL	Stock	4.9257	4.9407	4.9107	4.9386	62366136.0
2007-07-16 14:30:00	AAPL	Stock	4.9389	4.9554	4.9311	4.9371	41144656.0
2007-07-16 15:00:00	AAPL	Stock	4.9368	4.9457	4.9218	4.9457	36606136.0
2007-07-16 15:30:00	AAPL	Stock	4.9457	4.9479	4.9286	4.9314	67131960.0
2007-07-16 16:00:00	AAPL	Stock	4.9314	4.9321	4.9311	4.9321	9521932.0
2007-07-16 09:30:00	MSFT	Stock	29.76	29.97	29.72	29.96	3948102.0
2007-07-16 10:00:00	MSFT	Stock	29.95	29.98	29.9	29.97	2319480.0
2007-07-16 10:30:00	MSFT	Stock	29.98	30.15	29.97	30.15	4547137.0
2007-07-16 11:00:00	MSFT	Stock	30.15	30.15	30.09	30.13	2132495.0
2007-07-16 11:30:00	MSFT	Stock	30.135	30.19	30.1	30.18	2359114.0
2007-07-16 12:00:00	MSFT	Stock	30.18	30.24	30.11	30.15	3357250.0
2007-07-16 12:30:00	MSFT	Stock	30.14	30.19	30.1	30.11	2707204.0
2007-07-16 13:00:00	MSFT	Stock	30.11	30.15	30.04	30.09	2191391.0
2007-07-16 13:30:00	MSFT	Stock	30.09	30.13	30.02	30.03	2548700.0
2007-07-16 14:00:00	MSFT	Stock	30.03	30.04	30.0	30.033	2382577.0
2007-07-16 14:30:00	MSFT	Stock	30.03	30.11	30.02	30.06	2107056.0
2007-07-16 15:00:00	MSFT	Stock	30.05	30.15	30.04	30.14	3016012.0
2007-07-16 15:30:00	MSFT	Stock	30.15	30.15	30.02	30.03	5535417.0
2007-07-16 16:00:00	MSFT	Stock	30.03	30.03	30.03	30.03	1447654.0
2007-07-16 08:30:00	NVDA	Stock	0.7708	0.7717	0.7708	0.7717	24000.0
2007-07-16 09:00:00	NVDA	Stock	0.7697	0.771	0.765	0.7652	588180.0
2007-07-16 09:30:00	NVDA	Stock	0.7652	0.7697	0.765	0.7678	39588660.0
2007-07-16 10:00:00	NVDA	Stock	0.7677	0.7707	0.7663	0.7703	27738000.0
2007-07-16 10:30:00	NVDA	Stock	0.7703	0.7738	0.7702	0.7735	26820960.0
2007-07-16 11:00:00	NVDA	Stock	0.7733	0.7798	0.7731	0.7792	43271220.0
2007-07-16 11:30:00	NVDA	Stock	0.7792	0.7797	0.7775	0.778	24062700.0
2007-07-16 12:00:00	NVDA	Stock	0.7782	0.7808	0.7777	0.7804	23852820.0
2007-07-16 12:30:00	NVDA	Stock	0.7803	0.7815	0.7785	0.7812	19382400.0
2007-07-16 13:00:00	NVDA	Stock	0.7812	0.7815	0.7757	0.776	23044200.0
2007-07-16 13:30:00	NVDA	Stock	0.7762	0.7762	0.7715	0.772	94719180.0
2007-07-16 14:00:00	NVDA	Stock	0.7722	0.774	0.7713	0.774	18685500.0
2007-07-16 14:30:00	NVDA	Stock	0.7741	0.7772	0.7735	0.7755	26070240.0
2007-07-16 15:00:00	NVDA	Stock	0.7753	0.7763	0.7738	0.7758	21295800.0
2007-07-16 15:30:00	NVDA	Stock	0.776	0.7795	0.7747	0.7783	66386400.0
2007-07-16 16:00:00	NVDA	Stock	0.7783	0.7783	0.7754	0.7767	59046900.0
2007-07-16 16:30:00	NVDA	Stock	0.778	0.778	0.7768	0.7768	1218000.0
2007-07-16 17:30:00	NVDA	Stock	0.7745	0.7783	0.7745	0.7783	97380.0
2007-07-16 19:00:00	NVDA	Stock	0.7808	0.7808	0.7808	0.7808	6000.0
2007-07-16 07:00:00	AMZN	Stock	3.7405	3.75	3.7325	3.7425	96100.0
2007-07-16 07:30:00	AMZN	Stock	3.7425	3.7625	3.7375	3.7625	118920.0
2007-07-16 08:00:00	AMZN	Stock	3.76	3.76	3.735	3.735	402140.0

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

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