PREVIEW / stock_1hour / 2009-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-20.parquet
  size:    899 KB
  rows:    42,948
  symbols: 3,394

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-10-20 04:00:00	AAPL	Stock	7.1429	7.1718	7.12	7.1293	80416.0
2009-10-20 05:00:00	AAPL	Stock	7.1257	7.1786	7.125	7.1786	233744.0
2009-10-20 06:00:00	AAPL	Stock	7.1796	7.2	7.175	7.2	571228.0
2009-10-20 07:00:00	AAPL	Stock	7.1929	7.2496	7.1929	7.2393	4179308.0
2009-10-20 08:00:00	AAPL	Stock	7.2107	7.2582	7.1996	7.2125	23991744.0
2009-10-20 09:00:00	AAPL	Stock	7.2143	7.2246	7.0893	7.1129	336058212.0
2009-10-20 10:00:00	AAPL	Stock	7.1125	7.1554	7.0757	7.1461	208987100.0
2009-10-20 11:00:00	AAPL	Stock	7.1461	7.1675	7.1111	7.1225	111968892.0
2009-10-20 12:00:00	AAPL	Stock	7.1232	7.1311	7.0661	7.0904	102956560.0
2009-10-20 13:00:00	AAPL	Stock	7.0904	7.1261	7.0876	7.1032	65310924.0
2009-10-20 14:00:00	AAPL	Stock	7.1021	7.1357	7.0982	7.1146	82858804.0
2009-10-20 15:00:00	AAPL	Stock	7.1153	7.1207	7.0857	7.1	98627872.0
2009-10-20 16:00:00	AAPL	Stock	7.0993	7.1282	7.0714	7.0857	14728448.0
2009-10-20 17:00:00	AAPL	Stock	7.0829	7.0986	7.065	7.0696	1571584.0
2009-10-20 18:00:00	AAPL	Stock	7.0693	7.1518	7.0679	7.1243	7372736.0
2009-10-20 19:00:00	AAPL	Stock	7.1214	7.1321	7.1211	7.1307	688184.0
2009-10-20 05:00:00	MSFT	Stock	26.52	26.58	26.52	26.58	372.0
2009-10-20 07:00:00	MSFT	Stock	26.52	26.57	26.46	26.46	3000.0
2009-10-20 08:00:00	MSFT	Stock	26.47	26.5	26.38	26.38	46578.0
2009-10-20 09:00:00	MSFT	Stock	26.4	26.43	26.03	26.2	7252023.0
2009-10-20 10:00:00	MSFT	Stock	26.19	26.23	26.1	26.22	5464639.0
2009-10-20 11:00:00	MSFT	Stock	26.229	26.229	25.94	26.01	8294664.0
2009-10-20 12:00:00	MSFT	Stock	26.005	26.09	25.95	26.04	5126552.0
2009-10-20 13:00:00	MSFT	Stock	26.05	26.17	26.03	26.14	4437042.0
2009-10-20 14:00:00	MSFT	Stock	26.144	26.28	26.13	26.28	6030307.0
2009-10-20 15:00:00	MSFT	Stock	26.27	26.45	26.21	26.37	11604288.0
2009-10-20 16:00:00	MSFT	Stock	26.38	26.45	26.148	26.35	3474294.0
2009-10-20 17:00:00	MSFT	Stock	26.37	26.37	26.34	26.36	201700.0
2009-10-20 18:00:00	MSFT	Stock	26.37	26.37	26.3	26.36	12099.0
2009-10-20 19:00:00	MSFT	Stock	26.35	26.45	26.35	26.45	5313.0
2009-10-20 08:00:00	NVDA	Stock	0.347	0.347	0.3428	0.345	182840.0
2009-10-20 09:00:00	NVDA	Stock	0.345	0.3505	0.345	0.3498	115357200.0
2009-10-20 10:00:00	NVDA	Stock	0.3498	0.3508	0.347	0.349	187575520.0
2009-10-20 11:00:00	NVDA	Stock	0.349	0.3495	0.3438	0.3453	113795280.0
2009-10-20 12:00:00	NVDA	Stock	0.3455	0.3458	0.34	0.3429	69713200.0
2009-10-20 13:00:00	NVDA	Stock	0.3428	0.3455	0.3425	0.3433	41313360.0
2009-10-20 14:00:00	NVDA	Stock	0.343	0.3449	0.3428	0.3435	40165160.0
2009-10-20 15:00:00	NVDA	Stock	0.3435	0.3436	0.3404	0.3428	75573600.0
2009-10-20 16:00:00	NVDA	Stock	0.3428	0.3464	0.3418	0.3428	10014200.0
2009-10-20 17:00:00	NVDA	Stock	0.3428	0.3428	0.342	0.342	551400.0
2009-10-20 06:00:00	AMZN	Stock	4.7605	4.7605	4.7605	4.7605	10000.0
2009-10-20 07:00:00	AMZN	Stock	4.787	4.8145	4.787	4.8145	19100.0
2009-10-20 08:00:00	AMZN	Stock	4.8145	4.822	4.801	4.8095	242200.0
2009-10-20 09:00:00	AMZN	Stock	4.8075	4.8085	4.75	4.775	22830400.0
2009-10-20 10:00:00	AMZN	Stock	4.774	4.777	4.729	4.7635	40256400.0
2009-10-20 11:00:00	AMZN	Stock	4.763	4.7645	4.7225	4.7475	22023640.0
2009-10-20 12:00:00	AMZN	Stock	4.7475	4.7525	4.7135	4.719	17065460.0
2009-10-20 13:00:00	AMZN	Stock	4.718	4.746	4.7175	4.7315	9743900.0
2009-10-20 14:00:00	AMZN	Stock	4.7315	4.753	4.73	4.74	13221820.0
2009-10-20 15:00:00	AMZN	Stock	4.7403	4.7595	4.722	4.75	26352180.0

> showing 50 of 42,948 rows — these rows as CSV

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