PREVIEW / stock_30min / 2009-10-29

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-29.parquet
  size:    1.4 MB
  rows:    74,679
  symbols: 3,402

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-29 04:00:00	AAPL	Stock	6.8214	6.8214	6.8214	6.8214	2800.0
2009-10-29 04:30:00	AAPL	Stock	6.8214	6.8214	6.7986	6.7986	14000.0
2009-10-29 05:00:00	AAPL	Stock	6.8214	6.8232	6.8093	6.8232	55776.0
2009-10-29 05:30:00	AAPL	Stock	6.8232	6.8232	6.8232	6.8232	5908.0
2009-10-29 06:00:00	AAPL	Stock	6.835	6.835	6.835	6.835	2800.0
2009-10-29 06:30:00	AAPL	Stock	6.8389	6.8393	6.8214	6.8382	50092.0
2009-10-29 07:00:00	AAPL	Stock	6.8304	6.8571	6.8304	6.8571	101472.0
2009-10-29 07:30:00	AAPL	Stock	6.8521	6.8571	6.8321	6.8561	127876.0
2009-10-29 08:00:00	AAPL	Stock	6.8393	6.8661	6.8393	6.8507	1207640.0
2009-10-29 08:30:00	AAPL	Stock	6.8521	6.9936	6.8521	6.9911	10694572.0
2009-10-29 09:00:00	AAPL	Stock	6.99	6.9954	6.9536	6.9593	3518340.0
2009-10-29 09:30:00	AAPL	Stock	6.9596	6.9643	6.8621	6.9393	111085072.0
2009-10-29 10:00:00	AAPL	Stock	6.9421	6.9982	6.9389	6.9418	81237520.0
2009-10-29 10:30:00	AAPL	Stock	6.9425	6.9879	6.9346	6.9857	40858524.0
2009-10-29 11:00:00	AAPL	Stock	6.9857	6.9925	6.9664	6.975	27981240.0
2009-10-29 11:30:00	AAPL	Stock	6.9761	6.9893	6.9621	6.9721	24038280.0
2009-10-29 12:00:00	AAPL	Stock	6.9721	6.9889	6.9696	6.985	20266120.0
2009-10-29 12:30:00	AAPL	Stock	6.9864	6.9893	6.9743	6.9818	21036876.0
2009-10-29 13:00:00	AAPL	Stock	6.9818	6.9839	6.9486	6.9521	21798112.0
2009-10-29 13:30:00	AAPL	Stock	6.9525	6.9786	6.9521	6.974	23120664.0
2009-10-29 14:00:00	AAPL	Stock	6.9739	6.9854	6.9611	6.9646	19851076.0
2009-10-29 14:30:00	AAPL	Stock	6.9661	7.0071	6.9643	7.0071	32836580.0
2009-10-29 15:00:00	AAPL	Stock	7.0068	7.025	6.9961	7.0114	39964260.0
2009-10-29 15:30:00	AAPL	Stock	7.0111	7.0289	7.0032	7.0139	65543604.0
2009-10-29 16:00:00	AAPL	Stock	7.0136	7.0186	6.9936	7.0139	6498744.0
2009-10-29 16:30:00	AAPL	Stock	7.0164	7.0246	7.0125	7.0189	1474060.0
2009-10-29 17:00:00	AAPL	Stock	7.0146	7.0212	7.0146	7.0189	46928.0
2009-10-29 17:30:00	AAPL	Stock	7.0189	7.025	7.0179	7.0179	119392.0
2009-10-29 18:00:00	AAPL	Stock	7.02	7.0339	7.0125	7.0304	920612.0
2009-10-29 18:30:00	AAPL	Stock	7.0293	7.0339	7.0282	7.0321	155708.0
2009-10-29 19:00:00	AAPL	Stock	7.0321	7.0357	7.0321	7.0339	172956.0
2009-10-29 19:30:00	AAPL	Stock	7.0354	7.0396	7.0354	7.0357	189728.0
2009-10-29 06:30:00	MSFT	Stock	28.05	28.05	28.05	28.05	400.0
2009-10-29 08:00:00	MSFT	Stock	28.14	28.14	28.05	28.08	9904.0
2009-10-29 08:30:00	MSFT	Stock	28.17	28.3	28.05	28.3	77229.0
2009-10-29 09:00:00	MSFT	Stock	28.34	28.35	28.06	28.07	177073.0
2009-10-29 09:30:00	MSFT	Stock	28.08	28.19	27.85	27.99	7697968.0
2009-10-29 10:00:00	MSFT	Stock	28.0	28.14	27.96	28.05	4743341.0
2009-10-29 10:30:00	MSFT	Stock	28.055	28.08	27.98	28.08	3857456.0
2009-10-29 11:00:00	MSFT	Stock	28.06	28.11	28.01	28.03	3316702.0
2009-10-29 11:30:00	MSFT	Stock	28.025	28.06	27.93	27.98	4865118.0
2009-10-29 12:00:00	MSFT	Stock	27.98	28.02	27.93	27.97	5049816.0
2009-10-29 12:30:00	MSFT	Stock	27.97	28.222	27.96	28.15	4091294.0
2009-10-29 13:00:00	MSFT	Stock	28.16	28.32	28.14	28.32	2763887.0
2009-10-29 13:30:00	MSFT	Stock	28.32	28.41	28.26	28.41	3237859.0
2009-10-29 14:00:00	MSFT	Stock	28.4	28.41	28.3	28.35	3421120.0
2009-10-29 14:30:00	MSFT	Stock	28.35	28.41	28.33	28.4	2774348.0
2009-10-29 15:00:00	MSFT	Stock	28.39	28.4	28.24	28.26	4804262.0
2009-10-29 15:30:00	MSFT	Stock	28.25	28.29	28.12	28.22	8734818.0
2009-10-29 16:00:00	MSFT	Stock	28.22	28.284	28.058	28.15	1960936.0

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

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