PREVIEW / stock_30min / 2009-11-04

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-04.parquet
  size:    1.3 MB
  rows:    72,506
  symbols: 3,399

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
2009-11-04 06:30:00	AAPL	Stock	6.7857	6.7857	6.7857	6.7857	28000.0
2009-11-04 07:00:00	AAPL	Stock	6.7911	6.7982	6.7857	6.7857	81200.0
2009-11-04 07:30:00	AAPL	Stock	6.7839	6.7893	6.775	6.7807	172088.0
2009-11-04 08:00:00	AAPL	Stock	6.7839	6.8212	6.7804	6.8036	1303092.0
2009-11-04 08:30:00	AAPL	Stock	6.805	6.8211	6.8043	6.8125	1184988.0
2009-11-04 09:00:00	AAPL	Stock	6.8082	6.8211	6.8057	6.8107	1263612.0
2009-11-04 09:30:00	AAPL	Stock	6.8114	6.8368	6.7939	6.8332	70229516.0
2009-11-04 10:00:00	AAPL	Stock	6.8339	6.8561	6.8146	6.8561	48783588.0
2009-11-04 10:30:00	AAPL	Stock	6.8561	6.9232	6.8554	6.9218	47693772.0
2009-11-04 11:00:00	AAPL	Stock	6.9218	6.9221	6.895	6.9057	33369924.0
2009-11-04 11:30:00	AAPL	Stock	6.9039	6.9104	6.8818	6.883	20267828.0
2009-11-04 12:00:00	AAPL	Stock	6.8842	6.8982	6.8775	6.8811	16076648.0
2009-11-04 12:30:00	AAPL	Stock	6.8809	6.895	6.8775	6.8893	17796044.0
2009-11-04 13:00:00	AAPL	Stock	6.8882	6.89	6.8707	6.8732	13014624.0
2009-11-04 13:30:00	AAPL	Stock	6.8729	6.8804	6.8571	6.8732	13785912.0
2009-11-04 14:00:00	AAPL	Stock	6.8718	6.8946	6.8571	6.8667	34488972.0
2009-11-04 14:30:00	AAPL	Stock	6.8668	6.9182	6.8575	6.9096	45444756.0
2009-11-04 15:00:00	AAPL	Stock	6.9096	6.9132	6.8739	6.8911	38658424.0
2009-11-04 15:30:00	AAPL	Stock	6.8929	6.895	6.8061	6.8164	69187496.0
2009-11-04 16:00:00	AAPL	Stock	6.8168	6.8643	6.8114	6.8286	7308588.0
2009-11-04 16:30:00	AAPL	Stock	6.8268	6.8304	6.8146	6.8239	1652168.0
2009-11-04 17:00:00	AAPL	Stock	6.8275	6.8389	6.8268	6.8375	286272.0
2009-11-04 17:30:00	AAPL	Stock	6.8357	6.8393	6.8321	6.8321	234864.0
2009-11-04 18:00:00	AAPL	Stock	6.8304	6.835	6.8146	6.8289	204288.0
2009-11-04 18:30:00	AAPL	Stock	6.8329	6.8329	6.832	6.832	11200.0
2009-11-04 19:00:00	AAPL	Stock	6.8296	6.8364	6.8279	6.8304	69384.0
2009-11-04 19:30:00	AAPL	Stock	6.8304	6.8304	6.8214	6.8286	82488.0
2009-11-04 06:30:00	MSFT	Stock	27.78	27.78	27.78	27.78	400.0
2009-11-04 07:00:00	MSFT	Stock	27.73	27.77	27.73	27.77	300.0
2009-11-04 08:00:00	MSFT	Stock	27.53	27.68	27.53	27.66	90349.0
2009-11-04 08:30:00	MSFT	Stock	27.67	27.71	27.65	27.67	15680.0
2009-11-04 09:00:00	MSFT	Stock	27.67	27.69	27.65	27.68	23641.0
2009-11-04 09:30:00	MSFT	Stock	27.68	27.92	27.62	27.89	5071834.0
2009-11-04 10:00:00	MSFT	Stock	27.9	28.1	27.83	28.06	6807734.0
2009-11-04 10:30:00	MSFT	Stock	28.06	28.12	28.03	28.11	3658002.0
2009-11-04 11:00:00	MSFT	Stock	28.11	28.26	28.07	28.19	4009277.0
2009-11-04 11:30:00	MSFT	Stock	28.19	28.25	28.15	28.169	2430256.0
2009-11-04 12:00:00	MSFT	Stock	28.17	28.19	28.1	28.12	2130880.0
2009-11-04 12:30:00	MSFT	Stock	28.13	28.23	28.09	28.22	1617516.0
2009-11-04 13:00:00	MSFT	Stock	28.22	28.26	28.16	28.2	1981620.0
2009-11-04 13:30:00	MSFT	Stock	28.19	28.21	28.14	28.15	1380937.0
2009-11-04 14:00:00	MSFT	Stock	28.14	28.36	28.1	28.148	3965930.0
2009-11-04 14:30:00	MSFT	Stock	28.148	28.39	28.12	28.38	6030063.0
2009-11-04 15:00:00	MSFT	Stock	28.38	28.38	28.23	28.29	5078382.0
2009-11-04 15:30:00	MSFT	Stock	28.3	28.32	28.04	28.06	12472065.0
2009-11-04 16:00:00	MSFT	Stock	28.07	28.4	28.05	28.35	5490168.0
2009-11-04 16:30:00	MSFT	Stock	28.35	28.36	28.06	28.32	513928.0
2009-11-04 17:00:00	MSFT	Stock	28.34	28.36	28.31	28.36	93153.0
2009-11-04 17:30:00	MSFT	Stock	28.34	28.34	28.26	28.28	92600.0
2009-11-04 18:00:00	MSFT	Stock	28.32	28.34	28.06	28.34	22845.0

> showing 50 of 72,506 rows — these rows as CSV

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