PREVIEW / stock_1hour / 2013-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-07.parquet
  size:    969 KB
  rows:    45,667
  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-07 05:00:00	AAPL	Stock	15.165	15.165	15.1643	15.1643	11676.0
2013-03-07 07:00:00	AAPL	Stock	15.1786	15.1893	15.1325	15.1429	283080.0
2013-03-07 08:00:00	AAPL	Stock	15.1607	15.2193	15.1429	15.2143	1515948.0
2013-03-07 09:00:00	AAPL	Stock	15.2143	15.23	15.0464	15.0782	61781300.0
2013-03-07 10:00:00	AAPL	Stock	15.0807	15.1682	15.0379	15.1362	74372088.0
2013-03-07 11:00:00	AAPL	Stock	15.1372	15.3789	15.1332	15.3303	104276172.0
2013-03-07 12:00:00	AAPL	Stock	15.3287	15.3481	15.2446	15.3289	48779724.0
2013-03-07 13:00:00	AAPL	Stock	15.3275	15.3307	15.2254	15.2571	34086472.0
2013-03-07 14:00:00	AAPL	Stock	15.2575	15.3554	15.1907	15.3554	40313924.0
2013-03-07 15:00:00	AAPL	Stock	15.355	15.4289	15.3132	15.3714	83450360.0
2013-03-07 16:00:00	AAPL	Stock	15.3718	15.3971	15.2045	15.3918	10441452.0
2013-03-07 17:00:00	AAPL	Stock	15.3893	15.3929	15.3779	15.3893	261856.0
2013-03-07 18:00:00	AAPL	Stock	15.3893	15.3914	15.3779	15.3911	164612.0
2013-03-07 19:00:00	AAPL	Stock	15.3857	15.3893	15.3789	15.3789	335328.0
2013-03-07 08:00:00	MSFT	Stock	28.05	28.1	28.0	28.1	3598.0
2013-03-07 09:00:00	MSFT	Stock	28.15	28.24	28.005	28.14	2865950.0
2013-03-07 10:00:00	MSFT	Stock	28.131	28.26	28.1	28.16	4140984.0
2013-03-07 11:00:00	MSFT	Stock	28.163	28.2	28.14	28.16	3221249.0
2013-03-07 12:00:00	MSFT	Stock	28.155	28.25	28.12	28.235	3552224.0
2013-03-07 13:00:00	MSFT	Stock	28.235	28.28	28.15	28.17	2792794.0
2013-03-07 14:00:00	MSFT	Stock	28.17	28.19	28.1	28.16	4939938.0
2013-03-07 15:00:00	MSFT	Stock	28.16	28.2	28.13	28.14	5367637.0
2013-03-07 16:00:00	MSFT	Stock	28.14	28.231	28.14	28.14	2042313.0
2013-03-07 17:00:00	MSFT	Stock	28.1	28.14	28.1	28.14	6020.0
2013-03-07 19:00:00	MSFT	Stock	28.13	28.13	28.11	28.11	939.0
2013-03-07 08:00:00	NVDA	Stock	0.3243	0.3243	0.32	0.321	128000.0
2013-03-07 09:00:00	NVDA	Stock	0.3215	0.3248	0.3205	0.3242	42367120.0
2013-03-07 10:00:00	NVDA	Stock	0.3242	0.3245	0.3213	0.3213	45465080.0
2013-03-07 11:00:00	NVDA	Stock	0.3213	0.3215	0.3205	0.321	27569960.0
2013-03-07 12:00:00	NVDA	Stock	0.3208	0.321	0.3195	0.3203	31547320.0
2013-03-07 13:00:00	NVDA	Stock	0.3203	0.321	0.3195	0.32	30496000.0
2013-03-07 14:00:00	NVDA	Stock	0.3201	0.3205	0.319	0.32	41192040.0
2013-03-07 15:00:00	NVDA	Stock	0.3201	0.321	0.3188	0.3188	85522520.0
2013-03-07 16:00:00	NVDA	Stock	0.319	0.3203	0.3185	0.3188	9869160.0
2013-03-07 17:00:00	NVDA	Stock	0.3188	0.3188	0.318	0.318	68000.0
2013-03-07 18:00:00	NVDA	Stock	0.3183	0.3183	0.3183	0.3183	236000.0
2013-03-07 06:00:00	AMZN	Stock	13.7325	13.7325	13.7295	13.7295	4000.0
2013-03-07 07:00:00	AMZN	Stock	13.709	13.709	13.695	13.705	52000.0
2013-03-07 08:00:00	AMZN	Stock	13.7	13.7095	13.698	13.7075	98500.0
2013-03-07 09:00:00	AMZN	Stock	13.7015	13.74	13.6175	13.6465	4629040.0
2013-03-07 10:00:00	AMZN	Stock	13.6545	13.717	13.5925	13.695	7843180.0
2013-03-07 11:00:00	AMZN	Stock	13.6945	13.7375	13.677	13.678	4639100.0
2013-03-07 12:00:00	AMZN	Stock	13.679	13.6965	13.6425	13.6442	2886780.0
2013-03-07 13:00:00	AMZN	Stock	13.65	13.6673	13.61	13.6592	3830760.0
2013-03-07 14:00:00	AMZN	Stock	13.6645	13.6875	13.611	13.6755	4027800.0
2013-03-07 15:00:00	AMZN	Stock	13.6792	13.729	13.6685	13.6945	7560620.0
2013-03-07 16:00:00	AMZN	Stock	13.694	13.7026	13.6716	13.685	2733060.0
2013-03-07 17:00:00	AMZN	Stock	13.694	13.694	13.694	13.694	4500.0
2013-03-07 19:00:00	AMZN	Stock	13.6855	13.6855	13.681	13.681	16000.0
2013-03-07 04:00:00	META	Stock	27.5	27.5	27.5	27.5	900.0

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

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