PREVIEW / stock_30min / 2005-07-28

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-07-28.parquet
  size:    852 KB
  rows:    46,193
  symbols: 2,052

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
2005-07-28 08:00:00	AAPL	Stock	1.5714	1.5804	1.5714	1.5786	264124.0
2005-07-28 08:30:00	AAPL	Stock	1.5736	1.575	1.5736	1.5736	107380.0
2005-07-28 09:00:00	AAPL	Stock	1.5739	1.5739	1.5668	1.5668	348964.0
2005-07-28 09:30:00	AAPL	Stock	1.5661	1.5714	1.5496	1.5568	46118856.0
2005-07-28 10:00:00	AAPL	Stock	1.5568	1.5589	1.5464	1.55	39901848.0
2005-07-28 10:30:00	AAPL	Stock	1.5504	1.555	1.5471	1.5536	17019688.0
2005-07-28 11:00:00	AAPL	Stock	1.5536	1.56	1.5521	1.5561	13979560.0
2005-07-28 11:30:00	AAPL	Stock	1.5561	1.5679	1.5546	1.5643	21417452.0
2005-07-28 12:00:00	AAPL	Stock	1.5643	1.5664	1.5571	1.5607	10901072.0
2005-07-28 12:30:00	AAPL	Stock	1.5604	1.5639	1.56	1.5625	8431864.0
2005-07-28 13:00:00	AAPL	Stock	1.5625	1.5629	1.5582	1.5614	10414432.0
2005-07-28 13:30:00	AAPL	Stock	1.5614	1.5629	1.5582	1.56	9108904.0
2005-07-28 14:00:00	AAPL	Stock	1.5596	1.5654	1.5575	1.5582	10613960.0
2005-07-28 14:30:00	AAPL	Stock	1.5586	1.5604	1.5571	1.5596	8569988.0
2005-07-28 15:00:00	AAPL	Stock	1.5593	1.5636	1.5568	1.5632	17068744.0
2005-07-28 15:30:00	AAPL	Stock	1.5632	1.5671	1.5607	1.5621	26675936.0
2005-07-28 16:00:00	AAPL	Stock	1.5636	1.5671	1.55	1.5586	4027352.0
2005-07-28 16:30:00	AAPL	Stock	1.5604	1.5643	1.5571	1.5571	592704.0
2005-07-28 17:00:00	AAPL	Stock	1.5571	1.5589	1.5571	1.5589	23128.0
2005-07-28 17:30:00	AAPL	Stock	1.5571	1.5589	1.5571	1.5571	70000.0
2005-07-28 18:00:00	AAPL	Stock	1.5571	1.5571	1.5571	1.5571	48020.0
2005-07-28 08:00:00	MSFT	Stock	25.71	25.74	25.71	25.74	382135.0
2005-07-28 08:30:00	MSFT	Stock	25.72	25.77	25.72	25.75	40710.0
2005-07-28 09:00:00	MSFT	Stock	25.75	25.77	25.72	25.74	54975.0
2005-07-28 09:30:00	MSFT	Stock	25.75	25.79	25.69	25.77	4577287.0
2005-07-28 10:00:00	MSFT	Stock	25.76	25.78	25.69	25.7	3315358.0
2005-07-28 10:30:00	MSFT	Stock	25.693	25.78	25.66	25.769	3525150.0
2005-07-28 11:00:00	MSFT	Stock	25.77	25.81	25.75	25.789	2902661.0
2005-07-28 11:30:00	MSFT	Stock	25.78	25.85	25.77	25.81	6159847.0
2005-07-28 12:00:00	MSFT	Stock	25.8	25.82	25.7	25.77	3477495.0
2005-07-28 12:30:00	MSFT	Stock	25.77	25.78	25.75	25.76	1766592.0
2005-07-28 13:00:00	MSFT	Stock	25.76	25.79	25.75	25.77	1829850.0
2005-07-28 13:30:00	MSFT	Stock	25.77	25.82	25.76	25.78	2388826.0
2005-07-28 14:00:00	MSFT	Stock	25.78	25.79	25.75	25.76	2204305.0
2005-07-28 14:30:00	MSFT	Stock	25.77	25.78	25.75	25.76	1464198.0
2005-07-28 15:00:00	MSFT	Stock	25.77	25.77	25.71	25.75	3868803.0
2005-07-28 15:30:00	MSFT	Stock	25.75	25.77	25.72	25.76	4878352.0
2005-07-28 16:00:00	MSFT	Stock	25.76	25.8	25.745	25.78	254285.0
2005-07-28 16:30:00	MSFT	Stock	25.78	25.8	25.75	25.78	69563.0
2005-07-28 17:00:00	MSFT	Stock	25.77	25.8	25.76	25.76	20655.0
2005-07-28 17:30:00	MSFT	Stock	25.77	25.8	25.77	25.79	28295.0
2005-07-28 18:00:00	MSFT	Stock	25.79	25.8	25.79	25.79	8725.0
2005-07-28 08:00:00	NVDA	Stock	0.2275	0.2283	0.2242	0.2255	583200.0
2005-07-28 09:00:00	NVDA	Stock	0.2265	0.2265	0.2252	0.2252	72000.0
2005-07-28 09:30:00	NVDA	Stock	0.2251	0.227	0.225	0.2263	53519160.0
2005-07-28 10:00:00	NVDA	Stock	0.2262	0.2263	0.222	0.2229	47660760.0
2005-07-28 10:30:00	NVDA	Stock	0.2229	0.2238	0.2227	0.2235	15946200.0
2005-07-28 11:00:00	NVDA	Stock	0.2234	0.2248	0.2232	0.2247	19926600.0
2005-07-28 11:30:00	NVDA	Stock	0.2246	0.2267	0.2244	0.2261	29184000.0
2005-07-28 12:00:00	NVDA	Stock	0.2261	0.2266	0.2256	0.2258	10853760.0

> showing 50 of 46,193 rows — these rows as CSV

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