PREVIEW / stock_30min / 2007-08-08

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-08.parquet
  size:    1.2 MB
  rows:    68,119
  symbols: 3,122

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-08 09:30:00	AAPL	Stock	4.8843	4.8879	4.7989	4.8157	105577332.0
2007-08-08 10:00:00	AAPL	Stock	4.8157	4.8325	4.7911	4.7982	77284256.0
2007-08-08 10:30:00	AAPL	Stock	4.7975	4.8275	4.7804	4.7925	74884712.0
2007-08-08 11:00:00	AAPL	Stock	4.7929	4.8114	4.7768	4.7964	61002116.0
2007-08-08 11:30:00	AAPL	Stock	4.7964	4.825	4.7896	4.8064	41373052.0
2007-08-08 12:00:00	AAPL	Stock	4.8057	4.8064	4.7889	4.7961	30719668.0
2007-08-08 12:30:00	AAPL	Stock	4.7957	4.8068	4.7907	4.7929	26523728.0
2007-08-08 13:00:00	AAPL	Stock	4.7921	4.8171	4.7904	4.8107	27126344.0
2007-08-08 13:30:00	AAPL	Stock	4.8107	4.8221	4.8004	4.8194	38647952.0
2007-08-08 14:00:00	AAPL	Stock	4.82	4.8396	4.8075	4.8304	56025508.0
2007-08-08 14:30:00	AAPL	Stock	4.8304	4.8343	4.7857	4.7964	49731444.0
2007-08-08 15:00:00	AAPL	Stock	4.7964	4.8082	4.7425	4.7461	79301824.0
2007-08-08 15:30:00	AAPL	Stock	4.7468	4.7946	4.7143	4.7707	85965068.0
2007-08-08 16:00:00	AAPL	Stock	4.7707	4.7861	4.7639	4.7857	11519480.0
2007-08-08 09:30:00	MSFT	Stock	29.72	29.72	29.21	29.58	4608749.0
2007-08-08 10:00:00	MSFT	Stock	29.59	29.64	29.51	29.58	3409433.0
2007-08-08 10:30:00	MSFT	Stock	29.58	29.65	29.52	29.57	2261393.0
2007-08-08 11:00:00	MSFT	Stock	29.561	29.59	29.47	29.58	1839937.0
2007-08-08 11:30:00	MSFT	Stock	29.58	29.63	29.53	29.58	1780601.0
2007-08-08 12:00:00	MSFT	Stock	29.57	29.63	29.54	29.562	2157566.0
2007-08-08 12:30:00	MSFT	Stock	29.57	29.66	29.57	29.58	1924977.0
2007-08-08 13:00:00	MSFT	Stock	29.58	29.698	29.54	29.69	2282579.0
2007-08-08 13:30:00	MSFT	Stock	29.69	29.76	29.61	29.7	4275744.0
2007-08-08 14:00:00	MSFT	Stock	29.71	29.81	29.65	29.8	3055864.0
2007-08-08 14:30:00	MSFT	Stock	29.8	29.86	29.7	29.7	3398835.0
2007-08-08 15:00:00	MSFT	Stock	29.71	29.77	29.56	29.59	5546532.0
2007-08-08 15:30:00	MSFT	Stock	29.58	29.95	29.57	29.95	6636764.0
2007-08-08 16:00:00	MSFT	Stock	29.95	30.01	29.82	29.9	3036605.0
2007-08-08 08:00:00	NVDA	Stock	0.7408	0.7467	0.7408	0.7417	126000.0
2007-08-08 08:30:00	NVDA	Stock	0.7417	0.7417	0.7383	0.7417	198000.0
2007-08-08 09:00:00	NVDA	Stock	0.7403	0.7413	0.7383	0.741	447000.0
2007-08-08 09:30:00	NVDA	Stock	0.7394	0.7642	0.7338	0.7588	98404500.0
2007-08-08 10:00:00	NVDA	Stock	0.7587	0.763	0.7533	0.7597	63574260.0
2007-08-08 10:30:00	NVDA	Stock	0.7598	0.7663	0.7557	0.7637	47368440.0
2007-08-08 11:00:00	NVDA	Stock	0.7638	0.764	0.7553	0.7593	43860000.0
2007-08-08 11:30:00	NVDA	Stock	0.7595	0.7625	0.7564	0.7575	29004900.0
2007-08-08 12:00:00	NVDA	Stock	0.7575	0.7583	0.7497	0.7572	45546420.0
2007-08-08 12:30:00	NVDA	Stock	0.7573	0.7658	0.7573	0.7627	22285980.0
2007-08-08 13:00:00	NVDA	Stock	0.7627	0.7682	0.7605	0.7672	25875120.0
2007-08-08 13:30:00	NVDA	Stock	0.7668	0.775	0.7668	0.7748	38115180.0
2007-08-08 14:00:00	NVDA	Stock	0.7748	0.7825	0.7712	0.7795	41515860.0
2007-08-08 14:30:00	NVDA	Stock	0.7793	0.7793	0.7625	0.7628	49783080.0
2007-08-08 15:00:00	NVDA	Stock	0.7635	0.7655	0.7505	0.7513	51258420.0
2007-08-08 15:30:00	NVDA	Stock	0.751	0.7613	0.75	0.76	58226340.0
2007-08-08 16:00:00	NVDA	Stock	0.76	0.7623	0.7597	0.7603	13691640.0
2007-08-08 16:30:00	NVDA	Stock	0.7605	0.7622	0.76	0.7622	981720.0
2007-08-08 17:00:00	NVDA	Stock	0.7648	0.7653	0.7648	0.7653	116220.0
2007-08-08 17:30:00	NVDA	Stock	0.7653	0.7665	0.7653	0.7655	165000.0
2007-08-08 18:00:00	NVDA	Stock	0.7665	0.7667	0.7663	0.7667	84000.0
2007-08-08 18:30:00	NVDA	Stock	0.7682	0.7733	0.7682	0.7722	643800.0

> showing 50 of 68,119 rows — these rows as CSV

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