PREVIEW / stock_30min / 2007-04-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-27.parquet
  size:    1.0 MB
  rows:    55,485
  symbols: 2,617

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-27 05:00:00	AAPL	Stock	3.5221	3.5221	3.5221	3.5221	8400.0
2007-04-27 05:30:00	AAPL	Stock	3.5225	3.5225	3.5225	3.5225	2800.0
2007-04-27 06:30:00	AAPL	Stock	3.53	3.53	3.53	3.53	11200.0
2007-04-27 07:00:00	AAPL	Stock	3.5304	3.5304	3.5204	3.5286	50400.0
2007-04-27 07:30:00	AAPL	Stock	3.5321	3.5321	3.5161	3.5164	153412.0
2007-04-27 08:00:00	AAPL	Stock	3.5214	3.5214	3.5	3.5071	1516396.0
2007-04-27 08:30:00	AAPL	Stock	3.5071	3.5086	3.4911	3.4964	5052656.0
2007-04-27 09:00:00	AAPL	Stock	3.4957	3.5214	3.4957	3.5054	2654288.0
2007-04-27 09:30:00	AAPL	Stock	3.5064	3.5339	3.4889	3.5129	101140172.0
2007-04-27 10:00:00	AAPL	Stock	3.5129	3.5489	3.5096	3.5361	89082280.0
2007-04-27 10:30:00	AAPL	Stock	3.5357	3.5379	3.5057	3.5243	55577900.0
2007-04-27 11:00:00	AAPL	Stock	3.5239	3.5314	3.5179	3.5272	35414540.0
2007-04-27 11:30:00	AAPL	Stock	3.5275	3.5364	3.5225	3.5361	28511364.0
2007-04-27 12:00:00	AAPL	Stock	3.5361	3.5386	3.5279	3.5329	20979140.0
2007-04-27 12:30:00	AAPL	Stock	3.5325	3.5386	3.5304	3.5321	19276292.0
2007-04-27 13:00:00	AAPL	Stock	3.5321	3.5339	3.5293	3.5321	18285344.0
2007-04-27 13:30:00	AAPL	Stock	3.5321	3.5368	3.5286	3.5339	24264072.0
2007-04-27 14:00:00	AAPL	Stock	3.5343	3.5536	3.5329	3.55	38553228.0
2007-04-27 14:30:00	AAPL	Stock	3.5487	3.5614	3.5468	3.5529	51936500.0
2007-04-27 15:00:00	AAPL	Stock	3.5529	3.5696	3.5514	3.5607	57025388.0
2007-04-27 15:30:00	AAPL	Stock	3.5607	3.5682	3.5507	3.5682	80554180.0
2007-04-27 16:00:00	AAPL	Stock	3.5682	3.5686	3.5675	3.5686	3132192.0
2007-04-27 09:30:00	MSFT	Stock	30.17	30.6	30.0	30.527	32039342.0
2007-04-27 10:00:00	MSFT	Stock	30.53	30.74	30.4	30.44	17054261.0
2007-04-27 10:30:00	MSFT	Stock	30.44	30.5	30.32	30.46	9560241.0
2007-04-27 11:00:00	MSFT	Stock	30.46	30.47	30.27	30.31	9059671.0
2007-04-27 11:30:00	MSFT	Stock	30.31	30.44	30.27	30.43	6240768.0
2007-04-27 12:00:00	MSFT	Stock	30.44	30.45	30.26	30.26	4340007.0
2007-04-27 12:30:00	MSFT	Stock	30.26	30.31	30.18	30.18	3607107.0
2007-04-27 13:00:00	MSFT	Stock	30.19	30.29	30.15	30.25	3906934.0
2007-04-27 13:30:00	MSFT	Stock	30.252	30.29	30.17	30.23	2649813.0
2007-04-27 14:00:00	MSFT	Stock	30.23	30.29	30.19	30.26	3413076.0
2007-04-27 14:30:00	MSFT	Stock	30.27	30.33	30.24	30.323	6432944.0
2007-04-27 15:00:00	MSFT	Stock	30.33	30.36	30.26	30.31	5650008.0
2007-04-27 15:30:00	MSFT	Stock	30.31	30.34	30.07	30.13	11168777.0
2007-04-27 16:00:00	MSFT	Stock	30.15	30.15	30.12	30.12	1111878.0
2007-04-27 08:00:00	NVDA	Stock	0.5583	0.5583	0.5583	0.5583	6000.0
2007-04-27 09:00:00	NVDA	Stock	0.5552	0.5563	0.5545	0.5563	114000.0
2007-04-27 09:30:00	NVDA	Stock	0.5568	0.563	0.5543	0.5617	50617380.0
2007-04-27 10:00:00	NVDA	Stock	0.5617	0.5617	0.5525	0.5528	53268660.0
2007-04-27 10:30:00	NVDA	Stock	0.553	0.5542	0.544	0.5458	83972940.0
2007-04-27 11:00:00	NVDA	Stock	0.546	0.546	0.5423	0.5445	51447720.0
2007-04-27 11:30:00	NVDA	Stock	0.5445	0.5453	0.5423	0.5437	30188220.0
2007-04-27 12:00:00	NVDA	Stock	0.5438	0.547	0.5435	0.5468	31154640.0
2007-04-27 12:30:00	NVDA	Stock	0.547	0.5488	0.5468	0.5472	29908380.0
2007-04-27 13:00:00	NVDA	Stock	0.5472	0.5472	0.5462	0.5467	22792800.0
2007-04-27 13:30:00	NVDA	Stock	0.5467	0.5473	0.5445	0.5446	35424960.0
2007-04-27 14:00:00	NVDA	Stock	0.5447	0.5478	0.5447	0.5472	38012640.0
2007-04-27 14:30:00	NVDA	Stock	0.5472	0.5483	0.5462	0.5478	18156540.0
2007-04-27 15:00:00	NVDA	Stock	0.5478	0.5512	0.5473	0.55	36402840.0

> showing 50 of 55,485 rows — these rows as CSV

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