PREVIEW / stock_30min / 2009-05-22

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-22.parquet
  size:    1.2 MB
  rows:    69,827
  symbols: 3,321

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-05-22 04:00:00	AAPL	Stock	4.4496	4.4529	4.4496	4.4529	5600.0
2009-05-22 06:00:00	AAPL	Stock	4.4768	4.4768	4.4768	4.4768	2800.0
2009-05-22 06:30:00	AAPL	Stock	4.4821	4.4871	4.4821	4.4871	5600.0
2009-05-22 07:00:00	AAPL	Stock	4.4714	4.4732	4.4286	4.4321	45164.0
2009-05-22 07:30:00	AAPL	Stock	4.4464	4.4571	4.4464	4.4571	22876.0
2009-05-22 08:00:00	AAPL	Stock	4.4525	4.4543	4.4464	4.4496	412552.0
2009-05-22 08:30:00	AAPL	Stock	4.4486	4.4536	4.4464	4.4536	219940.0
2009-05-22 09:00:00	AAPL	Stock	4.4539	4.4539	4.4289	4.4307	412412.0
2009-05-22 09:30:00	AAPL	Stock	4.4311	4.4343	4.3482	4.3846	62555780.0
2009-05-22 10:00:00	AAPL	Stock	4.3846	4.4107	4.3643	4.3993	42962388.0
2009-05-22 10:30:00	AAPL	Stock	4.4002	4.4025	4.38	4.3967	18542972.0
2009-05-22 11:00:00	AAPL	Stock	4.3968	4.4143	4.3936	4.3954	17137344.0
2009-05-22 11:30:00	AAPL	Stock	4.3964	4.4046	4.3811	4.3904	13565720.0
2009-05-22 12:00:00	AAPL	Stock	4.3893	4.4029	4.3825	4.3839	11783632.0
2009-05-22 12:30:00	AAPL	Stock	4.3832	4.3964	4.3807	4.3932	12131672.0
2009-05-22 13:00:00	AAPL	Stock	4.3932	4.4004	4.3871	4.3925	8646652.0
2009-05-22 13:30:00	AAPL	Stock	4.3925	4.3946	4.3764	4.3893	11256644.0
2009-05-22 14:00:00	AAPL	Stock	4.3889	4.4054	4.3843	4.4027	12835676.0
2009-05-22 14:30:00	AAPL	Stock	4.4029	4.4161	4.3957	4.4139	11172252.0
2009-05-22 15:00:00	AAPL	Stock	4.4136	4.4246	4.3907	4.3936	18298616.0
2009-05-22 15:30:00	AAPL	Stock	4.3936	4.4107	4.375	4.375	33975396.0
2009-05-22 16:00:00	AAPL	Stock	4.375	4.3937	4.3686	4.375	7028756.0
2009-05-22 16:30:00	AAPL	Stock	4.375	4.3754	4.3736	4.3754	32144.0
2009-05-22 17:00:00	AAPL	Stock	4.375	4.375	4.3732	4.3732	126952.0
2009-05-22 17:30:00	AAPL	Stock	4.3732	4.3732	4.3679	4.3679	45696.0
2009-05-22 18:00:00	AAPL	Stock	4.3736	4.3743	4.3736	4.3743	22400.0
2009-05-22 18:30:00	AAPL	Stock	4.375	4.375	4.375	4.375	2800.0
2009-05-22 19:00:00	AAPL	Stock	4.3732	4.375	4.3732	4.3732	19292.0
2009-05-22 19:30:00	AAPL	Stock	4.375	4.375	4.3732	4.3743	43988.0
2009-05-22 07:00:00	MSFT	Stock	19.95	20.0	19.95	20.0	700.0
2009-05-22 07:30:00	MSFT	Stock	19.99	19.99	19.95	19.99	2000.0
2009-05-22 08:00:00	MSFT	Stock	19.99	20.0	19.92	19.96	9295.0
2009-05-22 08:30:00	MSFT	Stock	19.95	20.0	19.95	19.97	11010.0
2009-05-22 09:00:00	MSFT	Stock	19.95	19.95	19.9	19.9	7200.0
2009-05-22 09:30:00	MSFT	Stock	19.91	19.94	19.47	19.61	5485880.0
2009-05-22 10:00:00	MSFT	Stock	19.62	19.71	19.553	19.598	3477171.0
2009-05-22 10:30:00	MSFT	Stock	19.6	19.77	19.53	19.69	2051359.0
2009-05-22 11:00:00	MSFT	Stock	19.693	19.82	19.65	19.8	2273302.0
2009-05-22 11:30:00	MSFT	Stock	19.801	19.85	19.7	19.74	2372744.0
2009-05-22 12:00:00	MSFT	Stock	19.74	19.85	19.739	19.753	1720513.0
2009-05-22 12:30:00	MSFT	Stock	19.76	19.95	19.75	19.94	1201972.0
2009-05-22 13:00:00	MSFT	Stock	19.94	19.99	19.93	19.982	1783770.0
2009-05-22 13:30:00	MSFT	Stock	19.99	20.0	19.91	19.98	1785115.0
2009-05-22 14:00:00	MSFT	Stock	19.99	20.04	19.94	20.01	2022430.0
2009-05-22 14:30:00	MSFT	Stock	20.01	20.14	19.99	20.122	2858156.0
2009-05-22 15:00:00	MSFT	Stock	20.13	20.17	19.99	20.0	3215680.0
2009-05-22 15:30:00	MSFT	Stock	20.01	20.01	19.76	19.76	5397561.0
2009-05-22 16:00:00	MSFT	Stock	19.76	19.838	19.708	19.75	1226042.0
2009-05-22 16:30:00	MSFT	Stock	19.76	19.76	19.75	19.75	13710.0
2009-05-22 17:00:00	MSFT	Stock	19.78	19.82	19.75	19.78	3150.0

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

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