PREVIEW / stock_30min / 2007-10-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-23.parquet
  size:    1.2 MB
  rows:    67,149
  symbols: 3,153

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
2007-10-23 04:00:00	AAPL	Stock	6.6436	6.6436	6.6432	6.6432	76748.0
2007-10-23 04:30:00	AAPL	Stock	6.6432	6.6486	6.6257	6.6257	105252.0
2007-10-23 06:00:00	AAPL	Stock	6.6393	6.6579	6.6393	6.6579	91980.0
2007-10-23 06:30:00	AAPL	Stock	6.6607	6.6925	6.6507	6.6925	233044.0
2007-10-23 07:00:00	AAPL	Stock	6.6857	6.7275	6.6636	6.6875	2911580.0
2007-10-23 07:30:00	AAPL	Stock	6.6907	6.7143	6.6754	6.7125	4773104.0
2007-10-23 08:00:00	AAPL	Stock	6.7071	6.7393	6.6721	6.6946	19759096.0
2007-10-23 08:30:00	AAPL	Stock	6.6946	7.0575	6.6839	6.7061	15569764.0
2007-10-23 09:00:00	AAPL	Stock	6.705	6.7768	6.705	6.7321	34575772.0
2007-10-23 09:30:00	AAPL	Stock	6.7332	6.7357	6.5271	6.6357	499002560.0
2007-10-23 10:00:00	AAPL	Stock	6.6368	6.6675	6.62	6.6575	217009744.0
2007-10-23 10:30:00	AAPL	Stock	6.6582	6.6743	6.6343	6.6436	132630540.0
2007-10-23 11:00:00	AAPL	Stock	6.6425	6.65	6.6018	6.6136	141447012.0
2007-10-23 11:30:00	AAPL	Stock	6.6136	6.6499	6.6071	6.6271	79263884.0
2007-10-23 12:00:00	AAPL	Stock	6.6271	6.6375	6.6179	6.6346	50813000.0
2007-10-23 12:30:00	AAPL	Stock	6.6343	6.6443	6.6236	6.6311	53741296.0
2007-10-23 13:00:00	AAPL	Stock	6.6307	6.6321	6.605	6.6186	52841740.0
2007-10-23 13:30:00	AAPL	Stock	6.6186	6.6321	6.6118	6.6254	47716928.0
2007-10-23 14:00:00	AAPL	Stock	6.6254	6.6564	6.6211	6.6507	73376828.0
2007-10-23 14:30:00	AAPL	Stock	6.65	6.6986	6.6471	6.6857	112816984.0
2007-10-23 15:00:00	AAPL	Stock	6.6857	6.7089	6.6618	6.6882	111247472.0
2007-10-23 15:30:00	AAPL	Stock	6.6889	6.6968	6.6304	6.6486	136109148.0
2007-10-23 16:00:00	AAPL	Stock	6.6471	6.6964	6.2271	6.5939	12616436.0
2007-10-23 16:30:00	AAPL	Stock	6.5929	6.7257	6.5786	6.5946	2217376.0
2007-10-23 17:00:00	AAPL	Stock	6.5979	6.5982	6.2211	6.5714	1912848.0
2007-10-23 17:30:00	AAPL	Stock	6.5714	6.6415	6.5714	6.5911	888356.0
2007-10-23 18:00:00	AAPL	Stock	6.5929	6.6	6.5625	6.5625	1280132.0
2007-10-23 18:30:00	AAPL	Stock	6.5664	6.5714	6.5589	6.5589	328860.0
2007-10-23 19:00:00	AAPL	Stock	6.5625	6.5625	6.5554	6.5607	575820.0
2007-10-23 19:30:00	AAPL	Stock	6.5607	6.5714	6.5593	6.5711	648508.0
2007-10-23 04:00:00	MSFT	Stock	30.6	30.66	30.6	30.66	200.0
2007-10-23 05:00:00	MSFT	Stock	30.69	30.69	30.69	30.69	200.0
2007-10-23 05:30:00	MSFT	Stock	30.7	30.7	30.7	30.7	300.0
2007-10-23 08:00:00	MSFT	Stock	30.76	30.78	30.71	30.77	19302.0
2007-10-23 08:30:00	MSFT	Stock	30.77	30.78	30.73	30.73	40925.0
2007-10-23 09:00:00	MSFT	Stock	30.73	30.86	30.65	30.71	212811.0
2007-10-23 09:30:00	MSFT	Stock	30.71	30.91	30.71	30.84	6801067.0
2007-10-23 10:00:00	MSFT	Stock	30.84	30.99	30.78	30.98	5937609.0
2007-10-23 10:30:00	MSFT	Stock	30.97	31.12	30.83	30.879	5681744.0
2007-10-23 11:00:00	MSFT	Stock	30.88	30.94	30.74	30.82	3654727.0
2007-10-23 11:30:00	MSFT	Stock	30.83	31.0	30.77	30.98	2709095.0
2007-10-23 12:00:00	MSFT	Stock	30.98	30.98	30.81	30.83	1754783.0
2007-10-23 12:30:00	MSFT	Stock	30.82	30.9	30.779	30.85	2265291.0
2007-10-23 13:00:00	MSFT	Stock	30.85	30.92	30.84	30.88	1630587.0
2007-10-23 13:30:00	MSFT	Stock	30.88	30.91	30.84	30.85	1534441.0
2007-10-23 14:00:00	MSFT	Stock	30.85	30.93	30.85	30.912	2873826.0
2007-10-23 14:30:00	MSFT	Stock	30.91	30.94	30.81	30.86	3383922.0
2007-10-23 15:00:00	MSFT	Stock	30.86	30.89	30.78	30.84	2929323.0
2007-10-23 15:30:00	MSFT	Stock	30.85	30.92	30.8	30.9	6123123.0
2007-10-23 16:00:00	MSFT	Stock	30.9	30.91	30.335	30.77	2378383.0

> showing 50 of 67,149 rows — these rows as CSV

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