PREVIEW / stock_30min / 2005-09-01

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-09-01.parquet
  size:    884 KB
  rows:    47,873
  symbols: 2,077

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-09-01 08:00:00	AAPL	Stock	1.675	1.6779	1.675	1.6768	56056.0
2005-09-01 08:30:00	AAPL	Stock	1.6757	1.6843	1.6746	1.6804	512792.0
2005-09-01 09:00:00	AAPL	Stock	1.6746	1.6804	1.6746	1.675	3368904.0
2005-09-01 09:30:00	AAPL	Stock	1.6786	1.6846	1.6668	1.6775	67499768.0
2005-09-01 10:00:00	AAPL	Stock	1.6775	1.6775	1.6664	1.6689	35332668.0
2005-09-01 10:30:00	AAPL	Stock	1.6689	1.6786	1.6614	1.6682	23934372.0
2005-09-01 11:00:00	AAPL	Stock	1.6682	1.675	1.6632	1.6661	34692028.0
2005-09-01 11:30:00	AAPL	Stock	1.6664	1.6743	1.6639	1.6679	26075728.0
2005-09-01 12:00:00	AAPL	Stock	1.6679	1.6689	1.6629	1.665	12920320.0
2005-09-01 12:30:00	AAPL	Stock	1.665	1.6679	1.6561	1.6579	16369584.0
2005-09-01 13:00:00	AAPL	Stock	1.6582	1.6607	1.6561	1.6582	13024452.0
2005-09-01 13:30:00	AAPL	Stock	1.6582	1.664	1.6518	1.6525	19572336.0
2005-09-01 14:00:00	AAPL	Stock	1.6525	1.6582	1.6461	1.6518	26800452.0
2005-09-01 14:30:00	AAPL	Stock	1.6521	1.6582	1.65	1.6525	15927380.0
2005-09-01 15:00:00	AAPL	Stock	1.6525	1.6593	1.6514	1.6529	23842644.0
2005-09-01 15:30:00	AAPL	Stock	1.6529	1.6557	1.6504	1.6521	24873436.0
2005-09-01 16:00:00	AAPL	Stock	1.6525	1.653	1.65	1.6507	2309664.0
2005-09-01 16:30:00	AAPL	Stock	1.65	1.6521	1.65	1.6521	719544.0
2005-09-01 17:00:00	AAPL	Stock	1.6521	1.6521	1.6521	1.6521	39200.0
2005-09-01 17:30:00	AAPL	Stock	1.6532	1.6532	1.6521	1.6521	88760.0
2005-09-01 18:00:00	AAPL	Stock	1.6532	1.6532	1.6532	1.6532	64400.0
2005-09-01 08:00:00	MSFT	Stock	27.4	27.43	27.4	27.4	4000.0
2005-09-01 08:30:00	MSFT	Stock	27.4	27.41	27.38	27.38	258617.0
2005-09-01 09:00:00	MSFT	Stock	27.38	27.4	27.35	27.36	433782.0
2005-09-01 09:30:00	MSFT	Stock	27.38	27.39	27.23	27.28	5674250.0
2005-09-01 10:00:00	MSFT	Stock	27.29	27.29	27.16	27.19	5399658.0
2005-09-01 10:30:00	MSFT	Stock	27.19	27.25	27.15	27.212	4491307.0
2005-09-01 11:00:00	MSFT	Stock	27.21	27.35	27.19	27.21	5554840.0
2005-09-01 11:30:00	MSFT	Stock	27.212	27.27	27.17	27.21	5509112.0
2005-09-01 12:00:00	MSFT	Stock	27.21	27.26	27.19	27.23	6045826.0
2005-09-01 12:30:00	MSFT	Stock	27.23	27.28	27.18	27.21	7391857.0
2005-09-01 13:00:00	MSFT	Stock	27.21	27.28	27.16	27.24	5992429.0
2005-09-01 13:30:00	MSFT	Stock	27.27	27.34	27.19	27.221	7397439.0
2005-09-01 14:00:00	MSFT	Stock	27.22	27.25	27.17	27.25	5529725.0
2005-09-01 14:30:00	MSFT	Stock	27.25	27.33	27.23	27.24	3732346.0
2005-09-01 15:00:00	MSFT	Stock	27.24	27.29	27.211	27.23	3873630.0
2005-09-01 15:30:00	MSFT	Stock	27.23	27.27	27.2	27.2	6094109.0
2005-09-01 16:00:00	MSFT	Stock	27.21	27.23	27.16	27.21	340243.0
2005-09-01 16:30:00	MSFT	Stock	27.2	27.4	27.2	27.4	144665.0
2005-09-01 17:00:00	MSFT	Stock	27.23	27.23	27.2	27.2	690.0
2005-09-01 17:30:00	MSFT	Stock	27.18	27.2	27.18	27.18	86398.0
2005-09-01 18:00:00	MSFT	Stock	27.21	27.21	27.18	27.2	2498.0
2005-09-01 09:00:00	NVDA	Stock	0.2557	0.2557	0.2546	0.2546	180720.0
2005-09-01 09:30:00	NVDA	Stock	0.2549	0.2572	0.2542	0.2557	63108120.0
2005-09-01 10:00:00	NVDA	Stock	0.2557	0.2559	0.2536	0.2549	48152160.0
2005-09-01 10:30:00	NVDA	Stock	0.2549	0.2556	0.2543	0.2553	69061320.0
2005-09-01 11:00:00	NVDA	Stock	0.2552	0.2581	0.2546	0.2574	52549080.0
2005-09-01 11:30:00	NVDA	Stock	0.2574	0.2578	0.2565	0.2567	29094840.0
2005-09-01 12:00:00	NVDA	Stock	0.2567	0.2572	0.2561	0.2566	18939480.0
2005-09-01 12:30:00	NVDA	Stock	0.2566	0.258	0.2559	0.2569	47325720.0

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

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