PREVIEW / stock_30min / 2009-03-31

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-03-31.parquet
  size:    1.3 MB
  rows:    72,066
  symbols: 3,345

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
2009-03-31 07:30:00	AAPL	Stock	3.7518	3.7664	3.7496	3.75	313516.0
2009-03-31 08:00:00	AAPL	Stock	3.7639	3.7661	3.7504	3.7607	276108.0
2009-03-31 08:30:00	AAPL	Stock	3.7607	3.7664	3.7568	3.7607	431396.0
2009-03-31 09:00:00	AAPL	Stock	3.7625	3.7711	3.7607	3.7696	961044.0
2009-03-31 09:30:00	AAPL	Stock	3.7661	3.7864	3.7536	3.772	67820284.0
2009-03-31 10:00:00	AAPL	Stock	3.7714	3.7921	3.7632	3.7804	41731900.0
2009-03-31 10:30:00	AAPL	Stock	3.7804	3.7918	3.7643	3.77	34426196.0
2009-03-31 11:00:00	AAPL	Stock	3.7707	3.7768	3.7546	3.7693	32292764.0
2009-03-31 11:30:00	AAPL	Stock	3.77	3.775	3.7536	3.7607	22629432.0
2009-03-31 12:00:00	AAPL	Stock	3.7607	3.7696	3.7548	3.7614	25235588.0
2009-03-31 12:30:00	AAPL	Stock	3.7621	3.7946	3.7564	3.7946	26603836.0
2009-03-31 13:00:00	AAPL	Stock	3.7943	3.8136	3.7911	3.7989	34369188.0
2009-03-31 13:30:00	AAPL	Stock	3.7996	3.8125	3.7907	3.8021	22262520.0
2009-03-31 14:00:00	AAPL	Stock	3.8021	3.8182	3.7939	3.8114	31721004.0
2009-03-31 14:30:00	AAPL	Stock	3.8125	3.8375	3.8121	3.8261	35879172.0
2009-03-31 15:00:00	AAPL	Stock	3.8257	3.8275	3.7982	3.8182	48803356.0
2009-03-31 15:30:00	AAPL	Stock	3.8196	3.8196	3.75	3.7554	86519748.0
2009-03-31 16:00:00	AAPL	Stock	3.7525	3.8054	3.7507	3.7541	26580848.0
2009-03-31 16:30:00	AAPL	Stock	3.7543	3.7614	3.7529	3.7543	2573144.0
2009-03-31 17:00:00	AAPL	Stock	3.7543	3.7543	3.75	3.7504	2350684.0
2009-03-31 17:30:00	AAPL	Stock	3.75	3.7518	3.75	3.7518	10808.0
2009-03-31 18:00:00	AAPL	Stock	3.7518	3.7543	3.7489	3.75	274204.0
2009-03-31 18:30:00	AAPL	Stock	3.7496	3.7539	3.7471	3.7471	85680.0
2009-03-31 19:00:00	AAPL	Stock	3.7471	3.7471	3.7286	3.7329	111496.0
2009-03-31 19:30:00	AAPL	Stock	3.7304	3.7357	3.73	3.7346	136892.0
2009-03-31 04:00:00	MSFT	Stock	17.7	17.7	17.7	17.7	285.0
2009-03-31 07:00:00	MSFT	Stock	17.74	17.78	17.74	17.78	1600.0
2009-03-31 07:30:00	MSFT	Stock	17.77	17.77	17.77	17.77	2930.0
2009-03-31 08:00:00	MSFT	Stock	17.75	17.83	17.66	17.8	17100.0
2009-03-31 08:30:00	MSFT	Stock	17.79	17.88	17.79	17.83	13500.0
2009-03-31 09:00:00	MSFT	Stock	17.82	17.84	17.78	17.83	25125.0
2009-03-31 09:30:00	MSFT	Stock	17.82	18.4	17.78	18.26	8634113.0
2009-03-31 10:00:00	MSFT	Stock	18.26	18.45	18.17	18.45	6037737.0
2009-03-31 10:30:00	MSFT	Stock	18.45	18.56	18.36	18.39	6468625.0
2009-03-31 11:00:00	MSFT	Stock	18.38	18.53	18.378	18.49	3677891.0
2009-03-31 11:30:00	MSFT	Stock	18.485	18.57	18.46	18.471	3274364.0
2009-03-31 12:00:00	MSFT	Stock	18.48	18.49	18.43	18.47	4217937.0
2009-03-31 12:30:00	MSFT	Stock	18.48	18.58	18.45	18.56	3442885.0
2009-03-31 13:00:00	MSFT	Stock	18.55	18.65	18.54	18.61	3332969.0
2009-03-31 13:30:00	MSFT	Stock	18.61	18.67	18.53	18.6	3849046.0
2009-03-31 14:00:00	MSFT	Stock	18.6	18.73	18.57	18.65	5424520.0
2009-03-31 14:30:00	MSFT	Stock	18.66	18.79	18.65	18.682	4667487.0
2009-03-31 15:00:00	MSFT	Stock	18.69	18.75	18.66	18.73	7019630.0
2009-03-31 15:30:00	MSFT	Stock	18.74	18.74	18.3	18.33	22787143.0
2009-03-31 16:00:00	MSFT	Stock	18.33	18.648	18.3	18.365	6547380.0
2009-03-31 16:30:00	MSFT	Stock	18.486	18.486	18.35	18.37	880418.0
2009-03-31 17:00:00	MSFT	Stock	18.37	18.38	18.28	18.32	296288.0
2009-03-31 17:30:00	MSFT	Stock	18.32	18.32	18.3	18.32	1570.0
2009-03-31 18:00:00	MSFT	Stock	18.33	18.37	18.29	18.32	322904.0
2009-03-31 18:30:00	MSFT	Stock	18.33	18.34	18.33	18.34	600.0

> showing 50 of 72,066 rows — these rows as CSV

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