PREVIEW / stock_30min / 2005-07-20

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-07-20.parquet
  size:    839 KB
  rows:    45,009
  symbols: 2,035

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-07-20 08:00:00	AAPL	Stock	1.5321	1.5332	1.5214	1.5232	1008112.0
2005-07-20 08:30:00	AAPL	Stock	1.5232	1.5282	1.5182	1.5214	912240.0
2005-07-20 09:00:00	AAPL	Stock	1.5214	1.5321	1.5207	1.5311	1399636.0
2005-07-20 09:30:00	AAPL	Stock	1.5307	1.5393	1.5232	1.53	97358940.0
2005-07-20 10:00:00	AAPL	Stock	1.5293	1.5357	1.5246	1.525	49512512.0
2005-07-20 10:30:00	AAPL	Stock	1.5254	1.5325	1.525	1.5271	30608004.0
2005-07-20 11:00:00	AAPL	Stock	1.5271	1.5346	1.5268	1.5325	23073008.0
2005-07-20 11:30:00	AAPL	Stock	1.5325	1.5364	1.5275	1.5314	15478512.0
2005-07-20 12:00:00	AAPL	Stock	1.5311	1.5321	1.5282	1.5293	11968824.0
2005-07-20 12:30:00	AAPL	Stock	1.5289	1.5346	1.5279	1.5321	8376284.0
2005-07-20 13:00:00	AAPL	Stock	1.5321	1.5425	1.5307	1.5414	34693176.0
2005-07-20 13:30:00	AAPL	Stock	1.5414	1.55	1.5411	1.5471	34896652.0
2005-07-20 14:00:00	AAPL	Stock	1.5468	1.5546	1.5454	1.554	31275664.0
2005-07-20 14:30:00	AAPL	Stock	1.5539	1.5589	1.5518	1.5521	31393796.0
2005-07-20 15:00:00	AAPL	Stock	1.5529	1.5561	1.5511	1.5539	22428924.0
2005-07-20 15:30:00	AAPL	Stock	1.5541	1.5643	1.5539	1.5586	52297168.0
2005-07-20 16:00:00	AAPL	Stock	1.5582	1.5664	1.5561	1.5636	2747556.0
2005-07-20 16:30:00	AAPL	Stock	1.5607	1.5632	1.5568	1.5632	759500.0
2005-07-20 17:00:00	AAPL	Stock	1.5629	1.5632	1.5607	1.5632	222600.0
2005-07-20 17:30:00	AAPL	Stock	1.5636	1.5643	1.5632	1.5632	147644.0
2005-07-20 18:00:00	AAPL	Stock	1.5632	1.5675	1.5632	1.5675	327600.0
2005-07-20 18:30:00	AAPL	Stock	1.5675	1.5675	1.5675	1.5675	8400.0
2005-07-20 08:00:00	MSFT	Stock	25.88	25.93	25.88	25.91	127980.0
2005-07-20 08:30:00	MSFT	Stock	25.91	25.97	25.9	25.95	979510.0
2005-07-20 09:00:00	MSFT	Stock	25.93	26.03	25.93	25.98	459350.0
2005-07-20 09:30:00	MSFT	Stock	26.0	26.08	25.94	26.04	9705856.0
2005-07-20 10:00:00	MSFT	Stock	26.03	26.13	25.93	25.99	8251358.0
2005-07-20 10:30:00	MSFT	Stock	25.99	26.05	25.92	25.93	5858906.0
2005-07-20 11:00:00	MSFT	Stock	25.93	26.0	25.88	25.97	5421286.0
2005-07-20 11:30:00	MSFT	Stock	25.97	26.02	25.96	25.98	2902110.0
2005-07-20 12:00:00	MSFT	Stock	25.99	26.0	25.96	25.96	2963750.0
2005-07-20 12:30:00	MSFT	Stock	26.0	26.0	25.94	25.99	2456430.0
2005-07-20 13:00:00	MSFT	Stock	25.99	26.07	25.95	26.06	4499388.0
2005-07-20 13:30:00	MSFT	Stock	26.05	26.15	26.04	26.12	6261058.0
2005-07-20 14:00:00	MSFT	Stock	26.12	26.16	26.06	26.14	4159816.0
2005-07-20 14:30:00	MSFT	Stock	26.14	26.18	26.04	26.06	4056286.0
2005-07-20 15:00:00	MSFT	Stock	26.06	26.09	25.999	26.06	3489455.0
2005-07-20 15:30:00	MSFT	Stock	26.07	26.23	26.06	26.18	8701360.0
2005-07-20 16:00:00	MSFT	Stock	26.18	26.28	26.03	26.27	433716.0
2005-07-20 16:30:00	MSFT	Stock	26.25	26.34	26.19	26.3	84945.0
2005-07-20 17:00:00	MSFT	Stock	26.3	26.3	26.19	26.3	280166.0
2005-07-20 17:30:00	MSFT	Stock	26.32	26.34	26.22	26.23	40516.0
2005-07-20 18:00:00	MSFT	Stock	26.23	26.27	26.21	26.23	94526.0
2005-07-20 08:00:00	NVDA	Stock	0.2167	0.2167	0.2167	0.2167	146400.0
2005-07-20 08:30:00	NVDA	Stock	0.2175	0.2175	0.2175	0.2175	12000.0
2005-07-20 09:00:00	NVDA	Stock	0.219	0.2204	0.218	0.2203	1570560.0
2005-07-20 09:30:00	NVDA	Stock	0.2189	0.2195	0.2159	0.2177	83703600.0
2005-07-20 10:00:00	NVDA	Stock	0.2177	0.2186	0.217	0.2178	37752240.0
2005-07-20 10:30:00	NVDA	Stock	0.2177	0.2207	0.2177	0.2192	36861120.0
2005-07-20 11:00:00	NVDA	Stock	0.2192	0.2203	0.219	0.2203	28119120.0

> showing 50 of 45,009 rows — these rows as CSV

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