PREVIEW / stock_30min / 2007-07-13

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-07-13.parquet
  size:    1.1 MB
  rows:    65,012
  symbols: 3,050

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-07-13 09:30:00	AAPL	Stock	4.8225	4.8379	4.8043	4.8107	147047040.0
2007-07-13 10:00:00	AAPL	Stock	4.8107	4.8239	4.8064	4.8125	67108720.0
2007-07-13 10:30:00	AAPL	Stock	4.8123	4.8307	4.81	4.8246	54175408.0
2007-07-13 11:00:00	AAPL	Stock	4.8246	4.825	4.8143	4.8218	31583104.0
2007-07-13 11:30:00	AAPL	Stock	4.8221	4.8321	4.8182	4.825	42503216.0
2007-07-13 12:00:00	AAPL	Stock	4.825	4.8418	4.8201	4.8354	56805728.0
2007-07-13 12:30:00	AAPL	Stock	4.835	4.8514	4.8304	4.8457	54936112.0
2007-07-13 13:00:00	AAPL	Stock	4.8457	4.8482	4.8311	4.8426	35204428.0
2007-07-13 13:30:00	AAPL	Stock	4.8428	4.8496	4.8396	4.8407	26956664.0
2007-07-13 14:00:00	AAPL	Stock	4.8407	4.8625	4.8396	4.8568	54453000.0
2007-07-13 14:30:00	AAPL	Stock	4.8568	4.8768	4.8529	4.8739	56036932.0
2007-07-13 15:00:00	AAPL	Stock	4.8742	4.9104	4.8725	4.9093	110103168.0
2007-07-13 15:30:00	AAPL	Stock	4.9093	4.9232	4.8918	4.9164	111844320.0
2007-07-13 16:00:00	AAPL	Stock	4.9161	4.9189	4.9161	4.9189	4529168.0
2007-07-13 09:30:00	MSFT	Stock	29.94	30.02	29.88	29.92	5977402.0
2007-07-13 10:00:00	MSFT	Stock	29.92	29.99	29.81	29.83	3776000.0
2007-07-13 10:30:00	MSFT	Stock	29.83	29.9	29.76	29.87	2626890.0
2007-07-13 11:00:00	MSFT	Stock	29.87	29.89	29.85	29.86	1589155.0
2007-07-13 11:30:00	MSFT	Stock	29.87	29.87	29.74	29.74	2038237.0
2007-07-13 12:00:00	MSFT	Stock	29.74	29.79	29.72	29.74	2077238.0
2007-07-13 12:30:00	MSFT	Stock	29.74	29.76	29.66	29.68	2093806.0
2007-07-13 13:00:00	MSFT	Stock	29.68	29.76	29.67	29.73	2438368.0
2007-07-13 13:30:00	MSFT	Stock	29.731	29.82	29.72	29.75	2533811.0
2007-07-13 14:00:00	MSFT	Stock	29.76	29.76	29.67	29.69	2405704.0
2007-07-13 14:30:00	MSFT	Stock	29.7	29.81	29.68	29.77	4024414.0
2007-07-13 15:00:00	MSFT	Stock	29.77	29.84	29.74	29.82	3168585.0
2007-07-13 15:30:00	MSFT	Stock	29.82	29.88	29.77	29.81	4923501.0
2007-07-13 16:00:00	MSFT	Stock	29.81	29.82	29.8	29.82	1034073.0
2007-07-13 09:00:00	NVDA	Stock	0.7667	0.771	0.7667	0.7692	374820.0
2007-07-13 09:30:00	NVDA	Stock	0.767	0.7762	0.7637	0.7722	39602760.0
2007-07-13 10:00:00	NVDA	Stock	0.7723	0.7733	0.7695	0.7713	36149280.0
2007-07-13 10:30:00	NVDA	Stock	0.7713	0.7738	0.7698	0.7708	24623940.0
2007-07-13 11:00:00	NVDA	Stock	0.7709	0.771	0.7667	0.7693	20070960.0
2007-07-13 11:30:00	NVDA	Stock	0.7693	0.7717	0.7657	0.7658	18932220.0
2007-07-13 12:00:00	NVDA	Stock	0.7658	0.766	0.7642	0.7652	26457840.0
2007-07-13 12:30:00	NVDA	Stock	0.7652	0.7683	0.7648	0.7677	30880500.0
2007-07-13 13:00:00	NVDA	Stock	0.7677	0.7735	0.766	0.7672	16643940.0
2007-07-13 13:30:00	NVDA	Stock	0.7673	0.7697	0.7668	0.7678	11590800.0
2007-07-13 14:00:00	NVDA	Stock	0.7678	0.7693	0.7675	0.769	12549900.0
2007-07-13 14:30:00	NVDA	Stock	0.7691	0.7702	0.7682	0.7695	19310040.0
2007-07-13 15:00:00	NVDA	Stock	0.7693	0.7695	0.7653	0.7657	36797340.0
2007-07-13 15:30:00	NVDA	Stock	0.7657	0.766	0.764	0.7642	57616140.0
2007-07-13 16:00:00	NVDA	Stock	0.7642	0.7648	0.7642	0.7645	4698120.0
2007-07-13 16:30:00	NVDA	Stock	0.7685	0.7738	0.7667	0.7698	184860.0
2007-07-13 17:00:00	NVDA	Stock	0.766	0.776	0.7642	0.7667	2752380.0
2007-07-13 18:00:00	NVDA	Stock	0.7668	0.7668	0.7668	0.7668	12000.0
2007-07-13 07:30:00	AMZN	Stock	3.635	3.636	3.635	3.636	21500.0
2007-07-13 08:00:00	AMZN	Stock	3.6395	3.6515	3.6395	3.65	213600.0
2007-07-13 08:30:00	AMZN	Stock	3.645	3.6535	3.6425	3.645	67600.0
2007-07-13 09:00:00	AMZN	Stock	3.65	3.6725	3.6425	3.653	618120.0

> showing 50 of 65,012 rows — these rows as CSV

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