PREVIEW / stock_30min / 2013-12-24

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-24.parquet
  size:    1.0 MB
  rows:    50,138
  symbols: 3,461

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-12-24 04:00:00	AAPL	Stock	20.37	20.37	20.37	20.37	2800.0
2013-12-24 05:00:00	AAPL	Stock	20.3854	20.4064	20.3854	20.4	39200.0
2013-12-24 05:30:00	AAPL	Stock	20.435	20.435	20.435	20.435	2800.0
2013-12-24 06:00:00	AAPL	Stock	20.435	20.435	20.3929	20.3929	12124.0
2013-12-24 06:30:00	AAPL	Stock	20.4286	20.4286	20.4261	20.4261	8400.0
2013-12-24 07:00:00	AAPL	Stock	20.4246	20.4246	20.3329	20.3329	179396.0
2013-12-24 07:30:00	AAPL	Stock	20.3429	20.375	20.3429	20.3571	104496.0
2013-12-24 08:00:00	AAPL	Stock	20.3446	20.4257	20.3279	20.3357	482468.0
2013-12-24 08:30:00	AAPL	Stock	20.3367	20.3568	20.3257	20.3489	411236.0
2013-12-24 09:00:00	AAPL	Stock	20.3518	20.3739	20.3346	20.3489	859236.0
2013-12-24 09:30:00	AAPL	Stock	20.3521	20.4243	20.2786	20.3651	47433960.0
2013-12-24 10:00:00	AAPL	Stock	20.3636	20.3725	20.2925	20.2945	26087992.0
2013-12-24 10:30:00	AAPL	Stock	20.2945	20.2961	20.2518	20.2714	15927436.0
2013-12-24 11:00:00	AAPL	Stock	20.2714	20.2739	20.2239	20.2529	13467776.0
2013-12-24 11:30:00	AAPL	Stock	20.2504	20.2575	20.2154	20.2179	10362072.0
2013-12-24 12:00:00	AAPL	Stock	20.2182	20.2754	20.2161	20.2743	11387964.0
2013-12-24 12:30:00	AAPL	Stock	20.2734	20.2796	20.2518	20.2757	13516832.0
2013-12-24 13:00:00	AAPL	Stock	20.2739	20.3061	20.2689	20.2839	2908220.0
2013-12-24 13:30:00	AAPL	Stock	20.2821	20.2893	20.2821	20.286	207200.0
2013-12-24 14:00:00	AAPL	Stock	20.2829	20.2918	20.2814	20.2857	131460.0
2013-12-24 14:30:00	AAPL	Stock	20.2864	20.2921	20.2857	20.2857	51380.0
2013-12-24 15:00:00	AAPL	Stock	20.2925	20.295	20.2921	20.2946	137368.0
2013-12-24 15:30:00	AAPL	Stock	20.2893	20.3036	20.2893	20.3036	60340.0
2013-12-24 16:00:00	AAPL	Stock	20.3054	20.3054	20.2811	20.2893	40040.0
2013-12-24 16:30:00	AAPL	Stock	20.2864	20.2864	20.2739	20.2739	55300.0
2013-12-24 09:00:00	MSFT	Stock	36.63	36.74	36.6	36.73	17968.0
2013-12-24 09:30:00	MSFT	Stock	36.72	36.94	36.64	36.91	2012369.0
2013-12-24 10:00:00	MSFT	Stock	36.9	37.17	36.86	37.073	2492859.0
2013-12-24 10:30:00	MSFT	Stock	37.07	37.12	36.995	37.04	1617445.0
2013-12-24 11:00:00	MSFT	Stock	37.03	37.11	37.01	37.013	1147860.0
2013-12-24 11:30:00	MSFT	Stock	37.01	37.09	36.995	37.06	1040869.0
2013-12-24 12:00:00	MSFT	Stock	37.06	37.14	37.04	37.125	1242640.0
2013-12-24 12:30:00	MSFT	Stock	37.13	37.13	37.024	37.09	2594067.0
2013-12-24 13:00:00	MSFT	Stock	37.1	37.15	36.678	37.08	1235511.0
2013-12-24 13:30:00	MSFT	Stock	36.97	37.088	36.97	37.088	10345.0
2013-12-24 14:00:00	MSFT	Stock	37.15	37.15	37.09	37.09	200.0
2013-12-24 15:00:00	MSFT	Stock	37.15	37.15	37.15	37.15	1700.0
2013-12-24 15:30:00	MSFT	Stock	37.15	37.15	37.15	37.15	100.0
2013-12-24 16:00:00	MSFT	Stock	37.1	37.1	37.07	37.07	500.0
2013-12-24 09:30:00	NVDA	Stock	0.3968	0.3968	0.3922	0.3922	9685320.0
2013-12-24 10:00:00	NVDA	Stock	0.3925	0.3925	0.3915	0.3924	8221360.0
2013-12-24 10:30:00	NVDA	Stock	0.3925	0.3925	0.3918	0.3919	7255960.0
2013-12-24 11:00:00	NVDA	Stock	0.3919	0.3925	0.3915	0.3922	8904920.0
2013-12-24 11:30:00	NVDA	Stock	0.3922	0.3929	0.392	0.3926	6421760.0
2013-12-24 12:00:00	NVDA	Stock	0.3925	0.3942	0.3925	0.3942	8332560.0
2013-12-24 12:30:00	NVDA	Stock	0.3941	0.3955	0.394	0.3955	18727720.0
2013-12-24 13:00:00	NVDA	Stock	0.3953	0.3955	0.3935	0.3955	2116120.0
2013-12-24 14:00:00	NVDA	Stock	0.3956	0.3956	0.3956	0.3956	141320.0
2013-12-24 08:00:00	AMZN	Stock	20.185	20.185	20.1	20.15	32060.0
2013-12-24 08:30:00	AMZN	Stock	20.175	20.175	20.15	20.15	30000.0

> showing 50 of 50,138 rows — these rows as CSV

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