PREVIEW / stock_30min / 2008-08-27

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-27.parquet
  size:    1.2 MB
  rows:    67,395
  symbols: 3,299

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-08-27 07:00:00	AAPL	Stock	6.2036	6.2036	6.2036	6.2036	2800.0
2008-08-27 07:30:00	AAPL	Stock	6.1964	6.1968	6.1964	6.1968	9520.0
2008-08-27 08:00:00	AAPL	Stock	6.1932	6.1932	6.1764	6.1786	422128.0
2008-08-27 08:30:00	AAPL	Stock	6.1821	6.2189	6.1821	6.2089	1234436.0
2008-08-27 09:00:00	AAPL	Stock	6.2089	6.2104	6.1882	6.1882	694148.0
2008-08-27 09:30:00	AAPL	Stock	6.19	6.2136	6.1497	6.1732	57639876.0
2008-08-27 10:00:00	AAPL	Stock	6.1732	6.2175	6.1646	6.2129	45415384.0
2008-08-27 10:30:00	AAPL	Stock	6.2136	6.2146	6.1825	6.1968	37964024.0
2008-08-27 11:00:00	AAPL	Stock	6.1961	6.2214	6.1861	6.2032	29408204.0
2008-08-27 11:30:00	AAPL	Stock	6.2036	6.2075	6.1871	6.2071	20253968.0
2008-08-27 12:00:00	AAPL	Stock	6.2075	6.2629	6.2043	6.2504	53745664.0
2008-08-27 12:30:00	AAPL	Stock	6.2493	6.2771	6.2493	6.2708	29816836.0
2008-08-27 13:00:00	AAPL	Stock	6.2698	6.2736	6.2507	6.2607	25905432.0
2008-08-27 13:30:00	AAPL	Stock	6.2607	6.2771	6.255	6.2568	19882240.0
2008-08-27 14:00:00	AAPL	Stock	6.2568	6.2757	6.2554	6.2696	20723416.0
2008-08-27 14:30:00	AAPL	Stock	6.2693	6.2764	6.2475	6.2521	28359492.0
2008-08-27 15:00:00	AAPL	Stock	6.2511	6.2604	6.2229	6.2268	30371124.0
2008-08-27 15:30:00	AAPL	Stock	6.2264	6.2443	6.2179	6.2411	46790940.0
2008-08-27 16:00:00	AAPL	Stock	6.2382	6.2503	6.1658	6.2247	8994440.0
2008-08-27 16:30:00	AAPL	Stock	6.2382	6.2404	6.1825	6.2139	3777368.0
2008-08-27 17:00:00	AAPL	Stock	6.2136	6.2214	6.2018	6.2143	670236.0
2008-08-27 17:30:00	AAPL	Stock	6.2107	6.2143	6.1879	6.1996	446460.0
2008-08-27 18:00:00	AAPL	Stock	6.2	6.2125	6.2	6.2107	398048.0
2008-08-27 18:30:00	AAPL	Stock	6.2075	6.2136	6.2071	6.2136	122668.0
2008-08-27 19:00:00	AAPL	Stock	6.2132	6.2211	6.2104	6.2211	127400.0
2008-08-27 19:30:00	AAPL	Stock	6.2196	6.2243	6.2143	6.2143	103012.0
2008-08-27 20:00:00	AAPL	Stock	6.2389	6.2389	6.2389	6.2389	8400.0
2008-08-27 07:00:00	MSFT	Stock	27.47	27.47	27.45	27.45	800.0
2008-08-27 08:00:00	MSFT	Stock	27.25	27.37	27.25	27.37	1300.0
2008-08-27 08:30:00	MSFT	Stock	27.32	27.32	27.32	27.32	200.0
2008-08-27 09:00:00	MSFT	Stock	27.33	27.34	27.22	27.33	23938.0
2008-08-27 09:30:00	MSFT	Stock	27.34	27.34	27.13	27.29	2214299.0
2008-08-27 10:00:00	MSFT	Stock	27.29	27.52	27.262	27.52	2572975.0
2008-08-27 10:30:00	MSFT	Stock	27.52	27.54	27.37	27.372	2686626.0
2008-08-27 11:00:00	MSFT	Stock	27.37	27.51	27.36	27.48	1389155.0
2008-08-27 11:30:00	MSFT	Stock	27.48	27.51	27.4	27.45	1646263.0
2008-08-27 12:00:00	MSFT	Stock	27.45	27.57	27.44	27.57	1298420.0
2008-08-27 12:30:00	MSFT	Stock	27.57	27.75	27.56	27.71	2173710.0
2008-08-27 13:00:00	MSFT	Stock	27.72	27.74	27.65	27.7	1499539.0
2008-08-27 13:30:00	MSFT	Stock	27.7	27.76	27.66	27.68	1716917.0
2008-08-27 14:00:00	MSFT	Stock	27.68	27.72	27.63	27.69	1928433.0
2008-08-27 14:30:00	MSFT	Stock	27.69	27.79	27.67	27.67	1545330.0
2008-08-27 15:00:00	MSFT	Stock	27.68	27.69	27.56	27.56	2517309.0
2008-08-27 15:30:00	MSFT	Stock	27.57	27.6	27.5	27.57	6112771.0
2008-08-27 16:00:00	MSFT	Stock	27.5	27.666	27.5	27.56	3331046.0
2008-08-27 16:30:00	MSFT	Stock	27.56	27.56	27.541	27.56	135935.0
2008-08-27 17:00:00	MSFT	Stock	27.556	27.59	27.556	27.59	7548.0
2008-08-27 17:30:00	MSFT	Stock	27.67	27.68	27.67	27.68	1400.0
2008-08-27 18:00:00	MSFT	Stock	27.5	27.5	27.46	27.46	770.0
2008-08-27 19:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	400.0

> showing 50 of 67,395 rows — these rows as CSV

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