PREVIEW / stock_30min / 2007-07-18

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-18.parquet
  size:    1.1 MB
  rows:    63,943
  symbols: 3,064

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-18 09:30:00	AAPL	Stock	4.9354	4.94	4.8939	4.9346	127695736.0
2007-07-18 10:00:00	AAPL	Stock	4.935	4.9443	4.9161	4.9193	66749620.0
2007-07-18 10:30:00	AAPL	Stock	4.9193	4.9204	4.8982	4.9125	61705448.0
2007-07-18 11:00:00	AAPL	Stock	4.9129	4.9261	4.9075	4.9221	39118912.0
2007-07-18 11:30:00	AAPL	Stock	4.9218	4.9232	4.9025	4.905	36036980.0
2007-07-18 12:00:00	AAPL	Stock	4.9054	4.9071	4.8586	4.8775	84657944.0
2007-07-18 12:30:00	AAPL	Stock	4.8775	4.8921	4.87	4.885	38358572.0
2007-07-18 13:00:00	AAPL	Stock	4.8847	4.8943	4.8736	4.8896	26464620.0
2007-07-18 13:30:00	AAPL	Stock	4.8896	4.9146	4.8896	4.9014	48092912.0
2007-07-18 14:00:00	AAPL	Stock	4.9014	4.9086	4.8971	4.9018	32234328.0
2007-07-18 14:30:00	AAPL	Stock	4.9014	4.9114	4.8875	4.8921	36916964.0
2007-07-18 15:00:00	AAPL	Stock	4.8921	4.9132	4.8757	4.9029	35658000.0
2007-07-18 15:30:00	AAPL	Stock	4.9029	4.9336	4.8889	4.9332	79683184.0
2007-07-18 16:00:00	AAPL	Stock	4.9332	4.9332	4.9329	4.9329	7963536.0
2007-07-18 09:30:00	MSFT	Stock	30.51	30.8	30.5	30.74	6908517.0
2007-07-18 10:00:00	MSFT	Stock	30.74	30.86	30.65	30.79	6193192.0
2007-07-18 10:30:00	MSFT	Stock	30.78	30.79	30.71	30.74	4133555.0
2007-07-18 11:00:00	MSFT	Stock	30.73	30.88	30.73	30.86	3904362.0
2007-07-18 11:30:00	MSFT	Stock	30.87	30.88	30.72	30.72	4522508.0
2007-07-18 12:00:00	MSFT	Stock	30.725	30.725	30.56	30.65	4423726.0
2007-07-18 12:30:00	MSFT	Stock	30.66	30.73	30.62	30.66	2219317.0
2007-07-18 13:00:00	MSFT	Stock	30.66	30.69	30.53	30.65	3323370.0
2007-07-18 13:30:00	MSFT	Stock	30.66	30.76	30.65	30.69	2162315.0
2007-07-18 14:00:00	MSFT	Stock	30.68	30.76	30.68	30.73	2641860.0
2007-07-18 14:30:00	MSFT	Stock	30.72	30.79	30.67	30.785	3100513.0
2007-07-18 15:00:00	MSFT	Stock	30.785	30.88	30.78	30.86	4511584.0
2007-07-18 15:30:00	MSFT	Stock	30.86	30.97	30.84	30.95	11300874.0
2007-07-18 16:00:00	MSFT	Stock	30.96	30.96	30.92	30.92	1278671.0
2007-07-18 08:00:00	NVDA	Stock	0.7625	0.7625	0.7583	0.7583	24000.0
2007-07-18 08:30:00	NVDA	Stock	0.7625	0.7627	0.7625	0.7627	45300.0
2007-07-18 09:00:00	NVDA	Stock	0.7633	0.7655	0.7625	0.7647	314040.0
2007-07-18 09:30:00	NVDA	Stock	0.7638	0.7662	0.7592	0.7592	61248480.0
2007-07-18 10:00:00	NVDA	Stock	0.7593	0.7627	0.7555	0.7557	46151400.0
2007-07-18 10:30:00	NVDA	Stock	0.7558	0.7558	0.7458	0.7485	83575500.0
2007-07-18 11:00:00	NVDA	Stock	0.7488	0.7548	0.7485	0.754	39263700.0
2007-07-18 11:30:00	NVDA	Stock	0.7542	0.7542	0.7495	0.7503	36574260.0
2007-07-18 12:00:00	NVDA	Stock	0.7507	0.7533	0.7472	0.7473	35739900.0
2007-07-18 12:30:00	NVDA	Stock	0.7473	0.7493	0.7463	0.7472	21502680.0
2007-07-18 13:00:00	NVDA	Stock	0.7472	0.7495	0.7463	0.748	24444540.0
2007-07-18 13:30:00	NVDA	Stock	0.7482	0.7522	0.7478	0.7503	31900020.0
2007-07-18 14:00:00	NVDA	Stock	0.7503	0.752	0.7498	0.7515	18681120.0
2007-07-18 14:30:00	NVDA	Stock	0.7515	0.7557	0.7513	0.7548	39485880.0
2007-07-18 15:00:00	NVDA	Stock	0.7548	0.7557	0.7532	0.7548	31084200.0
2007-07-18 15:30:00	NVDA	Stock	0.7547	0.7615	0.7535	0.7613	65954520.0
2007-07-18 16:00:00	NVDA	Stock	0.7613	0.7617	0.7603	0.7607	7341240.0
2007-07-18 16:30:00	NVDA	Stock	0.7607	0.7608	0.7607	0.7608	333000.0
2007-07-18 17:00:00	NVDA	Stock	0.7607	0.7617	0.7607	0.7617	59520.0
2007-07-18 18:30:00	NVDA	Stock	0.7613	0.7613	0.7613	0.7613	30000.0
2007-07-18 19:30:00	NVDA	Stock	0.7613	0.7613	0.7613	0.7613	12000.0
2007-07-18 07:30:00	AMZN	Stock	3.675	3.675	3.675	3.675	2000.0

> showing 50 of 63,943 rows — these rows as CSV

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