PREVIEW / stock_1hour / 2009-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-13.parquet
  size:    848 KB
  rows:    41,690
  symbols: 3,320

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-05-13 04:00:00	AAPL	Stock	4.4639	4.4639	4.4639	4.4639	2800.0
2009-05-13 07:00:00	AAPL	Stock	4.4432	4.4432	4.4107	4.4143	93772.0
2009-05-13 08:00:00	AAPL	Stock	4.4143	4.4214	4.4	4.4075	1829324.0
2009-05-13 09:00:00	AAPL	Stock	4.4086	4.4293	4.3814	4.3879	82298440.0
2009-05-13 10:00:00	AAPL	Stock	4.3867	4.3879	4.2986	4.3054	129067120.0
2009-05-13 11:00:00	AAPL	Stock	4.3054	4.3318	4.2929	4.3093	80479924.0
2009-05-13 12:00:00	AAPL	Stock	4.3093	4.3261	4.2886	4.2887	50269716.0
2009-05-13 13:00:00	AAPL	Stock	4.2889	4.3264	4.2886	4.3254	48841716.0
2009-05-13 14:00:00	AAPL	Stock	4.3261	4.3286	4.2925	4.3204	50716708.0
2009-05-13 15:00:00	AAPL	Stock	4.3204	4.3239	4.2643	4.2646	131640656.0
2009-05-13 16:00:00	AAPL	Stock	4.2646	4.4379	4.2636	4.2643	15381436.0
2009-05-13 17:00:00	AAPL	Stock	4.2679	4.2679	4.2543	4.2625	238028.0
2009-05-13 18:00:00	AAPL	Stock	4.2604	4.2675	4.2475	4.2493	2336236.0
2009-05-13 19:00:00	AAPL	Stock	4.25	4.2596	4.2457	4.2539	308252.0
2009-05-13 20:00:00	AAPL	Stock	4.35	4.35	4.35	4.35	39200.0
2009-05-13 04:00:00	MSFT	Stock	20.14	20.14	20.14	20.14	100.0
2009-05-13 06:00:00	MSFT	Stock	20.2	20.2	20.2	20.2	100.0
2009-05-13 07:00:00	MSFT	Stock	19.95	19.95	19.8	19.8	7900.0
2009-05-13 08:00:00	MSFT	Stock	19.89	19.89	19.7	19.83	21350.0
2009-05-13 09:00:00	MSFT	Stock	19.83	20.0	19.76	19.92	6591820.0
2009-05-13 10:00:00	MSFT	Stock	19.94	19.94	19.7	19.74	8188955.0
2009-05-13 11:00:00	MSFT	Stock	19.74	19.95	19.67	19.72	5330066.0
2009-05-13 12:00:00	MSFT	Stock	19.72	19.88	19.7	19.73	3336038.0
2009-05-13 13:00:00	MSFT	Stock	19.73	19.81	19.68	19.8	3805106.0
2009-05-13 14:00:00	MSFT	Stock	19.81	19.85	19.685	19.83	4808070.0
2009-05-13 15:00:00	MSFT	Stock	19.82	19.83	19.7	19.7	12419108.0
2009-05-13 16:00:00	MSFT	Stock	19.7	20.05	19.684	19.75	4155804.0
2009-05-13 17:00:00	MSFT	Stock	19.69	19.76	19.69	19.75	10714.0
2009-05-13 18:00:00	MSFT	Stock	19.75	19.77	19.7	19.7	2201.0
2009-05-13 19:00:00	MSFT	Stock	19.7	19.73	19.68	19.68	4430.0
2009-05-13 08:00:00	NVDA	Stock	0.227	0.2275	0.223	0.223	1261600.0
2009-05-13 09:00:00	NVDA	Stock	0.223	0.2243	0.2188	0.22	181007840.0
2009-05-13 10:00:00	NVDA	Stock	0.2198	0.22	0.2128	0.2132	278432320.0
2009-05-13 11:00:00	NVDA	Stock	0.2132	0.2143	0.209	0.2092	203745280.0
2009-05-13 12:00:00	NVDA	Stock	0.2092	0.212	0.2082	0.2105	142572760.0
2009-05-13 13:00:00	NVDA	Stock	0.2105	0.2111	0.2088	0.2106	104329680.0
2009-05-13 14:00:00	NVDA	Stock	0.2108	0.2115	0.2095	0.2109	108905040.0
2009-05-13 15:00:00	NVDA	Stock	0.211	0.2112	0.209	0.21	207105240.0
2009-05-13 16:00:00	NVDA	Stock	0.21	0.2138	0.21	0.211	16532400.0
2009-05-13 17:00:00	NVDA	Stock	0.2102	0.2108	0.21	0.2108	402800.0
2009-05-13 18:00:00	NVDA	Stock	0.2108	0.2112	0.21	0.2112	301800.0
2009-05-13 19:00:00	NVDA	Stock	0.2112	0.2115	0.21	0.21	372000.0
2009-05-13 20:00:00	NVDA	Stock	0.2178	0.2178	0.2178	0.2178	37108000.0
2009-05-13 07:00:00	AMZN	Stock	3.885	3.885	3.885	3.885	6000.0
2009-05-13 08:00:00	AMZN	Stock	3.85	3.85	3.81	3.819	160000.0
2009-05-13 09:00:00	AMZN	Stock	3.8175	3.8325	3.7765	3.7855	23582260.0
2009-05-13 10:00:00	AMZN	Stock	3.7845	3.829	3.764	3.7755	35061280.0
2009-05-13 11:00:00	AMZN	Stock	3.7755	3.7995	3.7697	3.789	15781680.0
2009-05-13 12:00:00	AMZN	Stock	3.791	3.802	3.769	3.771	11081120.0
2009-05-13 13:00:00	AMZN	Stock	3.77	3.786	3.749	3.7855	18439260.0

> showing 50 of 41,690 rows — these rows as CSV

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