PREVIEW / stock_30min / 2010-08-11

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-11.parquet
  size:    1.4 MB
  rows:    75,047
  symbols: 3,454

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-08-11 05:30:00	AAPL	Stock	9.1982	9.1982	9.1696	9.1696	11200.0
2010-08-11 07:00:00	AAPL	Stock	9.1679	9.1789	9.1643	9.1789	111300.0
2010-08-11 07:30:00	AAPL	Stock	9.1804	9.1857	9.175	9.1804	360192.0
2010-08-11 08:00:00	AAPL	Stock	9.1829	9.1957	9.1579	9.1643	1641332.0
2010-08-11 08:30:00	AAPL	Stock	9.1643	9.1646	9.1379	9.1482	1304940.0
2010-08-11 09:00:00	AAPL	Stock	9.1504	9.1518	9.1189	9.1193	1720152.0
2010-08-11 09:30:00	AAPL	Stock	9.1193	9.1318	9.0214	9.0559	109421452.0
2010-08-11 10:00:00	AAPL	Stock	9.055	9.0779	9.0446	9.0518	41469400.0
2010-08-11 10:30:00	AAPL	Stock	9.0525	9.063	8.9871	9.0014	47550020.0
2010-08-11 11:00:00	AAPL	Stock	9.0016	9.0089	8.9404	8.9505	64804964.0
2010-08-11 11:30:00	AAPL	Stock	8.9504	8.9775	8.9436	8.9636	37832144.0
2010-08-11 12:00:00	AAPL	Stock	8.9643	8.9689	8.9482	8.9531	22802500.0
2010-08-11 12:30:00	AAPL	Stock	8.9532	8.9561	8.9218	8.9318	50742804.0
2010-08-11 13:00:00	AAPL	Stock	8.9318	8.9875	8.9318	8.9854	33473580.0
2010-08-11 13:30:00	AAPL	Stock	8.9851	8.9854	8.9536	8.9571	24498964.0
2010-08-11 14:00:00	AAPL	Stock	8.9568	8.9814	8.9546	8.9761	20811000.0
2010-08-11 14:30:00	AAPL	Stock	8.975	8.9761	8.9293	8.9453	36806420.0
2010-08-11 15:00:00	AAPL	Stock	8.9436	8.9511	8.9304	8.9456	30447508.0
2010-08-11 15:30:00	AAPL	Stock	8.9457	8.9693	8.9286	8.9311	69661004.0
2010-08-11 16:00:00	AAPL	Stock	8.9318	8.9878	8.8971	8.9036	16912728.0
2010-08-11 16:30:00	AAPL	Stock	8.9082	9.1194	8.8579	8.8582	966952.0
2010-08-11 17:00:00	AAPL	Stock	8.8575	8.8575	8.8071	8.8179	1960280.0
2010-08-11 17:30:00	AAPL	Stock	8.8207	8.8339	8.8143	8.8304	462392.0
2010-08-11 18:00:00	AAPL	Stock	8.8304	8.9354	8.8304	8.8339	844816.0
2010-08-11 18:30:00	AAPL	Stock	8.8446	8.8561	8.8357	8.8464	86576.0
2010-08-11 19:00:00	AAPL	Stock	8.8529	8.8529	8.8393	8.8393	242984.0
2010-08-11 19:30:00	AAPL	Stock	8.8429	8.8471	8.8286	8.8393	480676.0
2010-08-11 04:00:00	MSFT	Stock	25.0	25.0	24.86	24.86	1300.0
2010-08-11 06:00:00	MSFT	Stock	24.8	24.8	24.8	24.8	300.0
2010-08-11 06:30:00	MSFT	Stock	24.77	24.77	24.77	24.77	100.0
2010-08-11 07:00:00	MSFT	Stock	24.76	24.76	24.66	24.71	2545.0
2010-08-11 07:30:00	MSFT	Stock	24.72	24.77	24.71	24.75	4420.0
2010-08-11 08:00:00	MSFT	Stock	24.73	24.81	24.71	24.75	10662.0
2010-08-11 08:30:00	MSFT	Stock	24.76	24.76	24.7	24.71	31436.0
2010-08-11 09:00:00	MSFT	Stock	24.71	24.71	24.66	24.69	110362.0
2010-08-11 09:30:00	MSFT	Stock	24.68	24.78	24.6	24.77	9546494.0
2010-08-11 10:00:00	MSFT	Stock	24.765	24.85	24.69	24.82	5649899.0
2010-08-11 10:30:00	MSFT	Stock	24.83	24.83	24.76	24.8	5493549.0
2010-08-11 11:00:00	MSFT	Stock	24.795	24.81	24.7	24.71	4654814.0
2010-08-11 11:30:00	MSFT	Stock	24.71	24.79	24.69	24.72	3854183.0
2010-08-11 12:00:00	MSFT	Stock	24.71	24.76	24.68	24.71	3782241.0
2010-08-11 12:30:00	MSFT	Stock	24.7	24.72	24.57	24.57	6012815.0
2010-08-11 13:00:00	MSFT	Stock	24.57	24.68	24.56	24.67	4755531.0
2010-08-11 13:30:00	MSFT	Stock	24.67	24.69	24.61	24.65	4126346.0
2010-08-11 14:00:00	MSFT	Stock	24.65	24.78	24.648	24.76	3256261.0
2010-08-11 14:30:00	MSFT	Stock	24.76	24.77	24.68	24.72	3927273.0
2010-08-11 15:00:00	MSFT	Stock	24.728	24.82	24.71	24.8	4014640.0
2010-08-11 15:30:00	MSFT	Stock	24.8	24.9	24.77	24.84	13302224.0
2010-08-11 16:00:00	MSFT	Stock	24.84	25.145	24.6	24.66	3282544.0
2010-08-11 16:30:00	MSFT	Stock	24.65	24.837	24.48	24.5	70462.0

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

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