PREVIEW / stock_30min / 2008-04-07

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-07.parquet
  size:    1.2 MB
  rows:    69,795
  symbols: 3,283

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-07 04:00:00	AAPL	Stock	5.5118	5.5118	5.5118	5.5118	2800.0
2008-04-07 04:30:00	AAPL	Stock	5.5039	5.5039	5.5039	5.5039	25200.0
2008-04-07 05:00:00	AAPL	Stock	5.5232	5.5354	5.5232	5.5354	8400.0
2008-04-07 05:30:00	AAPL	Stock	5.5446	5.5511	5.5446	5.5511	36960.0
2008-04-07 06:30:00	AAPL	Stock	5.5536	5.5743	5.5536	5.5536	378000.0
2008-04-07 07:00:00	AAPL	Stock	5.5436	5.5568	5.5321	5.5568	268800.0
2008-04-07 07:30:00	AAPL	Stock	5.5586	5.5679	5.5357	5.56	415856.0
2008-04-07 08:00:00	AAPL	Stock	5.5582	5.5714	5.5407	5.5639	2551836.0
2008-04-07 08:30:00	AAPL	Stock	5.5643	5.5679	5.55	5.5632	2323804.0
2008-04-07 09:00:00	AAPL	Stock	5.5625	5.5796	5.5518	5.5764	4162816.0
2008-04-07 09:30:00	AAPL	Stock	5.5761	5.6054	5.5489	5.5989	150928176.0
2008-04-07 10:00:00	AAPL	Stock	5.5996	5.6196	5.58	5.6068	108198468.0
2008-04-07 10:30:00	AAPL	Stock	5.6064	5.6339	5.6004	5.6307	77676620.0
2008-04-07 11:00:00	AAPL	Stock	5.6304	5.655	5.6211	5.6489	69703032.0
2008-04-07 11:30:00	AAPL	Stock	5.6489	5.685	5.6482	5.6746	78888180.0
2008-04-07 12:00:00	AAPL	Stock	5.6739	5.6996	5.6646	5.6964	58899484.0
2008-04-07 12:30:00	AAPL	Stock	5.6971	5.7032	5.6643	5.6721	51718800.0
2008-04-07 13:00:00	AAPL	Stock	5.6721	5.6771	5.625	5.6279	70861364.0
2008-04-07 13:30:00	AAPL	Stock	5.6279	5.6461	5.6	5.6136	60479720.0
2008-04-07 14:00:00	AAPL	Stock	5.6141	5.6182	5.5804	5.5832	96308856.0
2008-04-07 14:30:00	AAPL	Stock	5.5826	5.6036	5.5486	5.5775	111225324.0
2008-04-07 15:00:00	AAPL	Stock	5.5771	5.5968	5.5396	5.5886	92306760.0
2008-04-07 15:30:00	AAPL	Stock	5.5881	5.5921	5.5536	5.5686	91146188.0
2008-04-07 16:00:00	AAPL	Stock	5.5689	5.6173	5.5475	5.6054	10113348.0
2008-04-07 16:30:00	AAPL	Stock	5.5589	5.5675	5.5557	5.5625	457128.0
2008-04-07 17:00:00	AAPL	Stock	5.5607	5.6167	5.5607	5.5657	944468.0
2008-04-07 17:30:00	AAPL	Stock	5.5625	5.5675	5.5575	5.5643	387436.0
2008-04-07 18:00:00	AAPL	Stock	5.5661	5.5661	5.5643	5.5646	142408.0
2008-04-07 18:30:00	AAPL	Stock	5.5661	5.5714	5.5661	5.5714	109256.0
2008-04-07 19:00:00	AAPL	Stock	5.5696	5.5793	5.5696	5.5793	187964.0
2008-04-07 19:30:00	AAPL	Stock	5.5786	5.5786	5.5714	5.5757	101780.0
2008-04-07 07:30:00	MSFT	Stock	29.56	29.56	29.5	29.5	3100.0
2008-04-07 08:00:00	MSFT	Stock	29.58	29.75	29.5	29.61	141102.0
2008-04-07 08:30:00	MSFT	Stock	29.7	29.75	29.63	29.64	47224.0
2008-04-07 09:00:00	MSFT	Stock	29.69	29.7	29.5	29.56	91532.0
2008-04-07 09:30:00	MSFT	Stock	29.62	29.62	29.3	29.47	6156992.0
2008-04-07 10:00:00	MSFT	Stock	29.47	29.51	29.36	29.4	3039449.0
2008-04-07 10:30:00	MSFT	Stock	29.41	29.41	29.25	29.3	3144339.0
2008-04-07 11:00:00	MSFT	Stock	29.31	29.362	29.11	29.25	3097426.0
2008-04-07 11:30:00	MSFT	Stock	29.248	29.34	29.2	29.252	2686101.0
2008-04-07 12:00:00	MSFT	Stock	29.258	29.31	29.21	29.281	2257062.0
2008-04-07 12:30:00	MSFT	Stock	29.281	29.35	29.13	29.17	2607229.0
2008-04-07 13:00:00	MSFT	Stock	29.172	29.24	29.17	29.19	2184847.0
2008-04-07 13:30:00	MSFT	Stock	29.185	29.2	29.09	29.11	2823807.0
2008-04-07 14:00:00	MSFT	Stock	29.11	29.19	29.1	29.158	2140834.0
2008-04-07 14:30:00	MSFT	Stock	29.155	29.17	29.04	29.06	3006680.0
2008-04-07 15:00:00	MSFT	Stock	29.06	29.23	29.03	29.19	3793050.0
2008-04-07 15:30:00	MSFT	Stock	29.19	29.2	29.1	29.16	4621984.0
2008-04-07 16:00:00	MSFT	Stock	29.16	29.361	29.1	29.361	1612402.0
2008-04-07 16:30:00	MSFT	Stock	29.14	29.2	29.12	29.2	3260.0

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

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