PREVIEW / stock_30min / 2011-12-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-21.parquet
  size:    1.4 MB
  rows:    76,334
  symbols: 3,562

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
2011-12-21 04:00:00	AAPL	Stock	14.1771	14.2071	14.1771	14.2071	8400.0
2011-12-21 04:30:00	AAPL	Stock	14.1829	14.1829	14.1829	14.1829	7000.0
2011-12-21 05:00:00	AAPL	Stock	14.2036	14.2036	14.2032	14.2032	18200.0
2011-12-21 06:00:00	AAPL	Stock	14.2032	14.2032	14.1429	14.1786	11200.0
2011-12-21 06:30:00	AAPL	Stock	14.1582	14.1582	14.0786	14.0786	19600.0
2011-12-21 07:00:00	AAPL	Stock	14.1289	14.1596	14.1289	14.1429	165228.0
2011-12-21 07:30:00	AAPL	Stock	14.1429	14.1518	14.0982	14.1196	240912.0
2011-12-21 08:00:00	AAPL	Stock	14.135	14.135	14.0689	14.0914	921396.0
2011-12-21 08:30:00	AAPL	Stock	14.0964	14.1504	14.0929	14.1371	991088.0
2011-12-21 09:00:00	AAPL	Stock	14.1411	14.185	14.1411	14.1704	1936200.0
2011-12-21 09:30:00	AAPL	Stock	14.1632	14.1893	14.025	14.0957	54459636.0
2011-12-21 10:00:00	AAPL	Stock	14.095	14.1571	14.0454	14.1211	32560220.0
2011-12-21 10:30:00	AAPL	Stock	14.1186	14.1518	14.0714	14.0879	20035792.0
2011-12-21 11:00:00	AAPL	Stock	14.0857	14.0893	14.0518	14.0675	14028588.0
2011-12-21 11:30:00	AAPL	Stock	14.0696	14.0875	14.0293	14.0434	12775336.0
2011-12-21 12:00:00	AAPL	Stock	14.0446	14.0662	14.0004	14.015	14894488.0
2011-12-21 12:30:00	AAPL	Stock	14.0157	14.0611	14.0064	14.0539	11678240.0
2011-12-21 13:00:00	AAPL	Stock	14.0573	14.0842	14.0468	14.0571	10506524.0
2011-12-21 13:30:00	AAPL	Stock	14.0575	14.0804	14.0339	14.079	10332252.0
2011-12-21 14:00:00	AAPL	Stock	14.0789	14.0993	14.0436	14.0664	10300416.0
2011-12-21 14:30:00	AAPL	Stock	14.0664	14.1	14.0468	14.08	8853796.0
2011-12-21 15:00:00	AAPL	Stock	14.0796	14.1421	14.0696	14.1371	17410876.0
2011-12-21 15:30:00	AAPL	Stock	14.1375	14.1679	14.1322	14.1586	27129816.0
2011-12-21 16:00:00	AAPL	Stock	14.1586	14.1679	14.0888	14.1604	9823492.0
2011-12-21 16:30:00	AAPL	Stock	14.1604	14.1607	14.1341	14.1486	519232.0
2011-12-21 17:00:00	AAPL	Stock	14.1493	14.1707	14.1482	14.1636	462868.0
2011-12-21 17:30:00	AAPL	Stock	14.1636	14.1839	14.1636	14.1786	275268.0
2011-12-21 18:00:00	AAPL	Stock	14.1793	14.1793	14.1586	14.175	82460.0
2011-12-21 18:30:00	AAPL	Stock	14.1768	14.1814	14.1739	14.1786	86464.0
2011-12-21 19:00:00	AAPL	Stock	14.175	14.1946	14.1739	14.1946	301224.0
2011-12-21 19:30:00	AAPL	Stock	14.1929	14.2093	14.1871	14.1932	289296.0
2011-12-21 04:30:00	MSFT	Stock	26.11	26.11	26.11	26.11	500.0
2011-12-21 05:30:00	MSFT	Stock	26.09	26.09	26.09	26.09	500.0
2011-12-21 07:00:00	MSFT	Stock	26.07	26.07	26.03	26.03	600.0
2011-12-21 07:30:00	MSFT	Stock	26.0	26.0	25.91	25.95	14672.0
2011-12-21 08:00:00	MSFT	Stock	25.95	25.95	25.82	25.86	29090.0
2011-12-21 08:30:00	MSFT	Stock	25.87	25.93	25.87	25.91	45400.0
2011-12-21 09:00:00	MSFT	Stock	25.93	26.05	25.93	26.01	162184.0
2011-12-21 09:30:00	MSFT	Stock	26.01	26.19	25.84	25.9	8213509.0
2011-12-21 10:00:00	MSFT	Stock	25.89	26.0	25.84	25.94	4577003.0
2011-12-21 10:30:00	MSFT	Stock	25.94	26.02	25.86	25.895	3253933.0
2011-12-21 11:00:00	MSFT	Stock	25.9	25.905	25.64	25.69	4743354.0
2011-12-21 11:30:00	MSFT	Stock	25.68	25.7	25.57	25.64	5001605.0
2011-12-21 12:00:00	MSFT	Stock	25.64	25.65	25.46	25.47	3986305.0
2011-12-21 12:30:00	MSFT	Stock	25.47	25.63	25.47	25.61	3009533.0
2011-12-21 13:00:00	MSFT	Stock	25.615	25.66	25.522	25.535	2991445.0
2011-12-21 13:30:00	MSFT	Stock	25.535	25.59	25.44	25.59	3635150.0
2011-12-21 14:00:00	MSFT	Stock	25.59	25.67	25.58	25.61	3056580.0
2011-12-21 14:30:00	MSFT	Stock	25.605	25.67	25.56	25.64	4138825.0
2011-12-21 15:00:00	MSFT	Stock	25.632	25.65	25.6	25.621	5276010.0

> showing 50 of 76,334 rows — these rows as CSV

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