PREVIEW / stock_30min / 2008-09-26

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-09-26.parquet
  size:    1.2 MB
  rows:    70,433
  symbols: 3,334

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
2008-09-26 05:00:00	AAPL	Stock	4.5643	4.5643	4.5429	4.5429	8400.0
2008-09-26 06:00:00	AAPL	Stock	4.5536	4.5554	4.5357	4.5357	19600.0
2008-09-26 06:30:00	AAPL	Stock	4.5357	4.5357	4.4714	4.5	106708.0
2008-09-26 07:00:00	AAPL	Stock	4.5	4.5	4.4761	4.5	332528.0
2008-09-26 07:30:00	AAPL	Stock	4.5	4.5	4.4764	4.4943	668556.0
2008-09-26 08:00:00	AAPL	Stock	4.4825	4.5036	4.4518	4.4589	3161116.0
2008-09-26 08:30:00	AAPL	Stock	4.4589	4.5437	4.4229	4.4275	6974828.0
2008-09-26 09:00:00	AAPL	Stock	4.4321	4.4789	4.4232	4.4618	6074264.0
2008-09-26 09:30:00	AAPL	Stock	4.4611	4.5536	4.3929	4.5064	187388740.0
2008-09-26 10:00:00	AAPL	Stock	4.5061	4.5404	4.4561	4.4664	114887556.0
2008-09-26 10:30:00	AAPL	Stock	4.4664	4.5161	4.4539	4.4836	78567748.0
2008-09-26 11:00:00	AAPL	Stock	4.4843	4.5257	4.4786	4.4996	59995516.0
2008-09-26 11:30:00	AAPL	Stock	4.5004	4.5357	4.4964	4.5216	60670988.0
2008-09-26 12:00:00	AAPL	Stock	4.5218	4.5289	4.4939	4.525	43052072.0
2008-09-26 12:30:00	AAPL	Stock	4.5246	4.5686	4.5096	4.5543	56587132.0
2008-09-26 13:00:00	AAPL	Stock	4.5549	4.5989	4.545	4.5736	70247436.0
2008-09-26 13:30:00	AAPL	Stock	4.5718	4.5821	4.5164	4.5232	61578916.0
2008-09-26 14:00:00	AAPL	Stock	4.5225	4.53	4.4836	4.485	52654000.0
2008-09-26 14:30:00	AAPL	Stock	4.4839	4.4986	4.4446	4.4618	69565160.0
2008-09-26 15:00:00	AAPL	Stock	4.4621	4.5518	4.4389	4.5339	99519084.0
2008-09-26 15:30:00	AAPL	Stock	4.5341	4.6357	4.5225	4.5775	128618644.0
2008-09-26 16:00:00	AAPL	Stock	4.5795	4.6	4.5149	4.5932	15113000.0
2008-09-26 16:30:00	AAPL	Stock	4.5918	4.5918	4.5147	4.5911	503692.0
2008-09-26 17:00:00	AAPL	Stock	4.5911	4.6	4.58	4.5929	516488.0
2008-09-26 17:30:00	AAPL	Stock	4.5961	4.5982	4.58	4.595	129388.0
2008-09-26 18:00:00	AAPL	Stock	4.5954	4.5993	4.5946	4.5964	194488.0
2008-09-26 18:30:00	AAPL	Stock	4.6	4.6054	4.5964	4.5975	167608.0
2008-09-26 19:00:00	AAPL	Stock	4.6036	4.6086	4.6	4.6086	135324.0
2008-09-26 19:30:00	AAPL	Stock	4.6071	4.6071	4.6	4.6007	291732.0
2008-09-26 04:30:00	MSFT	Stock	26.2	26.2	26.2	26.2	100.0
2008-09-26 06:00:00	MSFT	Stock	26.1	26.1	26.09	26.09	1000.0
2008-09-26 06:30:00	MSFT	Stock	26.08	26.08	26.08	26.08	300.0
2008-09-26 07:00:00	MSFT	Stock	26.08	26.09	25.96	26.05	12062.0
2008-09-26 07:30:00	MSFT	Stock	25.97	26.1	25.96	26.1	12738.0
2008-09-26 08:00:00	MSFT	Stock	26.0	26.2	26.0	26.15	63657.0
2008-09-26 08:30:00	MSFT	Stock	26.16	26.16	25.88	25.89	176099.0
2008-09-26 09:00:00	MSFT	Stock	25.87	26.55	25.85	26.2	220672.0
2008-09-26 09:30:00	MSFT	Stock	26.18	26.87	26.14	26.84	11197738.0
2008-09-26 10:00:00	MSFT	Stock	26.84	27.03	26.84	27.0	8156569.0
2008-09-26 10:30:00	MSFT	Stock	27.0	27.23	26.95	27.18	7049947.0
2008-09-26 11:00:00	MSFT	Stock	27.182	27.24	27.0	27.14	8509549.0
2008-09-26 11:30:00	MSFT	Stock	27.14	27.15	26.98	27.0	6195977.0
2008-09-26 12:00:00	MSFT	Stock	27.0	27.05	26.95	27.0	5643290.0
2008-09-26 12:30:00	MSFT	Stock	27.0	27.1	27.0	27.06	4680728.0
2008-09-26 13:00:00	MSFT	Stock	27.06	27.24	27.03	27.11	6644688.0
2008-09-26 13:30:00	MSFT	Stock	27.11	27.23	27.08	27.112	3421568.0
2008-09-26 14:00:00	MSFT	Stock	27.115	27.17	27.04	27.07	4128095.0
2008-09-26 14:30:00	MSFT	Stock	27.07	27.21	27.06	27.08	5824417.0
2008-09-26 15:00:00	MSFT	Stock	27.095	27.3	27.02	27.23	7945627.0
2008-09-26 15:30:00	MSFT	Stock	27.23	27.56	27.2	27.4	16017029.0

> showing 50 of 70,433 rows — these rows as CSV

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