PREVIEW / stock_30min / 2010-09-30

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-30.parquet
  size:    1.4 MB
  rows:    75,912
  symbols: 3,495

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-09-30 04:00:00	AAPL	Stock	10.2607	10.2607	10.2607	10.2607	2800.0
2010-09-30 07:30:00	AAPL	Stock	10.2611	10.2611	10.2589	10.2589	9856.0
2010-09-30 08:00:00	AAPL	Stock	10.2586	10.2796	10.2475	10.2643	788144.0
2010-09-30 08:30:00	AAPL	Stock	10.2679	10.3282	10.2679	10.3071	2738904.0
2010-09-30 09:00:00	AAPL	Stock	10.3125	10.3354	10.3118	10.3268	1839292.0
2010-09-30 09:30:00	AAPL	Stock	10.3218	10.3571	10.2786	10.3146	89086956.0
2010-09-30 10:00:00	AAPL	Stock	10.3136	10.3196	10.2661	10.2807	55359248.0
2010-09-30 10:30:00	AAPL	Stock	10.2804	10.2925	10.2246	10.225	41625976.0
2010-09-30 11:00:00	AAPL	Stock	10.2243	10.2245	10.0446	10.0932	119929544.0
2010-09-30 11:30:00	AAPL	Stock	10.0932	10.1607	10.0721	10.1514	62581428.0
2010-09-30 12:00:00	AAPL	Stock	10.1518	10.1529	10.1	10.12	33705476.0
2010-09-30 12:30:00	AAPL	Stock	10.1196	10.1857	10.1182	10.1661	27036548.0
2010-09-30 13:00:00	AAPL	Stock	10.1667	10.1689	10.1432	10.1675	23315460.0
2010-09-30 13:30:00	AAPL	Stock	10.1664	10.1804	10.1396	10.1579	18916156.0
2010-09-30 14:00:00	AAPL	Stock	10.157	10.1831	10.1164	10.1782	27005328.0
2010-09-30 14:30:00	AAPL	Stock	10.1782	10.2304	10.1675	10.2025	34832868.0
2010-09-30 15:00:00	AAPL	Stock	10.2025	10.2104	10.1679	10.2025	30913456.0
2010-09-30 15:30:00	AAPL	Stock	10.2032	10.2175	10.1339	10.1339	71492148.0
2010-09-30 16:00:00	AAPL	Stock	10.1339	10.3132	10.1329	10.1571	24089772.0
2010-09-30 16:30:00	AAPL	Stock	10.1521	10.2632	10.1334	10.145	433048.0
2010-09-30 17:00:00	AAPL	Stock	10.1468	10.1568	10.1379	10.1486	140476.0
2010-09-30 17:30:00	AAPL	Stock	10.1345	10.1464	10.1334	10.1421	177604.0
2010-09-30 18:00:00	AAPL	Stock	10.1429	10.1482	10.1339	10.1429	142156.0
2010-09-30 18:30:00	AAPL	Stock	10.1411	10.1411	10.1379	10.1386	41300.0
2010-09-30 19:00:00	AAPL	Stock	10.1386	10.1457	10.1379	10.1429	167244.0
2010-09-30 19:30:00	AAPL	Stock	10.1411	10.1593	10.1386	10.1536	184632.0
2010-09-30 07:30:00	MSFT	Stock	24.52	24.52	24.5	24.5	2490.0
2010-09-30 08:00:00	MSFT	Stock	24.54	24.54	24.5	24.5	5675.0
2010-09-30 08:30:00	MSFT	Stock	24.54	24.62	24.5	24.62	33783.0
2010-09-30 09:00:00	MSFT	Stock	24.61	24.77	24.6	24.6	104864.0
2010-09-30 09:30:00	MSFT	Stock	24.61	24.83	24.57	24.825	8046350.0
2010-09-30 10:00:00	MSFT	Stock	24.83	24.83	24.675	24.705	7170232.0
2010-09-30 10:30:00	MSFT	Stock	24.71	24.75	24.63	24.63	4223432.0
2010-09-30 11:00:00	MSFT	Stock	24.63	24.66	24.4	24.47	5895133.0
2010-09-30 11:30:00	MSFT	Stock	24.468	24.49	24.41	24.432	2786078.0
2010-09-30 12:00:00	MSFT	Stock	24.435	24.45	24.36	24.415	2709866.0
2010-09-30 12:30:00	MSFT	Stock	24.41	24.55	24.41	24.53	2502867.0
2010-09-30 13:00:00	MSFT	Stock	24.53	24.62	24.49	24.6	2820651.0
2010-09-30 13:30:00	MSFT	Stock	24.595	24.62	24.58	24.6	1489699.0
2010-09-30 14:00:00	MSFT	Stock	24.6	24.61	24.52	24.57	2981137.0
2010-09-30 14:30:00	MSFT	Stock	24.57	24.695	24.55	24.63	3012517.0
2010-09-30 15:00:00	MSFT	Stock	24.63	24.69	24.58	24.61	3356025.0
2010-09-30 15:30:00	MSFT	Stock	24.615	24.64	24.47	24.48	5963683.0
2010-09-30 16:00:00	MSFT	Stock	24.48	24.608	24.46	24.49	6727245.0
2010-09-30 16:30:00	MSFT	Stock	24.5	24.505	24.46	24.47	33645.0
2010-09-30 17:00:00	MSFT	Stock	24.46	24.46	24.46	24.46	115.0
2010-09-30 17:30:00	MSFT	Stock	24.48	24.48	24.48	24.48	2338.0
2010-09-30 18:00:00	MSFT	Stock	24.49	24.49	24.45	24.45	45595.0
2010-09-30 19:00:00	MSFT	Stock	24.45	24.48	24.45	24.48	2565.0
2010-09-30 19:30:00	MSFT	Stock	24.45	24.5	24.45	24.5	2143.0

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

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