PREVIEW / stock_30min / 2007-07-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-27.parquet
  size:    1.2 MB
  rows:    67,258
  symbols: 3,081

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-07-27 09:30:00	AAPL	Stock	5.2211	5.2857	5.2096	5.2793	189465584.0
2007-07-27 10:00:00	AAPL	Stock	5.279	5.3186	5.2629	5.2714	151267088.0
2007-07-27 10:30:00	AAPL	Stock	5.2714	5.2857	5.2389	5.2632	98787808.0
2007-07-27 11:00:00	AAPL	Stock	5.2625	5.2875	5.2479	5.2536	62372996.0
2007-07-27 11:30:00	AAPL	Stock	5.2536	5.2568	5.2143	5.2364	70240072.0
2007-07-27 12:00:00	AAPL	Stock	5.2336	5.2461	5.195	5.1961	68543720.0
2007-07-27 12:30:00	AAPL	Stock	5.1954	5.1993	5.1371	5.1825	105140364.0
2007-07-27 13:00:00	AAPL	Stock	5.1822	5.2093	5.1732	5.1886	42913500.0
2007-07-27 13:30:00	AAPL	Stock	5.1882	5.2089	5.1714	5.1921	44122316.0
2007-07-27 14:00:00	AAPL	Stock	5.1925	5.2118	5.18	5.1864	42844480.0
2007-07-27 14:30:00	AAPL	Stock	5.1861	5.2254	5.1757	5.2221	62574568.0
2007-07-27 15:00:00	AAPL	Stock	5.2225	5.2314	5.1929	5.2218	76349952.0
2007-07-27 15:30:00	AAPL	Stock	5.2214	5.2271	5.135	5.1361	99643796.0
2007-07-27 16:00:00	AAPL	Stock	5.1361	5.1457	5.1357	5.1375	5747896.0
2007-07-27 09:30:00	MSFT	Stock	29.93	30.0	29.58	29.7	6241716.0
2007-07-27 10:00:00	MSFT	Stock	29.7	29.88	29.61	29.69	6576133.0
2007-07-27 10:30:00	MSFT	Stock	29.691	29.74	29.56	29.69	4447190.0
2007-07-27 11:00:00	MSFT	Stock	29.69	29.81	29.6	29.64	3728576.0
2007-07-27 11:30:00	MSFT	Stock	29.63	29.73	29.56	29.65	3339449.0
2007-07-27 12:00:00	MSFT	Stock	29.65	29.73	29.59	29.73	3837068.0
2007-07-27 12:30:00	MSFT	Stock	29.74	29.81	29.49	29.53	4778195.0
2007-07-27 13:00:00	MSFT	Stock	29.54	29.72	29.52	29.62	3171369.0
2007-07-27 13:30:00	MSFT	Stock	29.62	29.77	29.59	29.67	3446648.0
2007-07-27 14:00:00	MSFT	Stock	29.67	29.75	29.55	29.59	3169270.0
2007-07-27 14:30:00	MSFT	Stock	29.59	29.8	29.55	29.68	3596148.0
2007-07-27 15:00:00	MSFT	Stock	29.68	29.74	29.64	29.67	4224768.0
2007-07-27 15:30:00	MSFT	Stock	29.67	29.69	29.36	29.37	10315685.0
2007-07-27 16:00:00	MSFT	Stock	29.37	29.46	29.37	29.39	1242940.0
2007-07-27 08:00:00	NVDA	Stock	0.735	0.735	0.7293	0.7293	88800.0
2007-07-27 08:30:00	NVDA	Stock	0.7293	0.7382	0.7283	0.736	259800.0
2007-07-27 09:00:00	NVDA	Stock	0.7357	0.7417	0.7357	0.74	617820.0
2007-07-27 09:30:00	NVDA	Stock	0.7375	0.7603	0.7375	0.7582	74865600.0
2007-07-27 10:00:00	NVDA	Stock	0.7587	0.7715	0.7553	0.7673	70432920.0
2007-07-27 10:30:00	NVDA	Stock	0.7675	0.7683	0.7567	0.7583	50321640.0
2007-07-27 11:00:00	NVDA	Stock	0.7583	0.7645	0.7558	0.7633	37509540.0
2007-07-27 11:30:00	NVDA	Stock	0.7632	0.7643	0.754	0.755	47650500.0
2007-07-27 12:00:00	NVDA	Stock	0.755	0.756	0.7492	0.752	35085360.0
2007-07-27 12:30:00	NVDA	Stock	0.752	0.753	0.7465	0.7468	40692120.0
2007-07-27 13:00:00	NVDA	Stock	0.7468	0.7633	0.7463	0.7512	33793320.0
2007-07-27 13:30:00	NVDA	Stock	0.7512	0.7598	0.7505	0.757	31910040.0
2007-07-27 14:00:00	NVDA	Stock	0.7572	0.7595	0.7497	0.7498	30499500.0
2007-07-27 14:30:00	NVDA	Stock	0.7498	0.76	0.7495	0.7555	31703760.0
2007-07-27 15:00:00	NVDA	Stock	0.7557	0.756	0.751	0.752	38725800.0
2007-07-27 15:30:00	NVDA	Stock	0.7522	0.7525	0.7372	0.7372	75441720.0
2007-07-27 16:00:00	NVDA	Stock	0.7372	0.7383	0.73	0.7365	1731780.0
2007-07-27 16:30:00	NVDA	Stock	0.7357	0.7365	0.7317	0.7348	354660.0
2007-07-27 17:00:00	NVDA	Stock	0.7358	0.7358	0.7358	0.7358	6000.0
2007-07-27 17:30:00	NVDA	Stock	0.7358	0.7358	0.7358	0.7358	6000.0
2007-07-27 18:30:00	NVDA	Stock	0.7358	0.7358	0.7358	0.7358	6000.0
2007-07-27 19:30:00	NVDA	Stock	0.7577	0.7587	0.7325	0.7325	336780.0

> showing 50 of 67,258 rows — these rows as CSV

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