PREVIEW / stock_30min / 2009-11-06

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-06.parquet
  size:    1.3 MB
  rows:    71,068
  symbols: 3,368

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-06 05:00:00	AAPL	Stock	6.9407	6.9629	6.9407	6.9514	11200.0
2009-11-06 07:00:00	AAPL	Stock	6.9393	6.9504	6.9143	6.9286	11200.0
2009-11-06 07:30:00	AAPL	Stock	6.9286	6.9464	6.9286	6.9461	101808.0
2009-11-06 08:00:00	AAPL	Stock	6.9464	6.9621	6.9429	6.9464	1243228.0
2009-11-06 08:30:00	AAPL	Stock	6.9536	6.9536	6.8393	6.8632	4852372.0
2009-11-06 09:00:00	AAPL	Stock	6.8632	6.935	6.8518	6.8821	3668028.0
2009-11-06 09:30:00	AAPL	Stock	6.8804	6.9711	6.8714	6.95	71847076.0
2009-11-06 10:00:00	AAPL	Stock	6.95	6.9582	6.8969	6.8969	33012028.0
2009-11-06 10:30:00	AAPL	Stock	6.8975	6.9286	6.8839	6.9267	31089856.0
2009-11-06 11:00:00	AAPL	Stock	6.9243	6.9449	6.9172	6.9279	18691064.0
2009-11-06 11:30:00	AAPL	Stock	6.9271	6.9357	6.9164	6.9204	11912544.0
2009-11-06 12:00:00	AAPL	Stock	6.9189	6.9455	6.9189	6.9307	13351184.0
2009-11-06 12:30:00	AAPL	Stock	6.9311	6.9411	6.9189	6.9293	10728032.0
2009-11-06 13:00:00	AAPL	Stock	6.9302	6.9429	6.9232	6.9357	9964864.0
2009-11-06 13:30:00	AAPL	Stock	6.9357	6.9393	6.9236	6.9275	11460988.0
2009-11-06 14:00:00	AAPL	Stock	6.9275	6.9339	6.9143	6.9254	10928344.0
2009-11-06 14:30:00	AAPL	Stock	6.9254	6.9336	6.9168	6.9286	9404584.0
2009-11-06 15:00:00	AAPL	Stock	6.9296	6.9368	6.9179	6.9368	11843132.0
2009-11-06 15:30:00	AAPL	Stock	6.9361	6.9436	6.9274	6.9411	24479504.0
2009-11-06 16:00:00	AAPL	Stock	6.9407	6.9496	6.9179	6.9464	5076232.0
2009-11-06 16:30:00	AAPL	Stock	6.9414	6.9461	6.9411	6.9436	44772.0
2009-11-06 17:00:00	AAPL	Stock	6.9461	6.9464	6.9439	6.9439	14000.0
2009-11-06 17:30:00	AAPL	Stock	6.9461	6.9482	6.9461	6.9482	72016.0
2009-11-06 18:00:00	AAPL	Stock	6.9471	6.9482	6.9407	6.9464	3059700.0
2009-11-06 18:30:00	AAPL	Stock	6.9482	6.9486	6.9482	6.9482	29932.0
2009-11-06 19:00:00	AAPL	Stock	6.9482	6.95	6.9475	6.95	52248.0
2009-11-06 19:30:00	AAPL	Stock	6.9511	6.9511	6.9486	6.9511	45696.0
2009-11-06 07:30:00	MSFT	Stock	28.5	28.6	28.46	28.5	1570.0
2009-11-06 08:00:00	MSFT	Stock	28.58	28.62	28.54	28.6	25808.0
2009-11-06 08:30:00	MSFT	Stock	28.6	28.6	28.28	28.35	74783.0
2009-11-06 09:00:00	MSFT	Stock	28.35	28.47	28.29	28.37	701664.0
2009-11-06 09:30:00	MSFT	Stock	28.37	28.6	28.2	28.58	6589866.0
2009-11-06 10:00:00	MSFT	Stock	28.58	28.63	28.3	28.33	3877492.0
2009-11-06 10:30:00	MSFT	Stock	28.33	28.48	28.28	28.44	3071790.0
2009-11-06 11:00:00	MSFT	Stock	28.43	28.51	28.41	28.49	2409360.0
2009-11-06 11:30:00	MSFT	Stock	28.495	28.53	28.45	28.478	2013018.0
2009-11-06 12:00:00	MSFT	Stock	28.49	28.52	28.44	28.5	2267790.0
2009-11-06 12:30:00	MSFT	Stock	28.502	28.52	28.43	28.46	1744436.0
2009-11-06 13:00:00	MSFT	Stock	28.45	28.55	28.44	28.55	1277131.0
2009-11-06 13:30:00	MSFT	Stock	28.55	28.55	28.46	28.47	1613532.0
2009-11-06 14:00:00	MSFT	Stock	28.47	28.55	28.45	28.527	1634089.0
2009-11-06 14:30:00	MSFT	Stock	28.53	28.623	28.47	28.48	2529628.0
2009-11-06 15:00:00	MSFT	Stock	28.48	28.505	28.43	28.47	1899620.0
2009-11-06 15:30:00	MSFT	Stock	28.47	28.52	28.42	28.52	4758023.0
2009-11-06 16:00:00	MSFT	Stock	28.52	28.6	28.43	28.52	987917.0
2009-11-06 16:30:00	MSFT	Stock	28.52	28.52	28.5	28.52	5400.0
2009-11-06 17:00:00	MSFT	Stock	28.506	28.55	28.5	28.55	2100.0
2009-11-06 17:30:00	MSFT	Stock	28.57	28.58	28.53	28.53	2098.0
2009-11-06 18:00:00	MSFT	Stock	28.57	28.57	28.52	28.52	322729.0
2009-11-06 19:00:00	MSFT	Stock	28.58	28.58	28.58	28.58	300.0

> showing 50 of 71,068 rows — these rows as CSV

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