PREVIEW / stock_30min / 2010-10-07

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-07.parquet
  size:    1.4 MB
  rows:    76,516
  symbols: 3,492

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-10-07 07:00:00	AAPL	Stock	10.3675	10.3714	10.3571	10.3571	69720.0
2010-10-07 07:30:00	AAPL	Stock	10.3568	10.3611	10.3446	10.3464	156912.0
2010-10-07 08:00:00	AAPL	Stock	10.3432	10.3432	10.2721	10.3211	1624728.0
2010-10-07 08:30:00	AAPL	Stock	10.3211	10.3929	10.3039	10.3825	3775240.0
2010-10-07 09:00:00	AAPL	Stock	10.3821	10.3893	10.365	10.365	2522632.0
2010-10-07 09:30:00	AAPL	Stock	10.3664	10.3743	10.2468	10.2711	77314132.0
2010-10-07 10:00:00	AAPL	Stock	10.2686	10.3532	10.2589	10.3479	51194668.0
2010-10-07 10:30:00	AAPL	Stock	10.3501	10.3504	10.3071	10.3143	28152488.0
2010-10-07 11:00:00	AAPL	Stock	10.3143	10.32	10.2868	10.2946	22788808.0
2010-10-07 11:30:00	AAPL	Stock	10.295	10.3393	10.2946	10.3104	19736752.0
2010-10-07 12:00:00	AAPL	Stock	10.3104	10.3275	10.2886	10.2946	16510284.0
2010-10-07 12:30:00	AAPL	Stock	10.2939	10.3064	10.2732	10.3007	20469036.0
2010-10-07 13:00:00	AAPL	Stock	10.3032	10.3309	10.2907	10.3196	16005192.0
2010-10-07 13:30:00	AAPL	Stock	10.3182	10.3511	10.3054	10.3393	15340332.0
2010-10-07 14:00:00	AAPL	Stock	10.3407	10.3571	10.325	10.3375	29698536.0
2010-10-07 14:30:00	AAPL	Stock	10.3382	10.3543	10.3289	10.3479	23365468.0
2010-10-07 15:00:00	AAPL	Stock	10.3482	10.3518	10.3275	10.3375	20391308.0
2010-10-07 15:30:00	AAPL	Stock	10.3375	10.3686	10.3232	10.325	50070272.0
2010-10-07 16:00:00	AAPL	Stock	10.3293	10.3469	10.3216	10.3457	6319796.0
2010-10-07 16:30:00	AAPL	Stock	10.364	10.364	10.3216	10.3386	1286236.0
2010-10-07 17:00:00	AAPL	Stock	10.3375	10.3393	10.3361	10.3382	172172.0
2010-10-07 17:30:00	AAPL	Stock	10.3393	10.3407	10.3357	10.3357	114856.0
2010-10-07 18:00:00	AAPL	Stock	10.3329	10.3357	10.3293	10.3346	242172.0
2010-10-07 18:30:00	AAPL	Stock	10.3357	10.3361	10.3307	10.3339	326844.0
2010-10-07 19:00:00	AAPL	Stock	10.3343	10.3364	10.3343	10.3364	44380.0
2010-10-07 19:30:00	AAPL	Stock	10.3368	10.3371	10.3321	10.3364	201796.0
2010-10-07 07:00:00	MSFT	Stock	24.5	24.5	24.5	24.5	500.0
2010-10-07 07:30:00	MSFT	Stock	24.56	24.6	24.56	24.6	500.0
2010-10-07 08:00:00	MSFT	Stock	24.5	24.5	24.44	24.44	6938.0
2010-10-07 08:30:00	MSFT	Stock	24.45	24.6	24.44	24.6	53500.0
2010-10-07 09:00:00	MSFT	Stock	24.58	24.67	24.54	24.6	85985.0
2010-10-07 09:30:00	MSFT	Stock	24.61	24.63	24.28	24.48	4946140.0
2010-10-07 10:00:00	MSFT	Stock	24.48	24.67	24.44	24.67	4431744.0
2010-10-07 10:30:00	MSFT	Stock	24.67	24.75	24.65	24.68	6838581.0
2010-10-07 11:00:00	MSFT	Stock	24.68	24.7	24.61	24.69	2715912.0
2010-10-07 11:30:00	MSFT	Stock	24.69	24.7	24.51	24.515	3816892.0
2010-10-07 12:00:00	MSFT	Stock	24.52	24.53	24.42	24.43	3200084.0
2010-10-07 12:30:00	MSFT	Stock	24.435	24.47	24.39	24.47	2006935.0
2010-10-07 13:00:00	MSFT	Stock	24.465	24.53	24.45	24.48	1533198.0
2010-10-07 13:30:00	MSFT	Stock	24.485	24.58	24.47	24.55	1880895.0
2010-10-07 14:00:00	MSFT	Stock	24.555	24.58	24.48	24.53	1831311.0
2010-10-07 14:30:00	MSFT	Stock	24.54	24.58	24.53	24.575	1679420.0
2010-10-07 15:00:00	MSFT	Stock	24.575	24.58	24.45	24.487	4906594.0
2010-10-07 15:30:00	MSFT	Stock	24.49	24.57	24.47	24.53	7909832.0
2010-10-07 16:00:00	MSFT	Stock	24.52	24.6	24.5	24.532	1192840.0
2010-10-07 16:30:00	MSFT	Stock	24.58	24.59	24.43	24.54	10200.0
2010-10-07 17:00:00	MSFT	Stock	24.57	24.57	24.54	24.57	9450.0
2010-10-07 17:30:00	MSFT	Stock	24.53	24.58	24.53	24.53	19976.0
2010-10-07 18:00:00	MSFT	Stock	24.53	24.53	24.53	24.53	42393.0
2010-10-07 18:30:00	MSFT	Stock	24.53	24.53	24.53	24.53	2100.0

> showing 50 of 76,516 rows — these rows as CSV

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