PREVIEW / stock_30min / 2007-04-12

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-12.parquet
  size:    1.0 MB
  rows:    55,518
  symbols: 2,573

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-12 04:00:00	AAPL	Stock	3.3104	3.3104	3.3068	3.3068	7000.0
2007-04-12 07:00:00	AAPL	Stock	3.3043	3.3043	3.3043	3.3043	8400.0
2007-04-12 07:30:00	AAPL	Stock	3.3018	3.3018	3.3018	3.3018	5600.0
2007-04-12 08:00:00	AAPL	Stock	3.3014	3.3032	3.2893	3.2911	610792.0
2007-04-12 08:30:00	AAPL	Stock	3.29	3.2929	3.2868	3.2929	686840.0
2007-04-12 09:00:00	AAPL	Stock	3.2929	3.2975	3.2868	3.2879	905492.0
2007-04-12 09:30:00	AAPL	Stock	3.2871	3.2882	3.24	3.2575	125028848.0
2007-04-12 10:00:00	AAPL	Stock	3.2571	3.2721	3.2532	3.2711	73415216.0
2007-04-12 10:30:00	AAPL	Stock	3.27	3.2811	3.2661	3.2793	57242808.0
2007-04-12 11:00:00	AAPL	Stock	3.2793	3.2968	3.2768	3.2871	66741976.0
2007-04-12 11:30:00	AAPL	Stock	3.2871	3.2875	3.2711	3.2786	35356496.0
2007-04-12 12:00:00	AAPL	Stock	3.2786	3.2946	3.2786	3.2868	41121920.0
2007-04-12 12:30:00	AAPL	Stock	3.2868	3.2889	3.2818	3.2889	18042864.0
2007-04-12 13:00:00	AAPL	Stock	3.2882	3.2939	3.2796	3.2896	26236672.0
2007-04-12 13:30:00	AAPL	Stock	3.2896	3.2946	3.2879	3.2889	20452404.0
2007-04-12 14:00:00	AAPL	Stock	3.2889	3.2907	3.2829	3.2875	19802328.0
2007-04-12 14:30:00	AAPL	Stock	3.2875	3.2943	3.2861	3.2904	18239396.0
2007-04-12 15:00:00	AAPL	Stock	3.2904	3.2943	3.29	3.2907	20481860.0
2007-04-12 15:30:00	AAPL	Stock	3.2904	3.2929	3.2811	3.2911	50677256.0
2007-04-12 16:00:00	AAPL	Stock	3.2911	3.2929	3.2861	3.2861	2503564.0
2007-04-12 16:30:00	AAPL	Stock	3.2861	3.2925	3.1907	3.1964	34458480.0
2007-04-12 17:00:00	AAPL	Stock	3.1957	3.2925	3.1875	3.2107	36705900.0
2007-04-12 17:30:00	AAPL	Stock	3.21	3.2107	3.2	3.2036	3869824.0
2007-04-12 18:00:00	AAPL	Stock	3.2039	3.2179	3.2036	3.2175	1522640.0
2007-04-12 18:30:00	AAPL	Stock	3.2207	3.2357	3.2161	3.2314	1127392.0
2007-04-12 19:00:00	AAPL	Stock	3.2314	3.2321	3.2232	3.2232	375396.0
2007-04-12 19:30:00	AAPL	Stock	3.2232	3.2321	3.2232	3.2293	320264.0
2007-04-12 08:30:00	MSFT	Stock	28.1	28.1	28.1	28.1	1000.0
2007-04-12 09:00:00	MSFT	Stock	28.09	28.09	28.06	28.07	20460.0
2007-04-12 09:30:00	MSFT	Stock	28.06	28.19	28.04	28.12	4875157.0
2007-04-12 10:00:00	MSFT	Stock	28.11	28.32	28.1	28.3	3773087.0
2007-04-12 10:30:00	MSFT	Stock	28.3	28.43	28.22	28.36	3221248.0
2007-04-12 11:00:00	MSFT	Stock	28.36	28.42	28.31	28.41	3258171.0
2007-04-12 11:30:00	MSFT	Stock	28.42	28.42	28.29	28.4	1794815.0
2007-04-12 12:00:00	MSFT	Stock	28.39	28.54	28.36	28.45	2949545.0
2007-04-12 12:30:00	MSFT	Stock	28.45	28.55	28.41	28.52	1634432.0
2007-04-12 13:00:00	MSFT	Stock	28.53	28.62	28.51	28.56	2847972.0
2007-04-12 13:30:00	MSFT	Stock	28.57	28.58	28.45	28.45	2654177.0
2007-04-12 14:00:00	MSFT	Stock	28.45	28.47	28.36	28.36	1933872.0
2007-04-12 14:30:00	MSFT	Stock	28.36	28.49	28.36	28.41	2038647.0
2007-04-12 15:00:00	MSFT	Stock	28.42	28.5	28.4	28.48	2332241.0
2007-04-12 15:30:00	MSFT	Stock	28.48	28.59	28.42	28.54	8423317.0
2007-04-12 16:00:00	MSFT	Stock	28.54	28.57	28.397	28.53	762264.0
2007-04-12 16:30:00	MSFT	Stock	28.53	28.53	28.52	28.52	1250.0
2007-04-12 17:00:00	MSFT	Stock	28.5	28.54	28.5	28.54	1489.0
2007-04-12 17:30:00	MSFT	Stock	28.53	28.53	28.53	28.53	2400.0
2007-04-12 18:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	100.0
2007-04-12 19:00:00	MSFT	Stock	28.52	28.53	28.52	28.53	2650.0
2007-04-12 19:30:00	MSFT	Stock	28.52	28.53	28.51	28.51	7050.0
2007-04-12 08:00:00	NVDA	Stock	0.4887	0.4887	0.4887	0.4887	6000.0

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

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