PREVIEW / stock_30min / 2012-05-21

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-21.parquet
  size:    1.4 MB
  rows:    75,936
  symbols: 3,524

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
2012-05-21 04:00:00	AAPL	Stock	19.1071	19.1071	19.0	19.0714	18760.0
2012-05-21 05:00:00	AAPL	Stock	19.0714	19.0714	19.0714	19.0714	14000.0
2012-05-21 05:30:00	AAPL	Stock	19.0714	19.0714	19.0714	19.0714	2800.0
2012-05-21 06:00:00	AAPL	Stock	19.0714	19.0857	19.0714	19.0857	17416.0
2012-05-21 06:30:00	AAPL	Stock	19.0571	19.1071	19.0571	19.1071	14000.0
2012-05-21 07:00:00	AAPL	Stock	19.1429	19.1429	19.0721	19.0804	149296.0
2012-05-21 07:30:00	AAPL	Stock	19.0804	19.1136	19.0732	19.0846	177044.0
2012-05-21 08:00:00	AAPL	Stock	19.0768	19.105	19.0536	19.0893	2347996.0
2012-05-21 08:30:00	AAPL	Stock	19.0954	19.1071	19.045	19.0575	2029916.0
2012-05-21 09:00:00	AAPL	Stock	19.0639	19.1014	19.0564	19.0886	1534540.0
2012-05-21 09:30:00	AAPL	Stock	19.0929	19.2543	19.0732	19.19	66167976.0
2012-05-21 10:00:00	AAPL	Stock	19.1925	19.4568	19.1511	19.4292	73586856.0
2012-05-21 10:30:00	AAPL	Stock	19.4239	19.6246	19.4214	19.5261	65583700.0
2012-05-21 11:00:00	AAPL	Stock	19.525	19.5293	19.4464	19.4978	38572744.0
2012-05-21 11:30:00	AAPL	Stock	19.4982	19.5657	19.4829	19.5446	29119272.0
2012-05-21 12:00:00	AAPL	Stock	19.5418	19.7893	19.525	19.7839	59495548.0
2012-05-21 12:30:00	AAPL	Stock	19.7871	19.8036	19.6982	19.7461	40561416.0
2012-05-21 13:00:00	AAPL	Stock	19.7493	19.8093	19.7336	19.7929	22345456.0
2012-05-21 13:30:00	AAPL	Stock	19.7871	19.8036	19.7507	19.7697	16595320.0
2012-05-21 14:00:00	AAPL	Stock	19.7721	19.78	19.6821	19.7477	25377072.0
2012-05-21 14:30:00	AAPL	Stock	19.7469	19.9121	19.7429	19.8965	39222344.0
2012-05-21 15:00:00	AAPL	Stock	19.8915	20.0146	19.8518	19.9757	56136080.0
2012-05-21 15:30:00	AAPL	Stock	19.9733	20.055	19.9236	20.0464	63159404.0
2012-05-21 16:00:00	AAPL	Stock	20.0457	20.0993	19.6285	20.0821	17223976.0
2012-05-21 16:30:00	AAPL	Stock	20.0821	20.1196	19.1982	20.1071	1506092.0
2012-05-21 17:00:00	AAPL	Stock	20.1075	20.1525	20.0457	20.1525	1678712.0
2012-05-21 17:30:00	AAPL	Stock	20.1518	20.1679	20.1393	20.1561	845068.0
2012-05-21 18:00:00	AAPL	Stock	20.15	20.1643	20.1296	20.1364	486080.0
2012-05-21 18:30:00	AAPL	Stock	20.1289	20.1496	20.1268	20.1429	108668.0
2012-05-21 19:00:00	AAPL	Stock	20.1357	20.1529	20.1357	20.1482	118804.0
2012-05-21 19:30:00	AAPL	Stock	20.1429	20.1429	20.1325	20.1429	323176.0
2012-05-21 07:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	500.0
2012-05-21 07:30:00	MSFT	Stock	29.49	29.67	29.45	29.45	13392.0
2012-05-21 08:00:00	MSFT	Stock	29.5	29.5	29.34	29.39	5786.0
2012-05-21 08:30:00	MSFT	Stock	29.38	29.38	29.2	29.22	17194.0
2012-05-21 09:00:00	MSFT	Stock	29.23	29.23	29.07	29.12	48754.0
2012-05-21 09:30:00	MSFT	Stock	29.09	29.34	29.06	29.32	4933336.0
2012-05-21 10:00:00	MSFT	Stock	29.31	29.44	29.29	29.38	2928145.0
2012-05-21 10:30:00	MSFT	Stock	29.39	29.55	29.38	29.505	3254805.0
2012-05-21 11:00:00	MSFT	Stock	29.5	29.51	29.41	29.45	2463839.0
2012-05-21 11:30:00	MSFT	Stock	29.44	29.54	29.4	29.475	1790738.0
2012-05-21 12:00:00	MSFT	Stock	29.478	29.7	29.45	29.69	2108783.0
2012-05-21 12:30:00	MSFT	Stock	29.69	29.79	29.65	29.65	1975019.0
2012-05-21 13:00:00	MSFT	Stock	29.655	29.67	29.555	29.56	1392746.0
2012-05-21 13:30:00	MSFT	Stock	29.568	29.65	29.565	29.58	1589988.0
2012-05-21 14:00:00	MSFT	Stock	29.58	29.62	29.51	29.548	1653420.0
2012-05-21 14:30:00	MSFT	Stock	29.541	29.65	29.541	29.635	1170948.0
2012-05-21 15:00:00	MSFT	Stock	29.64	29.79	29.635	29.76	2642396.0
2012-05-21 15:30:00	MSFT	Stock	29.76	29.79	29.71	29.75	5963228.0
2012-05-21 16:00:00	MSFT	Stock	29.74	29.79	29.539	29.75	3747437.0

> showing 50 of 75,936 rows — these rows as CSV

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