PREVIEW / stock_1hour / 2008-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-03.parquet
  size:    827 KB
  rows:    39,804
  symbols: 3,290

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-09-03 07:00:00	AAPL	Stock	5.9496	5.9496	5.9357	5.9371	53200.0
2008-09-03 08:00:00	AAPL	Stock	5.9414	5.9696	5.9393	5.9639	1956108.0
2008-09-03 09:00:00	AAPL	Stock	5.9629	5.9989	5.9354	5.9782	87910676.0
2008-09-03 10:00:00	AAPL	Stock	5.9771	6.0243	5.9579	5.9675	107942156.0
2008-09-03 11:00:00	AAPL	Stock	5.9671	5.9975	5.8707	5.8939	103898340.0
2008-09-03 12:00:00	AAPL	Stock	5.8939	5.9093	5.8571	5.9029	60115468.0
2008-09-03 13:00:00	AAPL	Stock	5.9025	6.0007	5.8879	5.9696	99755180.0
2008-09-03 14:00:00	AAPL	Stock	5.9704	5.9911	5.9161	5.9311	133029484.0
2008-09-03 15:00:00	AAPL	Stock	5.9293	5.9729	5.8932	5.9607	115671108.0
2008-09-03 16:00:00	AAPL	Stock	5.9636	5.9864	5.9435	5.9629	15888656.0
2008-09-03 17:00:00	AAPL	Stock	5.9643	5.9661	5.9629	5.9632	99988.0
2008-09-03 18:00:00	AAPL	Stock	5.9643	5.9729	5.9632	5.9729	92596.0
2008-09-03 19:00:00	AAPL	Stock	5.9732	5.9743	5.9661	5.9711	47068.0
2008-09-03 06:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	100.0
2008-09-03 07:00:00	MSFT	Stock	26.86	27.0	26.79	26.8	4720.0
2008-09-03 08:00:00	MSFT	Stock	26.88	27.1	26.86	27.03	770349.0
2008-09-03 09:00:00	MSFT	Stock	27.0	27.07	26.89	27.0	6033908.0
2008-09-03 10:00:00	MSFT	Stock	27.0	27.18	26.9	26.98	9341145.0
2008-09-03 11:00:00	MSFT	Stock	26.99	27.04	26.89	26.95	8665294.0
2008-09-03 12:00:00	MSFT	Stock	26.95	26.96	26.89	26.91	5820796.0
2008-09-03 13:00:00	MSFT	Stock	26.915	27.02	26.84	26.98	7280345.0
2008-09-03 14:00:00	MSFT	Stock	26.99	27.08	26.88	26.91	6606006.0
2008-09-03 15:00:00	MSFT	Stock	26.92	27.06	26.88	26.93	10063401.0
2008-09-03 16:00:00	MSFT	Stock	26.94	27.06	26.9	26.9	2160923.0
2008-09-03 17:00:00	MSFT	Stock	26.91	26.94	26.91	26.92	747.0
2008-09-03 18:00:00	MSFT	Stock	26.92	26.93	26.92	26.93	315.0
2008-09-03 19:00:00	MSFT	Stock	26.94	26.94	26.93	26.93	620.0
2008-09-03 08:00:00	NVDA	Stock	0.3062	0.3062	0.3012	0.3025	240000.0
2008-09-03 09:00:00	NVDA	Stock	0.3025	0.305	0.2992	0.302	100438000.0
2008-09-03 10:00:00	NVDA	Stock	0.3022	0.3042	0.2982	0.3001	123365080.0
2008-09-03 11:00:00	NVDA	Stock	0.3001	0.301	0.294	0.296	129015200.0
2008-09-03 12:00:00	NVDA	Stock	0.296	0.296	0.2922	0.2932	69858320.0
2008-09-03 13:00:00	NVDA	Stock	0.2932	0.295	0.2922	0.2948	46348160.0
2008-09-03 14:00:00	NVDA	Stock	0.2948	0.295	0.29	0.2902	88207960.0
2008-09-03 15:00:00	NVDA	Stock	0.2902	0.2918	0.2888	0.2915	133956440.0
2008-09-03 16:00:00	NVDA	Stock	0.2915	0.2961	0.2915	0.2915	2132640.0
2008-09-03 17:00:00	NVDA	Stock	0.2918	0.2918	0.2918	0.2918	74000.0
2008-09-03 18:00:00	NVDA	Stock	0.2922	0.2938	0.292	0.2938	234000.0
2008-09-03 19:00:00	NVDA	Stock	0.2938	0.2938	0.2925	0.2938	102840.0
2008-09-03 08:00:00	AMZN	Stock	4.05	4.095	4.05	4.095	91400.0
2008-09-03 09:00:00	AMZN	Stock	4.0875	4.1	4.0132	4.03	14053160.0
2008-09-03 10:00:00	AMZN	Stock	4.03	4.0705	4.001	4.054	25285460.0
2008-09-03 11:00:00	AMZN	Stock	4.056	4.064	4.014	4.0225	14333980.0
2008-09-03 12:00:00	AMZN	Stock	4.021	4.053	4.0075	4.048	10950980.0
2008-09-03 13:00:00	AMZN	Stock	4.048	4.081	4.039	4.061	9679460.0
2008-09-03 14:00:00	AMZN	Stock	4.0605	4.077	4.036	4.0435	13436360.0
2008-09-03 15:00:00	AMZN	Stock	4.0415	4.0552	4.0175	4.0385	23159420.0
2008-09-03 16:00:00	AMZN	Stock	4.0385	4.0451	4.0345	4.0385	2715000.0
2008-09-03 17:00:00	AMZN	Stock	4.0345	4.0395	4.0345	4.0395	24800.0
2008-09-03 09:00:00	TLT	Stock	94.26	94.5	94.25	94.36	199781.0

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

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