PREVIEW / stock_30min / 2008-11-18

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-18.parquet
  size:    1.2 MB
  rows:    69,535
  symbols: 3,329

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-11-18 06:30:00	AAPL	Stock	3.11	3.11	3.0925	3.0925	8400.0
2008-11-18 07:00:00	AAPL	Stock	3.1286	3.1289	3.1271	3.1271	19600.0
2008-11-18 07:30:00	AAPL	Stock	3.1264	3.1368	3.1264	3.1364	170464.0
2008-11-18 08:00:00	AAPL	Stock	3.1357	3.2407	3.1339	3.2279	3144260.0
2008-11-18 08:30:00	AAPL	Stock	3.2268	3.2536	3.2143	3.2204	3406396.0
2008-11-18 09:00:00	AAPL	Stock	3.2239	3.2239	3.1993	3.2018	3000088.0
2008-11-18 09:30:00	AAPL	Stock	3.2043	3.2496	3.1643	3.1775	147490924.0
2008-11-18 10:00:00	AAPL	Stock	3.1779	3.2275	3.1579	3.2274	123204536.0
2008-11-18 10:30:00	AAPL	Stock	3.2268	3.2311	3.2011	3.2104	83994344.0
2008-11-18 11:00:00	AAPL	Stock	3.2104	3.2104	3.1786	3.1886	57758092.0
2008-11-18 11:30:00	AAPL	Stock	3.1889	3.2232	3.1885	3.2204	68101908.0
2008-11-18 12:00:00	AAPL	Stock	3.2204	3.2304	3.1964	3.2032	48265028.0
2008-11-18 12:30:00	AAPL	Stock	3.2032	3.2043	3.1686	3.1811	52790276.0
2008-11-18 13:00:00	AAPL	Stock	3.1825	3.1825	3.1343	3.1554	70591500.0
2008-11-18 13:30:00	AAPL	Stock	3.1557	3.1589	3.1186	3.1471	77218568.0
2008-11-18 14:00:00	AAPL	Stock	3.1471	3.1689	3.1257	3.1629	75534424.0
2008-11-18 14:30:00	AAPL	Stock	3.1629	3.1632	3.1021	3.115	79000656.0
2008-11-18 15:00:00	AAPL	Stock	3.115	3.1843	3.1096	3.1711	112954352.0
2008-11-18 15:30:00	AAPL	Stock	3.1711	3.2139	3.1346	3.2118	147807716.0
2008-11-18 16:00:00	AAPL	Stock	3.2143	3.2332	3.1396	3.2186	38162768.0
2008-11-18 16:30:00	AAPL	Stock	3.2164	3.2193	3.2036	3.2114	6302464.0
2008-11-18 17:00:00	AAPL	Stock	3.2089	3.2125	3.2082	3.2125	663544.0
2008-11-18 17:30:00	AAPL	Stock	3.2136	3.2139	3.2093	3.2139	134876.0
2008-11-18 18:00:00	AAPL	Stock	3.2118	3.2118	3.2096	3.2107	455728.0
2008-11-18 18:30:00	AAPL	Stock	3.2107	3.2114	3.2075	3.2075	169736.0
2008-11-18 19:00:00	AAPL	Stock	3.2054	3.2071	3.1982	3.1982	234304.0
2008-11-18 19:30:00	AAPL	Stock	3.1982	3.2032	3.1964	3.1964	197400.0
2008-11-18 07:00:00	MSFT	Stock	19.17	19.2	19.16	19.2	800.0
2008-11-18 08:00:00	MSFT	Stock	19.23	19.81	19.14	19.72	74522.0
2008-11-18 08:30:00	MSFT	Stock	19.72	19.83	19.68	19.74	74047.0
2008-11-18 09:00:00	MSFT	Stock	19.74	19.74	19.45	19.49	122596.0
2008-11-18 09:30:00	MSFT	Stock	19.49	19.57	19.21	19.3	7974918.0
2008-11-18 10:00:00	MSFT	Stock	19.3	19.4	19.09	19.4	7857458.0
2008-11-18 10:30:00	MSFT	Stock	19.4	19.56	19.34	19.45	5967886.0
2008-11-18 11:00:00	MSFT	Stock	19.45	19.45	19.19	19.25	5659906.0
2008-11-18 11:30:00	MSFT	Stock	19.245	19.51	19.22	19.51	4529874.0
2008-11-18 12:00:00	MSFT	Stock	19.51	19.54	19.39	19.475	4486481.0
2008-11-18 12:30:00	MSFT	Stock	19.47	19.47	19.23	19.24	4031364.0
2008-11-18 13:00:00	MSFT	Stock	19.24	19.24	18.96	19.02	5231287.0
2008-11-18 13:30:00	MSFT	Stock	19.01	19.02	18.76	18.9	7412043.0
2008-11-18 14:00:00	MSFT	Stock	18.9	19.01	18.75	18.932	7779607.0
2008-11-18 14:30:00	MSFT	Stock	18.94	19.06	18.78	18.87	8219398.0
2008-11-18 15:00:00	MSFT	Stock	18.87	19.36	18.84	19.228	9547738.0
2008-11-18 15:30:00	MSFT	Stock	19.22	19.66	19.0	19.6	18999710.0
2008-11-18 16:00:00	MSFT	Stock	19.6	19.8	18.871	19.62	7791065.0
2008-11-18 16:30:00	MSFT	Stock	19.58	19.71	19.161	19.6	1250214.0
2008-11-18 17:00:00	MSFT	Stock	19.58	19.62	19.52	19.62	178947.0
2008-11-18 17:30:00	MSFT	Stock	19.58	19.62	19.51	19.52	34986.0
2008-11-18 18:00:00	MSFT	Stock	19.62	19.62	19.51	19.51	185752.0
2008-11-18 18:30:00	MSFT	Stock	19.51	19.55	19.51	19.55	5100.0

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

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