PREVIEW / stock_30min / 2007-03-28

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-28.parquet
  size:    1.0 MB
  rows:    56,011
  symbols: 2,550

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
2007-03-28 07:00:00	AAPL	Stock	3.405	3.4057	3.4036	3.4036	58800.0
2007-03-28 07:30:00	AAPL	Stock	3.4018	3.4018	3.3964	3.3964	98000.0
2007-03-28 08:00:00	AAPL	Stock	3.3982	3.4036	3.3914	3.3979	2352560.0
2007-03-28 08:30:00	AAPL	Stock	3.3961	3.3993	3.3893	3.3929	1699992.0
2007-03-28 09:00:00	AAPL	Stock	3.3896	3.3929	3.3875	3.3875	2120076.0
2007-03-28 09:30:00	AAPL	Stock	3.3886	3.4068	3.3843	3.3896	110740504.0
2007-03-28 10:00:00	AAPL	Stock	3.39	3.4071	3.3879	3.3968	64667540.0
2007-03-28 10:30:00	AAPL	Stock	3.3968	3.3968	3.3786	3.3886	82956552.0
2007-03-28 11:00:00	AAPL	Stock	3.3882	3.3975	3.3857	3.3914	47406436.0
2007-03-28 11:30:00	AAPL	Stock	3.3918	3.3946	3.3893	3.3936	22284836.0
2007-03-28 12:00:00	AAPL	Stock	3.3932	3.3946	3.3668	3.3868	126020832.0
2007-03-28 12:30:00	AAPL	Stock	3.3868	3.3929	3.3821	3.3843	35998004.0
2007-03-28 13:00:00	AAPL	Stock	3.3843	3.3846	3.3761	3.3785	27055196.0
2007-03-28 13:30:00	AAPL	Stock	3.3786	3.385	3.3689	3.3721	42022400.0
2007-03-28 14:00:00	AAPL	Stock	3.3725	3.375	3.3482	3.3561	92209180.0
2007-03-28 14:30:00	AAPL	Stock	3.3554	3.361	3.3343	3.345	91581196.0
2007-03-28 15:00:00	AAPL	Stock	3.345	3.3486	3.3268	3.3418	88536756.0
2007-03-28 15:30:00	AAPL	Stock	3.3418	3.3489	3.3286	3.3289	88457852.0
2007-03-28 16:00:00	AAPL	Stock	3.3293	3.3571	3.3221	3.325	9520308.0
2007-03-28 16:30:00	AAPL	Stock	3.3293	3.3321	3.325	3.3311	1596056.0
2007-03-28 17:00:00	AAPL	Stock	3.3321	3.3339	3.3293	3.3321	5088356.0
2007-03-28 17:30:00	AAPL	Stock	3.3314	3.3314	3.3232	3.3286	319060.0
2007-03-28 18:00:00	AAPL	Stock	3.3257	3.3286	3.3257	3.3286	85260.0
2007-03-28 18:30:00	AAPL	Stock	3.3286	3.3304	3.3286	3.3304	144760.0
2007-03-28 19:00:00	AAPL	Stock	3.3304	3.3304	3.3257	3.3286	132720.0
2007-03-28 19:30:00	AAPL	Stock	3.3286	3.3332	3.3261	3.3332	99120.0
2007-03-28 08:00:00	MSFT	Stock	27.72	27.72	27.64	27.7	7550.0
2007-03-28 08:30:00	MSFT	Stock	27.68	27.68	27.6	27.6	23500.0
2007-03-28 09:00:00	MSFT	Stock	27.6	27.63	27.57	27.57	23422.0
2007-03-28 09:30:00	MSFT	Stock	27.58	27.88	27.4	27.76	4649408.0
2007-03-28 10:00:00	MSFT	Stock	27.76	27.85	27.74	27.79	1802335.0
2007-03-28 10:30:00	MSFT	Stock	27.79	27.79	27.52	27.73	6178492.0
2007-03-28 11:00:00	MSFT	Stock	27.73	27.81	27.65	27.73	2778460.0
2007-03-28 11:30:00	MSFT	Stock	27.73	27.75	27.66	27.7	1421076.0
2007-03-28 12:00:00	MSFT	Stock	27.709	28.0	27.7	27.88	3439226.0
2007-03-28 12:30:00	MSFT	Stock	27.88	27.95	27.85	27.87	1698459.0
2007-03-28 13:00:00	MSFT	Stock	27.87	27.9	27.79	27.86	1336457.0
2007-03-28 13:30:00	MSFT	Stock	27.86	27.95	27.85	27.86	2022463.0
2007-03-28 14:00:00	MSFT	Stock	27.86	27.91	27.72	27.78	3577975.0
2007-03-28 14:30:00	MSFT	Stock	27.77	27.79	27.66	27.7	2989369.0
2007-03-28 15:00:00	MSFT	Stock	27.69	27.79	27.68	27.78	3501488.0
2007-03-28 15:30:00	MSFT	Stock	27.78	27.81	27.63	27.63	8599222.0
2007-03-28 16:00:00	MSFT	Stock	27.63	27.64	27.6	27.64	924954.0
2007-03-28 16:30:00	MSFT	Stock	27.64	27.69	27.64	27.69	520428.0
2007-03-28 17:00:00	MSFT	Stock	27.69	27.69	27.64	27.69	1726121.0
2007-03-28 18:00:00	MSFT	Stock	27.69	27.69	27.69	27.69	4000.0
2007-03-28 18:30:00	MSFT	Stock	27.67	27.67	27.67	27.67	100.0
2007-03-28 19:00:00	MSFT	Stock	27.69	27.69	27.67	27.67	1250.0
2007-03-28 08:30:00	NVDA	Stock	0.491	0.491	0.4908	0.4908	28200.0
2007-03-28 09:00:00	NVDA	Stock	0.4947	0.4947	0.4922	0.4922	84060.0

> showing 50 of 56,011 rows — these rows as CSV

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