PREVIEW / stock_30min / 2008-06-12

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-12.parquet
  size:    1.2 MB
  rows:    68,355
  symbols: 3,306

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-06-12 05:00:00	AAPL	Stock	6.4911	6.4911	6.4821	6.4821	8400.0
2008-06-12 06:00:00	AAPL	Stock	6.4811	6.4811	6.4589	6.4589	61600.0
2008-06-12 06:30:00	AAPL	Stock	6.4679	6.475	6.4668	6.475	61600.0
2008-06-12 07:00:00	AAPL	Stock	6.4914	6.5357	6.4911	6.5179	885528.0
2008-06-12 07:30:00	AAPL	Stock	6.5179	6.5304	6.5029	6.5304	223440.0
2008-06-12 08:00:00	AAPL	Stock	6.5243	6.5243	6.4964	6.5036	2037700.0
2008-06-12 08:30:00	AAPL	Stock	6.5064	6.525	6.4821	6.5	2500932.0
2008-06-12 09:00:00	AAPL	Stock	6.5021	6.5064	6.4775	6.4821	2014432.0
2008-06-12 09:30:00	AAPL	Stock	6.4821	6.5214	6.4429	6.4589	119808556.0
2008-06-12 10:00:00	AAPL	Stock	6.4589	6.4704	6.2536	6.3036	197520344.0
2008-06-12 10:30:00	AAPL	Stock	6.3021	6.3361	6.2554	6.3118	118417432.0
2008-06-12 11:00:00	AAPL	Stock	6.3118	6.3393	6.2818	6.3088	88049192.0
2008-06-12 11:30:00	AAPL	Stock	6.3089	6.345	6.2654	6.285	62955340.0
2008-06-12 12:00:00	AAPL	Stock	6.2846	6.3168	6.2839	6.3	39201064.0
2008-06-12 12:30:00	AAPL	Stock	6.3	6.3121	6.2561	6.2625	52776696.0
2008-06-12 13:00:00	AAPL	Stock	6.2625	6.275	6.225	6.2508	87561544.0
2008-06-12 13:30:00	AAPL	Stock	6.2514	6.2593	6.2164	6.2439	57098804.0
2008-06-12 14:00:00	AAPL	Stock	6.2432	6.2554	6.1996	6.21	69983088.0
2008-06-12 14:30:00	AAPL	Stock	6.21	6.2282	6.1143	6.1839	115588872.0
2008-06-12 15:00:00	AAPL	Stock	6.1839	6.1911	6.1254	6.1571	91407092.0
2008-06-12 15:30:00	AAPL	Stock	6.1561	6.1964	6.1257	6.1711	112093408.0
2008-06-12 16:00:00	AAPL	Stock	6.1711	6.38	6.1695	6.1757	16987992.0
2008-06-12 16:30:00	AAPL	Stock	6.1606	6.1804	6.1606	6.1714	5182184.0
2008-06-12 17:00:00	AAPL	Stock	6.1732	6.1879	6.1529	6.1536	803796.0
2008-06-12 17:30:00	AAPL	Stock	6.1525	6.1529	6.1339	6.1425	832132.0
2008-06-12 18:00:00	AAPL	Stock	6.1429	6.1536	6.1357	6.1464	270340.0
2008-06-12 18:30:00	AAPL	Stock	6.1468	6.1521	6.1429	6.1507	178864.0
2008-06-12 19:00:00	AAPL	Stock	6.1454	6.1507	6.145	6.1507	286384.0
2008-06-12 19:30:00	AAPL	Stock	6.1507	6.1514	6.1411	6.1411	342832.0
2008-06-12 07:30:00	MSFT	Stock	27.34	27.34	27.34	27.34	600.0
2008-06-12 08:00:00	MSFT	Stock	27.3	27.39	27.28	27.3	44571.0
2008-06-12 08:30:00	MSFT	Stock	27.33	27.36	27.3	27.33	29998.0
2008-06-12 09:00:00	MSFT	Stock	27.35	27.41	27.3	27.4	79421.0
2008-06-12 09:30:00	MSFT	Stock	27.4	27.58	27.36	27.44	5696916.0
2008-06-12 10:00:00	MSFT	Stock	27.45	27.55	27.26	27.37	4430944.0
2008-06-12 10:30:00	MSFT	Stock	27.37	27.49	27.37	27.49	4342026.0
2008-06-12 11:00:00	MSFT	Stock	27.48	27.55	27.35	27.37	3616239.0
2008-06-12 11:30:00	MSFT	Stock	27.37	27.39	27.29	27.33	2235278.0
2008-06-12 12:00:00	MSFT	Stock	27.32	27.45	27.32	27.44	1954798.0
2008-06-12 12:30:00	MSFT	Stock	27.43	27.45	27.24	27.25	2154483.0
2008-06-12 13:00:00	MSFT	Stock	27.25	27.32	27.2	27.28	2233807.0
2008-06-12 13:30:00	MSFT	Stock	27.28	27.32	27.19	27.27	4168571.0
2008-06-12 14:00:00	MSFT	Stock	27.27	27.5	27.23	27.4	8109011.0
2008-06-12 14:30:00	MSFT	Stock	27.4	27.87	27.35	27.85	19190672.0
2008-06-12 15:00:00	MSFT	Stock	27.85	28.55	27.75	27.99	27519828.0
2008-06-12 15:30:00	MSFT	Stock	27.99	28.45	27.88	28.26	21932668.0
2008-06-12 16:00:00	MSFT	Stock	28.28	28.38	27.305	28.31	3393587.0
2008-06-12 16:30:00	MSFT	Stock	28.33	28.35	27.56	28.32	381086.0
2008-06-12 17:00:00	MSFT	Stock	28.32	28.42	28.24	28.32	142506.0
2008-06-12 17:30:00	MSFT	Stock	28.32	28.32	28.28	28.3	25190.0

> showing 50 of 68,355 rows — these rows as CSV

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