PREVIEW / stock_30min / 2008-10-13

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-13.parquet
  size:    1.3 MB
  rows:    74,906
  symbols: 3,369

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-10-13 05:00:00	AAPL	Stock	3.6786	3.6786	3.6571	3.6607	35000.0
2008-10-13 05:30:00	AAPL	Stock	3.6786	3.6786	3.6786	3.6786	25480.0
2008-10-13 06:30:00	AAPL	Stock	3.6786	3.6786	3.6786	3.6786	10080.0
2008-10-13 07:00:00	AAPL	Stock	3.6607	3.6786	3.6429	3.6696	473172.0
2008-10-13 07:30:00	AAPL	Stock	3.6607	3.6786	3.6379	3.6468	631904.0
2008-10-13 08:00:00	AAPL	Stock	3.6429	3.6914	3.6129	3.6821	3416448.0
2008-10-13 08:30:00	AAPL	Stock	3.6864	3.7311	3.6786	3.7179	5055288.0
2008-10-13 09:00:00	AAPL	Stock	3.7179	3.7411	3.625	3.7343	9650564.0
2008-10-13 09:30:00	AAPL	Stock	3.7339	3.7857	3.6196	3.6671	268103752.0
2008-10-13 10:00:00	AAPL	Stock	3.6668	3.7143	3.6079	3.705	120751316.0
2008-10-13 10:30:00	AAPL	Stock	3.7064	3.7321	3.6825	3.6893	93134076.0
2008-10-13 11:00:00	AAPL	Stock	3.6889	3.7225	3.6821	3.7014	66185672.0
2008-10-13 11:30:00	AAPL	Stock	3.7025	3.7393	3.7025	3.7271	69281940.0
2008-10-13 12:00:00	AAPL	Stock	3.7271	3.7807	3.7193	3.7754	84784140.0
2008-10-13 12:30:00	AAPL	Stock	3.776	3.7857	3.7554	3.7564	71433180.0
2008-10-13 13:00:00	AAPL	Stock	3.7564	3.78	3.7443	3.7589	47670700.0
2008-10-13 13:30:00	AAPL	Stock	3.7589	3.7786	3.725	3.7397	64251460.0
2008-10-13 14:00:00	AAPL	Stock	3.7404	3.7486	3.6818	3.685	69682844.0
2008-10-13 14:30:00	AAPL	Stock	3.685	3.81	3.6771	3.8046	134855812.0
2008-10-13 15:00:00	AAPL	Stock	3.8046	3.9014	3.7939	3.8743	168034664.0
2008-10-13 15:30:00	AAPL	Stock	3.8746	3.9475	3.8564	3.9421	203554176.0
2008-10-13 16:00:00	AAPL	Stock	3.9443	3.9643	3.7626	3.9336	45675588.0
2008-10-13 16:30:00	AAPL	Stock	3.9321	3.9643	3.7824	3.95	2439976.0
2008-10-13 17:00:00	AAPL	Stock	3.9496	3.9496	3.9343	3.9443	707476.0
2008-10-13 17:30:00	AAPL	Stock	3.9414	3.9586	3.9414	3.9586	331100.0
2008-10-13 18:00:00	AAPL	Stock	3.9593	3.9593	3.9496	3.95	160804.0
2008-10-13 18:30:00	AAPL	Stock	3.9486	3.9564	3.9486	3.9536	209048.0
2008-10-13 19:00:00	AAPL	Stock	3.9536	3.985	3.9536	3.9825	197316.0
2008-10-13 19:30:00	AAPL	Stock	3.9854	4.0625	3.985	4.0625	983164.0
2008-10-13 06:30:00	MSFT	Stock	22.73	22.73	22.73	22.73	200.0
2008-10-13 07:00:00	MSFT	Stock	22.7	22.75	22.6	22.75	2888.0
2008-10-13 07:30:00	MSFT	Stock	22.84	22.84	22.62	22.65	9043.0
2008-10-13 08:00:00	MSFT	Stock	22.66	22.9	22.62	22.77	55407.0
2008-10-13 08:30:00	MSFT	Stock	22.77	22.9	22.65	22.71	132559.0
2008-10-13 09:00:00	MSFT	Stock	22.73	22.95	22.67	22.9	255833.0
2008-10-13 09:30:00	MSFT	Stock	22.89	23.22	22.63	23.12	15022843.0
2008-10-13 10:00:00	MSFT	Stock	23.12	23.5	22.9	23.44	9626944.0
2008-10-13 10:30:00	MSFT	Stock	23.45	23.63	23.0	23.508	8468161.0
2008-10-13 11:00:00	MSFT	Stock	23.505	23.7	23.46	23.63	7267030.0
2008-10-13 11:30:00	MSFT	Stock	23.63	23.98	23.62	23.82	9067867.0
2008-10-13 12:00:00	MSFT	Stock	23.82	24.1	23.71	24.1	7940196.0
2008-10-13 12:30:00	MSFT	Stock	24.1	24.24	24.0	24.07	7530359.0
2008-10-13 13:00:00	MSFT	Stock	24.05	24.11	23.94	24.01	5353991.0
2008-10-13 13:30:00	MSFT	Stock	24.01	24.11	23.84	23.87	5895363.0
2008-10-13 14:00:00	MSFT	Stock	23.86	24.04	23.81	23.82	6521446.0
2008-10-13 14:30:00	MSFT	Stock	23.82	24.25	23.79	24.24	10614481.0
2008-10-13 15:00:00	MSFT	Stock	24.242	24.65	24.2	24.47	12554871.0
2008-10-13 15:30:00	MSFT	Stock	24.47	25.5	24.44	25.49	26077324.0
2008-10-13 16:00:00	MSFT	Stock	25.49	25.5	22.948	25.42	11053146.0
2008-10-13 16:30:00	MSFT	Stock	25.42	25.5	24.811	25.35	74549.0

> showing 50 of 74,906 rows — these rows as CSV

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