PREVIEW / stock_30min / 2007-11-06

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-06.parquet
  size:    1.2 MB
  rows:    68,380
  symbols: 3,190

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-11-06 04:00:00	AAPL	Stock	6.6493	6.6493	6.6493	6.6493	5600.0
2007-11-06 05:00:00	AAPL	Stock	6.6493	6.6682	6.6493	6.6682	8176.0
2007-11-06 05:30:00	AAPL	Stock	6.6682	6.6682	6.6682	6.6682	5600.0
2007-11-06 06:30:00	AAPL	Stock	6.6964	6.715	6.6964	6.715	95200.0
2007-11-06 07:00:00	AAPL	Stock	6.7179	6.7321	6.7121	6.7143	259000.0
2007-11-06 07:30:00	AAPL	Stock	6.7179	6.7232	6.7121	6.7196	208768.0
2007-11-06 08:00:00	AAPL	Stock	6.7196	6.7196	6.6893	6.6957	2183552.0
2007-11-06 08:30:00	AAPL	Stock	6.6957	6.7036	6.6875	6.6889	1381660.0
2007-11-06 09:00:00	AAPL	Stock	6.6864	6.7018	6.6786	6.6843	1338540.0
2007-11-06 09:30:00	AAPL	Stock	6.685	6.7075	6.6689	6.6943	79633428.0
2007-11-06 10:00:00	AAPL	Stock	6.6944	6.7139	6.6789	6.6893	61798520.0
2007-11-06 10:30:00	AAPL	Stock	6.6882	6.6893	6.6168	6.6429	86570988.0
2007-11-06 11:00:00	AAPL	Stock	6.6443	6.6739	6.6339	6.6507	54090848.0
2007-11-06 11:30:00	AAPL	Stock	6.6507	6.6857	6.6329	6.6714	68806360.0
2007-11-06 12:00:00	AAPL	Stock	6.6718	6.6932	6.6554	6.6763	48769560.0
2007-11-06 12:30:00	AAPL	Stock	6.6768	6.6893	6.6729	6.6796	24892000.0
2007-11-06 13:00:00	AAPL	Stock	6.6789	6.7071	6.6789	6.6979	39791836.0
2007-11-06 13:30:00	AAPL	Stock	6.6975	6.7286	6.6904	6.7118	53718588.0
2007-11-06 14:00:00	AAPL	Stock	6.7118	6.7204	6.6964	6.7089	42837732.0
2007-11-06 14:30:00	AAPL	Stock	6.7093	6.7857	6.7029	6.7468	77098112.0
2007-11-06 15:00:00	AAPL	Stock	6.7496	6.8136	6.7454	6.805	160417544.0
2007-11-06 15:30:00	AAPL	Stock	6.8052	6.8571	6.7975	6.8539	129805844.0
2007-11-06 16:00:00	AAPL	Stock	6.8536	6.8632	6.6961	6.8611	19371660.0
2007-11-06 16:30:00	AAPL	Stock	6.8611	6.8632	6.8496	6.8621	612248.0
2007-11-06 17:00:00	AAPL	Stock	6.8621	6.8625	6.8496	6.8589	604072.0
2007-11-06 17:30:00	AAPL	Stock	6.6825	6.8632	6.6825	6.8611	482468.0
2007-11-06 18:00:00	AAPL	Stock	6.8593	6.8643	6.8586	6.8589	76636.0
2007-11-06 18:30:00	AAPL	Stock	6.8589	6.8607	6.6618	6.8571	259700.0
2007-11-06 19:00:00	AAPL	Stock	6.8571	6.8607	6.8543	6.8589	118020.0
2007-11-06 19:30:00	AAPL	Stock	6.8607	6.8664	6.8571	6.8625	264236.0
2007-11-06 07:00:00	MSFT	Stock	36.73	36.75	36.67	36.73	29400.0
2007-11-06 07:30:00	MSFT	Stock	36.72	36.72	36.4	36.5	39400.0
2007-11-06 08:00:00	MSFT	Stock	36.5	36.7	36.4	36.68	92341.0
2007-11-06 08:30:00	MSFT	Stock	36.65	36.69	36.62	36.69	26745.0
2007-11-06 09:00:00	MSFT	Stock	36.69	36.77	36.56	36.59	88763.0
2007-11-06 09:30:00	MSFT	Stock	36.59	36.68	36.43	36.49	8315586.0
2007-11-06 10:00:00	MSFT	Stock	36.49	36.52	36.125	36.192	10033761.0
2007-11-06 10:30:00	MSFT	Stock	36.19	36.23	36.07	36.14	10911548.0
2007-11-06 11:00:00	MSFT	Stock	36.14	36.22	35.99	36.0	11402344.0
2007-11-06 11:30:00	MSFT	Stock	36.005	37.22	35.87	35.99	9700075.0
2007-11-06 12:00:00	MSFT	Stock	35.98	36.05	35.91	35.96	4430024.0
2007-11-06 12:30:00	MSFT	Stock	35.97	36.08	35.97	36.05	3169823.0
2007-11-06 13:00:00	MSFT	Stock	36.048	36.18	36.04	36.15	4049723.0
2007-11-06 13:30:00	MSFT	Stock	36.15	36.37	36.15	36.28	6633183.0
2007-11-06 14:00:00	MSFT	Stock	36.28	36.35	36.21	36.215	4344488.0
2007-11-06 14:30:00	MSFT	Stock	36.21	36.35	36.16	36.31	4125825.0
2007-11-06 15:00:00	MSFT	Stock	36.31	36.47	36.012	36.43	8750109.0
2007-11-06 15:30:00	MSFT	Stock	36.422	36.45	36.37	36.41	10994774.0
2007-11-06 16:00:00	MSFT	Stock	36.41	36.6	36.185	36.41	5637731.0
2007-11-06 16:30:00	MSFT	Stock	36.42	36.47	36.41	36.43	102097.0

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

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