PREVIEW / stock_30min / 2007-08-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-23.parquet
  size:    1.1 MB
  rows:    64,060
  symbols: 3,108

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-08-23 09:30:00	AAPL	Stock	4.7532	4.7621	4.6921	4.7214	141933904.0
2007-08-23 10:00:00	AAPL	Stock	4.7207	4.7454	4.6754	4.6868	94433612.0
2007-08-23 10:30:00	AAPL	Stock	4.6868	4.7054	4.6732	4.6896	50098356.0
2007-08-23 11:00:00	AAPL	Stock	4.69	4.6954	4.6607	4.6711	58654792.0
2007-08-23 11:30:00	AAPL	Stock	4.6711	4.685	4.6482	4.6486	47147100.0
2007-08-23 12:00:00	AAPL	Stock	4.6482	4.69	4.6482	4.6846	51059680.0
2007-08-23 12:30:00	AAPL	Stock	4.685	4.6929	4.6518	4.6554	46584636.0
2007-08-23 13:00:00	AAPL	Stock	4.6554	4.6689	4.6343	4.6511	60513348.0
2007-08-23 13:30:00	AAPL	Stock	4.6514	4.6711	4.645	4.665	41297396.0
2007-08-23 14:00:00	AAPL	Stock	4.6646	4.6804	4.6561	4.6693	39889444.0
2007-08-23 14:30:00	AAPL	Stock	4.6693	4.6768	4.6546	4.6761	33553184.0
2007-08-23 15:00:00	AAPL	Stock	4.6761	4.7011	4.6704	4.6793	61284524.0
2007-08-23 15:30:00	AAPL	Stock	4.6793	4.6821	4.6486	4.6811	75252128.0
2007-08-23 16:00:00	AAPL	Stock	4.6793	4.6811	4.6789	4.6811	9391368.0
2007-08-23 09:30:00	MSFT	Stock	28.28	28.33	28.2	28.23	2710885.0
2007-08-23 10:00:00	MSFT	Stock	28.23	28.29	28.21	28.231	2441987.0
2007-08-23 10:30:00	MSFT	Stock	28.23	28.26	28.16	28.19	1710300.0
2007-08-23 11:00:00	MSFT	Stock	28.19	28.25	28.14	28.19	1979584.0
2007-08-23 11:30:00	MSFT	Stock	28.198	28.21	28.1	28.1	2452034.0
2007-08-23 12:00:00	MSFT	Stock	28.11	28.18	28.11	28.16	1446077.0
2007-08-23 12:30:00	MSFT	Stock	28.16	28.24	28.13	28.16	2208036.0
2007-08-23 13:00:00	MSFT	Stock	28.16	28.2	28.13	28.15	1207284.0
2007-08-23 13:30:00	MSFT	Stock	28.147	28.26	28.14	28.24	3004661.0
2007-08-23 14:00:00	MSFT	Stock	28.24	28.29	28.19	28.2	1974527.0
2007-08-23 14:30:00	MSFT	Stock	28.2	28.22	28.11	28.18	2372259.0
2007-08-23 15:00:00	MSFT	Stock	28.18	28.27	28.12	28.26	3503779.0
2007-08-23 15:30:00	MSFT	Stock	28.263	28.29	28.2	28.29	3671307.0
2007-08-23 16:00:00	MSFT	Stock	28.29	28.3	28.28	28.3	1129607.0
2007-08-23 08:00:00	NVDA	Stock	0.8217	0.8217	0.8147	0.8183	553980.0
2007-08-23 08:30:00	NVDA	Stock	0.8142	0.8165	0.8133	0.8165	156000.0
2007-08-23 09:00:00	NVDA	Stock	0.812	0.814	0.808	0.8083	564540.0
2007-08-23 09:30:00	NVDA	Stock	0.8107	0.8187	0.805	0.8098	82680900.0
2007-08-23 10:00:00	NVDA	Stock	0.81	0.8158	0.8087	0.8112	61685880.0
2007-08-23 10:30:00	NVDA	Stock	0.8112	0.8202	0.8112	0.8158	51955260.0
2007-08-23 11:00:00	NVDA	Stock	0.8158	0.8167	0.8033	0.8097	51734460.0
2007-08-23 11:30:00	NVDA	Stock	0.8098	0.8125	0.808	0.8083	40504800.0
2007-08-23 12:00:00	NVDA	Stock	0.8088	0.8128	0.8088	0.8123	22302480.0
2007-08-23 12:30:00	NVDA	Stock	0.8123	0.8153	0.8083	0.8103	29071440.0
2007-08-23 13:00:00	NVDA	Stock	0.8105	0.8138	0.8103	0.812	24838200.0
2007-08-23 13:30:00	NVDA	Stock	0.8121	0.8142	0.8103	0.8123	22029060.0
2007-08-23 14:00:00	NVDA	Stock	0.8124	0.813	0.8075	0.8077	34222440.0
2007-08-23 14:30:00	NVDA	Stock	0.808	0.8085	0.8013	0.803	43747620.0
2007-08-23 15:00:00	NVDA	Stock	0.803	0.805	0.7977	0.8002	45808200.0
2007-08-23 15:30:00	NVDA	Stock	0.8002	0.8027	0.7965	0.8	49532640.0
2007-08-23 16:00:00	NVDA	Stock	0.7995	0.8	0.7963	0.7963	487860.0
2007-08-23 16:30:00	NVDA	Stock	0.7963	0.7963	0.7963	0.7963	60000.0
2007-08-23 17:00:00	NVDA	Stock	0.8	0.8	0.7992	0.8	36234060.0
2007-08-23 17:30:00	NVDA	Stock	0.7975	0.7975	0.7962	0.7962	108000.0
2007-08-23 18:00:00	NVDA	Stock	0.7952	0.7975	0.7952	0.7975	30000.0
2007-08-23 19:00:00	NVDA	Stock	0.7973	0.7973	0.7973	0.7973	6000.0

> showing 50 of 64,060 rows — these rows as CSV

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