PREVIEW / stock_30min / 2012-10-02

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-02.parquet
  size:    1.4 MB
  rows:    74,849
  symbols: 3,469

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
2012-10-02 04:00:00	AAPL	Stock	23.625	23.6429	23.6246	23.6429	40880.0
2012-10-02 05:00:00	AAPL	Stock	23.6943	23.6964	23.6943	23.6964	19600.0
2012-10-02 05:30:00	AAPL	Stock	23.7107	23.7214	23.7071	23.7143	57288.0
2012-10-02 06:00:00	AAPL	Stock	23.7054	23.7125	23.7	23.7125	36400.0
2012-10-02 06:30:00	AAPL	Stock	23.7143	23.7318	23.7125	23.7318	33180.0
2012-10-02 07:00:00	AAPL	Stock	23.7143	23.7282	23.6429	23.6429	251804.0
2012-10-02 07:30:00	AAPL	Stock	23.6604	23.7214	23.6604	23.7121	353808.0
2012-10-02 08:00:00	AAPL	Stock	23.7007	23.7507	23.6964	23.6968	1196552.0
2012-10-02 08:30:00	AAPL	Stock	23.7018	23.7118	23.6471	23.6532	1036588.0
2012-10-02 09:00:00	AAPL	Stock	23.65	23.6518	23.6	23.6464	2056208.0
2012-10-02 09:30:00	AAPL	Stock	23.6361	23.7225	23.5546	23.6318	76195756.0
2012-10-02 10:00:00	AAPL	Stock	23.6314	23.7959	23.5179	23.7671	56024528.0
2012-10-02 10:30:00	AAPL	Stock	23.7675	23.7982	23.6329	23.6601	33743332.0
2012-10-02 11:00:00	AAPL	Stock	23.6593	23.6921	23.5446	23.5982	31141320.0
2012-10-02 11:30:00	AAPL	Stock	23.598	23.6696	23.4786	23.4964	42252700.0
2012-10-02 12:00:00	AAPL	Stock	23.4957	23.5493	23.4375	23.4646	31150196.0
2012-10-02 12:30:00	AAPL	Stock	23.4611	23.4882	23.4036	23.4157	33007352.0
2012-10-02 13:00:00	AAPL	Stock	23.4154	23.4768	23.3164	23.3486	36217132.0
2012-10-02 13:30:00	AAPL	Stock	23.3464	23.4868	23.3132	23.35	39415516.0
2012-10-02 14:00:00	AAPL	Stock	23.35	23.3986	23.2968	23.3179	30437204.0
2012-10-02 14:30:00	AAPL	Stock	23.3154	23.325	23.25	23.2754	46377436.0
2012-10-02 15:00:00	AAPL	Stock	23.28	23.5357	23.2375	23.5139	68471424.0
2012-10-02 15:30:00	AAPL	Stock	23.5129	23.6571	23.4571	23.6168	85818460.0
2012-10-02 16:00:00	AAPL	Stock	23.6175	23.6521	23.4197	23.65	5321932.0
2012-10-02 16:30:00	AAPL	Stock	23.6443	23.6554	23.5095	23.6536	414400.0
2012-10-02 17:00:00	AAPL	Stock	23.6543	23.6786	23.6543	23.6768	383012.0
2012-10-02 17:30:00	AAPL	Stock	23.6786	23.6929	23.6786	23.6868	238504.0
2012-10-02 18:00:00	AAPL	Stock	23.6896	23.6896	23.6182	23.675	2184112.0
2012-10-02 18:30:00	AAPL	Stock	23.6746	23.6786	23.6625	23.6732	89320.0
2012-10-02 19:00:00	AAPL	Stock	23.6696	23.6732	23.6618	23.6721	52332.0
2012-10-02 19:30:00	AAPL	Stock	23.6661	23.6821	23.6636	23.6821	199612.0
2012-10-02 07:00:00	MSFT	Stock	29.53	29.6	29.53	29.6	1466.0
2012-10-02 07:30:00	MSFT	Stock	29.6	29.64	29.6	29.64	9200.0
2012-10-02 08:00:00	MSFT	Stock	29.6	29.69	29.6	29.64	8305.0
2012-10-02 08:30:00	MSFT	Stock	29.62	29.66	29.6	29.65	18137.0
2012-10-02 09:00:00	MSFT	Stock	29.65	29.67	29.64	29.67	14149.0
2012-10-02 09:30:00	MSFT	Stock	29.68	29.89	29.6	29.8	5743145.0
2012-10-02 10:00:00	MSFT	Stock	29.8	29.82	29.67	29.75	4679966.0
2012-10-02 10:30:00	MSFT	Stock	29.75	29.83	29.7	29.73	3945244.0
2012-10-02 11:00:00	MSFT	Stock	29.73	29.74	29.62	29.685	1880111.0
2012-10-02 11:30:00	MSFT	Stock	29.69	29.73	29.52	29.53	2862240.0
2012-10-02 12:00:00	MSFT	Stock	29.521	29.63	29.52	29.575	1681572.0
2012-10-02 12:30:00	MSFT	Stock	29.58	29.63	29.55	29.568	1983534.0
2012-10-02 13:00:00	MSFT	Stock	29.56	29.63	29.56	29.59	1388807.0
2012-10-02 13:30:00	MSFT	Stock	29.585	29.64	29.54	29.568	1603209.0
2012-10-02 14:00:00	MSFT	Stock	29.57	29.66	29.56	29.586	2237326.0
2012-10-02 14:30:00	MSFT	Stock	29.58	29.6	29.5	29.53	2373019.0
2012-10-02 15:00:00	MSFT	Stock	29.535	29.645	29.52	29.635	2884452.0
2012-10-02 15:30:00	MSFT	Stock	29.632	29.71	29.59	29.67	6023921.0
2012-10-02 16:00:00	MSFT	Stock	29.66	29.85	29.49	29.77	1417421.0

> showing 50 of 74,849 rows — these rows as CSV

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