PREVIEW / stock_30min / 2007-04-17

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-17.parquet
  size:    1.0 MB
  rows:    55,434
  symbols: 2,582

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-17 07:00:00	AAPL	Stock	3.2518	3.2518	3.2321	3.2411	204400.0
2007-04-17 07:30:00	AAPL	Stock	3.2407	3.2411	3.2232	3.2357	480200.0
2007-04-17 08:00:00	AAPL	Stock	3.2425	3.25	3.2357	3.2446	869624.0
2007-04-17 08:30:00	AAPL	Stock	3.2446	3.305	3.2432	3.2982	5653760.0
2007-04-17 09:00:00	AAPL	Stock	3.2971	3.2982	3.2829	3.2857	4386452.0
2007-04-17 09:30:00	AAPL	Stock	3.2857	3.2964	3.2379	3.2511	113082760.0
2007-04-17 10:00:00	AAPL	Stock	3.2511	3.2525	3.2357	3.2443	67705260.0
2007-04-17 10:30:00	AAPL	Stock	3.2439	3.2543	3.2375	3.2471	43627444.0
2007-04-17 11:00:00	AAPL	Stock	3.2475	3.25	3.2321	3.235	38223220.0
2007-04-17 11:30:00	AAPL	Stock	3.235	3.2429	3.225	3.2282	60024580.0
2007-04-17 12:00:00	AAPL	Stock	3.2286	3.2289	3.2039	3.2093	78678796.0
2007-04-17 12:30:00	AAPL	Stock	3.2093	3.2182	3.2054	3.2105	47169416.0
2007-04-17 13:00:00	AAPL	Stock	3.2104	3.2171	3.2036	3.2157	40206656.0
2007-04-17 13:30:00	AAPL	Stock	3.2157	3.2189	3.2125	3.2171	30223620.0
2007-04-17 14:00:00	AAPL	Stock	3.2175	3.2386	3.2168	3.2375	64878072.0
2007-04-17 14:30:00	AAPL	Stock	3.2375	3.2411	3.2304	3.2329	39388216.0
2007-04-17 15:00:00	AAPL	Stock	3.2332	3.2364	3.2221	3.2232	43002792.0
2007-04-17 15:30:00	AAPL	Stock	3.2232	3.2857	3.22	3.2268	60942364.0
2007-04-17 16:00:00	AAPL	Stock	3.2268	3.2304	3.225	3.2275	1484308.0
2007-04-17 16:30:00	AAPL	Stock	3.2261	3.2275	3.2214	3.225	1744428.0
2007-04-17 17:00:00	AAPL	Stock	3.2221	3.2264	3.2179	3.2236	1606584.0
2007-04-17 17:30:00	AAPL	Stock	3.2221	3.2268	3.2214	3.2264	183008.0
2007-04-17 18:00:00	AAPL	Stock	3.2268	3.2268	3.2214	3.2268	188244.0
2007-04-17 18:30:00	AAPL	Stock	3.2186	3.22	3.2186	3.2196	128492.0
2007-04-17 19:00:00	AAPL	Stock	3.2179	3.2179	3.2143	3.2168	102200.0
2007-04-17 19:30:00	AAPL	Stock	3.2143	3.2168	3.2143	3.2143	22400.0
2007-04-17 08:00:00	MSFT	Stock	28.7	28.7	28.63	28.63	400.0
2007-04-17 08:30:00	MSFT	Stock	28.7	28.77	28.65	28.77	18095.0
2007-04-17 09:00:00	MSFT	Stock	28.77	28.78	28.63	28.65	89839.0
2007-04-17 09:30:00	MSFT	Stock	28.63	28.73	28.56	28.69	4548121.0
2007-04-17 10:00:00	MSFT	Stock	28.69	28.73	28.63	28.64	2467272.0
2007-04-17 10:30:00	MSFT	Stock	28.645	28.75	28.63	28.71	2491530.0
2007-04-17 11:00:00	MSFT	Stock	28.71	28.73	28.67	28.71	1202514.0
2007-04-17 11:30:00	MSFT	Stock	28.72	28.75	28.71	28.74	1085034.0
2007-04-17 12:00:00	MSFT	Stock	28.73	28.74	28.72	28.73	1015596.0
2007-04-17 12:30:00	MSFT	Stock	28.74	28.74	28.65	28.67	1423378.0
2007-04-17 13:00:00	MSFT	Stock	28.67	28.71	28.65	28.71	1349382.0
2007-04-17 13:30:00	MSFT	Stock	28.71	28.75	28.7	28.74	991711.0
2007-04-17 14:00:00	MSFT	Stock	28.75	28.81	28.7	28.8	3868524.0
2007-04-17 14:30:00	MSFT	Stock	28.8	28.89	28.8	28.87	2254865.0
2007-04-17 15:00:00	MSFT	Stock	28.87	28.89	28.83	28.861	3061710.0
2007-04-17 15:30:00	MSFT	Stock	28.86	28.89	28.78	28.87	4800908.0
2007-04-17 16:00:00	MSFT	Stock	28.87	28.89	28.841	28.88	214363.0
2007-04-17 16:30:00	MSFT	Stock	28.87	28.87	28.75	28.84	8925.0
2007-04-17 17:00:00	MSFT	Stock	28.84	28.85	28.75	28.84	1211.0
2007-04-17 17:30:00	MSFT	Stock	28.84	28.84	28.84	28.84	100.0
2007-04-17 08:00:00	NVDA	Stock	0.5067	0.51	0.505	0.505	687000.0
2007-04-17 08:30:00	NVDA	Stock	0.5083	0.5163	0.5052	0.5163	2306640.0
2007-04-17 09:00:00	NVDA	Stock	0.5145	0.5207	0.5133	0.5198	9263940.0
2007-04-17 09:30:00	NVDA	Stock	0.5198	0.5317	0.5177	0.5238	196655520.0

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

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