PREVIEW / stock_30min / 2007-10-16

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-16.parquet
  size:    1.2 MB
  rows:    67,798
  symbols: 3,148

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-16 05:30:00	AAPL	Stock	5.9007	5.9007	5.9007	5.9007	5600.0
2007-10-16 06:30:00	AAPL	Stock	5.9357	5.9357	5.8882	5.8886	14000.0
2007-10-16 07:00:00	AAPL	Stock	5.8925	5.8929	5.8732	5.8907	243460.0
2007-10-16 07:30:00	AAPL	Stock	5.8929	5.9096	5.8857	5.9061	297640.0
2007-10-16 08:00:00	AAPL	Stock	5.9096	5.9246	5.8857	5.8929	2541644.0
2007-10-16 08:30:00	AAPL	Stock	5.8929	5.9204	5.8907	5.9171	3499972.0
2007-10-16 09:00:00	AAPL	Stock	5.9164	5.9179	5.8989	5.9121	1589252.0
2007-10-16 09:30:00	AAPL	Stock	5.9118	5.9764	5.8993	5.9746	128822204.0
2007-10-16 10:00:00	AAPL	Stock	5.9743	6.0093	5.9543	5.9793	117829908.0
2007-10-16 10:30:00	AAPL	Stock	5.9793	6.01	5.9718	5.9979	81082820.0
2007-10-16 11:00:00	AAPL	Stock	5.9986	6.0361	5.9936	6.0357	76791876.0
2007-10-16 11:30:00	AAPL	Stock	6.0357	6.0696	6.0329	6.0389	91729092.0
2007-10-16 12:00:00	AAPL	Stock	6.0389	6.0593	6.0214	6.0371	56837060.0
2007-10-16 12:30:00	AAPL	Stock	6.0368	6.0607	6.028	6.0456	56525728.0
2007-10-16 13:00:00	AAPL	Stock	6.0456	6.0546	6.0121	6.0325	61723228.0
2007-10-16 13:30:00	AAPL	Stock	6.0325	6.0625	6.0271	6.0566	46400284.0
2007-10-16 14:00:00	AAPL	Stock	6.0568	6.0779	6.0493	6.0639	88898908.0
2007-10-16 14:30:00	AAPL	Stock	6.0639	6.0707	6.0446	6.0586	63041132.0
2007-10-16 15:00:00	AAPL	Stock	6.0586	6.0688	6.0296	6.0571	76709556.0
2007-10-16 15:30:00	AAPL	Stock	6.0571	6.0661	6.0411	6.0564	80009496.0
2007-10-16 16:00:00	AAPL	Stock	6.0607	6.0814	6.0152	6.0786	16066036.0
2007-10-16 16:30:00	AAPL	Stock	6.0804	6.1314	6.0497	6.1221	10881136.0
2007-10-16 17:00:00	AAPL	Stock	6.115	6.1214	6.0196	6.1179	2375324.0
2007-10-16 17:30:00	AAPL	Stock	6.1196	6.1304	6.1189	6.1279	1337308.0
2007-10-16 18:00:00	AAPL	Stock	6.125	6.1318	6.0564	6.1314	3557736.0
2007-10-16 18:30:00	AAPL	Stock	6.1304	6.1389	6.1268	6.1389	448980.0
2007-10-16 19:00:00	AAPL	Stock	6.1393	6.1393	6.1286	6.1318	203952.0
2007-10-16 19:30:00	AAPL	Stock	6.1289	6.1375	6.1275	6.1346	414204.0
2007-10-16 05:30:00	MSFT	Stock	30.05	30.15	30.05	30.15	2000.0
2007-10-16 07:00:00	MSFT	Stock	30.17	30.17	30.15	30.15	4900.0
2007-10-16 07:30:00	MSFT	Stock	30.15	30.15	30.11	30.15	4500.0
2007-10-16 08:00:00	MSFT	Stock	30.11	30.22	30.1	30.15	38726.0
2007-10-16 08:30:00	MSFT	Stock	30.13	30.2	30.13	30.2	49287.0
2007-10-16 09:00:00	MSFT	Stock	30.2	30.27	30.16	30.27	67455.0
2007-10-16 09:30:00	MSFT	Stock	30.27	30.54	30.23	30.51	9193467.0
2007-10-16 10:00:00	MSFT	Stock	30.52	30.58	30.3	30.4	5863264.0
2007-10-16 10:30:00	MSFT	Stock	30.41	30.477	30.34	30.38	3859297.0
2007-10-16 11:00:00	MSFT	Stock	30.39	30.43	30.3	30.39	2542613.0
2007-10-16 11:30:00	MSFT	Stock	30.38	30.5	30.38	30.472	2628166.0
2007-10-16 12:00:00	MSFT	Stock	30.47	30.5	30.42	30.422	2047966.0
2007-10-16 12:30:00	MSFT	Stock	30.43	30.44	30.36	30.38	2432722.0
2007-10-16 13:00:00	MSFT	Stock	30.38	30.4	30.31	30.325	2328071.0
2007-10-16 13:30:00	MSFT	Stock	30.33	30.47	30.3	30.438	2485204.0
2007-10-16 14:00:00	MSFT	Stock	30.45	30.47	30.35	30.39	2573145.0
2007-10-16 14:30:00	MSFT	Stock	30.39	30.42	30.35	30.38	2253002.0
2007-10-16 15:00:00	MSFT	Stock	30.39	30.4	30.3	30.37	3261021.0
2007-10-16 15:30:00	MSFT	Stock	30.37	30.47	30.31	30.31	8319024.0
2007-10-16 16:00:00	MSFT	Stock	30.31	30.55	30.29	30.31	4371180.0
2007-10-16 16:30:00	MSFT	Stock	30.5	30.59	30.296	30.59	1518157.0
2007-10-16 17:00:00	MSFT	Stock	30.59	30.63	30.59	30.6	46162.0

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

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