PREVIEW / stock_30min / 2007-10-26

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-26.parquet
  size:    1.2 MB
  rows:    67,791
  symbols: 3,152

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-10-26 05:00:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	2800.0
2007-10-26 05:30:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	2800.0
2007-10-26 06:00:00	AAPL	Stock	6.6018	6.6018	6.6018	6.6018	14000.0
2007-10-26 06:30:00	AAPL	Stock	6.6061	6.6061	6.6061	6.6061	31472.0
2007-10-26 07:00:00	AAPL	Stock	6.6071	6.6146	6.5918	6.6071	196336.0
2007-10-26 07:30:00	AAPL	Stock	6.6004	6.6071	6.5714	6.5714	1129100.0
2007-10-26 08:00:00	AAPL	Stock	6.5786	6.5943	6.5443	6.5821	2643396.0
2007-10-26 08:30:00	AAPL	Stock	6.5821	6.5996	6.5804	6.5893	2057216.0
2007-10-26 09:00:00	AAPL	Stock	6.5925	6.6196	6.5893	6.6143	3774008.0
2007-10-26 09:30:00	AAPL	Stock	6.6175	6.6204	6.5314	6.5504	111938064.0
2007-10-26 10:00:00	AAPL	Stock	6.5482	6.5911	6.5357	6.5807	67803204.0
2007-10-26 10:30:00	AAPL	Stock	6.5796	6.5975	6.5661	6.5868	58663892.0
2007-10-26 11:00:00	AAPL	Stock	6.5868	6.6036	6.5696	6.5761	54941040.0
2007-10-26 11:30:00	AAPL	Stock	6.5757	6.5854	6.5575	6.5689	39137756.0
2007-10-26 12:00:00	AAPL	Stock	6.5679	6.5893	6.5589	6.5846	38000900.0
2007-10-26 12:30:00	AAPL	Stock	6.585	6.6	6.5846	6.5939	35491232.0
2007-10-26 13:00:00	AAPL	Stock	6.5932	6.6071	6.5861	6.6007	30525236.0
2007-10-26 13:30:00	AAPL	Stock	6.6007	6.6157	6.5911	6.6061	52976924.0
2007-10-26 14:00:00	AAPL	Stock	6.6057	6.6139	6.6	6.6053	49190820.0
2007-10-26 14:30:00	AAPL	Stock	6.6046	6.6104	6.5882	6.5918	44379160.0
2007-10-26 15:00:00	AAPL	Stock	6.5918	6.6032	6.5779	6.5975	40696908.0
2007-10-26 15:30:00	AAPL	Stock	6.5986	6.6071	6.5768	6.5964	63921116.0
2007-10-26 16:00:00	AAPL	Stock	6.5964	6.6017	6.5807	6.5964	7977872.0
2007-10-26 16:30:00	AAPL	Stock	6.5932	6.5964	6.576	6.5864	446348.0
2007-10-26 17:00:00	AAPL	Stock	6.5864	6.5925	6.5839	6.5893	263508.0
2007-10-26 17:30:00	AAPL	Stock	6.5864	6.5893	6.5857	6.5857	119196.0
2007-10-26 18:00:00	AAPL	Stock	6.5821	6.5857	6.5811	6.5843	173908.0
2007-10-26 18:30:00	AAPL	Stock	6.5857	6.5857	6.5821	6.5857	170576.0
2007-10-26 19:00:00	AAPL	Stock	6.5857	6.5893	6.5839	6.5893	200396.0
2007-10-26 19:30:00	AAPL	Stock	6.5893	6.5911	6.5857	6.5904	119616.0
2007-10-26 04:30:00	MSFT	Stock	35.14	35.14	35.05	35.05	25000.0
2007-10-26 05:00:00	MSFT	Stock	35.11	35.11	35.11	35.11	1000.0
2007-10-26 06:00:00	MSFT	Stock	35.25	35.37	35.25	35.3	14040.0
2007-10-26 06:30:00	MSFT	Stock	35.3	35.3	35.3	35.3	1100.0
2007-10-26 07:00:00	MSFT	Stock	35.37	36.07	35.37	35.9	473600.0
2007-10-26 07:30:00	MSFT	Stock	35.9	39.95	35.9	36.05	858889.0
2007-10-26 08:00:00	MSFT	Stock	36.05	36.55	35.75	36.43	9052323.0
2007-10-26 08:30:00	MSFT	Stock	36.42	36.42	36.03	36.08	2579346.0
2007-10-26 09:00:00	MSFT	Stock	36.07	36.28	35.8	36.01	6293072.0
2007-10-26 09:30:00	MSFT	Stock	36.02	36.05	35.0	35.3	73382827.0
2007-10-26 10:00:00	MSFT	Stock	35.3	36.0	35.3	35.59	28198466.0
2007-10-26 10:30:00	MSFT	Stock	35.6	35.6	35.28	35.372	20770198.0
2007-10-26 11:00:00	MSFT	Stock	35.37	35.6	35.28	35.36	13117488.0
2007-10-26 11:30:00	MSFT	Stock	35.35	35.38	35.08	35.09	18178912.0
2007-10-26 12:00:00	MSFT	Stock	35.11	35.29	34.99	35.01	14718822.0
2007-10-26 12:30:00	MSFT	Stock	35.01	35.12	34.9	35.08	14680713.0
2007-10-26 13:00:00	MSFT	Stock	35.07	35.08	34.82	34.87	10904224.0
2007-10-26 13:30:00	MSFT	Stock	34.88	34.93	34.62	34.78	12655341.0
2007-10-26 14:00:00	MSFT	Stock	34.78	35.04	34.74	34.89	11172366.0
2007-10-26 14:30:00	MSFT	Stock	34.89	34.9	34.56	34.83	13210644.0

> showing 50 of 67,791 rows — these rows as CSV

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