PREVIEW / stock_30min / 2005-04-07

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-04-07.parquet
  size:    819 KB
  rows:    44,284
  symbols: 1,948

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
2005-04-07 08:00:00	AAPL	Stock	1.5179	1.5179	1.5139	1.5161	612500.0
2005-04-07 08:30:00	AAPL	Stock	1.5157	1.5157	1.5107	1.5107	238980.0
2005-04-07 09:00:00	AAPL	Stock	1.5118	1.5175	1.505	1.5125	1555932.0
2005-04-07 09:30:00	AAPL	Stock	1.5118	1.5264	1.5089	1.5236	61985140.0
2005-04-07 10:00:00	AAPL	Stock	1.5239	1.5268	1.5211	1.5221	36384488.0
2005-04-07 10:30:00	AAPL	Stock	1.5221	1.5282	1.5218	1.5253	35303212.0
2005-04-07 11:00:00	AAPL	Stock	1.5254	1.5339	1.5246	1.5275	35586600.0
2005-04-07 11:30:00	AAPL	Stock	1.5275	1.5286	1.525	1.5271	20989808.0
2005-04-07 12:00:00	AAPL	Stock	1.5271	1.53	1.5246	1.5257	22138872.0
2005-04-07 12:30:00	AAPL	Stock	1.5261	1.5304	1.5246	1.5264	25372592.0
2005-04-07 13:00:00	AAPL	Stock	1.5264	1.5268	1.5218	1.5264	28334740.0
2005-04-07 13:30:00	AAPL	Stock	1.5268	1.5275	1.52	1.5203	20482224.0
2005-04-07 14:00:00	AAPL	Stock	1.5204	1.5304	1.5179	1.5279	29442392.0
2005-04-07 14:30:00	AAPL	Stock	1.5282	1.5318	1.5279	1.5304	24797360.0
2005-04-07 15:00:00	AAPL	Stock	1.5304	1.5432	1.5268	1.5418	45191384.0
2005-04-07 15:30:00	AAPL	Stock	1.5418	1.5625	1.5386	1.5554	91079436.0
2005-04-07 16:00:00	AAPL	Stock	1.5546	1.5596	1.545	1.5596	5142984.0
2005-04-07 16:30:00	AAPL	Stock	1.5604	1.5632	1.5557	1.5575	1831816.0
2005-04-07 17:00:00	AAPL	Stock	1.5539	1.5589	1.5539	1.5557	281036.0
2005-04-07 17:30:00	AAPL	Stock	1.5289	1.5621	1.5289	1.5571	182000.0
2005-04-07 18:00:00	AAPL	Stock	1.5589	1.5625	1.5589	1.5625	151648.0
2005-04-07 08:00:00	MSFT	Stock	24.65	24.67	24.65	24.65	3000.0
2005-04-07 08:30:00	MSFT	Stock	24.67	24.68	24.67	24.68	2160.0
2005-04-07 09:00:00	MSFT	Stock	24.68	24.68	24.62	24.66	85041.0
2005-04-07 09:30:00	MSFT	Stock	24.66	25.0	24.63	24.85	6549108.0
2005-04-07 10:00:00	MSFT	Stock	24.85	24.93	24.83	24.861	5312421.0
2005-04-07 10:30:00	MSFT	Stock	24.87	25.0	24.861	24.95	6547387.0
2005-04-07 11:00:00	MSFT	Stock	24.95	25.01	24.89	24.89	6299401.0
2005-04-07 11:30:00	MSFT	Stock	24.89	25.03	24.88	24.94	4193544.0
2005-04-07 12:00:00	MSFT	Stock	24.94	24.98	24.92	24.94	4976193.0
2005-04-07 12:30:00	MSFT	Stock	24.95	25.05	24.93	25.02	6284894.0
2005-04-07 13:00:00	MSFT	Stock	25.02	25.07	24.97	25.0	5720751.0
2005-04-07 13:30:00	MSFT	Stock	25.0	25.02	24.96	24.97	4705421.0
2005-04-07 14:00:00	MSFT	Stock	24.97	25.04	24.97	25.01	2441397.0
2005-04-07 14:30:00	MSFT	Stock	25.01	25.06	24.99	25.051	5882035.0
2005-04-07 15:00:00	MSFT	Stock	25.058	25.07	24.99	25.02	5153549.0
2005-04-07 15:30:00	MSFT	Stock	25.03	25.13	25.02	25.1	9765454.0
2005-04-07 16:00:00	MSFT	Stock	25.1	25.11	24.67	25.09	668165.0
2005-04-07 16:30:00	MSFT	Stock	25.09	25.11	25.08	25.09	586429.0
2005-04-07 17:00:00	MSFT	Stock	25.11	25.11	25.07	25.1	48680.0
2005-04-07 17:30:00	MSFT	Stock	24.97	25.18	24.97	25.18	44385.0
2005-04-07 18:00:00	MSFT	Stock	25.09	25.09	25.04	25.06	6831.0
2005-04-07 08:30:00	NVDA	Stock	0.195	0.195	0.195	0.195	132000.0
2005-04-07 09:00:00	NVDA	Stock	0.1949	0.1949	0.1946	0.1949	296520.0
2005-04-07 09:30:00	NVDA	Stock	0.1954	0.1961	0.1921	0.1929	56272320.0
2005-04-07 10:00:00	NVDA	Stock	0.193	0.195	0.1929	0.1942	19279920.0
2005-04-07 10:30:00	NVDA	Stock	0.1942	0.1952	0.194	0.195	27941880.0
2005-04-07 11:00:00	NVDA	Stock	0.195	0.1964	0.1949	0.1957	23016000.0
2005-04-07 11:30:00	NVDA	Stock	0.1957	0.1971	0.1956	0.1966	36956520.0
2005-04-07 12:00:00	NVDA	Stock	0.1967	0.1969	0.1964	0.1968	10389840.0

> showing 50 of 44,284 rows — these rows as CSV

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