PREVIEW / stock_30min / 2007-01-31

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-31.parquet
  size:    997 KB
  rows:    53,680
  symbols: 2,505

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-01-31 06:00:00	AAPL	Stock	3.0554	3.0554	3.0554	3.0554	5600.0
2007-01-31 06:30:00	AAPL	Stock	3.0468	3.0468	3.0468	3.0468	2800.0
2007-01-31 07:00:00	AAPL	Stock	3.0436	3.0436	3.0321	3.0321	26880.0
2007-01-31 07:30:00	AAPL	Stock	3.0446	3.0446	3.0446	3.0446	2800.0
2007-01-31 08:00:00	AAPL	Stock	3.0464	3.05	3.0411	3.0446	928032.0
2007-01-31 08:30:00	AAPL	Stock	3.0429	3.0479	3.0357	3.0421	1296036.0
2007-01-31 09:00:00	AAPL	Stock	3.0411	3.0457	3.0214	3.0314	5208140.0
2007-01-31 09:30:00	AAPL	Stock	3.0307	3.0407	3.0125	3.0193	133209776.0
2007-01-31 10:00:00	AAPL	Stock	3.0196	3.0429	3.0182	3.0325	86199372.0
2007-01-31 10:30:00	AAPL	Stock	3.0325	3.0443	3.0289	3.0371	69632136.0
2007-01-31 11:00:00	AAPL	Stock	3.0371	3.0375	3.0254	3.0282	32004252.0
2007-01-31 11:30:00	AAPL	Stock	3.0282	3.0329	3.0232	3.0286	27849332.0
2007-01-31 12:00:00	AAPL	Stock	3.0286	3.0296	3.0179	3.0211	37343572.0
2007-01-31 12:30:00	AAPL	Stock	3.0214	3.0239	3.0175	3.0232	22098216.0
2007-01-31 13:00:00	AAPL	Stock	3.0232	3.025	3.0179	3.0207	20401668.0
2007-01-31 13:30:00	AAPL	Stock	3.0207	3.0239	3.0179	3.0204	22263220.0
2007-01-31 14:00:00	AAPL	Stock	3.02	3.0357	3.0161	3.0279	80788848.0
2007-01-31 14:30:00	AAPL	Stock	3.0279	3.0554	3.0236	3.0461	108127656.0
2007-01-31 15:00:00	AAPL	Stock	3.0461	3.0711	3.0414	3.0704	108152352.0
2007-01-31 15:30:00	AAPL	Stock	3.07	3.0714	3.0589	3.0614	77828212.0
2007-01-31 16:00:00	AAPL	Stock	3.0639	3.0696	3.0425	3.0554	2900492.0
2007-01-31 16:30:00	AAPL	Stock	3.0554	3.0618	3.0475	3.0564	1291276.0
2007-01-31 17:00:00	AAPL	Stock	3.0546	3.0586	3.0532	3.0546	306740.0
2007-01-31 17:30:00	AAPL	Stock	3.0557	3.0607	3.0557	3.0571	315700.0
2007-01-31 18:00:00	AAPL	Stock	3.0571	3.0618	3.0554	3.0604	158900.0
2007-01-31 18:30:00	AAPL	Stock	3.0607	3.0636	3.0607	3.0625	78876.0
2007-01-31 19:00:00	AAPL	Stock	3.0617	3.0625	3.0589	3.0589	43176.0
2007-01-31 19:30:00	AAPL	Stock	3.0543	3.0625	3.0532	3.0607	76160.0
2007-01-31 07:00:00	MSFT	Stock	30.36	30.36	30.36	30.36	200.0
2007-01-31 07:30:00	MSFT	Stock	30.38	30.38	30.38	30.38	100.0
2007-01-31 08:00:00	MSFT	Stock	30.35	30.38	30.31	30.31	8530.0
2007-01-31 08:30:00	MSFT	Stock	30.35	30.38	30.35	30.38	8624.0
2007-01-31 09:00:00	MSFT	Stock	30.37	30.41	30.32	30.41	21400.0
2007-01-31 09:30:00	MSFT	Stock	30.41	30.463	30.35	30.403	5932742.0
2007-01-31 10:00:00	MSFT	Stock	30.4	30.55	30.37	30.47	6004003.0
2007-01-31 10:30:00	MSFT	Stock	30.47	30.94	30.46	30.64	8301953.0
2007-01-31 11:00:00	MSFT	Stock	30.64	30.65	30.5	30.56	3835900.0
2007-01-31 11:30:00	MSFT	Stock	30.56	30.68	30.474	30.66	3135134.0
2007-01-31 12:00:00	MSFT	Stock	30.66	30.671	30.53	30.55	3858230.0
2007-01-31 12:30:00	MSFT	Stock	30.55	30.65	30.474	30.65	5247687.0
2007-01-31 13:00:00	MSFT	Stock	30.64	30.68	30.59	30.63	1879483.0
2007-01-31 13:30:00	MSFT	Stock	30.63	30.66	30.58	30.62	2664154.0
2007-01-31 14:00:00	MSFT	Stock	30.62	30.82	30.6	30.75	6723946.0
2007-01-31 14:30:00	MSFT	Stock	30.75	30.96	30.73	30.94	5761492.0
2007-01-31 15:00:00	MSFT	Stock	30.95	31.1	30.92	30.97	7436318.0
2007-01-31 15:30:00	MSFT	Stock	30.96	31.0	30.8	30.86	8443544.0
2007-01-31 16:00:00	MSFT	Stock	30.87	31.0	30.77	30.81	119908.0
2007-01-31 16:30:00	MSFT	Stock	30.78	30.86	30.76	30.8	172896.0
2007-01-31 17:00:00	MSFT	Stock	30.8	30.86	30.79	30.86	30854.0
2007-01-31 17:30:00	MSFT	Stock	30.8	30.8	30.8	30.8	5700.0

> showing 50 of 53,680 rows — these rows as CSV

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