PREVIEW / stock_30min / 2010-04-30

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-30.parquet
  size:    1.4 MB
  rows:    76,101
  symbols: 3,499

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-04-30 04:00:00	AAPL	Stock	9.6268	9.6268	9.6107	9.625	33600.0
2010-04-30 04:30:00	AAPL	Stock	9.6571	9.6636	9.6571	9.6636	8400.0
2010-04-30 05:00:00	AAPL	Stock	9.6429	9.6429	9.6429	9.6429	11200.0
2010-04-30 05:30:00	AAPL	Stock	9.6429	9.6429	9.6407	9.6407	16800.0
2010-04-30 06:00:00	AAPL	Stock	9.6346	9.6357	9.6346	9.6357	16800.0
2010-04-30 06:30:00	AAPL	Stock	9.6357	9.6429	9.6275	9.6275	30716.0
2010-04-30 07:00:00	AAPL	Stock	9.6275	9.6329	9.6196	9.6286	81732.0
2010-04-30 07:30:00	AAPL	Stock	9.6389	9.6493	9.6264	9.6304	78456.0
2010-04-30 08:00:00	AAPL	Stock	9.6304	9.6486	9.6268	9.6439	1062292.0
2010-04-30 08:30:00	AAPL	Stock	9.6432	9.6468	9.6114	9.6204	1405852.0
2010-04-30 09:00:00	AAPL	Stock	9.6321	9.6418	9.605	9.62	1240008.0
2010-04-30 09:30:00	AAPL	Stock	9.6182	9.6632	9.5036	9.5321	72987768.0
2010-04-30 10:00:00	AAPL	Stock	9.5321	9.5461	9.4679	9.5257	55168120.0
2010-04-30 10:30:00	AAPL	Stock	9.5268	9.5639	9.5039	9.5386	28716884.0
2010-04-30 11:00:00	AAPL	Stock	9.5382	9.5457	9.5018	9.515	22089788.0
2010-04-30 11:30:00	AAPL	Stock	9.5175	9.5179	9.4968	9.5161	20906172.0
2010-04-30 12:00:00	AAPL	Stock	9.5154	9.5227	9.4286	9.4318	38448816.0
2010-04-30 12:30:00	AAPL	Stock	9.4314	9.4486	9.3607	9.3897	38429524.0
2010-04-30 13:00:00	AAPL	Stock	9.3893	9.4361	9.3757	9.4242	33869500.0
2010-04-30 13:30:00	AAPL	Stock	9.42	9.4307	9.3929	9.3954	24692500.0
2010-04-30 14:00:00	AAPL	Stock	9.3954	9.4182	9.3761	9.3936	28255388.0
2010-04-30 14:30:00	AAPL	Stock	9.39	9.3971	9.3571	9.3732	32217332.0
2010-04-30 15:00:00	AAPL	Stock	9.3729	9.3925	9.3429	9.3743	41320328.0
2010-04-30 15:30:00	AAPL	Stock	9.3736	9.3989	9.3214	9.3218	70525672.0
2010-04-30 16:00:00	AAPL	Stock	9.3218	9.4643	9.3214	9.3257	20700456.0
2010-04-30 16:30:00	AAPL	Stock	9.372	9.372	9.3275	9.3339	425404.0
2010-04-30 17:00:00	AAPL	Stock	9.3339	9.4989	9.3325	9.3386	219492.0
2010-04-30 17:30:00	AAPL	Stock	9.3386	9.3393	9.3364	9.3368	123592.0
2010-04-30 18:00:00	AAPL	Stock	9.3386	9.3393	9.3325	9.3357	264096.0
2010-04-30 18:30:00	AAPL	Stock	9.3357	9.3357	9.3246	9.3282	190316.0
2010-04-30 19:00:00	AAPL	Stock	9.3286	9.3439	9.3286	9.3304	26292.0
2010-04-30 19:30:00	AAPL	Stock	9.3321	9.3421	9.3321	9.3364	148344.0
2010-04-30 08:00:00	MSFT	Stock	31.13	31.13	31.02	31.02	300.0
2010-04-30 08:30:00	MSFT	Stock	31.04	31.04	31.01	31.02	4450.0
2010-04-30 09:00:00	MSFT	Stock	31.02	31.08	30.95	31.07	19085.0
2010-04-30 09:30:00	MSFT	Stock	31.07	31.08	30.74	30.82	7623839.0
2010-04-30 10:00:00	MSFT	Stock	30.82	30.84	30.66	30.72	8449132.0
2010-04-30 10:30:00	MSFT	Stock	30.73	30.82	30.7	30.8	4300815.0
2010-04-30 11:00:00	MSFT	Stock	30.8	30.89	30.692	30.786	2877059.0
2010-04-30 11:30:00	MSFT	Stock	30.78	30.9	30.77	30.856	2714812.0
2010-04-30 12:00:00	MSFT	Stock	30.86	30.86	30.67	30.68	2698593.0
2010-04-30 12:30:00	MSFT	Stock	30.68	30.71	30.52	30.57	3083377.0
2010-04-30 13:00:00	MSFT	Stock	30.57	30.74	30.57	30.665	3198594.0
2010-04-30 13:30:00	MSFT	Stock	30.67	30.78	30.64	30.67	2317205.0
2010-04-30 14:00:00	MSFT	Stock	30.67	30.78	30.64	30.76	2173610.0
2010-04-30 14:30:00	MSFT	Stock	30.751	30.765	30.65	30.65	3138362.0
2010-04-30 15:00:00	MSFT	Stock	30.65	30.76	30.6	30.64	4935378.0
2010-04-30 15:30:00	MSFT	Stock	30.64	30.73	30.53	30.54	9715747.0
2010-04-30 16:00:00	MSFT	Stock	30.54	30.737	30.53	30.62	4207903.0
2010-04-30 16:30:00	MSFT	Stock	30.54	30.871	30.54	30.55	47312.0

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

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