PREVIEW / stock_30min / 2013-01-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-15.parquet
  size:    1.4 MB
  rows:    75,599
  symbols: 3,457

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-01-15 04:00:00	AAPL	Stock	17.8575	17.8575	17.8575	17.8575	11200.0
2013-01-15 04:30:00	AAPL	Stock	17.8575	17.8575	17.8575	17.8575	2800.0
2013-01-15 05:00:00	AAPL	Stock	17.8929	17.8929	17.8929	17.8929	2800.0
2013-01-15 05:30:00	AAPL	Stock	17.8814	17.8814	17.875	17.875	5600.0
2013-01-15 06:00:00	AAPL	Stock	17.8557	17.875	17.8554	17.8571	19600.0
2013-01-15 06:30:00	AAPL	Stock	17.8571	17.8746	17.8571	17.8746	35700.0
2013-01-15 07:00:00	AAPL	Stock	17.8754	17.9143	17.8668	17.9054	369964.0
2013-01-15 07:30:00	AAPL	Stock	17.9107	17.9707	17.9089	17.9707	599648.0
2013-01-15 08:00:00	AAPL	Stock	17.9493	18.015	17.8661	17.9511	1663060.0
2013-01-15 08:30:00	AAPL	Stock	17.9607	17.9807	17.9107	17.9146	1369452.0
2013-01-15 09:00:00	AAPL	Stock	17.9186	17.9282	17.7857	17.7982	5194280.0
2013-01-15 09:30:00	AAPL	Stock	17.7964	17.8211	17.4382	17.5437	206442124.0
2013-01-15 10:00:00	AAPL	Stock	17.5496	17.5975	17.48	17.5257	71642284.0
2013-01-15 10:30:00	AAPL	Stock	17.5286	17.5779	17.4554	17.4804	51779840.0
2013-01-15 11:00:00	AAPL	Stock	17.4814	17.4821	17.3429	17.3468	74714108.0
2013-01-15 11:30:00	AAPL	Stock	17.3454	17.4357	17.2821	17.2871	60848844.0
2013-01-15 12:00:00	AAPL	Stock	17.2857	17.4618	17.2786	17.4296	57205120.0
2013-01-15 12:30:00	AAPL	Stock	17.4311	17.5321	17.4311	17.4411	49853272.0
2013-01-15 13:00:00	AAPL	Stock	17.4411	17.5	17.4107	17.4514	35038388.0
2013-01-15 13:30:00	AAPL	Stock	17.45	17.4732	17.3964	17.4114	23253888.0
2013-01-15 14:00:00	AAPL	Stock	17.4179	17.4375	17.3304	17.3501	33813108.0
2013-01-15 14:30:00	AAPL	Stock	17.3543	17.3907	17.3307	17.358	35990164.0
2013-01-15 15:00:00	AAPL	Stock	17.3586	17.4321	17.3086	17.392	53167660.0
2013-01-15 15:30:00	AAPL	Stock	17.3929	17.3957	17.2636	17.3504	76226836.0
2013-01-15 16:00:00	AAPL	Stock	17.3543	17.4602	17.3279	17.3525	15767416.0
2013-01-15 16:30:00	AAPL	Stock	17.3525	17.3909	17.3164	17.3275	1202992.0
2013-01-15 17:00:00	AAPL	Stock	17.3279	17.3714	17.3214	17.3571	1664348.0
2013-01-15 17:30:00	AAPL	Stock	17.3614	17.5643	17.3536	17.5014	2993060.0
2013-01-15 18:00:00	AAPL	Stock	17.5082	17.5179	17.4746	17.5	735560.0
2013-01-15 18:30:00	AAPL	Stock	17.4996	17.5057	17.4929	17.5	551516.0
2013-01-15 19:00:00	AAPL	Stock	17.5	17.5054	17.4793	17.4821	515592.0
2013-01-15 19:30:00	AAPL	Stock	17.4854	17.5107	17.4821	17.4954	753172.0
2013-01-15 07:30:00	MSFT	Stock	26.82	26.82	26.82	26.82	2400.0
2013-01-15 08:00:00	MSFT	Stock	26.83	26.84	26.77	26.77	11593.0
2013-01-15 08:30:00	MSFT	Stock	26.8	26.9	26.8	26.8	14500.0
2013-01-15 09:00:00	MSFT	Stock	26.79	26.87	26.76	26.87	25352.0
2013-01-15 09:30:00	MSFT	Stock	26.84	27.17	26.825	26.98	7018837.0
2013-01-15 10:00:00	MSFT	Stock	26.98	26.98	26.86	26.892	3525537.0
2013-01-15 10:30:00	MSFT	Stock	26.895	26.95	26.89	26.925	2204279.0
2013-01-15 11:00:00	MSFT	Stock	26.925	26.97	26.9	26.925	1969833.0
2013-01-15 11:30:00	MSFT	Stock	26.92	26.98	26.92	26.95	1696001.0
2013-01-15 12:00:00	MSFT	Stock	26.95	26.97	26.93	26.94	1448869.0
2013-01-15 12:30:00	MSFT	Stock	26.95	27.01	26.94	26.98	1385800.0
2013-01-15 13:00:00	MSFT	Stock	26.982	27.019	26.95	26.965	1969633.0
2013-01-15 13:30:00	MSFT	Stock	26.96	27.13	26.945	27.07	9605048.0
2013-01-15 14:00:00	MSFT	Stock	27.06	27.1	27.02	27.08	2119537.0
2013-01-15 14:30:00	MSFT	Stock	27.075	27.2	27.06	27.17	2714854.0
2013-01-15 15:00:00	MSFT	Stock	27.17	27.23	27.16	27.2	4217817.0
2013-01-15 15:30:00	MSFT	Stock	27.2	27.29	27.2	27.21	5875499.0
2013-01-15 16:00:00	MSFT	Stock	27.21	27.29	26.876	27.2	1473130.0

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

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