PREVIEW / stock_30min / 2010-09-24

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-24.parquet
  size:    1.4 MB
  rows:    75,167
  symbols: 3,486

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-09-24 06:00:00	AAPL	Stock	10.3557	10.3557	10.3554	10.3554	5600.0
2010-09-24 06:30:00	AAPL	Stock	10.3557	10.3557	10.3554	10.3554	14000.0
2010-09-24 07:00:00	AAPL	Stock	10.3557	10.375	10.3557	10.375	70056.0
2010-09-24 07:30:00	AAPL	Stock	10.375	10.3889	10.3679	10.3868	129640.0
2010-09-24 08:00:00	AAPL	Stock	10.375	10.4243	10.37	10.4143	2541840.0
2010-09-24 08:30:00	AAPL	Stock	10.4196	10.4454	10.4193	10.43	4378556.0
2010-09-24 09:00:00	AAPL	Stock	10.4318	10.4461	10.4036	10.4286	6462512.0
2010-09-24 09:30:00	AAPL	Stock	10.4286	10.4832	10.3979	10.4348	143068744.0
2010-09-24 10:00:00	AAPL	Stock	10.4396	10.4679	10.4004	10.4196	81199160.0
2010-09-24 10:30:00	AAPL	Stock	10.4196	10.4493	10.4111	10.4325	43897112.0
2010-09-24 11:00:00	AAPL	Stock	10.4325	10.4489	10.4243	10.4393	36411368.0
2010-09-24 11:30:00	AAPL	Stock	10.4393	10.4657	10.4254	10.4629	37668540.0
2010-09-24 12:00:00	AAPL	Stock	10.4629	10.4654	10.44	10.45	18736312.0
2010-09-24 12:30:00	AAPL	Stock	10.45	10.4618	10.445	10.4532	20066704.0
2010-09-24 13:00:00	AAPL	Stock	10.4536	10.4571	10.4411	10.4514	16470608.0
2010-09-24 13:30:00	AAPL	Stock	10.4516	10.4526	10.4289	10.4329	22674848.0
2010-09-24 14:00:00	AAPL	Stock	10.4343	10.4411	10.3768	10.3982	45441088.0
2010-09-24 14:30:00	AAPL	Stock	10.3979	10.4325	10.395	10.4057	38492972.0
2010-09-24 15:00:00	AAPL	Stock	10.4061	10.4143	10.3839	10.3936	33623688.0
2010-09-24 15:30:00	AAPL	Stock	10.3938	10.4468	10.3829	10.4457	70371700.0
2010-09-24 16:00:00	AAPL	Stock	10.445	10.4464	10.41	10.4361	16937816.0
2010-09-24 16:30:00	AAPL	Stock	10.4364	10.4621	10.3946	10.4618	2774716.0
2010-09-24 17:00:00	AAPL	Stock	10.4607	10.4743	10.4094	10.4689	2573480.0
2010-09-24 17:30:00	AAPL	Stock	10.4679	10.4714	10.4571	10.4714	1381044.0
2010-09-24 18:00:00	AAPL	Stock	10.4711	10.4718	10.4646	10.4654	178724.0
2010-09-24 18:30:00	AAPL	Stock	10.4654	10.4675	10.4575	10.4596	177296.0
2010-09-24 19:00:00	AAPL	Stock	10.4596	10.4607	10.4575	10.46	65800.0
2010-09-24 19:30:00	AAPL	Stock	10.4607	10.4607	10.44	10.4536	514528.0
2010-09-24 05:00:00	MSFT	Stock	24.64	24.64	24.64	24.64	100.0
2010-09-24 05:30:00	MSFT	Stock	24.65	24.65	24.65	24.65	300.0
2010-09-24 07:00:00	MSFT	Stock	24.54	24.61	24.54	24.58	3150.0
2010-09-24 07:30:00	MSFT	Stock	24.58	24.59	24.58	24.58	5676.0
2010-09-24 08:00:00	MSFT	Stock	24.56	24.61	24.52	24.58	26010.0
2010-09-24 08:30:00	MSFT	Stock	24.6	24.65	24.49	24.63	60787.0
2010-09-24 09:00:00	MSFT	Stock	24.61	24.74	24.6	24.64	108387.0
2010-09-24 09:30:00	MSFT	Stock	24.65	24.69	24.58	24.63	6120695.0
2010-09-24 10:00:00	MSFT	Stock	24.62	24.79	24.61	24.716	6662898.0
2010-09-24 10:30:00	MSFT	Stock	24.72	24.745	24.67	24.67	4562910.0
2010-09-24 11:00:00	MSFT	Stock	24.675	24.73	24.64	24.66	2903056.0
2010-09-24 11:30:00	MSFT	Stock	24.658	24.75	24.65	24.72	3137527.0
2010-09-24 12:00:00	MSFT	Stock	24.72	24.75	24.69	24.718	1831074.0
2010-09-24 12:30:00	MSFT	Stock	24.72	24.745	24.69	24.72	1940164.0
2010-09-24 13:00:00	MSFT	Stock	24.72	24.75	24.69	24.7	2292164.0
2010-09-24 13:30:00	MSFT	Stock	24.71	24.74	24.68	24.685	2388921.0
2010-09-24 14:00:00	MSFT	Stock	24.68	24.77	24.68	24.76	2778238.0
2010-09-24 14:30:00	MSFT	Stock	24.77	24.8	24.74	24.75	3420671.0
2010-09-24 15:00:00	MSFT	Stock	24.74	24.75	24.7	24.71	2677783.0
2010-09-24 15:30:00	MSFT	Stock	24.72	24.78	24.69	24.77	7706079.0
2010-09-24 16:00:00	MSFT	Stock	24.78	24.8	24.705	24.785	2754305.0
2010-09-24 16:30:00	MSFT	Stock	24.77	24.77	24.71	24.77	9050.0

> showing 50 of 75,167 rows — these rows as CSV

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