PREVIEW / stock_30min / 2009-04-28

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-28.parquet
  size:    1.3 MB
  rows:    70,128
  symbols: 3,313

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-04-28 06:00:00	AAPL	Stock	4.3896	4.3896	4.3896	4.3896	2800.0
2009-04-28 06:30:00	AAPL	Stock	4.3882	4.3882	4.3882	4.3882	2800.0
2009-04-28 07:00:00	AAPL	Stock	4.3896	4.4254	4.3896	4.3982	47600.0
2009-04-28 07:30:00	AAPL	Stock	4.4021	4.4021	4.3996	4.3996	44800.0
2009-04-28 08:00:00	AAPL	Stock	4.4546	4.4546	4.3996	4.41	645008.0
2009-04-28 08:30:00	AAPL	Stock	4.4107	4.4218	4.4018	4.42	200312.0
2009-04-28 09:00:00	AAPL	Stock	4.4179	4.4214	4.4021	4.4057	1235444.0
2009-04-28 09:30:00	AAPL	Stock	4.4064	4.4539	4.4021	4.4536	66410092.0
2009-04-28 10:00:00	AAPL	Stock	4.45	4.5025	4.4486	4.4971	61334980.0
2009-04-28 10:30:00	AAPL	Stock	4.4971	4.5075	4.4871	4.4953	30214688.0
2009-04-28 11:00:00	AAPL	Stock	4.495	4.5004	4.4732	4.4771	20948592.0
2009-04-28 11:30:00	AAPL	Stock	4.4771	4.4843	4.4682	4.4727	16624524.0
2009-04-28 12:00:00	AAPL	Stock	4.4729	4.4907	4.4729	4.4904	18527852.0
2009-04-28 12:30:00	AAPL	Stock	4.4907	4.4982	4.4836	4.4904	14353920.0
2009-04-28 13:00:00	AAPL	Stock	4.4907	4.4986	4.46	4.4675	35710920.0
2009-04-28 13:30:00	AAPL	Stock	4.4679	4.4736	4.4386	4.4421	25939228.0
2009-04-28 14:00:00	AAPL	Stock	4.4421	4.4757	4.4364	4.4711	28924616.0
2009-04-28 14:30:00	AAPL	Stock	4.4718	4.4907	4.4718	4.4757	24332112.0
2009-04-28 15:00:00	AAPL	Stock	4.4757	4.4839	4.4379	4.4429	31171700.0
2009-04-28 15:30:00	AAPL	Stock	4.4429	4.4514	4.4214	4.4282	52298568.0
2009-04-28 16:00:00	AAPL	Stock	4.4279	4.4775	4.4218	4.425	14187824.0
2009-04-28 16:30:00	AAPL	Stock	4.4268	4.4282	4.425	4.425	393120.0
2009-04-28 17:00:00	AAPL	Stock	4.425	4.4282	4.4239	4.4254	61180.0
2009-04-28 17:30:00	AAPL	Stock	4.4264	4.4286	4.4221	4.4221	143948.0
2009-04-28 18:00:00	AAPL	Stock	4.425	4.425	4.4164	4.4186	384160.0
2009-04-28 18:30:00	AAPL	Stock	4.4168	4.4361	4.4168	4.4332	348124.0
2009-04-28 19:00:00	AAPL	Stock	4.4296	4.4296	4.4293	4.4293	14000.0
2009-04-28 19:30:00	AAPL	Stock	4.4314	4.44	4.4296	4.44	74648.0
2009-04-28 06:30:00	MSFT	Stock	20.23	20.3	20.2	20.2	2000.0
2009-04-28 07:00:00	MSFT	Stock	20.21	20.21	20.21	20.21	300.0
2009-04-28 07:30:00	MSFT	Stock	20.22	20.27	20.22	20.23	800.0
2009-04-28 08:00:00	MSFT	Stock	20.29	20.32	20.23	20.3	16372.0
2009-04-28 08:30:00	MSFT	Stock	20.33	20.33	20.23	20.23	10644.0
2009-04-28 09:00:00	MSFT	Stock	20.31	20.33	20.17	20.2	20796.0
2009-04-28 09:30:00	MSFT	Stock	20.26	20.27	19.86	20.0	8671042.0
2009-04-28 10:00:00	MSFT	Stock	20.0	20.1	19.98	20.07	8378093.0
2009-04-28 10:30:00	MSFT	Stock	20.07	20.09	20.03	20.06	4038222.0
2009-04-28 11:00:00	MSFT	Stock	20.06	20.24	20.05	20.2	5016129.0
2009-04-28 11:30:00	MSFT	Stock	20.201	20.21	20.09	20.148	3030904.0
2009-04-28 12:00:00	MSFT	Stock	20.145	20.21	20.11	20.14	2640366.0
2009-04-28 12:30:00	MSFT	Stock	20.14	20.14	19.96	19.972	3476611.0
2009-04-28 13:00:00	MSFT	Stock	19.98	20.14	19.85	19.87	5061727.0
2009-04-28 13:30:00	MSFT	Stock	19.879	19.93	19.79	19.84	5131412.0
2009-04-28 14:00:00	MSFT	Stock	19.85	19.91	19.83	19.898	5287760.0
2009-04-28 14:30:00	MSFT	Stock	19.9	20.04	19.9	19.96	7765800.0
2009-04-28 15:00:00	MSFT	Stock	19.965	20.03	19.89	19.92	5145720.0
2009-04-28 15:30:00	MSFT	Stock	19.92	20.0	19.86	19.92	7730106.0
2009-04-28 16:00:00	MSFT	Stock	19.93	20.593	19.88	19.996	1479684.0
2009-04-28 16:30:00	MSFT	Stock	19.93	20.1	19.9	19.94	35707.0
2009-04-28 17:00:00	MSFT	Stock	19.92	19.93	19.9	19.9	50542.0

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

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