PREVIEW / stock_30min / 2007-10-05

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-05.parquet
  size:    1.2 MB
  rows:    67,258
  symbols: 3,141

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-10-05 06:00:00	AAPL	Stock	5.5893	5.5893	5.5893	5.5893	4200.0
2007-10-05 06:30:00	AAPL	Stock	5.5893	5.5893	5.5893	5.5893	15624.0
2007-10-05 07:00:00	AAPL	Stock	5.5814	5.5814	5.5714	5.5714	53200.0
2007-10-05 07:30:00	AAPL	Stock	5.5714	5.6014	5.5714	5.5929	171500.0
2007-10-05 08:00:00	AAPL	Stock	5.5893	5.6214	5.5893	5.61	2935520.0
2007-10-05 08:30:00	AAPL	Stock	5.61	5.6529	5.61	5.6321	9589300.0
2007-10-05 09:00:00	AAPL	Stock	5.6321	5.6725	5.6321	5.6607	5503204.0
2007-10-05 09:30:00	AAPL	Stock	5.6586	5.6889	5.6321	5.6571	131974024.0
2007-10-05 10:00:00	AAPL	Stock	5.6571	5.6832	5.6489	5.6504	61776932.0
2007-10-05 10:30:00	AAPL	Stock	5.6504	5.6864	5.6454	5.6854	56962220.0
2007-10-05 11:00:00	AAPL	Stock	5.6857	5.6968	5.6786	5.6839	73854200.0
2007-10-05 11:30:00	AAPL	Stock	5.6846	5.7064	5.6689	5.7043	65903768.0
2007-10-05 12:00:00	AAPL	Stock	5.7043	5.7139	5.7014	5.7036	45320632.0
2007-10-05 12:30:00	AAPL	Stock	5.7043	5.7136	5.6982	5.7075	27552252.0
2007-10-05 13:00:00	AAPL	Stock	5.7075	5.7079	5.6939	5.7075	37810332.0
2007-10-05 13:30:00	AAPL	Stock	5.7075	5.7211	5.7057	5.7161	72963184.0
2007-10-05 14:00:00	AAPL	Stock	5.7161	5.73	5.7071	5.7079	46957652.0
2007-10-05 14:30:00	AAPL	Stock	5.7075	5.7429	5.6964	5.7036	68531176.0
2007-10-05 15:00:00	AAPL	Stock	5.7036	5.7161	5.6929	5.715	55077904.0
2007-10-05 15:30:00	AAPL	Stock	5.7143	5.7704	5.7082	5.7696	142618392.0
2007-10-05 16:00:00	AAPL	Stock	5.7704	5.8054	5.6867	5.8036	24357228.0
2007-10-05 16:30:00	AAPL	Stock	5.8046	5.8271	5.7	5.8214	4895044.0
2007-10-05 17:00:00	AAPL	Stock	5.8214	5.8432	5.8214	5.8393	2403128.0
2007-10-05 17:30:00	AAPL	Stock	5.8393	5.8771	5.8393	5.8614	3501652.0
2007-10-05 18:00:00	AAPL	Stock	5.8607	5.8625	5.8289	5.8321	1259048.0
2007-10-05 18:30:00	AAPL	Stock	5.8307	5.8393	5.8286	5.8286	457128.0
2007-10-05 19:00:00	AAPL	Stock	5.8286	5.8304	5.8214	5.8239	576156.0
2007-10-05 19:30:00	AAPL	Stock	5.825	5.8393	5.8229	5.8357	452340.0
2007-10-05 08:00:00	MSFT	Stock	29.74	29.8	29.74	29.8	16808.0
2007-10-05 08:30:00	MSFT	Stock	29.75	29.93	29.75	29.88	83960.0
2007-10-05 09:00:00	MSFT	Stock	29.9	29.9	29.82	29.9	45600.0
2007-10-05 09:30:00	MSFT	Stock	29.9	29.9	29.73	29.78	4427190.0
2007-10-05 10:00:00	MSFT	Stock	29.79	29.88	29.75	29.84	3001687.0
2007-10-05 10:30:00	MSFT	Stock	29.85	29.89	29.82	29.86	2401687.0
2007-10-05 11:00:00	MSFT	Stock	29.86	29.99	29.86	29.91	6093160.0
2007-10-05 11:30:00	MSFT	Stock	29.91	29.99	29.91	29.969	2654777.0
2007-10-05 12:00:00	MSFT	Stock	29.97	29.98	29.91	29.94	1718793.0
2007-10-05 12:30:00	MSFT	Stock	29.94	29.95	29.92	29.92	1374874.0
2007-10-05 13:00:00	MSFT	Stock	29.921	29.96	29.87	29.89	1988109.0
2007-10-05 13:30:00	MSFT	Stock	29.881	29.96	29.88	29.88	3590681.0
2007-10-05 14:00:00	MSFT	Stock	29.88	29.91	29.87	29.88	2833198.0
2007-10-05 14:30:00	MSFT	Stock	29.88	29.93	29.85	29.92	2466701.0
2007-10-05 15:00:00	MSFT	Stock	29.93	29.95	29.87	29.9	3158824.0
2007-10-05 15:30:00	MSFT	Stock	29.9	29.92	29.82	29.87	6077008.0
2007-10-05 16:00:00	MSFT	Stock	29.87	29.93	29.84	29.84	2801678.0
2007-10-05 16:30:00	MSFT	Stock	29.84	29.97	29.84	29.86	284994.0
2007-10-05 17:00:00	MSFT	Stock	29.85	29.87	29.85	29.85	1700.0
2007-10-05 17:30:00	MSFT	Stock	29.85	29.85	29.85	29.85	100.0
2007-10-05 18:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	3302.0
2007-10-05 18:30:00	MSFT	Stock	29.87	29.87	29.87	29.87	200.0

> showing 50 of 67,258 rows — these rows as CSV

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