PREVIEW / stock_1hour / 2012-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-09.parquet
  size:    948 KB
  rows:    45,738
  symbols: 3,534

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-01-09 04:00:00	AAPL	Stock	15.1254	15.1429	15.1254	15.1429	6160.0
2012-01-09 05:00:00	AAPL	Stock	15.125	15.125	15.1075	15.1075	58800.0
2012-01-09 06:00:00	AAPL	Stock	15.0982	15.0982	15.0914	15.0914	30800.0
2012-01-09 07:00:00	AAPL	Stock	15.0964	15.1582	15.0914	15.1429	756280.0
2012-01-09 08:00:00	AAPL	Stock	15.1332	15.2107	15.1232	15.1889	3133452.0
2012-01-09 09:00:00	AAPL	Stock	15.1889	15.2425	15.1632	15.2193	71297016.0
2012-01-09 10:00:00	AAPL	Stock	15.2193	15.2768	15.1921	15.2139	80778152.0
2012-01-09 11:00:00	AAPL	Stock	15.2128	15.2143	15.1029	15.1068	56348768.0
2012-01-09 12:00:00	AAPL	Stock	15.1068	15.1518	15.0482	15.1421	52244192.0
2012-01-09 13:00:00	AAPL	Stock	15.1425	15.1525	15.1111	15.1189	21150752.0
2012-01-09 14:00:00	AAPL	Stock	15.1196	15.1782	15.0893	15.1139	32065992.0
2012-01-09 15:00:00	AAPL	Stock	15.1145	15.135	15.0543	15.0618	50130416.0
2012-01-09 16:00:00	AAPL	Stock	15.0579	15.216	15.0536	15.0711	16480828.0
2012-01-09 17:00:00	AAPL	Stock	15.0707	15.0757	15.0446	15.06	228592.0
2012-01-09 18:00:00	AAPL	Stock	15.0568	15.0875	15.0568	15.0868	219940.0
2012-01-09 19:00:00	AAPL	Stock	15.0875	15.1143	15.0875	15.1018	275856.0
2012-01-09 06:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	2500.0
2012-01-09 07:00:00	MSFT	Stock	28.0	28.22	28.0	28.1	1175.0
2012-01-09 08:00:00	MSFT	Stock	28.15	28.18	28.12	28.17	27900.0
2012-01-09 09:00:00	MSFT	Stock	28.17	28.18	27.93	28.02	9328620.0
2012-01-09 10:00:00	MSFT	Stock	28.015	28.03	27.88	27.9	9548961.0
2012-01-09 11:00:00	MSFT	Stock	27.895	27.94	27.73	27.88	8041243.0
2012-01-09 12:00:00	MSFT	Stock	27.89	27.95	27.76	27.79	6047033.0
2012-01-09 13:00:00	MSFT	Stock	27.785	27.87	27.76	27.81	4709906.0
2012-01-09 14:00:00	MSFT	Stock	27.815	27.85	27.76	27.796	5599396.0
2012-01-09 15:00:00	MSFT	Stock	27.79	27.81	27.72	27.74	12921630.0
2012-01-09 16:00:00	MSFT	Stock	27.73	28.11	27.7	27.7	2490425.0
2012-01-09 17:00:00	MSFT	Stock	27.76	27.77	27.75	27.77	4700.0
2012-01-09 18:00:00	MSFT	Stock	27.77	28.0	27.74	27.77	10600.0
2012-01-09 19:00:00	MSFT	Stock	27.78	27.81	27.78	27.8	1200.0
2012-01-09 08:00:00	NVDA	Stock	0.365	0.3658	0.365	0.3658	200000.0
2012-01-09 09:00:00	NVDA	Stock	0.364	0.3705	0.3618	0.37	60418840.0
2012-01-09 10:00:00	NVDA	Stock	0.37	0.3705	0.363	0.3642	98245560.0
2012-01-09 11:00:00	NVDA	Stock	0.3641	0.3668	0.361	0.364	73831440.0
2012-01-09 12:00:00	NVDA	Stock	0.364	0.366	0.363	0.3652	50165000.0
2012-01-09 13:00:00	NVDA	Stock	0.3651	0.366	0.3638	0.3645	36681000.0
2012-01-09 14:00:00	NVDA	Stock	0.3645	0.3652	0.3628	0.3632	56042360.0
2012-01-09 15:00:00	NVDA	Stock	0.3632	0.3642	0.3625	0.3638	113200080.0
2012-01-09 16:00:00	NVDA	Stock	0.363	0.3648	0.3622	0.3643	1305480.0
2012-01-09 17:00:00	NVDA	Stock	0.3622	0.365	0.3622	0.365	654800.0
2012-01-09 18:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	20000.0
2012-01-09 19:00:00	NVDA	Stock	0.3632	0.3655	0.3632	0.365	112000.0
2012-01-09 04:00:00	AMZN	Stock	9.1125	9.13	9.1125	9.13	20000.0
2012-01-09 05:00:00	AMZN	Stock	9.13	9.13	9.13	9.13	2000.0
2012-01-09 07:00:00	AMZN	Stock	9.15	9.1525	9.15	9.1525	22800.0
2012-01-09 08:00:00	AMZN	Stock	9.15	9.16	9.1165	9.134	170700.0
2012-01-09 09:00:00	AMZN	Stock	9.134	9.2185	9.0415	9.0492	15585040.0
2012-01-09 10:00:00	AMZN	Stock	9.0455	9.083	8.9005	8.931	19821360.0
2012-01-09 11:00:00	AMZN	Stock	8.934	8.9369	8.85	8.8725	14261700.0
2012-01-09 12:00:00	AMZN	Stock	8.875	8.955	8.8605	8.9145	7460000.0

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

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