PREVIEW / stock_30min / 2010-09-27

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-27.parquet
  size:    1.4 MB
  rows:    73,149
  symbols: 3,490

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
2010-09-27 04:00:00	AAPL	Stock	10.4679	10.4679	10.4679	10.4679	2800.0
2010-09-27 05:30:00	AAPL	Stock	10.4757	10.4982	10.4757	10.4911	14000.0
2010-09-27 06:00:00	AAPL	Stock	10.4911	10.4911	10.4911	10.4911	2800.0
2010-09-27 06:30:00	AAPL	Stock	10.4814	10.4814	10.4643	10.4643	28000.0
2010-09-27 07:00:00	AAPL	Stock	10.4761	10.4836	10.4704	10.4714	222180.0
2010-09-27 07:30:00	AAPL	Stock	10.4714	10.4786	10.4643	10.4757	200200.0
2010-09-27 08:00:00	AAPL	Stock	10.4786	10.5346	10.4657	10.5257	3223752.0
2010-09-27 08:30:00	AAPL	Stock	10.5261	10.5307	10.5179	10.5289	2059456.0
2010-09-27 09:00:00	AAPL	Stock	10.5289	10.5321	10.485	10.4964	1843884.0
2010-09-27 09:30:00	AAPL	Stock	10.4991	10.5261	10.4561	10.4764	96205564.0
2010-09-27 10:00:00	AAPL	Stock	10.4761	10.4921	10.4325	10.4746	49323232.0
2010-09-27 10:30:00	AAPL	Stock	10.4746	10.525	10.4589	10.475	45780168.0
2010-09-27 11:00:00	AAPL	Stock	10.4746	10.475	10.4486	10.4675	24755668.0
2010-09-27 11:30:00	AAPL	Stock	10.4687	10.475	10.4436	10.4557	22145592.0
2010-09-27 12:00:00	AAPL	Stock	10.455	10.4654	10.4464	10.4564	14193676.0
2010-09-27 12:30:00	AAPL	Stock	10.4554	10.475	10.4464	10.4729	14913220.0
2010-09-27 13:00:00	AAPL	Stock	10.4732	10.4921	10.4686	10.4839	20629896.0
2010-09-27 13:30:00	AAPL	Stock	10.4836	10.505	10.4779	10.4929	23122120.0
2010-09-27 14:00:00	AAPL	Stock	10.4929	10.5011	10.475	10.5	18932648.0
2010-09-27 14:30:00	AAPL	Stock	10.4993	10.5075	10.4893	10.4907	23954784.0
2010-09-27 15:00:00	AAPL	Stock	10.4908	10.4939	10.4786	10.4868	19940508.0
2010-09-27 15:30:00	AAPL	Stock	10.4868	10.4868	10.3932	10.3936	74714080.0
2010-09-27 16:00:00	AAPL	Stock	10.3943	10.4708	10.3875	10.39	15996064.0
2010-09-27 16:30:00	AAPL	Stock	10.3954	10.4915	10.3714	10.3821	717220.0
2010-09-27 17:00:00	AAPL	Stock	10.3807	10.4125	10.3807	10.4054	1373708.0
2010-09-27 17:30:00	AAPL	Stock	10.4054	10.4075	10.4014	10.4036	286972.0
2010-09-27 18:00:00	AAPL	Stock	10.4036	10.4057	10.3986	10.4018	141568.0
2010-09-27 18:30:00	AAPL	Stock	10.4018	10.4089	10.4011	10.4079	59332.0
2010-09-27 19:00:00	AAPL	Stock	10.4004	10.4064	10.4	10.4018	41300.0
2010-09-27 19:30:00	AAPL	Stock	10.4	10.4014	10.3929	10.3946	221844.0
2010-09-27 20:00:00	AAPL	Stock	10.4561	10.4561	10.4561	10.4561	11200.0
2010-09-27 04:30:00	MSFT	Stock	24.8	24.8	24.8	24.8	200.0
2010-09-27 07:00:00	MSFT	Stock	24.9	24.91	24.83	24.83	1580.0
2010-09-27 07:30:00	MSFT	Stock	24.85	24.87	24.79	24.83	12600.0
2010-09-27 08:00:00	MSFT	Stock	24.79	24.86	24.79	24.81	14720.0
2010-09-27 08:30:00	MSFT	Stock	24.83	24.84	24.82	24.83	24079.0
2010-09-27 09:00:00	MSFT	Stock	24.83	24.87	24.76	24.85	89065.0
2010-09-27 09:30:00	MSFT	Stock	24.85	24.86	24.73	24.795	2522378.0
2010-09-27 10:00:00	MSFT	Stock	24.8	24.8	24.68	24.71	2477060.0
2010-09-27 10:30:00	MSFT	Stock	24.71	24.735	24.65	24.69	2913730.0
2010-09-27 11:00:00	MSFT	Stock	24.69	24.72	24.62	24.62	2968815.0
2010-09-27 11:30:00	MSFT	Stock	24.62	24.71	24.59	24.7	2274388.0
2010-09-27 12:00:00	MSFT	Stock	24.71	24.78	24.7	24.76	2189593.0
2010-09-27 12:30:00	MSFT	Stock	24.759	24.759	24.7	24.72	1821259.0
2010-09-27 13:00:00	MSFT	Stock	24.715	24.76	24.69	24.75	1773787.0
2010-09-27 13:30:00	MSFT	Stock	24.75	24.87	24.74	24.86	2625812.0
2010-09-27 14:00:00	MSFT	Stock	24.86	24.96	24.85	24.955	3407955.0
2010-09-27 14:30:00	MSFT	Stock	24.95	24.99	24.91	24.915	3612993.0
2010-09-27 15:00:00	MSFT	Stock	24.91	24.94	24.87	24.87	2529884.0
2010-09-27 15:30:00	MSFT	Stock	24.87	24.88	24.7	24.72	7330768.0

> showing 50 of 73,149 rows — these rows as CSV

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