PREVIEW / stock_30min / 2007-05-31

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-05-31.parquet
  size:    1.1 MB
  rows:    64,826
  symbols: 3,012

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-05-31 09:30:00	AAPL	Stock	4.2882	4.3125	4.2729	4.2864	221660096.0
2007-05-31 10:00:00	AAPL	Stock	4.2857	4.2993	4.2693	4.2839	125230560.0
2007-05-31 10:30:00	AAPL	Stock	4.2839	4.2946	4.2768	4.2832	69873496.0
2007-05-31 11:00:00	AAPL	Stock	4.2829	4.2936	4.2718	4.2757	65084628.0
2007-05-31 11:30:00	AAPL	Stock	4.2757	4.3029	4.2757	4.2979	50198148.0
2007-05-31 12:00:00	AAPL	Stock	4.2979	4.3421	4.2911	4.3382	104178508.0
2007-05-31 12:30:00	AAPL	Stock	4.3382	4.3632	4.3346	4.3445	114745988.0
2007-05-31 13:00:00	AAPL	Stock	4.3443	4.3554	4.3079	4.3171	88854668.0
2007-05-31 13:30:00	AAPL	Stock	4.3175	4.33	4.3043	4.3256	61625312.0
2007-05-31 14:00:00	AAPL	Stock	4.325	4.3418	4.3225	4.3357	49361452.0
2007-05-31 14:30:00	AAPL	Stock	4.3357	4.3579	4.3336	4.3393	77245252.0
2007-05-31 15:00:00	AAPL	Stock	4.3396	4.3454	4.3164	4.3175	67069632.0
2007-05-31 15:30:00	AAPL	Stock	4.3179	4.3379	4.3	4.3336	124179524.0
2007-05-31 16:00:00	AAPL	Stock	4.3346	4.3414	4.3282	4.3282	37493036.0
2007-05-31 09:30:00	MSFT	Stock	31.12	31.16	30.96	30.96	6524388.0
2007-05-31 10:00:00	MSFT	Stock	30.96	31.03	30.9	30.92	4191987.0
2007-05-31 10:30:00	MSFT	Stock	30.93	30.95	30.87	30.89	3496691.0
2007-05-31 11:00:00	MSFT	Stock	30.9	30.9	30.78	30.81	3094059.0
2007-05-31 11:30:00	MSFT	Stock	30.82	30.91	30.81	30.85	2030547.0
2007-05-31 12:00:00	MSFT	Stock	30.86	30.89	30.82	30.88	2052322.0
2007-05-31 12:30:00	MSFT	Stock	30.89	30.9	30.84	30.87	3141696.0
2007-05-31 13:00:00	MSFT	Stock	30.87	30.87	30.7	30.73	4703189.0
2007-05-31 13:30:00	MSFT	Stock	30.735	30.78	30.64	30.67	3962634.0
2007-05-31 14:00:00	MSFT	Stock	30.67	30.76	30.66	30.73	3096264.0
2007-05-31 14:30:00	MSFT	Stock	30.73	30.79	30.71	30.74	3087203.0
2007-05-31 15:00:00	MSFT	Stock	30.75	30.76	30.67	30.682	5311747.0
2007-05-31 15:30:00	MSFT	Stock	30.69	30.91	30.61	30.68	10873669.0
2007-05-31 16:00:00	MSFT	Stock	30.68	30.72	30.67	30.69	9820404.0
2007-05-31 08:30:00	NVDA	Stock	0.5723	0.5723	0.5687	0.5687	70500.0
2007-05-31 09:00:00	NVDA	Stock	0.5703	0.5723	0.5702	0.5723	246000.0
2007-05-31 09:30:00	NVDA	Stock	0.5707	0.5773	0.5698	0.5765	42414960.0
2007-05-31 10:00:00	NVDA	Stock	0.5765	0.5795	0.574	0.5753	40770600.0
2007-05-31 10:30:00	NVDA	Stock	0.5755	0.5808	0.5753	0.5808	39570300.0
2007-05-31 11:00:00	NVDA	Stock	0.5808	0.5808	0.5778	0.578	37755720.0
2007-05-31 11:30:00	NVDA	Stock	0.578	0.5793	0.5777	0.578	26263140.0
2007-05-31 12:00:00	NVDA	Stock	0.578	0.5783	0.576	0.5762	23402520.0
2007-05-31 12:30:00	NVDA	Stock	0.5762	0.5767	0.574	0.5758	24785580.0
2007-05-31 13:00:00	NVDA	Stock	0.5758	0.5775	0.5735	0.5748	30097440.0
2007-05-31 13:30:00	NVDA	Stock	0.575	0.576	0.5733	0.5753	23497620.0
2007-05-31 14:00:00	NVDA	Stock	0.5753	0.5775	0.5752	0.5755	23338260.0
2007-05-31 14:30:00	NVDA	Stock	0.5753	0.577	0.575	0.5755	26244300.0
2007-05-31 15:00:00	NVDA	Stock	0.5755	0.5782	0.5752	0.5765	40510260.0
2007-05-31 15:30:00	NVDA	Stock	0.5765	0.5778	0.5755	0.5772	59792940.0
2007-05-31 16:00:00	NVDA	Stock	0.5778	0.5798	0.5772	0.5798	846780.0
2007-05-31 16:30:00	NVDA	Stock	0.5778	0.58	0.5778	0.58	411600.0
2007-05-31 17:30:00	NVDA	Stock	0.5773	0.5773	0.5773	0.5773	93032760.0
2007-05-31 18:00:00	NVDA	Stock	0.5773	0.5773	0.5773	0.5773	199999980.0
2007-05-31 18:30:00	NVDA	Stock	0.5798	0.5798	0.5798	0.5798	21000.0
2007-05-31 19:00:00	NVDA	Stock	0.58	0.58	0.5792	0.5792	35580.0
2007-05-31 06:30:00	AMZN	Stock	3.5425	3.5425	3.5425	3.5425	2000.0

> showing 50 of 64,826 rows — these rows as CSV

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