PREVIEW / stock_30min / 2008-07-16

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-07-16.parquet
  size:    1.3 MB
  rows:    69,619
  symbols: 3,356

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-16 06:00:00	AAPL	Stock	6.0736	6.0736	6.0736	6.0736	13692.0
2008-07-16 06:30:00	AAPL	Stock	6.0039	6.0039	6.0039	6.0039	5600.0
2008-07-16 07:00:00	AAPL	Stock	6.005	6.0446	6.005	6.0446	19600.0
2008-07-16 07:30:00	AAPL	Stock	6.0539	6.0786	6.0539	6.0786	91700.0
2008-07-16 08:00:00	AAPL	Stock	6.0714	6.1225	6.0711	6.1071	1130528.0
2008-07-16 08:30:00	AAPL	Stock	6.1075	6.1075	6.0714	6.1	2078048.0
2008-07-16 09:00:00	AAPL	Stock	6.1018	6.1143	6.0714	6.0761	2012528.0
2008-07-16 09:30:00	AAPL	Stock	6.0786	6.1071	6.0214	6.0782	105304332.0
2008-07-16 10:00:00	AAPL	Stock	6.0786	6.1143	6.0536	6.0761	58929640.0
2008-07-16 10:30:00	AAPL	Stock	6.0758	6.1354	6.0682	6.0889	70533484.0
2008-07-16 11:00:00	AAPL	Stock	6.0879	6.1175	6.045	6.0629	62603324.0
2008-07-16 11:30:00	AAPL	Stock	6.0629	6.0993	6.0543	6.0811	42497112.0
2008-07-16 12:00:00	AAPL	Stock	6.0816	6.0939	6.045	6.0843	39376960.0
2008-07-16 12:30:00	AAPL	Stock	6.0832	6.1021	6.0629	6.1011	35579544.0
2008-07-16 13:00:00	AAPL	Stock	6.1014	6.1071	6.0668	6.0879	44173192.0
2008-07-16 13:30:00	AAPL	Stock	6.0879	6.1089	6.0793	6.0986	30231208.0
2008-07-16 14:00:00	AAPL	Stock	6.0995	6.1421	6.0761	6.1207	63634340.0
2008-07-16 14:30:00	AAPL	Stock	6.1196	6.1607	6.1057	6.1564	52840312.0
2008-07-16 15:00:00	AAPL	Stock	6.1571	6.1761	6.1382	6.1686	49273504.0
2008-07-16 15:30:00	AAPL	Stock	6.1686	6.1743	6.1479	6.1689	57720964.0
2008-07-16 16:00:00	AAPL	Stock	6.1689	6.1718	6.0586	6.1464	16907744.0
2008-07-16 16:30:00	AAPL	Stock	6.1429	6.1718	6.1429	6.1536	739564.0
2008-07-16 17:00:00	AAPL	Stock	6.1589	6.1723	6.1496	6.1536	95144.0
2008-07-16 17:30:00	AAPL	Stock	6.1554	6.1582	6.1479	6.1582	58240.0
2008-07-16 18:00:00	AAPL	Stock	6.1586	6.16	6.15	6.15	66080.0
2008-07-16 18:30:00	AAPL	Stock	6.1589	6.1607	6.1536	6.1554	57484.0
2008-07-16 19:00:00	AAPL	Stock	6.1604	6.1607	6.1504	6.1504	43960.0
2008-07-16 19:30:00	AAPL	Stock	6.1554	6.1571	6.1546	6.1571	63448.0
2008-07-16 20:00:00	AAPL	Stock	6.0746	6.0746	6.0746	6.0746	53200.0
2008-07-16 07:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	200.0
2008-07-16 08:00:00	MSFT	Stock	26.14	26.38	26.14	26.33	8215.0
2008-07-16 08:30:00	MSFT	Stock	26.33	26.33	26.17	26.3	5515.0
2008-07-16 09:00:00	MSFT	Stock	26.33	26.35	26.01	26.13	88585.0
2008-07-16 09:30:00	MSFT	Stock	26.14	26.36	26.07	26.31	7811176.0
2008-07-16 10:00:00	MSFT	Stock	26.31	26.34	25.92	26.12	5793359.0
2008-07-16 10:30:00	MSFT	Stock	26.12	26.48	26.11	26.46	5861306.0
2008-07-16 11:00:00	MSFT	Stock	26.46	26.63	26.33	26.45	5274106.0
2008-07-16 11:30:00	MSFT	Stock	26.45	26.54	26.43	26.46	2377564.0
2008-07-16 12:00:00	MSFT	Stock	26.47	26.58	26.41	26.57	2678806.0
2008-07-16 12:30:00	MSFT	Stock	26.57	26.67	26.56	26.65	3066943.0
2008-07-16 13:00:00	MSFT	Stock	26.65	26.99	26.64	26.938	5435615.0
2008-07-16 13:30:00	MSFT	Stock	26.93	27.04	26.89	27.04	4860996.0
2008-07-16 14:00:00	MSFT	Stock	27.04	27.16	26.95	27.095	7400790.0
2008-07-16 14:30:00	MSFT	Stock	27.092	27.25	27.09	27.18	6128104.0
2008-07-16 15:00:00	MSFT	Stock	27.17	27.27	27.105	27.15	5422895.0
2008-07-16 15:30:00	MSFT	Stock	27.15	27.29	27.11	27.28	10920718.0
2008-07-16 16:00:00	MSFT	Stock	27.26	27.28	26.15	27.25	5886271.0
2008-07-16 16:30:00	MSFT	Stock	27.2	27.25	27.11	27.15	17848.0
2008-07-16 17:00:00	MSFT	Stock	26.698	27.265	26.698	27.2	31742.0
2008-07-16 17:30:00	MSFT	Stock	27.19	27.32	27.11	27.32	8079.0

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

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