PREVIEW / stock_30min / 2007-12-21

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-21.parquet
  size:    1.3 MB
  rows:    75,442
  symbols: 3,246

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-12-21 07:00:00	AAPL	Stock	6.8182	6.8214	6.8036	6.8107	497364.0
2007-12-21 07:30:00	AAPL	Stock	6.8075	6.8214	6.8043	6.8043	204540.0
2007-12-21 08:00:00	AAPL	Stock	6.8125	6.8289	6.8018	6.8214	3649996.0
2007-12-21 08:30:00	AAPL	Stock	6.8214	6.8321	6.8214	6.8268	4940684.0
2007-12-21 09:00:00	AAPL	Stock	6.8268	6.8529	6.7821	6.7904	11775400.0
2007-12-21 09:30:00	AAPL	Stock	6.7904	6.8304	6.7818	6.8029	259068964.0
2007-12-21 10:00:00	AAPL	Stock	6.8032	6.8696	6.8014	6.8519	99883028.0
2007-12-21 10:30:00	AAPL	Stock	6.85	6.8568	6.8336	6.8525	49223244.0
2007-12-21 11:00:00	AAPL	Stock	6.8521	6.8707	6.8357	6.8443	60738020.0
2007-12-21 11:30:00	AAPL	Stock	6.8446	6.8589	6.842	6.8464	27811000.0
2007-12-21 12:00:00	AAPL	Stock	6.8454	6.8564	6.8371	6.8521	30582664.0
2007-12-21 12:30:00	AAPL	Stock	6.8524	6.8571	6.8436	6.8464	25775904.0
2007-12-21 13:00:00	AAPL	Stock	6.8461	6.8607	6.8457	6.856	27680828.0
2007-12-21 13:30:00	AAPL	Stock	6.8561	6.875	6.8504	6.87	33229056.0
2007-12-21 14:00:00	AAPL	Stock	6.8693	6.875	6.8618	6.8657	30452464.0
2007-12-21 14:30:00	AAPL	Stock	6.8654	6.9071	6.8625	6.9008	53774616.0
2007-12-21 15:00:00	AAPL	Stock	6.9018	6.9132	6.8932	6.8964	62459236.0
2007-12-21 15:30:00	AAPL	Stock	6.8968	6.9025	6.8375	6.9011	110588016.0
2007-12-21 16:00:00	AAPL	Stock	6.8929	6.9261	6.8443	6.9189	53450768.0
2007-12-21 16:30:00	AAPL	Stock	6.9254	6.9256	6.6861	6.9107	42822360.0
2007-12-21 17:00:00	AAPL	Stock	6.9107	6.9256	6.6861	6.9071	3464916.0
2007-12-21 17:30:00	AAPL	Stock	6.9253	6.9254	6.9086	6.9143	2688532.0
2007-12-21 18:00:00	AAPL	Stock	6.9146	6.9259	6.9125	6.9179	439460.0
2007-12-21 18:30:00	AAPL	Stock	6.9171	6.9171	6.7864	6.9161	431256.0
2007-12-21 19:00:00	AAPL	Stock	6.9161	6.9196	6.9143	6.9179	93184.0
2007-12-21 19:30:00	AAPL	Stock	6.9179	6.9179	6.9075	6.9107	264180.0
2007-12-21 07:00:00	MSFT	Stock	35.7	35.7	35.7	35.7	111.0
2007-12-21 07:30:00	MSFT	Stock	35.73	35.87	35.73	35.87	379.0
2007-12-21 08:00:00	MSFT	Stock	35.85	35.9	35.73	35.85	22433.0
2007-12-21 08:30:00	MSFT	Stock	35.88	35.92	35.52	35.52	2263558.0
2007-12-21 09:00:00	MSFT	Stock	35.9	35.98	35.52	35.89	131945.0
2007-12-21 09:30:00	MSFT	Stock	35.9	35.98	35.75	35.82	29319922.0
2007-12-21 10:00:00	MSFT	Stock	35.83	36.0	35.81	35.94	4487224.0
2007-12-21 10:30:00	MSFT	Stock	35.93	36.01	35.86	35.9	3651954.0
2007-12-21 11:00:00	MSFT	Stock	35.9	35.98	35.87	35.9	2503749.0
2007-12-21 11:30:00	MSFT	Stock	35.9	35.91	35.86	35.882	1936439.0
2007-12-21 12:00:00	MSFT	Stock	35.885	35.9	35.8	35.9	1611195.0
2007-12-21 12:30:00	MSFT	Stock	35.9	35.92	35.86	35.863	1166555.0
2007-12-21 13:00:00	MSFT	Stock	35.86	35.9	35.84	35.845	1329364.0
2007-12-21 13:30:00	MSFT	Stock	35.845	35.88	35.81	35.86	1383930.0
2007-12-21 14:00:00	MSFT	Stock	35.86	35.96	35.86	35.868	2001543.0
2007-12-21 14:30:00	MSFT	Stock	35.86	35.91	35.84	35.887	3085395.0
2007-12-21 15:00:00	MSFT	Stock	35.885	36.0	35.86	35.97	2997262.0
2007-12-21 15:30:00	MSFT	Stock	35.97	36.05	35.9	36.05	7411065.0
2007-12-21 16:00:00	MSFT	Stock	36.05	36.12	35.862	36.065	7735134.0
2007-12-21 16:30:00	MSFT	Stock	35.921	36.09	35.52	36.06	9544368.0
2007-12-21 17:00:00	MSFT	Stock	35.916	36.08	35.52	36.067	519094.0
2007-12-21 17:30:00	MSFT	Stock	36.06	36.18	35.465	36.18	271214.0
2007-12-21 18:00:00	MSFT	Stock	36.15	36.16	36.074	36.074	389845.0
2007-12-21 18:30:00	MSFT	Stock	36.15	36.18	35.81	35.89	119766.0

> showing 50 of 75,442 rows — these rows as CSV

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