PREVIEW / stock_30min / 2007-02-01

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-01.parquet
  size:    993 KB
  rows:    53,821
  symbols: 2,504

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-02-01 06:00:00	AAPL	Stock	3.0679	3.0679	3.0679	3.0679	2800.0
2007-02-01 07:00:00	AAPL	Stock	3.0836	3.0836	3.0732	3.0732	44800.0
2007-02-01 07:30:00	AAPL	Stock	3.0714	3.0718	3.0679	3.0714	58800.0
2007-02-01 08:00:00	AAPL	Stock	3.0796	3.0796	3.0618	3.0714	808164.0
2007-02-01 08:30:00	AAPL	Stock	3.0714	3.0771	3.0618	3.0771	1615796.0
2007-02-01 09:00:00	AAPL	Stock	3.0768	3.0796	3.0714	3.0796	1861720.0
2007-02-01 09:30:00	AAPL	Stock	3.0793	3.0811	3.0614	3.0704	114238796.0
2007-02-01 10:00:00	AAPL	Stock	3.0704	3.0714	3.0507	3.056	81872644.0
2007-02-01 10:30:00	AAPL	Stock	3.0561	3.0679	3.0539	3.0554	43469356.0
2007-02-01 11:00:00	AAPL	Stock	3.0546	3.0561	3.0289	3.0421	78623076.0
2007-02-01 11:30:00	AAPL	Stock	3.0418	3.0489	3.0361	3.0457	37455628.0
2007-02-01 12:00:00	AAPL	Stock	3.0457	3.0471	3.0379	3.0382	22138564.0
2007-02-01 12:30:00	AAPL	Stock	3.0379	3.0418	3.0332	3.035	21349916.0
2007-02-01 13:00:00	AAPL	Stock	3.0353	3.0407	3.0268	3.0393	40583284.0
2007-02-01 13:30:00	AAPL	Stock	3.0393	3.0471	3.0361	3.0414	31544604.0
2007-02-01 14:00:00	AAPL	Stock	3.0418	3.0457	3.0379	3.0432	24751636.0
2007-02-01 14:30:00	AAPL	Stock	3.0432	3.0475	3.0321	3.0389	36988336.0
2007-02-01 15:00:00	AAPL	Stock	3.0389	3.0468	3.0357	3.0389	43219232.0
2007-02-01 15:30:00	AAPL	Stock	3.0386	3.0429	3.0264	3.0264	68779396.0
2007-02-01 16:00:00	AAPL	Stock	3.0261	3.0311	3.0243	3.0264	2839704.0
2007-02-01 16:30:00	AAPL	Stock	3.0268	3.0293	3.0265	3.0293	1146096.0
2007-02-01 17:00:00	AAPL	Stock	3.0293	3.0307	3.0286	3.0286	195216.0
2007-02-01 17:30:00	AAPL	Stock	3.0289	3.0304	3.0268	3.0268	140308.0
2007-02-01 18:00:00	AAPL	Stock	3.0268	3.03	3.0268	3.03	115276.0
2007-02-01 18:30:00	AAPL	Stock	3.03	3.0307	3.0286	3.0307	142968.0
2007-02-01 19:00:00	AAPL	Stock	3.0286	3.0314	3.0264	3.0314	268296.0
2007-02-01 19:30:00	AAPL	Stock	3.0314	3.0314	3.0307	3.0314	155568.0
2007-02-01 08:00:00	MSFT	Stock	30.84	30.84	30.79	30.79	750.0
2007-02-01 08:30:00	MSFT	Stock	30.84	30.85	30.81	30.85	26610.0
2007-02-01 09:00:00	MSFT	Stock	30.86	30.94	30.83	30.83	206798.0
2007-02-01 09:30:00	MSFT	Stock	30.84	30.94	30.74	30.82	7446159.0
2007-02-01 10:00:00	MSFT	Stock	30.82	30.82	30.61	30.64	5219066.0
2007-02-01 10:30:00	MSFT	Stock	30.64	30.7	30.61	30.63	2863791.0
2007-02-01 11:00:00	MSFT	Stock	30.63	30.836	30.38	30.46	5242673.0
2007-02-01 11:30:00	MSFT	Stock	30.46	30.54	30.43	30.51	3015498.0
2007-02-01 12:00:00	MSFT	Stock	30.51	30.836	30.49	30.51	2217207.0
2007-02-01 12:30:00	MSFT	Stock	30.52	30.52	30.45	30.46	1187026.0
2007-02-01 13:00:00	MSFT	Stock	30.47	30.47	30.42	30.46	1347651.0
2007-02-01 13:30:00	MSFT	Stock	30.46	30.64	30.41	30.45	2778393.0
2007-02-01 14:00:00	MSFT	Stock	30.449	30.48	30.37	30.43	2275811.0
2007-02-01 14:30:00	MSFT	Stock	30.42	30.47	30.39	30.44	2637267.0
2007-02-01 15:00:00	MSFT	Stock	30.43	30.5	30.38	30.43	4299659.0
2007-02-01 15:30:00	MSFT	Stock	30.43	30.6	30.423	30.55	9686376.0
2007-02-01 16:00:00	MSFT	Stock	30.56	30.56	30.44	30.52	226295.0
2007-02-01 16:30:00	MSFT	Stock	30.53	30.563	30.52	30.55	81254.0
2007-02-01 17:00:00	MSFT	Stock	30.56	30.56	30.56	30.56	1308.0
2007-02-01 17:30:00	MSFT	Stock	30.51	30.51	30.51	30.51	100.0
2007-02-01 18:00:00	MSFT	Stock	30.56	30.57	30.56	30.57	1983.0
2007-02-01 18:30:00	MSFT	Stock	30.53	30.57	30.53	30.57	4500.0
2007-02-01 19:00:00	MSFT	Stock	30.559	30.559	30.559	30.559	4681.0

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

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