PREVIEW / stock_30min / 2007-11-26

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-26.parquet
  size:    1.2 MB
  rows:    68,759
  symbols: 3,213

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-11-26 04:00:00	AAPL	Stock	6.1993	6.1993	6.1993	6.1993	2800.0
2007-11-26 05:00:00	AAPL	Stock	6.21	6.21	6.21	6.21	2800.0
2007-11-26 06:00:00	AAPL	Stock	6.2189	6.2304	6.2189	6.2304	11200.0
2007-11-26 06:30:00	AAPL	Stock	6.2218	6.2218	6.2143	6.2143	14000.0
2007-11-26 07:00:00	AAPL	Stock	6.2143	6.2143	6.1821	6.1929	98000.0
2007-11-26 07:30:00	AAPL	Stock	6.1929	6.2089	6.1786	6.1889	1448608.0
2007-11-26 08:00:00	AAPL	Stock	6.1893	6.2232	6.1807	6.2004	5030788.0
2007-11-26 08:30:00	AAPL	Stock	6.2004	6.2043	6.1607	6.1893	5026672.0
2007-11-26 09:00:00	AAPL	Stock	6.1918	6.2096	6.1264	6.1996	2976988.0
2007-11-26 09:30:00	AAPL	Stock	6.1996	6.3036	6.175	6.3036	197365560.0
2007-11-26 10:00:00	AAPL	Stock	6.3036	6.31	6.2539	6.2686	109490108.0
2007-11-26 10:30:00	AAPL	Stock	6.2688	6.2946	6.2336	6.2436	101125192.0
2007-11-26 11:00:00	AAPL	Stock	6.2436	6.2639	6.1932	6.2032	103672828.0
2007-11-26 11:30:00	AAPL	Stock	6.2029	6.2654	6.1971	6.2486	80675644.0
2007-11-26 12:00:00	AAPL	Stock	6.2486	6.2919	6.2475	6.2868	62936104.0
2007-11-26 12:30:00	AAPL	Stock	6.285	6.3071	6.2757	6.2978	60459336.0
2007-11-26 13:00:00	AAPL	Stock	6.2968	6.3018	6.2714	6.2839	57238636.0
2007-11-26 13:30:00	AAPL	Stock	6.2836	6.3311	6.2679	6.2825	99172668.0
2007-11-26 14:00:00	AAPL	Stock	6.2821	6.3007	6.2393	6.2807	69308148.0
2007-11-26 14:30:00	AAPL	Stock	6.2807	6.3	6.2593	6.2611	70223104.0
2007-11-26 15:00:00	AAPL	Stock	6.2618	6.265	6.205	6.2129	115699192.0
2007-11-26 15:30:00	AAPL	Stock	6.2139	6.2389	6.1554	6.1634	122154032.0
2007-11-26 16:00:00	AAPL	Stock	6.1607	6.2539	6.1596	6.1764	18730516.0
2007-11-26 16:30:00	AAPL	Stock	6.1786	6.2539	6.1621	6.1621	21064428.0
2007-11-26 17:00:00	AAPL	Stock	6.1764	6.1764	6.1629	6.1629	582400.0
2007-11-26 17:30:00	AAPL	Stock	6.2604	6.2802	6.1646	6.175	407288.0
2007-11-26 18:00:00	AAPL	Stock	6.175	6.1821	6.17	6.1782	324016.0
2007-11-26 18:30:00	AAPL	Stock	6.1786	6.1786	6.1618	6.1779	105112.0
2007-11-26 19:00:00	AAPL	Stock	6.1782	6.1793	6.1739	6.1786	184688.0
2007-11-26 19:30:00	AAPL	Stock	6.1786	6.1821	6.1768	6.1786	234080.0
2007-11-26 07:00:00	MSFT	Stock	34.2	34.2	34.15	34.15	390.0
2007-11-26 07:30:00	MSFT	Stock	34.2	34.2	34.2	34.2	310.0
2007-11-26 08:00:00	MSFT	Stock	34.23	34.23	34.15	34.17	5932.0
2007-11-26 08:30:00	MSFT	Stock	34.2	34.2	34.11	34.11	8116.0
2007-11-26 09:00:00	MSFT	Stock	34.15	34.15	33.96	34.09	75963.0
2007-11-26 09:30:00	MSFT	Stock	34.08	34.35	34.01	34.35	7517049.0
2007-11-26 10:00:00	MSFT	Stock	34.35	34.37	34.16	34.17	3914864.0
2007-11-26 10:30:00	MSFT	Stock	34.17	34.23	33.86	33.88	5740269.0
2007-11-26 11:00:00	MSFT	Stock	33.88	34.06	33.77	33.77	4663730.0
2007-11-26 11:30:00	MSFT	Stock	33.77	33.86	33.72	33.77	3397303.0
2007-11-26 12:00:00	MSFT	Stock	33.77	33.86	33.67	33.765	4288878.0
2007-11-26 12:30:00	MSFT	Stock	33.76	33.83	33.75	33.75	2793835.0
2007-11-26 13:00:00	MSFT	Stock	33.75	33.82	33.63	33.63	4584397.0
2007-11-26 13:30:00	MSFT	Stock	33.635	33.75	33.63	33.67	3689581.0
2007-11-26 14:00:00	MSFT	Stock	33.67	33.75	33.53	33.59	5810408.0
2007-11-26 14:30:00	MSFT	Stock	33.59	33.63	33.42	33.47	6552889.0
2007-11-26 15:00:00	MSFT	Stock	33.46	33.5	33.18	33.2	11413864.0
2007-11-26 15:30:00	MSFT	Stock	33.2	33.29	32.93	32.99	13947922.0
2007-11-26 16:00:00	MSFT	Stock	32.98	33.648	32.94	32.97	3620638.0
2007-11-26 16:30:00	MSFT	Stock	33.0	33.648	32.97	33.03	10068.0

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

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