PREVIEW / stock_30min / 2009-01-06

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-06.parquet
  size:    1.3 MB
  rows:    70,652
  symbols: 3,329

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
2009-01-06 05:30:00	AAPL	Stock	3.3925	3.3925	3.3925	3.3925	5600.0
2009-01-06 06:00:00	AAPL	Stock	3.4161	3.4161	3.4161	3.4161	19600.0
2009-01-06 07:00:00	AAPL	Stock	3.4357	3.4643	3.4214	3.425	1016624.0
2009-01-06 07:30:00	AAPL	Stock	3.4268	3.4357	3.4232	3.435	484176.0
2009-01-06 08:00:00	AAPL	Stock	3.4346	3.4414	3.4214	3.4286	3860360.0
2009-01-06 08:30:00	AAPL	Stock	3.4271	3.4321	3.4143	3.4196	3006304.0
2009-01-06 09:00:00	AAPL	Stock	3.42	3.4386	3.4179	3.4243	4449844.0
2009-01-06 09:30:00	AAPL	Stock	3.4239	3.4489	3.4029	3.4296	129548104.0
2009-01-06 10:00:00	AAPL	Stock	3.4293	3.4704	3.42	3.4604	123782148.0
2009-01-06 10:30:00	AAPL	Stock	3.4604	3.4611	3.4214	3.4275	76788740.0
2009-01-06 11:00:00	AAPL	Stock	3.4282	3.4321	3.4061	3.4079	59372432.0
2009-01-06 11:30:00	AAPL	Stock	3.4086	3.43	3.4086	3.4211	44340604.0
2009-01-06 12:00:00	AAPL	Stock	3.4221	3.4361	3.4132	3.4211	45704512.0
2009-01-06 12:30:00	AAPL	Stock	3.4211	3.4568	3.4196	3.4411	70979972.0
2009-01-06 13:00:00	AAPL	Stock	3.4406	3.4418	3.3804	3.3911	148288252.0
2009-01-06 13:30:00	AAPL	Stock	3.3911	3.3961	3.3257	3.3389	153365884.0
2009-01-06 14:00:00	AAPL	Stock	3.3396	3.3571	3.3143	3.3493	109959388.0
2009-01-06 14:30:00	AAPL	Stock	3.3486	3.3618	3.3429	3.355	70216188.0
2009-01-06 15:00:00	AAPL	Stock	3.3557	3.3571	3.3071	3.3093	101838884.0
2009-01-06 15:30:00	AAPL	Stock	3.3096	3.3296	3.2996	3.3214	116042276.0
2009-01-06 16:00:00	AAPL	Stock	3.3229	3.4179	3.3061	3.3114	12196380.0
2009-01-06 16:30:00	AAPL	Stock	3.3111	3.3221	3.3061	3.3154	1021580.0
2009-01-06 17:00:00	AAPL	Stock	3.3171	3.3196	3.3125	3.3143	302568.0
2009-01-06 17:30:00	AAPL	Stock	3.3146	3.3157	3.3086	3.3125	124040.0
2009-01-06 18:00:00	AAPL	Stock	3.3139	3.3221	3.3096	3.3096	2404360.0
2009-01-06 18:30:00	AAPL	Stock	3.3096	3.3121	3.3071	3.3082	100576.0
2009-01-06 19:00:00	AAPL	Stock	3.3089	3.3107	3.3089	3.3089	85064.0
2009-01-06 19:30:00	AAPL	Stock	3.3118	3.3118	3.25	3.3068	284620.0
2009-01-06 07:00:00	MSFT	Stock	20.52	20.52	20.52	20.52	120.0
2009-01-06 07:30:00	MSFT	Stock	20.57	20.85	20.57	20.85	27476.0
2009-01-06 08:00:00	MSFT	Stock	20.52	20.81	20.52	20.76	948005.0
2009-01-06 08:30:00	MSFT	Stock	20.74	20.76	20.74	20.76	5450.0
2009-01-06 09:00:00	MSFT	Stock	20.76	20.79	20.69	20.76	15015.0
2009-01-06 09:30:00	MSFT	Stock	20.77	20.94	20.73	20.9	7625887.0
2009-01-06 10:00:00	MSFT	Stock	20.91	20.96	20.69	20.772	6384685.0
2009-01-06 10:30:00	MSFT	Stock	20.77	20.96	20.76	20.94	3101268.0
2009-01-06 11:00:00	MSFT	Stock	20.94	20.98	20.8	20.8	3148146.0
2009-01-06 11:30:00	MSFT	Stock	20.808	20.91	20.79	20.85	2786273.0
2009-01-06 12:00:00	MSFT	Stock	20.85	20.9	20.79	20.82	2205792.0
2009-01-06 12:30:00	MSFT	Stock	20.812	20.9	20.812	20.89	3301663.0
2009-01-06 13:00:00	MSFT	Stock	20.89	20.9	20.72	20.77	3012183.0
2009-01-06 13:30:00	MSFT	Stock	20.77	20.87	20.72	20.78	2697647.0
2009-01-06 14:00:00	MSFT	Stock	20.79	20.89	20.69	20.89	3528030.0
2009-01-06 14:30:00	MSFT	Stock	20.888	21.0	20.88	20.97	2999688.0
2009-01-06 15:00:00	MSFT	Stock	20.96	20.99	20.66	20.74	5328032.0
2009-01-06 15:30:00	MSFT	Stock	20.75	20.79	20.61	20.76	8211093.0
2009-01-06 16:00:00	MSFT	Stock	20.75	20.906	20.68	20.76	2149899.0
2009-01-06 16:30:00	MSFT	Stock	20.69	20.76	20.67	20.67	128098.0
2009-01-06 17:00:00	MSFT	Stock	20.68	20.76	20.68	20.7	2031.0
2009-01-06 17:30:00	MSFT	Stock	20.75	20.75	20.67	20.68	5723.0

> showing 50 of 70,652 rows — these rows as CSV

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