PREVIEW / stock_30min / 2010-03-09

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-09.parquet
  size:    1.4 MB
  rows:    73,595
  symbols: 3,461

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-09 05:30:00	AAPL	Stock	7.7857	7.7857	7.7857	7.7857	5628.0
2010-03-09 06:30:00	AAPL	Stock	7.785	7.785	7.785	7.785	2800.0
2010-03-09 07:00:00	AAPL	Stock	7.7686	7.7864	7.7686	7.7861	89208.0
2010-03-09 07:30:00	AAPL	Stock	7.7961	7.7982	7.7929	7.7964	44800.0
2010-03-09 08:00:00	AAPL	Stock	7.7993	7.815	7.7939	7.8004	725732.0
2010-03-09 08:30:00	AAPL	Stock	7.8	7.8121	7.8	7.8075	393008.0
2010-03-09 09:00:00	AAPL	Stock	7.8107	7.8118	7.7929	7.7936	670124.0
2010-03-09 09:30:00	AAPL	Stock	7.7968	7.8436	7.7818	7.8382	71550556.0
2010-03-09 10:00:00	AAPL	Stock	7.8368	7.9161	7.8218	7.9089	88891600.0
2010-03-09 10:30:00	AAPL	Stock	7.9089	8.0061	7.8993	7.9893	118802404.0
2010-03-09 11:00:00	AAPL	Stock	7.9907	7.9939	7.9464	7.9736	83080340.0
2010-03-09 11:30:00	AAPL	Stock	7.9736	7.9911	7.9661	7.9893	36627640.0
2010-03-09 12:00:00	AAPL	Stock	7.9893	8.0146	7.9782	8.0036	37277100.0
2010-03-09 12:30:00	AAPL	Stock	8.0036	8.0171	7.9929	8.0121	33806584.0
2010-03-09 13:00:00	AAPL	Stock	8.0119	8.0168	7.9957	8.0136	28085876.0
2010-03-09 13:30:00	AAPL	Stock	8.0136	8.0286	8.0114	8.0271	39904396.0
2010-03-09 14:00:00	AAPL	Stock	8.0271	8.0357	8.0204	8.0286	40156760.0
2010-03-09 14:30:00	AAPL	Stock	8.0282	8.0293	7.9664	7.9771	67836216.0
2010-03-09 15:00:00	AAPL	Stock	7.9772	7.9875	7.9082	7.9432	95426492.0
2010-03-09 15:30:00	AAPL	Stock	7.9429	7.9743	7.9364	7.9704	71730988.0
2010-03-09 16:00:00	AAPL	Stock	7.9661	8.0291	7.9571	7.9686	11847080.0
2010-03-09 16:30:00	AAPL	Stock	7.9686	7.9686	7.9634	7.9679	139944.0
2010-03-09 17:00:00	AAPL	Stock	7.9654	7.9675	7.9643	7.9643	169792.0
2010-03-09 17:30:00	AAPL	Stock	7.9664	7.9679	7.9646	7.9679	54376.0
2010-03-09 18:00:00	AAPL	Stock	7.9696	7.975	7.9696	7.975	147756.0
2010-03-09 18:30:00	AAPL	Stock	7.9729	7.9746	7.9679	7.9679	210056.0
2010-03-09 19:00:00	AAPL	Stock	7.9682	7.9729	7.9675	7.9729	107604.0
2010-03-09 19:30:00	AAPL	Stock	7.9732	7.9757	7.9679	7.975	106624.0
2010-03-09 07:00:00	MSFT	Stock	28.53	28.53	28.53	28.53	199.0
2010-03-09 07:30:00	MSFT	Stock	28.53	28.53	28.53	28.53	200.0
2010-03-09 08:00:00	MSFT	Stock	28.55	28.56	28.53	28.56	15075.0
2010-03-09 08:30:00	MSFT	Stock	28.57	28.57	28.49	28.52	23900.0
2010-03-09 09:00:00	MSFT	Stock	28.5	28.56	28.5	28.56	5270.0
2010-03-09 09:30:00	MSFT	Stock	28.56	28.891	28.55	28.885	4342408.0
2010-03-09 10:00:00	MSFT	Stock	28.88	28.92	28.8	28.81	3621813.0
2010-03-09 10:30:00	MSFT	Stock	28.81	28.92	28.77	28.9	3840155.0
2010-03-09 11:00:00	MSFT	Stock	28.9	28.9	28.78	28.86	1801633.0
2010-03-09 11:30:00	MSFT	Stock	28.85	28.94	28.82	28.91	3961655.0
2010-03-09 12:00:00	MSFT	Stock	28.91	29.02	28.9	29.02	3202462.0
2010-03-09 12:30:00	MSFT	Stock	29.02	29.05	28.99	29.045	3009572.0
2010-03-09 13:00:00	MSFT	Stock	29.045	29.11	29.04	29.095	3927422.0
2010-03-09 13:30:00	MSFT	Stock	29.1	29.11	28.98	28.99	3132913.0
2010-03-09 14:00:00	MSFT	Stock	29.0	29.07	28.98	29.055	2303698.0
2010-03-09 14:30:00	MSFT	Stock	29.06	29.07	28.89	28.9	2728010.0
2010-03-09 15:00:00	MSFT	Stock	28.895	28.94	28.74	28.768	4647293.0
2010-03-09 15:30:00	MSFT	Stock	28.76	28.85	28.75	28.8	6146924.0
2010-03-09 16:00:00	MSFT	Stock	28.8	28.925	28.772	28.8	1508063.0
2010-03-09 16:30:00	MSFT	Stock	28.79	28.81	28.79	28.81	14188.0
2010-03-09 17:00:00	MSFT	Stock	28.63	28.82	28.63	28.81	707004.0
2010-03-09 17:30:00	MSFT	Stock	28.82	28.82	28.82	28.82	1000.0

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

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