PREVIEW / stock_30min / 2010-05-20

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-20.parquet
  size:    1.5 MB
  rows:    79,594
  symbols: 3,513

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-05-20 04:30:00	AAPL	Stock	8.8571	8.8607	8.8571	8.8607	19600.0
2010-05-20 05:00:00	AAPL	Stock	8.8804	8.8804	8.8536	8.8536	14000.0
2010-05-20 05:30:00	AAPL	Stock	8.8536	8.8536	8.8536	8.8536	14000.0
2010-05-20 06:00:00	AAPL	Stock	8.8411	8.8411	8.8411	8.8411	3108.0
2010-05-20 07:00:00	AAPL	Stock	8.8036	8.8304	8.7575	8.7679	122500.0
2010-05-20 07:30:00	AAPL	Stock	8.7629	8.7682	8.6993	8.7143	863184.0
2010-05-20 08:00:00	AAPL	Stock	8.71	8.7375	8.6921	8.7143	3486560.0
2010-05-20 08:30:00	AAPL	Stock	8.71	8.7125	8.6154	8.6536	5768420.0
2010-05-20 09:00:00	AAPL	Stock	8.6536	8.6921	8.6318	8.6321	3410148.0
2010-05-20 09:30:00	AAPL	Stock	8.6386	8.685	8.5893	8.6404	149293788.0
2010-05-20 10:00:00	AAPL	Stock	8.6393	8.6739	8.5018	8.5689	147278236.0
2010-05-20 10:30:00	AAPL	Stock	8.5661	8.5893	8.5143	8.5541	96465040.0
2010-05-20 11:00:00	AAPL	Stock	8.5536	8.6125	8.5493	8.6114	70117180.0
2010-05-20 11:30:00	AAPL	Stock	8.6114	8.6412	8.584	8.5939	68432588.0
2010-05-20 12:00:00	AAPL	Stock	8.5914	8.6071	8.5504	8.5729	46582088.0
2010-05-20 12:30:00	AAPL	Stock	8.5732	8.5749	8.4364	8.4439	78587740.0
2010-05-20 13:00:00	AAPL	Stock	8.4407	8.5821	8.4361	8.5593	93155720.0
2010-05-20 13:30:00	AAPL	Stock	8.5629	8.6121	8.5386	8.5629	75731152.0
2010-05-20 14:00:00	AAPL	Stock	8.5618	8.6429	8.5143	8.5975	89000912.0
2010-05-20 14:30:00	AAPL	Stock	8.5996	8.7089	8.58	8.6339	117380704.0
2010-05-20 15:00:00	AAPL	Stock	8.6368	8.6582	8.5964	8.6082	72172576.0
2010-05-20 15:30:00	AAPL	Stock	8.6082	8.6332	8.4704	8.4846	134704640.0
2010-05-20 16:00:00	AAPL	Stock	8.4821	8.5853	8.44	8.4461	15559600.0
2010-05-20 16:30:00	AAPL	Stock	8.4461	8.5899	8.4357	8.4732	1726172.0
2010-05-20 17:00:00	AAPL	Stock	8.4739	8.4821	8.4546	8.4625	1290912.0
2010-05-20 17:30:00	AAPL	Stock	8.4625	8.4629	8.4146	8.4207	1286852.0
2010-05-20 18:00:00	AAPL	Stock	8.4164	8.4914	8.3679	8.3821	1486604.0
2010-05-20 18:30:00	AAPL	Stock	8.3918	8.4268	8.3839	8.3839	766416.0
2010-05-20 19:00:00	AAPL	Stock	8.3929	8.4018	8.3839	8.3946	604492.0
2010-05-20 19:30:00	AAPL	Stock	8.3932	8.4018	8.3679	8.3929	628124.0
2010-05-20 06:30:00	MSFT	Stock	27.85	27.85	27.85	27.85	2000.0
2010-05-20 07:00:00	MSFT	Stock	27.91	28.04	27.89	27.89	9800.0
2010-05-20 07:30:00	MSFT	Stock	27.87	27.9	27.81	27.81	2939.0
2010-05-20 08:00:00	MSFT	Stock	27.9	28.288	27.78	27.82	25177.0
2010-05-20 08:30:00	MSFT	Stock	27.82	27.82	27.62	27.69	27156.0
2010-05-20 09:00:00	MSFT	Stock	27.68	27.85	27.64	27.65	40132.0
2010-05-20 09:30:00	MSFT	Stock	27.64	27.84	27.42	27.74	6006162.0
2010-05-20 10:00:00	MSFT	Stock	27.74	27.82	27.27	27.355	7373183.0
2010-05-20 10:30:00	MSFT	Stock	27.355	27.53	27.28	27.29	8544468.0
2010-05-20 11:00:00	MSFT	Stock	27.28	27.45	27.18	27.44	6684024.0
2010-05-20 11:30:00	MSFT	Stock	27.44	27.69	27.43	27.51	6864258.0
2010-05-20 12:00:00	MSFT	Stock	27.51	27.56	27.38	27.42	3775693.0
2010-05-20 12:30:00	MSFT	Stock	27.42	27.43	27.19	27.2	2902032.0
2010-05-20 13:00:00	MSFT	Stock	27.2	27.6	27.04	27.54	4691483.0
2010-05-20 13:30:00	MSFT	Stock	27.53	27.6	27.43	27.48	4934863.0
2010-05-20 14:00:00	MSFT	Stock	27.48	27.62	27.25	27.52	5773050.0
2010-05-20 14:30:00	MSFT	Stock	27.52	27.69	27.42	27.444	6062649.0
2010-05-20 15:00:00	MSFT	Stock	27.45	27.56	27.35	27.47	4541299.0
2010-05-20 15:30:00	MSFT	Stock	27.47	27.54	27.11	27.11	12872199.0
2010-05-20 16:00:00	MSFT	Stock	27.12	28.255	27.03	27.1	4378099.0

> showing 50 of 79,594 rows — these rows as CSV

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