PREVIEW / stock_30min / 2009-10-01

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-01.parquet
  size:    1.4 MB
  rows:    75,955
  symbols: 3,379

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-10-01 07:00:00	AAPL	Stock	6.59	6.5982	6.59	6.5982	9660.0
2009-10-01 07:30:00	AAPL	Stock	6.6004	6.6043	6.6	6.6025	51240.0
2009-10-01 08:00:00	AAPL	Stock	6.6204	6.6429	6.6039	6.6386	560840.0
2009-10-01 08:30:00	AAPL	Stock	6.6339	6.6382	6.5982	6.6107	1144612.0
2009-10-01 09:00:00	AAPL	Stock	6.6118	6.6314	6.6104	6.6239	801696.0
2009-10-01 09:30:00	AAPL	Stock	6.6196	6.6507	6.6	6.63	64965460.0
2009-10-01 10:00:00	AAPL	Stock	6.6275	6.6493	6.5639	6.5832	67256700.0
2009-10-01 10:30:00	AAPL	Stock	6.5832	6.5964	6.5536	6.5614	39033904.0
2009-10-01 11:00:00	AAPL	Stock	6.5611	6.5643	6.5218	6.5336	42594580.0
2009-10-01 11:30:00	AAPL	Stock	6.5321	6.5404	6.5121	6.5343	27462288.0
2009-10-01 12:00:00	AAPL	Stock	6.5343	6.5654	6.53	6.5579	28805784.0
2009-10-01 12:30:00	AAPL	Stock	6.5579	6.5625	6.5357	6.5382	15471232.0
2009-10-01 13:00:00	AAPL	Stock	6.5382	6.5393	6.5179	6.5196	29135988.0
2009-10-01 13:30:00	AAPL	Stock	6.5207	6.5382	6.5179	6.5289	28716268.0
2009-10-01 14:00:00	AAPL	Stock	6.5289	6.5421	6.525	6.5386	21219324.0
2009-10-01 14:30:00	AAPL	Stock	6.5368	6.5407	6.52	6.5221	21597744.0
2009-10-01 15:00:00	AAPL	Stock	6.5221	6.5393	6.5121	6.5143	34695052.0
2009-10-01 15:30:00	AAPL	Stock	6.5143	6.5275	6.4536	6.4557	75135368.0
2009-10-01 16:00:00	AAPL	Stock	6.4575	6.5476	6.4414	6.4536	16094596.0
2009-10-01 16:30:00	AAPL	Stock	6.4536	6.4579	6.4364	6.4571	4937492.0
2009-10-01 17:00:00	AAPL	Stock	6.4546	6.4557	6.4429	6.4446	1886472.0
2009-10-01 17:30:00	AAPL	Stock	6.4436	6.4482	6.44	6.44	185920.0
2009-10-01 18:00:00	AAPL	Stock	6.4411	6.4593	6.4371	6.4371	511308.0
2009-10-01 18:30:00	AAPL	Stock	6.4375	6.4386	6.4343	6.4386	140784.0
2009-10-01 19:00:00	AAPL	Stock	6.4393	6.4454	6.4386	6.4396	30800.0
2009-10-01 19:30:00	AAPL	Stock	6.4411	6.4479	6.4393	6.4464	233100.0
2009-10-01 20:00:00	AAPL	Stock	6.6196	6.6196	6.6196	6.6196	17612.0
2009-10-01 04:30:00	MSFT	Stock	25.67	25.67	25.6	25.6	1500.0
2009-10-01 05:00:00	MSFT	Stock	25.55	25.63	25.4	25.4	6789.0
2009-10-01 05:30:00	MSFT	Stock	25.41	25.41	25.41	25.41	100.0
2009-10-01 06:00:00	MSFT	Stock	25.45	25.45	25.45	25.45	5000.0
2009-10-01 06:30:00	MSFT	Stock	25.41	25.53	25.4	25.53	6500.0
2009-10-01 07:00:00	MSFT	Stock	25.46	25.5	25.46	25.5	1300.0
2009-10-01 07:30:00	MSFT	Stock	25.5	25.52	25.45	25.46	2200.0
2009-10-01 08:00:00	MSFT	Stock	25.48	25.89	25.47	25.47	421220.0
2009-10-01 08:30:00	MSFT	Stock	25.47	25.53	25.45	25.46	22367.0
2009-10-01 09:00:00	MSFT	Stock	25.46	25.89	25.32	25.37	234408.0
2009-10-01 09:30:00	MSFT	Stock	25.41	25.47	25.22	25.25	9570701.0
2009-10-01 10:00:00	MSFT	Stock	25.25	25.28	24.89	25.05	10607513.0
2009-10-01 10:30:00	MSFT	Stock	25.05	25.12	25.02	25.057	4702487.0
2009-10-01 11:00:00	MSFT	Stock	25.05	25.06	24.92	24.95	5710908.0
2009-10-01 11:30:00	MSFT	Stock	24.95	25.01	24.92	24.952	3234001.0
2009-10-01 12:00:00	MSFT	Stock	24.95	25.05	24.93	24.953	3020139.0
2009-10-01 12:30:00	MSFT	Stock	24.95	24.96	24.9	24.91	2409023.0
2009-10-01 13:00:00	MSFT	Stock	24.9	24.91	24.8	24.83	3680675.0
2009-10-01 13:30:00	MSFT	Stock	24.84	24.95	24.825	24.9	3081754.0
2009-10-01 14:00:00	MSFT	Stock	24.9	25.0	24.85	25.0	3167526.0
2009-10-01 14:30:00	MSFT	Stock	24.99	25.03	24.93	24.99	3062455.0
2009-10-01 15:00:00	MSFT	Stock	24.98	24.985	24.9	24.94	5135300.0
2009-10-01 15:30:00	MSFT	Stock	24.93	25.02	24.84	24.87	9660370.0

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

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