PREVIEW / stock_30min / 2007-07-24

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-24.parquet
  size:    1.2 MB
  rows:    64,887
  symbols: 3,086

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-24 09:30:00	AAPL	Stock	4.96	4.9811	4.8768	4.9379	321008324.0
2007-07-24 10:00:00	AAPL	Stock	4.9368	5.0	4.9311	4.9804	152561612.0
2007-07-24 10:30:00	AAPL	Stock	4.9804	5.0179	4.9661	5.0129	93402344.0
2007-07-24 11:00:00	AAPL	Stock	5.0136	5.0246	4.9968	5.0054	108555860.0
2007-07-24 11:30:00	AAPL	Stock	5.005	5.0068	4.9814	4.9957	62127044.0
2007-07-24 12:00:00	AAPL	Stock	4.995	5.0061	4.9789	5.0032	53019708.0
2007-07-24 12:30:00	AAPL	Stock	5.0029	5.0036	4.9911	4.9979	49359828.0
2007-07-24 13:00:00	AAPL	Stock	4.9979	5.0191	4.9911	5.0111	52521028.0
2007-07-24 13:30:00	AAPL	Stock	5.01	5.0357	4.9718	4.9825	87534328.0
2007-07-24 14:00:00	AAPL	Stock	4.9825	4.9886	4.9654	4.9736	73361792.0
2007-07-24 14:30:00	AAPL	Stock	4.9732	4.9764	4.9271	4.9311	129076472.0
2007-07-24 15:00:00	AAPL	Stock	4.9311	4.9339	4.8593	4.8682	183404228.0
2007-07-24 15:30:00	AAPL	Stock	4.8682	4.875	4.7911	4.8211	240031316.0
2007-07-24 16:00:00	AAPL	Stock	4.8214	4.8214	4.8143	4.8175	18862144.0
2007-07-24 09:30:00	MSFT	Stock	31.01	31.23	31.0	31.175	4816731.0
2007-07-24 10:00:00	MSFT	Stock	31.17	31.19	30.96	31.09	3025673.0
2007-07-24 10:30:00	MSFT	Stock	31.09	31.27	31.05	31.24	2803599.0
2007-07-24 11:00:00	MSFT	Stock	31.24	31.27	31.15	31.22	3333676.0
2007-07-24 11:30:00	MSFT	Stock	31.22	31.29	31.19	31.29	1978634.0
2007-07-24 12:00:00	MSFT	Stock	31.29	31.46	31.28	31.419	2323748.0
2007-07-24 12:30:00	MSFT	Stock	31.42	31.48	31.3	31.32	2968554.0
2007-07-24 13:00:00	MSFT	Stock	31.32	31.38	31.2	31.205	3329793.0
2007-07-24 13:30:00	MSFT	Stock	31.2	31.26	31.13	31.17	3500103.0
2007-07-24 14:00:00	MSFT	Stock	31.16	31.17	31.09	31.14	2504637.0
2007-07-24 14:30:00	MSFT	Stock	31.13	31.15	30.99	31.002	4870150.0
2007-07-24 15:00:00	MSFT	Stock	31.01	31.01	30.84	30.848	6433985.0
2007-07-24 15:30:00	MSFT	Stock	30.84	30.87	30.71	30.79	9822007.0
2007-07-24 16:00:00	MSFT	Stock	30.81	30.81	30.78	30.8	2527901.0
2007-07-24 08:30:00	NVDA	Stock	0.7575	0.7575	0.7492	0.7525	503400.0
2007-07-24 09:00:00	NVDA	Stock	0.7532	0.7562	0.7532	0.7547	871980.0
2007-07-24 09:30:00	NVDA	Stock	0.7562	0.7603	0.749	0.757	41090580.0
2007-07-24 10:00:00	NVDA	Stock	0.7572	0.7585	0.7497	0.7555	26838360.0
2007-07-24 10:30:00	NVDA	Stock	0.7555	0.759	0.7528	0.757	38133240.0
2007-07-24 11:00:00	NVDA	Stock	0.7572	0.7577	0.7502	0.751	24848340.0
2007-07-24 11:30:00	NVDA	Stock	0.751	0.7555	0.7485	0.7555	28707480.0
2007-07-24 12:00:00	NVDA	Stock	0.7555	0.7573	0.7513	0.7557	21412260.0
2007-07-24 12:30:00	NVDA	Stock	0.7557	0.7625	0.7557	0.7577	22431960.0
2007-07-24 13:00:00	NVDA	Stock	0.7577	0.759	0.7535	0.7558	19775820.0
2007-07-24 13:30:00	NVDA	Stock	0.7558	0.758	0.751	0.7513	22133700.0
2007-07-24 14:00:00	NVDA	Stock	0.7513	0.7528	0.7487	0.7508	27384360.0
2007-07-24 14:30:00	NVDA	Stock	0.751	0.7513	0.743	0.7435	38076480.0
2007-07-24 15:00:00	NVDA	Stock	0.7435	0.7437	0.7367	0.7373	47834940.0
2007-07-24 15:30:00	NVDA	Stock	0.7372	0.7397	0.7345	0.7397	67047240.0
2007-07-24 16:00:00	NVDA	Stock	0.7388	0.7395	0.7382	0.7383	4802940.0
2007-07-24 17:00:00	NVDA	Stock	0.7382	0.7382	0.7382	0.7382	719460.0
2007-07-24 17:30:00	NVDA	Stock	0.7382	0.7382	0.7382	0.7382	29700.0
2007-07-24 19:00:00	NVDA	Stock	0.74	0.74	0.74	0.74	69960.0
2007-07-24 05:30:00	AMZN	Stock	3.58	3.58	3.57	3.57	14000.0
2007-07-24 07:30:00	AMZN	Stock	3.5995	3.5995	3.5995	3.5995	2000.0
2007-07-24 08:00:00	AMZN	Stock	3.599	3.599	3.5545	3.565	51340.0

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

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