PREVIEW / stock_30min / 2009-06-08

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-08.parquet
  size:    1.3 MB
  rows:    71,920
  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
2009-06-08 04:00:00	AAPL	Stock	5.1429	5.1429	5.1429	5.1429	19600.0
2009-06-08 05:00:00	AAPL	Stock	5.1114	5.1114	5.1114	5.1114	28000.0
2009-06-08 06:30:00	AAPL	Stock	5.1368	5.1368	5.1368	5.1368	8400.0
2009-06-08 07:00:00	AAPL	Stock	5.1311	5.1311	5.1118	5.1182	247212.0
2009-06-08 07:30:00	AAPL	Stock	5.1182	5.1279	5.1139	5.1271	87724.0
2009-06-08 08:00:00	AAPL	Stock	5.125	5.1368	5.1021	5.1057	1018444.0
2009-06-08 08:30:00	AAPL	Stock	5.1071	5.1164	5.1039	5.1136	748888.0
2009-06-08 09:00:00	AAPL	Stock	5.1125	5.1407	5.1107	5.1389	1354920.0
2009-06-08 09:30:00	AAPL	Stock	5.1364	5.1507	5.0407	5.0507	98861392.0
2009-06-08 10:00:00	AAPL	Stock	5.0507	5.0643	5.0382	5.0543	45921372.0
2009-06-08 10:30:00	AAPL	Stock	5.0546	5.0671	5.0414	5.0557	33228748.0
2009-06-08 11:00:00	AAPL	Stock	5.0546	5.0714	5.0486	5.0586	26318376.0
2009-06-08 11:30:00	AAPL	Stock	5.0575	5.0764	5.0464	5.0486	27941368.0
2009-06-08 12:00:00	AAPL	Stock	5.0486	5.0511	5.0382	5.0493	21685944.0
2009-06-08 12:30:00	AAPL	Stock	5.049	5.0589	5.0296	5.0304	36829632.0
2009-06-08 13:00:00	AAPL	Stock	5.0314	5.0518	4.9796	5.0112	118908272.0
2009-06-08 13:30:00	AAPL	Stock	5.0114	5.0389	5.0046	5.0258	45711036.0
2009-06-08 14:00:00	AAPL	Stock	5.0264	5.0375	5.0086	5.0254	33997124.0
2009-06-08 14:30:00	AAPL	Stock	5.0254	5.0518	5.0118	5.0361	79120636.0
2009-06-08 15:00:00	AAPL	Stock	5.0357	5.0993	5.0225	5.0918	189880488.0
2009-06-08 15:30:00	AAPL	Stock	5.0921	5.1511	5.0921	5.1332	144993548.0
2009-06-08 16:00:00	AAPL	Stock	5.1425	5.1446	5.0495	5.1389	16279200.0
2009-06-08 16:30:00	AAPL	Stock	5.1389	5.1393	5.1357	5.1386	856744.0
2009-06-08 17:00:00	AAPL	Stock	5.1386	5.1536	5.1386	5.1471	1461096.0
2009-06-08 17:30:00	AAPL	Stock	5.047	5.1496	5.047	5.1446	164640.0
2009-06-08 18:00:00	AAPL	Stock	5.1439	5.1532	5.1375	5.15	1033200.0
2009-06-08 18:30:00	AAPL	Stock	5.15	5.15	5.1429	5.1475	156576.0
2009-06-08 19:00:00	AAPL	Stock	5.1429	5.1429	5.1375	5.1418	196560.0
2009-06-08 19:30:00	AAPL	Stock	5.1393	5.1432	5.1393	5.1411	95396.0
2009-06-08 04:00:00	MSFT	Stock	21.95	21.95	21.95	21.95	100.0
2009-06-08 07:00:00	MSFT	Stock	21.76	21.76	21.76	21.76	100.0
2009-06-08 07:30:00	MSFT	Stock	21.9	21.9	21.9	21.9	100.0
2009-06-08 08:00:00	MSFT	Stock	21.95	21.95	21.91	21.93	2500.0
2009-06-08 08:30:00	MSFT	Stock	21.94	21.94	21.93	21.93	5591.0
2009-06-08 09:00:00	MSFT	Stock	21.93	21.98	21.93	21.95	7629.0
2009-06-08 09:30:00	MSFT	Stock	21.98	22.0	21.68	21.69	7320319.0
2009-06-08 10:00:00	MSFT	Stock	21.69	21.76	21.63	21.705	3088558.0
2009-06-08 10:30:00	MSFT	Stock	21.7	21.78	21.65	21.7	3118831.0
2009-06-08 11:00:00	MSFT	Stock	21.698	21.74	21.63	21.69	2811983.0
2009-06-08 11:30:00	MSFT	Stock	21.7	21.76	21.655	21.7	2082022.0
2009-06-08 12:00:00	MSFT	Stock	21.7	21.71	21.66	21.66	1054992.0
2009-06-08 12:30:00	MSFT	Stock	21.66	21.74	21.65	21.71	1155513.0
2009-06-08 13:00:00	MSFT	Stock	21.72	21.77	21.71	21.74	853655.0
2009-06-08 13:30:00	MSFT	Stock	21.745	21.8	21.7	21.77	1376052.0
2009-06-08 14:00:00	MSFT	Stock	21.78	21.84	21.73	21.838	1822779.0
2009-06-08 14:30:00	MSFT	Stock	21.84	21.87	21.74	21.852	3233995.0
2009-06-08 15:00:00	MSFT	Stock	21.85	22.12	21.83	22.1	7034322.0
2009-06-08 15:30:00	MSFT	Stock	22.11	22.32	22.06	22.06	10179672.0
2009-06-08 16:00:00	MSFT	Stock	22.05	22.123	21.691	22.05	2158506.0
2009-06-08 16:30:00	MSFT	Stock	22.11	22.11	21.8	22.05	40750.0

> showing 50 of 71,920 rows — these rows as CSV

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