PREVIEW / stock_30min / 2004-07-07

all stock 30-min files

  file:    by_date/stock_30min/2004/2004-07-07.parquet
  size:    743 KB
  rows:    40,607
  symbols: 1,796

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
2004-07-07 08:30:00	AAPL	Stock	0.5529	0.5529	0.5529	0.5529	476000.0
2004-07-07 09:00:00	AAPL	Stock	0.5534	0.5534	0.5498	0.5532	5223232.0
2004-07-07 09:30:00	AAPL	Stock	0.5502	0.56	0.5496	0.5563	39222288.0
2004-07-07 10:00:00	AAPL	Stock	0.5563	0.5586	0.5552	0.5554	21600040.0
2004-07-07 10:30:00	AAPL	Stock	0.555	0.5552	0.5482	0.5493	25820760.0
2004-07-07 11:00:00	AAPL	Stock	0.5493	0.5495	0.5429	0.5436	29979656.0
2004-07-07 11:30:00	AAPL	Stock	0.5438	0.5441	0.5396	0.5414	58518936.0
2004-07-07 12:00:00	AAPL	Stock	0.5416	0.542	0.538	0.5386	26635784.0
2004-07-07 12:30:00	AAPL	Stock	0.5382	0.5418	0.538	0.5413	21609056.0
2004-07-07 13:00:00	AAPL	Stock	0.5413	0.5438	0.5405	0.5432	13772640.0
2004-07-07 13:30:00	AAPL	Stock	0.5432	0.5438	0.5421	0.5423	11254320.0
2004-07-07 14:00:00	AAPL	Stock	0.5425	0.5427	0.5389	0.5413	28137536.0
2004-07-07 14:30:00	AAPL	Stock	0.5409	0.5421	0.54	0.5404	16238992.0
2004-07-07 15:00:00	AAPL	Stock	0.5404	0.5407	0.5388	0.5396	40176528.0
2004-07-07 15:30:00	AAPL	Stock	0.5396	0.5427	0.5395	0.5423	38819760.0
2004-07-07 16:00:00	AAPL	Stock	0.5404	0.5443	0.5402	0.5427	3749368.0
2004-07-07 16:30:00	AAPL	Stock	0.5414	0.545	0.5375	0.5375	1186640.0
2004-07-07 17:00:00	AAPL	Stock	0.5368	0.5427	0.5357	0.5357	1024800.0
2004-07-07 17:30:00	AAPL	Stock	0.5357	0.5357	0.5357	0.5357	33600.0
2004-07-07 08:00:00	MSFT	Stock	28.0	28.1	27.83	27.85	65826.0
2004-07-07 08:30:00	MSFT	Stock	27.84	28.03	27.7	27.79	80252.0
2004-07-07 09:00:00	MSFT	Stock	27.79	28.01	27.68	27.69	215510.0
2004-07-07 09:30:00	MSFT	Stock	27.701	28.06	27.55	28.01	14838340.0
2004-07-07 10:00:00	MSFT	Stock	28.01	28.1	28.0	28.02	4656315.0
2004-07-07 10:30:00	MSFT	Stock	28.01	28.02	27.9	27.95	4173794.0
2004-07-07 11:00:00	MSFT	Stock	27.94	28.0	27.85	27.87	5683488.0
2004-07-07 11:30:00	MSFT	Stock	27.87	27.98	27.82	27.96	2895338.0
2004-07-07 12:00:00	MSFT	Stock	27.96	28.03	27.96	27.98	2585090.0
2004-07-07 12:30:00	MSFT	Stock	27.97	28.03	27.92	27.96	2599812.0
2004-07-07 13:00:00	MSFT	Stock	27.97	28.24	27.96	28.21	3984329.0
2004-07-07 13:30:00	MSFT	Stock	28.21	28.28	28.18	28.24	3357409.0
2004-07-07 14:00:00	MSFT	Stock	28.24	28.32	28.19	28.3	3427430.0
2004-07-07 14:30:00	MSFT	Stock	28.29	28.32	28.21	28.26	4219210.0
2004-07-07 15:00:00	MSFT	Stock	28.26	28.31	28.16	28.16	4290744.0
2004-07-07 15:30:00	MSFT	Stock	28.16	28.17	28.08	28.1	6428312.0
2004-07-07 16:00:00	MSFT	Stock	28.1	28.16	28.06	28.1	635942.0
2004-07-07 16:30:00	MSFT	Stock	28.1	28.1	27.33	27.36	186858.0
2004-07-07 17:00:00	MSFT	Stock	27.42	28.12	27.42	27.64	104855.0
2004-07-07 17:30:00	MSFT	Stock	27.64	27.7	27.64	27.68	40046.0
2004-07-07 18:00:00	MSFT	Stock	27.68	27.74	27.64	27.73	21080.0
2004-07-07 08:30:00	NVDA	Stock	0.152	0.1521	0.152	0.1521	600000.0
2004-07-07 09:00:00	NVDA	Stock	0.151	0.1529	0.151	0.1528	540000.0
2004-07-07 09:30:00	NVDA	Stock	0.1532	0.155	0.1527	0.1547	73561560.0
2004-07-07 10:00:00	NVDA	Stock	0.1547	0.1562	0.1537	0.154	39967920.0
2004-07-07 10:30:00	NVDA	Stock	0.154	0.1542	0.1518	0.1518	27024840.0
2004-07-07 11:00:00	NVDA	Stock	0.152	0.1532	0.1514	0.1515	19050000.0
2004-07-07 11:30:00	NVDA	Stock	0.1514	0.1534	0.1513	0.1533	11559120.0
2004-07-07 12:00:00	NVDA	Stock	0.1533	0.1541	0.1531	0.1531	15114120.0
2004-07-07 12:30:00	NVDA	Stock	0.1531	0.1534	0.1526	0.1527	9016320.0
2004-07-07 13:00:00	NVDA	Stock	0.1528	0.1532	0.1514	0.1531	39084960.0

> showing 50 of 40,607 rows — these rows as CSV

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