PREVIEW / stock_30min / 2010-03-01

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-01.parquet
  size:    1.4 MB
  rows:    74,744
  symbols: 3,474

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
2010-03-01 04:30:00	AAPL	Stock	7.3586	7.3586	7.3557	7.3557	5600.0
2010-03-01 05:00:00	AAPL	Stock	7.3671	7.3671	7.3671	7.3671	28000.0
2010-03-01 05:30:00	AAPL	Stock	7.3679	7.3679	7.3679	7.3679	2800.0
2010-03-01 07:00:00	AAPL	Stock	7.3407	7.3568	7.3386	7.3404	121856.0
2010-03-01 07:30:00	AAPL	Stock	7.3446	7.3536	7.3321	7.3321	250124.0
2010-03-01 08:00:00	AAPL	Stock	7.3286	7.335	7.3079	7.3304	1055152.0
2010-03-01 08:30:00	AAPL	Stock	7.3289	7.3429	7.3275	7.3421	2510732.0
2010-03-01 09:00:00	AAPL	Stock	7.3421	7.3482	7.3393	7.3482	1723904.0
2010-03-01 09:30:00	AAPL	Stock	7.3475	7.4046	7.3375	7.3957	89034652.0
2010-03-01 10:00:00	AAPL	Stock	7.3929	7.4518	7.3868	7.4446	86821868.0
2010-03-01 10:30:00	AAPL	Stock	7.4446	7.4607	7.4339	7.4507	56593908.0
2010-03-01 11:00:00	AAPL	Stock	7.4514	7.4679	7.4507	7.4536	38386656.0
2010-03-01 11:30:00	AAPL	Stock	7.4536	7.4554	7.4429	7.4489	26077576.0
2010-03-01 12:00:00	AAPL	Stock	7.4493	7.4621	7.4482	7.4557	18552660.0
2010-03-01 12:30:00	AAPL	Stock	7.4557	7.4667	7.4443	7.4468	20774180.0
2010-03-01 13:00:00	AAPL	Stock	7.4468	7.46	7.4457	7.46	15626520.0
2010-03-01 13:30:00	AAPL	Stock	7.46	7.4757	7.4554	7.4671	28151340.0
2010-03-01 14:00:00	AAPL	Stock	7.4675	7.4721	7.4557	7.4661	20691720.0
2010-03-01 14:30:00	AAPL	Stock	7.4651	7.4682	7.4543	7.4593	19359480.0
2010-03-01 15:00:00	AAPL	Stock	7.4589	7.4821	7.4561	7.4739	40418476.0
2010-03-01 15:30:00	AAPL	Stock	7.475	7.4789	7.4468	7.4646	65049320.0
2010-03-01 16:00:00	AAPL	Stock	7.4643	7.4668	7.3916	7.46	11487616.0
2010-03-01 16:30:00	AAPL	Stock	7.4554	7.4621	7.4554	7.4579	297612.0
2010-03-01 17:00:00	AAPL	Stock	7.4596	7.461	7.4568	7.4607	224952.0
2010-03-01 17:30:00	AAPL	Stock	7.4607	7.4643	7.4593	7.4593	146720.0
2010-03-01 18:00:00	AAPL	Stock	7.4607	7.4643	7.4607	7.4639	241696.0
2010-03-01 18:30:00	AAPL	Stock	7.4629	7.4639	7.4611	7.4629	108864.0
2010-03-01 19:00:00	AAPL	Stock	7.46	7.4618	7.4595	7.4618	37268.0
2010-03-01 19:30:00	AAPL	Stock	7.4607	7.4625	7.4561	7.4561	147924.0
2010-03-01 20:00:00	AAPL	Stock	7.4486	7.4486	7.4486	7.4486	137200.0
2010-03-01 04:00:00	MSFT	Stock	28.76	28.76	28.76	28.76	200.0
2010-03-01 07:00:00	MSFT	Stock	28.72	28.72	28.72	28.72	400.0
2010-03-01 08:00:00	MSFT	Stock	28.7	28.78	28.66	28.78	2607.0
2010-03-01 08:30:00	MSFT	Stock	28.79	28.8	28.76	28.76	3293.0
2010-03-01 09:00:00	MSFT	Stock	28.78	28.82	28.76	28.76	2189.0
2010-03-01 09:30:00	MSFT	Stock	28.76	28.82	28.57	28.6	4037422.0
2010-03-01 10:00:00	MSFT	Stock	28.59	28.86	28.53	28.78	4149324.0
2010-03-01 10:30:00	MSFT	Stock	28.772	28.91	28.74	28.88	2756386.0
2010-03-01 11:00:00	MSFT	Stock	28.88	28.96	28.87	28.94	3289421.0
2010-03-01 11:30:00	MSFT	Stock	28.94	28.97	28.8	28.84	2455666.0
2010-03-01 12:00:00	MSFT	Stock	28.85	28.89	28.83	28.85	1801395.0
2010-03-01 12:30:00	MSFT	Stock	28.841	28.96	28.84	28.911	2430508.0
2010-03-01 13:00:00	MSFT	Stock	28.91	28.92	28.83	28.85	1574924.0
2010-03-01 13:30:00	MSFT	Stock	28.84	28.88	28.81	28.83	1873517.0
2010-03-01 14:00:00	MSFT	Stock	28.83	28.95	28.82	28.9	1686364.0
2010-03-01 14:30:00	MSFT	Stock	28.89	28.94	28.87	28.92	2253954.0
2010-03-01 15:00:00	MSFT	Stock	28.91	28.95	28.84	28.94	4314305.0
2010-03-01 15:30:00	MSFT	Stock	28.95	29.05	28.93	29.01	8429414.0
2010-03-01 16:00:00	MSFT	Stock	29.02	29.07	28.855	29.01	2020577.0
2010-03-01 16:30:00	MSFT	Stock	28.973	29.05	28.973	29.05	50381.0

> showing 50 of 74,744 rows — these rows as CSV

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