PREVIEW / stock_30min / 2010-02-18

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-18.parquet
  size:    1.3 MB
  rows:    72,954
  symbols: 3,451

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-02-18 04:30:00	AAPL	Stock	7.21	7.2143	7.21	7.2143	8400.0
2010-02-18 07:30:00	AAPL	Stock	7.2279	7.2279	7.2279	7.2279	5600.0
2010-02-18 08:00:00	AAPL	Stock	7.2118	7.2268	7.2118	7.2232	147364.0
2010-02-18 08:30:00	AAPL	Stock	7.2204	7.2204	7.1646	7.1714	2647036.0
2010-02-18 09:00:00	AAPL	Stock	7.1743	7.2029	7.1743	7.2029	1415652.0
2010-02-18 09:30:00	AAPL	Stock	7.2004	7.2193	7.1757	7.2071	57945664.0
2010-02-18 10:00:00	AAPL	Stock	7.2079	7.2179	7.1879	7.1979	41376972.0
2010-02-18 10:30:00	AAPL	Stock	7.1979	7.2639	7.1893	7.2529	45884804.0
2010-02-18 11:00:00	AAPL	Stock	7.2532	7.2818	7.2507	7.2561	41454196.0
2010-02-18 11:30:00	AAPL	Stock	7.2564	7.2657	7.2429	7.2546	24704596.0
2010-02-18 12:00:00	AAPL	Stock	7.2543	7.2643	7.2446	7.2525	15848000.0
2010-02-18 12:30:00	AAPL	Stock	7.2525	7.2539	7.2325	7.2411	15130640.0
2010-02-18 13:00:00	AAPL	Stock	7.2411	7.2511	7.2329	7.2425	17007284.0
2010-02-18 13:30:00	AAPL	Stock	7.2425	7.2482	7.2386	7.2414	19507628.0
2010-02-18 14:00:00	AAPL	Stock	7.2421	7.265	7.2336	7.2586	28500304.0
2010-02-18 14:30:00	AAPL	Stock	7.2586	7.2782	7.255	7.2746	27785044.0
2010-02-18 15:00:00	AAPL	Stock	7.2746	7.2782	7.26	7.2629	24460128.0
2010-02-18 15:30:00	AAPL	Stock	7.2632	7.2679	7.2418	7.2514	41665680.0
2010-02-18 16:00:00	AAPL	Stock	7.2514	7.2569	7.239	7.245	4778368.0
2010-02-18 16:30:00	AAPL	Stock	7.2622	7.2622	7.1936	7.2011	2059736.0
2010-02-18 17:00:00	AAPL	Stock	7.2032	7.2071	7.1964	7.2	361060.0
2010-02-18 17:30:00	AAPL	Stock	7.1964	7.2507	7.1821	7.1839	492492.0
2010-02-18 18:00:00	AAPL	Stock	7.185	7.2475	7.1839	7.1904	268296.0
2010-02-18 18:30:00	AAPL	Stock	7.1893	7.1911	7.1854	7.1875	102872.0
2010-02-18 19:00:00	AAPL	Stock	7.1875	7.1875	7.1793	7.1821	456400.0
2010-02-18 19:30:00	AAPL	Stock	7.1818	7.1911	7.1818	7.1893	279216.0
2010-02-18 07:30:00	MSFT	Stock	28.59	28.59	28.59	28.59	100.0
2010-02-18 08:00:00	MSFT	Stock	28.56	28.6	28.55	28.58	7300.0
2010-02-18 08:30:00	MSFT	Stock	28.59	28.59	28.48	28.53	22748.0
2010-02-18 09:00:00	MSFT	Stock	28.5	28.64	28.5	28.6	71248.0
2010-02-18 09:30:00	MSFT	Stock	28.59	28.73	28.51	28.69	5031347.0
2010-02-18 10:00:00	MSFT	Stock	28.68	28.75	28.6	28.65	3554659.0
2010-02-18 10:30:00	MSFT	Stock	28.66	28.73	28.62	28.7	2529440.0
2010-02-18 11:00:00	MSFT	Stock	28.7	28.72	28.63	28.67	2344490.0
2010-02-18 11:30:00	MSFT	Stock	28.67	28.71	28.63	28.683	1146421.0
2010-02-18 12:00:00	MSFT	Stock	28.685	28.72	28.63	28.68	1129470.0
2010-02-18 12:30:00	MSFT	Stock	28.685	28.7	28.64	28.66	1458028.0
2010-02-18 13:00:00	MSFT	Stock	28.66	28.72	28.66	28.671	1152274.0
2010-02-18 13:30:00	MSFT	Stock	28.672	28.73	28.67	28.71	1314358.0
2010-02-18 14:00:00	MSFT	Stock	28.72	28.8	28.67	28.795	2654840.0
2010-02-18 14:30:00	MSFT	Stock	28.79	28.96	28.77	28.94	3976929.0
2010-02-18 15:00:00	MSFT	Stock	28.95	28.97	28.905	28.97	5486218.0
2010-02-18 15:30:00	MSFT	Stock	28.965	29.03	28.89	28.97	8597591.0
2010-02-18 16:00:00	MSFT	Stock	28.97	29.09	28.79	29.03	1204725.0
2010-02-18 16:30:00	MSFT	Stock	28.952	29.03	28.58	28.6	118064.0
2010-02-18 17:00:00	MSFT	Stock	28.751	28.77	28.55	28.66	35359.0
2010-02-18 17:30:00	MSFT	Stock	28.67	28.97	28.67	28.73	12799.0
2010-02-18 18:00:00	MSFT	Stock	28.97	28.97	28.7	28.71	5060.0
2010-02-18 18:30:00	MSFT	Stock	28.72	28.75	28.72	28.75	230.0
2010-02-18 19:00:00	MSFT	Stock	28.72	28.72	28.68	28.68	7825.0

> showing 50 of 72,954 rows — these rows as CSV

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