PREVIEW / stock_30min / 2009-10-28

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-28.parquet
  size:    1.4 MB
  rows:    73,230
  symbols: 3,409

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-10-28 04:00:00	AAPL	Stock	7.0	7.0	6.9957	6.9957	28084.0
2009-10-28 04:30:00	AAPL	Stock	7.0304	7.0304	6.995	6.995	12712.0
2009-10-28 05:00:00	AAPL	Stock	6.9929	7.0229	6.9929	6.9929	16100.0
2009-10-28 06:00:00	AAPL	Stock	6.9857	6.9857	6.9857	6.9857	22120.0
2009-10-28 06:30:00	AAPL	Stock	6.9857	7.0071	6.9857	6.9982	38164.0
2009-10-28 07:00:00	AAPL	Stock	7.0211	7.0214	6.9921	6.995	68320.0
2009-10-28 07:30:00	AAPL	Stock	6.9936	7.0268	6.9918	7.0268	142016.0
2009-10-28 08:00:00	AAPL	Stock	7.0282	7.0432	7.0182	7.0257	629216.0
2009-10-28 08:30:00	AAPL	Stock	7.0286	7.0757	7.0232	7.0643	703752.0
2009-10-28 09:00:00	AAPL	Stock	7.0646	7.0893	7.0446	7.0493	3076640.0
2009-10-28 09:30:00	AAPL	Stock	7.0543	7.07	6.9771	7.0346	126680680.0
2009-10-28 10:00:00	AAPL	Stock	7.0332	7.0721	6.9932	7.0032	77737660.0
2009-10-28 10:30:00	AAPL	Stock	7.0029	7.0193	6.8707	6.9236	114425080.0
2009-10-28 11:00:00	AAPL	Stock	6.9225	6.9604	6.9018	6.9439	57915648.0
2009-10-28 11:30:00	AAPL	Stock	6.9432	6.955	6.9179	6.9318	33628532.0
2009-10-28 12:00:00	AAPL	Stock	6.9321	6.9532	6.8964	6.9179	28174412.0
2009-10-28 12:30:00	AAPL	Stock	6.9157	6.9336	6.9007	6.9029	33647796.0
2009-10-28 13:00:00	AAPL	Stock	6.9034	6.9429	6.825	6.9332	57561476.0
2009-10-28 13:30:00	AAPL	Stock	6.9339	6.9461	6.9107	6.914	22669108.0
2009-10-28 14:00:00	AAPL	Stock	6.9143	6.9196	6.8675	6.8875	43876420.0
2009-10-28 14:30:00	AAPL	Stock	6.8875	6.9136	6.8518	6.8982	57212540.0
2009-10-28 15:00:00	AAPL	Stock	6.8979	6.9224	6.8539	6.8618	52772916.0
2009-10-28 15:30:00	AAPL	Stock	6.8614	6.8807	6.835	6.8668	86990624.0
2009-10-28 16:00:00	AAPL	Stock	6.8711	7.1114	6.861	6.8693	11216268.0
2009-10-28 16:30:00	AAPL	Stock	6.8679	6.8725	6.8668	6.8679	354732.0
2009-10-28 17:00:00	AAPL	Stock	6.8671	6.8714	6.8621	6.8621	147336.0
2009-10-28 17:30:00	AAPL	Stock	6.86	6.8714	6.8446	6.8446	464324.0
2009-10-28 18:00:00	AAPL	Stock	6.85	6.8714	6.8179	6.8214	1252132.0
2009-10-28 18:30:00	AAPL	Stock	6.82	6.8225	6.8143	6.8143	431340.0
2009-10-28 19:00:00	AAPL	Stock	6.8143	6.8211	6.8061	6.8143	549584.0
2009-10-28 19:30:00	AAPL	Stock	6.8204	6.8264	6.8179	6.825	330820.0
2009-10-28 05:30:00	MSFT	Stock	28.38	28.38	28.38	28.38	100.0
2009-10-28 06:30:00	MSFT	Stock	28.29	28.29	28.29	28.29	375.0
2009-10-28 07:00:00	MSFT	Stock	28.29	28.29	28.25	28.25	525.0
2009-10-28 07:30:00	MSFT	Stock	28.3	28.31	28.26	28.27	6600.0
2009-10-28 08:00:00	MSFT	Stock	28.37	28.44	28.35	28.44	10607.0
2009-10-28 08:30:00	MSFT	Stock	28.41	28.44	28.35	28.39	20823.0
2009-10-28 09:00:00	MSFT	Stock	28.61	28.61	28.14	28.22	92687.0
2009-10-28 09:30:00	MSFT	Stock	28.24	28.7	28.1	28.592	7834195.0
2009-10-28 10:00:00	MSFT	Stock	28.59	28.77	28.44	28.602	7621671.0
2009-10-28 10:30:00	MSFT	Stock	28.58	28.67	28.41	28.41	5864870.0
2009-10-28 11:00:00	MSFT	Stock	28.41	28.44	28.3	28.402	5843166.0
2009-10-28 11:30:00	MSFT	Stock	28.41	28.43	28.34	28.35	2689102.0
2009-10-28 12:00:00	MSFT	Stock	28.35	28.43	28.17	28.22	3889243.0
2009-10-28 12:30:00	MSFT	Stock	28.22	28.24	28.02	28.13	5731195.0
2009-10-28 13:00:00	MSFT	Stock	28.135	28.38	28.13	28.312	3306942.0
2009-10-28 13:30:00	MSFT	Stock	28.29	28.32	28.19	28.22	1992181.0
2009-10-28 14:00:00	MSFT	Stock	28.225	28.305	28.11	28.12	4021675.0
2009-10-28 14:30:00	MSFT	Stock	28.125	28.19	27.98	28.1	5499445.0
2009-10-28 15:00:00	MSFT	Stock	28.108	28.16	28.0	28.04	4531069.0

> showing 50 of 73,230 rows — these rows as CSV

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