PREVIEW / stock_30min / 2008-08-15

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-15.parquet
  size:    1.2 MB
  rows:    69,071
  symbols: 3,326

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-08-15 06:30:00	AAPL	Stock	6.3914	6.3914	6.3914	6.3914	5600.0
2008-08-15 07:00:00	AAPL	Stock	6.3854	6.3971	6.3643	6.3804	78400.0
2008-08-15 07:30:00	AAPL	Stock	6.3821	6.3875	6.3661	6.3661	64820.0
2008-08-15 08:00:00	AAPL	Stock	6.3839	6.4036	6.3696	6.4025	419020.0
2008-08-15 08:30:00	AAPL	Stock	6.4043	6.4286	6.3964	6.3964	1113756.0
2008-08-15 09:00:00	AAPL	Stock	6.3964	6.3979	6.3893	6.3957	886620.0
2008-08-15 09:30:00	AAPL	Stock	6.3918	6.4196	6.3232	6.3546	111200460.0
2008-08-15 10:00:00	AAPL	Stock	6.3554	6.375	6.2807	6.3568	65833544.0
2008-08-15 10:30:00	AAPL	Stock	6.3554	6.3921	6.3546	6.3843	48248536.0
2008-08-15 11:00:00	AAPL	Stock	6.3846	6.3864	6.3671	6.385	31084900.0
2008-08-15 11:30:00	AAPL	Stock	6.3854	6.3975	6.3614	6.365	39840220.0
2008-08-15 12:00:00	AAPL	Stock	6.3657	6.3857	6.3504	6.3575	29410164.0
2008-08-15 12:30:00	AAPL	Stock	6.3569	6.3746	6.3518	6.3572	20131160.0
2008-08-15 13:00:00	AAPL	Stock	6.3571	6.3629	6.3414	6.3454	19604676.0
2008-08-15 13:30:00	AAPL	Stock	6.345	6.345	6.2686	6.2718	50303288.0
2008-08-15 14:00:00	AAPL	Stock	6.2714	6.2911	6.2518	6.2825	68006568.0
2008-08-15 14:30:00	AAPL	Stock	6.2825	6.2911	6.2568	6.2786	34286588.0
2008-08-15 15:00:00	AAPL	Stock	6.28	6.3011	6.2743	6.3002	34243608.0
2008-08-15 15:30:00	AAPL	Stock	6.3	6.3036	6.2564	6.275	71282848.0
2008-08-15 16:00:00	AAPL	Stock	6.2757	6.3358	6.2689	6.2689	10110296.0
2008-08-15 16:30:00	AAPL	Stock	6.2689	6.2764	6.2689	6.2732	137312.0
2008-08-15 17:00:00	AAPL	Stock	6.2736	6.2771	6.2729	6.2768	113120.0
2008-08-15 17:30:00	AAPL	Stock	6.2768	6.31	6.2768	6.2843	238280.0
2008-08-15 18:00:00	AAPL	Stock	6.2814	6.2832	6.2786	6.2786	38696.0
2008-08-15 18:30:00	AAPL	Stock	6.2786	6.2786	6.2771	6.2771	27692.0
2008-08-15 19:00:00	AAPL	Stock	6.2768	6.2768	6.275	6.275	12292.0
2008-08-15 19:30:00	AAPL	Stock	6.2754	6.2768	6.2718	6.2718	17752.0
2008-08-15 07:30:00	MSFT	Stock	27.85	27.85	27.85	27.85	1200.0
2008-08-15 08:00:00	MSFT	Stock	27.85	27.91	27.85	27.85	2675.0
2008-08-15 08:30:00	MSFT	Stock	27.95	27.97	27.95	27.95	2050.0
2008-08-15 09:00:00	MSFT	Stock	27.95	28.0	27.95	27.96	6110.0
2008-08-15 09:30:00	MSFT	Stock	27.92	28.15	27.81	27.848	11524872.0
2008-08-15 10:00:00	MSFT	Stock	27.85	27.89	27.67	27.81	4053708.0
2008-08-15 10:30:00	MSFT	Stock	27.81	28.03	27.81	28.01	3183214.0
2008-08-15 11:00:00	MSFT	Stock	28.02	28.02	27.85	27.95	2395240.0
2008-08-15 11:30:00	MSFT	Stock	27.94	28.01	27.84	27.853	2137896.0
2008-08-15 12:00:00	MSFT	Stock	27.86	27.87	27.75	27.86	1844909.0
2008-08-15 12:30:00	MSFT	Stock	27.86	27.9	27.82	27.86	1093468.0
2008-08-15 13:00:00	MSFT	Stock	27.86	27.87	27.75	27.78	1368947.0
2008-08-15 13:30:00	MSFT	Stock	27.78	27.8	27.74	27.75	1232943.0
2008-08-15 14:00:00	MSFT	Stock	27.752	27.82	27.62	27.64	4187415.0
2008-08-15 14:30:00	MSFT	Stock	27.64	27.76	27.58	27.73	3310529.0
2008-08-15 15:00:00	MSFT	Stock	27.72	27.85	27.72	27.812	2641133.0
2008-08-15 15:30:00	MSFT	Stock	27.82	27.83	27.69	27.8	4573834.0
2008-08-15 16:00:00	MSFT	Stock	27.81	27.865	27.722	27.81	3036339.0
2008-08-15 16:30:00	MSFT	Stock	27.84	27.84	27.81	27.81	1500.0
2008-08-15 17:00:00	MSFT	Stock	27.78	27.78	27.78	27.78	200.0
2008-08-15 17:30:00	MSFT	Stock	27.81	27.83	27.8	27.83	700.0
2008-08-15 19:30:00	MSFT	Stock	27.83	27.85	27.83	27.85	865.0
2008-08-15 20:00:00	MSFT	Stock	27.99	27.99	27.99	27.99	763.0

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

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