PREVIEW / stock_30min / 2007-03-08

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-08.parquet
  size:    1.0 MB
  rows:    55,533
  symbols: 2,515

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
2007-03-08 04:00:00	AAPL	Stock	3.1593	3.1593	3.1593	3.1593	2800.0
2007-03-08 04:30:00	AAPL	Stock	3.1554	3.1646	3.1554	3.1571	11200.0
2007-03-08 06:30:00	AAPL	Stock	3.1643	3.1643	3.1643	3.1643	14000.0
2007-03-08 07:00:00	AAPL	Stock	3.1682	3.1682	3.1679	3.1682	109060.0
2007-03-08 07:30:00	AAPL	Stock	3.1682	3.1746	3.1646	3.1746	173740.0
2007-03-08 08:00:00	AAPL	Stock	3.1686	3.175	3.1657	3.1696	1929928.0
2007-03-08 08:30:00	AAPL	Stock	3.1696	3.1714	3.1611	3.1643	1422204.0
2007-03-08 09:00:00	AAPL	Stock	3.1643	3.1682	3.1618	3.1643	1838984.0
2007-03-08 09:30:00	AAPL	Stock	3.1639	3.1686	3.1482	3.15	82167064.0
2007-03-08 10:00:00	AAPL	Stock	3.1496	3.1593	3.1471	3.1564	46406164.0
2007-03-08 10:30:00	AAPL	Stock	3.1561	3.1564	3.1429	3.1479	45324468.0
2007-03-08 11:00:00	AAPL	Stock	3.1475	3.1532	3.1414	3.1496	31558100.0
2007-03-08 11:30:00	AAPL	Stock	3.1496	3.1546	3.1464	3.15	25427892.0
2007-03-08 12:00:00	AAPL	Stock	3.1504	3.1539	3.1446	3.1457	21906276.0
2007-03-08 12:30:00	AAPL	Stock	3.1457	3.1496	3.1382	3.1432	24499524.0
2007-03-08 13:00:00	AAPL	Stock	3.1432	3.1525	3.1396	3.1504	20872320.0
2007-03-08 13:30:00	AAPL	Stock	3.1504	3.1564	3.1479	3.15	19696712.0
2007-03-08 14:00:00	AAPL	Stock	3.15	3.1511	3.1389	3.1393	33194280.0
2007-03-08 14:30:00	AAPL	Stock	3.1393	3.1396	3.1236	3.1354	67000024.0
2007-03-08 15:00:00	AAPL	Stock	3.1354	3.1382	3.1299	3.1346	29102500.0
2007-03-08 15:30:00	AAPL	Stock	3.1343	3.1429	3.1332	3.1414	45487008.0
2007-03-08 16:00:00	AAPL	Stock	3.1429	3.1464	3.1389	3.1429	3506412.0
2007-03-08 16:30:00	AAPL	Stock	3.1429	3.1461	3.1429	3.145	255780.0
2007-03-08 17:00:00	AAPL	Stock	3.1446	3.1479	3.1446	3.1479	49224.0
2007-03-08 17:30:00	AAPL	Stock	3.1479	3.1482	3.1464	3.1482	137172.0
2007-03-08 18:00:00	AAPL	Stock	3.1493	3.1493	3.1493	3.1493	25200.0
2007-03-08 18:30:00	AAPL	Stock	3.1486	3.1511	3.1482	3.1511	185976.0
2007-03-08 19:00:00	AAPL	Stock	3.1493	3.1493	3.1482	3.1482	15652.0
2007-03-08 19:30:00	AAPL	Stock	3.1496	3.1504	3.1482	3.1504	171864.0
2007-03-08 04:30:00	MSFT	Stock	27.75	27.79	27.75	27.79	1800.0
2007-03-08 05:00:00	MSFT	Stock	27.79	27.79	27.79	27.79	2300.0
2007-03-08 06:30:00	MSFT	Stock	27.79	27.79	27.79	27.79	100.0
2007-03-08 07:00:00	MSFT	Stock	27.79	27.9	27.79	27.9	3600.0
2007-03-08 07:30:00	MSFT	Stock	27.87	27.87	27.87	27.87	4000.0
2007-03-08 08:00:00	MSFT	Stock	27.87	27.87	27.77	27.8	45540.0
2007-03-08 08:30:00	MSFT	Stock	27.8	27.8	27.76	27.79	17050.0
2007-03-08 09:00:00	MSFT	Stock	27.8	27.82	27.73	27.74	54071.0
2007-03-08 09:30:00	MSFT	Stock	27.72	27.82	27.66	27.7	6548096.0
2007-03-08 10:00:00	MSFT	Stock	27.7	27.85	27.68	27.81	5746428.0
2007-03-08 10:30:00	MSFT	Stock	27.81	27.83	27.72	27.74	3158778.0
2007-03-08 11:00:00	MSFT	Stock	27.74	27.75	27.66	27.67	3508028.0
2007-03-08 11:30:00	MSFT	Stock	27.66	27.75	27.66	27.7	4024319.0
2007-03-08 12:00:00	MSFT	Stock	27.7	27.7	27.64	27.65	2614784.0
2007-03-08 12:30:00	MSFT	Stock	27.65	27.66	27.59	27.59	5111250.0
2007-03-08 13:00:00	MSFT	Stock	27.59	27.6	27.53	27.53	5412689.0
2007-03-08 13:30:00	MSFT	Stock	27.53	27.69	27.52	27.54	3044175.0
2007-03-08 14:00:00	MSFT	Stock	27.54	27.55	27.35	27.35	6227994.0
2007-03-08 14:30:00	MSFT	Stock	27.35	27.38	27.21	27.3	8667934.0
2007-03-08 15:00:00	MSFT	Stock	27.3	27.37	27.29	27.33	4883468.0
2007-03-08 15:30:00	MSFT	Stock	27.34	27.39	27.27	27.34	9701837.0

> showing 50 of 55,533 rows — these rows as CSV

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