PREVIEW / stock_30min / 2010-01-26

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-26.parquet
  size:    1.4 MB
  rows:    72,610
  symbols: 3,444

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-01-26 04:00:00	AAPL	Stock	7.3554	7.3636	7.3375	7.3636	43904.0
2010-01-26 04:30:00	AAPL	Stock	7.3636	7.3932	7.3636	7.3932	48440.0
2010-01-26 05:00:00	AAPL	Stock	7.3914	7.3946	7.375	7.375	30800.0
2010-01-26 05:30:00	AAPL	Stock	7.3714	7.3718	7.3682	7.3718	33600.0
2010-01-26 06:00:00	AAPL	Stock	7.3714	7.3714	7.3543	7.3604	123536.0
2010-01-26 06:30:00	AAPL	Stock	7.3625	7.3736	7.3521	7.3521	141148.0
2010-01-26 07:00:00	AAPL	Stock	7.3618	7.4029	7.3521	7.3929	755720.0
2010-01-26 07:30:00	AAPL	Stock	7.3925	7.4764	7.3918	7.4496	4099788.0
2010-01-26 08:00:00	AAPL	Stock	7.4343	7.4464	7.3771	7.4079	11265268.0
2010-01-26 08:30:00	AAPL	Stock	7.4093	7.4321	7.3893	7.4039	9973824.0
2010-01-26 09:00:00	AAPL	Stock	7.4043	7.4068	7.3175	7.3536	15625064.0
2010-01-26 09:30:00	AAPL	Stock	7.3496	7.3821	7.235	7.3043	251869828.0
2010-01-26 10:00:00	AAPL	Stock	7.3071	7.3875	7.2654	7.3468	147471296.0
2010-01-26 10:30:00	AAPL	Stock	7.3475	7.4246	7.3432	7.385	94544352.0
2010-01-26 11:00:00	AAPL	Stock	7.3854	7.4418	7.375	7.4377	79614276.0
2010-01-26 11:30:00	AAPL	Stock	7.4382	7.5279	7.4339	7.5221	104497092.0
2010-01-26 12:00:00	AAPL	Stock	7.5218	7.6214	7.5096	7.6071	155108940.0
2010-01-26 12:30:00	AAPL	Stock	7.6075	7.6325	7.58	7.5975	127197112.0
2010-01-26 13:00:00	AAPL	Stock	7.5971	7.6214	7.54	7.5486	97443836.0
2010-01-26 13:30:00	AAPL	Stock	7.5496	7.5904	7.5489	7.59	67189696.0
2010-01-26 14:00:00	AAPL	Stock	7.5893	7.5929	7.4829	7.4843	110116272.0
2010-01-26 14:30:00	AAPL	Stock	7.4838	7.5114	7.4346	7.4832	140688828.0
2010-01-26 15:00:00	AAPL	Stock	7.4832	7.4964	7.375	7.3882	130625516.0
2010-01-26 15:30:00	AAPL	Stock	7.3893	7.3946	7.2964	7.3532	196551124.0
2010-01-26 16:00:00	AAPL	Stock	7.3532	7.4432	7.2584	7.3757	12172384.0
2010-01-26 16:30:00	AAPL	Stock	7.3757	7.5681	7.3066	7.3675	1449448.0
2010-01-26 17:00:00	AAPL	Stock	7.3686	7.4228	7.3557	7.3557	731472.0
2010-01-26 17:30:00	AAPL	Stock	7.3639	7.5814	7.3554	7.3554	3416336.0
2010-01-26 18:00:00	AAPL	Stock	7.3543	7.3839	7.3536	7.3714	2024428.0
2010-01-26 18:30:00	AAPL	Stock	7.3714	7.3786	7.37	7.37	403620.0
2010-01-26 19:00:00	AAPL	Stock	7.3707	7.3743	7.3664	7.3664	561680.0
2010-01-26 19:30:00	AAPL	Stock	7.3664	7.375	7.365	7.375	635712.0
2010-01-26 04:00:00	MSFT	Stock	29.2	29.2	29.2	29.2	125.0
2010-01-26 05:30:00	MSFT	Stock	29.13	29.13	29.13	29.13	300.0
2010-01-26 06:30:00	MSFT	Stock	29.13	29.16	29.13	29.16	2100.0
2010-01-26 07:00:00	MSFT	Stock	29.19	29.3	29.19	29.26	5545.0
2010-01-26 07:30:00	MSFT	Stock	29.29	29.35	29.29	29.35	7200.0
2010-01-26 08:00:00	MSFT	Stock	29.36	29.48	29.34	29.4	24680.0
2010-01-26 08:30:00	MSFT	Stock	29.38	29.38	29.32	29.32	8915.0
2010-01-26 09:00:00	MSFT	Stock	29.31	29.31	29.18	29.18	94492.0
2010-01-26 09:30:00	MSFT	Stock	29.18	29.35	29.09	29.25	7458915.0
2010-01-26 10:00:00	MSFT	Stock	29.22	29.61	29.21	29.492	7516952.0
2010-01-26 10:30:00	MSFT	Stock	29.495	29.51	29.35	29.46	3442881.0
2010-01-26 11:00:00	MSFT	Stock	29.46	29.63	29.45	29.599	4397506.0
2010-01-26 11:30:00	MSFT	Stock	29.59	29.79	29.58	29.77	4454128.0
2010-01-26 12:00:00	MSFT	Stock	29.76	29.83	29.735	29.781	3087189.0
2010-01-26 12:30:00	MSFT	Stock	29.78	29.84	29.71	29.82	2392733.0
2010-01-26 13:00:00	MSFT	Stock	29.83	29.85	29.76	29.8	2832569.0
2010-01-26 13:30:00	MSFT	Stock	29.808	29.85	29.76	29.83	3897874.0
2010-01-26 14:00:00	MSFT	Stock	29.83	29.84	29.65	29.652	2881492.0

> showing 50 of 72,610 rows — these rows as CSV

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