PREVIEW / stock_30min / 2008-06-17

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-17.parquet
  size:    1.2 MB
  rows:    68,006
  symbols: 3,312

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-06-17 07:00:00	AAPL	Stock	6.3425	6.3536	6.3425	6.3536	21840.0
2008-06-17 07:30:00	AAPL	Stock	6.3461	6.3536	6.3393	6.3464	209692.0
2008-06-17 08:00:00	AAPL	Stock	6.3482	6.3518	6.3157	6.3375	2653000.0
2008-06-17 08:30:00	AAPL	Stock	6.3375	6.3586	6.3304	6.3525	3451224.0
2008-06-17 09:00:00	AAPL	Stock	6.3529	6.3811	6.3507	6.3604	3285716.0
2008-06-17 09:30:00	AAPL	Stock	6.3604	6.4211	6.3361	6.4111	143832332.0
2008-06-17 10:00:00	AAPL	Stock	6.4111	6.4429	6.3775	6.395	99199072.0
2008-06-17 10:30:00	AAPL	Stock	6.395	6.4714	6.3863	6.4572	83605956.0
2008-06-17 11:00:00	AAPL	Stock	6.4579	6.4739	6.4379	6.4429	59331692.0
2008-06-17 11:30:00	AAPL	Stock	6.4429	6.4493	6.4171	6.4268	42625184.0
2008-06-17 12:00:00	AAPL	Stock	6.4268	6.4507	6.4218	6.4418	27420428.0
2008-06-17 12:30:00	AAPL	Stock	6.4429	6.4521	6.4196	6.4489	40285056.0
2008-06-17 13:00:00	AAPL	Stock	6.4493	6.4821	6.445	6.4736	62110972.0
2008-06-17 13:30:00	AAPL	Stock	6.4743	6.4832	6.4568	6.475	38443216.0
2008-06-17 14:00:00	AAPL	Stock	6.4744	6.4918	6.4632	6.4761	48734056.0
2008-06-17 14:30:00	AAPL	Stock	6.4754	6.4996	6.4536	6.4954	51498384.0
2008-06-17 15:00:00	AAPL	Stock	6.4954	6.4989	6.4418	6.4611	77213220.0
2008-06-17 15:30:00	AAPL	Stock	6.4625	6.4964	6.4568	6.4793	80769948.0
2008-06-17 16:00:00	AAPL	Stock	6.4793	6.4857	6.4424	6.4796	5369924.0
2008-06-17 16:30:00	AAPL	Stock	6.4825	6.4857	6.4581	6.4854	329700.0
2008-06-17 17:00:00	AAPL	Stock	6.4821	6.4857	6.3501	6.4839	149800.0
2008-06-17 17:30:00	AAPL	Stock	6.4839	6.4882	6.4839	6.4861	152320.0
2008-06-17 18:00:00	AAPL	Stock	6.4907	6.4911	6.4886	6.4893	254800.0
2008-06-17 18:30:00	AAPL	Stock	6.4911	6.4929	6.4829	6.4875	187572.0
2008-06-17 19:00:00	AAPL	Stock	6.4857	6.4857	6.4832	6.4854	82572.0
2008-06-17 19:30:00	AAPL	Stock	6.4857	6.4889	6.4857	6.4875	45080.0
2008-06-17 07:30:00	MSFT	Stock	29.25	29.25	29.1	29.1	2046.0
2008-06-17 08:00:00	MSFT	Stock	29.0	29.08	29.0	29.04	8740.0
2008-06-17 08:30:00	MSFT	Stock	29.01	29.05	28.98	29.05	63573.0
2008-06-17 09:00:00	MSFT	Stock	29.05	29.12	28.96	29.01	141578.0
2008-06-17 09:30:00	MSFT	Stock	29.04	29.1	28.81	28.85	4689103.0
2008-06-17 10:00:00	MSFT	Stock	28.84	28.94	28.82	28.89	4095364.0
2008-06-17 10:30:00	MSFT	Stock	28.9	29.06	28.87	29.04	4011987.0
2008-06-17 11:00:00	MSFT	Stock	29.04	29.12	28.98	29.01	4078923.0
2008-06-17 11:30:00	MSFT	Stock	29.001	29.01	28.87	28.88	3097219.0
2008-06-17 12:00:00	MSFT	Stock	28.88	29.0	28.88	28.93	2231925.0
2008-06-17 12:30:00	MSFT	Stock	28.94	28.97	28.81	28.845	2177200.0
2008-06-17 13:00:00	MSFT	Stock	28.85	28.93	28.82	28.92	1930241.0
2008-06-17 13:30:00	MSFT	Stock	28.93	29.0	28.91	28.91	2138601.0
2008-06-17 14:00:00	MSFT	Stock	28.92	28.99	28.9	28.93	2162778.0
2008-06-17 14:30:00	MSFT	Stock	28.93	29.0	28.9	28.95	2821289.0
2008-06-17 15:00:00	MSFT	Stock	28.95	28.97	28.86	28.905	3604789.0
2008-06-17 15:30:00	MSFT	Stock	28.9	28.94	28.79	28.8	4424044.0
2008-06-17 16:00:00	MSFT	Stock	28.8	28.979	28.75	28.75	969237.0
2008-06-17 16:30:00	MSFT	Stock	28.8	28.8	28.79	28.8	5825.0
2008-06-17 17:00:00	MSFT	Stock	28.79	28.79	28.78	28.78	3545.0
2008-06-17 17:30:00	MSFT	Stock	28.79	28.79	28.77	28.77	3600.0
2008-06-17 18:00:00	MSFT	Stock	28.8	28.82	28.8	28.82	1571.0
2008-06-17 18:30:00	MSFT	Stock	28.85	28.85	28.85	28.85	1700.0
2008-06-17 19:00:00	MSFT	Stock	28.82	28.82	28.82	28.82	2970.0

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

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