PREVIEW / stock_1hour / 2007-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-08.parquet
  size:    824 KB
  rows:    40,415
  symbols: 3,195

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-11-08 05:00:00	AAPL	Stock	6.6154	6.6154	6.6154	6.6154	5600.0
2007-11-08 06:00:00	AAPL	Stock	6.6304	6.6786	6.6304	6.6786	67200.0
2007-11-08 07:00:00	AAPL	Stock	6.6964	6.7232	6.6804	6.7054	1289260.0
2007-11-08 08:00:00	AAPL	Stock	6.7136	6.7321	6.6629	6.6679	4825996.0
2007-11-08 09:00:00	AAPL	Stock	6.6686	6.6875	6.4471	6.5971	189973896.0
2007-11-08 10:00:00	AAPL	Stock	6.5986	6.5993	6.4793	6.5596	211767332.0
2007-11-08 11:00:00	AAPL	Stock	6.5593	6.5696	6.2896	6.3607	202863388.0
2007-11-08 12:00:00	AAPL	Stock	6.3607	6.3979	6.1407	6.2621	339450916.0
2007-11-08 13:00:00	AAPL	Stock	6.2625	6.2829	5.9918	6.2696	365684088.0
2007-11-08 14:00:00	AAPL	Stock	6.2686	6.3	6.1218	6.2904	213325168.0
2007-11-08 15:00:00	AAPL	Stock	6.2904	6.4821	6.2546	6.2671	338971892.0
2007-11-08 16:00:00	AAPL	Stock	6.2665	6.6632	6.1	6.2679	23104956.0
2007-11-08 17:00:00	AAPL	Stock	6.265	6.3781	6.2557	6.27	1596616.0
2007-11-08 18:00:00	AAPL	Stock	6.2746	6.2857	6.26	6.2782	865788.0
2007-11-08 19:00:00	AAPL	Stock	6.2839	6.3232	6.2714	6.3214	711872.0
2007-11-08 20:00:00	AAPL	Stock	6.3214	6.3214	6.3214	6.3214	25200.0
2007-11-08 05:00:00	MSFT	Stock	35.04	35.04	35.04	35.04	500.0
2007-11-08 06:00:00	MSFT	Stock	35.04	35.25	35.04	35.25	3116.0
2007-11-08 07:00:00	MSFT	Stock	35.25	35.48	35.2	35.22	4800.0
2007-11-08 08:00:00	MSFT	Stock	35.22	35.5	35.15	35.4	34903.0
2007-11-08 09:00:00	MSFT	Stock	35.37	35.75	35.37	35.6	9021407.0
2007-11-08 10:00:00	MSFT	Stock	35.6	35.9	35.46	35.66	17683021.0
2007-11-08 11:00:00	MSFT	Stock	35.67	35.71	35.45	35.62	11156384.0
2007-11-08 12:00:00	MSFT	Stock	35.62	35.69	34.97	34.98	14743138.0
2007-11-08 13:00:00	MSFT	Stock	34.98	35.04	34.66	34.91	20605784.0
2007-11-08 14:00:00	MSFT	Stock	34.91	34.92	34.53	34.692	15222553.0
2007-11-08 15:00:00	MSFT	Stock	34.7	34.99	34.4	34.71	30218977.0
2007-11-08 16:00:00	MSFT	Stock	34.75	35.626	34.7	34.74	4053169.0
2007-11-08 17:00:00	MSFT	Stock	34.74	35.79	34.51	34.81	10998632.0
2007-11-08 18:00:00	MSFT	Stock	34.81	34.98	34.69	34.7	5035.0
2007-11-08 19:00:00	MSFT	Stock	34.7	34.97	34.7	34.81	1548.0
2007-11-08 04:00:00	NVDA	Stock	0.8938	0.8938	0.8938	0.8938	6000.0
2007-11-08 06:00:00	NVDA	Stock	0.8968	0.898	0.8968	0.898	8000.0
2007-11-08 07:00:00	NVDA	Stock	0.8995	0.9	0.8995	0.9	44000.0
2007-11-08 08:00:00	NVDA	Stock	0.9012	0.9015	0.8888	0.9	364560.0
2007-11-08 09:00:00	NVDA	Stock	0.9	0.9	0.864	0.8752	68560520.0
2007-11-08 10:00:00	NVDA	Stock	0.8748	0.8922	0.8675	0.8918	82609720.0
2007-11-08 11:00:00	NVDA	Stock	0.8918	0.91	0.8878	0.902	87741560.0
2007-11-08 12:00:00	NVDA	Stock	0.902	0.9045	0.86	0.8635	85284600.0
2007-11-08 13:00:00	NVDA	Stock	0.8637	0.8645	0.8458	0.8592	106873760.0
2007-11-08 14:00:00	NVDA	Stock	0.8595	0.8632	0.8203	0.8428	188332360.0
2007-11-08 15:00:00	NVDA	Stock	0.8432	0.8585	0.8292	0.845	242178280.0
2007-11-08 16:00:00	NVDA	Stock	0.846	0.8864	0.8	0.8288	62570280.0
2007-11-08 17:00:00	NVDA	Stock	0.8298	0.9295	0.8102	0.9162	62791240.0
2007-11-08 18:00:00	NVDA	Stock	0.9162	0.9188	0.9075	0.911	6905120.0
2007-11-08 19:00:00	NVDA	Stock	0.9125	0.9125	0.9078	0.9125	1188520.0
2007-11-08 08:00:00	AMZN	Stock	4.324	4.3525	4.3135	4.3135	196360.0
2007-11-08 09:00:00	AMZN	Stock	4.3445	4.3522	4.2335	4.254	40104680.0
2007-11-08 10:00:00	AMZN	Stock	4.2515	4.2705	4.214	4.2525	26164760.0
2007-11-08 11:00:00	AMZN	Stock	4.252	4.2655	4.1875	4.2005	19111180.0

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

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