PREVIEW / stock_30min / 2010-10-01

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-01.parquet
  size:    1.4 MB
  rows:    75,339
  symbols: 3,468

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-10-01 06:00:00	AAPL	Stock	10.1964	10.1964	10.1964	10.1964	2800.0
2010-10-01 07:00:00	AAPL	Stock	10.1893	10.1893	10.1539	10.1889	33600.0
2010-10-01 07:30:00	AAPL	Stock	10.1886	10.1968	10.1786	10.1961	133140.0
2010-10-01 08:00:00	AAPL	Stock	10.1964	10.2107	10.1339	10.2071	966448.0
2010-10-01 08:30:00	AAPL	Stock	10.2071	10.2204	10.1339	10.2171	1805608.0
2010-10-01 09:00:00	AAPL	Stock	10.2157	10.2275	10.1339	10.225	3346560.0
2010-10-01 09:30:00	AAPL	Stock	10.2286	10.235	10.1361	10.1822	76239912.0
2010-10-01 10:00:00	AAPL	Stock	10.1832	10.1964	10.0482	10.0768	78204336.0
2010-10-01 10:30:00	AAPL	Stock	10.0768	10.1214	10.0525	10.105	49120288.0
2010-10-01 11:00:00	AAPL	Stock	10.1056	10.1207	10.0818	10.0961	20242348.0
2010-10-01 11:30:00	AAPL	Stock	10.0957	10.1429	10.0839	10.1267	26680948.0
2010-10-01 12:00:00	AAPL	Stock	10.1257	10.1325	10.1071	10.1204	15462440.0
2010-10-01 12:30:00	AAPL	Stock	10.1211	10.1321	10.1036	10.1286	13238176.0
2010-10-01 13:00:00	AAPL	Stock	10.1296	10.1357	10.1122	10.125	16433816.0
2010-10-01 13:30:00	AAPL	Stock	10.1245	10.1254	10.0907	10.1064	14536368.0
2010-10-01 14:00:00	AAPL	Stock	10.1064	10.1354	10.0814	10.1093	22767108.0
2010-10-01 14:30:00	AAPL	Stock	10.1093	10.1239	10.1	10.1106	13749736.0
2010-10-01 15:00:00	AAPL	Stock	10.1111	10.1489	10.1086	10.129	27785156.0
2010-10-01 15:30:00	AAPL	Stock	10.1306	10.145	10.09	10.09	55022016.0
2010-10-01 16:00:00	AAPL	Stock	10.09	10.1757	10.0871	10.0896	8141308.0
2010-10-01 16:30:00	AAPL	Stock	10.1339	10.2271	10.0843	10.0911	197148.0
2010-10-01 17:00:00	AAPL	Stock	10.09	10.0989	10.09	10.0964	1104068.0
2010-10-01 17:30:00	AAPL	Stock	10.0954	10.0954	10.0904	10.0946	135772.0
2010-10-01 18:00:00	AAPL	Stock	10.09	10.0939	10.09	10.0939	209132.0
2010-10-01 18:30:00	AAPL	Stock	10.0943	10.0946	10.0943	10.0946	10360.0
2010-10-01 19:00:00	AAPL	Stock	10.0961	10.0964	10.0932	10.0932	12964.0
2010-10-01 19:30:00	AAPL	Stock	10.0946	10.0946	10.09	10.0936	37604.0
2010-10-01 05:00:00	MSFT	Stock	24.7	24.71	24.7	24.71	500.0
2010-10-01 06:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	300.0
2010-10-01 06:30:00	MSFT	Stock	24.66	24.66	24.66	24.66	870.0
2010-10-01 07:00:00	MSFT	Stock	24.66	24.68	24.66	24.68	500.0
2010-10-01 07:30:00	MSFT	Stock	24.68	24.68	24.68	24.68	100.0
2010-10-01 08:00:00	MSFT	Stock	24.62	24.65	24.62	24.65	5490.0
2010-10-01 08:30:00	MSFT	Stock	24.65	24.66	24.49	24.49	27895.0
2010-10-01 09:00:00	MSFT	Stock	24.49	24.8	24.49	24.76	120341.0
2010-10-01 09:30:00	MSFT	Stock	24.77	24.82	24.7	24.75	6055028.0
2010-10-01 10:00:00	MSFT	Stock	24.74	24.76	24.48	24.49	6677461.0
2010-10-01 10:30:00	MSFT	Stock	24.49	24.49	24.38	24.39	5523896.0
2010-10-01 11:00:00	MSFT	Stock	24.39	24.46	24.35	24.382	4729895.0
2010-10-01 11:30:00	MSFT	Stock	24.385	24.46	24.36	24.44	3806661.0
2010-10-01 12:00:00	MSFT	Stock	24.44	24.48	24.4	24.46	2727732.0
2010-10-01 12:30:00	MSFT	Stock	24.47	24.5	24.39	24.41	3512008.0
2010-10-01 13:00:00	MSFT	Stock	24.41	24.51	24.4	24.49	3587167.0
2010-10-01 13:30:00	MSFT	Stock	24.49	24.5	24.39	24.405	2788536.0
2010-10-01 14:00:00	MSFT	Stock	24.405	24.44	24.37	24.379	2443900.0
2010-10-01 14:30:00	MSFT	Stock	24.38	24.42	24.3	24.31	5874519.0
2010-10-01 15:00:00	MSFT	Stock	24.31	24.38	24.3	24.335	4258278.0
2010-10-01 15:30:00	MSFT	Stock	24.335	24.39	24.33	24.38	6596816.0
2010-10-01 16:00:00	MSFT	Stock	24.38	24.646	24.33	24.38	2026884.0
2010-10-01 16:30:00	MSFT	Stock	24.38	24.38	24.356	24.38	10660.0

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

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