PREVIEW / stock_30min / 2009-07-16

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-07-16.parquet
  size:    1.3 MB
  rows:    69,399
  symbols: 3,335

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
2009-07-16 05:30:00	AAPL	Stock	5.2643	5.2643	5.2643	5.2643	2800.0
2009-07-16 07:30:00	AAPL	Stock	5.2625	5.2625	5.1904	5.1929	743624.0
2009-07-16 08:00:00	AAPL	Stock	5.1929	5.2082	5.1929	5.2039	1204000.0
2009-07-16 08:30:00	AAPL	Stock	5.2068	5.2268	5.1964	5.2089	1362620.0
2009-07-16 09:00:00	AAPL	Stock	5.2057	5.2139	5.1946	5.2139	1044232.0
2009-07-16 09:30:00	AAPL	Stock	5.21	5.2825	5.1989	5.2652	81655588.0
2009-07-16 10:00:00	AAPL	Stock	5.2664	5.2664	5.2286	5.2554	34411664.0
2009-07-16 10:30:00	AAPL	Stock	5.255	5.2693	5.2521	5.2536	22074024.0
2009-07-16 11:00:00	AAPL	Stock	5.2537	5.2693	5.2429	5.2539	17779552.0
2009-07-16 11:30:00	AAPL	Stock	5.2536	5.2568	5.2429	5.2511	17552948.0
2009-07-16 12:00:00	AAPL	Stock	5.2518	5.2546	5.2436	5.2504	9258088.0
2009-07-16 12:30:00	AAPL	Stock	5.2504	5.2521	5.2386	5.24	12317676.0
2009-07-16 13:00:00	AAPL	Stock	5.2404	5.2446	5.2364	5.2425	12381992.0
2009-07-16 13:30:00	AAPL	Stock	5.2429	5.2539	5.2357	5.2539	20281156.0
2009-07-16 14:00:00	AAPL	Stock	5.2537	5.2582	5.2461	5.2525	26678596.0
2009-07-16 14:30:00	AAPL	Stock	5.2521	5.2639	5.2464	5.2589	35853748.0
2009-07-16 15:00:00	AAPL	Stock	5.2589	5.2743	5.2525	5.2696	28444164.0
2009-07-16 15:30:00	AAPL	Stock	5.2704	5.2864	5.2604	5.2675	53373488.0
2009-07-16 16:00:00	AAPL	Stock	5.2682	5.2807	5.2232	5.2532	9756572.0
2009-07-16 16:30:00	AAPL	Stock	5.2518	5.2696	5.2436	5.2507	769468.0
2009-07-16 17:00:00	AAPL	Stock	5.2518	5.255	5.2429	5.2464	235760.0
2009-07-16 17:30:00	AAPL	Stock	5.2496	5.2536	5.2464	5.2464	47404.0
2009-07-16 18:00:00	AAPL	Stock	5.2686	5.2686	5.245	5.245	210756.0
2009-07-16 18:30:00	AAPL	Stock	5.2521	5.2643	5.2521	5.2604	634592.0
2009-07-16 19:00:00	AAPL	Stock	5.2589	5.2611	5.2582	5.2582	43876.0
2009-07-16 19:30:00	AAPL	Stock	5.2607	5.2607	5.2561	5.2589	91280.0
2009-07-16 07:00:00	MSFT	Stock	24.13	24.13	24.1	24.11	7120.0
2009-07-16 07:30:00	MSFT	Stock	24.17	24.25	23.92	23.92	7600.0
2009-07-16 08:00:00	MSFT	Stock	23.92	24.0	23.83	23.83	31590.0
2009-07-16 08:30:00	MSFT	Stock	23.91	24.15	23.91	23.98	61650.0
2009-07-16 09:00:00	MSFT	Stock	23.92	23.95	23.87	23.95	4561.0
2009-07-16 09:30:00	MSFT	Stock	23.95	24.16	23.86	24.082	7647435.0
2009-07-16 10:00:00	MSFT	Stock	24.085	24.22	23.93	24.191	7384864.0
2009-07-16 10:30:00	MSFT	Stock	24.2	24.29	24.15	24.22	4476780.0
2009-07-16 11:00:00	MSFT	Stock	24.23	24.27	24.13	24.21	2808032.0
2009-07-16 11:30:00	MSFT	Stock	24.21	24.27	24.17	24.23	2537432.0
2009-07-16 12:00:00	MSFT	Stock	24.24	24.25	24.14	24.21	3202752.0
2009-07-16 12:30:00	MSFT	Stock	24.21	24.21	24.11	24.138	2732833.0
2009-07-16 13:00:00	MSFT	Stock	24.14	24.16	24.11	24.15	1948851.0
2009-07-16 13:30:00	MSFT	Stock	24.16	24.3	24.15	24.292	3886212.0
2009-07-16 14:00:00	MSFT	Stock	24.3	24.37	24.28	24.29	3836570.0
2009-07-16 14:30:00	MSFT	Stock	24.29	24.34	24.26	24.27	3955122.0
2009-07-16 15:00:00	MSFT	Stock	24.27	24.31	24.22	24.291	5111058.0
2009-07-16 15:30:00	MSFT	Stock	24.3	24.44	24.24	24.44	11058508.0
2009-07-16 16:00:00	MSFT	Stock	24.44	24.48	24.196	24.33	2140338.0
2009-07-16 16:30:00	MSFT	Stock	24.33	24.445	24.25	24.25	20022.0
2009-07-16 17:00:00	MSFT	Stock	24.25	24.34	24.21	24.21	10860.0
2009-07-16 17:30:00	MSFT	Stock	24.27	24.3	24.27	24.27	1745.0
2009-07-16 18:00:00	MSFT	Stock	24.44	24.44	24.2	24.36	20742.0
2009-07-16 19:00:00	MSFT	Stock	24.35	24.35	24.31	24.31	700.0

> showing 50 of 69,399 rows — these rows as CSV

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