PREVIEW / stock_30min / 2010-10-21

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-21.parquet
  size:    1.4 MB
  rows:    75,245
  symbols: 3,488

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
2010-10-21 04:00:00	AAPL	Stock	11.1607	11.1607	11.1607	11.1607	2800.0
2010-10-21 04:30:00	AAPL	Stock	11.1786	11.1875	11.1786	11.1875	5600.0
2010-10-21 05:00:00	AAPL	Stock	11.1525	11.1546	11.1525	11.1546	19600.0
2010-10-21 05:30:00	AAPL	Stock	11.145	11.145	11.145	11.145	8400.0
2010-10-21 06:00:00	AAPL	Stock	11.1429	11.1464	11.1429	11.1429	23744.0
2010-10-21 06:30:00	AAPL	Stock	11.15	11.1604	11.15	11.1604	25200.0
2010-10-21 07:00:00	AAPL	Stock	11.1604	11.1804	11.1504	11.1504	162792.0
2010-10-21 07:30:00	AAPL	Stock	11.1746	11.2143	11.1746	11.1957	692440.0
2010-10-21 08:00:00	AAPL	Stock	11.1711	11.1868	11.1475	11.1721	2214800.0
2010-10-21 08:30:00	AAPL	Stock	11.1664	11.1893	11.0904	11.1843	3370388.0
2010-10-21 09:00:00	AAPL	Stock	11.1843	11.1854	11.1554	11.1561	1180172.0
2010-10-21 09:30:00	AAPL	Stock	11.1564	11.2407	11.1114	11.2039	93159276.0
2010-10-21 10:00:00	AAPL	Stock	11.1996	11.225	11.1643	11.1839	58961140.0
2010-10-21 10:30:00	AAPL	Stock	11.1843	11.195	11.1557	11.1732	30810472.0
2010-10-21 11:00:00	AAPL	Stock	11.1726	11.1896	11.1229	11.1342	38603516.0
2010-10-21 11:30:00	AAPL	Stock	11.1336	11.1511	11.0743	11.1093	42084448.0
2010-10-21 12:00:00	AAPL	Stock	11.1089	11.1118	11.0811	11.0961	17730496.0
2010-10-21 12:30:00	AAPL	Stock	11.0943	11.0952	11.0361	11.0786	33022696.0
2010-10-21 13:00:00	AAPL	Stock	11.0786	11.1007	11.0732	11.0786	14352072.0
2010-10-21 13:30:00	AAPL	Stock	11.0793	11.0814	10.9661	10.9787	44543240.0
2010-10-21 14:00:00	AAPL	Stock	10.9811	11.0157	10.9571	10.9986	44146928.0
2010-10-21 14:30:00	AAPL	Stock	10.9986	11.0411	10.9964	11.0369	27453888.0
2010-10-21 15:00:00	AAPL	Stock	11.0382	11.07	11.0179	11.0579	32779572.0
2010-10-21 15:30:00	AAPL	Stock	11.0574	11.0696	11.0214	11.0495	39564448.0
2010-10-21 16:00:00	AAPL	Stock	11.0536	11.104	11.0125	11.0321	12229336.0
2010-10-21 16:30:00	AAPL	Stock	11.0271	11.0571	11.0107	11.0107	305284.0
2010-10-21 17:00:00	AAPL	Stock	11.0157	11.0895	11.0036	11.0736	957572.0
2010-10-21 17:30:00	AAPL	Stock	11.0225	11.0318	11.0179	11.0207	257096.0
2010-10-21 18:00:00	AAPL	Stock	11.0207	11.0543	11.0093	11.015	310856.0
2010-10-21 18:30:00	AAPL	Stock	11.0111	11.0214	11.0054	11.0143	60368.0
2010-10-21 19:00:00	AAPL	Stock	11.0196	11.0196	10.9643	10.9643	928872.0
2010-10-21 19:30:00	AAPL	Stock	10.9643	10.9671	10.9429	10.9557	2356396.0
2010-10-21 04:30:00	MSFT	Stock	25.5	25.5	25.5	25.5	600.0
2010-10-21 07:00:00	MSFT	Stock	25.5	25.75	25.32	25.34	17100.0
2010-10-21 07:30:00	MSFT	Stock	25.4	25.45	25.37	25.37	17200.0
2010-10-21 08:00:00	MSFT	Stock	25.4	25.45	25.3	25.37	37007.0
2010-10-21 08:30:00	MSFT	Stock	25.36	25.45	25.33	25.35	34622.0
2010-10-21 09:00:00	MSFT	Stock	25.36	25.39	25.32	25.36	16334.0
2010-10-21 09:30:00	MSFT	Stock	25.4	25.45	25.26	25.39	5547984.0
2010-10-21 10:00:00	MSFT	Stock	25.39	25.5	25.3	25.47	4801899.0
2010-10-21 10:30:00	MSFT	Stock	25.47	25.54	25.46	25.509	3725038.0
2010-10-21 11:00:00	MSFT	Stock	25.505	25.53	25.375	25.424	2509669.0
2010-10-21 11:30:00	MSFT	Stock	25.421	25.45	25.36	25.415	3038811.0
2010-10-21 12:00:00	MSFT	Stock	25.41	25.44	25.34	25.395	1540426.0
2010-10-21 12:30:00	MSFT	Stock	25.393	25.4	25.3	25.33	1877735.0
2010-10-21 13:00:00	MSFT	Stock	25.325	25.39	25.3	25.36	1889235.0
2010-10-21 13:30:00	MSFT	Stock	25.36	25.37	25.065	25.1	2904921.0
2010-10-21 14:00:00	MSFT	Stock	25.1	25.16	25.05	25.12	2809602.0
2010-10-21 14:30:00	MSFT	Stock	25.12	25.27	25.12	25.26	6242865.0
2010-10-21 15:00:00	MSFT	Stock	25.26	25.39	25.23	25.374	4168596.0

> showing 50 of 75,245 rows — these rows as CSV

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