PREVIEW / stock_30min / 2007-02-09

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-09.parquet
  size:    978 KB
  rows:    52,677
  symbols: 2,504

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-02-09 06:00:00	AAPL	Stock	3.0646	3.0646	3.0646	3.0646	14000.0
2007-02-09 06:30:00	AAPL	Stock	3.0625	3.0786	3.0625	3.075	30800.0
2007-02-09 07:00:00	AAPL	Stock	3.0754	3.0754	3.0636	3.0668	77000.0
2007-02-09 07:30:00	AAPL	Stock	3.0621	3.0714	3.0607	3.0607	145600.0
2007-02-09 08:00:00	AAPL	Stock	3.0693	3.0707	3.0536	3.0589	2610608.0
2007-02-09 08:30:00	AAPL	Stock	3.0604	3.0614	3.0579	3.0607	1350888.0
2007-02-09 09:00:00	AAPL	Stock	3.0621	3.0779	3.0589	3.0679	1624000.0
2007-02-09 09:30:00	AAPL	Stock	3.0671	3.0786	3.0475	3.05	90550376.0
2007-02-09 10:00:00	AAPL	Stock	3.0493	3.0554	3.0396	3.04	78444520.0
2007-02-09 10:30:00	AAPL	Stock	3.0396	3.0407	3.0111	3.0154	110845420.0
2007-02-09 11:00:00	AAPL	Stock	3.0154	3.03	3.015	3.0289	53296628.0
2007-02-09 11:30:00	AAPL	Stock	3.0289	3.035	3.0236	3.0271	43216488.0
2007-02-09 12:00:00	AAPL	Stock	3.0271	3.0289	3.0161	3.0179	30121644.0
2007-02-09 12:30:00	AAPL	Stock	3.0175	3.025	3.0011	3.0029	56626528.0
2007-02-09 13:00:00	AAPL	Stock	3.0025	3.0118	2.9986	3.0071	52089072.0
2007-02-09 13:30:00	AAPL	Stock	3.0071	3.0079	2.9761	2.9882	78244544.0
2007-02-09 14:00:00	AAPL	Stock	2.9882	2.9914	2.9746	2.9875	50492204.0
2007-02-09 14:30:00	AAPL	Stock	2.9875	2.9886	2.9718	2.9811	49604492.0
2007-02-09 15:00:00	AAPL	Stock	2.9807	2.9875	2.975	2.9861	52462648.0
2007-02-09 15:30:00	AAPL	Stock	2.9861	2.9893	2.9736	2.9736	83649748.0
2007-02-09 16:00:00	AAPL	Stock	2.9739	2.9804	2.9382	2.9707	16041816.0
2007-02-09 16:30:00	AAPL	Stock	2.9714	2.9721	2.9707	2.9714	290584.0
2007-02-09 17:00:00	AAPL	Stock	2.9718	2.9729	2.9714	2.9718	155848.0
2007-02-09 17:30:00	AAPL	Stock	2.9718	2.975	2.9714	2.975	149884.0
2007-02-09 18:00:00	AAPL	Stock	2.975	2.9761	2.9732	2.9761	150640.0
2007-02-09 18:30:00	AAPL	Stock	2.975	2.9779	2.975	2.9768	172200.0
2007-02-09 19:00:00	AAPL	Stock	2.9768	2.9779	2.9761	2.9761	163520.0
2007-02-09 19:30:00	AAPL	Stock	2.9761	2.9779	2.9761	2.9775	141120.0
2007-02-09 07:30:00	MSFT	Stock	29.31	29.31	29.31	29.31	7774.0
2007-02-09 08:00:00	MSFT	Stock	29.31	29.45	29.31	29.35	22208.0
2007-02-09 08:30:00	MSFT	Stock	29.34	29.35	29.34	29.35	16684.0
2007-02-09 09:00:00	MSFT	Stock	29.34	29.38	29.26	29.35	154708.0
2007-02-09 09:30:00	MSFT	Stock	29.35	29.4	29.25	29.29	8262909.0
2007-02-09 10:00:00	MSFT	Stock	29.28	29.32	29.25	29.3	3234175.0
2007-02-09 10:30:00	MSFT	Stock	29.29	29.31	29.23	29.25	6138853.0
2007-02-09 11:00:00	MSFT	Stock	29.25	29.3	29.25	29.29	2754287.0
2007-02-09 11:30:00	MSFT	Stock	29.3	29.31	29.27	29.28	1296436.0
2007-02-09 12:00:00	MSFT	Stock	29.28	29.29	29.25	29.25	2517715.0
2007-02-09 12:30:00	MSFT	Stock	29.25	29.32	29.22	29.23	8260896.0
2007-02-09 13:00:00	MSFT	Stock	29.23	29.26	29.2	29.23	5664466.0
2007-02-09 13:30:00	MSFT	Stock	29.24	29.24	29.05	29.092	9350036.0
2007-02-09 14:00:00	MSFT	Stock	29.09	29.35	28.95	29.04	4237224.0
2007-02-09 14:30:00	MSFT	Stock	29.04	29.08	28.94	29.06	5012369.0
2007-02-09 15:00:00	MSFT	Stock	29.06	29.09	28.99	29.01	3824705.0
2007-02-09 15:30:00	MSFT	Stock	29.01	29.04	28.93	28.94	6597536.0
2007-02-09 16:00:00	MSFT	Stock	28.93	29.0	28.93	28.96	320319.0
2007-02-09 16:30:00	MSFT	Stock	28.95	28.95	28.94	28.95	8460.0
2007-02-09 17:00:00	MSFT	Stock	28.94	29.257	28.94	28.94	13721.0
2007-02-09 17:30:00	MSFT	Stock	28.95	28.95	28.94	28.94	4100.0
2007-02-09 18:00:00	MSFT	Stock	28.95	28.95	28.95	28.95	1009.0

> showing 50 of 52,677 rows — these rows as CSV

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