PREVIEW / stock_1hour / 2012-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-11.parquet
  size:    958 KB
  rows:    45,187
  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
2012-12-11 04:00:00	AAPL	Stock	19.0179	19.0975	19.0179	19.0818	65576.0
2012-12-11 05:00:00	AAPL	Stock	19.0714	19.0839	19.0518	19.0536	61600.0
2012-12-11 06:00:00	AAPL	Stock	19.0586	19.0693	19.0446	19.0668	56000.0
2012-12-11 07:00:00	AAPL	Stock	19.0614	19.1	19.0071	19.0854	478576.0
2012-12-11 08:00:00	AAPL	Stock	19.0954	19.2236	19.0357	19.1575	4412744.0
2012-12-11 09:00:00	AAPL	Stock	19.1596	19.4286	19.1586	19.3723	101032708.0
2012-12-11 10:00:00	AAPL	Stock	19.3711	19.5318	19.2993	19.4693	90729548.0
2012-12-11 11:00:00	AAPL	Stock	19.4714	19.6271	19.4429	19.47	99484476.0
2012-12-11 12:00:00	AAPL	Stock	19.4736	19.5761	19.3946	19.4964	58639560.0
2012-12-11 13:00:00	AAPL	Stock	19.4929	19.5482	19.4175	19.5107	35301784.0
2012-12-11 14:00:00	AAPL	Stock	19.5107	19.5446	19.3196	19.3632	65842532.0
2012-12-11 15:00:00	AAPL	Stock	19.3632	19.3804	19.2143	19.3218	114741284.0
2012-12-11 16:00:00	AAPL	Stock	19.3218	19.5118	19.3067	19.3679	9883916.0
2012-12-11 17:00:00	AAPL	Stock	19.3675	19.4054	19.3471	19.3971	839300.0
2012-12-11 18:00:00	AAPL	Stock	19.3982	19.4036	19.3764	19.3964	347732.0
2012-12-11 19:00:00	AAPL	Stock	19.3979	19.4018	19.3821	19.3936	277452.0
2012-12-11 05:00:00	MSFT	Stock	27.05	27.14	27.05	27.14	1985.0
2012-12-11 06:00:00	MSFT	Stock	27.14	27.14	27.14	27.14	320.0
2012-12-11 07:00:00	MSFT	Stock	27.1	27.14	27.1	27.12	5038.0
2012-12-11 08:00:00	MSFT	Stock	27.11	27.12	26.99	27.06	33085.0
2012-12-11 09:00:00	MSFT	Stock	27.07	27.29	27.04	27.28	6492905.0
2012-12-11 10:00:00	MSFT	Stock	27.285	27.48	27.25	27.415	9195634.0
2012-12-11 11:00:00	MSFT	Stock	27.42	27.48	27.3	27.31	6143076.0
2012-12-11 12:00:00	MSFT	Stock	27.31	27.47	27.28	27.43	6276041.0
2012-12-11 13:00:00	MSFT	Stock	27.42	27.48	27.4	27.47	4427935.0
2012-12-11 14:00:00	MSFT	Stock	27.47	27.49	27.33	27.364	4826510.0
2012-12-11 15:00:00	MSFT	Stock	27.36	27.37	27.2	27.32	10391994.0
2012-12-11 16:00:00	MSFT	Stock	27.32	27.44	26.845	27.4	3257730.0
2012-12-11 17:00:00	MSFT	Stock	27.42	27.42	27.38	27.38	10550.0
2012-12-11 18:00:00	MSFT	Stock	27.38	27.38	27.37	27.37	3650.0
2012-12-11 19:00:00	MSFT	Stock	27.37	27.37	27.36	27.36	4395.0
2012-12-11 08:00:00	NVDA	Stock	0.31	0.3113	0.31	0.3113	152000.0
2012-12-11 09:00:00	NVDA	Stock	0.3105	0.3203	0.3093	0.3175	114670400.0
2012-12-11 10:00:00	NVDA	Stock	0.3178	0.318	0.3153	0.3163	159157480.0
2012-12-11 11:00:00	NVDA	Stock	0.3163	0.3169	0.3155	0.3158	81104760.0
2012-12-11 12:00:00	NVDA	Stock	0.3158	0.3173	0.3155	0.3173	48862800.0
2012-12-11 13:00:00	NVDA	Stock	0.3173	0.3185	0.3163	0.3185	91106200.0
2012-12-11 14:00:00	NVDA	Stock	0.3184	0.3195	0.3173	0.3175	114350200.0
2012-12-11 15:00:00	NVDA	Stock	0.3175	0.3176	0.314	0.316	176708280.0
2012-12-11 16:00:00	NVDA	Stock	0.3163	0.3183	0.3091	0.3183	17136000.0
2012-12-11 18:00:00	NVDA	Stock	0.3173	0.318	0.3173	0.318	28000.0
2012-12-11 04:00:00	AMZN	Stock	12.3875	12.3875	12.3875	12.3875	2000.0
2012-12-11 05:00:00	AMZN	Stock	12.399	12.399	12.399	12.399	2000.0
2012-12-11 07:00:00	AMZN	Stock	12.4335	12.453	12.433	12.433	33500.0
2012-12-11 08:00:00	AMZN	Stock	12.4475	12.4495	12.3835	12.44	196180.0
2012-12-11 09:00:00	AMZN	Stock	12.44	12.4875	12.345	12.3955	11818960.0
2012-12-11 10:00:00	AMZN	Stock	12.395	12.5765	12.3325	12.5565	19913160.0
2012-12-11 11:00:00	AMZN	Stock	12.558	12.674	12.55	12.6085	12860520.0
2012-12-11 12:00:00	AMZN	Stock	12.6095	12.644	12.575	12.586	8285360.0
2012-12-11 13:00:00	AMZN	Stock	12.5865	12.6145	12.5565	12.601	7239320.0

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

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