PREVIEW / stock_30min / 2007-12-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-20.parquet
  size:    1.2 MB
  rows:    70,600
  symbols: 3,257

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-12-20 04:00:00	AAPL	Stock	6.5807	6.5807	6.5807	6.5807	2800.0
2007-12-20 07:00:00	AAPL	Stock	6.6068	6.6068	6.6068	6.6068	7756.0
2007-12-20 07:30:00	AAPL	Stock	6.6057	6.6057	6.5768	6.5882	112000.0
2007-12-20 08:00:00	AAPL	Stock	6.5821	6.6071	6.5714	6.5982	2008020.0
2007-12-20 08:30:00	AAPL	Stock	6.5982	6.6054	6.5821	6.5914	1451044.0
2007-12-20 09:00:00	AAPL	Stock	6.5911	6.6246	6.5911	6.62	2343908.0
2007-12-20 09:30:00	AAPL	Stock	6.6193	6.6236	6.5643	6.575	87154816.0
2007-12-20 10:00:00	AAPL	Stock	6.5744	6.6304	6.5475	6.5718	71234632.0
2007-12-20 10:30:00	AAPL	Stock	6.5718	6.6021	6.5604	6.5718	60998308.0
2007-12-20 11:00:00	AAPL	Stock	6.5721	6.5843	6.5554	6.5811	43933092.0
2007-12-20 11:30:00	AAPL	Stock	6.5821	6.5836	6.5661	6.5682	24882228.0
2007-12-20 12:00:00	AAPL	Stock	6.5679	6.5811	6.5504	6.5796	35422380.0
2007-12-20 12:30:00	AAPL	Stock	6.58	6.5821	6.5675	6.5736	21084252.0
2007-12-20 13:00:00	AAPL	Stock	6.5732	6.6125	6.5718	6.6007	38974376.0
2007-12-20 13:30:00	AAPL	Stock	6.6004	6.6346	6.5989	6.6286	54630548.0
2007-12-20 14:00:00	AAPL	Stock	6.6282	6.6782	6.6107	6.6754	70933856.0
2007-12-20 14:30:00	AAPL	Stock	6.6757	6.6964	6.6571	6.6725	72615200.0
2007-12-20 15:00:00	AAPL	Stock	6.6725	6.7082	6.6561	6.6945	80936912.0
2007-12-20 15:30:00	AAPL	Stock	6.6936	6.6982	6.675	6.6839	76563704.0
2007-12-20 16:00:00	AAPL	Stock	6.6854	6.7857	6.6202	6.7786	19873252.0
2007-12-20 16:30:00	AAPL	Stock	6.7786	6.7857	6.7575	6.7575	3435348.0
2007-12-20 17:00:00	AAPL	Stock	6.7582	6.7754	6.6861	6.7754	1939448.0
2007-12-20 17:30:00	AAPL	Stock	6.6197	6.7839	6.6141	6.7821	1322832.0
2007-12-20 18:00:00	AAPL	Stock	6.7789	6.79	6.7786	6.79	1049720.0
2007-12-20 18:30:00	AAPL	Stock	6.7911	6.7911	6.7786	6.7786	525588.0
2007-12-20 19:00:00	AAPL	Stock	6.7786	6.7804	6.7643	6.7761	289072.0
2007-12-20 19:30:00	AAPL	Stock	6.7732	6.7857	6.7696	6.7807	332192.0
2007-12-20 08:00:00	MSFT	Stock	34.94	35.2	34.94	35.2	28921.0
2007-12-20 08:30:00	MSFT	Stock	35.13	35.2	35.08	35.15	49642.0
2007-12-20 09:00:00	MSFT	Stock	35.18	35.39	35.1	35.39	193220.0
2007-12-20 09:30:00	MSFT	Stock	35.39	35.39	35.14	35.17	6577250.0
2007-12-20 10:00:00	MSFT	Stock	35.17	35.28	35.08	35.24	3657102.0
2007-12-20 10:30:00	MSFT	Stock	35.24	35.43	35.21	35.31	5176721.0
2007-12-20 11:00:00	MSFT	Stock	35.3	35.34	35.21	35.28	3585137.0
2007-12-20 11:30:00	MSFT	Stock	35.29	35.38	35.23	35.35	2434520.0
2007-12-20 12:00:00	MSFT	Stock	35.34	35.39	35.23	35.35	2637673.0
2007-12-20 12:30:00	MSFT	Stock	35.36	35.37	35.27	35.31	2868219.0
2007-12-20 13:00:00	MSFT	Stock	35.31	35.5	35.28	35.44	3056229.0
2007-12-20 13:30:00	MSFT	Stock	35.44	35.49	35.41	35.47	2933211.0
2007-12-20 14:00:00	MSFT	Stock	35.47	35.66	35.45	35.63	4504025.0
2007-12-20 14:30:00	MSFT	Stock	35.62	35.73	35.52	35.63	4339096.0
2007-12-20 15:00:00	MSFT	Stock	35.62	35.79	35.51	35.59	5793869.0
2007-12-20 15:30:00	MSFT	Stock	35.6	35.63	35.47	35.52	8385458.0
2007-12-20 16:00:00	MSFT	Stock	35.53	35.62	35.35	35.62	3131077.0
2007-12-20 16:30:00	MSFT	Stock	35.6	35.62	35.402	35.62	37536.0
2007-12-20 17:00:00	MSFT	Stock	35.62	35.68	35.52	35.68	14050.0
2007-12-20 17:30:00	MSFT	Stock	35.448	35.68	35.448	35.65	54073.0
2007-12-20 18:00:00	MSFT	Stock	35.69	35.75	35.69	35.7	4490.0
2007-12-20 18:30:00	MSFT	Stock	35.69	35.69	35.69	35.69	900.0
2007-12-20 19:30:00	MSFT	Stock	35.7	35.74	35.7	35.7	2150.0

> showing 50 of 70,600 rows — these rows as CSV

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