PREVIEW / stock_30min / 2007-11-15

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-15.parquet
  size:    1.2 MB
  rows:    69,310
  symbols: 3,193

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-11-15 04:00:00	AAPL	Stock	5.8946	5.8946	5.8946	5.8946	2800.0
2007-11-15 05:30:00	AAPL	Stock	5.8575	5.8575	5.8471	5.8489	19600.0
2007-11-15 06:00:00	AAPL	Stock	5.8746	5.875	5.8746	5.875	14000.0
2007-11-15 06:30:00	AAPL	Stock	5.8571	5.8571	5.8571	5.8571	28000.0
2007-11-15 07:00:00	AAPL	Stock	5.8571	5.93	5.8571	5.8746	163632.0
2007-11-15 07:30:00	AAPL	Stock	5.875	5.9214	5.875	5.8932	321636.0
2007-11-15 08:00:00	AAPL	Stock	5.8932	6.055	5.8929	6.0289	8307292.0
2007-11-15 08:30:00	AAPL	Stock	6.0264	6.0607	5.9136	5.935	11653516.0
2007-11-15 09:00:00	AAPL	Stock	5.9407	5.9607	5.9075	5.9364	5172440.0
2007-11-15 09:30:00	AAPL	Stock	5.9425	6.0468	5.9189	5.9436	189579096.0
2007-11-15 10:00:00	AAPL	Stock	5.9432	6.015	5.9093	5.9775	133365036.0
2007-11-15 10:30:00	AAPL	Stock	5.9761	6.0357	5.9589	5.99	91523068.0
2007-11-15 11:00:00	AAPL	Stock	5.99	6.0568	5.9764	6.0286	79560348.0
2007-11-15 11:30:00	AAPL	Stock	6.0289	6.0357	5.9889	6.0125	80475556.0
2007-11-15 12:00:00	AAPL	Stock	6.0096	6.0268	5.9857	5.9893	60168192.0
2007-11-15 12:30:00	AAPL	Stock	5.9893	5.9929	5.8786	5.925	106923460.0
2007-11-15 13:00:00	AAPL	Stock	5.925	5.9839	5.9186	5.9475	66665648.0
2007-11-15 13:30:00	AAPL	Stock	5.9471	5.9821	5.9246	5.93	69225016.0
2007-11-15 14:00:00	AAPL	Stock	5.9311	5.9643	5.8929	5.9236	79266516.0
2007-11-15 14:30:00	AAPL	Stock	5.9243	5.9471	5.75	5.75	126638876.0
2007-11-15 15:00:00	AAPL	Stock	5.7525	5.8589	5.725	5.8179	164848908.0
2007-11-15 15:30:00	AAPL	Stock	5.8182	5.8929	5.7429	5.8659	187598796.0
2007-11-15 16:00:00	AAPL	Stock	5.8661	5.9946	5.8482	5.85	16640456.0
2007-11-15 16:30:00	AAPL	Stock	5.8568	5.8915	5.8521	5.8625	491512.0
2007-11-15 17:00:00	AAPL	Stock	5.8625	5.8625	5.8536	5.8607	481320.0
2007-11-15 17:30:00	AAPL	Stock	5.8582	5.8679	5.85	5.8571	8288560.0
2007-11-15 18:00:00	AAPL	Stock	5.8571	5.8607	5.8539	5.8575	189532.0
2007-11-15 18:30:00	AAPL	Stock	5.8625	5.8654	5.8554	5.8625	271180.0
2007-11-15 19:00:00	AAPL	Stock	5.8579	5.8646	5.8579	5.8639	92960.0
2007-11-15 19:30:00	AAPL	Stock	5.8646	5.8646	5.8593	5.86	190204.0
2007-11-15 05:00:00	MSFT	Stock	33.77	33.77	33.77	33.77	400.0
2007-11-15 07:00:00	MSFT	Stock	33.75	33.75	33.75	33.75	600.0
2007-11-15 08:00:00	MSFT	Stock	33.9	33.93	33.77	33.8	8709.0
2007-11-15 08:30:00	MSFT	Stock	33.81	33.93	33.78	33.93	99032.0
2007-11-15 09:00:00	MSFT	Stock	33.8	33.85	33.74	33.78	43027.0
2007-11-15 09:30:00	MSFT	Stock	33.8	33.84	33.59	33.75	7619241.0
2007-11-15 10:00:00	MSFT	Stock	33.74	34.1	33.67	34.0	4473139.0
2007-11-15 10:30:00	MSFT	Stock	33.99	34.08	33.84	33.87	3587544.0
2007-11-15 11:00:00	MSFT	Stock	33.87	33.97	33.79	33.855	2738206.0
2007-11-15 11:30:00	MSFT	Stock	33.86	33.86	33.7	33.81	3937428.0
2007-11-15 12:00:00	MSFT	Stock	33.82	33.96	33.78	33.829	2159538.0
2007-11-15 12:30:00	MSFT	Stock	33.82	33.91	33.78	33.88	2881046.0
2007-11-15 13:00:00	MSFT	Stock	33.88	34.04	33.82	33.87	2759872.0
2007-11-15 13:30:00	MSFT	Stock	33.88	34.04	33.82	33.82	2363327.0
2007-11-15 14:00:00	MSFT	Stock	33.82	33.93	33.78	33.89	3222261.0
2007-11-15 14:30:00	MSFT	Stock	33.889	33.93	33.69	33.7	4932886.0
2007-11-15 15:00:00	MSFT	Stock	33.71	33.85	33.68	33.74	5364838.0
2007-11-15 15:30:00	MSFT	Stock	33.74	33.84	33.55	33.7	11713681.0
2007-11-15 16:00:00	MSFT	Stock	33.7	33.836	33.65	33.65	4368978.0
2007-11-15 16:30:00	MSFT	Stock	33.76	33.776	33.66	33.66	57585.0

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

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