PREVIEW / stock_30min / 2010-08-09

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-09.parquet
  size:    1.3 MB
  rows:    72,247
  symbols: 3,491

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-08-09 06:00:00	AAPL	Stock	9.2964	9.2964	9.2964	9.2964	2800.0
2010-08-09 06:30:00	AAPL	Stock	9.2607	9.2821	9.2607	9.2821	16800.0
2010-08-09 07:00:00	AAPL	Stock	9.2611	9.2746	9.2575	9.2575	44800.0
2010-08-09 07:30:00	AAPL	Stock	9.2714	9.3143	9.2657	9.3079	276304.0
2010-08-09 08:00:00	AAPL	Stock	9.3132	9.335	9.3089	9.3182	1073576.0
2010-08-09 08:30:00	AAPL	Stock	9.3218	9.3282	9.3164	9.3179	747516.0
2010-08-09 09:00:00	AAPL	Stock	9.3179	9.3375	9.3143	9.3354	1255296.0
2010-08-09 09:30:00	AAPL	Stock	9.3371	9.3393	9.275	9.2943	41752816.0
2010-08-09 10:00:00	AAPL	Stock	9.2946	9.3321	9.2893	9.2914	33416152.0
2010-08-09 10:30:00	AAPL	Stock	9.2921	9.3114	9.2704	9.2796	21035224.0
2010-08-09 11:00:00	AAPL	Stock	9.2807	9.3168	9.2782	9.2996	17585820.0
2010-08-09 11:30:00	AAPL	Stock	9.2989	9.3071	9.2961	9.2986	12685372.0
2010-08-09 12:00:00	AAPL	Stock	9.2986	9.3146	9.2961	9.3043	12486236.0
2010-08-09 12:30:00	AAPL	Stock	9.3036	9.3139	9.3007	9.3071	6807276.0
2010-08-09 13:00:00	AAPL	Stock	9.3068	9.3186	9.3022	9.3093	8878492.0
2010-08-09 13:30:00	AAPL	Stock	9.3092	9.3196	9.3043	9.3175	15850156.0
2010-08-09 14:00:00	AAPL	Stock	9.3182	9.3304	9.3175	9.3246	23197636.0
2010-08-09 14:30:00	AAPL	Stock	9.3246	9.3543	9.3246	9.3514	24170832.0
2010-08-09 15:00:00	AAPL	Stock	9.3511	9.3625	9.335	9.3496	26882436.0
2010-08-09 15:30:00	AAPL	Stock	9.35	9.3589	9.3429	9.35	42258748.0
2010-08-09 16:00:00	AAPL	Stock	9.3486	9.3568	9.3071	9.3536	8091076.0
2010-08-09 16:30:00	AAPL	Stock	9.3536	9.3536	9.3489	9.3489	89152.0
2010-08-09 17:00:00	AAPL	Stock	9.312	9.3504	9.312	9.3482	233520.0
2010-08-09 17:30:00	AAPL	Stock	9.3486	9.3489	9.345	9.3482	53200.0
2010-08-09 18:00:00	AAPL	Stock	9.3511	9.3536	9.3482	9.35	190036.0
2010-08-09 18:30:00	AAPL	Stock	9.3486	9.3536	9.3482	9.3536	95592.0
2010-08-09 19:00:00	AAPL	Stock	9.355	9.355	9.34	9.3429	102368.0
2010-08-09 19:30:00	AAPL	Stock	9.3482	9.3482	9.3429	9.3446	89600.0
2010-08-09 05:30:00	MSFT	Stock	25.65	25.65	25.65	25.65	100.0
2010-08-09 07:00:00	MSFT	Stock	25.54	25.54	25.5	25.51	2650.0
2010-08-09 07:30:00	MSFT	Stock	25.51	25.51	25.51	25.51	33000.0
2010-08-09 08:00:00	MSFT	Stock	25.59	25.64	25.55	25.64	6291.0
2010-08-09 08:30:00	MSFT	Stock	25.62	25.65	25.62	25.64	22611.0
2010-08-09 09:00:00	MSFT	Stock	25.65	25.65	25.49	25.55	57983.0
2010-08-09 09:30:00	MSFT	Stock	25.55	25.58	25.37	25.38	5584390.0
2010-08-09 10:00:00	MSFT	Stock	25.38	25.54	25.38	25.525	3569544.0
2010-08-09 10:30:00	MSFT	Stock	25.525	25.58	25.512	25.58	2669984.0
2010-08-09 11:00:00	MSFT	Stock	25.578	25.61	25.57	25.6	2239449.0
2010-08-09 11:30:00	MSFT	Stock	25.6	25.655	25.6	25.61	1904462.0
2010-08-09 12:00:00	MSFT	Stock	25.61	25.61	25.57	25.581	2150506.0
2010-08-09 12:30:00	MSFT	Stock	25.58	25.59	25.51	25.538	3000195.0
2010-08-09 13:00:00	MSFT	Stock	25.53	25.6	25.53	25.58	1668484.0
2010-08-09 13:30:00	MSFT	Stock	25.57	25.61	25.56	25.59	1441933.0
2010-08-09 14:00:00	MSFT	Stock	25.598	25.61	25.58	25.58	1672566.0
2010-08-09 14:30:00	MSFT	Stock	25.58	25.73	25.58	25.699	2953880.0
2010-08-09 15:00:00	MSFT	Stock	25.691	25.7	25.59	25.63	3389891.0
2010-08-09 15:30:00	MSFT	Stock	25.635	25.655	25.53	25.61	12875733.0
2010-08-09 16:00:00	MSFT	Stock	25.61	25.64	25.51	25.63	11553989.0
2010-08-09 16:30:00	MSFT	Stock	25.62	25.64	25.61	25.62	13163.0
2010-08-09 17:00:00	MSFT	Stock	25.6	25.61	25.6	25.61	5531.0

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

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