PREVIEW / stock_30min / 2009-01-02

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-02.parquet
  size:    1.3 MB
  rows:    70,005
  symbols: 3,320

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-01-02 07:30:00	AAPL	Stock	3.0696	3.0796	3.0696	3.0768	34860.0
2009-01-02 08:00:00	AAPL	Stock	3.0768	3.0768	3.0482	3.0614	1034488.0
2009-01-02 08:30:00	AAPL	Stock	3.0482	3.0714	3.0482	3.0661	2083144.0
2009-01-02 09:00:00	AAPL	Stock	3.0661	3.07	3.0482	3.0579	1259580.0
2009-01-02 09:30:00	AAPL	Stock	3.0579	3.1179	3.0414	3.1064	82547248.0
2009-01-02 10:00:00	AAPL	Stock	3.1054	3.1157	3.0954	3.1079	52746120.0
2009-01-02 10:30:00	AAPL	Stock	3.1079	3.1379	3.1025	3.1271	54114368.0
2009-01-02 11:00:00	AAPL	Stock	3.1279	3.1389	3.1182	3.1364	39671968.0
2009-01-02 11:30:00	AAPL	Stock	3.1357	3.1464	3.1329	3.1443	37954364.0
2009-01-02 12:00:00	AAPL	Stock	3.1439	3.1943	3.1396	3.1936	57947652.0
2009-01-02 12:30:00	AAPL	Stock	3.1932	3.2064	3.1875	3.1946	55320860.0
2009-01-02 13:00:00	AAPL	Stock	3.1946	3.2043	3.1875	3.1986	36589504.0
2009-01-02 13:30:00	AAPL	Stock	3.1986	3.2104	3.1954	3.1982	31211348.0
2009-01-02 14:00:00	AAPL	Stock	3.1989	3.2125	3.19	3.2104	40544532.0
2009-01-02 14:30:00	AAPL	Stock	3.2107	3.2143	3.2054	3.2132	42043848.0
2009-01-02 15:00:00	AAPL	Stock	3.2132	3.2389	3.2132	3.2357	75796392.0
2009-01-02 15:30:00	AAPL	Stock	3.2357	3.2514	3.2296	3.2386	106846040.0
2009-01-02 16:00:00	AAPL	Stock	3.2386	3.2421	3.1747	3.2279	18888408.0
2009-01-02 16:30:00	AAPL	Stock	3.2282	3.2411	3.225	3.2304	403648.0
2009-01-02 17:00:00	AAPL	Stock	3.2296	3.2318	3.2286	3.2311	91756.0
2009-01-02 17:30:00	AAPL	Stock	3.2314	3.2321	3.23	3.2314	48244.0
2009-01-02 18:00:00	AAPL	Stock	3.2289	3.2411	3.2289	3.2368	8460536.0
2009-01-02 18:30:00	AAPL	Stock	3.2375	3.24	3.2307	3.2307	253232.0
2009-01-02 19:00:00	AAPL	Stock	3.2325	3.2325	3.2286	3.2286	174384.0
2009-01-02 19:30:00	AAPL	Stock	3.2254	3.2336	3.2254	3.2304	77728.0
2009-01-02 07:00:00	MSFT	Stock	19.45	19.45	19.45	19.45	100.0
2009-01-02 08:00:00	MSFT	Stock	19.48	19.48	19.39	19.39	282511.0
2009-01-02 08:30:00	MSFT	Stock	19.39	19.44	19.36	19.39	11456.0
2009-01-02 09:00:00	MSFT	Stock	19.44	19.55	19.4	19.55	26163.0
2009-01-02 09:30:00	MSFT	Stock	19.53	19.6	19.37	19.55	4065900.0
2009-01-02 10:00:00	MSFT	Stock	19.55	19.75	19.54	19.74	3969136.0
2009-01-02 10:30:00	MSFT	Stock	19.738	19.94	19.73	19.9	3494200.0
2009-01-02 11:00:00	MSFT	Stock	19.9	19.96	19.86	19.96	2339071.0
2009-01-02 11:30:00	MSFT	Stock	19.952	20.04	19.93	20.01	2562144.0
2009-01-02 12:00:00	MSFT	Stock	20.0	20.05	19.93	19.96	2071054.0
2009-01-02 12:30:00	MSFT	Stock	19.948	20.05	19.948	20.02	1699465.0
2009-01-02 13:00:00	MSFT	Stock	20.012	20.09	19.97	20.08	1514527.0
2009-01-02 13:30:00	MSFT	Stock	20.072	20.13	20.05	20.095	2247843.0
2009-01-02 14:00:00	MSFT	Stock	20.1	20.2	20.07	20.13	3931227.0
2009-01-02 14:30:00	MSFT	Stock	20.14	20.2	20.09	20.14	4568937.0
2009-01-02 15:00:00	MSFT	Stock	20.15	20.24	20.14	20.222	2948685.0
2009-01-02 15:30:00	MSFT	Stock	20.23	20.4	20.21	20.32	9363909.0
2009-01-02 16:00:00	MSFT	Stock	20.33	20.37	20.02	20.24	4367506.0
2009-01-02 16:30:00	MSFT	Stock	20.25	20.33	20.25	20.33	64243.0
2009-01-02 17:00:00	MSFT	Stock	20.23	20.28	20.23	20.28	1950.0
2009-01-02 17:30:00	MSFT	Stock	20.28	20.28	20.28	20.28	3800.0
2009-01-02 18:00:00	MSFT	Stock	20.33	20.33	20.33	20.33	28385.0
2009-01-02 18:30:00	MSFT	Stock	20.3	20.3	20.3	20.3	1390.0
2009-01-02 19:00:00	MSFT	Stock	20.28	20.28	20.28	20.28	100.0
2009-01-02 19:30:00	MSFT	Stock	20.29	20.31	20.28	20.28	5800.0

> showing 50 of 70,005 rows — these rows as CSV

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