PREVIEW / stock_1hour / 2006-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-27.parquet
  size:    635 KB
  rows:    30,362
  symbols: 2,493

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
2006-12-27 06:00:00	AAPL	Stock	2.9061	2.9107	2.8907	2.8929	120400.0
2006-12-27 07:00:00	AAPL	Stock	2.9071	2.9071	2.8571	2.8696	1636040.0
2006-12-27 08:00:00	AAPL	Stock	2.8711	2.8796	2.7807	2.7996	56896392.0
2006-12-27 09:00:00	AAPL	Stock	2.7979	2.8068	2.7418	2.7836	493248840.0
2006-12-27 10:00:00	AAPL	Stock	2.7832	2.7972	2.7736	2.7921	272837488.0
2006-12-27 11:00:00	AAPL	Stock	2.7929	2.8557	2.7918	2.8539	326728108.0
2006-12-27 12:00:00	AAPL	Stock	2.8543	2.9107	2.8471	2.8836	260498560.0
2006-12-27 13:00:00	AAPL	Stock	2.8836	2.9125	2.8832	2.9029	145527704.0
2006-12-27 14:00:00	AAPL	Stock	2.9029	2.9146	2.8918	2.9107	123813508.0
2006-12-27 15:00:00	AAPL	Stock	2.91	2.9286	2.9018	2.9136	226845640.0
2006-12-27 16:00:00	AAPL	Stock	2.9136	2.9179	2.7861	2.9175	5238744.0
2006-12-27 17:00:00	AAPL	Stock	2.9171	2.9189	2.9146	2.9189	759472.0
2006-12-27 18:00:00	AAPL	Stock	2.9196	2.9204	2.9114	2.9186	278348.0
2006-12-27 19:00:00	AAPL	Stock	2.9186	2.9207	2.8214	2.8232	4624480.0
2006-12-27 07:00:00	MSFT	Stock	29.81	30.1	29.81	30.1	1300.0
2006-12-27 08:00:00	MSFT	Stock	29.95	29.99	29.92	29.99	29104.0
2006-12-27 09:00:00	MSFT	Stock	29.99	30.13	29.91	30.098	3961723.0
2006-12-27 10:00:00	MSFT	Stock	30.099	30.13	29.99	30.083	5244693.0
2006-12-27 11:00:00	MSFT	Stock	30.08	30.082	29.95	30.01	3846820.0
2006-12-27 12:00:00	MSFT	Stock	30.019	30.08	29.99	30.009	2883252.0
2006-12-27 13:00:00	MSFT	Stock	30.0	30.06	29.99	30.04	4883105.0
2006-12-27 14:00:00	MSFT	Stock	30.04	30.09	30.04	30.07	2225868.0
2006-12-27 15:00:00	MSFT	Stock	30.079	30.1	30.02	30.03	6057114.0
2006-12-27 16:00:00	MSFT	Stock	30.02	30.04	30.0	30.04	528274.0
2006-12-27 17:00:00	MSFT	Stock	30.02	30.02	30.02	30.02	32400.0
2006-12-27 18:00:00	MSFT	Stock	30.02	30.04	30.02	30.04	1378.0
2006-12-27 19:00:00	MSFT	Stock	30.04	30.04	30.04	30.04	684.0
2006-12-27 07:00:00	NVDA	Stock	0.625	0.625	0.625	0.625	12000.0
2006-12-27 08:00:00	NVDA	Stock	0.6227	0.625	0.6227	0.6243	282000.0
2006-12-27 09:00:00	NVDA	Stock	0.6247	0.6273	0.6187	0.6242	41794800.0
2006-12-27 10:00:00	NVDA	Stock	0.6245	0.626	0.6223	0.6235	45046680.0
2006-12-27 11:00:00	NVDA	Stock	0.6233	0.625	0.623	0.6238	28336800.0
2006-12-27 12:00:00	NVDA	Stock	0.6238	0.6262	0.6232	0.6257	25126920.0
2006-12-27 13:00:00	NVDA	Stock	0.6257	0.6267	0.6238	0.6242	22617000.0
2006-12-27 14:00:00	NVDA	Stock	0.6242	0.6255	0.624	0.6253	29419860.0
2006-12-27 15:00:00	NVDA	Stock	0.6253	0.6265	0.6237	0.6253	50212020.0
2006-12-27 16:00:00	NVDA	Stock	0.6252	0.6255	0.6249	0.6253	1172400.0
2006-12-27 17:00:00	NVDA	Stock	0.625	0.6262	0.625	0.6262	99600.0
2006-12-27 19:00:00	NVDA	Stock	0.6265	0.6265	0.6265	0.6265	54000.0
2006-12-27 08:00:00	AMZN	Stock	1.9995	1.9995	1.9995	1.9995	12000.0
2006-12-27 09:00:00	AMZN	Stock	1.998	2.0075	1.99	1.998	7634500.0
2006-12-27 10:00:00	AMZN	Stock	1.998	2.0	1.9945	1.9983	11760480.0
2006-12-27 11:00:00	AMZN	Stock	1.998	2.005	1.9955	1.998	7657660.0
2006-12-27 12:00:00	AMZN	Stock	1.9985	2.0075	1.998	2.007	4253240.0
2006-12-27 13:00:00	AMZN	Stock	2.007	2.0105	2.0045	2.0095	5454340.0
2006-12-27 14:00:00	AMZN	Stock	2.009	2.0155	2.008	2.015	9537920.0
2006-12-27 15:00:00	AMZN	Stock	2.015	2.0235	2.0125	2.016	21915820.0
2006-12-27 16:00:00	AMZN	Stock	2.014	2.0175	2.012	2.0175	189320.0
2006-12-27 19:00:00	AMZN	Stock	2.0125	2.0125	2.0125	2.0125	39000.0
2006-12-27 09:00:00	CL	Stock	32.625	32.66	32.505	32.515	226000.0

> showing 50 of 30,362 rows — these rows as CSV

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