PREVIEW / stock_30min / 2009-07-08

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-07-08.parquet
  size:    1.3 MB
  rows:    69,819
  symbols: 3,313

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-07-08 07:00:00	AAPL	Stock	4.85	4.8571	4.85	4.8571	73836.0
2009-07-08 07:30:00	AAPL	Stock	4.8571	4.8661	4.8475	4.8571	26992.0
2009-07-08 08:00:00	AAPL	Stock	4.8489	4.8571	4.8393	4.8525	243768.0
2009-07-08 08:30:00	AAPL	Stock	4.85	4.85	4.8286	4.8329	320572.0
2009-07-08 09:00:00	AAPL	Stock	4.8375	4.8493	4.8339	4.8446	394632.0
2009-07-08 09:30:00	AAPL	Stock	4.8543	4.8868	4.8111	4.8461	71707720.0
2009-07-08 10:00:00	AAPL	Stock	4.845	4.8857	4.8414	4.8652	45389764.0
2009-07-08 10:30:00	AAPL	Stock	4.8668	4.8746	4.8432	4.8432	32093152.0
2009-07-08 11:00:00	AAPL	Stock	4.8432	4.8441	4.8007	4.8107	44790900.0
2009-07-08 11:30:00	AAPL	Stock	4.8107	4.8568	4.8097	4.8414	36397984.0
2009-07-08 12:00:00	AAPL	Stock	4.8411	4.8457	4.8089	4.8154	29646344.0
2009-07-08 12:30:00	AAPL	Stock	4.815	4.8464	4.8129	4.8386	22669164.0
2009-07-08 13:00:00	AAPL	Stock	4.8386	4.8796	4.8357	4.8721	36199296.0
2009-07-08 13:30:00	AAPL	Stock	4.8718	4.8807	4.8539	4.8554	22763608.0
2009-07-08 14:00:00	AAPL	Stock	4.8561	4.8617	4.8286	4.8304	26195680.0
2009-07-08 14:30:00	AAPL	Stock	4.8304	4.8661	4.8168	4.8593	43568840.0
2009-07-08 15:00:00	AAPL	Stock	4.8593	4.8929	4.8464	4.8782	56121240.0
2009-07-08 15:30:00	AAPL	Stock	4.8786	4.93	4.8775	4.9014	82791436.0
2009-07-08 16:00:00	AAPL	Stock	4.9011	4.9147	4.8548	4.9018	13762532.0
2009-07-08 16:30:00	AAPL	Stock	4.9007	4.9157	4.9007	4.9157	1033956.0
2009-07-08 17:00:00	AAPL	Stock	4.9107	4.9179	4.9007	4.9175	73080.0
2009-07-08 17:30:00	AAPL	Stock	4.9171	4.9179	4.9107	4.9157	40684.0
2009-07-08 18:00:00	AAPL	Stock	4.9082	4.9082	4.9007	4.9071	651168.0
2009-07-08 18:30:00	AAPL	Stock	4.9064	4.9125	4.9064	4.9121	67900.0
2009-07-08 19:00:00	AAPL	Stock	4.9143	4.9143	4.9071	4.9071	320600.0
2009-07-08 20:00:00	AAPL	Stock	4.82	4.82	4.82	4.82	8400.0
2009-07-08 07:00:00	MSFT	Stock	22.56	22.56	22.56	22.56	300.0
2009-07-08 07:30:00	MSFT	Stock	22.47	22.57	22.47	22.57	2148.0
2009-07-08 08:00:00	MSFT	Stock	22.55	22.55	22.28	22.35	46857.0
2009-07-08 08:30:00	MSFT	Stock	22.35	22.37	22.29	22.34	50620.0
2009-07-08 09:00:00	MSFT	Stock	22.34	22.39	22.26	22.26	63182.0
2009-07-08 09:30:00	MSFT	Stock	22.31	22.33	22.1	22.19	9014043.0
2009-07-08 10:00:00	MSFT	Stock	22.18	22.46	22.17	22.35	7833409.0
2009-07-08 10:30:00	MSFT	Stock	22.35	22.35	22.23	22.24	3934613.0
2009-07-08 11:00:00	MSFT	Stock	22.23	22.24	22.08	22.09	5312826.0
2009-07-08 11:30:00	MSFT	Stock	22.08	22.18	22.07	22.1	3828487.0
2009-07-08 12:00:00	MSFT	Stock	22.093	22.1	22.0	22.05	3931854.0
2009-07-08 12:30:00	MSFT	Stock	22.04	22.2	22.04	22.17	2686804.0
2009-07-08 13:00:00	MSFT	Stock	22.17	22.35	22.16	22.35	4287807.0
2009-07-08 13:30:00	MSFT	Stock	22.35	22.4	22.3	22.37	3126657.0
2009-07-08 14:00:00	MSFT	Stock	22.38	22.39	22.29	22.34	3161803.0
2009-07-08 14:30:00	MSFT	Stock	22.34	22.49	22.28	22.462	3320525.0
2009-07-08 15:00:00	MSFT	Stock	22.47	22.55	22.42	22.49	5231079.0
2009-07-08 15:30:00	MSFT	Stock	22.5	22.69	22.48	22.58	11432905.0
2009-07-08 16:00:00	MSFT	Stock	22.56	22.64	22.232	22.6	3504569.0
2009-07-08 16:30:00	MSFT	Stock	22.6	22.6	22.56	22.58	256751.0
2009-07-08 17:00:00	MSFT	Stock	22.56	22.61	22.56	22.61	13313.0
2009-07-08 17:30:00	MSFT	Stock	22.6	22.65	22.6	22.65	1600.0
2009-07-08 18:00:00	MSFT	Stock	22.65	22.65	22.58	22.58	1300.0
2009-07-08 19:00:00	MSFT	Stock	22.6	22.6	22.59	22.59	760.0

> showing 50 of 69,819 rows — these rows as CSV

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