PREVIEW / stock_30min / 2008-02-20

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-20.parquet
  size:    1.2 MB
  rows:    69,335
  symbols: 3,279

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-02-20 05:30:00	AAPL	Stock	4.3679	4.3679	4.3668	4.3668	28000.0
2008-02-20 06:30:00	AAPL	Stock	4.3625	4.3625	4.3571	4.3571	11200.0
2008-02-20 07:00:00	AAPL	Stock	4.3611	4.3661	4.3518	4.3571	360416.0
2008-02-20 07:30:00	AAPL	Stock	4.3575	4.3771	4.3575	4.3629	86604.0
2008-02-20 08:00:00	AAPL	Stock	4.3714	4.3771	4.3536	4.3643	1268624.0
2008-02-20 08:30:00	AAPL	Stock	4.3725	4.3725	4.3343	4.3482	3836392.0
2008-02-20 09:00:00	AAPL	Stock	4.3486	4.3686	4.3429	4.3654	3596376.0
2008-02-20 09:30:00	AAPL	Stock	4.3643	4.4107	4.3457	4.3796	130598580.0
2008-02-20 10:00:00	AAPL	Stock	4.3793	4.4025	4.36	4.3861	88037152.0
2008-02-20 10:30:00	AAPL	Stock	4.3861	4.3861	4.3539	4.3607	66259340.0
2008-02-20 11:00:00	AAPL	Stock	4.3607	4.3829	4.3571	4.3796	48796580.0
2008-02-20 11:30:00	AAPL	Stock	4.3796	4.3975	4.3625	4.39	49947464.0
2008-02-20 12:00:00	AAPL	Stock	4.3904	4.4286	4.3857	4.4179	91840084.0
2008-02-20 12:30:00	AAPL	Stock	4.4186	4.425	4.4061	4.4082	50223908.0
2008-02-20 13:00:00	AAPL	Stock	4.4082	4.45	4.3932	4.3943	71407224.0
2008-02-20 13:30:00	AAPL	Stock	4.3942	4.4107	4.3786	4.3996	57559852.0
2008-02-20 14:00:00	AAPL	Stock	4.3993	4.42	4.3664	4.3907	81047484.0
2008-02-20 14:30:00	AAPL	Stock	4.3918	4.4157	4.3804	4.4061	76367284.0
2008-02-20 15:00:00	AAPL	Stock	4.4064	4.42	4.3843	4.3889	58894416.0
2008-02-20 15:30:00	AAPL	Stock	4.3882	4.4214	4.3768	4.42	73263568.0
2008-02-20 16:00:00	AAPL	Stock	4.4211	4.4225	4.3936	4.4186	10843028.0
2008-02-20 16:30:00	AAPL	Stock	4.4189	4.4221	4.377	4.4164	1657992.0
2008-02-20 17:00:00	AAPL	Stock	4.4193	4.4196	4.4168	4.4196	122388.0
2008-02-20 17:30:00	AAPL	Stock	4.4193	4.4311	4.4193	4.4282	358960.0
2008-02-20 18:00:00	AAPL	Stock	4.4268	4.4286	4.4254	4.4286	212940.0
2008-02-20 18:30:00	AAPL	Stock	4.4286	4.4375	4.4275	4.4375	294840.0
2008-02-20 19:00:00	AAPL	Stock	4.4321	4.4354	4.4221	4.4343	176260.0
2008-02-20 19:30:00	AAPL	Stock	4.4343	4.4446	4.4343	4.4411	447132.0
2008-02-20 07:00:00	MSFT	Stock	28.13	28.13	28.12	28.12	750.0
2008-02-20 08:00:00	MSFT	Stock	28.17	28.24	28.17	28.2	249133.0
2008-02-20 08:30:00	MSFT	Stock	28.19	28.19	28.06	28.1	51135.0
2008-02-20 09:00:00	MSFT	Stock	28.1	28.15	28.07	28.15	50764.0
2008-02-20 09:30:00	MSFT	Stock	28.14	28.25	27.97	28.07	8773916.0
2008-02-20 10:00:00	MSFT	Stock	28.08	28.2	27.92	28.06	9994253.0
2008-02-20 10:30:00	MSFT	Stock	28.06	28.12	28.04	28.04	7868413.0
2008-02-20 11:00:00	MSFT	Stock	28.05	28.06	28.01	28.03	5218156.0
2008-02-20 11:30:00	MSFT	Stock	28.03	28.06	27.99	28.04	4630209.0
2008-02-20 12:00:00	MSFT	Stock	28.04	28.19	28.0	28.14	10315282.0
2008-02-20 12:30:00	MSFT	Stock	28.133	28.16	28.05	28.1	4948212.0
2008-02-20 13:00:00	MSFT	Stock	28.11	28.21	28.03	28.04	5308681.0
2008-02-20 13:30:00	MSFT	Stock	28.04	28.15	27.97	28.08	4671900.0
2008-02-20 14:00:00	MSFT	Stock	28.08	28.18	28.01	28.03	7694314.0
2008-02-20 14:30:00	MSFT	Stock	28.03	28.18	28.03	28.15	5783204.0
2008-02-20 15:00:00	MSFT	Stock	28.15	28.26	28.11	28.18	7060707.0
2008-02-20 15:30:00	MSFT	Stock	28.17	28.24	28.12	28.23	8092437.0
2008-02-20 16:00:00	MSFT	Stock	28.21	28.27	28.094	28.22	1958790.0
2008-02-20 16:30:00	MSFT	Stock	27.996	28.22	27.996	28.22	416295.0
2008-02-20 17:00:00	MSFT	Stock	28.23	28.24	28.185	28.24	33120.0
2008-02-20 17:30:00	MSFT	Stock	28.24	28.24	28.24	28.24	500.0
2008-02-20 18:00:00	MSFT	Stock	28.24	28.25	28.19	28.19	201449.0

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

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