PREVIEW / stock_30min / 2008-04-25

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-25.parquet
  size:    1.2 MB
  rows:    68,219
  symbols: 3,271

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-25 07:00:00	AAPL	Stock	6.0018	6.0486	5.9875	6.0486	280224.0
2008-04-25 07:30:00	AAPL	Stock	6.0486	6.1607	6.0475	6.0979	1009764.0
2008-04-25 08:00:00	AAPL	Stock	6.0964	6.1318	6.0421	6.105	5063828.0
2008-04-25 08:30:00	AAPL	Stock	6.1032	6.125	6.0982	6.1168	4300520.0
2008-04-25 09:00:00	AAPL	Stock	6.1168	6.1182	6.0896	6.0954	4536896.0
2008-04-25 09:30:00	AAPL	Stock	6.0954	6.1107	5.9436	5.9664	187981052.0
2008-04-25 10:00:00	AAPL	Stock	5.9661	6.0671	5.9457	6.0536	128448824.0
2008-04-25 10:30:00	AAPL	Stock	6.0536	6.0732	6.025	6.0625	86557184.0
2008-04-25 11:00:00	AAPL	Stock	6.0625	6.0661	6.0179	6.0339	73969224.0
2008-04-25 11:30:00	AAPL	Stock	6.0343	6.06	6.0289	6.0436	43912428.0
2008-04-25 12:00:00	AAPL	Stock	6.0429	6.0554	6.0	6.0321	39099872.0
2008-04-25 12:30:00	AAPL	Stock	6.0318	6.0493	6.0179	6.0289	39972856.0
2008-04-25 13:00:00	AAPL	Stock	6.0289	6.035	5.9846	5.9871	45403624.0
2008-04-25 13:30:00	AAPL	Stock	5.9875	6.035	5.9682	6.0329	53770472.0
2008-04-25 14:00:00	AAPL	Stock	6.0325	6.0571	6.025	6.0507	50257088.0
2008-04-25 14:30:00	AAPL	Stock	6.0514	6.0704	6.0386	6.0518	50221276.0
2008-04-25 15:00:00	AAPL	Stock	6.0525	6.0875	6.0461	6.0682	70625632.0
2008-04-25 15:30:00	AAPL	Stock	6.0686	6.0779	6.0518	6.0629	60843300.0
2008-04-25 16:00:00	AAPL	Stock	6.0625	6.0714	6.0385	6.0693	19608148.0
2008-04-25 16:30:00	AAPL	Stock	6.0664	6.0693	6.0618	6.0682	801640.0
2008-04-25 17:00:00	AAPL	Stock	6.0679	6.0691	6.0618	6.0661	11534992.0
2008-04-25 17:30:00	AAPL	Stock	6.0664	6.0675	6.0654	6.0664	150976.0
2008-04-25 18:00:00	AAPL	Stock	6.0654	6.0664	6.065	6.065	221508.0
2008-04-25 18:30:00	AAPL	Stock	6.0657	6.0675	6.0632	6.0643	170744.0
2008-04-25 19:00:00	AAPL	Stock	6.0643	6.0664	6.0643	6.0664	119028.0
2008-04-25 19:30:00	AAPL	Stock	6.0679	6.0696	6.0679	6.0679	156632.0
2008-04-25 06:30:00	MSFT	Stock	30.4	30.4	30.4	30.4	500.0
2008-04-25 07:00:00	MSFT	Stock	30.5	30.5	30.19	30.3	14510.0
2008-04-25 07:30:00	MSFT	Stock	30.35	30.4	30.2	30.3	26440.0
2008-04-25 08:00:00	MSFT	Stock	30.39	30.42	30.3	30.38	324600.0
2008-04-25 08:30:00	MSFT	Stock	30.38	30.53	30.35	30.4	838283.0
2008-04-25 09:00:00	MSFT	Stock	30.38	30.38	30.01	30.06	2544155.0
2008-04-25 09:30:00	MSFT	Stock	30.05	30.39	29.85	29.92	36894291.0
2008-04-25 10:00:00	MSFT	Stock	29.93	30.02	29.77	29.94	14765660.0
2008-04-25 10:30:00	MSFT	Stock	29.93	30.01	29.83	29.908	13016199.0
2008-04-25 11:00:00	MSFT	Stock	29.91	30.0	29.6	29.7	10767884.0
2008-04-25 11:30:00	MSFT	Stock	29.7	29.85	29.65	29.81	7347859.0
2008-04-25 12:00:00	MSFT	Stock	29.8	29.81	29.74	29.76	3801840.0
2008-04-25 12:30:00	MSFT	Stock	29.75	29.85	29.74	29.77	3502772.0
2008-04-25 13:00:00	MSFT	Stock	29.77	29.842	29.72	29.81	6096801.0
2008-04-25 13:30:00	MSFT	Stock	29.81	29.81	29.74	29.79	3516677.0
2008-04-25 14:00:00	MSFT	Stock	29.78	29.81	29.74	29.76	5174516.0
2008-04-25 14:30:00	MSFT	Stock	29.759	29.77	29.7	29.754	4170558.0
2008-04-25 15:00:00	MSFT	Stock	29.75	29.88	29.7	29.78	10802248.0
2008-04-25 15:30:00	MSFT	Stock	29.77	29.85	29.68	29.81	14567847.0
2008-04-25 16:00:00	MSFT	Stock	29.82	29.883	29.769	29.8	2537984.0
2008-04-25 16:30:00	MSFT	Stock	29.82	29.85	29.78	29.85	160242.0
2008-04-25 17:00:00	MSFT	Stock	29.83	29.91	29.769	29.89	157703.0
2008-04-25 17:30:00	MSFT	Stock	29.89	29.91	29.87	29.9	26822.0
2008-04-25 18:00:00	MSFT	Stock	29.91	29.92	29.9	29.91	19951.0

> showing 50 of 68,219 rows — these rows as CSV

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