PREVIEW / stock_30min / 2006-04-06

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-04-06.parquet
  size:    910 KB
  rows:    48,998
  symbols: 2,211

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
2006-04-06 04:00:00	AAPL	Stock	2.45	2.45	2.45	2.45	32200.0
2006-04-06 04:30:00	AAPL	Stock	2.4518	2.4607	2.4518	2.4607	118104.0
2006-04-06 05:00:00	AAPL	Stock	2.4607	2.4643	2.4607	2.4643	43400.0
2006-04-06 05:30:00	AAPL	Stock	2.4611	2.475	2.4611	2.4664	322952.0
2006-04-06 06:00:00	AAPL	Stock	2.4643	2.4643	2.4554	2.4607	155372.0
2006-04-06 06:30:00	AAPL	Stock	2.4536	2.4536	2.4518	2.4518	114828.0
2006-04-06 07:00:00	AAPL	Stock	2.4536	2.4536	2.4357	2.4464	623084.0
2006-04-06 07:30:00	AAPL	Stock	2.4446	2.4511	2.4414	2.4468	1365560.0
2006-04-06 08:00:00	AAPL	Stock	2.4464	2.4561	2.4243	2.4268	10511116.0
2006-04-06 08:30:00	AAPL	Stock	2.4275	2.4368	2.4243	2.4343	8031968.0
2006-04-06 09:00:00	AAPL	Stock	2.4339	2.4421	2.42	2.4393	9636536.0
2006-04-06 09:30:00	AAPL	Stock	2.4393	2.4821	2.4357	2.4736	432595884.0
2006-04-06 10:00:00	AAPL	Stock	2.4736	2.5	2.4721	2.48	240184112.0
2006-04-06 10:30:00	AAPL	Stock	2.4796	2.4989	2.4643	2.4982	230217904.0
2006-04-06 11:00:00	AAPL	Stock	2.4986	2.5229	2.4918	2.5132	225167432.0
2006-04-06 11:30:00	AAPL	Stock	2.5136	2.5207	2.4971	2.4993	135346736.0
2006-04-06 12:00:00	AAPL	Stock	2.4993	2.5089	2.4907	2.4979	118550600.0
2006-04-06 12:30:00	AAPL	Stock	2.4971	2.5311	2.4914	2.525	131723592.0
2006-04-06 13:00:00	AAPL	Stock	2.5246	2.5518	2.5225	2.5518	165851196.0
2006-04-06 13:30:00	AAPL	Stock	2.5518	2.5657	2.54	2.56	163338476.0
2006-04-06 14:00:00	AAPL	Stock	2.5604	2.5657	2.5511	2.5572	134340808.0
2006-04-06 14:30:00	AAPL	Stock	2.5574	2.5682	2.5479	2.5639	145075784.0
2006-04-06 15:00:00	AAPL	Stock	2.5643	2.5732	2.5325	2.5389	227400264.0
2006-04-06 15:30:00	AAPL	Stock	2.5389	2.5532	2.525	2.5429	246398292.0
2006-04-06 16:00:00	AAPL	Stock	2.5429	2.5714	2.4885	2.5446	7694652.0
2006-04-06 16:30:00	AAPL	Stock	2.5443	2.5471	2.5429	2.5432	1117760.0
2006-04-06 17:00:00	AAPL	Stock	2.5436	2.5446	2.5379	2.5393	648732.0
2006-04-06 17:30:00	AAPL	Stock	2.5393	2.546	2.5375	2.5396	4646488.0
2006-04-06 18:00:00	AAPL	Stock	2.5393	2.5414	2.5393	2.5407	329336.0
2006-04-06 07:00:00	MSFT	Stock	27.7	27.7	27.67	27.67	1214.0
2006-04-06 07:30:00	MSFT	Stock	27.67	27.67	27.65	27.65	386.0
2006-04-06 08:00:00	MSFT	Stock	27.72	27.72	27.65	27.71	2899.0
2006-04-06 08:30:00	MSFT	Stock	27.7	27.7	27.68	27.7	10040.0
2006-04-06 09:00:00	MSFT	Stock	27.7	27.73	27.65	27.65	51914.0
2006-04-06 09:30:00	MSFT	Stock	27.66	27.72	27.64	27.64	3632978.0
2006-04-06 10:00:00	MSFT	Stock	27.64	27.69	27.62	27.63	2144573.0
2006-04-06 10:30:00	MSFT	Stock	27.63	27.7	27.59	27.63	2624488.0
2006-04-06 11:00:00	MSFT	Stock	27.64	27.64	27.54	27.57	2598360.0
2006-04-06 11:30:00	MSFT	Stock	27.57	27.59	27.47	27.47	2594540.0
2006-04-06 12:00:00	MSFT	Stock	27.47	27.5	27.37	27.37	3800188.0
2006-04-06 12:30:00	MSFT	Stock	27.38	27.584	27.37	27.45	2857768.0
2006-04-06 13:00:00	MSFT	Stock	27.45	27.45	27.41	27.43	1988639.0
2006-04-06 13:30:00	MSFT	Stock	27.43	27.54	27.43	27.52	4586219.0
2006-04-06 14:00:00	MSFT	Stock	27.52	27.61	27.46	27.47	5787935.0
2006-04-06 14:30:00	MSFT	Stock	27.47	27.5	27.43	27.45	2637591.0
2006-04-06 15:00:00	MSFT	Stock	27.46	27.65	27.45	27.57	6473671.0
2006-04-06 15:30:00	MSFT	Stock	27.57	27.61	27.52	27.53	6015471.0
2006-04-06 16:00:00	MSFT	Stock	27.52	27.58	27.52	27.53	125621.0
2006-04-06 17:00:00	MSFT	Stock	27.56	27.56	27.56	27.56	900.0
2006-04-06 17:30:00	MSFT	Stock	27.517	27.517	27.517	27.517	490900.0

> showing 50 of 48,998 rows — these rows as CSV

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