PREVIEW / stock_30min / 2010-07-08

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-08.parquet
  size:    1.3 MB
  rows:    74,507
  symbols: 3,459

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-07-08 04:30:00	AAPL	Stock	9.2714	9.2789	9.2714	9.2789	14000.0
2010-07-08 05:00:00	AAPL	Stock	9.2804	9.2804	9.275	9.275	5600.0
2010-07-08 05:30:00	AAPL	Stock	9.2754	9.2754	9.275	9.275	56000.0
2010-07-08 06:00:00	AAPL	Stock	9.2768	9.2768	9.2768	9.2768	2800.0
2010-07-08 06:30:00	AAPL	Stock	9.3018	9.3018	9.3018	9.3018	8400.0
2010-07-08 07:00:00	AAPL	Stock	9.2768	9.2857	9.2554	9.2661	469728.0
2010-07-08 07:30:00	AAPL	Stock	9.2679	9.2679	9.245	9.2621	155820.0
2010-07-08 08:00:00	AAPL	Stock	9.2575	9.2996	9.25	9.2854	2513252.0
2010-07-08 08:30:00	AAPL	Stock	9.2857	9.3811	9.2857	9.3679	7611044.0
2010-07-08 09:00:00	AAPL	Stock	9.37	9.3925	9.3664	9.3757	3891132.0
2010-07-08 09:30:00	AAPL	Stock	9.3764	9.3893	9.3086	9.3316	113979068.0
2010-07-08 10:00:00	AAPL	Stock	9.3311	9.3489	9.2964	9.3421	71603784.0
2010-07-08 10:30:00	AAPL	Stock	9.3429	9.3446	9.2825	9.2846	40772032.0
2010-07-08 11:00:00	AAPL	Stock	9.285	9.2851	9.2007	9.2375	79004184.0
2010-07-08 11:30:00	AAPL	Stock	9.2386	9.2411	9.1286	9.1521	64823612.0
2010-07-08 12:00:00	AAPL	Stock	9.1514	9.2032	9.1386	9.1942	44800336.0
2010-07-08 12:30:00	AAPL	Stock	9.1929	9.1968	9.1032	9.1175	35277564.0
2010-07-08 13:00:00	AAPL	Stock	9.1171	9.1911	9.1132	9.1725	46319308.0
2010-07-08 13:30:00	AAPL	Stock	9.172	9.1996	9.1461	9.16	29893136.0
2010-07-08 14:00:00	AAPL	Stock	9.1579	9.1764	9.1107	9.1482	32521692.0
2010-07-08 14:30:00	AAPL	Stock	9.15	9.1821	9.1293	9.175	28915376.0
2010-07-08 15:00:00	AAPL	Stock	9.1757	9.2211	9.1446	9.2146	46353328.0
2010-07-08 15:30:00	AAPL	Stock	9.2157	9.2375	9.2061	9.2143	75127696.0
2010-07-08 16:00:00	AAPL	Stock	9.2171	9.3472	9.1844	9.2168	10672116.0
2010-07-08 16:30:00	AAPL	Stock	9.2168	9.233	9.214	9.2207	376264.0
2010-07-08 17:00:00	AAPL	Stock	9.2204	9.2207	9.2164	9.2207	191240.0
2010-07-08 17:30:00	AAPL	Stock	9.2204	9.2207	9.2157	9.2161	155540.0
2010-07-08 18:00:00	AAPL	Stock	9.2189	9.2196	9.2157	9.2196	131964.0
2010-07-08 18:30:00	AAPL	Stock	9.2164	9.2164	9.2036	9.2104	167636.0
2010-07-08 19:00:00	AAPL	Stock	9.2089	9.2107	9.2	9.2	436912.0
2010-07-08 19:30:00	AAPL	Stock	9.1986	9.2096	9.1982	9.2004	204960.0
2010-07-08 07:00:00	MSFT	Stock	24.38	24.42	24.38	24.42	3000.0
2010-07-08 07:30:00	MSFT	Stock	24.35	24.35	24.35	24.35	800.0
2010-07-08 08:00:00	MSFT	Stock	24.35	24.37	24.31	24.37	8466.0
2010-07-08 08:30:00	MSFT	Stock	24.4	24.54	24.4	24.53	57410.0
2010-07-08 09:00:00	MSFT	Stock	24.51	24.63	24.43	24.6	102656.0
2010-07-08 09:30:00	MSFT	Stock	24.6	24.63	23.972	24.31	6271792.0
2010-07-08 10:00:00	MSFT	Stock	24.32	24.38	24.22	24.37	4129398.0
2010-07-08 10:30:00	MSFT	Stock	24.37	24.4	24.24	24.342	3572820.0
2010-07-08 11:00:00	MSFT	Stock	24.35	24.35	24.18	24.19	3165973.0
2010-07-08 11:30:00	MSFT	Stock	24.2	24.3	24.17	24.23	2802218.0
2010-07-08 12:00:00	MSFT	Stock	24.23	24.37	24.22	24.315	2264530.0
2010-07-08 12:30:00	MSFT	Stock	24.32	24.34	24.24	24.26	1685001.0
2010-07-08 13:00:00	MSFT	Stock	24.25	24.35	24.24	24.264	1722911.0
2010-07-08 13:30:00	MSFT	Stock	24.27	24.3	24.19	24.24	1815394.0
2010-07-08 14:00:00	MSFT	Stock	24.24	24.31	24.13	24.18	2590293.0
2010-07-08 14:30:00	MSFT	Stock	24.18	24.23	24.156	24.18	2835377.0
2010-07-08 15:00:00	MSFT	Stock	24.19	24.26	24.11	24.241	4954670.0
2010-07-08 15:30:00	MSFT	Stock	24.245	24.42	24.24	24.42	8761316.0
2010-07-08 16:00:00	MSFT	Stock	24.42	24.48	24.283	24.42	2070196.0

> showing 50 of 74,507 rows — these rows as CSV

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