PREVIEW / stock_30min / 2007-01-05

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-05.parquet
  size:    993 KB
  rows:    53,489
  symbols: 2,482

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-01-05 06:00:00	AAPL	Stock	3.0714	3.0714	3.0714	3.0714	14000.0
2007-01-05 06:30:00	AAPL	Stock	3.0596	3.0596	3.0586	3.0586	58240.0
2007-01-05 07:00:00	AAPL	Stock	3.0671	3.0682	3.0536	3.0536	81200.0
2007-01-05 07:30:00	AAPL	Stock	3.0593	3.0593	3.0464	3.05	140364.0
2007-01-05 08:00:00	AAPL	Stock	3.05	3.0639	3.0389	3.05	3072216.0
2007-01-05 08:30:00	AAPL	Stock	3.0518	3.0593	3.0464	3.05	2415392.0
2007-01-05 09:00:00	AAPL	Stock	3.0518	3.0661	3.0464	3.0632	4720268.0
2007-01-05 09:30:00	AAPL	Stock	3.0632	3.0786	3.0371	3.0524	164809764.0
2007-01-05 10:00:00	AAPL	Stock	3.0518	3.0668	3.0404	3.0457	95756668.0
2007-01-05 10:30:00	AAPL	Stock	3.046	3.0546	3.0311	3.0318	70605500.0
2007-01-05 11:00:00	AAPL	Stock	3.0321	3.0436	3.0179	3.0186	70410060.0
2007-01-05 11:30:00	AAPL	Stock	3.0186	3.0289	3.0143	3.0232	61062204.0
2007-01-05 12:00:00	AAPL	Stock	3.0236	3.0786	3.0229	3.0386	46788196.0
2007-01-05 12:30:00	AAPL	Stock	3.0382	3.0675	3.0336	3.0385	41688752.0
2007-01-05 13:00:00	AAPL	Stock	3.0386	3.0586	3.0321	3.0404	34929944.0
2007-01-05 13:30:00	AAPL	Stock	3.0407	3.0436	3.0321	3.0389	30852416.0
2007-01-05 14:00:00	AAPL	Stock	3.0393	3.0411	3.0311	3.0396	42055804.0
2007-01-05 14:30:00	AAPL	Stock	3.0396	3.0496	3.0364	3.0371	44339736.0
2007-01-05 15:00:00	AAPL	Stock	3.0371	3.0464	3.0307	3.0421	47906740.0
2007-01-05 15:30:00	AAPL	Stock	3.0418	3.0457	3.0368	3.0386	61267136.0
2007-01-05 16:00:00	AAPL	Stock	3.0396	3.0411	3.0329	3.0354	1690024.0
2007-01-05 16:30:00	AAPL	Stock	3.0371	3.0371	3.0336	3.0368	229460.0
2007-01-05 17:00:00	AAPL	Stock	3.0368	3.0382	3.0357	3.0375	229628.0
2007-01-05 17:30:00	AAPL	Stock	3.0364	3.0386	3.0364	3.0386	150640.0
2007-01-05 18:00:00	AAPL	Stock	3.0386	3.0386	3.0339	3.0357	232008.0
2007-01-05 18:30:00	AAPL	Stock	3.0357	3.0357	3.035	3.035	70336.0
2007-01-05 19:00:00	AAPL	Stock	3.035	3.0354	3.035	3.0354	43400.0
2007-01-05 19:30:00	AAPL	Stock	3.0354	3.0354	3.0329	3.0329	134904.0
2007-01-05 08:00:00	MSFT	Stock	29.79	29.79	29.6	29.6	9272.0
2007-01-05 08:30:00	MSFT	Stock	29.64	29.71	29.59	29.71	19988.0
2007-01-05 09:00:00	MSFT	Stock	29.66	29.75	29.55	29.63	316942.0
2007-01-05 09:30:00	MSFT	Stock	29.63	29.72	29.57	29.61	8466838.0
2007-01-05 10:00:00	MSFT	Stock	29.61	29.75	29.6	29.66	3170655.0
2007-01-05 10:30:00	MSFT	Stock	29.66	29.71	29.58	29.65	2235237.0
2007-01-05 11:00:00	MSFT	Stock	29.65	29.7	29.48	29.49	3909214.0
2007-01-05 11:30:00	MSFT	Stock	29.49	29.57	29.45	29.53	2017885.0
2007-01-05 12:00:00	MSFT	Stock	29.52	29.66	29.52	29.62	1805380.0
2007-01-05 12:30:00	MSFT	Stock	29.611	29.74	29.6	29.62	2205932.0
2007-01-05 13:00:00	MSFT	Stock	29.62	29.71	29.56	29.65	2330785.0
2007-01-05 13:30:00	MSFT	Stock	29.64	29.7	29.57	29.62	1872843.0
2007-01-05 14:00:00	MSFT	Stock	29.63	29.67	29.56	29.6	3314118.0
2007-01-05 14:30:00	MSFT	Stock	29.61	29.68	29.58	29.58	2342908.0
2007-01-05 15:00:00	MSFT	Stock	29.59	29.65	29.54	29.62	3144013.0
2007-01-05 15:30:00	MSFT	Stock	29.63	29.66	29.6	29.64	4535958.0
2007-01-05 16:00:00	MSFT	Stock	29.64	29.68	29.51	29.51	79075.0
2007-01-05 16:30:00	MSFT	Stock	29.63	29.65	29.63	29.64	3772.0
2007-01-05 17:30:00	MSFT	Stock	29.64	29.64	29.63	29.63	5015.0
2007-01-05 18:00:00	MSFT	Stock	29.64	29.64	29.64	29.64	385.0
2007-01-05 18:30:00	MSFT	Stock	29.67	29.69	29.64	29.64	5141.0
2007-01-05 19:30:00	MSFT	Stock	29.63	29.69	29.63	29.69	2159.0

> showing 50 of 53,489 rows — these rows as CSV

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