PREVIEW / stock_30min / 2010-03-25

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-25.parquet
  size:    1.4 MB
  rows:    76,579
  symbols: 3,493

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
2010-03-25 05:00:00	AAPL	Stock	8.2054	8.2054	8.2054	8.2054	3052.0
2010-03-25 06:30:00	AAPL	Stock	8.2014	8.2014	8.2014	8.2014	8400.0
2010-03-25 07:00:00	AAPL	Stock	8.2282	8.2346	8.225	8.2296	213192.0
2010-03-25 07:30:00	AAPL	Stock	8.2296	8.2296	8.2257	8.2279	93212.0
2010-03-25 08:00:00	AAPL	Stock	8.2261	8.2475	8.2229	8.2382	1282484.0
2010-03-25 08:30:00	AAPL	Stock	8.2386	8.2507	8.2321	8.2364	1237208.0
2010-03-25 09:00:00	AAPL	Stock	8.2364	8.2518	8.2321	8.2482	3812032.0
2010-03-25 09:30:00	AAPL	Stock	8.2471	8.2493	8.2057	8.21	77722400.0
2010-03-25 10:00:00	AAPL	Stock	8.2093	8.2304	8.195	8.2036	59465896.0
2010-03-25 10:30:00	AAPL	Stock	8.2029	8.2175	8.2004	8.2107	24163412.0
2010-03-25 11:00:00	AAPL	Stock	8.2089	8.2446	8.2071	8.2361	41137208.0
2010-03-25 11:30:00	AAPL	Stock	8.2368	8.2468	8.2339	8.2458	23302580.0
2010-03-25 12:00:00	AAPL	Stock	8.2461	8.2464	8.22	8.2236	18990496.0
2010-03-25 12:30:00	AAPL	Stock	8.2236	8.2336	8.2182	8.2214	16444568.0
2010-03-25 13:00:00	AAPL	Stock	8.2221	8.2318	8.2179	8.2261	11657604.0
2010-03-25 13:30:00	AAPL	Stock	8.2261	8.2275	8.1793	8.1954	45131156.0
2010-03-25 14:00:00	AAPL	Stock	8.1954	8.1964	8.1286	8.135	46799060.0
2010-03-25 14:30:00	AAPL	Stock	8.135	8.1679	8.1257	8.1604	37035908.0
2010-03-25 15:00:00	AAPL	Stock	8.1596	8.1879	8.1489	8.1511	32023880.0
2010-03-25 15:30:00	AAPL	Stock	8.1504	8.1539	8.0804	8.0975	79066820.0
2010-03-25 16:00:00	AAPL	Stock	8.1018	8.245	8.0904	8.1107	11446456.0
2010-03-25 16:30:00	AAPL	Stock	8.1107	8.133	8.0938	8.102	1516396.0
2010-03-25 17:00:00	AAPL	Stock	8.1918	8.1918	8.0896	8.0896	652708.0
2010-03-25 17:30:00	AAPL	Stock	8.0893	8.1021	8.0893	8.0921	248640.0
2010-03-25 18:00:00	AAPL	Stock	8.0982	8.105	8.0921	8.1046	227136.0
2010-03-25 18:30:00	AAPL	Stock	8.1036	8.105	8.0911	8.105	81200.0
2010-03-25 19:00:00	AAPL	Stock	8.1061	8.1132	8.1011	8.1071	224392.0
2010-03-25 19:30:00	AAPL	Stock	8.1104	8.1125	8.1	8.1071	616196.0
2010-03-25 07:00:00	MSFT	Stock	29.7	29.7	29.7	29.7	700.0
2010-03-25 07:30:00	MSFT	Stock	29.71	29.75	29.71	29.75	1109.0
2010-03-25 08:00:00	MSFT	Stock	29.75	29.75	29.72	29.74	10891.0
2010-03-25 08:30:00	MSFT	Stock	29.73	29.75	29.7	29.7	53430.0
2010-03-25 09:00:00	MSFT	Stock	29.74	29.84	29.74	29.82	74209.0
2010-03-25 09:30:00	MSFT	Stock	29.83	30.17	29.8	30.14	9517253.0
2010-03-25 10:00:00	MSFT	Stock	30.134	30.25	30.08	30.2	6549514.0
2010-03-25 10:30:00	MSFT	Stock	30.201	30.26	30.15	30.25	6500767.0
2010-03-25 11:00:00	MSFT	Stock	30.25	30.55	30.23	30.49	9140069.0
2010-03-25 11:30:00	MSFT	Stock	30.49	30.57	30.45	30.479	3334575.0
2010-03-25 12:00:00	MSFT	Stock	30.48	30.53	30.4	30.42	3596886.0
2010-03-25 12:30:00	MSFT	Stock	30.42	30.53	30.411	30.47	2561501.0
2010-03-25 13:00:00	MSFT	Stock	30.47	30.5	30.42	30.488	2467386.0
2010-03-25 13:30:00	MSFT	Stock	30.48	30.5	30.23	30.3	5082394.0
2010-03-25 14:00:00	MSFT	Stock	30.3	30.33	30.17	30.21	3177531.0
2010-03-25 14:30:00	MSFT	Stock	30.21	30.26	30.16	30.235	3305485.0
2010-03-25 15:00:00	MSFT	Stock	30.24	30.34	30.22	30.22	3020971.0
2010-03-25 15:30:00	MSFT	Stock	30.23	30.27	30.01	30.01	9996263.0
2010-03-25 16:00:00	MSFT	Stock	30.01	30.47	29.97	30.02	2162038.0
2010-03-25 16:30:00	MSFT	Stock	30.218	30.238	29.99	30.006	235562.0
2010-03-25 17:00:00	MSFT	Stock	29.65	30.01	29.65	29.98	19125.0
2010-03-25 17:30:00	MSFT	Stock	29.97	30.01	29.91	29.94	8301.0

> showing 50 of 76,579 rows — these rows as CSV

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