PREVIEW / stock_1hour / 2008-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-19.parquet
  size:    857 KB
  rows:    40,974
  symbols: 3,314

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-05-19 07:00:00	AAPL	Stock	6.7179	6.7179	6.6614	6.6786	353500.0
2008-05-19 08:00:00	AAPL	Stock	6.6743	6.7179	6.6743	6.7136	1344364.0
2008-05-19 09:00:00	AAPL	Stock	6.7125	6.7132	6.6464	6.6607	91034776.0
2008-05-19 10:00:00	AAPL	Stock	6.6611	6.7257	6.6439	6.6593	163748676.0
2008-05-19 11:00:00	AAPL	Stock	6.6593	6.6818	6.6411	6.6693	96811680.0
2008-05-19 12:00:00	AAPL	Stock	6.6693	6.7143	6.6621	6.6965	66429720.0
2008-05-19 13:00:00	AAPL	Stock	6.6964	6.7389	6.6104	6.6125	124972344.0
2008-05-19 14:00:00	AAPL	Stock	6.6121	6.6296	6.5471	6.61	176945048.0
2008-05-19 15:00:00	AAPL	Stock	6.61	6.6143	6.475	6.5575	202746460.0
2008-05-19 16:00:00	AAPL	Stock	6.5568	6.7107	6.5429	6.555	13522544.0
2008-05-19 17:00:00	AAPL	Stock	6.555	6.5571	6.5529	6.5568	333844.0
2008-05-19 18:00:00	AAPL	Stock	6.5554	6.5643	6.5539	6.5643	313180.0
2008-05-19 19:00:00	AAPL	Stock	6.5661	6.5661	6.5579	6.5607	142016.0
2008-05-19 06:00:00	MSFT	Stock	29.99	29.99	29.86	29.86	3760.0
2008-05-19 07:00:00	MSFT	Stock	29.88	29.88	29.86	29.86	2400.0
2008-05-19 08:00:00	MSFT	Stock	29.95	30.05	29.89	29.9	58485.0
2008-05-19 09:00:00	MSFT	Stock	29.9	29.96	29.63	29.79	6572100.0
2008-05-19 10:00:00	MSFT	Stock	29.8	29.8	29.64	29.7	7253436.0
2008-05-19 11:00:00	MSFT	Stock	29.7	29.7	29.52	29.56	11149192.0
2008-05-19 12:00:00	MSFT	Stock	29.552	29.64	29.55	29.64	5792530.0
2008-05-19 13:00:00	MSFT	Stock	29.64	29.72	29.62	29.64	5405904.0
2008-05-19 14:00:00	MSFT	Stock	29.65	29.677	29.32	29.48	9824644.0
2008-05-19 15:00:00	MSFT	Stock	29.48	29.51	29.31	29.46	9758218.0
2008-05-19 16:00:00	MSFT	Stock	29.45	29.615	29.45	29.486	2613246.0
2008-05-19 17:00:00	MSFT	Stock	29.5	29.61	29.46	29.51	184107.0
2008-05-19 18:00:00	MSFT	Stock	29.5	29.51	29.48	29.48	2650.0
2008-05-19 19:00:00	MSFT	Stock	29.48	29.48	29.46	29.48	8306.0
2008-05-19 07:00:00	NVDA	Stock	0.6113	0.6113	0.6113	0.6113	16000.0
2008-05-19 08:00:00	NVDA	Stock	0.622	0.622	0.6125	0.615	281400.0
2008-05-19 09:00:00	NVDA	Stock	0.6168	0.6328	0.6103	0.6298	114430800.0
2008-05-19 10:00:00	NVDA	Stock	0.6297	0.632	0.6248	0.6273	173085040.0
2008-05-19 11:00:00	NVDA	Stock	0.627	0.63	0.6202	0.6225	172298000.0
2008-05-19 12:00:00	NVDA	Stock	0.6225	0.6228	0.615	0.616	105923120.0
2008-05-19 13:00:00	NVDA	Stock	0.616	0.6215	0.615	0.6178	121332600.0
2008-05-19 14:00:00	NVDA	Stock	0.6175	0.618	0.6003	0.605	213149280.0
2008-05-19 15:00:00	NVDA	Stock	0.605	0.6053	0.5933	0.597	211834480.0
2008-05-19 16:00:00	NVDA	Stock	0.5963	0.6234	0.5963	0.6	20883440.0
2008-05-19 17:00:00	NVDA	Stock	0.5995	0.5995	0.5995	0.5995	4016000.0
2008-05-19 18:00:00	NVDA	Stock	0.5995	0.5995	0.5995	0.5995	40000.0
2008-05-19 19:00:00	NVDA	Stock	0.5992	0.5992	0.5975	0.5975	20000.0
2008-05-19 04:00:00	AMZN	Stock	3.85	3.85	3.85	3.85	4000.0
2008-05-19 06:00:00	AMZN	Stock	3.8835	3.923	3.8675	3.923	45520.0
2008-05-19 07:00:00	AMZN	Stock	3.923	3.97	3.9005	3.9385	638200.0
2008-05-19 08:00:00	AMZN	Stock	3.948	3.98	3.9255	3.956	1533380.0
2008-05-19 09:00:00	AMZN	Stock	3.96	4.0325	3.943	4.023	46606580.0
2008-05-19 10:00:00	AMZN	Stock	4.022	4.087	4.0215	4.075	61591540.0
2008-05-19 11:00:00	AMZN	Stock	4.0745	4.206	4.072	4.1815	75599220.0
2008-05-19 12:00:00	AMZN	Stock	4.182	4.2375	4.1715	4.2125	39358460.0
2008-05-19 13:00:00	AMZN	Stock	4.213	4.228	4.1672	4.1725	34735380.0
2008-05-19 14:00:00	AMZN	Stock	4.1725	4.189	4.1265	4.1545	48251200.0

> showing 50 of 40,974 rows — these rows as CSV

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