PREVIEW / stock_30min / 2007-07-25

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-25.parquet
  size:    1.2 MB
  rows:    64,822
  symbols: 3,090

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
2007-07-25 09:30:00	AAPL	Stock	4.9054	4.9084	4.8214	4.8746	185702188.0
2007-07-25 10:00:00	AAPL	Stock	4.8746	4.9196	4.8621	4.8929	114498104.0
2007-07-25 10:30:00	AAPL	Stock	4.8923	4.8982	4.8571	4.8746	81922484.0
2007-07-25 11:00:00	AAPL	Stock	4.8736	4.8836	4.86	4.8721	59515736.0
2007-07-25 11:30:00	AAPL	Stock	4.8721	4.8807	4.8643	4.8725	52957576.0
2007-07-25 12:00:00	AAPL	Stock	4.8725	4.9171	4.8714	4.9132	53398968.0
2007-07-25 12:30:00	AAPL	Stock	4.9129	4.925	4.89	4.9021	51402708.0
2007-07-25 13:00:00	AAPL	Stock	4.9021	4.9082	4.8675	4.8829	47417412.0
2007-07-25 13:30:00	AAPL	Stock	4.8821	4.8904	4.8714	4.8718	45190992.0
2007-07-25 14:00:00	AAPL	Stock	4.8714	4.8836	4.8604	4.8825	59096800.0
2007-07-25 14:30:00	AAPL	Stock	4.8821	4.9214	4.8782	4.8996	65764356.0
2007-07-25 15:00:00	AAPL	Stock	4.8993	4.9414	4.8986	4.9346	97912948.0
2007-07-25 15:30:00	AAPL	Stock	4.935	4.9354	4.8839	4.9011	143796044.0
2007-07-25 16:00:00	AAPL	Stock	4.8971	4.9021	4.8936	4.9021	7030996.0
2007-07-25 09:30:00	MSFT	Stock	30.99	31.3	30.85	30.89	3898059.0
2007-07-25 10:00:00	MSFT	Stock	30.88	30.88	30.59	30.6	4549240.0
2007-07-25 10:30:00	MSFT	Stock	30.59	30.71	30.51	30.7	5656725.0
2007-07-25 11:00:00	MSFT	Stock	30.7	30.78	30.59	30.77	4080669.0
2007-07-25 11:30:00	MSFT	Stock	30.76	30.8	30.68	30.73	2213974.0
2007-07-25 12:00:00	MSFT	Stock	30.73	30.76	30.66	30.735	2054777.0
2007-07-25 12:30:00	MSFT	Stock	30.73	30.74	30.55	30.61	2353927.0
2007-07-25 13:00:00	MSFT	Stock	30.61	30.67	30.56	30.56	3020347.0
2007-07-25 13:30:00	MSFT	Stock	30.57	30.61	30.43	30.45	4630632.0
2007-07-25 14:00:00	MSFT	Stock	30.458	30.641	30.37	30.6	5132013.0
2007-07-25 14:30:00	MSFT	Stock	30.6	30.6	30.43	30.461	3514809.0
2007-07-25 15:00:00	MSFT	Stock	30.46	30.76	30.46	30.73	4426792.0
2007-07-25 15:30:00	MSFT	Stock	30.73	30.74	30.58	30.69	5172628.0
2007-07-25 16:00:00	MSFT	Stock	30.69	30.71	30.69	30.71	1264578.0
2007-07-25 08:30:00	NVDA	Stock	0.7433	0.744	0.7433	0.744	137760.0
2007-07-25 09:00:00	NVDA	Stock	0.744	0.7465	0.7417	0.7417	78120.0
2007-07-25 09:30:00	NVDA	Stock	0.7393	0.7498	0.7393	0.7468	29415240.0
2007-07-25 10:00:00	NVDA	Stock	0.7465	0.7475	0.7238	0.7302	56150280.0
2007-07-25 10:30:00	NVDA	Stock	0.7303	0.7327	0.7187	0.7293	79286400.0
2007-07-25 11:00:00	NVDA	Stock	0.7292	0.7352	0.7273	0.7342	32836680.0
2007-07-25 11:30:00	NVDA	Stock	0.7338	0.7358	0.7312	0.732	13762560.0
2007-07-25 12:00:00	NVDA	Stock	0.7318	0.7345	0.729	0.7345	14234040.0
2007-07-25 12:30:00	NVDA	Stock	0.7342	0.7365	0.7328	0.7358	20208180.0
2007-07-25 13:00:00	NVDA	Stock	0.736	0.7365	0.7333	0.7357	23343480.0
2007-07-25 13:30:00	NVDA	Stock	0.7355	0.7357	0.7268	0.727	32114460.0
2007-07-25 14:00:00	NVDA	Stock	0.727	0.733	0.7263	0.7312	31666920.0
2007-07-25 14:30:00	NVDA	Stock	0.7312	0.7313	0.7278	0.7312	15545280.0
2007-07-25 15:00:00	NVDA	Stock	0.731	0.7467	0.7307	0.7357	36807600.0
2007-07-25 15:30:00	NVDA	Stock	0.7358	0.7362	0.7323	0.735	35217180.0
2007-07-25 16:00:00	NVDA	Stock	0.7357	0.7357	0.7338	0.735	11329620.0
2007-07-25 16:30:00	NVDA	Stock	0.7338	0.7357	0.7338	0.7338	486360.0
2007-07-25 17:00:00	NVDA	Stock	0.7352	0.7352	0.7352	0.7352	54000.0
2007-07-25 17:30:00	NVDA	Stock	0.7352	0.7357	0.735	0.7357	160200.0
2007-07-25 18:00:00	NVDA	Stock	0.7357	0.7367	0.7357	0.7357	408000.0
2007-07-25 18:30:00	NVDA	Stock	0.7357	0.736	0.7357	0.736	40680.0
2007-07-25 19:00:00	NVDA	Stock	0.736	0.736	0.736	0.736	12840.0

> showing 50 of 64,822 rows — these rows as CSV

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