PREVIEW / stock_30min / 2007-04-13

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-13.parquet
  size:    1.0 MB
  rows:    55,115
  symbols: 2,577

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-13 06:30:00	AAPL	Stock	3.2318	3.2421	3.2318	3.2421	30800.0
2007-04-13 07:00:00	AAPL	Stock	3.2296	3.2357	3.2293	3.2357	22400.0
2007-04-13 07:30:00	AAPL	Stock	3.2393	3.2411	3.2357	3.2375	1017800.0
2007-04-13 08:00:00	AAPL	Stock	3.2393	3.2396	3.225	3.2368	4782904.0
2007-04-13 08:30:00	AAPL	Stock	3.2357	3.2532	3.2343	3.2446	9859780.0
2007-04-13 09:00:00	AAPL	Stock	3.2454	3.2643	3.2414	3.2464	5586532.0
2007-04-13 09:30:00	AAPL	Stock	3.2464	3.2643	3.2321	3.2482	140353444.0
2007-04-13 10:00:00	AAPL	Stock	3.2482	3.2571	3.2339	3.2496	87756312.0
2007-04-13 10:30:00	AAPL	Stock	3.2496	3.2564	3.2443	3.2464	53185804.0
2007-04-13 11:00:00	AAPL	Stock	3.247	3.25	3.2393	3.2464	45188388.0
2007-04-13 11:30:00	AAPL	Stock	3.2468	3.2471	3.235	3.2404	31862908.0
2007-04-13 12:00:00	AAPL	Stock	3.2404	3.2421	3.2307	3.2368	31228736.0
2007-04-13 12:30:00	AAPL	Stock	3.2368	3.2393	3.2325	3.2361	18587912.0
2007-04-13 13:00:00	AAPL	Stock	3.2361	3.2382	3.2196	3.2243	47881792.0
2007-04-13 13:30:00	AAPL	Stock	3.2243	3.2289	3.2207	3.2232	34745508.0
2007-04-13 14:00:00	AAPL	Stock	3.2229	3.2321	3.2164	3.2304	42433216.0
2007-04-13 14:30:00	AAPL	Stock	3.2304	3.2407	3.2275	3.2336	44681224.0
2007-04-13 15:00:00	AAPL	Stock	3.2339	3.2389	3.2286	3.2304	33952380.0
2007-04-13 15:30:00	AAPL	Stock	3.2306	3.2332	3.2179	3.2232	72753660.0
2007-04-13 16:00:00	AAPL	Stock	3.2232	3.225	3.2179	3.2246	2890440.0
2007-04-13 16:30:00	AAPL	Stock	3.2246	3.2246	3.2229	3.2229	1243984.0
2007-04-13 17:00:00	AAPL	Stock	3.2229	3.2243	3.2218	3.2232	285544.0
2007-04-13 17:30:00	AAPL	Stock	3.2243	3.2243	3.2221	3.2232	186144.0
2007-04-13 18:00:00	AAPL	Stock	3.2232	3.2246	3.2229	3.2232	54488.0
2007-04-13 18:30:00	AAPL	Stock	3.2232	3.2232	3.2229	3.2229	151620.0
2007-04-13 19:00:00	AAPL	Stock	3.2232	3.2239	3.2229	3.2229	54320.0
2007-04-13 19:30:00	AAPL	Stock	3.2236	3.2243	3.2225	3.2229	84000.0
2007-04-13 05:30:00	MSFT	Stock	28.49	28.49	28.49	28.49	200.0
2007-04-13 07:30:00	MSFT	Stock	28.57	28.57	28.47	28.47	600.0
2007-04-13 08:00:00	MSFT	Stock	28.5	28.52	28.5	28.52	505.0
2007-04-13 08:30:00	MSFT	Stock	28.52	28.54	28.48	28.48	6555.0
2007-04-13 09:00:00	MSFT	Stock	28.53	28.54	28.43	28.43	51086.0
2007-04-13 09:30:00	MSFT	Stock	28.43	28.46	28.28	28.31	2994707.0
2007-04-13 10:00:00	MSFT	Stock	28.31	28.31	28.1	28.25	4335204.0
2007-04-13 10:30:00	MSFT	Stock	28.25	28.43	28.24	28.392	3546181.0
2007-04-13 11:00:00	MSFT	Stock	28.39	28.45	28.339	28.4	2248846.0
2007-04-13 11:30:00	MSFT	Stock	28.395	28.42	28.35	28.41	1258144.0
2007-04-13 12:00:00	MSFT	Stock	28.402	28.486	28.35	28.4	2848601.0
2007-04-13 12:30:00	MSFT	Stock	28.39	28.47	28.38	28.45	1387878.0
2007-04-13 13:00:00	MSFT	Stock	28.45	28.48	28.38	28.43	1708379.0
2007-04-13 13:30:00	MSFT	Stock	28.421	28.52	28.42	28.44	2243535.0
2007-04-13 14:00:00	MSFT	Stock	28.44	28.47	28.38	28.469	1378669.0
2007-04-13 14:30:00	MSFT	Stock	28.46	28.7	28.44	28.52	2572298.0
2007-04-13 15:00:00	MSFT	Stock	28.52	28.66	28.51	28.58	2797830.0
2007-04-13 15:30:00	MSFT	Stock	28.58	28.65	28.56	28.62	4860368.0
2007-04-13 16:00:00	MSFT	Stock	28.62	28.65	28.59	28.61	145320.0
2007-04-13 16:30:00	MSFT	Stock	28.61	28.63	28.39	28.61	18977.0
2007-04-13 17:00:00	MSFT	Stock	28.61	28.61	28.61	28.61	4600.0
2007-04-13 17:30:00	MSFT	Stock	28.61	28.62	28.61	28.62	1150.0
2007-04-13 18:00:00	MSFT	Stock	28.63	28.64	28.63	28.64	2480.0

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

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