PREVIEW / stock_30min / 2013-06-06

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-06.parquet
  size:    1.5 MB
  rows:    80,606
  symbols: 3,483

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
2013-06-06 05:00:00	AAPL	Stock	15.9418	15.9418	15.9418	15.9418	2800.0
2013-06-06 05:30:00	AAPL	Stock	15.9393	15.9393	15.9393	15.9393	4200.0
2013-06-06 06:00:00	AAPL	Stock	15.9571	15.9757	15.9568	15.9757	36400.0
2013-06-06 07:00:00	AAPL	Stock	15.9836	15.9911	15.9432	15.9432	110460.0
2013-06-06 07:30:00	AAPL	Stock	15.9568	15.9889	15.9464	15.9739	197316.0
2013-06-06 08:00:00	AAPL	Stock	15.9696	15.9696	15.8929	15.9643	1058400.0
2013-06-06 08:30:00	AAPL	Stock	15.9579	15.9582	15.9114	15.9375	583128.0
2013-06-06 09:00:00	AAPL	Stock	15.9389	15.9393	15.895	15.895	725060.0
2013-06-06 09:30:00	AAPL	Stock	15.8946	15.9643	15.7429	15.8028	61816552.0
2013-06-06 10:00:00	AAPL	Stock	15.8036	15.8125	15.6546	15.6818	47172720.0
2013-06-06 10:30:00	AAPL	Stock	15.6818	15.7318	15.6122	15.6864	32105948.0
2013-06-06 11:00:00	AAPL	Stock	15.6864	15.6925	15.6214	15.6682	25900224.0
2013-06-06 11:30:00	AAPL	Stock	15.6632	15.6921	15.6154	15.6154	21252252.0
2013-06-06 12:00:00	AAPL	Stock	15.6182	15.6371	15.5018	15.521	34539904.0
2013-06-06 12:30:00	AAPL	Stock	15.5206	15.5642	15.5086	15.5429	25311916.0
2013-06-06 13:00:00	AAPL	Stock	15.5446	15.6246	15.5364	15.5757	22690332.0
2013-06-06 13:30:00	AAPL	Stock	15.58	15.6893	15.5736	15.6532	22877148.0
2013-06-06 14:00:00	AAPL	Stock	15.6496	15.6975	15.5864	15.6629	19294072.0
2013-06-06 14:30:00	AAPL	Stock	15.6656	15.6782	15.6254	15.6454	14216328.0
2013-06-06 15:00:00	AAPL	Stock	15.641	15.6857	15.6075	15.6404	21243684.0
2013-06-06 15:30:00	AAPL	Stock	15.6414	15.6618	15.6046	15.6593	31889284.0
2013-06-06 16:00:00	AAPL	Stock	15.6591	15.7182	15.6464	15.6843	28482776.0
2013-06-06 16:30:00	AAPL	Stock	15.6686	15.6804	15.6414	15.6675	1741992.0
2013-06-06 17:00:00	AAPL	Stock	15.6625	15.6782	15.6593	15.6768	210168.0
2013-06-06 17:30:00	AAPL	Stock	15.6775	15.6786	15.6714	15.6714	248948.0
2013-06-06 18:00:00	AAPL	Stock	15.6714	15.675	15.6664	15.6664	15372.0
2013-06-06 18:30:00	AAPL	Stock	15.6668	15.6732	15.6646	15.665	46340.0
2013-06-06 19:00:00	AAPL	Stock	15.6714	15.6764	15.6661	15.6764	49532.0
2013-06-06 19:30:00	AAPL	Stock	15.6696	15.6696	15.6661	15.6661	41300.0
2013-06-06 04:00:00	MSFT	Stock	34.75	34.75	34.75	34.75	500.0
2013-06-06 07:00:00	MSFT	Stock	34.78	34.78	34.78	34.78	500.0
2013-06-06 07:30:00	MSFT	Stock	34.89	34.9	34.89	34.9	2100.0
2013-06-06 08:00:00	MSFT	Stock	34.82	34.9	34.78	34.9	5666.0
2013-06-06 08:30:00	MSFT	Stock	34.84	34.87	34.8	34.8	3500.0
2013-06-06 09:00:00	MSFT	Stock	34.82	34.86	34.79	34.86	18710.0
2013-06-06 09:30:00	MSFT	Stock	34.85	35.11	34.8	35.01	4211584.0
2013-06-06 10:00:00	MSFT	Stock	35.005	35.08	34.88	34.93	2903461.0
2013-06-06 10:30:00	MSFT	Stock	34.935	34.95	34.825	34.86	2294751.0
2013-06-06 11:00:00	MSFT	Stock	34.86	34.92	34.841	34.875	1895581.0
2013-06-06 11:30:00	MSFT	Stock	34.875	34.91	34.82	34.83	2857529.0
2013-06-06 12:00:00	MSFT	Stock	34.83	34.85	34.53	34.58	2212818.0
2013-06-06 12:30:00	MSFT	Stock	34.585	34.72	34.58	34.6	1713019.0
2013-06-06 13:00:00	MSFT	Stock	34.6	34.675	34.5	34.575	1628238.0
2013-06-06 13:30:00	MSFT	Stock	34.575	34.67	34.49	34.518	2104457.0
2013-06-06 14:00:00	MSFT	Stock	34.515	34.625	34.51	34.595	2735883.0
2013-06-06 14:30:00	MSFT	Stock	34.596	34.8	34.56	34.795	2140977.0
2013-06-06 15:00:00	MSFT	Stock	34.795	34.81	34.7	34.755	1969410.0
2013-06-06 15:30:00	MSFT	Stock	34.756	34.95	34.71	34.95	5055464.0
2013-06-06 16:00:00	MSFT	Stock	34.95	34.98	34.806	34.964	3362769.0
2013-06-06 16:30:00	MSFT	Stock	34.898	34.967	34.76	34.965	112006.0

> showing 50 of 80,606 rows — these rows as CSV

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