PREVIEW / stock_30min / 2013-08-09

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-09.parquet
  size:    1.5 MB
  rows:    77,334
  symbols: 3,522

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
2013-08-09 04:00:00	AAPL	Stock	16.4446	16.4446	16.4446	16.4446	10640.0
2013-08-09 05:00:00	AAPL	Stock	16.4268	16.4268	16.3786	16.3786	11032.0
2013-08-09 07:00:00	AAPL	Stock	16.3929	16.3929	16.3896	16.3896	8820.0
2013-08-09 07:30:00	AAPL	Stock	16.4071	16.425	16.4036	16.4161	82852.0
2013-08-09 08:00:00	AAPL	Stock	16.3679	16.4161	16.3661	16.4089	228116.0
2013-08-09 08:30:00	AAPL	Stock	16.4121	16.4211	16.3971	16.4132	167524.0
2013-08-09 09:00:00	AAPL	Stock	16.42	16.4286	16.3761	16.3804	429492.0
2013-08-09 09:30:00	AAPL	Stock	16.3782	16.445	16.3525	16.3793	42302624.0
2013-08-09 10:00:00	AAPL	Stock	16.3775	16.3971	16.2946	16.3318	34497568.0
2013-08-09 10:30:00	AAPL	Stock	16.3285	16.3407	16.2268	16.2439	32095840.0
2013-08-09 11:00:00	AAPL	Stock	16.2446	16.2643	16.2329	16.2546	24696308.0
2013-08-09 11:30:00	AAPL	Stock	16.2546	16.2982	16.2411	16.2932	14713440.0
2013-08-09 12:00:00	AAPL	Stock	16.2932	16.3007	16.2649	16.2857	9239048.0
2013-08-09 12:30:00	AAPL	Stock	16.2857	16.3	16.27	16.2761	6973624.0
2013-08-09 13:00:00	AAPL	Stock	16.2796	16.2964	16.2686	16.2818	6632136.0
2013-08-09 13:30:00	AAPL	Stock	16.2818	16.2907	16.2464	16.2611	10347848.0
2013-08-09 14:00:00	AAPL	Stock	16.2611	16.2764	16.2464	16.265	8527260.0
2013-08-09 14:30:00	AAPL	Stock	16.265	16.2693	16.2396	16.2586	10472896.0
2013-08-09 15:00:00	AAPL	Stock	16.2586	16.2614	16.2364	16.2443	10123064.0
2013-08-09 15:30:00	AAPL	Stock	16.2443	16.2443	16.2018	16.2293	32925816.0
2013-08-09 16:00:00	AAPL	Stock	16.2304	16.2916	16.2111	16.2175	6997648.0
2013-08-09 16:30:00	AAPL	Stock	16.2143	16.2304	16.1975	16.2071	858676.0
2013-08-09 17:00:00	AAPL	Stock	16.2143	16.2643	16.2136	16.2568	758968.0
2013-08-09 17:30:00	AAPL	Stock	16.26	16.2746	16.25	16.2746	442316.0
2013-08-09 18:00:00	AAPL	Stock	16.2696	16.2746	16.2514	16.2625	306376.0
2013-08-09 18:30:00	AAPL	Stock	16.26	16.2689	16.26	16.2654	69356.0
2013-08-09 19:00:00	AAPL	Stock	16.2654	16.2696	16.2639	16.2639	25872.0
2013-08-09 19:30:00	AAPL	Stock	16.2714	16.2714	16.2593	16.2614	127288.0
2013-08-09 08:00:00	MSFT	Stock	32.71	32.77	32.71	32.77	4100.0
2013-08-09 08:30:00	MSFT	Stock	32.79	32.82	32.77	32.78	9300.0
2013-08-09 09:00:00	MSFT	Stock	32.78	32.83	32.77	32.78	13949.0
2013-08-09 09:30:00	MSFT	Stock	32.77	32.85	32.71	32.76	3235479.0
2013-08-09 10:00:00	MSFT	Stock	32.76	32.815	32.68	32.695	2209782.0
2013-08-09 10:30:00	MSFT	Stock	32.692	32.72	32.6	32.63	2221703.0
2013-08-09 11:00:00	MSFT	Stock	32.623	32.63	32.47	32.5	2413891.0
2013-08-09 11:30:00	MSFT	Stock	32.5	32.73	32.495	32.699	1947392.0
2013-08-09 12:00:00	MSFT	Stock	32.69	32.8	32.69	32.78	2356979.0
2013-08-09 12:30:00	MSFT	Stock	32.78	32.81	32.748	32.77	941750.0
2013-08-09 13:00:00	MSFT	Stock	32.78	32.86	32.75	32.851	1494278.0
2013-08-09 13:30:00	MSFT	Stock	32.86	32.9	32.82	32.847	1366032.0
2013-08-09 14:00:00	MSFT	Stock	32.85	32.86	32.7	32.71	1142118.0
2013-08-09 14:30:00	MSFT	Stock	32.71	32.74	32.62	32.666	1444629.0
2013-08-09 15:00:00	MSFT	Stock	32.66	32.7	32.6	32.67	1339269.0
2013-08-09 15:30:00	MSFT	Stock	32.672	32.71	32.62	32.7	2743834.0
2013-08-09 16:00:00	MSFT	Stock	32.7	32.71	32.65	32.65	1388656.0
2013-08-09 16:30:00	MSFT	Stock	32.65	32.77	32.65	32.76	178260.0
2013-08-09 17:00:00	MSFT	Stock	32.71	32.74	32.71	32.74	400.0
2013-08-09 17:30:00	MSFT	Stock	32.82	32.82	32.71	32.71	686.0
2013-08-09 18:00:00	MSFT	Stock	32.74	32.74	32.74	32.74	700.0
2013-08-09 18:30:00	MSFT	Stock	32.73	32.73	32.66	32.66	1707.0

> showing 50 of 77,334 rows — these rows as CSV

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