PREVIEW / stock_30min / 2011-09-16

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-16.parquet
  size:    1.4 MB
  rows:    75,120
  symbols: 3,542

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
2011-09-16 04:00:00	AAPL	Stock	14.0604	14.0604	14.0129	14.0129	36400.0
2011-09-16 04:30:00	AAPL	Stock	14.0311	14.035	14.0311	14.035	5600.0
2011-09-16 05:00:00	AAPL	Stock	14.0479	14.0479	14.0446	14.0479	8400.0
2011-09-16 05:30:00	AAPL	Stock	14.0714	14.1157	14.0714	14.1061	25200.0
2011-09-16 06:00:00	AAPL	Stock	14.1161	14.1429	14.1161	14.1271	16800.0
2011-09-16 06:30:00	AAPL	Stock	14.1039	14.1039	14.1004	14.1004	5600.0
2011-09-16 07:00:00	AAPL	Stock	14.1143	14.1429	14.0982	14.1114	187348.0
2011-09-16 07:30:00	AAPL	Stock	14.1161	14.1236	14.0839	14.1161	477652.0
2011-09-16 08:00:00	AAPL	Stock	14.1125	14.1414	14.0857	14.0932	1452752.0
2011-09-16 08:30:00	AAPL	Stock	14.1025	14.1314	14.0964	14.1196	1503124.0
2011-09-16 09:00:00	AAPL	Stock	14.1196	14.1632	14.105	14.1329	3784928.0
2011-09-16 09:30:00	AAPL	Stock	14.1325	14.2725	14.1082	14.2582	160200768.0
2011-09-16 10:00:00	AAPL	Stock	14.2579	14.2811	14.215	14.2293	62893208.0
2011-09-16 10:30:00	AAPL	Stock	14.2257	14.2457	14.1904	14.2131	46415068.0
2011-09-16 11:00:00	AAPL	Stock	14.2143	14.2489	14.2071	14.2216	29686636.0
2011-09-16 11:30:00	AAPL	Stock	14.2243	14.2679	14.2107	14.2454	33982088.0
2011-09-16 12:00:00	AAPL	Stock	14.2479	14.2675	14.2418	14.2611	24401832.0
2011-09-16 12:30:00	AAPL	Stock	14.2614	14.2832	14.2571	14.2778	26426372.0
2011-09-16 13:00:00	AAPL	Stock	14.2786	14.2804	14.2464	14.273	21932176.0
2011-09-16 13:30:00	AAPL	Stock	14.2711	14.2764	14.2387	14.2539	21880936.0
2011-09-16 14:00:00	AAPL	Stock	14.255	14.2643	14.2432	14.2571	16876860.0
2011-09-16 14:30:00	AAPL	Stock	14.2568	14.2836	14.2564	14.2793	28380212.0
2011-09-16 15:00:00	AAPL	Stock	14.2804	14.2811	14.2507	14.2582	29838816.0
2011-09-16 15:30:00	AAPL	Stock	14.2582	14.2986	14.2557	14.2943	102555292.0
2011-09-16 16:00:00	AAPL	Stock	14.2948	14.3036	14.2544	14.2868	50662556.0
2011-09-16 16:30:00	AAPL	Stock	14.2868	14.3039	14.1933	14.2886	10122784.0
2011-09-16 17:00:00	AAPL	Stock	14.2868	14.3036	14.2839	14.2839	554148.0
2011-09-16 17:30:00	AAPL	Stock	14.2814	14.3036	14.2746	14.2925	691936.0
2011-09-16 18:00:00	AAPL	Stock	14.2868	14.335	14.2868	14.3268	1457764.0
2011-09-16 18:30:00	AAPL	Stock	14.3275	14.3275	14.3093	14.3107	272888.0
2011-09-16 19:00:00	AAPL	Stock	14.3143	14.3214	14.3082	14.3161	287756.0
2011-09-16 19:30:00	AAPL	Stock	14.3175	14.3211	14.2857	14.2964	311668.0
2011-09-16 05:00:00	MSFT	Stock	26.8	26.8	26.8	26.8	100.0
2011-09-16 07:30:00	MSFT	Stock	26.9	26.9	26.9	26.9	100.0
2011-09-16 08:00:00	MSFT	Stock	26.91	26.95	26.9	26.93	16400.0
2011-09-16 08:30:00	MSFT	Stock	26.92	26.96	26.92	26.96	3400.0
2011-09-16 09:00:00	MSFT	Stock	26.96	27.07	26.95	27.03	269138.0
2011-09-16 09:30:00	MSFT	Stock	27.05	27.15	26.83	27.07	25054941.0
2011-09-16 10:00:00	MSFT	Stock	27.08	27.15	27.0	27.07	4282531.0
2011-09-16 10:30:00	MSFT	Stock	27.065	27.14	26.975	27.03	5115882.0
2011-09-16 11:00:00	MSFT	Stock	27.025	27.14	27.01	27.1	2953434.0
2011-09-16 11:30:00	MSFT	Stock	27.1	27.16	27.05	27.16	2908267.0
2011-09-16 12:00:00	MSFT	Stock	27.16	27.2	27.125	27.18	2394252.0
2011-09-16 12:30:00	MSFT	Stock	27.175	27.24	27.16	27.18	2644296.0
2011-09-16 13:00:00	MSFT	Stock	27.185	27.25	27.17	27.22	2631324.0
2011-09-16 13:30:00	MSFT	Stock	27.225	27.25	27.16	27.17	2539214.0
2011-09-16 14:00:00	MSFT	Stock	27.18	27.25	27.17	27.215	2087251.0
2011-09-16 14:30:00	MSFT	Stock	27.215	27.27	27.2	27.26	2369328.0
2011-09-16 15:00:00	MSFT	Stock	27.27	27.27	27.2	27.203	3582444.0
2011-09-16 15:30:00	MSFT	Stock	27.21	27.27	27.11	27.12	11756728.0

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

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