PREVIEW / stock_30min / 2010-09-07

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-07.parquet
  size:    1.4 MB
  rows:    74,752
  symbols: 3,466

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
2010-09-07 04:00:00	AAPL	Stock	9.1782	9.1782	9.1343	9.1343	53200.0
2010-09-07 04:30:00	AAPL	Stock	9.1271	9.1714	9.1271	9.1714	40600.0
2010-09-07 05:00:00	AAPL	Stock	9.1286	9.1286	9.1286	9.1286	8400.0
2010-09-07 05:30:00	AAPL	Stock	9.1571	9.1571	9.1571	9.1571	2800.0
2010-09-07 06:00:00	AAPL	Stock	9.1446	9.1639	9.1268	9.1639	92260.0
2010-09-07 06:30:00	AAPL	Stock	9.1639	9.1661	9.1518	9.1661	67620.0
2010-09-07 07:00:00	AAPL	Stock	9.1714	9.1961	9.1607	9.1857	274288.0
2010-09-07 07:30:00	AAPL	Stock	9.1839	9.1929	9.1761	9.1929	39480.0
2010-09-07 08:00:00	AAPL	Stock	9.1918	9.2107	9.1736	9.1754	1458688.0
2010-09-07 08:30:00	AAPL	Stock	9.1786	9.1821	9.1721	9.1814	549416.0
2010-09-07 09:00:00	AAPL	Stock	9.1821	9.1861	9.1607	9.1675	860104.0
2010-09-07 09:30:00	AAPL	Stock	9.1657	9.2689	9.1518	9.2082	76877500.0
2010-09-07 10:00:00	AAPL	Stock	9.2103	9.2224	9.1875	9.2161	38750628.0
2010-09-07 10:30:00	AAPL	Stock	9.2162	9.2571	9.2054	9.2543	31863216.0
2010-09-07 11:00:00	AAPL	Stock	9.2532	9.2582	9.2282	9.2492	22892576.0
2010-09-07 11:30:00	AAPL	Stock	9.2489	9.2536	9.2296	9.2504	16218692.0
2010-09-07 12:00:00	AAPL	Stock	9.2504	9.2585	9.2368	9.2396	17570112.0
2010-09-07 12:30:00	AAPL	Stock	9.24	9.24	9.2143	9.2268	17273676.0
2010-09-07 13:00:00	AAPL	Stock	9.2275	9.2411	9.2225	9.2275	14087640.0
2010-09-07 13:30:00	AAPL	Stock	9.2286	9.25	9.2257	9.2486	14214900.0
2010-09-07 14:00:00	AAPL	Stock	9.2489	9.2571	9.2386	9.2489	12262824.0
2010-09-07 14:30:00	AAPL	Stock	9.2489	9.2525	9.2154	9.2214	17547712.0
2010-09-07 15:00:00	AAPL	Stock	9.2218	9.2225	9.2004	9.2168	23475648.0
2010-09-07 15:30:00	AAPL	Stock	9.2171	9.2271	9.1986	9.2125	27901412.0
2010-09-07 16:00:00	AAPL	Stock	9.2075	9.237	9.1578	9.2071	5624500.0
2010-09-07 16:30:00	AAPL	Stock	9.2071	9.2217	9.2056	9.2093	806092.0
2010-09-07 17:00:00	AAPL	Stock	9.2071	9.2114	9.2071	9.2114	120372.0
2010-09-07 17:30:00	AAPL	Stock	9.2075	9.2136	9.2075	9.2136	267988.0
2010-09-07 18:00:00	AAPL	Stock	9.2121	9.2121	9.2075	9.2093	55804.0
2010-09-07 18:30:00	AAPL	Stock	9.2093	9.2107	9.2071	9.2071	58800.0
2010-09-07 19:00:00	AAPL	Stock	9.2089	9.2143	9.2075	9.2107	54404.0
2010-09-07 19:30:00	AAPL	Stock	9.2132	9.2196	9.2089	9.2193	106428.0
2010-09-07 07:00:00	MSFT	Stock	24.15	24.15	24.15	24.15	250.0
2010-09-07 07:30:00	MSFT	Stock	24.16	24.22	24.16	24.21	800.0
2010-09-07 08:00:00	MSFT	Stock	24.2	24.21	24.14	24.15	14013.0
2010-09-07 08:30:00	MSFT	Stock	24.15	24.18	24.15	24.18	4190.0
2010-09-07 09:00:00	MSFT	Stock	24.16	24.22	24.07	24.09	32076.0
2010-09-07 09:30:00	MSFT	Stock	24.1	24.3	24.09	24.22	4654430.0
2010-09-07 10:00:00	MSFT	Stock	24.22	24.24	24.14	24.15	5520319.0
2010-09-07 10:30:00	MSFT	Stock	24.159	24.16	24.05	24.082	3583268.0
2010-09-07 11:00:00	MSFT	Stock	24.09	24.11	24.01	24.045	2562617.0
2010-09-07 11:30:00	MSFT	Stock	24.05	24.07	23.95	23.98	4128793.0
2010-09-07 12:00:00	MSFT	Stock	23.98	24.08	23.97	24.0	3661636.0
2010-09-07 12:30:00	MSFT	Stock	23.99	24.0	23.95	23.991	2491200.0
2010-09-07 13:00:00	MSFT	Stock	24.0	24.01	23.98	23.99	1537635.0
2010-09-07 13:30:00	MSFT	Stock	23.988	23.99	23.94	23.98	3329341.0
2010-09-07 14:00:00	MSFT	Stock	23.985	24.04	23.97	23.97	2612056.0
2010-09-07 14:30:00	MSFT	Stock	23.975	24.0	23.93	23.94	2861477.0
2010-09-07 15:00:00	MSFT	Stock	23.94	23.98	23.92	23.965	4027875.0
2010-09-07 15:30:00	MSFT	Stock	23.97	24.02	23.93	23.96	7476729.0

> showing 50 of 74,752 rows — these rows as CSV

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