PREVIEW / stock_30min / 2008-06-13

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-13.parquet
  size:    1.2 MB
  rows:    67,696
  symbols: 3,329

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-06-13 06:00:00	AAPL	Stock	6.1221	6.1332	6.1221	6.1332	14000.0
2008-06-13 06:30:00	AAPL	Stock	6.1332	6.1429	6.1246	6.1429	33600.0
2008-06-13 07:00:00	AAPL	Stock	6.1596	6.1604	6.1393	6.1393	107072.0
2008-06-13 07:30:00	AAPL	Stock	6.1396	6.1475	6.1393	6.1464	107100.0
2008-06-13 08:00:00	AAPL	Stock	6.1543	6.1543	6.1071	6.1339	1840720.0
2008-06-13 08:30:00	AAPL	Stock	6.1339	6.2096	6.1154	6.1682	5757864.0
2008-06-13 09:00:00	AAPL	Stock	6.1686	6.1836	6.1239	6.1321	4711504.0
2008-06-13 09:30:00	AAPL	Stock	6.1339	6.1704	5.9039	6.0536	304140564.0
2008-06-13 10:00:00	AAPL	Stock	6.0521	6.1732	6.0179	6.1318	193986772.0
2008-06-13 10:30:00	AAPL	Stock	6.1318	6.1639	6.0857	6.1539	112862372.0
2008-06-13 11:00:00	AAPL	Stock	6.1549	6.2071	6.1339	6.2071	97989780.0
2008-06-13 11:30:00	AAPL	Stock	6.2068	6.22	6.1639	6.1786	87395280.0
2008-06-13 12:00:00	AAPL	Stock	6.1783	6.1964	6.1486	6.1696	36942444.0
2008-06-13 12:30:00	AAPL	Stock	6.1696	6.1758	6.0943	6.1136	57690500.0
2008-06-13 13:00:00	AAPL	Stock	6.1136	6.1179	6.0621	6.0771	57692572.0
2008-06-13 13:30:00	AAPL	Stock	6.0768	6.0857	6.0243	6.0447	60079208.0
2008-06-13 14:00:00	AAPL	Stock	6.0448	6.1021	6.0286	6.0793	62248900.0
2008-06-13 14:30:00	AAPL	Stock	6.0796	6.1411	6.0789	6.1389	56057876.0
2008-06-13 15:00:00	AAPL	Stock	6.1379	6.1389	6.0704	6.0839	53231864.0
2008-06-13 15:30:00	AAPL	Stock	6.0836	6.1596	6.0714	6.1532	94400292.0
2008-06-13 16:00:00	AAPL	Stock	6.1554	6.1596	6.0935	6.1464	15449588.0
2008-06-13 16:30:00	AAPL	Stock	6.1432	6.1561	6.1389	6.1561	384552.0
2008-06-13 17:00:00	AAPL	Stock	6.1482	6.1571	6.1446	6.1554	334348.0
2008-06-13 17:30:00	AAPL	Stock	6.1525	6.1586	6.145	6.145	219156.0
2008-06-13 18:00:00	AAPL	Stock	6.145	6.1554	6.145	6.1486	92400.0
2008-06-13 18:30:00	AAPL	Stock	6.1464	6.1511	6.1464	6.1511	33600.0
2008-06-13 19:00:00	AAPL	Stock	6.1511	6.1604	6.1482	6.1536	216412.0
2008-06-13 19:30:00	AAPL	Stock	6.1561	6.1561	6.1521	6.1554	205380.0
2008-06-13 07:30:00	MSFT	Stock	28.07	28.07	28.07	28.07	190.0
2008-06-13 08:00:00	MSFT	Stock	28.5	28.5	28.15	28.24	55273.0
2008-06-13 08:30:00	MSFT	Stock	28.19	28.4	28.15	28.34	2573612.0
2008-06-13 09:00:00	MSFT	Stock	28.34	28.63	28.31	28.62	633651.0
2008-06-13 09:30:00	MSFT	Stock	28.61	29.13	28.5	29.1	25971220.0
2008-06-13 10:00:00	MSFT	Stock	29.1	29.478	29.09	29.46	22679919.0
2008-06-13 10:30:00	MSFT	Stock	29.47	29.57	29.1	29.16	14263505.0
2008-06-13 11:00:00	MSFT	Stock	29.165	29.42	29.15	29.32	7169062.0
2008-06-13 11:30:00	MSFT	Stock	29.32	29.41	29.24	29.28	5656248.0
2008-06-13 12:00:00	MSFT	Stock	29.29	29.34	29.11	29.11	4414480.0
2008-06-13 12:30:00	MSFT	Stock	29.12	29.17	28.99	29.04	5058215.0
2008-06-13 13:00:00	MSFT	Stock	29.03	29.07	28.93	28.94	4717408.0
2008-06-13 13:30:00	MSFT	Stock	28.95	29.0	28.89	28.94	3518587.0
2008-06-13 14:00:00	MSFT	Stock	28.95	29.0	28.77	28.84	6451679.0
2008-06-13 14:30:00	MSFT	Stock	28.84	28.98	28.79	28.98	4799698.0
2008-06-13 15:00:00	MSFT	Stock	28.97	29.02	28.91	28.96	4972929.0
2008-06-13 15:30:00	MSFT	Stock	28.96	29.07	28.94	29.05	9671056.0
2008-06-13 16:00:00	MSFT	Stock	29.06	29.4	28.75	29.03	3302698.0
2008-06-13 16:30:00	MSFT	Stock	29.04	29.07	29.03	29.05	64256.0
2008-06-13 17:00:00	MSFT	Stock	29.05	29.05	28.98	29.04	32355.0
2008-06-13 17:30:00	MSFT	Stock	29.04	29.04	29.02	29.02	61500.0
2008-06-13 18:00:00	MSFT	Stock	29.07	29.07	29.01	29.05	3298.0

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

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