PREVIEW / stock_30min / 2010-11-03

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-03.parquet
  size:    1.4 MB
  rows:    72,582
  symbols: 3,475

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-11-03 04:30:00	AAPL	Stock	11.095	11.095	11.095	11.095	2800.0
2010-11-03 05:00:00	AAPL	Stock	11.0854	11.0854	11.08	11.08	19600.0
2010-11-03 06:00:00	AAPL	Stock	11.0925	11.0925	11.0925	11.0925	2800.0
2010-11-03 06:30:00	AAPL	Stock	11.0818	11.0921	11.0818	11.0921	8400.0
2010-11-03 07:00:00	AAPL	Stock	11.0789	11.0893	11.0757	11.0829	80640.0
2010-11-03 07:30:00	AAPL	Stock	11.0821	11.0889	11.0796	11.0889	189280.0
2010-11-03 08:00:00	AAPL	Stock	11.0907	11.1061	11.0786	11.0982	2081464.0
2010-11-03 08:30:00	AAPL	Stock	11.0918	11.1429	11.0832	11.1375	3716608.0
2010-11-03 09:00:00	AAPL	Stock	11.1407	11.1429	11.1157	11.1218	3254020.0
2010-11-03 09:30:00	AAPL	Stock	11.1204	11.1429	11.0746	11.1084	74822272.0
2010-11-03 10:00:00	AAPL	Stock	11.1086	11.1429	11.0964	11.1003	34290760.0
2010-11-03 10:30:00	AAPL	Stock	11.1004	11.1125	11.0646	11.0733	32159456.0
2010-11-03 11:00:00	AAPL	Stock	11.0732	11.0879	11.0375	11.0389	28849884.0
2010-11-03 11:30:00	AAPL	Stock	11.0375	11.0668	11.0368	11.0579	15244012.0
2010-11-03 12:00:00	AAPL	Stock	11.0557	11.0693	11.0371	11.0636	11669924.0
2010-11-03 12:30:00	AAPL	Stock	11.0642	11.0889	11.059	11.0832	13814892.0
2010-11-03 13:00:00	AAPL	Stock	11.0842	11.0968	11.065	11.0714	19271924.0
2010-11-03 13:30:00	AAPL	Stock	11.0714	11.0839	11.0582	11.075	10388812.0
2010-11-03 14:00:00	AAPL	Stock	11.0768	11.1482	11.0375	11.0536	66880184.0
2010-11-03 14:30:00	AAPL	Stock	11.0529	11.1589	11.0189	11.1425	66850532.0
2010-11-03 15:00:00	AAPL	Stock	11.1425	11.1743	11.1414	11.1504	51002672.0
2010-11-03 15:30:00	AAPL	Stock	11.1518	11.1711	11.1286	11.1696	61660592.0
2010-11-03 16:00:00	AAPL	Stock	11.17	11.1925	11.0695	11.1907	7966280.0
2010-11-03 16:30:00	AAPL	Stock	11.1882	11.1911	11.0826	11.1889	745192.0
2010-11-03 17:00:00	AAPL	Stock	11.1879	11.19	11.1846	11.1893	305340.0
2010-11-03 17:30:00	AAPL	Stock	11.1893	11.1893	11.1356	11.1804	1122576.0
2010-11-03 18:00:00	AAPL	Stock	11.1804	11.1846	11.1714	11.1811	478464.0
2010-11-03 18:30:00	AAPL	Stock	11.1832	11.1839	11.1793	11.1793	227220.0
2010-11-03 19:00:00	AAPL	Stock	11.1804	11.1821	11.1768	11.1786	144200.0
2010-11-03 19:30:00	AAPL	Stock	11.1789	11.1814	11.1718	11.1757	346500.0
2010-11-03 07:00:00	MSFT	Stock	27.4	27.4	27.4	27.4	500.0
2010-11-03 08:00:00	MSFT	Stock	27.4	27.48	27.4	27.47	14170.0
2010-11-03 08:30:00	MSFT	Stock	27.47	27.47	27.43	27.45	6800.0
2010-11-03 09:00:00	MSFT	Stock	27.46	27.48	27.33	27.48	40514.0
2010-11-03 09:30:00	MSFT	Stock	27.47	27.49	27.28	27.33	9771291.0
2010-11-03 10:00:00	MSFT	Stock	27.34	27.37	27.3	27.34	10158787.0
2010-11-03 10:30:00	MSFT	Stock	27.35	27.37	27.25	27.274	5379920.0
2010-11-03 11:00:00	MSFT	Stock	27.27	27.302	27.1	27.11	4562940.0
2010-11-03 11:30:00	MSFT	Stock	27.11	27.18	27.1	27.17	4859329.0
2010-11-03 12:00:00	MSFT	Stock	27.172	27.19	27.11	27.12	2324230.0
2010-11-03 12:30:00	MSFT	Stock	27.125	27.13	26.99	27.092	4128447.0
2010-11-03 13:00:00	MSFT	Stock	27.092	27.17	27.09	27.14	2601735.0
2010-11-03 13:30:00	MSFT	Stock	27.149	27.155	27.09	27.12	3837656.0
2010-11-03 14:00:00	MSFT	Stock	27.12	27.24	26.98	27.0	12464784.0
2010-11-03 14:30:00	MSFT	Stock	27.0	27.23	26.96	27.21	13948298.0
2010-11-03 15:00:00	MSFT	Stock	27.21	27.25	27.088	27.101	15095520.0
2010-11-03 15:30:00	MSFT	Stock	27.1	27.11	26.99	27.03	15860389.0
2010-11-03 16:00:00	MSFT	Stock	27.03	27.4	27.01	27.13	2850421.0
2010-11-03 16:30:00	MSFT	Stock	27.11	27.145	27.03	27.12	16462.0
2010-11-03 17:00:00	MSFT	Stock	27.08	27.11	27.07	27.1	10535.0

> showing 50 of 72,582 rows — these rows as CSV

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