PREVIEW / stock_30min / 2007-08-15

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-15.parquet
  size:    1.2 MB
  rows:    65,786
  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-15 09:30:00	AAPL	Stock	4.3836	4.4593	4.3493	4.4357	151026260.0
2007-08-15 10:00:00	AAPL	Stock	4.435	4.4426	4.4004	4.4357	71764084.0
2007-08-15 10:30:00	AAPL	Stock	4.4357	4.4357	4.3882	4.3925	53625740.0
2007-08-15 11:00:00	AAPL	Stock	4.3925	4.4011	4.3607	4.3961	61058788.0
2007-08-15 11:30:00	AAPL	Stock	4.3957	4.3982	4.3371	4.3393	73402280.0
2007-08-15 12:00:00	AAPL	Stock	4.3393	4.3714	4.3346	4.3543	55290032.0
2007-08-15 12:30:00	AAPL	Stock	4.3543	4.3793	4.3479	4.3586	34166692.0
2007-08-15 13:00:00	AAPL	Stock	4.3579	4.3782	4.3475	4.3714	37845304.0
2007-08-15 13:30:00	AAPL	Stock	4.3718	4.4221	4.3714	4.3939	62847176.0
2007-08-15 14:00:00	AAPL	Stock	4.3946	4.4104	4.3711	4.3806	47317844.0
2007-08-15 14:30:00	AAPL	Stock	4.3811	4.3921	4.3461	4.3543	57484616.0
2007-08-15 15:00:00	AAPL	Stock	4.3539	4.3668	4.3236	4.3239	74828376.0
2007-08-15 15:30:00	AAPL	Stock	4.3239	4.3336	4.2732	4.2846	153570900.0
2007-08-15 16:00:00	AAPL	Stock	4.2846	4.2857	4.2821	4.2821	10877496.0
2007-08-15 09:30:00	MSFT	Stock	28.24	28.62	28.14	28.56	3810672.0
2007-08-15 10:00:00	MSFT	Stock	28.56	28.71	28.55	28.69	4141558.0
2007-08-15 10:30:00	MSFT	Stock	28.68	28.69	28.55	28.62	3022010.0
2007-08-15 11:00:00	MSFT	Stock	28.62	28.74	28.56	28.72	1869187.0
2007-08-15 11:30:00	MSFT	Stock	28.71	28.72	28.51	28.57	2646795.0
2007-08-15 12:00:00	MSFT	Stock	28.57	28.74	28.55	28.69	1617145.0
2007-08-15 12:30:00	MSFT	Stock	28.69	28.74	28.61	28.7	1400701.0
2007-08-15 13:00:00	MSFT	Stock	28.69	28.8	28.64	28.76	1621950.0
2007-08-15 13:30:00	MSFT	Stock	28.77	28.99	28.76	28.95	3509609.0
2007-08-15 14:00:00	MSFT	Stock	28.95	28.96	28.76	28.78	3344263.0
2007-08-15 14:30:00	MSFT	Stock	28.78	28.8	28.45	28.47	3523309.0
2007-08-15 15:00:00	MSFT	Stock	28.47	28.655	28.26	28.27	4533582.0
2007-08-15 15:30:00	MSFT	Stock	28.27	28.32	28.05	28.11	6955726.0
2007-08-15 16:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	1822099.0
2007-08-15 08:00:00	NVDA	Stock	0.7492	0.7508	0.7468	0.7475	555000.0
2007-08-15 08:30:00	NVDA	Stock	0.7475	0.75	0.7475	0.75	209880.0
2007-08-15 09:00:00	NVDA	Stock	0.75	0.7567	0.7477	0.7567	931260.0
2007-08-15 09:30:00	NVDA	Stock	0.7493	0.7537	0.7337	0.7437	102809880.0
2007-08-15 10:00:00	NVDA	Stock	0.7438	0.76	0.738	0.759	69578700.0
2007-08-15 10:30:00	NVDA	Stock	0.759	0.7598	0.7435	0.7465	54619620.0
2007-08-15 11:00:00	NVDA	Stock	0.747	0.7475	0.742	0.745	36501600.0
2007-08-15 11:30:00	NVDA	Stock	0.745	0.745	0.7377	0.7395	37371900.0
2007-08-15 12:00:00	NVDA	Stock	0.739	0.7417	0.7362	0.7385	29685180.0
2007-08-15 12:30:00	NVDA	Stock	0.7383	0.7425	0.7375	0.7378	25619700.0
2007-08-15 13:00:00	NVDA	Stock	0.7378	0.7378	0.7292	0.7322	49263240.0
2007-08-15 13:30:00	NVDA	Stock	0.7323	0.7442	0.7322	0.7412	35891340.0
2007-08-15 14:00:00	NVDA	Stock	0.7408	0.7448	0.7372	0.7437	41934120.0
2007-08-15 14:30:00	NVDA	Stock	0.7437	0.744	0.7325	0.7337	42484800.0
2007-08-15 15:00:00	NVDA	Stock	0.7338	0.7378	0.7255	0.7258	64601100.0
2007-08-15 15:30:00	NVDA	Stock	0.7258	0.7269	0.7205	0.7215	69263580.0
2007-08-15 16:00:00	NVDA	Stock	0.7215	0.7258	0.7215	0.7253	9967320.0
2007-08-15 16:30:00	NVDA	Stock	0.7258	0.7267	0.7215	0.7217	1593000.0
2007-08-15 17:00:00	NVDA	Stock	0.7218	0.722	0.7218	0.722	165780.0
2007-08-15 18:00:00	NVDA	Stock	0.722	0.722	0.7217	0.7217	53400.0
2007-08-15 18:30:00	NVDA	Stock	0.7213	0.7213	0.72	0.72	53400.0
2007-08-15 19:00:00	NVDA	Stock	0.7192	0.7192	0.7192	0.7192	6000.0

> showing 50 of 65,786 rows — these rows as CSV

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