PREVIEW / stock_30min / 2011-10-19

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-19.parquet
  size:    1.4 MB
  rows:    73,609
  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
2011-10-19 04:00:00	AAPL	Stock	14.1471	14.3214	14.1471	14.3214	158620.0
2011-10-19 04:30:00	AAPL	Stock	14.2921	14.3232	14.2921	14.3175	111440.0
2011-10-19 05:00:00	AAPL	Stock	14.3196	14.3286	14.3125	14.3154	259868.0
2011-10-19 05:30:00	AAPL	Stock	14.3114	14.3286	14.2868	14.3071	65100.0
2011-10-19 06:00:00	AAPL	Stock	14.3107	14.3304	14.2857	14.2954	109900.0
2011-10-19 06:30:00	AAPL	Stock	14.2857	14.3864	14.2857	14.3864	247520.0
2011-10-19 07:00:00	AAPL	Stock	14.3882	14.4561	14.1964	14.2114	3829140.0
2011-10-19 07:30:00	AAPL	Stock	14.2143	14.3214	14.1975	14.2857	3043124.0
2011-10-19 08:00:00	AAPL	Stock	14.2893	14.3214	14.2257	14.2768	6982080.0
2011-10-19 08:30:00	AAPL	Stock	14.2786	14.3879	14.275	14.3711	10530968.0
2011-10-19 09:00:00	AAPL	Stock	14.3696	14.3854	14.2857	14.3339	13702276.0
2011-10-19 09:30:00	AAPL	Stock	14.3339	14.4464	14.2496	14.2843	232396668.0
2011-10-19 10:00:00	AAPL	Stock	14.2836	14.4107	14.23	14.395	120890532.0
2011-10-19 10:30:00	AAPL	Stock	14.395	14.5536	14.3629	14.505	116606280.0
2011-10-19 11:00:00	AAPL	Stock	14.5086	14.5864	14.4543	14.5678	103086340.0
2011-10-19 11:30:00	AAPL	Stock	14.567	14.5696	14.4468	14.452	48830068.0
2011-10-19 12:00:00	AAPL	Stock	14.4504	14.5179	14.4468	14.4982	39339832.0
2011-10-19 12:30:00	AAPL	Stock	14.4997	14.5179	14.4571	14.458	27299048.0
2011-10-19 13:00:00	AAPL	Stock	14.4579	14.4629	14.3732	14.3767	37511040.0
2011-10-19 13:30:00	AAPL	Stock	14.3768	14.4057	14.3432	14.3897	44100280.0
2011-10-19 14:00:00	AAPL	Stock	14.3902	14.3964	14.2864	14.2875	63271768.0
2011-10-19 14:30:00	AAPL	Stock	14.2875	14.375	14.2721	14.3161	63685776.0
2011-10-19 15:00:00	AAPL	Stock	14.3125	14.3239	14.25	14.2529	56122696.0
2011-10-19 15:30:00	AAPL	Stock	14.2521	14.2957	14.2071	14.2432	91092260.0
2011-10-19 16:00:00	AAPL	Stock	14.2436	14.574	14.2182	14.2232	10384276.0
2011-10-19 16:30:00	AAPL	Stock	14.225	14.33	14.2096	14.2375	1394540.0
2011-10-19 17:00:00	AAPL	Stock	14.2446	14.3571	14.2364	14.2746	448308.0
2011-10-19 17:30:00	AAPL	Stock	14.2686	14.2714	14.2643	14.2664	327880.0
2011-10-19 18:00:00	AAPL	Stock	14.2714	14.2768	14.2364	14.2686	210840.0
2011-10-19 18:30:00	AAPL	Stock	14.2732	14.2814	14.2607	14.2611	336392.0
2011-10-19 19:00:00	AAPL	Stock	14.2661	14.2804	14.2539	14.2739	207816.0
2011-10-19 19:30:00	AAPL	Stock	14.2668	14.2814	14.2618	14.2814	148428.0
2011-10-19 05:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	4300.0
2011-10-19 06:00:00	MSFT	Stock	27.28	27.28	27.28	27.28	240.0
2011-10-19 06:30:00	MSFT	Stock	27.31	27.49	27.31	27.49	320.0
2011-10-19 07:00:00	MSFT	Stock	27.44	27.5	27.44	27.5	4400.0
2011-10-19 07:30:00	MSFT	Stock	27.45	27.45	27.38	27.39	10226.0
2011-10-19 08:00:00	MSFT	Stock	27.38	27.47	27.38	27.39	10039.0
2011-10-19 08:30:00	MSFT	Stock	27.39	27.46	27.35	27.4	62528.0
2011-10-19 09:00:00	MSFT	Stock	27.42	27.44	27.37	27.39	31221.0
2011-10-19 09:30:00	MSFT	Stock	27.39	27.47	27.26	27.27	4410238.0
2011-10-19 10:00:00	MSFT	Stock	27.28	27.31	27.12	27.278	3133860.0
2011-10-19 10:30:00	MSFT	Stock	27.28	27.36	27.22	27.32	2062119.0
2011-10-19 11:00:00	MSFT	Stock	27.31	27.34	27.26	27.33	1942752.0
2011-10-19 11:30:00	MSFT	Stock	27.32	27.39	27.25	27.27	2247983.0
2011-10-19 12:00:00	MSFT	Stock	27.26	27.33	27.25	27.33	1749700.0
2011-10-19 12:30:00	MSFT	Stock	27.322	27.47	27.315	27.43	2194319.0
2011-10-19 13:00:00	MSFT	Stock	27.43	27.47	27.34	27.34	1890971.0
2011-10-19 13:30:00	MSFT	Stock	27.34	27.36	27.22	27.24	2862124.0
2011-10-19 14:00:00	MSFT	Stock	27.25	27.26	27.05	27.078	3741295.0

> showing 50 of 73,609 rows — these rows as CSV

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