PREVIEW / stock_1hour / 2009-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-27.parquet
  size:    808 KB
  rows:    39,859
  symbols: 3,310

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
2009-03-27 07:00:00	AAPL	Stock	3.8714	3.8889	3.8714	3.8754	84028.0
2009-03-27 08:00:00	AAPL	Stock	3.8811	3.8911	3.8689	3.8804	1063440.0
2009-03-27 09:00:00	AAPL	Stock	3.8775	3.8943	3.8289	3.8414	75518184.0
2009-03-27 10:00:00	AAPL	Stock	3.8421	3.8482	3.8171	3.8375	85589812.0
2009-03-27 11:00:00	AAPL	Stock	3.8375	3.8621	3.8182	3.8439	66941196.0
2009-03-27 12:00:00	AAPL	Stock	3.8443	3.8529	3.82	3.8218	44113188.0
2009-03-27 13:00:00	AAPL	Stock	3.8208	3.8304	3.8018	3.8132	59307976.0
2009-03-27 14:00:00	AAPL	Stock	3.8132	3.8229	3.8	3.8189	54658212.0
2009-03-27 15:00:00	AAPL	Stock	3.8189	3.8379	3.805	3.8261	85507352.0
2009-03-27 16:00:00	AAPL	Stock	3.8161	3.8314	3.8075	3.8232	13990872.0
2009-03-27 17:00:00	AAPL	Stock	3.825	3.8268	3.8164	3.8179	133224.0
2009-03-27 18:00:00	AAPL	Stock	3.81	3.8196	3.81	3.8196	1119636.0
2009-03-27 19:00:00	AAPL	Stock	3.8179	3.8214	3.8161	3.8161	141960.0
2009-03-27 05:00:00	MSFT	Stock	18.7	18.7	18.7	18.7	600.0
2009-03-27 07:00:00	MSFT	Stock	18.51	18.9	18.5	18.9	6618.0
2009-03-27 08:00:00	MSFT	Stock	18.57	18.83	18.52	18.54	33959.0
2009-03-27 09:00:00	MSFT	Stock	18.53	18.64	18.24	18.29	5202848.0
2009-03-27 10:00:00	MSFT	Stock	18.29	18.34	18.1	18.16	6822121.0
2009-03-27 11:00:00	MSFT	Stock	18.15	18.34	18.1	18.32	5895344.0
2009-03-27 12:00:00	MSFT	Stock	18.32	18.4	18.15	18.249	5232121.0
2009-03-27 13:00:00	MSFT	Stock	18.255	18.336	18.12	18.198	5376643.0
2009-03-27 14:00:00	MSFT	Stock	18.2	18.34	18.12	18.22	5259768.0
2009-03-27 15:00:00	MSFT	Stock	18.21	18.33	18.05	18.13	10179512.0
2009-03-27 16:00:00	MSFT	Stock	18.13	18.23	18.09	18.14	2578368.0
2009-03-27 17:00:00	MSFT	Stock	18.13	18.15	18.12	18.14	3640.0
2009-03-27 18:00:00	MSFT	Stock	18.08	18.15	18.08	18.14	232135.0
2009-03-27 19:00:00	MSFT	Stock	18.12	18.15	18.12	18.15	2325.0
2009-03-27 05:00:00	NVDA	Stock	0.2938	0.2938	0.2938	0.2938	4000.0
2009-03-27 07:00:00	NVDA	Stock	0.2675	0.2675	0.2675	0.2675	80760.0
2009-03-27 08:00:00	NVDA	Stock	0.2668	0.2672	0.263	0.267	226200.0
2009-03-27 09:00:00	NVDA	Stock	0.2672	0.2672	0.2585	0.2623	103033240.0
2009-03-27 10:00:00	NVDA	Stock	0.2624	0.263	0.258	0.2603	111411200.0
2009-03-27 11:00:00	NVDA	Stock	0.2603	0.2668	0.2595	0.266	127737720.0
2009-03-27 12:00:00	NVDA	Stock	0.266	0.2676	0.2608	0.2608	83031720.0
2009-03-27 13:00:00	NVDA	Stock	0.261	0.2615	0.2575	0.259	64211240.0
2009-03-27 14:00:00	NVDA	Stock	0.2592	0.2643	0.2583	0.2629	105541520.0
2009-03-27 15:00:00	NVDA	Stock	0.263	0.2645	0.2612	0.2618	117641080.0
2009-03-27 16:00:00	NVDA	Stock	0.2615	0.2623	0.2615	0.2615	15536360.0
2009-03-27 17:00:00	NVDA	Stock	0.2618	0.2618	0.2615	0.2615	67600.0
2009-03-27 18:00:00	NVDA	Stock	0.2615	0.2615	0.2615	0.2615	80000.0
2009-03-27 19:00:00	NVDA	Stock	0.2615	0.2625	0.2615	0.2625	12000.0
2009-03-27 06:00:00	AMZN	Stock	3.63	3.63	3.63	3.63	5000.0
2009-03-27 07:00:00	AMZN	Stock	3.6195	3.6195	3.584	3.584	10760.0
2009-03-27 08:00:00	AMZN	Stock	3.5975	3.6	3.56	3.5625	832860.0
2009-03-27 09:00:00	AMZN	Stock	3.568	3.6035	3.5155	3.5185	29329280.0
2009-03-27 10:00:00	AMZN	Stock	3.518	3.571	3.516	3.5475	27578600.0
2009-03-27 11:00:00	AMZN	Stock	3.5495	3.6145	3.5345	3.591	16726520.0
2009-03-27 12:00:00	AMZN	Stock	3.5915	3.6075	3.5285	3.531	16290880.0
2009-03-27 13:00:00	AMZN	Stock	3.532	3.5365	3.505	3.514	23599500.0
2009-03-27 14:00:00	AMZN	Stock	3.514	3.541	3.505	3.523	20664680.0

> showing 50 of 39,859 rows — these rows as CSV

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