PREVIEW / stock_1hour / 2007-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-08.parquet
  size:    808 KB
  rows:    39,369
  symbols: 3,122

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
2007-08-08 09:00:00	AAPL	Stock	4.8843	4.8879	4.7989	4.8157	105577332.0
2007-08-08 10:00:00	AAPL	Stock	4.8157	4.8325	4.7804	4.7925	152168968.0
2007-08-08 11:00:00	AAPL	Stock	4.7929	4.825	4.7768	4.8064	102375168.0
2007-08-08 12:00:00	AAPL	Stock	4.8057	4.8068	4.7889	4.7929	57243396.0
2007-08-08 13:00:00	AAPL	Stock	4.7921	4.8221	4.7904	4.8194	65774296.0
2007-08-08 14:00:00	AAPL	Stock	4.82	4.8396	4.7857	4.7964	105756952.0
2007-08-08 15:00:00	AAPL	Stock	4.7964	4.8082	4.7143	4.7707	165266892.0
2007-08-08 16:00:00	AAPL	Stock	4.7707	4.7861	4.7639	4.7857	11519480.0
2007-08-08 09:00:00	MSFT	Stock	29.72	29.72	29.21	29.58	4608749.0
2007-08-08 10:00:00	MSFT	Stock	29.59	29.65	29.51	29.57	5670826.0
2007-08-08 11:00:00	MSFT	Stock	29.561	29.63	29.47	29.58	3620538.0
2007-08-08 12:00:00	MSFT	Stock	29.57	29.66	29.54	29.58	4082543.0
2007-08-08 13:00:00	MSFT	Stock	29.58	29.76	29.54	29.7	6558323.0
2007-08-08 14:00:00	MSFT	Stock	29.71	29.86	29.65	29.7	6454699.0
2007-08-08 15:00:00	MSFT	Stock	29.71	29.95	29.56	29.95	12183296.0
2007-08-08 16:00:00	MSFT	Stock	29.95	30.01	29.82	29.9	3036605.0
2007-08-08 08:00:00	NVDA	Stock	0.7408	0.7467	0.7383	0.7417	324000.0
2007-08-08 09:00:00	NVDA	Stock	0.7403	0.7642	0.7338	0.7588	98851500.0
2007-08-08 10:00:00	NVDA	Stock	0.7587	0.7663	0.7533	0.7637	110942700.0
2007-08-08 11:00:00	NVDA	Stock	0.7638	0.764	0.7553	0.7575	72864900.0
2007-08-08 12:00:00	NVDA	Stock	0.7575	0.7658	0.7497	0.7627	67832400.0
2007-08-08 13:00:00	NVDA	Stock	0.7627	0.775	0.7605	0.7748	63990300.0
2007-08-08 14:00:00	NVDA	Stock	0.7748	0.7825	0.7625	0.7628	91298940.0
2007-08-08 15:00:00	NVDA	Stock	0.7635	0.7655	0.75	0.76	109484760.0
2007-08-08 16:00:00	NVDA	Stock	0.76	0.7623	0.7597	0.7622	14673360.0
2007-08-08 17:00:00	NVDA	Stock	0.7648	0.7665	0.7648	0.7655	281220.0
2007-08-08 18:00:00	NVDA	Stock	0.7665	0.7733	0.7663	0.7722	727800.0
2007-08-08 19:00:00	NVDA	Stock	0.7717	0.7745	0.7715	0.7717	382320.0
2007-08-08 06:00:00	AMZN	Stock	4.0	4.025	4.0	4.0	8000.0
2007-08-08 08:00:00	AMZN	Stock	3.995	3.995	3.98	3.981	135320.0
2007-08-08 09:00:00	AMZN	Stock	3.9825	3.994	3.91	3.9195	15529700.0
2007-08-08 10:00:00	AMZN	Stock	3.9195	3.991	3.895	3.988	33828300.0
2007-08-08 11:00:00	AMZN	Stock	3.9873	3.988	3.95	3.9515	15211080.0
2007-08-08 12:00:00	AMZN	Stock	3.9515	3.9635	3.9465	3.952	10752320.0
2007-08-08 13:00:00	AMZN	Stock	3.952	3.9845	3.952	3.969	11928040.0
2007-08-08 14:00:00	AMZN	Stock	3.9685	3.9935	3.9275	3.9295	18201240.0
2007-08-08 15:00:00	AMZN	Stock	3.9295	3.931	3.828	3.889	41967160.0
2007-08-08 16:00:00	AMZN	Stock	3.879	3.8905	3.8515	3.8875	5972940.0
2007-08-08 17:00:00	AMZN	Stock	3.88	3.889	3.875	3.875	52940.0
2007-08-08 18:00:00	AMZN	Stock	3.8875	3.889	3.8875	3.889	18200.0
2007-08-08 19:00:00	AMZN	Stock	3.8945	3.8945	3.8945	3.8945	9600.0
2007-08-08 09:00:00	TLT	Stock	86.89	86.89	86.52	86.57	763500.0
2007-08-08 10:00:00	TLT	Stock	86.57	86.61	86.34	86.42	1030700.0
2007-08-08 11:00:00	TLT	Stock	86.41	86.48	86.35	86.45	1539300.0
2007-08-08 12:00:00	TLT	Stock	86.43	86.46	86.28	86.29	1571100.0
2007-08-08 13:00:00	TLT	Stock	86.29	86.29	86.02	86.06	527500.0
2007-08-08 14:00:00	TLT	Stock	86.07	86.15	85.86	86.13	519800.0
2007-08-08 15:00:00	TLT	Stock	86.16	86.28	86.1	86.17	467268.0
2007-08-08 16:00:00	TLT	Stock	86.14	86.17	86.14	86.16	800.0
2007-08-08 08:00:00	CL	Stock	34.5	34.5	34.5	34.5	800.0

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

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