PREVIEW / stock_30min / 2008-08-07

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-07.parquet
  size:    1.2 MB
  rows:    68,898
  symbols: 3,309

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-08-07 07:00:00	AAPL	Stock	5.8411	5.8411	5.8268	5.8286	35840.0
2008-08-07 07:30:00	AAPL	Stock	5.8321	5.8479	5.8207	5.8214	187600.0
2008-08-07 08:00:00	AAPL	Stock	5.8214	5.8286	5.8036	5.8039	973252.0
2008-08-07 08:30:00	AAPL	Stock	5.8039	5.8071	5.7857	5.795	884100.0
2008-08-07 09:00:00	AAPL	Stock	5.7946	5.8196	5.7857	5.8114	1556576.0
2008-08-07 09:30:00	AAPL	Stock	5.8111	5.8768	5.7679	5.8443	106313032.0
2008-08-07 10:00:00	AAPL	Stock	5.8464	5.8929	5.8433	5.88	74010664.0
2008-08-07 10:30:00	AAPL	Stock	5.8793	5.8793	5.8286	5.8671	47069792.0
2008-08-07 11:00:00	AAPL	Stock	5.8675	5.8886	5.8464	5.8614	34799380.0
2008-08-07 11:30:00	AAPL	Stock	5.8629	5.9114	5.8471	5.9054	44718268.0
2008-08-07 12:00:00	AAPL	Stock	5.905	5.9057	5.8804	5.8989	32077220.0
2008-08-07 12:30:00	AAPL	Stock	5.8989	5.9339	5.8918	5.9243	40684784.0
2008-08-07 13:00:00	AAPL	Stock	5.9246	5.9314	5.9096	5.9195	26901756.0
2008-08-07 13:30:00	AAPL	Stock	5.92	5.9225	5.8786	5.8807	30697240.0
2008-08-07 14:00:00	AAPL	Stock	5.8811	5.8832	5.8443	5.8493	41747580.0
2008-08-07 14:30:00	AAPL	Stock	5.8504	5.8746	5.8239	5.83	47217884.0
2008-08-07 15:00:00	AAPL	Stock	5.8307	5.8589	5.81	5.8561	47795328.0
2008-08-07 15:30:00	AAPL	Stock	5.8557	5.8582	5.8043	5.8507	69281828.0
2008-08-07 16:00:00	AAPL	Stock	5.845	5.867	5.8336	5.8546	9314312.0
2008-08-07 16:30:00	AAPL	Stock	5.8489	5.8536	5.8418	5.8418	2461284.0
2008-08-07 17:00:00	AAPL	Stock	5.8536	5.855	5.85	5.855	139580.0
2008-08-07 17:30:00	AAPL	Stock	5.8536	5.8536	5.8486	5.8525	156520.0
2008-08-07 18:00:00	AAPL	Stock	5.85	5.85	5.8479	5.8482	114296.0
2008-08-07 18:30:00	AAPL	Stock	5.8496	5.8521	5.8496	5.8521	33824.0
2008-08-07 19:00:00	AAPL	Stock	5.8493	5.8514	5.8493	5.8514	18200.0
2008-08-07 19:30:00	AAPL	Stock	5.8525	5.8571	5.8511	5.8514	102200.0
2008-08-07 08:00:00	MSFT	Stock	26.87	27.0	26.87	26.9	2600.0
2008-08-07 08:30:00	MSFT	Stock	26.87	26.87	26.77	26.77	17025.0
2008-08-07 09:00:00	MSFT	Stock	26.77	26.91	26.73	26.88	21025.0
2008-08-07 09:30:00	MSFT	Stock	26.88	27.11	26.73	27.1	5069710.0
2008-08-07 10:00:00	MSFT	Stock	27.1	27.27	26.98	27.24	6758015.0
2008-08-07 10:30:00	MSFT	Stock	27.23	27.5	27.2	27.49	6695493.0
2008-08-07 11:00:00	MSFT	Stock	27.49	27.54	27.33	27.52	6897051.0
2008-08-07 11:30:00	MSFT	Stock	27.52	27.62	27.42	27.43	5514580.0
2008-08-07 12:00:00	MSFT	Stock	27.43	27.55	27.38	27.53	4128106.0
2008-08-07 12:30:00	MSFT	Stock	27.53	27.69	27.52	27.67	5337031.0
2008-08-07 13:00:00	MSFT	Stock	27.67	27.74	27.6	27.72	4627883.0
2008-08-07 13:30:00	MSFT	Stock	27.72	27.75	27.54	27.54	3307529.0
2008-08-07 14:00:00	MSFT	Stock	27.54	27.56	27.48	27.5	4362507.0
2008-08-07 14:30:00	MSFT	Stock	27.51	27.53	27.34	27.35	5937014.0
2008-08-07 15:00:00	MSFT	Stock	27.35	27.54	27.34	27.45	7067485.0
2008-08-07 15:30:00	MSFT	Stock	27.45	27.49	27.33	27.43	11424471.0
2008-08-07 16:00:00	MSFT	Stock	27.39	27.499	27.37	27.41	3646150.0
2008-08-07 16:30:00	MSFT	Stock	27.43	27.48	27.39	27.47	432446.0
2008-08-07 17:00:00	MSFT	Stock	27.42	27.43	27.42	27.43	1100.0
2008-08-07 17:30:00	MSFT	Stock	27.42	27.49	27.42	27.49	1150.0
2008-08-07 18:00:00	MSFT	Stock	27.43	27.43	27.42	27.42	700.0
2008-08-07 18:30:00	MSFT	Stock	27.48	27.48	27.48	27.48	100.0
2008-08-07 19:00:00	MSFT	Stock	27.44	27.44	27.42	27.43	600.0
2008-08-07 19:30:00	MSFT	Stock	27.44	27.44	27.43	27.43	1500.0

> showing 50 of 68,898 rows — these rows as CSV

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