PREVIEW / stock_30min / 2008-04-02

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-02.parquet
  size:    1.2 MB
  rows:    68,819
  symbols: 3,279

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-04-02 04:30:00	AAPL	Stock	5.3614	5.3614	5.3546	5.3546	19600.0
2008-04-02 07:00:00	AAPL	Stock	5.3493	5.3661	5.3443	5.3536	581392.0
2008-04-02 07:30:00	AAPL	Stock	5.3482	5.3482	5.3143	5.3282	1060528.0
2008-04-02 08:00:00	AAPL	Stock	5.3282	5.3404	5.3036	5.3132	7659540.0
2008-04-02 08:30:00	AAPL	Stock	5.3143	5.3264	5.3075	5.3214	1609020.0
2008-04-02 09:00:00	AAPL	Stock	5.3196	5.3432	5.3036	5.3114	15859284.0
2008-04-02 09:30:00	AAPL	Stock	5.3136	5.35	5.2832	5.3229	132898164.0
2008-04-02 10:00:00	AAPL	Stock	5.3221	5.3964	5.3011	5.3875	123193196.0
2008-04-02 10:30:00	AAPL	Stock	5.3875	5.4	5.3736	5.3782	85213632.0
2008-04-02 11:00:00	AAPL	Stock	5.3782	5.3821	5.3482	5.3521	62006644.0
2008-04-02 11:30:00	AAPL	Stock	5.3518	5.3696	5.3457	5.3489	43075256.0
2008-04-02 12:00:00	AAPL	Stock	5.3496	5.3657	5.3214	5.3225	54740308.0
2008-04-02 12:30:00	AAPL	Stock	5.3221	5.3304	5.2732	5.2811	75767552.0
2008-04-02 13:00:00	AAPL	Stock	5.2821	5.2975	5.2536	5.2764	65255540.0
2008-04-02 13:30:00	AAPL	Stock	5.2761	5.3061	5.2714	5.2825	52317216.0
2008-04-02 14:00:00	AAPL	Stock	5.2822	5.3189	5.2789	5.2841	46232060.0
2008-04-02 14:30:00	AAPL	Stock	5.2836	5.2871	5.2293	5.2396	77357112.0
2008-04-02 15:00:00	AAPL	Stock	5.24	5.2639	5.2089	5.26	80118612.0
2008-04-02 15:30:00	AAPL	Stock	5.2596	5.2679	5.2474	5.2668	75603780.0
2008-04-02 16:00:00	AAPL	Stock	5.2668	5.3393	5.2143	5.2857	15531152.0
2008-04-02 16:30:00	AAPL	Stock	5.2929	5.3214	5.2675	5.3161	2082668.0
2008-04-02 17:00:00	AAPL	Stock	5.3107	5.3411	5.3071	5.3407	4148816.0
2008-04-02 17:30:00	AAPL	Stock	5.3375	5.3407	5.3214	5.325	1472044.0
2008-04-02 18:00:00	AAPL	Stock	5.3232	5.33	5.3036	5.3036	967792.0
2008-04-02 18:30:00	AAPL	Stock	5.3071	5.3214	5.3071	5.3171	170016.0
2008-04-02 19:00:00	AAPL	Stock	5.3164	5.3168	5.3107	5.3121	175896.0
2008-04-02 19:30:00	AAPL	Stock	5.3139	5.3171	5.3107	5.3171	295316.0
2008-04-02 07:30:00	MSFT	Stock	29.49	29.49	29.49	29.49	100.0
2008-04-02 08:00:00	MSFT	Stock	29.5	29.6	29.49	29.6	34964.0
2008-04-02 08:30:00	MSFT	Stock	29.6	29.64	29.57	29.64	17525.0
2008-04-02 09:00:00	MSFT	Stock	29.65	29.67	29.43	29.55	48905.0
2008-04-02 09:30:00	MSFT	Stock	29.56	29.58	29.082	29.19	9690011.0
2008-04-02 10:00:00	MSFT	Stock	29.19	29.34	29.14	29.32	4428668.0
2008-04-02 10:30:00	MSFT	Stock	29.32	29.33	29.25	29.27	4202544.0
2008-04-02 11:00:00	MSFT	Stock	29.28	29.3	29.2	29.24	3203374.0
2008-04-02 11:30:00	MSFT	Stock	29.232	29.3	29.21	29.29	2116172.0
2008-04-02 12:00:00	MSFT	Stock	29.283	29.32	29.2	29.215	1695718.0
2008-04-02 12:30:00	MSFT	Stock	29.21	29.31	29.21	29.24	2341893.0
2008-04-02 13:00:00	MSFT	Stock	29.24	29.25	29.13	29.22	2066921.0
2008-04-02 13:30:00	MSFT	Stock	29.22	29.25	29.15	29.15	1936821.0
2008-04-02 14:00:00	MSFT	Stock	29.16	29.23	29.1	29.12	2363846.0
2008-04-02 14:30:00	MSFT	Stock	29.118	29.13	29.0	29.079	3543571.0
2008-04-02 15:00:00	MSFT	Stock	29.08	29.09	29.01	29.06	3739257.0
2008-04-02 15:30:00	MSFT	Stock	29.067	29.17	29.0	29.15	4896080.0
2008-04-02 16:00:00	MSFT	Stock	29.16	29.24	29.099	29.2	1261445.0
2008-04-02 16:30:00	MSFT	Stock	29.2	29.22	29.16	29.21	209048.0
2008-04-02 17:00:00	MSFT	Stock	29.21	29.21	29.2	29.21	4126.0
2008-04-02 17:30:00	MSFT	Stock	29.22	29.23	29.22	29.22	5003.0
2008-04-02 18:00:00	MSFT	Stock	29.2	29.2	29.2	29.2	4100.0
2008-04-02 18:30:00	MSFT	Stock	29.18	29.2	29.18	29.2	2000.0

> showing 50 of 68,819 rows — these rows as CSV

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