PREVIEW / stock_30min / 2006-01-23

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-01-23.parquet
  size:    872 KB
  rows:    47,326
  symbols: 2,171

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-01-23 04:00:00	AAPL	Stock	2.6982	2.6982	2.6982	2.6982	5600.0
2006-01-23 04:30:00	AAPL	Stock	2.7	2.7	2.6964	2.6964	30800.0
2006-01-23 05:00:00	AAPL	Stock	2.7089	2.7089	2.7089	2.7089	14000.0
2006-01-23 05:30:00	AAPL	Stock	2.6964	2.6964	2.6964	2.6964	11200.0
2006-01-23 06:30:00	AAPL	Stock	2.7125	2.7125	2.7125	2.7125	4620.0
2006-01-23 07:00:00	AAPL	Stock	2.7161	2.7161	2.7143	2.7143	84000.0
2006-01-23 07:30:00	AAPL	Stock	2.7161	2.7179	2.7143	2.7179	126000.0
2006-01-23 08:00:00	AAPL	Stock	2.7179	2.7357	2.7146	2.7307	1431444.0
2006-01-23 08:30:00	AAPL	Stock	2.7307	2.7314	2.7179	2.7286	2904468.0
2006-01-23 09:00:00	AAPL	Stock	2.7286	2.7314	2.7179	2.7186	7822556.0
2006-01-23 09:30:00	AAPL	Stock	2.7179	2.7325	2.7161	2.7196	121504264.0
2006-01-23 10:00:00	AAPL	Stock	2.7196	2.7611	2.7143	2.7532	106093204.0
2006-01-23 10:30:00	AAPL	Stock	2.7532	2.7732	2.7375	2.7721	77144984.0
2006-01-23 11:00:00	AAPL	Stock	2.7721	2.8	2.7654	2.7986	86635836.0
2006-01-23 11:30:00	AAPL	Stock	2.7986	2.8414	2.795	2.8246	119443996.0
2006-01-23 12:00:00	AAPL	Stock	2.8246	2.8268	2.8021	2.8083	72744028.0
2006-01-23 12:30:00	AAPL	Stock	2.8086	2.8193	2.7339	2.7993	54839764.0
2006-01-23 13:00:00	AAPL	Stock	2.7993	2.8193	2.7964	2.8146	37797620.0
2006-01-23 13:30:00	AAPL	Stock	2.8143	2.825	2.7829	2.7854	66806432.0
2006-01-23 14:00:00	AAPL	Stock	2.7857	2.7971	2.7646	2.775	67925116.0
2006-01-23 14:30:00	AAPL	Stock	2.7754	2.7832	2.7611	2.7832	67774868.0
2006-01-23 15:00:00	AAPL	Stock	2.7832	2.7875	2.7686	2.7821	64967952.0
2006-01-23 15:30:00	AAPL	Stock	2.7821	2.8	2.77	2.7718	89758956.0
2006-01-23 16:00:00	AAPL	Stock	2.7736	2.7807	2.7686	2.7711	1384488.0
2006-01-23 16:30:00	AAPL	Stock	2.7696	2.7696	2.7586	2.7643	471548.0
2006-01-23 17:00:00	AAPL	Stock	2.7657	2.7739	2.7643	2.765	3003784.0
2006-01-23 17:30:00	AAPL	Stock	2.7661	2.7696	2.7643	2.7689	92568.0
2006-01-23 18:00:00	AAPL	Stock	2.7689	2.7696	2.7661	2.7679	38472.0
2006-01-23 06:30:00	MSFT	Stock	26.45	26.45	26.45	26.45	100.0
2006-01-23 08:00:00	MSFT	Stock	26.47	26.5	26.45	26.48	4600.0
2006-01-23 08:30:00	MSFT	Stock	26.53	26.53	26.4	26.52	11029.0
2006-01-23 09:00:00	MSFT	Stock	26.52	26.53	26.4	26.41	167151.0
2006-01-23 09:30:00	MSFT	Stock	26.41	26.53	26.39	26.39	5937935.0
2006-01-23 10:00:00	MSFT	Stock	26.39	26.43	26.32	26.42	5192461.0
2006-01-23 10:30:00	MSFT	Stock	26.43	26.44	26.33	26.41	3791997.0
2006-01-23 11:00:00	MSFT	Stock	26.419	26.45	26.35	26.42	2134980.0
2006-01-23 11:30:00	MSFT	Stock	26.42	26.49	26.39	26.4	2257836.0
2006-01-23 12:00:00	MSFT	Stock	26.4	26.41	26.32	26.33	2898879.0
2006-01-23 12:30:00	MSFT	Stock	26.33	26.38	26.3	26.33	2420370.0
2006-01-23 13:00:00	MSFT	Stock	26.34	26.4	26.32	26.38	2416835.0
2006-01-23 13:30:00	MSFT	Stock	26.382	26.42	26.33	26.37	3206876.0
2006-01-23 14:00:00	MSFT	Stock	26.37	26.42	26.34	26.36	2625364.0
2006-01-23 14:30:00	MSFT	Stock	26.36	26.4	26.3	26.34	2696716.0
2006-01-23 15:00:00	MSFT	Stock	26.34	26.39	26.32	26.36	3303685.0
2006-01-23 15:30:00	MSFT	Stock	26.35	26.432	26.33	26.39	5959034.0
2006-01-23 16:00:00	MSFT	Stock	26.38	26.4	26.3	26.36	397890.0
2006-01-23 16:30:00	MSFT	Stock	26.37	26.39	26.36	26.36	12538.0
2006-01-23 17:00:00	MSFT	Stock	26.35	26.35	26.35	26.35	293400.0
2006-01-23 18:00:00	MSFT	Stock	26.35	26.35	26.35	26.35	46000.0
2006-01-23 08:30:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	120000.0

> showing 50 of 47,326 rows — these rows as CSV

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