PREVIEW / stock_30min / 2010-03-29

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-29.parquet
  size:    1.4 MB
  rows:    74,596
  symbols: 3,471

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-03-29 04:00:00	AAPL	Stock	8.3179	8.3211	8.2964	8.3211	36904.0
2010-03-29 04:30:00	AAPL	Stock	8.3214	8.3304	8.3214	8.3304	11200.0
2010-03-29 05:00:00	AAPL	Stock	8.3343	8.3679	8.3343	8.3679	12712.0
2010-03-29 05:30:00	AAPL	Stock	8.3743	8.375	8.3536	8.3536	333200.0
2010-03-29 06:00:00	AAPL	Stock	8.3571	8.3571	8.3571	8.3571	3500.0
2010-03-29 06:30:00	AAPL	Stock	8.3571	8.3571	8.3525	8.3571	28000.0
2010-03-29 07:00:00	AAPL	Stock	8.3571	8.375	8.3432	8.3518	583492.0
2010-03-29 07:30:00	AAPL	Stock	8.3518	8.3593	8.3325	8.3386	382004.0
2010-03-29 08:00:00	AAPL	Stock	8.3589	8.3696	8.3214	8.3357	1564892.0
2010-03-29 08:30:00	AAPL	Stock	8.3357	8.3411	8.3282	8.3357	1291388.0
2010-03-29 09:00:00	AAPL	Stock	8.3361	8.3361	8.3132	8.3214	1620528.0
2010-03-29 09:30:00	AAPL	Stock	8.3179	8.3525	8.3129	8.3343	73514504.0
2010-03-29 10:00:00	AAPL	Stock	8.3343	8.345	8.2954	8.3264	56972160.0
2010-03-29 10:30:00	AAPL	Stock	8.3279	8.3386	8.3154	8.3282	32278876.0
2010-03-29 11:00:00	AAPL	Stock	8.3279	8.3393	8.3136	8.3343	21893452.0
2010-03-29 11:30:00	AAPL	Stock	8.3343	8.3375	8.3271	8.3279	12396664.0
2010-03-29 12:00:00	AAPL	Stock	8.3279	8.3289	8.3118	8.3147	13727672.0
2010-03-29 12:30:00	AAPL	Stock	8.315	8.3214	8.3039	8.3118	14535024.0
2010-03-29 13:00:00	AAPL	Stock	8.31	8.3248	8.305	8.305	17294340.0
2010-03-29 13:30:00	AAPL	Stock	8.3046	8.3121	8.2857	8.2996	30094064.0
2010-03-29 14:00:00	AAPL	Stock	8.2994	8.2996	8.2725	8.2768	23189516.0
2010-03-29 14:30:00	AAPL	Stock	8.2761	8.2979	8.2721	8.2914	24242904.0
2010-03-29 15:00:00	AAPL	Stock	8.2925	8.305	8.2911	8.295	20132924.0
2010-03-29 15:30:00	AAPL	Stock	8.295	8.3018	8.2825	8.3018	35657356.0
2010-03-29 16:00:00	AAPL	Stock	8.2996	8.3287	8.2464	8.292	7953540.0
2010-03-29 16:30:00	AAPL	Stock	8.2921	8.3004	8.2921	8.2964	1174152.0
2010-03-29 17:00:00	AAPL	Stock	8.2964	8.4246	8.2961	8.4196	5240368.0
2010-03-29 17:30:00	AAPL	Stock	8.4196	8.5286	8.3914	8.5107	7755384.0
2010-03-29 18:00:00	AAPL	Stock	8.5107	8.5254	8.2996	8.5036	3307976.0
2010-03-29 18:30:00	AAPL	Stock	8.5036	8.5179	8.47	8.4743	2043356.0
2010-03-29 19:00:00	AAPL	Stock	8.4736	8.4857	8.4732	8.4821	1287636.0
2010-03-29 19:30:00	AAPL	Stock	8.4821	8.4854	8.4732	8.4821	1136912.0
2010-03-29 20:00:00	AAPL	Stock	8.3293	8.3293	8.3293	8.3293	75600.0
2010-03-29 04:30:00	MSFT	Stock	29.81	29.81	29.81	29.81	100.0
2010-03-29 07:30:00	MSFT	Stock	29.81	29.81	29.81	29.81	500.0
2010-03-29 08:00:00	MSFT	Stock	29.77	29.8	29.72	29.78	8830.0
2010-03-29 08:30:00	MSFT	Stock	29.73	29.78	29.72	29.78	12160.0
2010-03-29 09:00:00	MSFT	Stock	29.77	29.79	29.65	29.71	20915.0
2010-03-29 09:30:00	MSFT	Stock	29.71	29.82	29.6	29.616	4136387.0
2010-03-29 10:00:00	MSFT	Stock	29.62	29.72	29.6	29.67	3298414.0
2010-03-29 10:30:00	MSFT	Stock	29.67	29.71	29.66	29.695	2628058.0
2010-03-29 11:00:00	MSFT	Stock	29.692	29.72	29.66	29.7	1703270.0
2010-03-29 11:30:00	MSFT	Stock	29.699	29.72	29.66	29.7	1772900.0
2010-03-29 12:00:00	MSFT	Stock	29.7	29.72	29.65	29.67	1344122.0
2010-03-29 12:30:00	MSFT	Stock	29.67	29.68	29.64	29.65	1580744.0
2010-03-29 13:00:00	MSFT	Stock	29.658	29.69	29.64	29.67	1428871.0
2010-03-29 13:30:00	MSFT	Stock	29.67	29.7	29.625	29.649	1579770.0
2010-03-29 14:00:00	MSFT	Stock	29.64	29.68	29.63	29.64	1268620.0
2010-03-29 14:30:00	MSFT	Stock	29.64	29.69	29.63	29.68	2114356.0
2010-03-29 15:00:00	MSFT	Stock	29.675	29.682	29.63	29.63	1732958.0

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

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