PREVIEW / stock_30min / 2007-09-25

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-25.parquet
  size:    1.2 MB
  rows:    66,779
  symbols: 3,123

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-09-25 06:30:00	AAPL	Stock	5.2625	5.2625	5.25	5.2504	92400.0
2007-09-25 07:00:00	AAPL	Stock	5.2504	5.2504	5.2286	5.2371	427868.0
2007-09-25 07:30:00	AAPL	Stock	5.2386	5.2482	5.2361	5.2479	95200.0
2007-09-25 08:00:00	AAPL	Stock	5.2464	5.2586	5.2379	5.25	2909956.0
2007-09-25 08:30:00	AAPL	Stock	5.2504	5.2668	5.2504	5.2557	1934436.0
2007-09-25 09:00:00	AAPL	Stock	5.2557	5.2557	5.2371	5.245	3528868.0
2007-09-25 09:30:00	AAPL	Stock	5.2461	5.3007	5.2436	5.2946	126154084.0
2007-09-25 10:00:00	AAPL	Stock	5.2946	5.365	5.2811	5.3332	169279264.0
2007-09-25 10:30:00	AAPL	Stock	5.3325	5.3561	5.3293	5.3372	65502108.0
2007-09-25 11:00:00	AAPL	Stock	5.3375	5.3536	5.3336	5.3411	53238668.0
2007-09-25 11:30:00	AAPL	Stock	5.3411	5.3482	5.3229	5.335	42818888.0
2007-09-25 12:00:00	AAPL	Stock	5.3354	5.3429	5.3161	5.3289	41727056.0
2007-09-25 12:30:00	AAPL	Stock	5.329	5.3439	5.3246	5.3379	30972564.0
2007-09-25 13:00:00	AAPL	Stock	5.3375	5.3571	5.2964	5.3561	38792320.0
2007-09-25 13:30:00	AAPL	Stock	5.3564	5.3975	5.3514	5.3925	118002248.0
2007-09-25 14:00:00	AAPL	Stock	5.3921	5.41	5.3696	5.4093	99065932.0
2007-09-25 14:30:00	AAPL	Stock	5.4086	5.4286	5.3889	5.4264	123762856.0
2007-09-25 15:00:00	AAPL	Stock	5.4268	5.4286	5.4032	5.4102	79325008.0
2007-09-25 15:30:00	AAPL	Stock	5.4096	5.4721	5.4079	5.4721	167279448.0
2007-09-25 16:00:00	AAPL	Stock	5.4704	5.4893	5.3271	5.4821	16323972.0
2007-09-25 16:30:00	AAPL	Stock	5.4821	5.4904	5.3882	5.4857	6079584.0
2007-09-25 17:00:00	AAPL	Stock	5.4857	5.4893	5.4707	5.4875	1598464.0
2007-09-25 17:30:00	AAPL	Stock	5.4868	5.4868	5.4736	5.4807	673652.0
2007-09-25 18:00:00	AAPL	Stock	5.4804	5.4875	5.4707	5.4846	2237648.0
2007-09-25 18:30:00	AAPL	Stock	5.4846	5.4879	5.4839	5.4875	241752.0
2007-09-25 19:00:00	AAPL	Stock	5.4864	5.4889	5.4825	5.4875	171220.0
2007-09-25 19:30:00	AAPL	Stock	5.4864	5.4911	5.4846	5.4857	325780.0
2007-09-25 07:00:00	MSFT	Stock	29.13	29.13	29.13	29.13	144.0
2007-09-25 07:30:00	MSFT	Stock	29.13	29.13	29.08	29.08	400.0
2007-09-25 08:00:00	MSFT	Stock	29.11	29.24	29.11	29.19	61651.0
2007-09-25 08:30:00	MSFT	Stock	29.17	29.2	29.12	29.17	82775.0
2007-09-25 09:00:00	MSFT	Stock	29.16	29.18	29.08	29.14	121066.0
2007-09-25 09:30:00	MSFT	Stock	29.13	29.48	29.1	29.4	8407778.0
2007-09-25 10:00:00	MSFT	Stock	29.4	29.47	29.33	29.435	5633745.0
2007-09-25 10:30:00	MSFT	Stock	29.433	29.52	29.37	29.44	8209975.0
2007-09-25 11:00:00	MSFT	Stock	29.43	29.5	29.38	29.39	7080928.0
2007-09-25 11:30:00	MSFT	Stock	29.4	29.42	29.33	29.398	3926885.0
2007-09-25 12:00:00	MSFT	Stock	29.398	29.4	29.34	29.37	2671274.0
2007-09-25 12:30:00	MSFT	Stock	29.37	29.42	29.36	29.39	2618809.0
2007-09-25 13:00:00	MSFT	Stock	29.39	29.42	29.36	29.415	1880229.0
2007-09-25 13:30:00	MSFT	Stock	29.415	29.45	29.39	29.43	2394667.0
2007-09-25 14:00:00	MSFT	Stock	29.43	29.47	29.41	29.45	2814418.0
2007-09-25 14:30:00	MSFT	Stock	29.45	29.55	29.43	29.52	4653028.0
2007-09-25 15:00:00	MSFT	Stock	29.52	29.54	29.43	29.46	5026995.0
2007-09-25 15:30:00	MSFT	Stock	29.46	29.56	29.4	29.55	14162166.0
2007-09-25 16:00:00	MSFT	Stock	29.55	29.56	29.427	29.51	5254101.0
2007-09-25 16:30:00	MSFT	Stock	29.51	29.52	29.431	29.52	463662.0
2007-09-25 17:00:00	MSFT	Stock	29.5	29.56	29.5	29.52	20484.0
2007-09-25 17:30:00	MSFT	Stock	28.941	29.55	28.941	29.53	19700.0
2007-09-25 18:00:00	MSFT	Stock	29.55	29.57	29.55	29.57	94462.0

> showing 50 of 66,779 rows — these rows as CSV

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