PREVIEW / stock_30min / 2010-11-04

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-04.parquet
  size:    1.4 MB
  rows:    76,955
  symbols: 3,518

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-11-04 04:00:00	AAPL	Stock	11.1907	11.2143	11.1789	11.2143	17080.0
2010-11-04 04:30:00	AAPL	Stock	11.25	11.25	11.25	11.25	2800.0
2010-11-04 06:30:00	AAPL	Stock	11.2554	11.2554	11.2554	11.2554	5600.0
2010-11-04 07:00:00	AAPL	Stock	11.2668	11.2775	11.2357	11.2393	270256.0
2010-11-04 07:30:00	AAPL	Stock	11.2396	11.2464	11.2364	11.2464	187040.0
2010-11-04 08:00:00	AAPL	Stock	11.2464	11.2657	11.2439	11.2657	2435412.0
2010-11-04 08:30:00	AAPL	Stock	11.2657	11.2943	11.2539	11.2854	2863308.0
2010-11-04 09:00:00	AAPL	Stock	11.285	11.2889	11.2643	11.2654	3020780.0
2010-11-04 09:30:00	AAPL	Stock	11.2661	11.3443	11.2511	11.3287	97008632.0
2010-11-04 10:00:00	AAPL	Stock	11.3298	11.3339	11.2932	11.3176	46083464.0
2010-11-04 10:30:00	AAPL	Stock	11.3175	11.4232	11.3143	11.4164	87474324.0
2010-11-04 11:00:00	AAPL	Stock	11.4164	11.435	11.3786	11.3868	80236044.0
2010-11-04 11:30:00	AAPL	Stock	11.3879	11.4054	11.3729	11.3786	31941672.0
2010-11-04 12:00:00	AAPL	Stock	11.3771	11.3804	11.3511	11.3646	30964808.0
2010-11-04 12:30:00	AAPL	Stock	11.3646	11.3882	11.3593	11.3756	21980364.0
2010-11-04 13:00:00	AAPL	Stock	11.3768	11.3914	11.3711	11.3864	18135124.0
2010-11-04 13:30:00	AAPL	Stock	11.3861	11.3893	11.3607	11.3607	20601280.0
2010-11-04 14:00:00	AAPL	Stock	11.3611	11.3804	11.3493	11.3704	26049408.0
2010-11-04 14:30:00	AAPL	Stock	11.3693	11.3857	11.3604	11.3636	20152664.0
2010-11-04 15:00:00	AAPL	Stock	11.3636	11.3792	11.3214	11.3586	45992212.0
2010-11-04 15:30:00	AAPL	Stock	11.3589	11.3675	11.3143	11.3661	60287444.0
2010-11-04 16:00:00	AAPL	Stock	11.3668	11.3693	11.3161	11.3239	28928480.0
2010-11-04 16:30:00	AAPL	Stock	11.3239	11.3594	11.3096	11.3179	2355528.0
2010-11-04 17:00:00	AAPL	Stock	11.3175	11.3186	11.3093	11.3143	581140.0
2010-11-04 17:30:00	AAPL	Stock	11.3143	11.3354	11.3143	11.3321	402640.0
2010-11-04 18:00:00	AAPL	Stock	11.3314	11.3668	11.3125	11.3207	1907556.0
2010-11-04 18:30:00	AAPL	Stock	11.3243	11.325	11.3179	11.3221	119560.0
2010-11-04 19:00:00	AAPL	Stock	11.3232	11.3307	11.3143	11.325	194740.0
2010-11-04 19:30:00	AAPL	Stock	11.3279	11.3286	11.31	11.3107	1393700.0
2010-11-04 04:30:00	MSFT	Stock	27.31	27.31	27.31	27.31	200.0
2010-11-04 05:30:00	MSFT	Stock	27.45	27.45	27.45	27.45	3900.0
2010-11-04 06:00:00	MSFT	Stock	27.45	27.45	27.45	27.45	1000.0
2010-11-04 06:30:00	MSFT	Stock	27.44	27.44	27.44	27.44	2000.0
2010-11-04 07:00:00	MSFT	Stock	27.4	27.4	27.35	27.4	2700.0
2010-11-04 07:30:00	MSFT	Stock	27.4	27.4	27.37	27.38	2300.0
2010-11-04 08:00:00	MSFT	Stock	27.35	27.4	27.29	27.31	48700.0
2010-11-04 08:30:00	MSFT	Stock	27.32	27.35	27.32	27.35	52793.0
2010-11-04 09:00:00	MSFT	Stock	27.35	27.44	27.35	27.43	270722.0
2010-11-04 09:30:00	MSFT	Stock	27.41	27.43	27.15	27.15	11217201.0
2010-11-04 10:00:00	MSFT	Stock	27.16	27.25	27.09	27.22	7491358.0
2010-11-04 10:30:00	MSFT	Stock	27.23	27.23	27.1	27.175	5037198.0
2010-11-04 11:00:00	MSFT	Stock	27.17	27.22	27.16	27.2	5095450.0
2010-11-04 11:30:00	MSFT	Stock	27.199	27.22	27.11	27.122	3591094.0
2010-11-04 12:00:00	MSFT	Stock	27.115	27.19	27.07	27.165	5325516.0
2010-11-04 12:30:00	MSFT	Stock	27.165	27.19	27.15	27.17	2941463.0
2010-11-04 13:00:00	MSFT	Stock	27.17	27.19	27.14	27.16	2150437.0
2010-11-04 13:30:00	MSFT	Stock	27.16	27.175	27.06	27.135	3779332.0
2010-11-04 14:00:00	MSFT	Stock	27.135	27.2	27.13	27.175	4240310.0
2010-11-04 14:30:00	MSFT	Stock	27.18	27.21	27.12	27.141	2922991.0
2010-11-04 15:00:00	MSFT	Stock	27.15	27.17	27.12	27.155	3330422.0

> showing 50 of 76,955 rows — these rows as CSV

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