PREVIEW / stock_30min / 2007-11-05

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-05.parquet
  size:    1.3 MB
  rows:    74,720
  symbols: 3,193

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-11-05 04:00:00	AAPL	Stock	6.6804	6.6804	6.6804	6.6804	2800.0
2007-11-05 05:30:00	AAPL	Stock	6.6539	6.6539	6.6518	6.6518	53200.0
2007-11-05 06:00:00	AAPL	Stock	6.645	6.645	6.6432	6.6432	28000.0
2007-11-05 06:30:00	AAPL	Stock	6.6607	6.6607	6.6429	6.6429	53200.0
2007-11-05 07:00:00	AAPL	Stock	6.6429	6.6732	6.6429	6.6729	284900.0
2007-11-05 07:30:00	AAPL	Stock	6.6696	6.6696	6.6525	6.6525	142800.0
2007-11-05 08:00:00	AAPL	Stock	6.6554	6.7096	6.6321	6.6339	3248308.0
2007-11-05 08:30:00	AAPL	Stock	6.6343	6.6411	6.6182	6.6393	1108072.0
2007-11-05 09:00:00	AAPL	Stock	6.64	6.7096	6.6107	6.6175	1673028.0
2007-11-05 09:30:00	AAPL	Stock	6.6179	6.6629	6.58	6.6254	96579476.0
2007-11-05 10:00:00	AAPL	Stock	6.6268	6.6518	6.6157	6.6407	60799984.0
2007-11-05 10:30:00	AAPL	Stock	6.6411	6.7154	6.6375	6.6975	74905124.0
2007-11-05 11:00:00	AAPL	Stock	6.6986	6.7486	6.6771	6.7293	80835384.0
2007-11-05 11:30:00	AAPL	Stock	6.7282	6.7346	6.6918	6.7243	39973136.0
2007-11-05 12:00:00	AAPL	Stock	6.7239	6.7279	6.6857	6.6925	39777052.0
2007-11-05 12:30:00	AAPL	Stock	6.6918	6.6989	6.6786	6.6911	30734032.0
2007-11-05 13:00:00	AAPL	Stock	6.6911	6.7036	6.6729	6.675	44410772.0
2007-11-05 13:30:00	AAPL	Stock	6.6754	6.6818	6.6411	6.6457	51187696.0
2007-11-05 14:00:00	AAPL	Stock	6.6439	6.6661	6.6293	6.6332	60652312.0
2007-11-05 14:30:00	AAPL	Stock	6.6336	6.6482	6.6	6.6111	59789324.0
2007-11-05 15:00:00	AAPL	Stock	6.6111	6.6586	6.6075	6.6532	69335308.0
2007-11-05 15:30:00	AAPL	Stock	6.6543	6.7046	6.6411	6.6443	70815920.0
2007-11-05 16:00:00	AAPL	Stock	6.6443	6.6722	6.6	6.65	8431584.0
2007-11-05 16:30:00	AAPL	Stock	6.6514	6.6639	6.6443	6.6464	7644896.0
2007-11-05 17:00:00	AAPL	Stock	6.6464	6.6493	6.635	6.6464	2567908.0
2007-11-05 17:30:00	AAPL	Stock	6.7189	6.7232	6.6432	6.6432	461244.0
2007-11-05 18:00:00	AAPL	Stock	6.6429	6.6719	6.6393	6.6393	152460.0
2007-11-05 18:30:00	AAPL	Stock	6.6411	6.6411	6.6357	6.6393	74844.0
2007-11-05 19:00:00	AAPL	Stock	6.6343	6.6382	6.6321	6.6321	198940.0
2007-11-05 19:30:00	AAPL	Stock	6.6321	6.6371	6.6296	6.6336	44940.0
2007-11-05 04:00:00	MSFT	Stock	36.76	36.79	36.76	36.79	700.0
2007-11-05 05:00:00	MSFT	Stock	36.71	36.71	36.71	36.71	200.0
2007-11-05 07:00:00	MSFT	Stock	36.66	36.79	36.66	36.69	6430.0
2007-11-05 07:30:00	MSFT	Stock	36.77	36.77	36.69	36.69	5800.0
2007-11-05 08:00:00	MSFT	Stock	37.06	37.06	36.6	36.65	1160477.0
2007-11-05 08:30:00	MSFT	Stock	36.62	36.75	36.61	36.75	37269.0
2007-11-05 09:00:00	MSFT	Stock	36.76	37.06	36.62	36.76	142361.0
2007-11-05 09:30:00	MSFT	Stock	36.75	36.9	36.63	36.83	9616455.0
2007-11-05 10:00:00	MSFT	Stock	36.84	37.09	36.8	36.95	8564311.0
2007-11-05 10:30:00	MSFT	Stock	36.94	37.1	36.653	36.87	5664027.0
2007-11-05 11:00:00	MSFT	Stock	36.87	36.92	36.83	36.871	5499132.0
2007-11-05 11:30:00	MSFT	Stock	36.87	36.9	36.82	36.83	3536537.0
2007-11-05 12:00:00	MSFT	Stock	36.83	36.85	36.75	36.78	3420364.0
2007-11-05 12:30:00	MSFT	Stock	36.78	36.82	36.76	36.82	2444889.0
2007-11-05 13:00:00	MSFT	Stock	36.815	36.87	36.78	36.86	2825287.0
2007-11-05 13:30:00	MSFT	Stock	36.86	36.88	36.77	36.81	3624806.0
2007-11-05 14:00:00	MSFT	Stock	36.81	36.86	36.73	36.76	3774033.0
2007-11-05 14:30:00	MSFT	Stock	36.76	36.86	36.7	36.74	5420282.0
2007-11-05 15:00:00	MSFT	Stock	36.741	36.91	36.7	36.85	6835617.0
2007-11-05 15:30:00	MSFT	Stock	36.86	36.92	36.71	36.719	7878786.0

> showing 50 of 74,720 rows — these rows as CSV

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