PREVIEW / stock_30min / 2008-10-10

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-10-10.parquet
  size:    1.4 MB
  rows:    78,731
  symbols: 3,414

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-10-10 04:00:00	AAPL	Stock	3.1179	3.1207	3.1179	3.1207	56000.0
2008-10-10 05:00:00	AAPL	Stock	3.0714	3.1211	3.0361	3.0714	92400.0
2008-10-10 05:30:00	AAPL	Stock	3.0714	3.0714	3.0536	3.0536	102928.0
2008-10-10 06:00:00	AAPL	Stock	3.0696	3.0696	3.0696	3.0696	14000.0
2008-10-10 06:30:00	AAPL	Stock	3.0536	3.0889	3.0536	3.0875	45276.0
2008-10-10 07:00:00	AAPL	Stock	3.1064	3.1586	3.1064	3.1239	425152.0
2008-10-10 07:30:00	AAPL	Stock	3.1214	3.125	3.0796	3.0811	341376.0
2008-10-10 08:00:00	AAPL	Stock	3.1007	3.1107	3.0586	3.1036	2952404.0
2008-10-10 08:30:00	AAPL	Stock	3.1039	3.1057	3.0375	3.0411	2288664.0
2008-10-10 09:00:00	AAPL	Stock	3.0425	3.0814	3.0039	3.0586	4298196.0
2008-10-10 09:30:00	AAPL	Stock	3.0586	3.3357	3.0357	3.3086	261238768.0
2008-10-10 10:00:00	AAPL	Stock	3.3071	3.4643	3.3036	3.3461	224977816.0
2008-10-10 10:30:00	AAPL	Stock	3.3496	3.36	3.2357	3.2971	165070332.0
2008-10-10 11:00:00	AAPL	Stock	3.2975	3.3429	3.2214	3.2257	133625632.0
2008-10-10 11:30:00	AAPL	Stock	3.2254	3.2832	3.2143	3.2468	133373016.0
2008-10-10 12:00:00	AAPL	Stock	3.2464	3.3321	3.2389	3.2914	119513212.0
2008-10-10 12:30:00	AAPL	Stock	3.2946	3.3496	3.2493	3.3382	106676808.0
2008-10-10 13:00:00	AAPL	Stock	3.3386	3.4107	3.2864	3.3318	107803332.0
2008-10-10 13:30:00	AAPL	Stock	3.332	3.3354	3.2843	3.3093	132444368.0
2008-10-10 14:00:00	AAPL	Stock	3.3082	3.4086	3.2857	3.3054	152141864.0
2008-10-10 14:30:00	AAPL	Stock	3.3036	3.3907	3.2539	3.2921	138956580.0
2008-10-10 15:00:00	AAPL	Stock	3.2921	3.5171	3.2721	3.495	203856324.0
2008-10-10 15:30:00	AAPL	Stock	3.4946	3.5714	3.4246	3.4696	222864292.0
2008-10-10 16:00:00	AAPL	Stock	3.4796	3.5171	3.3333	3.4736	45910984.0
2008-10-10 16:30:00	AAPL	Stock	3.532	3.532	3.4571	3.4786	23236528.0
2008-10-10 17:00:00	AAPL	Stock	3.4786	3.4907	3.4571	3.4893	203728.0
2008-10-10 17:30:00	AAPL	Stock	3.4893	3.4982	3.4571	3.4786	288596.0
2008-10-10 18:00:00	AAPL	Stock	3.4571	3.4893	3.4571	3.4575	385784.0
2008-10-10 18:30:00	AAPL	Stock	3.4571	3.5	3.4464	3.4911	332416.0
2008-10-10 19:00:00	AAPL	Stock	3.4857	3.4857	3.4571	3.4679	177268.0
2008-10-10 19:30:00	AAPL	Stock	3.4782	3.4804	3.4696	3.4696	213136.0
2008-10-10 04:30:00	MSFT	Stock	21.7	21.7	21.7	21.7	200.0
2008-10-10 05:00:00	MSFT	Stock	21.7	21.7	21.69	21.69	4604.0
2008-10-10 05:30:00	MSFT	Stock	21.7	21.7	21.67	21.67	11912.0
2008-10-10 06:00:00	MSFT	Stock	21.66	21.66	21.65	21.65	3000.0
2008-10-10 06:30:00	MSFT	Stock	21.75	21.75	21.75	21.75	100.0
2008-10-10 07:00:00	MSFT	Stock	22.1	22.21	21.9	22.06	3550.0
2008-10-10 07:30:00	MSFT	Stock	22.08	22.08	21.9	21.9	12721.0
2008-10-10 08:00:00	MSFT	Stock	21.9	22.01	21.8	21.93	79624.0
2008-10-10 08:30:00	MSFT	Stock	21.9	21.94	21.76	21.8	71321.0
2008-10-10 09:00:00	MSFT	Stock	21.8	22.06	21.65	21.79	572210.0
2008-10-10 09:30:00	MSFT	Stock	21.79	22.2	20.65	21.8	26408335.0
2008-10-10 10:00:00	MSFT	Stock	21.79	22.29	21.54	21.82	18535637.0
2008-10-10 10:30:00	MSFT	Stock	21.82	21.9	20.85	21.12	17322835.0
2008-10-10 11:00:00	MSFT	Stock	21.12	21.53	21.02	21.05	16428188.0
2008-10-10 11:30:00	MSFT	Stock	21.05	21.35	20.85	21.014	12182767.0
2008-10-10 12:00:00	MSFT	Stock	21.014	21.3	20.86	21.17	12668675.0
2008-10-10 12:30:00	MSFT	Stock	21.17	21.57	21.06	21.32	9615592.0
2008-10-10 13:00:00	MSFT	Stock	21.32	21.38	21.04	21.07	8052928.0
2008-10-10 13:30:00	MSFT	Stock	21.06	21.09	20.75	20.8	11444407.0

> showing 50 of 78,731 rows — these rows as CSV

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