PREVIEW / stock_30min / 2006-02-24

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-02-24.parquet
  size:    882 KB
  rows:    47,400
  symbols: 2,187

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-02-24 04:00:00	AAPL	Stock	2.5457	2.5457	2.5457	2.5457	2800.0
2006-02-24 05:00:00	AAPL	Stock	2.5821	2.5821	2.5821	2.5821	8400.0
2006-02-24 06:30:00	AAPL	Stock	2.5893	2.5893	2.5893	2.5893	5600.0
2006-02-24 07:00:00	AAPL	Stock	2.5768	2.5768	2.5768	2.5768	2800.0
2006-02-24 07:30:00	AAPL	Stock	2.5804	2.5825	2.5796	2.5796	64400.0
2006-02-24 08:00:00	AAPL	Stock	2.5829	2.5843	2.5779	2.5843	1553328.0
2006-02-24 08:30:00	AAPL	Stock	2.5771	2.5829	2.5661	2.5696	1851808.0
2006-02-24 09:00:00	AAPL	Stock	2.5693	2.5789	2.5632	2.5771	1547308.0
2006-02-24 09:30:00	AAPL	Stock	2.5764	2.5857	2.5643	2.5807	79490740.0
2006-02-24 10:00:00	AAPL	Stock	2.5804	2.6032	2.5804	2.585	78000748.0
2006-02-24 10:30:00	AAPL	Stock	2.5846	2.5911	2.5732	2.5764	46111884.0
2006-02-24 11:00:00	AAPL	Stock	2.5764	2.5918	2.5764	2.5829	31611272.0
2006-02-24 11:30:00	AAPL	Stock	2.5829	2.5918	2.5789	2.5907	25586512.0
2006-02-24 12:00:00	AAPL	Stock	2.5907	2.5921	2.5843	2.5864	16161712.0
2006-02-24 12:30:00	AAPL	Stock	2.5864	2.5896	2.5766	2.5861	20333264.0
2006-02-24 13:00:00	AAPL	Stock	2.5868	2.5893	2.5768	2.5771	18688684.0
2006-02-24 13:30:00	AAPL	Stock	2.5771	2.5786	2.5607	2.5625	33352032.0
2006-02-24 14:00:00	AAPL	Stock	2.5625	2.5782	2.5611	2.5714	24785684.0
2006-02-24 14:30:00	AAPL	Stock	2.5711	2.5732	2.5607	2.5671	31374616.0
2006-02-24 15:00:00	AAPL	Stock	2.5661	2.5732	2.5607	2.5654	28345044.0
2006-02-24 15:30:00	AAPL	Stock	2.565	2.565	2.5429	2.5518	76153588.0
2006-02-24 16:00:00	AAPL	Stock	2.5514	2.5543	2.5461	2.5536	2430820.0
2006-02-24 16:30:00	AAPL	Stock	2.5539	2.5589	2.5539	2.5568	334796.0
2006-02-24 17:00:00	AAPL	Stock	2.5586	2.5607	2.5575	2.5575	392000.0
2006-02-24 17:30:00	AAPL	Stock	2.5604	2.5604	2.5554	2.56	91420.0
2006-02-24 18:00:00	AAPL	Stock	2.5589	2.5607	2.5571	2.5607	30800.0
2006-02-24 06:30:00	MSFT	Stock	26.67	26.67	26.67	26.67	300.0
2006-02-24 07:00:00	MSFT	Stock	26.67	26.67	26.62	26.62	2520.0
2006-02-24 07:30:00	MSFT	Stock	26.67	26.69	26.67	26.69	5600.0
2006-02-24 08:00:00	MSFT	Stock	26.66	26.66	26.65	26.65	9015.0
2006-02-24 08:30:00	MSFT	Stock	26.65	26.65	26.65	26.65	27895.0
2006-02-24 09:00:00	MSFT	Stock	26.65	26.66	26.57	26.58	93050.0
2006-02-24 09:30:00	MSFT	Stock	26.59	26.64	26.54	26.56	5126599.0
2006-02-24 10:00:00	MSFT	Stock	26.56	26.63	26.55	26.57	3039406.0
2006-02-24 10:30:00	MSFT	Stock	26.56	26.6	26.52	26.55	2373467.0
2006-02-24 11:00:00	MSFT	Stock	26.55	26.57	26.55	26.56	1334589.0
2006-02-24 11:30:00	MSFT	Stock	26.56	26.57	26.53	26.54	1492624.0
2006-02-24 12:00:00	MSFT	Stock	26.54	26.59	26.54	26.56	1007981.0
2006-02-24 12:30:00	MSFT	Stock	26.561	26.58	26.55	26.56	934044.0
2006-02-24 13:00:00	MSFT	Stock	26.56	26.63	26.54	26.62	5001294.0
2006-02-24 13:30:00	MSFT	Stock	26.62	26.65	26.59	26.62	5225574.0
2006-02-24 14:00:00	MSFT	Stock	26.62	26.66	26.61	26.66	3539761.0
2006-02-24 14:30:00	MSFT	Stock	26.66	26.73	26.63	26.72	4930304.0
2006-02-24 15:00:00	MSFT	Stock	26.72	26.74	26.64	26.65	2276994.0
2006-02-24 15:30:00	MSFT	Stock	26.65	26.68	26.58	26.67	5676710.0
2006-02-24 16:00:00	MSFT	Stock	26.67	26.68	26.63	26.67	226992.0
2006-02-24 16:30:00	MSFT	Stock	26.69	26.7	26.64	26.64	23613.0
2006-02-24 17:00:00	MSFT	Stock	26.67	26.67	26.67	26.67	450.0
2006-02-24 17:30:00	MSFT	Stock	26.64	26.64	26.64	26.64	700.0
2006-02-24 18:00:00	MSFT	Stock	26.64	26.64	26.63	26.63	1240.0

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

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