PREVIEW / stock_30min / 2009-09-01

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-09-01.parquet
  size:    1.4 MB
  rows:    74,731
  symbols: 3,378

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
2009-09-01 04:30:00	AAPL	Stock	6.0282	6.0282	6.0282	6.0282	2800.0
2009-09-01 05:00:00	AAPL	Stock	5.9489	5.9489	5.9489	5.9489	2800.0
2009-09-01 06:00:00	AAPL	Stock	5.9143	5.9357	5.9143	5.9304	22400.0
2009-09-01 06:30:00	AAPL	Stock	5.9321	5.9321	5.9286	5.9286	11200.0
2009-09-01 07:00:00	AAPL	Stock	5.9621	5.9821	5.9571	5.9821	75740.0
2009-09-01 07:30:00	AAPL	Stock	5.9786	6.0	5.9725	5.9725	85456.0
2009-09-01 08:00:00	AAPL	Stock	5.9871	6.0214	5.9786	6.0036	1195936.0
2009-09-01 08:30:00	AAPL	Stock	6.0061	6.0196	6.0004	6.0139	634116.0
2009-09-01 09:00:00	AAPL	Stock	6.0107	6.0107	5.9857	6.0057	520940.0
2009-09-01 09:30:00	AAPL	Stock	5.9996	6.0689	5.9975	6.06	44532712.0
2009-09-01 10:00:00	AAPL	Stock	6.0593	6.0714	6.0432	6.0632	40217380.0
2009-09-01 10:30:00	AAPL	Stock	6.0632	6.0689	6.0221	6.0222	28468748.0
2009-09-01 11:00:00	AAPL	Stock	6.0225	6.0239	5.9536	5.9579	55694828.0
2009-09-01 11:30:00	AAPL	Stock	5.9571	5.972	5.9343	5.9411	40348168.0
2009-09-01 12:00:00	AAPL	Stock	5.9414	5.9554	5.9339	5.9478	22451912.0
2009-09-01 12:30:00	AAPL	Stock	5.9471	5.9625	5.9204	5.9207	27679484.0
2009-09-01 13:00:00	AAPL	Stock	5.9221	5.93	5.8907	5.9175	35371028.0
2009-09-01 13:30:00	AAPL	Stock	5.9173	5.9268	5.9068	5.9261	24844876.0
2009-09-01 14:00:00	AAPL	Stock	5.9271	5.9461	5.9239	5.9407	24068128.0
2009-09-01 14:30:00	AAPL	Stock	5.9407	5.9554	5.9286	5.9329	21857052.0
2009-09-01 15:00:00	AAPL	Stock	5.9336	5.9443	5.9221	5.9221	21925008.0
2009-09-01 15:30:00	AAPL	Stock	5.9225	5.93	5.8946	5.9036	54897024.0
2009-09-01 16:00:00	AAPL	Stock	5.9039	5.9733	5.9	5.9018	7596876.0
2009-09-01 16:30:00	AAPL	Stock	5.9036	5.9071	5.8996	5.8996	5670224.0
2009-09-01 17:00:00	AAPL	Stock	5.9018	5.9036	5.8964	5.8993	283164.0
2009-09-01 17:30:00	AAPL	Stock	5.8993	5.8993	5.8957	5.8982	100016.0
2009-09-01 18:00:00	AAPL	Stock	5.8964	5.9036	5.8964	5.9018	242340.0
2009-09-01 18:30:00	AAPL	Stock	5.9	5.9011	5.8993	5.9	83524.0
2009-09-01 19:00:00	AAPL	Stock	5.8968	5.8982	5.8964	5.8964	54432.0
2009-09-01 19:30:00	AAPL	Stock	5.8954	5.9107	5.895	5.9071	193396.0
2009-09-01 06:00:00	MSFT	Stock	24.43	24.43	24.43	24.43	200.0
2009-09-01 07:30:00	MSFT	Stock	24.45	24.45	24.45	24.45	900.0
2009-09-01 08:00:00	MSFT	Stock	24.57	24.65	24.5	24.6	90529.0
2009-09-01 08:30:00	MSFT	Stock	24.58	24.6	24.55	24.57	3984.0
2009-09-01 09:00:00	MSFT	Stock	24.55	24.65	24.34	24.35	110964.0
2009-09-01 09:30:00	MSFT	Stock	24.35	24.74	24.34	24.59	4581733.0
2009-09-01 10:00:00	MSFT	Stock	24.59	24.73	24.53	24.592	4595176.0
2009-09-01 10:30:00	MSFT	Stock	24.592	24.6	24.46	24.46	3126036.0
2009-09-01 11:00:00	MSFT	Stock	24.46	24.49	24.14	24.16	6168771.0
2009-09-01 11:30:00	MSFT	Stock	24.16	24.26	24.04	24.06	6936898.0
2009-09-01 12:00:00	MSFT	Stock	24.07	24.1	23.96	23.962	3783028.0
2009-09-01 12:30:00	MSFT	Stock	23.97	24.01	23.95	23.96	3006376.0
2009-09-01 13:00:00	MSFT	Stock	23.97	24.014	23.9	23.942	2970327.0
2009-09-01 13:30:00	MSFT	Stock	23.95	24.06	23.9	24.02	3159778.0
2009-09-01 14:00:00	MSFT	Stock	24.02	24.06	23.93	23.97	2628968.0
2009-09-01 14:30:00	MSFT	Stock	23.98	24.055	23.95	23.98	2748475.0
2009-09-01 15:00:00	MSFT	Stock	23.99	24.07	23.97	24.0	3204836.0
2009-09-01 15:30:00	MSFT	Stock	24.0	24.13	23.97	23.98	8728310.0
2009-09-01 16:00:00	MSFT	Stock	23.98	24.22	23.96	23.98	3567777.0
2009-09-01 16:30:00	MSFT	Stock	23.98	24.0	23.98	23.99	984465.0

> showing 50 of 74,731 rows — these rows as CSV

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