PREVIEW / stock_30min / 2009-02-10

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-10.parquet
  size:    1.3 MB
  rows:    69,422
  symbols: 3,317

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-02-10 04:00:00	AAPL	Stock	3.6307	3.6325	3.6307	3.6325	7000.0
2009-02-10 07:00:00	AAPL	Stock	3.6357	3.6357	3.6357	3.6357	11200.0
2009-02-10 07:30:00	AAPL	Stock	3.6404	3.6404	3.6404	3.6404	2800.0
2009-02-10 08:00:00	AAPL	Stock	3.655	3.655	3.6307	3.6336	185724.0
2009-02-10 08:30:00	AAPL	Stock	3.6339	3.6429	3.6143	3.6143	994980.0
2009-02-10 09:00:00	AAPL	Stock	3.615	3.625	3.6107	3.6146	1030176.0
2009-02-10 09:30:00	AAPL	Stock	3.6143	3.66	3.6	3.645	89956748.0
2009-02-10 10:00:00	AAPL	Stock	3.645	3.6554	3.6011	3.6011	66445764.0
2009-02-10 10:30:00	AAPL	Stock	3.6014	3.6161	3.595	3.6107	49928032.0
2009-02-10 11:00:00	AAPL	Stock	3.6107	3.6221	3.5739	3.5946	76042008.0
2009-02-10 11:30:00	AAPL	Stock	3.5946	3.5961	3.5271	3.5529	91442904.0
2009-02-10 12:00:00	AAPL	Stock	3.5529	3.5804	3.54	3.5446	42620172.0
2009-02-10 12:30:00	AAPL	Stock	3.5439	3.5507	3.5307	3.5386	29223992.0
2009-02-10 13:00:00	AAPL	Stock	3.5386	3.5386	3.4929	3.4957	58803500.0
2009-02-10 13:30:00	AAPL	Stock	3.4954	3.5064	3.4882	3.5014	40540220.0
2009-02-10 14:00:00	AAPL	Stock	3.5004	3.515	3.485	3.4857	40522076.0
2009-02-10 14:30:00	AAPL	Stock	3.4854	3.5025	3.4679	3.4854	62704852.0
2009-02-10 15:00:00	AAPL	Stock	3.4854	3.5071	3.4736	3.4871	51992248.0
2009-02-10 15:30:00	AAPL	Stock	3.4871	3.5071	3.4664	3.4986	101085264.0
2009-02-10 16:00:00	AAPL	Stock	3.4986	3.5511	3.4936	3.4975	23051896.0
2009-02-10 16:30:00	AAPL	Stock	3.4975	3.5	3.4929	3.4929	5878292.0
2009-02-10 17:00:00	AAPL	Stock	3.4989	3.4989	3.4964	3.4964	53144.0
2009-02-10 17:30:00	AAPL	Stock	3.4961	3.5018	3.4961	3.5018	99372.0
2009-02-10 18:00:00	AAPL	Stock	3.5018	3.5018	3.4939	3.5	10871728.0
2009-02-10 18:30:00	AAPL	Stock	3.5018	3.5075	3.5	3.5075	51968.0
2009-02-10 19:00:00	AAPL	Stock	3.5025	3.5075	3.5	3.5075	82264.0
2009-02-10 19:30:00	AAPL	Stock	3.5079	3.5143	3.5071	3.5143	63896.0
2009-02-10 08:00:00	MSFT	Stock	19.44	19.44	19.4	19.4	1345.0
2009-02-10 08:30:00	MSFT	Stock	19.4	19.43	19.2	19.23	54408.0
2009-02-10 09:00:00	MSFT	Stock	19.23	19.32	19.23	19.28	5458.0
2009-02-10 09:30:00	MSFT	Stock	19.25	19.8	19.24	19.612	8527165.0
2009-02-10 10:00:00	MSFT	Stock	19.61	19.68	19.54	19.61	5300801.0
2009-02-10 10:30:00	MSFT	Stock	19.61	19.71	19.59	19.6	3889002.0
2009-02-10 11:00:00	MSFT	Stock	19.592	19.68	19.3	19.46	9738700.0
2009-02-10 11:30:00	MSFT	Stock	19.46	19.46	19.05	19.24	10264159.0
2009-02-10 12:00:00	MSFT	Stock	19.25	19.35	19.19	19.21	4086093.0
2009-02-10 12:30:00	MSFT	Stock	19.205	19.24	19.1	19.19	2843430.0
2009-02-10 13:00:00	MSFT	Stock	19.19	19.2	18.98	18.98	4579587.0
2009-02-10 13:30:00	MSFT	Stock	18.98	19.07	18.94	19.03	3136791.0
2009-02-10 14:00:00	MSFT	Stock	19.03	19.1	18.94	18.97	2815385.0
2009-02-10 14:30:00	MSFT	Stock	18.97	19.02	18.86	18.86	4087166.0
2009-02-10 15:00:00	MSFT	Stock	18.87	19.03	18.81	18.85	6108696.0
2009-02-10 15:30:00	MSFT	Stock	18.86	18.93	18.7	18.8	13418653.0
2009-02-10 16:00:00	MSFT	Stock	18.79	19.228	18.78	18.89	4224946.0
2009-02-10 16:30:00	MSFT	Stock	18.8	18.91	18.8	18.85	610004.0
2009-02-10 17:00:00	MSFT	Stock	18.92	18.92	18.91	18.91	500.0
2009-02-10 17:30:00	MSFT	Stock	18.9	18.9	18.9	18.9	14200.0
2009-02-10 18:00:00	MSFT	Stock	18.8	18.91	18.8	18.91	14677.0
2009-02-10 19:00:00	MSFT	Stock	18.91	18.92	18.91	18.92	1577.0
2009-02-10 19:30:00	MSFT	Stock	18.92	18.99	18.9	18.99	3248.0

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

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