PREVIEW / stock_1hour / 2013-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-08.parquet
  size:    977 KB
  rows:    45,472
  symbols: 3,494

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-03-08 04:00:00	AAPL	Stock	15.3964	15.4196	15.3921	15.4196	30800.0
2013-03-08 05:00:00	AAPL	Stock	15.4196	15.4196	15.3964	15.4196	16800.0
2013-03-08 06:00:00	AAPL	Stock	15.4196	15.4196	15.4068	15.4068	65408.0
2013-03-08 07:00:00	AAPL	Stock	15.4089	15.4593	15.3393	15.35	904372.0
2013-03-08 08:00:00	AAPL	Stock	15.3621	15.4429	15.2904	15.3121	4417448.0
2013-03-08 09:00:00	AAPL	Stock	15.3121	15.5511	15.3	15.51	105189028.0
2013-03-08 10:00:00	AAPL	Stock	15.5143	15.5143	15.3571	15.4443	72928576.0
2013-03-08 11:00:00	AAPL	Stock	15.4439	15.4671	15.3893	15.4412	34946912.0
2013-03-08 12:00:00	AAPL	Stock	15.4414	15.4518	15.3446	15.3736	33107620.0
2013-03-08 13:00:00	AAPL	Stock	15.3732	15.4414	15.3643	15.4059	26878572.0
2013-03-08 14:00:00	AAPL	Stock	15.4068	15.4282	15.3754	15.3943	18433856.0
2013-03-08 15:00:00	AAPL	Stock	15.3957	15.4504	15.3854	15.4125	58833908.0
2013-03-08 16:00:00	AAPL	Stock	15.4186	15.4382	15.4068	15.4225	25488848.0
2013-03-08 17:00:00	AAPL	Stock	15.4196	15.5411	15.4093	15.4179	1675296.0
2013-03-08 18:00:00	AAPL	Stock	15.4179	15.4179	15.4125	15.4179	93184.0
2013-03-08 19:00:00	AAPL	Stock	15.4179	15.4268	15.4179	15.4232	84980.0
2013-03-08 04:00:00	MSFT	Stock	28.22	28.22	28.22	28.22	100.0
2013-03-08 05:00:00	MSFT	Stock	28.23	28.23	28.23	28.23	100.0
2013-03-08 07:00:00	MSFT	Stock	28.15	28.15	28.15	28.15	300.0
2013-03-08 08:00:00	MSFT	Stock	28.27	28.28	28.2	28.24	24707.0
2013-03-08 09:00:00	MSFT	Stock	28.24	28.33	28.07	28.09	3941413.0
2013-03-08 10:00:00	MSFT	Stock	28.09	28.22	28.032	28.175	4615733.0
2013-03-08 11:00:00	MSFT	Stock	28.18	28.21	28.145	28.19	2589271.0
2013-03-08 12:00:00	MSFT	Stock	28.19	28.2	28.07	28.07	3677256.0
2013-03-08 13:00:00	MSFT	Stock	28.08	28.1	28.04	28.045	3443995.0
2013-03-08 14:00:00	MSFT	Stock	28.05	28.07	28.02	28.054	3411250.0
2013-03-08 15:00:00	MSFT	Stock	28.05	28.13	27.96	27.991	12623690.0
2013-03-08 16:00:00	MSFT	Stock	27.99	28.181	27.96	28.0	3216354.0
2013-03-08 17:00:00	MSFT	Stock	28.0	28.0	27.99	28.0	2800.0
2013-03-08 18:00:00	MSFT	Stock	27.99	28.0	27.99	28.0	3150.0
2013-03-08 19:00:00	MSFT	Stock	28.0	28.0	27.99	27.99	1210.0
2013-03-08 08:00:00	NVDA	Stock	0.319	0.322	0.319	0.3213	214600.0
2013-03-08 09:00:00	NVDA	Stock	0.3213	0.322	0.3183	0.3193	30680200.0
2013-03-08 10:00:00	NVDA	Stock	0.3193	0.3213	0.3183	0.3198	55950960.0
2013-03-08 11:00:00	NVDA	Stock	0.3199	0.3205	0.3188	0.32	25436560.0
2013-03-08 12:00:00	NVDA	Stock	0.3201	0.3203	0.319	0.32	16224200.0
2013-03-08 13:00:00	NVDA	Stock	0.32	0.3205	0.3198	0.3205	12563400.0
2013-03-08 14:00:00	NVDA	Stock	0.3204	0.3213	0.3198	0.3211	27272000.0
2013-03-08 15:00:00	NVDA	Stock	0.3211	0.3215	0.3203	0.3203	66145120.0
2013-03-08 16:00:00	NVDA	Stock	0.3205	0.3205	0.3198	0.3205	9975960.0
2013-03-08 17:00:00	NVDA	Stock	0.3205	0.3205	0.3205	0.3205	188280.0
2013-03-08 19:00:00	NVDA	Stock	0.3205	0.3205	0.3205	0.3205	20000.0
2013-03-08 05:00:00	AMZN	Stock	13.7555	13.7555	13.7555	13.7555	2000.0
2013-03-08 08:00:00	AMZN	Stock	13.7025	13.7725	13.7025	13.7515	261260.0
2013-03-08 09:00:00	AMZN	Stock	13.752	13.772	13.613	13.6625	6299180.0
2013-03-08 10:00:00	AMZN	Stock	13.658	13.659	13.575	13.602	6995120.0
2013-03-08 11:00:00	AMZN	Stock	13.5975	13.6586	13.584	13.65	4354760.0
2013-03-08 12:00:00	AMZN	Stock	13.65	13.654	13.61	13.6325	2470380.0
2013-03-08 13:00:00	AMZN	Stock	13.6305	13.6735	13.6275	13.666	3696300.0
2013-03-08 14:00:00	AMZN	Stock	13.666	13.73	13.663	13.715	6509360.0

> showing 50 of 45,472 rows — these rows as CSV

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