PREVIEW / stock_30min / 2008-07-02

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-07-02.parquet
  size:    1.3 MB
  rows:    69,866
  symbols: 3,333

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
2008-07-02 07:00:00	AAPL	Stock	6.2768	6.2821	6.2679	6.2821	45556.0
2008-07-02 07:30:00	AAPL	Stock	6.2786	6.2786	6.2643	6.2729	178136.0
2008-07-02 08:00:00	AAPL	Stock	6.2679	6.2775	6.2446	6.2607	2271276.0
2008-07-02 08:30:00	AAPL	Stock	6.2607	6.2711	6.2429	6.2611	1160208.0
2008-07-02 09:00:00	AAPL	Stock	6.2611	6.2679	6.2518	6.2536	1184624.0
2008-07-02 09:30:00	AAPL	Stock	6.2557	6.3375	6.2368	6.2918	120522304.0
2008-07-02 10:00:00	AAPL	Stock	6.2911	6.3104	6.2143	6.2171	85397620.0
2008-07-02 10:30:00	AAPL	Stock	6.2182	6.2418	6.1771	6.2332	73531836.0
2008-07-02 11:00:00	AAPL	Stock	6.2336	6.2679	6.1964	6.2461	69700428.0
2008-07-02 11:30:00	AAPL	Stock	6.2463	6.2536	6.1346	6.1743	64362788.0
2008-07-02 12:00:00	AAPL	Stock	6.1741	6.2321	6.1443	6.1614	43755096.0
2008-07-02 12:30:00	AAPL	Stock	6.1618	6.1754	6.1314	6.1482	41655376.0
2008-07-02 13:00:00	AAPL	Stock	6.1482	6.1786	6.1132	6.1661	38005520.0
2008-07-02 13:30:00	AAPL	Stock	6.1664	6.1996	6.1468	6.1968	35600152.0
2008-07-02 14:00:00	AAPL	Stock	6.1975	6.2004	6.1396	6.1443	39209716.0
2008-07-02 14:30:00	AAPL	Stock	6.1443	6.1607	6.1018	6.125	46871524.0
2008-07-02 15:00:00	AAPL	Stock	6.1239	6.1343	6.0907	6.0932	53297272.0
2008-07-02 15:30:00	AAPL	Stock	6.0936	6.1018	6.0064	6.0069	90009584.0
2008-07-02 16:00:00	AAPL	Stock	6.0064	6.1893	6.0064	6.0157	10660272.0
2008-07-02 16:30:00	AAPL	Stock	6.0154	6.0204	6.0064	6.0068	387828.0
2008-07-02 17:00:00	AAPL	Stock	6.0071	6.0107	5.9554	5.9804	5770240.0
2008-07-02 17:30:00	AAPL	Stock	5.9818	5.9829	5.9643	5.9714	124320.0
2008-07-02 18:00:00	AAPL	Stock	5.9714	5.9732	5.9571	5.9571	187152.0
2008-07-02 18:30:00	AAPL	Stock	5.9643	5.9732	5.9471	5.9696	348628.0
2008-07-02 19:00:00	AAPL	Stock	5.9696	5.975	5.9654	5.9664	69160.0
2008-07-02 19:30:00	AAPL	Stock	5.9668	5.9714	5.9554	5.9675	415100.0
2008-07-02 20:00:00	AAPL	Stock	6.1461	6.1461	6.1461	6.1461	56000.0
2008-07-02 05:30:00	MSFT	Stock	26.89	26.89	26.89	26.89	100.0
2008-07-02 07:00:00	MSFT	Stock	26.89	26.89	26.89	26.89	300.0
2008-07-02 07:30:00	MSFT	Stock	26.9	27.08	26.9	27.01	589.0
2008-07-02 08:00:00	MSFT	Stock	27.03	27.09	27.02	27.06	12630.0
2008-07-02 08:30:00	MSFT	Stock	27.06	27.06	26.99	27.01	12363.0
2008-07-02 09:00:00	MSFT	Stock	27.02	27.07	26.85	26.9	115124.0
2008-07-02 09:30:00	MSFT	Stock	26.91	27.0	26.86	26.9	5527967.0
2008-07-02 10:00:00	MSFT	Stock	26.91	26.96	26.72	26.75	4741811.0
2008-07-02 10:30:00	MSFT	Stock	26.75	26.81	26.65	26.66	5270139.0
2008-07-02 11:00:00	MSFT	Stock	26.66	26.68	26.43	26.45	7197428.0
2008-07-02 11:30:00	MSFT	Stock	26.45	26.51	26.28	26.34	5899877.0
2008-07-02 12:00:00	MSFT	Stock	26.34	26.48	26.32	26.388	3783776.0
2008-07-02 12:30:00	MSFT	Stock	26.382	26.43	26.29	26.34	3206879.0
2008-07-02 13:00:00	MSFT	Stock	26.34	26.45	26.27	26.44	3481826.0
2008-07-02 13:30:00	MSFT	Stock	26.44	26.62	26.43	26.572	6050866.0
2008-07-02 14:00:00	MSFT	Stock	26.58	26.6	26.3	26.3	3908324.0
2008-07-02 14:30:00	MSFT	Stock	26.3	26.39	26.23	26.24	5316749.0
2008-07-02 15:00:00	MSFT	Stock	26.23	26.33	26.16	26.16	7635284.0
2008-07-02 15:30:00	MSFT	Stock	26.16	26.24	25.89	25.89	17853465.0
2008-07-02 16:00:00	MSFT	Stock	25.89	26.478	25.835	25.91	2910365.0
2008-07-02 16:30:00	MSFT	Stock	25.91	25.92	25.8	25.81	28091.0
2008-07-02 17:00:00	MSFT	Stock	25.85	25.9	25.7	25.7	595041.0
2008-07-02 17:30:00	MSFT	Stock	25.69	25.77	25.68	25.7	50554.0

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

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