PREVIEW / stock_30min / 2010-06-15

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-15.parquet
  size:    1.4 MB
  rows:    74,294
  symbols: 3,476

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-06-15 04:00:00	AAPL	Stock	9.0814	9.0821	9.0814	9.0821	14000.0
2010-06-15 04:30:00	AAPL	Stock	9.0936	9.1	9.0789	9.0961	61600.0
2010-06-15 05:00:00	AAPL	Stock	9.0961	9.1143	9.0961	9.1143	18200.0
2010-06-15 06:30:00	AAPL	Stock	9.1461	9.1461	9.1461	9.1461	2800.0
2010-06-15 07:00:00	AAPL	Stock	9.1429	9.1464	9.1414	9.1414	60340.0
2010-06-15 07:30:00	AAPL	Stock	9.1382	9.15	9.1346	9.1411	70000.0
2010-06-15 08:00:00	AAPL	Stock	9.1429	9.1429	9.0971	9.125	1751036.0
2010-06-15 08:30:00	AAPL	Stock	9.1246	9.1393	9.1143	9.1193	718508.0
2010-06-15 09:00:00	AAPL	Stock	9.1182	9.1375	9.1182	9.13	840812.0
2010-06-15 09:30:00	AAPL	Stock	9.13	9.2321	9.125	9.2239	77757988.0
2010-06-15 10:00:00	AAPL	Stock	9.2218	9.2282	9.1843	9.2054	50365448.0
2010-06-15 10:30:00	AAPL	Stock	9.2054	9.2214	9.1889	9.2175	31214092.0
2010-06-15 11:00:00	AAPL	Stock	9.2175	9.2209	9.1829	9.1893	26001108.0
2010-06-15 11:30:00	AAPL	Stock	9.1893	9.2218	9.1639	9.2179	32684036.0
2010-06-15 12:00:00	AAPL	Stock	9.2175	9.2311	9.2093	9.2239	26311460.0
2010-06-15 12:30:00	AAPL	Stock	9.2239	9.2304	9.2018	9.2231	20185900.0
2010-06-15 13:00:00	AAPL	Stock	9.2232	9.2411	9.2071	9.2346	34066564.0
2010-06-15 13:30:00	AAPL	Stock	9.2361	9.2475	9.2275	9.2446	21927332.0
2010-06-15 14:00:00	AAPL	Stock	9.2446	9.2661	9.2404	9.2621	36268708.0
2010-06-15 14:30:00	AAPL	Stock	9.2614	9.2643	9.2418	9.2454	25773272.0
2010-06-15 15:00:00	AAPL	Stock	9.2439	9.2679	9.2357	9.2657	32781168.0
2010-06-15 15:30:00	AAPL	Stock	9.2657	9.2804	9.2579	9.2786	69630932.0
2010-06-15 16:00:00	AAPL	Stock	9.275	9.2815	9.224	9.275	24325784.0
2010-06-15 16:30:00	AAPL	Stock	9.2736	9.275	9.1455	9.2714	1059968.0
2010-06-15 17:00:00	AAPL	Stock	9.2707	9.2754	9.2696	9.275	124712.0
2010-06-15 17:30:00	AAPL	Stock	9.2718	9.2764	9.2718	9.2764	150500.0
2010-06-15 18:00:00	AAPL	Stock	9.2736	9.2746	9.25	9.2571	405272.0
2010-06-15 18:30:00	AAPL	Stock	9.2532	9.2675	9.25	9.2575	145040.0
2010-06-15 19:00:00	AAPL	Stock	9.2571	9.2571	9.2357	9.2379	222992.0
2010-06-15 19:30:00	AAPL	Stock	9.2425	9.2496	9.2325	9.2496	668696.0
2010-06-15 07:00:00	MSFT	Stock	25.75	25.75	25.63	25.63	2000.0
2010-06-15 08:00:00	MSFT	Stock	25.69	25.72	25.534	25.69	8711.0
2010-06-15 08:30:00	MSFT	Stock	25.69	25.74	25.68	25.71	36215.0
2010-06-15 09:00:00	MSFT	Stock	25.7	25.75	25.68	25.74	33600.0
2010-06-15 09:30:00	MSFT	Stock	25.75	26.05	25.67	26.01	6910592.0
2010-06-15 10:00:00	MSFT	Stock	26.01	26.07	25.92	26.05	4861839.0
2010-06-15 10:30:00	MSFT	Stock	26.045	26.13	25.99	26.05	4487969.0
2010-06-15 11:00:00	MSFT	Stock	26.04	26.19	26.02	26.16	4926433.0
2010-06-15 11:30:00	MSFT	Stock	26.16	26.4	26.14	26.36	8506534.0
2010-06-15 12:00:00	MSFT	Stock	26.36	26.442	26.33	26.37	5334265.0
2010-06-15 12:30:00	MSFT	Stock	26.36	26.45	26.32	26.38	2518482.0
2010-06-15 13:00:00	MSFT	Stock	26.38	26.45	26.25	26.345	3117604.0
2010-06-15 13:30:00	MSFT	Stock	26.35	26.37	26.29	26.35	2045799.0
2010-06-15 14:00:00	MSFT	Stock	26.34	26.5	26.34	26.488	4119026.0
2010-06-15 14:30:00	MSFT	Stock	26.48	26.55	26.46	26.47	4625201.0
2010-06-15 15:00:00	MSFT	Stock	26.475	26.6	26.47	26.564	5337167.0
2010-06-15 15:30:00	MSFT	Stock	26.565	26.65	26.55	26.58	14017617.0
2010-06-15 16:00:00	MSFT	Stock	26.58	26.66	26.315	26.54	8177653.0
2010-06-15 16:30:00	MSFT	Stock	26.58	26.62	26.293	26.58	151863.0
2010-06-15 17:00:00	MSFT	Stock	26.58	26.58	26.5	26.52	11892.0

> showing 50 of 74,294 rows — these rows as CSV

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