PREVIEW / stock_30min / 2007-11-28

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-28.parquet
  size:    1.2 MB
  rows:    70,769
  symbols: 3,222

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-11-28 06:30:00	AAPL	Stock	6.2532	6.2714	6.2496	6.2714	39200.0
2007-11-28 07:00:00	AAPL	Stock	6.285	6.2946	6.2768	6.2946	163800.0
2007-11-28 07:30:00	AAPL	Stock	6.2964	6.3186	6.2893	6.3107	696164.0
2007-11-28 08:00:00	AAPL	Stock	6.3107	6.3254	6.2929	6.3036	4795644.0
2007-11-28 08:30:00	AAPL	Stock	6.3011	6.3121	6.2911	6.3018	3239012.0
2007-11-28 09:00:00	AAPL	Stock	6.3018	6.3239	6.2911	6.3164	4812696.0
2007-11-28 09:30:00	AAPL	Stock	6.3168	6.3214	6.2679	6.2946	183627808.0
2007-11-28 10:00:00	AAPL	Stock	6.2947	6.335	6.2625	6.3343	131018132.0
2007-11-28 10:30:00	AAPL	Stock	6.3336	6.3729	6.3218	6.3475	113506400.0
2007-11-28 11:00:00	AAPL	Stock	6.3468	6.3671	6.3379	6.3661	47554024.0
2007-11-28 11:30:00	AAPL	Stock	6.3661	6.3921	6.3575	6.3914	68077352.0
2007-11-28 12:00:00	AAPL	Stock	6.3918	6.41	6.3768	6.3889	68353656.0
2007-11-28 12:30:00	AAPL	Stock	6.3886	6.3982	6.3818	6.3871	45350900.0
2007-11-28 13:00:00	AAPL	Stock	6.3868	6.4071	6.3768	6.4057	45961020.0
2007-11-28 13:30:00	AAPL	Stock	6.4057	6.4246	6.3993	6.4171	59111836.0
2007-11-28 14:00:00	AAPL	Stock	6.4171	6.4286	6.4104	6.4175	70177996.0
2007-11-28 14:30:00	AAPL	Stock	6.4179	6.4279	6.3993	6.4157	56212156.0
2007-11-28 15:00:00	AAPL	Stock	6.4157	6.45	6.41	6.4286	90437592.0
2007-11-28 15:30:00	AAPL	Stock	6.4286	6.4429	6.3911	6.4332	125287568.0
2007-11-28 16:00:00	AAPL	Stock	6.4354	6.4418	6.369	6.4364	24873072.0
2007-11-28 16:30:00	AAPL	Stock	6.4375	6.4411	6.369	6.4386	532588.0
2007-11-28 17:00:00	AAPL	Stock	6.4389	6.4407	6.2432	6.4364	3049172.0
2007-11-28 17:30:00	AAPL	Stock	6.4364	6.4407	6.2432	6.4407	2083844.0
2007-11-28 18:00:00	AAPL	Stock	6.4386	6.4425	6.2432	6.44	1195096.0
2007-11-28 18:30:00	AAPL	Stock	6.4389	6.4389	6.4371	6.4375	172480.0
2007-11-28 19:00:00	AAPL	Stock	6.4375	6.4439	6.4375	6.4418	388360.0
2007-11-28 19:30:00	AAPL	Stock	6.4418	6.4464	6.4411	6.4461	281708.0
2007-11-28 07:00:00	MSFT	Stock	33.11	33.35	33.11	33.35	10662.0
2007-11-28 07:30:00	MSFT	Stock	33.4	33.4	33.33	33.37	21391.0
2007-11-28 08:00:00	MSFT	Stock	33.37	33.44	33.29	33.35	269880.0
2007-11-28 08:30:00	MSFT	Stock	33.29	33.42	33.28	33.41	55638.0
2007-11-28 09:00:00	MSFT	Stock	33.4	33.45	33.3	33.37	76366.0
2007-11-28 09:30:00	MSFT	Stock	33.38	33.39	33.08	33.14	8318488.0
2007-11-28 10:00:00	MSFT	Stock	33.14	33.22	32.9	33.21	7858756.0
2007-11-28 10:30:00	MSFT	Stock	33.2	33.5	33.18	33.44	8165905.0
2007-11-28 11:00:00	MSFT	Stock	33.442	33.45	33.35	33.4	4063739.0
2007-11-28 11:30:00	MSFT	Stock	33.407	33.41	33.25	33.35	4399029.0
2007-11-28 12:00:00	MSFT	Stock	33.35	33.41	33.23	33.29	4419755.0
2007-11-28 12:30:00	MSFT	Stock	33.287	33.32	33.22	33.27	3092019.0
2007-11-28 13:00:00	MSFT	Stock	33.27	33.36	33.23	33.29	3820470.0
2007-11-28 13:30:00	MSFT	Stock	33.3	33.4	33.25	33.36	4280635.0
2007-11-28 14:00:00	MSFT	Stock	33.36	33.55	33.29	33.49	5833223.0
2007-11-28 14:30:00	MSFT	Stock	33.49	33.62	33.47	33.59	4985315.0
2007-11-28 15:00:00	MSFT	Stock	33.59	33.89	33.58	33.81	8144149.0
2007-11-28 15:30:00	MSFT	Stock	33.81	33.81	33.53	33.69	13690668.0
2007-11-28 16:00:00	MSFT	Stock	33.69	33.712	33.29	33.6	5557606.0
2007-11-28 16:30:00	MSFT	Stock	33.06	33.7	33.06	33.65	1029475.0
2007-11-28 17:00:00	MSFT	Stock	33.65	33.65	33.06	33.65	79112.0
2007-11-28 17:30:00	MSFT	Stock	33.7	33.7	33.32	33.63	411728.0
2007-11-28 18:00:00	MSFT	Stock	33.62	33.62	33.61	33.61	910.0

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

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