PREVIEW / stock_30min / 2010-09-13

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-13.parquet
  size:    1.4 MB
  rows:    77,540
  symbols: 3,492

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-13 04:00:00	AAPL	Stock	9.4214	9.4464	9.4214	9.4464	8400.0
2010-09-13 05:30:00	AAPL	Stock	9.4664	9.4664	9.4479	9.4479	5600.0
2010-09-13 06:00:00	AAPL	Stock	9.4607	9.4607	9.4607	9.4607	2800.0
2010-09-13 06:30:00	AAPL	Stock	9.4679	9.4679	9.4679	9.4679	11200.0
2010-09-13 07:00:00	AAPL	Stock	9.4814	9.4893	9.4804	9.4893	133420.0
2010-09-13 07:30:00	AAPL	Stock	9.4843	9.4961	9.4732	9.475	122500.0
2010-09-13 08:00:00	AAPL	Stock	9.4732	9.5136	9.4725	9.4896	1466360.0
2010-09-13 08:30:00	AAPL	Stock	9.4975	9.5068	9.4857	9.4936	880012.0
2010-09-13 09:00:00	AAPL	Stock	9.4914	9.5054	9.475	9.4982	1244096.0
2010-09-13 09:30:00	AAPL	Stock	9.4982	9.5714	9.4914	9.5457	82777268.0
2010-09-13 10:00:00	AAPL	Stock	9.545	9.5714	9.545	9.5625	34399484.0
2010-09-13 10:30:00	AAPL	Stock	9.5629	9.5814	9.5607	9.5694	40121172.0
2010-09-13 11:00:00	AAPL	Stock	9.57	9.5743	9.5586	9.5632	16568440.0
2010-09-13 11:30:00	AAPL	Stock	9.5638	9.5654	9.5361	9.5482	21221368.0
2010-09-13 12:00:00	AAPL	Stock	9.5486	9.5489	9.5239	9.5321	21551012.0
2010-09-13 12:30:00	AAPL	Stock	9.5314	9.5443	9.5229	9.5339	16086616.0
2010-09-13 13:00:00	AAPL	Stock	9.5367	9.5571	9.5322	9.5486	15494612.0
2010-09-13 13:30:00	AAPL	Stock	9.5479	9.55	9.5318	9.5354	12825904.0
2010-09-13 14:00:00	AAPL	Stock	9.5354	9.5464	9.5268	9.5432	14740936.0
2010-09-13 14:30:00	AAPL	Stock	9.5432	9.5482	9.5364	9.5432	11044684.0
2010-09-13 15:00:00	AAPL	Stock	9.5432	9.5439	9.525	9.5329	25305476.0
2010-09-13 15:30:00	AAPL	Stock	9.5329	9.5504	9.525	9.5464	47743248.0
2010-09-13 16:00:00	AAPL	Stock	9.5471	9.5471	9.5354	9.5429	15550780.0
2010-09-13 16:30:00	AAPL	Stock	9.5439	9.545	9.5351	9.5429	348152.0
2010-09-13 17:00:00	AAPL	Stock	9.5429	9.545	9.5049	9.5425	136556.0
2010-09-13 17:30:00	AAPL	Stock	9.5471	9.5471	9.5393	9.5393	783748.0
2010-09-13 18:00:00	AAPL	Stock	9.5393	9.5457	9.5389	9.5457	178752.0
2010-09-13 18:30:00	AAPL	Stock	9.5446	9.5446	9.5371	9.5436	153720.0
2010-09-13 19:00:00	AAPL	Stock	9.5446	9.5454	9.5421	9.5454	22400.0
2010-09-13 19:30:00	AAPL	Stock	9.5414	9.5464	9.5414	9.5464	102368.0
2010-09-13 04:00:00	MSFT	Stock	24.02	24.02	24.02	24.02	800.0
2010-09-13 05:00:00	MSFT	Stock	24.02	24.02	24.02	24.02	200.0
2010-09-13 05:30:00	MSFT	Stock	24.07	24.14	24.07	24.14	1700.0
2010-09-13 06:30:00	MSFT	Stock	24.17	24.17	24.17	24.17	200.0
2010-09-13 07:00:00	MSFT	Stock	24.2	24.21	24.1	24.21	16500.0
2010-09-13 07:30:00	MSFT	Stock	24.21	24.21	24.01	24.21	12080.0
2010-09-13 08:00:00	MSFT	Stock	24.12	24.21	24.11	24.11	16706.0
2010-09-13 08:30:00	MSFT	Stock	24.11	24.11	24.07	24.1	14734.0
2010-09-13 09:00:00	MSFT	Stock	24.13	24.21	24.12	24.19	153334.0
2010-09-13 09:30:00	MSFT	Stock	24.2	24.35	24.09	24.35	9485741.0
2010-09-13 10:00:00	MSFT	Stock	24.35	24.52	24.34	24.45	9022522.0
2010-09-13 10:30:00	MSFT	Stock	24.453	24.52	24.45	24.48	5331513.0
2010-09-13 11:00:00	MSFT	Stock	24.479	24.54	24.46	24.528	3551582.0
2010-09-13 11:30:00	MSFT	Stock	24.52	24.55	24.49	24.51	3066663.0
2010-09-13 12:00:00	MSFT	Stock	24.51	24.51	24.31	24.4	3342373.0
2010-09-13 12:30:00	MSFT	Stock	24.39	24.45	24.39	24.44	3290172.0
2010-09-13 13:00:00	MSFT	Stock	24.44	24.45	24.36	24.4	2592080.0
2010-09-13 13:30:00	MSFT	Stock	24.4	24.42	24.39	24.42	1350690.0
2010-09-13 14:00:00	MSFT	Stock	24.415	24.54	24.41	24.54	3351685.0
2010-09-13 14:30:00	MSFT	Stock	24.53	24.59	24.51	24.525	2521528.0

> showing 50 of 77,540 rows — these rows as CSV

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