PREVIEW / stock_30min / 2007-06-25

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-25.parquet
  size:    1.1 MB
  rows:    63,823
  symbols: 3,042

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-06-25 09:30:00	AAPL	Stock	4.4354	4.4407	4.3929	4.4169	106048964.0
2007-06-25 10:00:00	AAPL	Stock	4.4168	4.4325	4.4057	4.4221	61559008.0
2007-06-25 10:30:00	AAPL	Stock	4.4221	4.4639	4.4186	4.4639	94848264.0
2007-06-25 11:00:00	AAPL	Stock	4.4639	4.4643	4.4386	4.4496	78583400.0
2007-06-25 11:30:00	AAPL	Stock	4.4489	4.4618	4.4443	4.4602	44188956.0
2007-06-25 12:00:00	AAPL	Stock	4.4604	4.4675	4.4518	4.4543	44293620.0
2007-06-25 12:30:00	AAPL	Stock	4.455	4.4607	4.4475	4.4525	23361996.0
2007-06-25 13:00:00	AAPL	Stock	4.4525	4.4539	4.4436	4.445	26931576.0
2007-06-25 13:30:00	AAPL	Stock	4.445	4.4493	4.4161	4.4175	56174552.0
2007-06-25 14:00:00	AAPL	Stock	4.4173	4.4236	4.3793	4.3796	84864864.0
2007-06-25 14:30:00	AAPL	Stock	4.3793	4.3854	4.3375	4.3493	129434816.0
2007-06-25 15:00:00	AAPL	Stock	4.3493	4.3675	4.3236	4.365	101944444.0
2007-06-25 15:30:00	AAPL	Stock	4.365	4.3779	4.3521	4.3696	86788240.0
2007-06-25 16:00:00	AAPL	Stock	4.3654	4.3693	4.3654	4.3693	5154996.0
2007-06-25 09:30:00	MSFT	Stock	29.47	29.55	29.38	29.47	5483042.0
2007-06-25 10:00:00	MSFT	Stock	29.47	29.69	29.45	29.645	5375087.0
2007-06-25 10:30:00	MSFT	Stock	29.64	29.69	29.57	29.68	2959996.0
2007-06-25 11:00:00	MSFT	Stock	29.68	29.75	29.67	29.69	2993884.0
2007-06-25 11:30:00	MSFT	Stock	29.7	29.7	29.61	29.652	1941653.0
2007-06-25 12:00:00	MSFT	Stock	29.65	29.74	29.65	29.71	1745109.0
2007-06-25 12:30:00	MSFT	Stock	29.705	29.72	29.67	29.67	1451914.0
2007-06-25 13:00:00	MSFT	Stock	29.67	29.73	29.65	29.7	1940142.0
2007-06-25 13:30:00	MSFT	Stock	29.7	29.77	29.67	29.68	2722133.0
2007-06-25 14:00:00	MSFT	Stock	29.69	29.73	29.6	29.66	3895504.0
2007-06-25 14:30:00	MSFT	Stock	29.66	29.67	29.45	29.54	4759622.0
2007-06-25 15:00:00	MSFT	Stock	29.54	29.57	29.45	29.52	4296978.0
2007-06-25 15:30:00	MSFT	Stock	29.53	29.598	29.41	29.51	6133763.0
2007-06-25 16:00:00	MSFT	Stock	29.51	29.51	29.49	29.49	1229584.0
2007-06-25 07:00:00	NVDA	Stock	0.705	0.705	0.705	0.705	12000.0
2007-06-25 07:30:00	NVDA	Stock	0.711	0.711	0.7088	0.7088	24000.0
2007-06-25 08:00:00	NVDA	Stock	0.7083	0.7125	0.705	0.7083	1984320.0
2007-06-25 08:30:00	NVDA	Stock	0.7083	0.7083	0.705	0.7067	879900.0
2007-06-25 09:00:00	NVDA	Stock	0.706	0.7085	0.7048	0.7057	1546800.0
2007-06-25 09:30:00	NVDA	Stock	0.7067	0.7147	0.7002	0.7123	151268580.0
2007-06-25 10:00:00	NVDA	Stock	0.7125	0.7223	0.7117	0.7192	92346240.0
2007-06-25 10:30:00	NVDA	Stock	0.7192	0.7217	0.7167	0.7205	74929320.0
2007-06-25 11:00:00	NVDA	Stock	0.7207	0.724	0.7177	0.7213	48444960.0
2007-06-25 11:30:00	NVDA	Stock	0.7213	0.7225	0.7183	0.7188	39974040.0
2007-06-25 12:00:00	NVDA	Stock	0.7187	0.7218	0.7167	0.7172	36088080.0
2007-06-25 12:30:00	NVDA	Stock	0.7173	0.7182	0.7138	0.7153	34014840.0
2007-06-25 13:00:00	NVDA	Stock	0.7153	0.719	0.7112	0.7118	29190600.0
2007-06-25 13:30:00	NVDA	Stock	0.7118	0.7157	0.7118	0.7122	30227940.0
2007-06-25 14:00:00	NVDA	Stock	0.712	0.713	0.7068	0.7072	39183780.0
2007-06-25 14:30:00	NVDA	Stock	0.7072	0.7165	0.7042	0.705	65290860.0
2007-06-25 15:00:00	NVDA	Stock	0.705	0.7083	0.7013	0.7075	66161700.0
2007-06-25 15:30:00	NVDA	Stock	0.7075	0.7107	0.7053	0.708	70357140.0
2007-06-25 16:00:00	NVDA	Stock	0.708	0.7092	0.7078	0.7078	5900400.0
2007-06-25 16:30:00	NVDA	Stock	0.708	0.7097	0.708	0.7097	72000.0
2007-06-25 17:00:00	NVDA	Stock	0.7097	0.7097	0.7092	0.7092	120000.0
2007-06-25 17:30:00	NVDA	Stock	0.7105	0.7105	0.7105	0.7105	45000.0

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

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