PREVIEW / stock_30min / 2009-06-04

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-04.parquet
  size:    1.3 MB
  rows:    72,470
  symbols: 3,347

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-06-04 05:30:00	AAPL	Stock	5.0786	5.0786	5.0786	5.0786	2800.0
2009-06-04 06:00:00	AAPL	Stock	5.0232	5.0321	5.0232	5.0321	31500.0
2009-06-04 07:00:00	AAPL	Stock	5.0357	5.0357	5.0089	5.0161	289632.0
2009-06-04 07:30:00	AAPL	Stock	5.0161	5.0275	5.0107	5.0143	174244.0
2009-06-04 08:00:00	AAPL	Stock	5.0179	5.0268	5.0032	5.0161	1315860.0
2009-06-04 08:30:00	AAPL	Stock	5.0189	5.0296	5.0043	5.0089	1748852.0
2009-06-04 09:00:00	AAPL	Stock	5.0089	5.0339	4.9946	5.005	2951704.0
2009-06-04 09:30:00	AAPL	Stock	5.0046	5.1121	5.0014	5.1079	117505528.0
2009-06-04 10:00:00	AAPL	Stock	5.1079	5.1286	5.0989	5.1086	74240516.0
2009-06-04 10:30:00	AAPL	Stock	5.1086	5.1204	5.1007	5.1171	36512728.0
2009-06-04 11:00:00	AAPL	Stock	5.1164	5.1225	5.0893	5.1136	25490584.0
2009-06-04 11:30:00	AAPL	Stock	5.1143	5.1307	5.1118	5.1194	23847320.0
2009-06-04 12:00:00	AAPL	Stock	5.12	5.1239	5.105	5.1207	20395648.0
2009-06-04 12:30:00	AAPL	Stock	5.1211	5.1321	5.1186	5.1302	17758804.0
2009-06-04 13:00:00	AAPL	Stock	5.1304	5.1357	5.1257	5.1321	20516636.0
2009-06-04 13:30:00	AAPL	Stock	5.1321	5.14	5.1221	5.1296	26913460.0
2009-06-04 14:00:00	AAPL	Stock	5.13	5.1329	5.1229	5.124	22274336.0
2009-06-04 14:30:00	AAPL	Stock	5.1246	5.1304	5.1154	5.1254	23431464.0
2009-06-04 15:00:00	AAPL	Stock	5.1254	5.1493	5.1182	5.1457	35342412.0
2009-06-04 15:30:00	AAPL	Stock	5.1454	5.1457	5.1221	5.1311	67498508.0
2009-06-04 16:00:00	AAPL	Stock	5.1311	5.1446	5.1027	5.1336	17686312.0
2009-06-04 16:30:00	AAPL	Stock	5.1336	5.1414	5.1106	5.1357	2403912.0
2009-06-04 17:00:00	AAPL	Stock	5.1332	5.1429	5.1332	5.1393	338688.0
2009-06-04 17:30:00	AAPL	Stock	5.1389	5.1425	5.1371	5.14	58128.0
2009-06-04 18:00:00	AAPL	Stock	5.14	5.1404	5.1336	5.1382	490644.0
2009-06-04 18:30:00	AAPL	Stock	5.1404	5.1407	5.1361	5.14	58100.0
2009-06-04 19:00:00	AAPL	Stock	5.1382	5.1382	5.1382	5.1382	50400.0
2009-06-04 19:30:00	AAPL	Stock	5.1411	5.2375	5.1411	5.2232	3459652.0
2009-06-04 07:00:00	MSFT	Stock	21.9	21.9	21.9	21.9	100.0
2009-06-04 07:30:00	MSFT	Stock	21.9	21.9	21.9	21.9	300.0
2009-06-04 08:00:00	MSFT	Stock	21.76	21.82	21.7	21.77	22295.0
2009-06-04 08:30:00	MSFT	Stock	21.82	21.85	21.8	21.85	27050.0
2009-06-04 09:00:00	MSFT	Stock	21.85	21.86	21.76	21.76	9849.0
2009-06-04 09:30:00	MSFT	Stock	21.75	21.9	21.73	21.78	3679414.0
2009-06-04 10:00:00	MSFT	Stock	21.79	21.79	21.58	21.73	3981348.0
2009-06-04 10:30:00	MSFT	Stock	21.73	21.85	21.69	21.79	2920196.0
2009-06-04 11:00:00	MSFT	Stock	21.79	21.8	21.7	21.71	2267303.0
2009-06-04 11:30:00	MSFT	Stock	21.71	21.75	21.69	21.705	1788526.0
2009-06-04 12:00:00	MSFT	Stock	21.717	21.74	21.67	21.69	2613249.0
2009-06-04 12:30:00	MSFT	Stock	21.69	21.72	21.63	21.63	1629185.0
2009-06-04 13:00:00	MSFT	Stock	21.64	21.75	21.63	21.725	1544044.0
2009-06-04 13:30:00	MSFT	Stock	21.725	21.82	21.71	21.72	2122928.0
2009-06-04 14:00:00	MSFT	Stock	21.71	21.79	21.71	21.76	1695442.0
2009-06-04 14:30:00	MSFT	Stock	21.76	21.82	21.72	21.77	2022011.0
2009-06-04 15:00:00	MSFT	Stock	21.77	21.87	21.72	21.84	3553776.0
2009-06-04 15:30:00	MSFT	Stock	21.834	21.87	21.77	21.81	5801183.0
2009-06-04 16:00:00	MSFT	Stock	21.82	21.86	21.675	21.83	3698160.0
2009-06-04 16:30:00	MSFT	Stock	21.83	21.833	21.764	21.83	718885.0
2009-06-04 17:00:00	MSFT	Stock	21.83	21.84	21.83	21.83	11152.0
2009-06-04 18:00:00	MSFT	Stock	21.79	21.79	21.79	21.79	1000.0

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

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