PREVIEW / stock_1hour / 2009-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-14.parquet
  size:    832 KB
  rows:    40,652
  symbols: 3,344

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-07-14 07:00:00	AAPL	Stock	5.125	5.125	5.0714	5.0893	193088.0
2009-07-14 08:00:00	AAPL	Stock	5.0875	5.0893	5.0679	5.0707	1213660.0
2009-07-14 09:00:00	AAPL	Stock	5.0679	5.1136	5.0415	5.0506	73965556.0
2009-07-14 10:00:00	AAPL	Stock	5.0518	5.0864	5.0464	5.0779	61939276.0
2009-07-14 11:00:00	AAPL	Stock	5.0779	5.1043	5.0743	5.0879	40244876.0
2009-07-14 12:00:00	AAPL	Stock	5.0882	5.0889	5.065	5.0793	30219336.0
2009-07-14 13:00:00	AAPL	Stock	5.08	5.0893	5.0743	5.0789	19574240.0
2009-07-14 14:00:00	AAPL	Stock	5.0789	5.0893	5.0679	5.0825	34148352.0
2009-07-14 15:00:00	AAPL	Stock	5.0818	5.0875	5.0571	5.0811	69111112.0
2009-07-14 16:00:00	AAPL	Stock	5.08	5.1518	5.0624	5.1504	11967704.0
2009-07-14 17:00:00	AAPL	Stock	5.1518	5.1714	5.0783	5.1607	2503256.0
2009-07-14 18:00:00	AAPL	Stock	5.1607	5.1607	5.0811	5.1557	445760.0
2009-07-14 19:00:00	AAPL	Stock	5.1571	5.1643	5.1571	5.1607	133168.0
2009-07-14 08:00:00	MSFT	Stock	23.16	23.25	23.13	23.16	14035.0
2009-07-14 09:00:00	MSFT	Stock	23.17	23.31	22.92	23.08	7474335.0
2009-07-14 10:00:00	MSFT	Stock	23.08	23.2	22.86	22.907	6835901.0
2009-07-14 11:00:00	MSFT	Stock	22.91	23.22	22.9	23.205	5227635.0
2009-07-14 12:00:00	MSFT	Stock	23.2	23.21	23.07	23.12	3444527.0
2009-07-14 13:00:00	MSFT	Stock	23.11	23.13	23.06	23.07	3108430.0
2009-07-14 14:00:00	MSFT	Stock	23.072	23.11	23.01	23.05	4778425.0
2009-07-14 15:00:00	MSFT	Stock	23.06	23.11	22.95	23.11	10788437.0
2009-07-14 16:00:00	MSFT	Stock	23.1	23.9	23.056	23.79	2507921.0
2009-07-14 17:00:00	MSFT	Stock	23.76	23.81	23.055	23.72	121751.0
2009-07-14 18:00:00	MSFT	Stock	23.72	23.75	23.11	23.72	44499.0
2009-07-14 19:00:00	MSFT	Stock	23.75	23.76	23.71	23.76	8843.0
2009-07-14 08:00:00	NVDA	Stock	0.2625	0.2625	0.2625	0.2625	20000.0
2009-07-14 09:00:00	NVDA	Stock	0.2625	0.267	0.2623	0.2635	69606280.0
2009-07-14 10:00:00	NVDA	Stock	0.2635	0.2663	0.2612	0.262	81817000.0
2009-07-14 11:00:00	NVDA	Stock	0.2623	0.268	0.2623	0.2678	41440920.0
2009-07-14 12:00:00	NVDA	Stock	0.2678	0.268	0.264	0.2655	29557760.0
2009-07-14 13:00:00	NVDA	Stock	0.2658	0.2678	0.265	0.267	28951200.0
2009-07-14 14:00:00	NVDA	Stock	0.267	0.2683	0.2663	0.2675	50947240.0
2009-07-14 15:00:00	NVDA	Stock	0.2672	0.2688	0.2663	0.2678	121837400.0
2009-07-14 16:00:00	NVDA	Stock	0.2675	0.278	0.2638	0.2763	20817280.0
2009-07-14 17:00:00	NVDA	Stock	0.2763	0.2775	0.2748	0.2763	1207080.0
2009-07-14 18:00:00	NVDA	Stock	0.2763	0.278	0.276	0.278	318800.0
2009-07-14 19:00:00	NVDA	Stock	0.277	0.28	0.2763	0.2763	96400.0
2009-07-14 07:00:00	AMZN	Stock	4.0995	4.0995	4.0995	4.0995	2000.0
2009-07-14 08:00:00	AMZN	Stock	4.0675	4.085	4.0675	4.071	107440.0
2009-07-14 09:00:00	AMZN	Stock	4.063	4.086	4.021	4.026	14636460.0
2009-07-14 10:00:00	AMZN	Stock	4.0255	4.064	4.0225	4.0325	16624200.0
2009-07-14 11:00:00	AMZN	Stock	4.0325	4.0795	4.0292	4.0735	9938380.0
2009-07-14 12:00:00	AMZN	Stock	4.0735	4.094	4.0634	4.091	8539280.0
2009-07-14 13:00:00	AMZN	Stock	4.0895	4.106	4.0855	4.0955	8521900.0
2009-07-14 14:00:00	AMZN	Stock	4.096	4.121	4.0845	4.1165	10007140.0
2009-07-14 15:00:00	AMZN	Stock	4.1155	4.1185	4.0845	4.0975	19286720.0
2009-07-14 16:00:00	AMZN	Stock	4.104	4.1275	4.0414	4.0975	854240.0
2009-07-14 17:00:00	AMZN	Stock	4.13	4.13	4.125	4.125	18000.0
2009-07-14 18:00:00	AMZN	Stock	4.1245	4.135	4.1245	4.1345	115280.0
2009-07-14 19:00:00	AMZN	Stock	4.1385	4.1385	4.1325	4.138	31000.0

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

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