PREVIEW / stock_30min / 2009-12-15

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-15.parquet
  size:    1.4 MB
  rows:    74,378
  symbols: 3,432

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-12-15 04:30:00	AAPL	Stock	6.9989	6.9989	6.9989	6.9989	2800.0
2009-12-15 07:30:00	AAPL	Stock	7.0018	7.0018	6.9989	7.0004	18200.0
2009-12-15 08:00:00	AAPL	Stock	7.0179	7.0179	6.9936	7.0054	515284.0
2009-12-15 08:30:00	AAPL	Stock	7.0011	7.0071	6.9821	7.0064	1246560.0
2009-12-15 09:00:00	AAPL	Stock	7.0064	7.0075	6.9839	6.9907	826672.0
2009-12-15 09:30:00	AAPL	Stock	6.9939	7.0004	6.9507	6.9689	54679996.0
2009-12-15 10:00:00	AAPL	Stock	6.9682	7.0139	6.9614	7.0029	42213416.0
2009-12-15 10:30:00	AAPL	Stock	7.0039	7.0539	6.9986	7.0343	40180196.0
2009-12-15 11:00:00	AAPL	Stock	7.035	7.0386	6.9914	6.9986	31248252.0
2009-12-15 11:30:00	AAPL	Stock	6.9979	7.0214	6.9964	7.0032	20079276.0
2009-12-15 12:00:00	AAPL	Stock	7.0027	7.0139	6.9907	6.9982	12278056.0
2009-12-15 12:30:00	AAPL	Stock	6.9986	7.01	6.9954	7.0	9366420.0
2009-12-15 13:00:00	AAPL	Stock	6.9993	7.0046	6.9793	6.9854	15542632.0
2009-12-15 13:30:00	AAPL	Stock	6.9857	6.9914	6.9725	6.9761	20143172.0
2009-12-15 14:00:00	AAPL	Stock	6.9761	6.9893	6.9736	6.9779	11886224.0
2009-12-15 14:30:00	AAPL	Stock	6.9789	6.9807	6.9557	6.9582	25621288.0
2009-12-15 15:00:00	AAPL	Stock	6.9589	6.9696	6.9293	6.94	27226360.0
2009-12-15 15:30:00	AAPL	Stock	6.9404	6.9411	6.9025	6.9346	61294716.0
2009-12-15 16:00:00	AAPL	Stock	6.935	6.9819	6.9278	6.9354	6036324.0
2009-12-15 16:30:00	AAPL	Stock	6.9346	6.9375	6.9325	6.9375	270508.0
2009-12-15 17:00:00	AAPL	Stock	6.9393	7.035	6.9343	6.9375	565740.0
2009-12-15 17:30:00	AAPL	Stock	6.9393	6.9432	6.9393	6.9432	48440.0
2009-12-15 18:00:00	AAPL	Stock	6.9396	6.9493	6.9346	6.9464	562324.0
2009-12-15 18:30:00	AAPL	Stock	6.9482	6.9496	6.9421	6.9421	15652.0
2009-12-15 19:00:00	AAPL	Stock	6.9429	6.9446	6.9429	6.9446	13720.0
2009-12-15 19:30:00	AAPL	Stock	6.9429	6.9429	6.9339	6.9393	85960.0
2009-12-15 07:30:00	MSFT	Stock	29.95	29.95	29.95	29.95	1500.0
2009-12-15 08:00:00	MSFT	Stock	30.11	30.11	29.96	29.99	7061.0
2009-12-15 08:30:00	MSFT	Stock	29.97	29.97	29.92	29.93	12400.0
2009-12-15 09:00:00	MSFT	Stock	29.93	30.0	29.89	29.89	21743.0
2009-12-15 09:30:00	MSFT	Stock	29.89	30.01	29.88	30.0	3632734.0
2009-12-15 10:00:00	MSFT	Stock	30.01	30.16	30.0	30.14	3446559.0
2009-12-15 10:30:00	MSFT	Stock	30.14	30.2	30.08	30.183	4169228.0
2009-12-15 11:00:00	MSFT	Stock	30.19	30.2	30.17	30.18	1809289.0
2009-12-15 11:30:00	MSFT	Stock	30.19	30.21	30.18	30.2	1935409.0
2009-12-15 12:00:00	MSFT	Stock	30.195	30.2	30.08	30.1	2782500.0
2009-12-15 12:30:00	MSFT	Stock	30.1	30.11	30.07	30.09	2335951.0
2009-12-15 13:00:00	MSFT	Stock	30.09	30.18	30.07	30.085	1632998.0
2009-12-15 13:30:00	MSFT	Stock	30.08	30.12	30.07	30.082	1740147.0
2009-12-15 14:00:00	MSFT	Stock	30.08	30.1	30.062	30.085	1647595.0
2009-12-15 14:30:00	MSFT	Stock	30.08	30.15	30.07	30.15	2881926.0
2009-12-15 15:00:00	MSFT	Stock	30.14	30.16	30.03	30.04	6980145.0
2009-12-15 15:30:00	MSFT	Stock	30.04	30.08	29.98	30.01	6904999.0
2009-12-15 16:00:00	MSFT	Stock	30.01	30.159	29.889	30.04	1487611.0
2009-12-15 16:30:00	MSFT	Stock	30.07	30.113	29.998	30.01	54881.0
2009-12-15 17:00:00	MSFT	Stock	30.02	30.11	30.01	30.01	532600.0
2009-12-15 17:30:00	MSFT	Stock	30.07	30.07	30.07	30.07	100.0
2009-12-15 18:00:00	MSFT	Stock	30.07	30.07	30.02	30.02	1899.0
2009-12-15 18:30:00	MSFT	Stock	30.01	30.06	30.01	30.01	2505.0
2009-12-15 20:00:00	MSFT	Stock	30.21	30.21	30.08	30.08	26249.0

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

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