PREVIEW / stock_30min / 2008-04-30

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-30.parquet
  size:    1.3 MB
  rows:    69,165
  symbols: 3,289

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-04-30 04:00:00	AAPL	Stock	6.2318	6.2318	6.2318	6.2318	2800.0
2008-04-30 06:30:00	AAPL	Stock	6.2336	6.2336	6.2336	6.2336	2800.0
2008-04-30 07:30:00	AAPL	Stock	6.2668	6.2668	6.25	6.25	169400.0
2008-04-30 08:00:00	AAPL	Stock	6.2529	6.2889	6.2446	6.2821	3010308.0
2008-04-30 08:30:00	AAPL	Stock	6.2843	6.3071	6.2543	6.3011	4012372.0
2008-04-30 09:00:00	AAPL	Stock	6.3018	6.3107	6.2907	6.2932	2468144.0
2008-04-30 09:30:00	AAPL	Stock	6.2932	6.3782	6.2786	6.3582	178765356.0
2008-04-30 10:00:00	AAPL	Stock	6.3582	6.3654	6.3275	6.3411	74633300.0
2008-04-30 10:30:00	AAPL	Stock	6.3407	6.3757	6.3375	6.3663	64145452.0
2008-04-30 11:00:00	AAPL	Stock	6.3664	6.3875	6.3655	6.3807	56077588.0
2008-04-30 11:30:00	AAPL	Stock	6.3807	6.3839	6.3443	6.3614	48552588.0
2008-04-30 12:00:00	AAPL	Stock	6.3621	6.3711	6.3254	6.3317	42180292.0
2008-04-30 12:30:00	AAPL	Stock	6.3311	6.4286	6.3254	6.3479	30973488.0
2008-04-30 13:00:00	AAPL	Stock	6.3469	6.3686	6.3443	6.3514	26874484.0
2008-04-30 13:30:00	AAPL	Stock	6.3514	6.3604	6.3429	6.3529	30294628.0
2008-04-30 14:00:00	AAPL	Stock	6.3532	6.3711	6.3132	6.3475	93827272.0
2008-04-30 14:30:00	AAPL	Stock	6.3461	6.3596	6.2461	6.2468	105697340.0
2008-04-30 15:00:00	AAPL	Stock	6.2464	6.255	6.1757	6.209	208118176.0
2008-04-30 15:30:00	AAPL	Stock	6.2083	6.2643	6.2083	6.2179	120076152.0
2008-04-30 16:00:00	AAPL	Stock	6.2179	6.3302	6.2089	6.2214	19186076.0
2008-04-30 16:30:00	AAPL	Stock	6.2214	6.2518	6.2125	6.2196	1616356.0
2008-04-30 17:00:00	AAPL	Stock	6.2196	6.2314	6.2125	6.2311	612472.0
2008-04-30 17:30:00	AAPL	Stock	6.3426	6.3426	6.225	6.2318	727468.0
2008-04-30 18:00:00	AAPL	Stock	6.2318	6.2371	6.2125	6.2357	297192.0
2008-04-30 18:30:00	AAPL	Stock	6.2332	6.2371	6.1504	6.2357	99456.0
2008-04-30 19:00:00	AAPL	Stock	6.2343	6.2375	6.2325	6.2375	137312.0
2008-04-30 19:30:00	AAPL	Stock	6.2368	6.2407	6.2329	6.2354	288736.0
2008-04-30 07:00:00	MSFT	Stock	28.7	28.7	28.69	28.69	600.0
2008-04-30 07:30:00	MSFT	Stock	28.78	28.78	28.78	28.78	100.0
2008-04-30 08:00:00	MSFT	Stock	28.7	28.78	28.7	28.73	7516.0
2008-04-30 08:30:00	MSFT	Stock	28.74	28.85	28.74	28.79	22922.0
2008-04-30 09:00:00	MSFT	Stock	28.79	28.85	28.74	28.74	39246.0
2008-04-30 09:30:00	MSFT	Stock	28.74	28.8	28.52	28.56	6510519.0
2008-04-30 10:00:00	MSFT	Stock	28.56	28.75	28.52	28.74	4345079.0
2008-04-30 10:30:00	MSFT	Stock	28.73	28.96	28.73	28.84	4332009.0
2008-04-30 11:00:00	MSFT	Stock	28.85	29.18	28.83	29.11	5300803.0
2008-04-30 11:30:00	MSFT	Stock	29.1	29.21	29.06	29.128	3728879.0
2008-04-30 12:00:00	MSFT	Stock	29.13	29.18	29.12	29.15	1868870.0
2008-04-30 12:30:00	MSFT	Stock	29.15	29.16	29.0	29.09	3039959.0
2008-04-30 13:00:00	MSFT	Stock	29.09	29.15	29.02	29.06	2363779.0
2008-04-30 13:30:00	MSFT	Stock	29.06	29.07	28.872	28.88	2556630.0
2008-04-30 14:00:00	MSFT	Stock	28.888	29.16	28.88	29.0	6008831.0
2008-04-30 14:30:00	MSFT	Stock	28.99	29.11	28.74	28.76	5803044.0
2008-04-30 15:00:00	MSFT	Stock	28.75	28.76	28.51	28.538	7432516.0
2008-04-30 15:30:00	MSFT	Stock	28.54	28.71	28.51	28.53	10432333.0
2008-04-30 16:00:00	MSFT	Stock	28.53	28.828	28.5	28.513	4763648.0
2008-04-30 16:30:00	MSFT	Stock	28.54	28.813	28.51	28.55	845406.0
2008-04-30 17:00:00	MSFT	Stock	28.55	28.55	28.52	28.55	397169.0
2008-04-30 17:30:00	MSFT	Stock	28.612	28.612	28.53	28.56	24057.0
2008-04-30 18:00:00	MSFT	Stock	28.59	28.805	28.235	28.235	72094.0

> showing 50 of 69,165 rows — these rows as CSV

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