PREVIEW / stock_30min / 2010-04-06

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-06.parquet
  size:    1.4 MB
  rows:    73,915
  symbols: 3,462

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-04-06 04:00:00	AAPL	Stock	8.5089	8.5346	8.5089	8.5346	19600.0
2010-04-06 04:30:00	AAPL	Stock	8.5375	8.5393	8.5375	8.5393	6440.0
2010-04-06 05:00:00	AAPL	Stock	8.5393	8.5393	8.5393	8.5393	3920.0
2010-04-06 05:30:00	AAPL	Stock	8.5357	8.5393	8.525	8.5393	28000.0
2010-04-06 06:00:00	AAPL	Stock	8.5361	8.5393	8.5361	8.5382	14000.0
2010-04-06 06:30:00	AAPL	Stock	8.5386	8.5386	8.5386	8.5386	5040.0
2010-04-06 07:00:00	AAPL	Stock	8.5293	8.5361	8.5239	8.525	293832.0
2010-04-06 07:30:00	AAPL	Stock	8.5239	8.5354	8.5196	8.5304	163436.0
2010-04-06 08:00:00	AAPL	Stock	8.5304	8.5304	8.4829	8.4964	2481668.0
2010-04-06 08:30:00	AAPL	Stock	8.4975	8.505	8.4904	8.5021	1131508.0
2010-04-06 09:00:00	AAPL	Stock	8.5025	8.5175	8.495	8.5066	774452.0
2010-04-06 09:30:00	AAPL	Stock	8.5061	8.5164	8.4643	8.4846	75966940.0
2010-04-06 10:00:00	AAPL	Stock	8.4846	8.5032	8.4679	8.5029	50145984.0
2010-04-06 10:30:00	AAPL	Stock	8.5029	8.5107	8.4891	8.5025	30909256.0
2010-04-06 11:00:00	AAPL	Stock	8.503	8.5314	8.4939	8.5229	38352608.0
2010-04-06 11:30:00	AAPL	Stock	8.5229	8.5286	8.5143	8.5247	24043096.0
2010-04-06 12:00:00	AAPL	Stock	8.5243	8.5286	8.5168	8.5214	15352344.0
2010-04-06 12:30:00	AAPL	Stock	8.5204	8.5241	8.5086	8.5229	14660436.0
2010-04-06 13:00:00	AAPL	Stock	8.5229	8.5314	8.5125	8.526	16671340.0
2010-04-06 13:30:00	AAPL	Stock	8.5268	8.5429	8.5193	8.5343	22921444.0
2010-04-06 14:00:00	AAPL	Stock	8.5346	8.57	8.5314	8.5682	38308368.0
2010-04-06 14:30:00	AAPL	Stock	8.5682	8.58	8.5611	8.5725	35440860.0
2010-04-06 15:00:00	AAPL	Stock	8.5732	8.5768	8.5536	8.5539	25329164.0
2010-04-06 15:30:00	AAPL	Stock	8.5536	8.5679	8.5418	8.5593	40568584.0
2010-04-06 16:00:00	AAPL	Stock	8.5554	8.56	8.5212	8.5536	6123432.0
2010-04-06 16:30:00	AAPL	Stock	8.5521	8.5568	8.5521	8.5564	275576.0
2010-04-06 17:00:00	AAPL	Stock	8.5546	8.5589	8.5546	8.5589	112560.0
2010-04-06 17:30:00	AAPL	Stock	8.5546	8.5589	8.5546	8.5582	239764.0
2010-04-06 18:00:00	AAPL	Stock	8.5589	8.5607	8.555	8.5607	359436.0
2010-04-06 18:30:00	AAPL	Stock	8.5579	8.5604	8.5579	8.5589	25088.0
2010-04-06 19:00:00	AAPL	Stock	8.5586	8.56	8.5571	8.5589	99764.0
2010-04-06 19:30:00	AAPL	Stock	8.5589	8.5596	8.5554	8.5582	559328.0
2010-04-06 07:30:00	MSFT	Stock	29.24	29.24	29.24	29.24	400.0
2010-04-06 08:00:00	MSFT	Stock	29.24	29.24	29.18	29.19	5756.0
2010-04-06 08:30:00	MSFT	Stock	29.2	29.22	29.17	29.2	8284.0
2010-04-06 09:00:00	MSFT	Stock	29.22	29.25	29.11	29.11	52100.0
2010-04-06 09:30:00	MSFT	Stock	29.13	29.19	29.06	29.128	3992038.0
2010-04-06 10:00:00	MSFT	Stock	29.13	29.13	28.98	29.08	4271334.0
2010-04-06 10:30:00	MSFT	Stock	29.08	29.16	29.05	29.135	3909993.0
2010-04-06 11:00:00	MSFT	Stock	29.135	29.3	29.09	29.26	3677319.0
2010-04-06 11:30:00	MSFT	Stock	29.27	29.36	29.26	29.355	2909996.0
2010-04-06 12:00:00	MSFT	Stock	29.36	29.4	29.32	29.35	2284828.0
2010-04-06 12:30:00	MSFT	Stock	29.35	29.35	29.26	29.34	3223559.0
2010-04-06 13:00:00	MSFT	Stock	29.332	29.41	29.33	29.365	1779071.0
2010-04-06 13:30:00	MSFT	Stock	29.367	29.41	29.35	29.38	2136210.0
2010-04-06 14:00:00	MSFT	Stock	29.37	29.52	29.36	29.52	3460605.0
2010-04-06 14:30:00	MSFT	Stock	29.52	29.58	29.43	29.45	3643953.0
2010-04-06 15:00:00	MSFT	Stock	29.45	29.49	29.37	29.385	2547081.0
2010-04-06 15:30:00	MSFT	Stock	29.39	29.44	29.32	29.33	5489875.0
2010-04-06 16:00:00	MSFT	Stock	29.33	29.406	29.25	29.33	2133907.0

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

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