PREVIEW / stock_30min / 2010-03-30

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-30.parquet
  size:    1.4 MB
  rows:    73,094
  symbols: 3,486

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
2010-03-30 04:00:00	AAPL	Stock	8.4625	8.4625	8.4579	8.4579	5600.0
2010-03-30 04:30:00	AAPL	Stock	8.4643	8.4643	8.4611	8.4611	8400.0
2010-03-30 05:30:00	AAPL	Stock	8.4721	8.4721	8.4721	8.4721	14000.0
2010-03-30 06:00:00	AAPL	Stock	8.4643	8.4743	8.4643	8.4743	21000.0
2010-03-30 06:30:00	AAPL	Stock	8.4707	8.4707	8.4682	8.4682	19600.0
2010-03-30 07:00:00	AAPL	Stock	8.4679	8.4893	8.4554	8.4893	306964.0
2010-03-30 07:30:00	AAPL	Stock	8.4893	8.4893	8.4361	8.4518	1073268.0
2010-03-30 08:00:00	AAPL	Stock	8.4643	8.4911	8.4554	8.4743	6140400.0
2010-03-30 08:30:00	AAPL	Stock	8.4739	8.4807	8.4564	8.4696	3322116.0
2010-03-30 09:00:00	AAPL	Stock	8.4682	8.4696	8.4196	8.4514	10471804.0
2010-03-30 09:30:00	AAPL	Stock	8.4501	8.4814	8.4243	8.4579	137842572.0
2010-03-30 10:00:00	AAPL	Stock	8.4582	8.4671	8.4254	8.4421	64009512.0
2010-03-30 10:30:00	AAPL	Stock	8.4421	8.4479	8.3946	8.4164	49306376.0
2010-03-30 11:00:00	AAPL	Stock	8.4164	8.4243	8.3661	8.4236	52521588.0
2010-03-30 11:30:00	AAPL	Stock	8.4229	8.44	8.4132	8.43	33648524.0
2010-03-30 12:00:00	AAPL	Stock	8.4318	8.4343	8.415	8.4293	15437968.0
2010-03-30 12:30:00	AAPL	Stock	8.43	8.4321	8.4114	8.4175	13130712.0
2010-03-30 13:00:00	AAPL	Stock	8.4182	8.4214	8.395	8.4057	20036436.0
2010-03-30 13:30:00	AAPL	Stock	8.4057	8.4232	8.3979	8.4211	15153880.0
2010-03-30 14:00:00	AAPL	Stock	8.4211	8.4264	8.4129	8.4218	13042120.0
2010-03-30 14:30:00	AAPL	Stock	8.4225	8.4361	8.4225	8.4337	18047708.0
2010-03-30 15:00:00	AAPL	Stock	8.4339	8.4364	8.4204	8.4261	18834368.0
2010-03-30 15:30:00	AAPL	Stock	8.425	8.4421	8.4225	8.4225	43426012.0
2010-03-30 16:00:00	AAPL	Stock	8.4225	8.432	8.4218	8.4232	6542004.0
2010-03-30 16:30:00	AAPL	Stock	8.4225	8.4279	8.4225	8.4264	742448.0
2010-03-30 17:00:00	AAPL	Stock	8.4264	8.4264	8.4164	8.4225	329784.0
2010-03-30 17:30:00	AAPL	Stock	8.42	8.4225	8.4186	8.4186	93184.0
2010-03-30 18:00:00	AAPL	Stock	8.4232	8.4232	8.4154	8.4154	90888.0
2010-03-30 18:30:00	AAPL	Stock	8.4173	8.4225	8.4173	8.4214	118300.0
2010-03-30 19:00:00	AAPL	Stock	8.4214	8.4214	8.4114	8.4114	73640.0
2010-03-30 19:30:00	AAPL	Stock	8.415	8.4179	8.412	8.4161	91028.0
2010-03-30 20:00:00	AAPL	Stock	8.4314	8.4314	8.4314	8.4314	1537200.0
2010-03-30 08:00:00	MSFT	Stock	29.59	29.6	29.56	29.56	1350.0
2010-03-30 08:30:00	MSFT	Stock	29.57	29.58	29.57	29.57	1383.0
2010-03-30 09:00:00	MSFT	Stock	29.59	29.59	29.56	29.59	1576.0
2010-03-30 09:30:00	MSFT	Stock	29.63	29.77	29.5	29.74	4405360.0
2010-03-30 10:00:00	MSFT	Stock	29.75	29.76	29.54	29.63	2934593.0
2010-03-30 10:30:00	MSFT	Stock	29.625	29.71	29.62	29.705	2928603.0
2010-03-30 11:00:00	MSFT	Stock	29.705	29.71	29.55	29.565	3219230.0
2010-03-30 11:30:00	MSFT	Stock	29.56	29.73	29.56	29.66	3103177.0
2010-03-30 12:00:00	MSFT	Stock	29.67	29.68	29.6	29.67	1199275.0
2010-03-30 12:30:00	MSFT	Stock	29.67	29.69	29.63	29.68	1176021.0
2010-03-30 13:00:00	MSFT	Stock	29.672	29.672	29.63	29.66	1135869.0
2010-03-30 13:30:00	MSFT	Stock	29.66	29.68	29.605	29.67	1334924.0
2010-03-30 14:00:00	MSFT	Stock	29.67	29.7	29.655	29.69	1736407.0
2010-03-30 14:30:00	MSFT	Stock	29.68	29.75	29.68	29.72	1385032.0
2010-03-30 15:00:00	MSFT	Stock	29.73	29.82	29.725	29.8	3919866.0
2010-03-30 15:30:00	MSFT	Stock	29.8	29.86	29.74	29.76	4319476.0
2010-03-30 16:00:00	MSFT	Stock	29.76	29.831	29.685	29.77	1520202.0
2010-03-30 16:30:00	MSFT	Stock	29.8	29.8	29.75	29.75	7683.0

> showing 50 of 73,094 rows — these rows as CSV

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