PREVIEW / stock_30min / 2014-01-08

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-08.parquet
  size:    1.6 MB
  rows:    83,408
  symbols: 3,521

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
2014-01-08 05:00:00	AAPL	Stock	19.2868	19.2907	19.2868	19.2904	8400.0
2014-01-08 05:30:00	AAPL	Stock	19.3179	19.3361	19.3086	19.3086	8400.0
2014-01-08 06:00:00	AAPL	Stock	19.3011	19.3011	19.2968	19.2968	11200.0
2014-01-08 06:30:00	AAPL	Stock	19.2971	19.2971	19.2718	19.2814	8400.0
2014-01-08 07:00:00	AAPL	Stock	19.2679	19.2857	19.2675	19.2857	20440.0
2014-01-08 07:30:00	AAPL	Stock	19.2954	19.3193	19.2879	19.3193	60424.0
2014-01-08 08:00:00	AAPL	Stock	19.3071	19.3204	19.2714	19.2914	406980.0
2014-01-08 08:30:00	AAPL	Stock	19.2814	19.3125	19.2768	19.2857	644140.0
2014-01-08 09:00:00	AAPL	Stock	19.2846	19.2846	19.2411	19.2536	440552.0
2014-01-08 09:30:00	AAPL	Stock	19.2432	19.4442	19.2389	19.4275	50889636.0
2014-01-08 10:00:00	AAPL	Stock	19.4275	19.4539	19.4036	19.4354	17984316.0
2014-01-08 10:30:00	AAPL	Stock	19.4396	19.4843	19.3771	19.3982	22783180.0
2014-01-08 11:00:00	AAPL	Stock	19.4	19.4375	19.3571	19.415	12422396.0
2014-01-08 11:30:00	AAPL	Stock	19.4161	19.4521	19.4025	19.45	8365448.0
2014-01-08 12:00:00	AAPL	Stock	19.4507	19.4661	19.4332	19.445	8970332.0
2014-01-08 12:30:00	AAPL	Stock	19.4452	19.4496	19.4107	19.4336	6232380.0
2014-01-08 13:00:00	AAPL	Stock	19.4321	19.44	19.375	19.4207	8140944.0
2014-01-08 13:30:00	AAPL	Stock	19.4193	19.4436	19.4161	19.4389	6294904.0
2014-01-08 14:00:00	AAPL	Stock	19.4386	19.4611	19.4107	19.4364	8445024.0
2014-01-08 14:30:00	AAPL	Stock	19.4321	19.4639	19.4075	19.412	11062464.0
2014-01-08 15:00:00	AAPL	Stock	19.4128	19.4282	19.3586	19.3654	11105640.0
2014-01-08 15:30:00	AAPL	Stock	19.3661	19.4104	19.3339	19.4061	25603312.0
2014-01-08 16:00:00	AAPL	Stock	19.4093	19.4093	19.3821	19.4007	15916264.0
2014-01-08 16:30:00	AAPL	Stock	19.4057	19.4154	19.4039	19.4154	426580.0
2014-01-08 17:00:00	AAPL	Stock	19.4107	19.4207	19.4093	19.4179	1948324.0
2014-01-08 17:30:00	AAPL	Stock	19.4093	19.4136	19.4089	19.4136	18816.0
2014-01-08 18:00:00	AAPL	Stock	19.4093	19.4093	19.4036	19.4036	59136.0
2014-01-08 18:30:00	AAPL	Stock	19.4036	19.4107	19.4036	19.4064	21840.0
2014-01-08 19:00:00	AAPL	Stock	19.4071	19.4107	19.4057	19.4107	16660.0
2014-01-08 19:30:00	AAPL	Stock	19.4107	19.4168	19.4075	19.4107	46900.0
2014-01-08 04:00:00	MSFT	Stock	36.1	36.1	36.1	36.1	700.0
2014-01-08 04:30:00	MSFT	Stock	36.1	36.1	36.1	36.1	1000.0
2014-01-08 05:00:00	MSFT	Stock	36.1	36.1	35.97	36.05	5740.0
2014-01-08 05:30:00	MSFT	Stock	36.09	36.09	36.09	36.09	100.0
2014-01-08 06:00:00	MSFT	Stock	36.11	36.11	36.1	36.1	931.0
2014-01-08 06:30:00	MSFT	Stock	36.07	36.29	36.07	36.14	2400.0
2014-01-08 07:00:00	MSFT	Stock	36.14	36.24	36.05	36.12	23850.0
2014-01-08 07:30:00	MSFT	Stock	36.13	36.18	36.09	36.14	17787.0
2014-01-08 08:00:00	MSFT	Stock	36.02	36.28	36.02	36.14	454860.0
2014-01-08 08:30:00	MSFT	Stock	36.16	36.2	36.14	36.19	49499.0
2014-01-08 09:00:00	MSFT	Stock	36.2	36.2	35.99	36.03	345182.0
2014-01-08 09:30:00	MSFT	Stock	36.0	36.05	35.74	35.95	7941603.0
2014-01-08 10:00:00	MSFT	Stock	35.95	36.14	35.91	35.96	4367733.0
2014-01-08 10:30:00	MSFT	Stock	35.97	36.02	35.93	35.95	2772329.0
2014-01-08 11:00:00	MSFT	Stock	35.954	35.98	35.88	35.94	3308400.0
2014-01-08 11:30:00	MSFT	Stock	35.945	35.99	35.89	35.94	3791708.0
2014-01-08 12:00:00	MSFT	Stock	35.94	35.95	35.9	35.9	2078769.0
2014-01-08 12:30:00	MSFT	Stock	35.905	35.92	35.75	35.799	4167329.0
2014-01-08 13:00:00	MSFT	Stock	35.8	35.865	35.79	35.83	2203039.0
2014-01-08 13:30:00	MSFT	Stock	35.83	35.83	35.76	35.79	2628410.0

> showing 50 of 83,408 rows — these rows as CSV

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