PREVIEW / stock_30min / 2006-07-17

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-07-17.parquet
  size:    892 KB
  rows:    48,673
  symbols: 2,317

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
2006-07-17 04:30:00	AAPL	Stock	1.825	1.825	1.8107	1.8214	227108.0
2006-07-17 05:30:00	AAPL	Stock	1.8282	1.8282	1.8282	1.8282	28000.0
2006-07-17 06:30:00	AAPL	Stock	1.8214	1.8375	1.8214	1.8375	11200.0
2006-07-17 07:00:00	AAPL	Stock	1.8357	1.8357	1.8357	1.8357	2800.0
2006-07-17 07:30:00	AAPL	Stock	1.8339	1.8482	1.8339	1.8446	362936.0
2006-07-17 08:00:00	AAPL	Stock	1.8393	1.8621	1.83	1.8571	6611948.0
2006-07-17 08:30:00	AAPL	Stock	1.8575	1.8579	1.8446	1.8475	5055176.0
2006-07-17 09:00:00	AAPL	Stock	1.8471	1.8475	1.8357	1.8475	6672148.0
2006-07-17 09:30:00	AAPL	Stock	1.8475	1.8732	1.8446	1.8493	177821084.0
2006-07-17 10:00:00	AAPL	Stock	1.8493	1.8661	1.8482	1.8568	105947296.0
2006-07-17 10:30:00	AAPL	Stock	1.8564	1.8714	1.8471	1.8714	102350248.0
2006-07-17 11:00:00	AAPL	Stock	1.8714	1.8914	1.8643	1.89	122902640.0
2006-07-17 11:30:00	AAPL	Stock	1.89	1.8957	1.8843	1.8889	76677552.0
2006-07-17 12:00:00	AAPL	Stock	1.8889	1.8893	1.8804	1.8871	43462188.0
2006-07-17 12:30:00	AAPL	Stock	1.8871	1.8904	1.8793	1.8807	34317164.0
2006-07-17 13:00:00	AAPL	Stock	1.8807	1.8875	1.8761	1.8843	41484100.0
2006-07-17 13:30:00	AAPL	Stock	1.8839	1.8911	1.8804	1.8886	27715800.0
2006-07-17 14:00:00	AAPL	Stock	1.8886	1.8968	1.8886	1.8921	52118864.0
2006-07-17 14:30:00	AAPL	Stock	1.8925	1.8957	1.8825	1.8868	44051756.0
2006-07-17 15:00:00	AAPL	Stock	1.8864	1.8868	1.8657	1.8711	88177544.0
2006-07-17 15:30:00	AAPL	Stock	1.8707	1.8882	1.8661	1.8671	81180792.0
2006-07-17 16:00:00	AAPL	Stock	1.8675	1.8729	1.8661	1.8729	1371804.0
2006-07-17 16:30:00	AAPL	Stock	1.8714	1.8714	1.8696	1.8696	124432.0
2006-07-17 17:00:00	AAPL	Stock	1.8714	1.8757	1.8714	1.8721	206080.0
2006-07-17 17:30:00	AAPL	Stock	1.8743	1.875	1.8721	1.8746	151760.0
2006-07-17 18:00:00	AAPL	Stock	1.8736	1.8746	1.8714	1.8746	30100.0
2006-07-17 04:30:00	MSFT	Stock	22.2	22.2	22.2	22.2	100.0
2006-07-17 08:00:00	MSFT	Stock	22.25	22.25	22.19	22.22	20400.0
2006-07-17 08:30:00	MSFT	Stock	22.25	22.25	22.21	22.23	8800.0
2006-07-17 09:00:00	MSFT	Stock	22.22	22.29	22.22	22.28	57085.0
2006-07-17 09:30:00	MSFT	Stock	22.29	22.48	22.26	22.41	5459467.0
2006-07-17 10:00:00	MSFT	Stock	22.4	22.48	22.35	22.423	3882903.0
2006-07-17 10:30:00	MSFT	Stock	22.42	22.54	22.37	22.52	3093105.0
2006-07-17 11:00:00	MSFT	Stock	22.53	22.61	22.51	22.53	3612287.0
2006-07-17 11:30:00	MSFT	Stock	22.522	22.56	22.47	22.48	1979230.0
2006-07-17 12:00:00	MSFT	Stock	22.48	22.49	22.43	22.46	1499590.0
2006-07-17 12:30:00	MSFT	Stock	22.46	22.5	22.44	22.45	1586191.0
2006-07-17 13:00:00	MSFT	Stock	22.46	22.51	22.43	22.49	1993654.0
2006-07-17 13:30:00	MSFT	Stock	22.5	22.52	22.48	22.52	880553.0
2006-07-17 14:00:00	MSFT	Stock	22.52	22.54	22.45	22.47	1910764.0
2006-07-17 14:30:00	MSFT	Stock	22.46	22.49	22.44	22.46	1438197.0
2006-07-17 15:00:00	MSFT	Stock	22.45	22.47	22.42	22.45	3066577.0
2006-07-17 15:30:00	MSFT	Stock	22.45	22.5	22.42	22.43	5006362.0
2006-07-17 16:00:00	MSFT	Stock	22.43	22.67	22.43	22.47	156973.0
2006-07-17 16:30:00	MSFT	Stock	22.47	22.58	22.46	22.46	624500.0
2006-07-17 17:00:00	MSFT	Stock	22.5	22.5	22.5	22.5	100.0
2006-07-17 17:30:00	MSFT	Stock	22.5	22.55	22.5	22.55	1000.0
2006-07-17 18:00:00	MSFT	Stock	22.5	22.54	22.5	22.54	229.0
2006-07-17 08:00:00	NVDA	Stock	0.2967	0.2967	0.2933	0.2933	22200.0
2006-07-17 09:00:00	NVDA	Stock	0.2952	0.2952	0.2923	0.2933	178200.0

> showing 50 of 48,673 rows — these rows as CSV

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