PREVIEW / stock_30min / 2010-09-29

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-29.parquet
  size:    1.4 MB
  rows:    72,424
  symbols: 3,477

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-29 05:00:00	AAPL	Stock	10.2682	10.2682	10.2682	10.2682	11200.0
2010-09-29 05:30:00	AAPL	Stock	10.2643	10.2643	10.2607	10.2607	5600.0
2010-09-29 06:00:00	AAPL	Stock	10.2607	10.2607	10.2607	10.2607	8400.0
2010-09-29 06:30:00	AAPL	Stock	10.2643	10.2643	10.2643	10.2643	14000.0
2010-09-29 07:00:00	AAPL	Stock	10.3	10.3	10.265	10.265	19600.0
2010-09-29 07:30:00	AAPL	Stock	10.2661	10.2661	10.2589	10.2654	44800.0
2010-09-29 08:00:00	AAPL	Stock	10.2607	10.3136	10.2607	10.2996	2484272.0
2010-09-29 08:30:00	AAPL	Stock	10.2929	10.3325	10.2746	10.2811	3176012.0
2010-09-29 09:00:00	AAPL	Stock	10.2804	10.2857	10.2539	10.2657	1492344.0
2010-09-29 09:30:00	AAPL	Stock	10.2661	10.3504	10.2371	10.3029	81478768.0
2010-09-29 10:00:00	AAPL	Stock	10.2975	10.3386	10.2598	10.2946	47415704.0
2010-09-29 10:30:00	AAPL	Stock	10.2936	10.3054	10.2775	10.2956	33856144.0
2010-09-29 11:00:00	AAPL	Stock	10.2946	10.3143	10.28	10.3064	22428308.0
2010-09-29 11:30:00	AAPL	Stock	10.3046	10.3282	10.3011	10.3014	20823376.0
2010-09-29 12:00:00	AAPL	Stock	10.3018	10.3093	10.2786	10.2918	24281684.0
2010-09-29 12:30:00	AAPL	Stock	10.2911	10.2982	10.2646	10.2771	28542024.0
2010-09-29 13:00:00	AAPL	Stock	10.2782	10.2882	10.2654	10.2743	21941332.0
2010-09-29 13:30:00	AAPL	Stock	10.2739	10.2804	10.2236	10.25	37375772.0
2010-09-29 14:00:00	AAPL	Stock	10.2496	10.2739	10.2429	10.2486	22807680.0
2010-09-29 14:30:00	AAPL	Stock	10.2493	10.2857	10.2475	10.2775	18726232.0
2010-09-29 15:00:00	AAPL	Stock	10.2782	10.2804	10.2143	10.2404	37903992.0
2010-09-29 15:30:00	AAPL	Stock	10.2411	10.2754	10.2268	10.2621	53481540.0
2010-09-29 16:00:00	AAPL	Stock	10.2618	10.3094	10.2514	10.2618	9048004.0
2010-09-29 16:30:00	AAPL	Stock	10.2668	10.2819	10.2395	10.2632	259420.0
2010-09-29 17:00:00	AAPL	Stock	10.2639	10.2819	10.2525	10.2564	145376.0
2010-09-29 17:30:00	AAPL	Stock	10.2571	10.2604	10.2554	10.2554	194376.0
2010-09-29 18:00:00	AAPL	Stock	10.2589	10.2632	10.2564	10.2564	98952.0
2010-09-29 18:30:00	AAPL	Stock	10.2571	10.2589	10.25	10.25	88564.0
2010-09-29 19:00:00	AAPL	Stock	10.2529	10.2529	10.2439	10.2439	92568.0
2010-09-29 19:30:00	AAPL	Stock	10.25	10.25	10.2396	10.2407	173432.0
2010-09-29 07:30:00	MSFT	Stock	24.71	24.71	24.71	24.71	100.0
2010-09-29 08:00:00	MSFT	Stock	24.7	24.7	24.66	24.68	11490.0
2010-09-29 08:30:00	MSFT	Stock	24.69	24.69	24.65	24.65	8483.0
2010-09-29 09:00:00	MSFT	Stock	24.65	24.68	24.59	24.61	16262.0
2010-09-29 09:30:00	MSFT	Stock	24.63	24.67	24.45	24.49	5464565.0
2010-09-29 10:00:00	MSFT	Stock	24.493	24.52	24.4	24.44	3913958.0
2010-09-29 10:30:00	MSFT	Stock	24.44	24.5	24.41	24.475	2912609.0
2010-09-29 11:00:00	MSFT	Stock	24.475	24.53	24.43	24.52	2357322.0
2010-09-29 11:30:00	MSFT	Stock	24.51	24.58	24.51	24.565	2929361.0
2010-09-29 12:00:00	MSFT	Stock	24.565	24.59	24.52	24.55	2429854.0
2010-09-29 12:30:00	MSFT	Stock	24.545	24.56	24.5	24.509	2171428.0
2010-09-29 13:00:00	MSFT	Stock	24.5	24.56	24.49	24.53	1963411.0
2010-09-29 13:30:00	MSFT	Stock	24.54	24.61	24.5	24.585	2140336.0
2010-09-29 14:00:00	MSFT	Stock	24.59	24.65	24.49	24.508	2878168.0
2010-09-29 14:30:00	MSFT	Stock	24.515	24.62	24.51	24.605	1681379.0
2010-09-29 15:00:00	MSFT	Stock	24.61	24.61	24.415	24.49	3967801.0
2010-09-29 15:30:00	MSFT	Stock	24.48	24.5	24.43	24.48	6763063.0
2010-09-29 16:00:00	MSFT	Stock	24.49	24.713	24.447	24.5	2048548.0
2010-09-29 16:30:00	MSFT	Stock	24.52	24.575	24.455	24.575	84824.0
2010-09-29 17:00:00	MSFT	Stock	24.52	24.52	24.52	24.52	108.0

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

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