PREVIEW / stock_30min / 2009-08-25

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-08-25.parquet
  size:    1.3 MB
  rows:    71,249
  symbols: 3,364

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
2009-08-25 06:30:00	AAPL	Stock	6.0182	6.0182	6.0182	6.0182	14000.0
2009-08-25 07:30:00	AAPL	Stock	6.0357	6.0429	6.0357	6.0429	22960.0
2009-08-25 08:00:00	AAPL	Stock	6.0432	6.0725	6.0432	6.0661	1181292.0
2009-08-25 08:30:00	AAPL	Stock	6.0643	6.0804	6.0607	6.0804	1038156.0
2009-08-25 09:00:00	AAPL	Stock	6.0786	6.085	6.0464	6.0514	1120112.0
2009-08-25 09:30:00	AAPL	Stock	6.0539	6.0893	6.0432	6.0893	48346396.0
2009-08-25 10:00:00	AAPL	Stock	6.0893	6.105	6.0536	6.0572	50682464.0
2009-08-25 10:30:00	AAPL	Stock	6.0571	6.0804	6.0543	6.0707	19636316.0
2009-08-25 11:00:00	AAPL	Stock	6.0704	6.0818	6.0664	6.0756	13746572.0
2009-08-25 11:30:00	AAPL	Stock	6.0768	6.0925	6.0743	6.0882	15918952.0
2009-08-25 12:00:00	AAPL	Stock	6.0889	6.0904	6.0796	6.0879	12730032.0
2009-08-25 12:30:00	AAPL	Stock	6.0879	6.0918	6.0675	6.0696	12588716.0
2009-08-25 13:00:00	AAPL	Stock	6.07	6.0775	6.0536	6.0593	14410900.0
2009-08-25 13:30:00	AAPL	Stock	6.0593	6.0664	6.0536	6.0607	16264192.0
2009-08-25 14:00:00	AAPL	Stock	6.0611	6.0764	6.0554	6.0679	16901668.0
2009-08-25 14:30:00	AAPL	Stock	6.0679	6.0689	6.0536	6.0679	19859644.0
2009-08-25 15:00:00	AAPL	Stock	6.0675	6.075	6.0625	6.0632	18564196.0
2009-08-25 15:30:00	AAPL	Stock	6.0636	6.0636	6.0404	6.05	45129112.0
2009-08-25 16:00:00	AAPL	Stock	6.05	6.0689	6.0479	6.0482	10106908.0
2009-08-25 16:30:00	AAPL	Stock	6.05	6.05	6.0489	6.0489	425544.0
2009-08-25 17:00:00	AAPL	Stock	6.0464	6.0691	6.0457	6.0486	303576.0
2009-08-25 17:30:00	AAPL	Stock	6.0489	6.0518	6.0411	6.0446	202860.0
2009-08-25 18:00:00	AAPL	Stock	6.0421	6.05	6.0421	6.0475	287364.0
2009-08-25 18:30:00	AAPL	Stock	6.0446	6.0475	6.0389	6.0446	106148.0
2009-08-25 19:00:00	AAPL	Stock	6.04	6.0429	6.0389	6.0429	40236.0
2009-08-25 19:30:00	AAPL	Stock	6.0464	6.0464	6.0443	6.0443	77000.0
2009-08-25 07:30:00	MSFT	Stock	24.71	24.75	24.71	24.75	3300.0
2009-08-25 08:00:00	MSFT	Stock	24.66	24.7	24.65	24.7	5230.0
2009-08-25 08:30:00	MSFT	Stock	24.68	24.68	24.66	24.66	1200.0
2009-08-25 09:00:00	MSFT	Stock	24.68	24.68	24.59	24.6	17088.0
2009-08-25 09:30:00	MSFT	Stock	24.6	24.7	24.5	24.68	4936468.0
2009-08-25 10:00:00	MSFT	Stock	24.68	24.82	24.6	24.62	5448457.0
2009-08-25 10:30:00	MSFT	Stock	24.62	24.68	24.61	24.63	2572342.0
2009-08-25 11:00:00	MSFT	Stock	24.64	24.71	24.625	24.7	1582034.0
2009-08-25 11:30:00	MSFT	Stock	24.69	24.74	24.66	24.68	1947888.0
2009-08-25 12:00:00	MSFT	Stock	24.68	24.75	24.67	24.75	1527251.0
2009-08-25 12:30:00	MSFT	Stock	24.74	24.79	24.64	24.64	2652064.0
2009-08-25 13:00:00	MSFT	Stock	24.64	24.67	24.54	24.567	3490252.0
2009-08-25 13:30:00	MSFT	Stock	24.56	24.6	24.53	24.59	1486297.0
2009-08-25 14:00:00	MSFT	Stock	24.58	24.61	24.56	24.57	1486024.0
2009-08-25 14:30:00	MSFT	Stock	24.56	24.577	24.46	24.54	2619171.0
2009-08-25 15:00:00	MSFT	Stock	24.54	24.65	24.525	24.63	3059233.0
2009-08-25 15:30:00	MSFT	Stock	24.62	24.7	24.55	24.64	6602007.0
2009-08-25 16:00:00	MSFT	Stock	24.64	24.65	24.49	24.61	2520957.0
2009-08-25 16:30:00	MSFT	Stock	24.637	24.64	24.61	24.61	157518.0
2009-08-25 17:00:00	MSFT	Stock	24.63	24.644	24.61	24.61	808.0
2009-08-25 17:30:00	MSFT	Stock	24.63	24.63	24.61	24.61	1050.0
2009-08-25 18:30:00	MSFT	Stock	24.61	24.63	24.61	24.61	2300.0
2009-08-25 19:00:00	MSFT	Stock	24.63	24.63	24.61	24.61	400.0
2009-08-25 19:30:00	MSFT	Stock	24.61	24.61	24.6	24.6	8774.0

> showing 50 of 71,249 rows — these rows as CSV

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