PREVIEW / stock_30min / 2007-06-15

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-15.parquet
  size:    1.2 MB
  rows:    64,886
  symbols: 3,022

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-06-15 09:30:00	AAPL	Stock	4.3079	4.3096	4.2807	4.2921	133684936.0
2007-06-15 10:00:00	AAPL	Stock	4.2921	4.3011	4.285	4.295	70422072.0
2007-06-15 10:30:00	AAPL	Stock	4.2954	4.3014	4.2882	4.2897	48642188.0
2007-06-15 11:00:00	AAPL	Stock	4.29	4.2964	4.2879	4.2904	27958728.0
2007-06-15 11:30:00	AAPL	Stock	4.2904	4.3011	4.29	4.2971	36437100.0
2007-06-15 12:00:00	AAPL	Stock	4.2975	4.3	4.2929	4.2957	27859048.0
2007-06-15 12:30:00	AAPL	Stock	4.296	4.3011	4.2907	4.2968	35039144.0
2007-06-15 13:00:00	AAPL	Stock	4.2971	4.2975	4.29	4.2929	27342868.0
2007-06-15 13:30:00	AAPL	Stock	4.2925	4.2975	4.2911	4.2971	21613228.0
2007-06-15 14:00:00	AAPL	Stock	4.2971	4.2979	4.2879	4.2904	26014548.0
2007-06-15 14:30:00	AAPL	Stock	4.29	4.2929	4.035	4.2896	42408464.0
2007-06-15 15:00:00	AAPL	Stock	4.29	4.2939	4.2868	4.2904	33977748.0
2007-06-15 15:30:00	AAPL	Stock	4.2904	4.3032	4.2889	4.3032	66120404.0
2007-06-15 16:00:00	AAPL	Stock	4.3036	4.3036	4.3014	4.3036	19537756.0
2007-06-15 09:30:00	MSFT	Stock	30.86	30.88	30.58	30.695	26393003.0
2007-06-15 10:00:00	MSFT	Stock	30.7	30.75	30.64	30.64	3006071.0
2007-06-15 10:30:00	MSFT	Stock	30.65	30.679	30.56	30.63	3904837.0
2007-06-15 11:00:00	MSFT	Stock	30.63	30.65	30.58	30.59	1855928.0
2007-06-15 11:30:00	MSFT	Stock	30.58	30.59	30.51	30.54	2698695.0
2007-06-15 12:00:00	MSFT	Stock	30.542	30.59	30.45	30.45	2291703.0
2007-06-15 12:30:00	MSFT	Stock	30.45	30.6	30.43	30.59	2919090.0
2007-06-15 13:00:00	MSFT	Stock	30.59	30.64	30.58	30.64	2997607.0
2007-06-15 13:30:00	MSFT	Stock	30.638	30.69	30.6	30.68	2410299.0
2007-06-15 14:00:00	MSFT	Stock	30.69	30.7	30.57	30.59	2875899.0
2007-06-15 14:30:00	MSFT	Stock	30.59	30.62	30.55	30.6	3668063.0
2007-06-15 15:00:00	MSFT	Stock	30.6	30.68	30.6	30.61	3341460.0
2007-06-15 15:30:00	MSFT	Stock	30.6	30.63	30.45	30.49	12693211.0
2007-06-15 16:00:00	MSFT	Stock	30.49	30.49	30.49	30.49	10574624.0
2007-06-15 08:00:00	NVDA	Stock	0.6333	0.6362	0.6333	0.6362	248820.0
2007-06-15 08:30:00	NVDA	Stock	0.6378	0.6398	0.6378	0.6382	140760.0
2007-06-15 09:00:00	NVDA	Stock	0.6365	0.6395	0.6363	0.6392	491520.0
2007-06-15 09:30:00	NVDA	Stock	0.6377	0.6502	0.6375	0.647	229381320.0
2007-06-15 10:00:00	NVDA	Stock	0.6472	0.6535	0.6463	0.6522	118315200.0
2007-06-15 10:30:00	NVDA	Stock	0.6522	0.6642	0.6522	0.6618	124174260.0
2007-06-15 11:00:00	NVDA	Stock	0.6619	0.6635	0.6548	0.6555	77518020.0
2007-06-15 11:30:00	NVDA	Stock	0.6556	0.6587	0.6548	0.6585	49414920.0
2007-06-15 12:00:00	NVDA	Stock	0.6585	0.6593	0.6562	0.6565	36563760.0
2007-06-15 12:30:00	NVDA	Stock	0.6563	0.6578	0.6538	0.6538	30384540.0
2007-06-15 13:00:00	NVDA	Stock	0.6538	0.6543	0.6527	0.6527	32302260.0
2007-06-15 13:30:00	NVDA	Stock	0.6527	0.6583	0.6525	0.6582	44423520.0
2007-06-15 14:00:00	NVDA	Stock	0.6582	0.6592	0.657	0.6588	41877660.0
2007-06-15 14:30:00	NVDA	Stock	0.6587	0.6623	0.6585	0.6623	47347140.0
2007-06-15 15:00:00	NVDA	Stock	0.6623	0.6623	0.6568	0.6592	68688060.0
2007-06-15 15:30:00	NVDA	Stock	0.659	0.6597	0.656	0.6592	76972260.0
2007-06-15 16:00:00	NVDA	Stock	0.6585	0.6597	0.6533	0.6592	16065360.0
2007-06-15 16:30:00	NVDA	Stock	0.6593	0.6593	0.6565	0.6593	2980080.0
2007-06-15 18:00:00	NVDA	Stock	0.6593	0.6682	0.6593	0.6655	3352500.0
2007-06-15 18:30:00	NVDA	Stock	0.6647	0.6652	0.6535	0.6633	1126140.0
2007-06-15 19:00:00	NVDA	Stock	0.6633	0.6667	0.6633	0.6633	292800.0
2007-06-15 19:30:00	NVDA	Stock	0.6637	0.6637	0.6633	0.6637	285000.0

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

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