PREVIEW / stock_30min / 2008-03-20

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-20.parquet
  size:    1.3 MB
  rows:    72,156
  symbols: 3,269

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-20 04:00:00	AAPL	Stock	4.6107	4.6107	4.6107	4.6107	2800.0
2008-03-20 05:30:00	AAPL	Stock	4.6346	4.6346	4.6346	4.6346	28000.0
2008-03-20 06:30:00	AAPL	Stock	4.6314	4.6314	4.6314	4.6314	14000.0
2008-03-20 07:00:00	AAPL	Stock	4.6339	4.6357	4.6339	4.6339	15400.0
2008-03-20 07:30:00	AAPL	Stock	4.6482	4.6564	4.6482	4.65	43512.0
2008-03-20 08:00:00	AAPL	Stock	4.65	4.6571	4.6429	4.6507	630756.0
2008-03-20 08:30:00	AAPL	Stock	4.6436	4.6464	4.615	4.6186	1501108.0
2008-03-20 09:00:00	AAPL	Stock	4.6211	4.6804	4.6179	4.6804	7135744.0
2008-03-20 09:30:00	AAPL	Stock	4.6746	4.69	4.6375	4.6654	165873092.0
2008-03-20 10:00:00	AAPL	Stock	4.665	4.6868	4.6439	4.6693	77387688.0
2008-03-20 10:30:00	AAPL	Stock	4.6689	4.6732	4.6507	4.6721	51621556.0
2008-03-20 11:00:00	AAPL	Stock	4.6718	4.6725	4.645	4.6625	45928372.0
2008-03-20 11:30:00	AAPL	Stock	4.6632	4.6643	4.6136	4.62	53652928.0
2008-03-20 12:00:00	AAPL	Stock	4.62	4.6479	4.62	4.6389	36888096.0
2008-03-20 12:30:00	AAPL	Stock	4.6393	4.6518	4.6211	4.6411	32212264.0
2008-03-20 13:00:00	AAPL	Stock	4.6411	4.6568	4.6357	4.6543	23950612.0
2008-03-20 13:30:00	AAPL	Stock	4.6546	4.6821	4.6525	4.6754	54659976.0
2008-03-20 14:00:00	AAPL	Stock	4.6761	4.6857	4.6625	4.6857	43635004.0
2008-03-20 14:30:00	AAPL	Stock	4.6857	4.7361	4.6807	4.7268	74838484.0
2008-03-20 15:00:00	AAPL	Stock	4.7264	4.7389	4.7111	4.7229	70645456.0
2008-03-20 15:30:00	AAPL	Stock	4.7229	4.7604	4.7054	4.7596	92694308.0
2008-03-20 16:00:00	AAPL	Stock	4.7532	4.7614	4.6781	4.7589	48335756.0
2008-03-20 16:30:00	AAPL	Stock	4.7596	4.7636	4.6798	4.7596	7529732.0
2008-03-20 17:00:00	AAPL	Stock	4.7593	4.7671	4.7593	4.7661	776804.0
2008-03-20 17:30:00	AAPL	Stock	4.765	4.7661	4.682	4.7604	822836.0
2008-03-20 18:00:00	AAPL	Stock	4.7589	4.7604	4.7514	4.7529	264012.0
2008-03-20 18:30:00	AAPL	Stock	4.7525	4.7543	4.7514	4.7539	189840.0
2008-03-20 19:00:00	AAPL	Stock	4.7521	4.7543	4.7411	4.75	131124.0
2008-03-20 19:30:00	AAPL	Stock	4.7496	4.7543	4.7432	4.7529	281568.0
2008-03-20 07:30:00	MSFT	Stock	28.68	28.68	28.65	28.66	1300.0
2008-03-20 08:00:00	MSFT	Stock	28.75	28.75	28.45	28.75	61426.0
2008-03-20 08:30:00	MSFT	Stock	28.7	28.7	28.58	28.58	10448.0
2008-03-20 09:00:00	MSFT	Stock	28.6	28.85	28.56	28.72	729499.0
2008-03-20 09:30:00	MSFT	Stock	28.72	29.08	28.59	28.92	5328687.0
2008-03-20 10:00:00	MSFT	Stock	28.93	29.09	28.85	28.97	4059865.0
2008-03-20 10:30:00	MSFT	Stock	28.97	29.0	28.78	28.87	2733879.0
2008-03-20 11:00:00	MSFT	Stock	28.86	28.96	28.77	28.94	2293795.0
2008-03-20 11:30:00	MSFT	Stock	28.94	28.95	28.75	28.778	2196235.0
2008-03-20 12:00:00	MSFT	Stock	28.78	28.9	28.779	28.81	2549574.0
2008-03-20 12:30:00	MSFT	Stock	28.81	28.85	28.74	28.77	2136811.0
2008-03-20 13:00:00	MSFT	Stock	28.78	28.85	28.74	28.84	1158123.0
2008-03-20 13:30:00	MSFT	Stock	28.84	29.01	28.82	28.96	2079470.0
2008-03-20 14:00:00	MSFT	Stock	28.97	29.01	28.89	28.98	2317516.0
2008-03-20 14:30:00	MSFT	Stock	28.97	29.05	28.95	28.99	2525265.0
2008-03-20 15:00:00	MSFT	Stock	28.98	29.12	28.97	29.0	3743915.0
2008-03-20 15:30:00	MSFT	Stock	29.0	29.19	28.92	29.19	7243639.0
2008-03-20 16:00:00	MSFT	Stock	29.19	29.223	28.872	29.22	4417889.0
2008-03-20 16:30:00	MSFT	Stock	29.22	29.23	28.949	29.15	434488.0
2008-03-20 17:00:00	MSFT	Stock	29.18	29.2	29.15	29.175	49065.0
2008-03-20 17:30:00	MSFT	Stock	29.18	29.25	28.974	29.12	4650.0

> showing 50 of 72,156 rows — these rows as CSV

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