PREVIEW / stock_30min / 2007-04-26

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-26.parquet
  size:    1.0 MB
  rows:    56,457
  symbols: 2,614

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-04-26 04:00:00	AAPL	Stock	3.6075	3.6075	3.6075	3.6075	2800.0
2007-04-26 04:30:00	AAPL	Stock	3.6571	3.6571	3.6571	3.6571	61600.0
2007-04-26 05:30:00	AAPL	Stock	3.6361	3.6368	3.6268	3.6268	24220.0
2007-04-26 06:00:00	AAPL	Stock	3.6286	3.65	3.6286	3.6429	341628.0
2007-04-26 06:30:00	AAPL	Stock	3.6371	3.6557	3.6368	3.6475	343868.0
2007-04-26 07:00:00	AAPL	Stock	3.6507	3.7179	3.6507	3.6921	5513088.0
2007-04-26 07:30:00	AAPL	Stock	3.6929	3.7321	3.6579	3.6611	10745224.0
2007-04-26 08:00:00	AAPL	Stock	3.6725	3.6964	3.6268	3.6804	41295744.0
2007-04-26 08:30:00	AAPL	Stock	3.6796	3.6921	3.6571	3.6643	21293972.0
2007-04-26 09:00:00	AAPL	Stock	3.6661	3.6718	3.6257	3.6286	41977572.0
2007-04-26 09:30:00	AAPL	Stock	3.6279	3.6607	3.5489	3.5821	433932716.0
2007-04-26 10:00:00	AAPL	Stock	3.5829	3.63	3.5107	3.5436	235023236.0
2007-04-26 10:30:00	AAPL	Stock	3.5436	3.6286	3.5296	3.5739	141550192.0
2007-04-26 11:00:00	AAPL	Stock	3.5746	3.5821	3.5496	3.5686	102076772.0
2007-04-26 11:30:00	AAPL	Stock	3.5686	3.6121	3.5571	3.5661	63920248.0
2007-04-26 12:00:00	AAPL	Stock	3.5657	3.5832	3.565	3.5679	53423552.0
2007-04-26 12:30:00	AAPL	Stock	3.5682	3.58	3.5621	3.5761	56809732.0
2007-04-26 13:00:00	AAPL	Stock	3.5775	3.6279	3.5757	3.5807	68756296.0
2007-04-26 13:30:00	AAPL	Stock	3.5807	3.6061	3.58	3.605	87576720.0
2007-04-26 14:00:00	AAPL	Stock	3.6046	3.6279	3.5907	3.5954	88471404.0
2007-04-26 14:30:00	AAPL	Stock	3.595	3.6071	3.5268	3.5911	54324956.0
2007-04-26 15:00:00	AAPL	Stock	3.5907	3.6279	3.5654	3.5671	78676136.0
2007-04-26 15:30:00	AAPL	Stock	3.5668	3.5968	3.5286	3.53	132368348.0
2007-04-26 16:00:00	AAPL	Stock	3.53	3.5911	3.4914	3.5011	8904224.0
2007-04-26 16:30:00	AAPL	Stock	3.5036	3.6246	3.5011	3.5054	2887556.0
2007-04-26 17:00:00	AAPL	Stock	3.5054	3.51	3.5036	3.5071	1174908.0
2007-04-26 17:30:00	AAPL	Stock	3.5071	3.51	3.5043	3.5068	1184148.0
2007-04-26 18:00:00	AAPL	Stock	3.5068	3.5104	3.5064	3.5093	781284.0
2007-04-26 18:30:00	AAPL	Stock	3.5089	3.5114	3.5071	3.5089	368844.0
2007-04-26 19:00:00	AAPL	Stock	3.5071	3.5143	3.5071	3.5143	273532.0
2007-04-26 19:30:00	AAPL	Stock	3.5164	3.5175	3.5107	3.5143	187880.0
2007-04-26 09:30:00	MSFT	Stock	29.09	29.35	28.91	29.29	8814232.0
2007-04-26 10:00:00	MSFT	Stock	29.29	29.31	29.11	29.17	4646781.0
2007-04-26 10:30:00	MSFT	Stock	29.171	29.2	29.07	29.11	3516914.0
2007-04-26 11:00:00	MSFT	Stock	29.11	29.15	29.1	29.13	2776687.0
2007-04-26 11:30:00	MSFT	Stock	29.12	29.24	29.1	29.152	2914910.0
2007-04-26 12:00:00	MSFT	Stock	29.15	29.2	29.1	29.15	3193851.0
2007-04-26 12:30:00	MSFT	Stock	29.15	29.18	29.11	29.12	1577378.0
2007-04-26 13:00:00	MSFT	Stock	29.12	29.15	29.05	29.08	1940747.0
2007-04-26 13:30:00	MSFT	Stock	29.07	29.17	29.07	29.13	2399401.0
2007-04-26 14:00:00	MSFT	Stock	29.122	29.17	29.07	29.15	3370041.0
2007-04-26 14:30:00	MSFT	Stock	29.15	29.22	29.14	29.22	3218627.0
2007-04-26 15:00:00	MSFT	Stock	29.22	29.35	29.17	29.26	5642388.0
2007-04-26 15:30:00	MSFT	Stock	29.25	29.25	28.17	29.11	9697999.0
2007-04-26 16:00:00	MSFT	Stock	29.1	29.11	29.1	29.1	1084750.0
2007-04-26 08:00:00	NVDA	Stock	0.5555	0.5555	0.5555	0.5555	6000.0
2007-04-26 08:30:00	NVDA	Stock	0.5573	0.5583	0.5558	0.5567	339000.0
2007-04-26 09:00:00	NVDA	Stock	0.5568	0.5568	0.5517	0.552	669480.0
2007-04-26 09:30:00	NVDA	Stock	0.5518	0.5568	0.5477	0.549	45833520.0
2007-04-26 10:00:00	NVDA	Stock	0.549	0.5567	0.5468	0.5558	65689620.0

> showing 50 of 56,457 rows — these rows as CSV

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