PREVIEW / stock_30min / 2007-06-11

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-11.parquet
  size:    1.1 MB
  rows:    63,088
  symbols: 3,019

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-11 09:30:00	AAPL	Stock	4.5	4.5054	4.4554	4.4661	170730756.0
2007-06-11 10:00:00	AAPL	Stock	4.4668	4.4668	4.4196	4.4225	151274312.0
2007-06-11 10:30:00	AAPL	Stock	4.4232	4.4393	4.4204	4.4382	64400700.0
2007-06-11 11:00:00	AAPL	Stock	4.4386	4.4525	4.4361	4.4443	69753460.0
2007-06-11 11:30:00	AAPL	Stock	4.4443	4.4479	4.4361	4.4411	41099044.0
2007-06-11 12:00:00	AAPL	Stock	4.4404	4.4425	4.4286	4.4364	48310052.0
2007-06-11 12:30:00	AAPL	Stock	4.4368	4.4618	4.435	4.4575	51070656.0
2007-06-11 13:00:00	AAPL	Stock	4.4571	4.4939	4.4482	4.4632	135998100.0
2007-06-11 13:30:00	AAPL	Stock	4.4629	4.475	4.4389	4.445	72672964.0
2007-06-11 14:00:00	AAPL	Stock	4.4446	4.4629	4.4086	4.4089	135069144.0
2007-06-11 14:30:00	AAPL	Stock	4.4089	4.4107	4.2929	4.3436	391968220.0
2007-06-11 15:00:00	AAPL	Stock	4.3429	4.3493	4.3036	4.3136	194135088.0
2007-06-11 15:30:00	AAPL	Stock	4.3138	4.3143	4.2693	4.2921	304728928.0
2007-06-11 16:00:00	AAPL	Stock	4.2918	4.2932	4.2918	4.2925	5158832.0
2007-06-11 09:30:00	MSFT	Stock	29.94	30.24	29.93	30.22	3278883.0
2007-06-11 10:00:00	MSFT	Stock	30.222	30.25	30.07	30.1	4177600.0
2007-06-11 10:30:00	MSFT	Stock	30.09	30.12	29.97	30.0	2642854.0
2007-06-11 11:00:00	MSFT	Stock	30.0	30.1	29.98	30.04	1866008.0
2007-06-11 11:30:00	MSFT	Stock	30.05	30.18	30.03	30.17	2028186.0
2007-06-11 12:00:00	MSFT	Stock	30.17	30.19	30.02	30.14	1333139.0
2007-06-11 12:30:00	MSFT	Stock	30.14	30.17	30.11	30.15	1516521.0
2007-06-11 13:00:00	MSFT	Stock	30.15	30.18	30.12	30.12	1931029.0
2007-06-11 13:30:00	MSFT	Stock	30.12	30.14	30.082	30.1	1611656.0
2007-06-11 14:00:00	MSFT	Stock	30.1	30.2	30.09	30.18	2267419.0
2007-06-11 14:30:00	MSFT	Stock	30.18	30.23	30.141	30.16	5449727.0
2007-06-11 15:00:00	MSFT	Stock	30.16	30.18	30.11	30.17	3536483.0
2007-06-11 15:30:00	MSFT	Stock	30.16	30.17	30.0	30.02	9581562.0
2007-06-11 16:00:00	MSFT	Stock	30.02	30.02	30.02	30.02	709969.0
2007-06-11 17:00:00	MSFT	Stock	30.13	30.19	30.02	30.03	17500.0
2007-06-11 08:00:00	NVDA	Stock	0.6092	0.6095	0.6092	0.6095	18000.0
2007-06-11 09:00:00	NVDA	Stock	0.6092	0.6117	0.6092	0.6093	103980.0
2007-06-11 09:30:00	NVDA	Stock	0.6092	0.615	0.6058	0.6133	60039360.0
2007-06-11 10:00:00	NVDA	Stock	0.6136	0.6147	0.6077	0.6108	43168140.0
2007-06-11 10:30:00	NVDA	Stock	0.6108	0.6117	0.6078	0.6107	28630140.0
2007-06-11 11:00:00	NVDA	Stock	0.6107	0.6122	0.6093	0.61	23863080.0
2007-06-11 11:30:00	NVDA	Stock	0.61	0.6123	0.61	0.6123	19302960.0
2007-06-11 12:00:00	NVDA	Stock	0.6123	0.6132	0.6103	0.6113	22303260.0
2007-06-11 12:30:00	NVDA	Stock	0.6113	0.6137	0.6103	0.6127	19102800.0
2007-06-11 13:00:00	NVDA	Stock	0.6127	0.6133	0.6118	0.6125	16176060.0
2007-06-11 13:30:00	NVDA	Stock	0.6123	0.6125	0.611	0.6112	24578340.0
2007-06-11 14:00:00	NVDA	Stock	0.6112	0.6142	0.6103	0.6137	36310860.0
2007-06-11 14:30:00	NVDA	Stock	0.6138	0.6138	0.6112	0.6112	21195780.0
2007-06-11 15:00:00	NVDA	Stock	0.6112	0.613	0.6108	0.6118	27722340.0
2007-06-11 15:30:00	NVDA	Stock	0.6118	0.6133	0.611	0.6113	78304260.0
2007-06-11 16:00:00	NVDA	Stock	0.6113	0.6121	0.6113	0.6115	4871880.0
2007-06-11 16:30:00	NVDA	Stock	0.6113	0.6118	0.6113	0.6113	150000.0
2007-06-11 17:00:00	NVDA	Stock	0.6107	0.6133	0.607	0.6113	954000.0
2007-06-11 17:30:00	NVDA	Stock	0.6125	0.6125	0.6125	0.6125	60000.0
2007-06-11 18:00:00	NVDA	Stock	0.6125	0.6125	0.6125	0.6125	12000.0
2007-06-11 19:30:00	NVDA	Stock	0.6083	0.6083	0.6083	0.6083	6000.0

> showing 50 of 63,088 rows — these rows as CSV

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