PREVIEW / stock_30min / 2009-02-20

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-20.parquet
  size:    1.3 MB
  rows:    69,463
  symbols: 3,366

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-02-20 07:00:00	AAPL	Stock	3.1921	3.1929	3.1921	3.1929	16800.0
2009-02-20 07:30:00	AAPL	Stock	3.1786	3.1786	3.1643	3.1718	65520.0
2009-02-20 08:00:00	AAPL	Stock	3.1904	3.1964	3.175	3.1879	742448.0
2009-02-20 08:30:00	AAPL	Stock	3.1821	3.2011	3.1821	3.2004	894376.0
2009-02-20 09:00:00	AAPL	Stock	3.1982	3.2139	3.1696	3.1943	3887744.0
2009-02-20 09:30:00	AAPL	Stock	3.1911	3.2404	3.1786	3.2257	107036300.0
2009-02-20 10:00:00	AAPL	Stock	3.2261	3.24	3.1989	3.2162	65153004.0
2009-02-20 10:30:00	AAPL	Stock	3.2161	3.2264	3.1964	3.205	41536880.0
2009-02-20 11:00:00	AAPL	Stock	3.2046	3.2143	3.1975	3.2121	37326576.0
2009-02-20 11:30:00	AAPL	Stock	3.2118	3.2243	3.2057	3.2171	33691420.0
2009-02-20 12:00:00	AAPL	Stock	3.2171	3.2389	3.2168	3.2332	34857536.0
2009-02-20 12:30:00	AAPL	Stock	3.2325	3.2404	3.2118	3.2168	37219532.0
2009-02-20 13:00:00	AAPL	Stock	3.2164	3.2225	3.1964	3.2079	35924868.0
2009-02-20 13:30:00	AAPL	Stock	3.2086	3.2289	3.2021	3.2186	30336852.0
2009-02-20 14:00:00	AAPL	Stock	3.2186	3.2689	3.2057	3.2639	65969568.0
2009-02-20 14:30:00	AAPL	Stock	3.2639	3.3	3.2511	3.2729	88667992.0
2009-02-20 15:00:00	AAPL	Stock	3.2729	3.275	3.2368	3.2375	61038740.0
2009-02-20 15:30:00	AAPL	Stock	3.2378	3.2657	3.2329	3.2546	76966288.0
2009-02-20 16:00:00	AAPL	Stock	3.2564	3.2571	3.233	3.2482	9774744.0
2009-02-20 16:30:00	AAPL	Stock	3.2468	3.255	3.2446	3.255	163828.0
2009-02-20 17:00:00	AAPL	Stock	3.255	3.255	3.2546	3.2546	20636.0
2009-02-20 17:30:00	AAPL	Stock	3.2546	3.2546	3.2546	3.2546	8400.0
2009-02-20 18:00:00	AAPL	Stock	3.2543	3.2579	3.2543	3.2554	220500.0
2009-02-20 18:30:00	AAPL	Stock	3.2536	3.2536	3.2468	3.2468	106820.0
2009-02-20 19:00:00	AAPL	Stock	3.2532	3.2543	3.2482	3.2504	39200.0
2009-02-20 19:30:00	AAPL	Stock	3.2536	3.2539	3.2479	3.2539	89740.0
2009-02-20 07:30:00	MSFT	Stock	17.62	17.62	17.6	17.6	10000.0
2009-02-20 08:00:00	MSFT	Stock	17.68	17.75	17.6	17.66	44469.0
2009-02-20 08:30:00	MSFT	Stock	17.68	17.73	17.68	17.7	28215.0
2009-02-20 09:00:00	MSFT	Stock	17.73	17.8	17.66	17.76	70733.0
2009-02-20 09:30:00	MSFT	Stock	17.77	18.13	17.66	18.09	12854967.0
2009-02-20 10:00:00	MSFT	Stock	18.09	18.172	17.88	18.02	5202468.0
2009-02-20 10:30:00	MSFT	Stock	18.02	18.1	17.94	17.98	4415434.0
2009-02-20 11:00:00	MSFT	Stock	17.98	18.06	17.95	18.05	2719660.0
2009-02-20 11:30:00	MSFT	Stock	18.053	18.09	17.96	18.03	2478349.0
2009-02-20 12:00:00	MSFT	Stock	18.03	18.12	18.02	18.045	2347752.0
2009-02-20 12:30:00	MSFT	Stock	18.045	18.045	17.8	17.842	2978183.0
2009-02-20 13:00:00	MSFT	Stock	17.85	17.85	17.73	17.78	2380205.0
2009-02-20 13:30:00	MSFT	Stock	17.77	17.84	17.74	17.808	2464374.0
2009-02-20 14:00:00	MSFT	Stock	17.81	18.1	17.76	18.04	5424168.0
2009-02-20 14:30:00	MSFT	Stock	18.04	18.19	18.03	18.04	7679522.0
2009-02-20 15:00:00	MSFT	Stock	18.04	18.09	17.88	17.89	5194281.0
2009-02-20 15:30:00	MSFT	Stock	17.89	18.09	17.83	17.99	9284111.0
2009-02-20 16:00:00	MSFT	Stock	17.99	18.05	17.92	17.99	2135054.0
2009-02-20 16:30:00	MSFT	Stock	18.0	18.01	17.98	18.01	10951.0
2009-02-20 17:00:00	MSFT	Stock	17.98	18.01	17.98	18.01	1075.0
2009-02-20 17:30:00	MSFT	Stock	18.01	18.01	18.01	18.01	400.0
2009-02-20 18:00:00	MSFT	Stock	18.01	18.02	18.01	18.01	500.0
2009-02-20 18:30:00	MSFT	Stock	18.06	18.06	18.06	18.06	1400.0
2009-02-20 19:30:00	MSFT	Stock	18.01	18.05	18.01	18.05	499.0

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

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