PREVIEW / stock_30min / 2008-06-23

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-23.parquet
  size:    1.3 MB
  rows:    70,201
  symbols: 3,314

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-23 07:00:00	AAPL	Stock	6.2707	6.2714	6.2707	6.2714	17920.0
2008-06-23 07:30:00	AAPL	Stock	6.2707	6.2732	6.2475	6.2475	302568.0
2008-06-23 08:00:00	AAPL	Stock	6.2564	6.2696	6.2189	6.26	1893164.0
2008-06-23 08:30:00	AAPL	Stock	6.2554	6.2821	6.2539	6.2668	1535072.0
2008-06-23 09:00:00	AAPL	Stock	6.2679	6.2736	6.2357	6.2393	2016952.0
2008-06-23 09:30:00	AAPL	Stock	6.2393	6.25	6.1454	6.1607	116572204.0
2008-06-23 10:00:00	AAPL	Stock	6.1607	6.2207	6.1386	6.2007	66173184.0
2008-06-23 10:30:00	AAPL	Stock	6.2004	6.2282	6.1514	6.1686	44982420.0
2008-06-23 11:00:00	AAPL	Stock	6.1687	6.1786	6.1271	6.1571	42490028.0
2008-06-23 11:30:00	AAPL	Stock	6.1571	6.1782	6.1443	6.1774	39147836.0
2008-06-23 12:00:00	AAPL	Stock	6.1775	6.185	6.1496	6.15	27444816.0
2008-06-23 12:30:00	AAPL	Stock	6.15	6.2007	6.1475	6.1954	24098452.0
2008-06-23 13:00:00	AAPL	Stock	6.1954	6.2161	6.1811	6.2073	26694500.0
2008-06-23 13:30:00	AAPL	Stock	6.2061	6.2661	6.2057	6.2429	44111284.0
2008-06-23 14:00:00	AAPL	Stock	6.2414	6.2736	6.2314	6.2657	47601484.0
2008-06-23 14:30:00	AAPL	Stock	6.265	6.2814	6.2346	6.2561	39164048.0
2008-06-23 15:00:00	AAPL	Stock	6.2564	6.2575	6.1964	6.2146	41535172.0
2008-06-23 15:30:00	AAPL	Stock	6.2146	6.2357	6.1793	6.1843	50835680.0
2008-06-23 16:00:00	AAPL	Stock	6.1843	6.2083	6.1768	6.1768	7068152.0
2008-06-23 16:30:00	AAPL	Stock	6.1768	6.1843	6.1679	6.1843	1049412.0
2008-06-23 17:00:00	AAPL	Stock	6.1725	6.1739	6.1686	6.1714	25284.0
2008-06-23 17:30:00	AAPL	Stock	6.1714	6.201	6.1714	6.1725	346640.0
2008-06-23 18:00:00	AAPL	Stock	6.1725	6.175	6.1714	6.175	72240.0
2008-06-23 18:30:00	AAPL	Stock	6.1732	6.175	6.1679	6.1679	127540.0
2008-06-23 19:00:00	AAPL	Stock	6.1679	6.1679	6.1679	6.1679	18116.0
2008-06-23 19:30:00	AAPL	Stock	6.1689	6.1746	6.1689	6.1739	73920.0
2008-06-23 07:00:00	MSFT	Stock	28.18	28.18	28.18	28.18	500.0
2008-06-23 08:00:00	MSFT	Stock	28.3	28.31	28.25	28.25	15227.0
2008-06-23 08:30:00	MSFT	Stock	28.24	28.3	28.24	28.26	14335.0
2008-06-23 09:00:00	MSFT	Stock	28.29	28.37	28.26	28.28	143770.0
2008-06-23 09:30:00	MSFT	Stock	28.29	28.41	28.01	28.089	6533563.0
2008-06-23 10:00:00	MSFT	Stock	28.09	28.14	28.01	28.05	8285452.0
2008-06-23 10:30:00	MSFT	Stock	28.053	28.1	27.79	27.9	5535350.0
2008-06-23 11:00:00	MSFT	Stock	27.901	27.98	27.81	27.89	2929796.0
2008-06-23 11:30:00	MSFT	Stock	27.9	28.02	27.86	28.0	2595708.0
2008-06-23 12:00:00	MSFT	Stock	28.0	28.04	27.84	27.88	2097782.0
2008-06-23 12:30:00	MSFT	Stock	27.88	27.98	27.88	27.96	1757083.0
2008-06-23 13:00:00	MSFT	Stock	27.955	28.02	27.89	27.98	2444984.0
2008-06-23 13:30:00	MSFT	Stock	27.98	28.13	27.97	28.02	2329844.0
2008-06-23 14:00:00	MSFT	Stock	28.02	28.14	28.0	28.14	3029785.0
2008-06-23 14:30:00	MSFT	Stock	28.15	28.2	28.07	28.09	3073203.0
2008-06-23 15:00:00	MSFT	Stock	28.08	28.09	27.9	28.0	3343005.0
2008-06-23 15:30:00	MSFT	Stock	28.01	28.02	27.89	27.99	5881988.0
2008-06-23 16:00:00	MSFT	Stock	27.97	28.2	27.8	28.029	1171129.0
2008-06-23 16:30:00	MSFT	Stock	27.9	28.055	27.9	27.97	154319.0
2008-06-23 17:00:00	MSFT	Stock	27.9	27.9	27.88	27.88	2100.0
2008-06-23 17:30:00	MSFT	Stock	27.88	27.88	27.88	27.88	600.0
2008-06-23 18:00:00	MSFT	Stock	27.89	27.89	27.88	27.88	549.0
2008-06-23 18:30:00	MSFT	Stock	27.86	27.86	27.86	27.86	300.0
2008-06-23 19:30:00	MSFT	Stock	27.87	27.87	27.87	27.87	3900.0

> showing 50 of 70,201 rows — these rows as CSV

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