PREVIEW / stock_30min / 2008-03-13

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-13.parquet
  size:    1.2 MB
  rows:    70,140
  symbols: 3,270

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
2008-03-13 04:00:00	AAPL	Stock	4.4732	4.4732	4.4643	4.4643	25200.0
2008-03-13 04:30:00	AAPL	Stock	4.4554	4.4554	4.4554	4.4554	5600.0
2008-03-13 05:00:00	AAPL	Stock	4.4375	4.4375	4.4375	4.4375	8400.0
2008-03-13 06:00:00	AAPL	Stock	4.4318	4.4318	4.4318	4.4318	16800.0
2008-03-13 07:00:00	AAPL	Stock	4.4314	4.4375	4.4311	4.4311	44380.0
2008-03-13 07:30:00	AAPL	Stock	4.4321	4.4321	4.4239	4.4286	180600.0
2008-03-13 08:00:00	AAPL	Stock	4.4389	4.4539	4.4264	4.4321	1879808.0
2008-03-13 08:30:00	AAPL	Stock	4.4268	4.4389	4.4186	4.4211	2604280.0
2008-03-13 09:00:00	AAPL	Stock	4.4214	4.4407	4.4207	4.4343	2001020.0
2008-03-13 09:30:00	AAPL	Stock	4.4325	4.4575	4.4014	4.4221	139650392.0
2008-03-13 10:00:00	AAPL	Stock	4.4221	4.4661	4.4111	4.4375	106198260.0
2008-03-13 10:30:00	AAPL	Stock	4.4375	4.4393	4.3929	4.415	81338348.0
2008-03-13 11:00:00	AAPL	Stock	4.4157	4.4543	4.4057	4.4425	98985712.0
2008-03-13 11:30:00	AAPL	Stock	4.4449	4.4861	4.4393	4.4832	81063360.0
2008-03-13 12:00:00	AAPL	Stock	4.4832	4.5075	4.4475	4.4677	73694824.0
2008-03-13 12:30:00	AAPL	Stock	4.4664	4.4786	4.4414	4.4639	48499780.0
2008-03-13 13:00:00	AAPL	Stock	4.4639	4.5357	4.4564	4.5271	79213288.0
2008-03-13 13:30:00	AAPL	Stock	4.5279	4.5754	4.5143	4.5557	93287208.0
2008-03-13 14:00:00	AAPL	Stock	4.5529	4.5814	4.5514	4.57	86928240.0
2008-03-13 14:30:00	AAPL	Stock	4.5707	4.5836	4.5364	4.5836	74782680.0
2008-03-13 15:00:00	AAPL	Stock	4.5839	4.6204	4.5768	4.6125	109922148.0
2008-03-13 15:30:00	AAPL	Stock	4.6121	4.625	4.5425	4.5693	142852556.0
2008-03-13 16:00:00	AAPL	Stock	4.5693	4.5864	4.4929	4.5714	37644544.0
2008-03-13 16:30:00	AAPL	Stock	4.5714	4.5786	4.5693	4.575	752780.0
2008-03-13 17:00:00	AAPL	Stock	4.5693	4.5786	4.5693	4.575	450772.0
2008-03-13 17:30:00	AAPL	Stock	4.575	4.5821	4.5696	4.5718	737996.0
2008-03-13 18:00:00	AAPL	Stock	4.5732	4.5786	4.5718	4.5786	352996.0
2008-03-13 18:30:00	AAPL	Stock	4.5736	4.5964	4.5736	4.5918	1326080.0
2008-03-13 19:00:00	AAPL	Stock	4.5946	4.5946	4.5896	4.5896	250432.0
2008-03-13 19:30:00	AAPL	Stock	4.5893	4.5961	4.5879	4.5961	247856.0
2008-03-13 07:00:00	MSFT	Stock	28.34	28.34	28.32	28.32	1300.0
2008-03-13 07:30:00	MSFT	Stock	28.35	28.35	28.34	28.34	2248.0
2008-03-13 08:00:00	MSFT	Stock	28.35	28.41	28.29	28.34	11217.0
2008-03-13 08:30:00	MSFT	Stock	28.34	28.4	28.32	28.4	10800.0
2008-03-13 09:00:00	MSFT	Stock	28.39	28.7	28.38	28.7	68434.0
2008-03-13 09:30:00	MSFT	Stock	28.69	28.73	28.34	28.57	6962373.0
2008-03-13 10:00:00	MSFT	Stock	28.57	28.68	28.36	28.46	7973392.0
2008-03-13 10:30:00	MSFT	Stock	28.46	28.485	28.16	28.37	5413913.0
2008-03-13 11:00:00	MSFT	Stock	28.37	28.78	28.36	28.64	7861568.0
2008-03-13 11:30:00	MSFT	Stock	28.64	28.72	28.51	28.575	4552840.0
2008-03-13 12:00:00	MSFT	Stock	28.58	28.71	28.53	28.56	3531488.0
2008-03-13 12:30:00	MSFT	Stock	28.56	28.64	28.43	28.49	3979081.0
2008-03-13 13:00:00	MSFT	Stock	28.49	28.85	28.46	28.82	4014509.0
2008-03-13 13:30:00	MSFT	Stock	28.82	28.9	28.75	28.84	5099563.0
2008-03-13 14:00:00	MSFT	Stock	28.84	28.99	28.8	28.98	5510438.0
2008-03-13 14:30:00	MSFT	Stock	28.98	28.99	28.75	28.82	6796669.0
2008-03-13 15:00:00	MSFT	Stock	28.82	28.9	28.63	28.785	8111433.0
2008-03-13 15:30:00	MSFT	Stock	28.792	28.84	28.54	28.62	10422426.0
2008-03-13 16:00:00	MSFT	Stock	28.62	28.781	28.55	28.59	4100525.0
2008-03-13 16:30:00	MSFT	Stock	28.62	28.63	28.58	28.6	39865.0

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

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