PREVIEW / stock_30min / 2008-06-27

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-27.parquet
  size:    1.5 MB
  rows:    79,321
  symbols: 3,335

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-27 04:30:00	AAPL	Stock	6.0	6.0	6.0	6.0	2800.0
2008-06-27 05:00:00	AAPL	Stock	6.0089	6.0089	5.9839	5.9839	5600.0
2008-06-27 05:30:00	AAPL	Stock	5.9896	5.9943	5.9896	5.9943	8400.0
2008-06-27 07:00:00	AAPL	Stock	5.9646	5.9804	5.9639	5.9804	24780.0
2008-06-27 07:30:00	AAPL	Stock	5.965	5.965	5.9357	5.9568	236348.0
2008-06-27 08:00:00	AAPL	Stock	5.9643	5.9775	5.8957	5.9107	2194584.0
2008-06-27 08:30:00	AAPL	Stock	5.9107	5.955	5.9036	5.9518	3435600.0
2008-06-27 09:00:00	AAPL	Stock	5.9514	5.9732	5.9421	5.9482	4638732.0
2008-06-27 09:30:00	AAPL	Stock	5.9468	6.0179	5.9068	6.0168	143970708.0
2008-06-27 10:00:00	AAPL	Stock	6.0171	6.0625	5.9696	6.0129	93029636.0
2008-06-27 10:30:00	AAPL	Stock	6.0146	6.0539	5.9886	6.0061	66576412.0
2008-06-27 11:00:00	AAPL	Stock	6.0067	6.0182	5.9775	6.0043	89008416.0
2008-06-27 11:30:00	AAPL	Stock	6.0032	6.0064	5.9796	6.0	35807576.0
2008-06-27 12:00:00	AAPL	Stock	5.9996	6.0343	5.9996	6.0268	38679452.0
2008-06-27 12:30:00	AAPL	Stock	6.0279	6.0314	5.9643	5.9839	33444348.0
2008-06-27 13:00:00	AAPL	Stock	5.9839	5.9875	5.8625	5.9282	56549304.0
2008-06-27 13:30:00	AAPL	Stock	5.9284	5.9361	5.8657	5.9057	66966620.0
2008-06-27 14:00:00	AAPL	Stock	5.9054	5.9875	5.9054	5.9775	79657116.0
2008-06-27 14:30:00	AAPL	Stock	5.9779	6.0686	5.9775	6.0682	88393620.0
2008-06-27 15:00:00	AAPL	Stock	6.0679	6.0918	6.03	6.0443	86533076.0
2008-06-27 15:30:00	AAPL	Stock	6.0439	6.0914	6.0304	6.0749	69857116.0
2008-06-27 16:00:00	AAPL	Stock	6.0737	6.0839	5.9941	6.0768	17217004.0
2008-06-27 16:30:00	AAPL	Stock	6.0811	6.0825	5.9941	6.0716	4697868.0
2008-06-27 17:00:00	AAPL	Stock	6.0749	6.0789	6.0718	6.0725	21349664.0
2008-06-27 17:30:00	AAPL	Stock	6.0746	6.0811	6.0722	6.0811	1558144.0
2008-06-27 18:00:00	AAPL	Stock	6.0746	6.0789	5.9941	6.075	2739828.0
2008-06-27 18:30:00	AAPL	Stock	6.075	6.0768	6.0732	6.0764	96040.0
2008-06-27 19:00:00	AAPL	Stock	6.0764	6.0839	6.0757	6.0789	66220.0
2008-06-27 19:30:00	AAPL	Stock	6.0789	6.0821	6.0789	6.0821	22400.0
2008-06-27 07:30:00	MSFT	Stock	27.63	27.63	27.56	27.59	1600.0
2008-06-27 08:00:00	MSFT	Stock	27.65	27.69	27.65	27.66	618.0
2008-06-27 08:30:00	MSFT	Stock	27.66	27.72	27.6	27.6	6607.0
2008-06-27 09:00:00	MSFT	Stock	27.71	27.9	27.66	27.68	35091.0
2008-06-27 09:30:00	MSFT	Stock	27.72	27.81	27.58	27.77	5469475.0
2008-06-27 10:00:00	MSFT	Stock	27.77	27.91	27.6	27.68	5655237.0
2008-06-27 10:30:00	MSFT	Stock	27.69	27.75	27.57	27.7	5171881.0
2008-06-27 11:00:00	MSFT	Stock	27.7	27.79	27.61	27.72	3538655.0
2008-06-27 11:30:00	MSFT	Stock	27.711	27.74	27.65	27.72	2187170.0
2008-06-27 12:00:00	MSFT	Stock	27.72	27.86	27.7	27.77	2681425.0
2008-06-27 12:30:00	MSFT	Stock	27.77	27.79	27.62	27.69	2926848.0
2008-06-27 13:00:00	MSFT	Stock	27.68	27.69	27.5	27.51	4039553.0
2008-06-27 13:30:00	MSFT	Stock	27.51	27.6	27.46	27.572	3822853.0
2008-06-27 14:00:00	MSFT	Stock	27.57	27.77	27.56	27.75	4049001.0
2008-06-27 14:30:00	MSFT	Stock	27.75	27.81	27.54	27.8	3535689.0
2008-06-27 15:00:00	MSFT	Stock	27.79	27.81	27.6	27.64	4038623.0
2008-06-27 15:30:00	MSFT	Stock	27.65	27.88	27.59	27.69	6545287.0
2008-06-27 16:00:00	MSFT	Stock	27.7	27.71	27.63	27.69	10324655.0
2008-06-27 16:30:00	MSFT	Stock	27.63	27.72	27.627	27.63	1216345.0
2008-06-27 17:00:00	MSFT	Stock	27.636	27.72	27.622	27.634	2441332.0
2008-06-27 17:30:00	MSFT	Stock	27.63	27.641	27.63	27.639	358610.0

> showing 50 of 79,321 rows — these rows as CSV

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