PREVIEW / stock_30min / 2008-03-07

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-07.parquet
  size:    1.2 MB
  rows:    69,595
  symbols: 3,264

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
2008-03-07 07:00:00	AAPL	Stock	4.3607	4.3607	4.3529	4.3571	110600.0
2008-03-07 07:30:00	AAPL	Stock	4.3571	4.3589	4.3446	4.3589	279832.0
2008-03-07 08:00:00	AAPL	Stock	4.3575	4.3786	4.3254	4.3564	4003692.0
2008-03-07 08:30:00	AAPL	Stock	4.3432	4.3564	4.3032	4.3157	4644052.0
2008-03-07 09:00:00	AAPL	Stock	4.3161	4.3214	4.2739	4.3004	5538232.0
2008-03-07 09:30:00	AAPL	Stock	4.3011	4.3589	4.2804	4.3464	183634612.0
2008-03-07 10:00:00	AAPL	Stock	4.345	4.3711	4.3321	4.3479	123918060.0
2008-03-07 10:30:00	AAPL	Stock	4.3486	4.3921	4.3421	4.3664	99982764.0
2008-03-07 11:00:00	AAPL	Stock	4.3664	4.3757	4.3343	4.3404	64423800.0
2008-03-07 11:30:00	AAPL	Stock	4.3404	4.3546	4.3257	4.3314	67270532.0
2008-03-07 12:00:00	AAPL	Stock	4.3311	4.3382	4.2954	4.3075	57136156.0
2008-03-07 12:30:00	AAPL	Stock	4.3079	4.3311	4.3014	4.3193	51904496.0
2008-03-07 13:00:00	AAPL	Stock	4.3196	4.3209	4.2854	4.3043	50601208.0
2008-03-07 13:30:00	AAPL	Stock	4.305	4.3061	4.2582	4.2582	77531552.0
2008-03-07 14:00:00	AAPL	Stock	4.2589	4.2921	4.2536	4.2682	76226276.0
2008-03-07 14:30:00	AAPL	Stock	4.2679	4.3129	4.2518	4.3129	74767476.0
2008-03-07 15:00:00	AAPL	Stock	4.3124	4.3868	4.2936	4.3568	148903216.0
2008-03-07 15:30:00	AAPL	Stock	4.3571	4.3786	4.3336	4.3718	122455004.0
2008-03-07 16:00:00	AAPL	Stock	4.3721	4.3746	4.3145	4.326	15478596.0
2008-03-07 16:30:00	AAPL	Stock	4.3496	4.3661	4.3464	4.3536	601664.0
2008-03-07 17:00:00	AAPL	Stock	4.3536	4.3725	4.3468	4.3643	1165752.0
2008-03-07 17:30:00	AAPL	Stock	4.3657	4.3657	4.3582	4.36	78960.0
2008-03-07 18:00:00	AAPL	Stock	4.36	4.3607	4.3507	4.3507	57876.0
2008-03-07 18:30:00	AAPL	Stock	4.3511	4.3571	4.3507	4.3571	44100.0
2008-03-07 19:00:00	AAPL	Stock	4.3554	4.3554	4.3529	4.355	21000.0
2008-03-07 19:30:00	AAPL	Stock	4.3521	4.355	4.3496	4.3536	125384.0
2008-03-07 07:00:00	MSFT	Stock	27.58	27.58	27.58	27.58	800.0
2008-03-07 07:30:00	MSFT	Stock	27.58	27.62	27.58	27.62	3182.0
2008-03-07 08:00:00	MSFT	Stock	27.6	27.68	27.51	27.68	20800.0
2008-03-07 08:30:00	MSFT	Stock	27.58	27.58	27.35	27.44	49588.0
2008-03-07 09:00:00	MSFT	Stock	27.45	27.46	27.31	27.32	122008.0
2008-03-07 09:30:00	MSFT	Stock	27.33	27.86	27.32	27.8	9669683.0
2008-03-07 10:00:00	MSFT	Stock	27.81	27.94	27.63	27.912	7933778.0
2008-03-07 10:30:00	MSFT	Stock	27.92	28.02	27.87	27.95	6425899.0
2008-03-07 11:00:00	MSFT	Stock	27.96	27.982	27.74	27.75	4008820.0
2008-03-07 11:30:00	MSFT	Stock	27.75	27.78	27.58	27.65	4370066.0
2008-03-07 12:00:00	MSFT	Stock	27.655	27.73	27.61	27.67	2712406.0
2008-03-07 12:30:00	MSFT	Stock	27.67	27.72	27.61	27.67	2675308.0
2008-03-07 13:00:00	MSFT	Stock	27.67	27.69	27.58	27.68	2639218.0
2008-03-07 13:30:00	MSFT	Stock	27.69	27.69	27.54	27.56	3167937.0
2008-03-07 14:00:00	MSFT	Stock	27.55	27.67	27.46	27.54	5819024.0
2008-03-07 14:30:00	MSFT	Stock	27.53	27.76	27.46	27.76	5504084.0
2008-03-07 15:00:00	MSFT	Stock	27.76	28.06	27.62	27.92	8677119.0
2008-03-07 15:30:00	MSFT	Stock	27.93	28.07	27.86	27.87	11098691.0
2008-03-07 16:00:00	MSFT	Stock	27.89	27.92	27.752	27.781	2602722.0
2008-03-07 16:30:00	MSFT	Stock	27.87	27.87	27.83	27.87	20992.0
2008-03-07 17:00:00	MSFT	Stock	27.86	27.87	27.84	27.87	81475.0
2008-03-07 17:30:00	MSFT	Stock	27.355	27.89	27.355	27.496	20385.0
2008-03-07 18:00:00	MSFT	Stock	27.85	27.85	27.8	27.8	3900.0
2008-03-07 18:30:00	MSFT	Stock	27.82	27.83	27.8	27.83	2100.0

> showing 50 of 69,595 rows — these rows as CSV

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