PREVIEW / stock_30min / 2007-10-19

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-19.parquet
  size:    1.2 MB
  rows:    68,098
  symbols: 3,151

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-10-19 04:00:00	AAPL	Stock	6.2	6.2	6.2	6.2	2800.0
2007-10-19 06:00:00	AAPL	Stock	6.2104	6.2104	6.2104	6.2104	2800.0
2007-10-19 06:30:00	AAPL	Stock	6.2104	6.2104	6.2104	6.2104	14000.0
2007-10-19 07:00:00	AAPL	Stock	6.2107	6.2164	6.2107	6.2164	28000.0
2007-10-19 07:30:00	AAPL	Stock	6.2218	6.25	6.2179	6.2479	396704.0
2007-10-19 08:00:00	AAPL	Stock	6.2479	6.25	6.2264	6.2357	4404512.0
2007-10-19 08:30:00	AAPL	Stock	6.2364	6.2446	6.2214	6.2296	3129364.0
2007-10-19 09:00:00	AAPL	Stock	6.23	6.2414	6.2064	6.2214	4786964.0
2007-10-19 09:30:00	AAPL	Stock	6.2225	6.2368	6.1846	6.2143	180716928.0
2007-10-19 10:00:00	AAPL	Stock	6.2157	6.2204	6.1393	6.1875	123929372.0
2007-10-19 10:30:00	AAPL	Stock	6.1875	6.1875	6.0893	6.0893	119778372.0
2007-10-19 11:00:00	AAPL	Stock	6.0914	6.1521	6.0893	6.1454	89109244.0
2007-10-19 11:30:00	AAPL	Stock	6.145	6.1761	6.1204	6.1718	83340880.0
2007-10-19 12:00:00	AAPL	Stock	6.1711	6.205	6.1625	6.1846	75880868.0
2007-10-19 12:30:00	AAPL	Stock	6.183	6.2111	6.1818	6.1993	58871708.0
2007-10-19 13:00:00	AAPL	Stock	6.1996	6.2021	6.1546	6.1661	59306352.0
2007-10-19 13:30:00	AAPL	Stock	6.1664	6.2014	6.1646	6.19	49622048.0
2007-10-19 14:00:00	AAPL	Stock	6.1896	6.1964	6.1682	6.1825	69403068.0
2007-10-19 14:30:00	AAPL	Stock	6.1821	6.1896	6.16	6.1661	55482280.0
2007-10-19 15:00:00	AAPL	Stock	6.1661	6.1832	6.1475	6.154	85091104.0
2007-10-19 15:30:00	AAPL	Stock	6.1536	6.1575	6.0714	6.0861	182932652.0
2007-10-19 16:00:00	AAPL	Stock	6.0875	6.1964	6.0797	6.0946	26491584.0
2007-10-19 16:30:00	AAPL	Stock	6.0946	6.1676	6.0829	6.1039	20309352.0
2007-10-19 17:00:00	AAPL	Stock	6.1036	6.1064	6.0829	6.1011	772632.0
2007-10-19 17:30:00	AAPL	Stock	6.1	6.1071	6.0954	6.1018	545244.0
2007-10-19 18:00:00	AAPL	Stock	6.0996	6.1157	6.0996	6.1157	523768.0
2007-10-19 18:30:00	AAPL	Stock	6.1161	6.1264	6.1161	6.1214	594440.0
2007-10-19 19:00:00	AAPL	Stock	6.1161	6.1232	6.1161	6.1218	222348.0
2007-10-19 19:30:00	AAPL	Stock	6.1182	6.1229	6.1107	6.1179	365540.0
2007-10-19 07:00:00	MSFT	Stock	31.08	31.09	31.0	31.0	4057.0
2007-10-19 07:30:00	MSFT	Stock	31.01	31.1	31.01	31.1	200.0
2007-10-19 08:00:00	MSFT	Stock	31.1	31.12	31.01	31.1	6270.0
2007-10-19 08:30:00	MSFT	Stock	31.09	31.09	31.05	31.05	3499.0
2007-10-19 09:00:00	MSFT	Stock	31.1	31.1	30.95	31.05	86669.0
2007-10-19 09:30:00	MSFT	Stock	31.09	31.09	30.78	30.81	16477865.0
2007-10-19 10:00:00	MSFT	Stock	30.81	30.85	30.68	30.76	4981842.0
2007-10-19 10:30:00	MSFT	Stock	30.76	30.8	30.55	30.56	4260765.0
2007-10-19 11:00:00	MSFT	Stock	30.55	30.73	30.53	30.71	2899768.0
2007-10-19 11:30:00	MSFT	Stock	30.71	30.72	30.53	30.65	2781036.0
2007-10-19 12:00:00	MSFT	Stock	30.64	30.835	30.56	30.56	2428527.0
2007-10-19 12:30:00	MSFT	Stock	30.56	30.65	30.53	30.57	2115842.0
2007-10-19 13:00:00	MSFT	Stock	30.56	30.57	30.42	30.45	2933047.0
2007-10-19 13:30:00	MSFT	Stock	30.45	30.54	30.42	30.52	2213748.0
2007-10-19 14:00:00	MSFT	Stock	30.51	30.61	30.44	30.55	3815609.0
2007-10-19 14:30:00	MSFT	Stock	30.55	30.62	30.42	30.45	4139696.0
2007-10-19 15:00:00	MSFT	Stock	30.48	30.51	30.28	30.29	6183883.0
2007-10-19 15:30:00	MSFT	Stock	30.28	30.34	30.11	30.18	12498653.0
2007-10-19 16:00:00	MSFT	Stock	30.18	31.17	30.17	30.17	4327425.0
2007-10-19 16:30:00	MSFT	Stock	30.202	31.16	30.17	30.21	1751383.0
2007-10-19 17:00:00	MSFT	Stock	30.27	30.31	30.17	30.27	1261059.0

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

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