PREVIEW / stock_1hour / 2012-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-19.parquet
  size:    956 KB
  rows:    44,946
  symbols: 3,539

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-03-19 04:00:00	AAPL	Stock	21.625	21.625	21.2321	21.4375	1086540.0
2012-03-19 05:00:00	AAPL	Stock	21.4604	21.4786	21.4286	21.4636	437052.0
2012-03-19 06:00:00	AAPL	Stock	21.4643	21.5714	21.4643	21.4911	635824.0
2012-03-19 07:00:00	AAPL	Stock	21.5536	21.7275	21.39	21.39	9593892.0
2012-03-19 08:00:00	AAPL	Stock	21.3929	21.6072	20.6589	21.1071	32152568.0
2012-03-19 09:00:00	AAPL	Stock	21.1071	21.3929	21.0611	21.22	171005520.0
2012-03-19 10:00:00	AAPL	Stock	21.2246	21.2279	21.0375	21.1961	151747596.0
2012-03-19 11:00:00	AAPL	Stock	21.2	21.2857	21.1557	21.2804	91099624.0
2012-03-19 12:00:00	AAPL	Stock	21.2796	21.4286	21.2715	21.4068	118180272.0
2012-03-19 13:00:00	AAPL	Stock	21.4029	21.4254	21.2618	21.3207	86793224.0
2012-03-19 14:00:00	AAPL	Stock	21.319	21.4018	21.3161	21.3814	59694068.0
2012-03-19 15:00:00	AAPL	Stock	21.3789	21.4918	21.3054	21.4721	146790756.0
2012-03-19 16:00:00	AAPL	Stock	21.4643	21.63	21.2622	21.5821	16574572.0
2012-03-19 17:00:00	AAPL	Stock	21.5821	21.6025	21.4836	21.5489	2839564.0
2012-03-19 18:00:00	AAPL	Stock	21.5571	21.5979	21.5529	21.5821	1337280.0
2012-03-19 19:00:00	AAPL	Stock	21.5786	21.5982	21.5736	21.5936	1310316.0
2012-03-19 04:00:00	MSFT	Stock	32.5	32.5	32.5	32.5	262.0
2012-03-19 06:00:00	MSFT	Stock	32.45	32.45	32.38	32.38	500.0
2012-03-19 07:00:00	MSFT	Stock	32.46	32.6	32.45	32.54	10700.0
2012-03-19 08:00:00	MSFT	Stock	32.5	32.59	32.5	32.5	22888.0
2012-03-19 09:00:00	MSFT	Stock	32.54	32.61	32.4	32.54	3262741.0
2012-03-19 10:00:00	MSFT	Stock	32.55	32.55	32.28	32.306	5809477.0
2012-03-19 11:00:00	MSFT	Stock	32.31	32.31	32.16	32.27	9011509.0
2012-03-19 12:00:00	MSFT	Stock	32.28	32.37	32.23	32.239	6850877.0
2012-03-19 13:00:00	MSFT	Stock	32.235	32.4	32.23	32.34	4559482.0
2012-03-19 14:00:00	MSFT	Stock	32.34	32.38	32.28	32.297	3215303.0
2012-03-19 15:00:00	MSFT	Stock	32.3	32.33	32.15	32.21	9824444.0
2012-03-19 16:00:00	MSFT	Stock	32.2	32.618	32.16	32.17	1454771.0
2012-03-19 17:00:00	MSFT	Stock	32.19	32.19	32.18	32.18	1788.0
2012-03-19 18:00:00	MSFT	Stock	32.18	32.2	32.18	32.18	7556.0
2012-03-19 19:00:00	MSFT	Stock	32.2	32.25	32.18	32.2	1173.0
2012-03-19 07:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	20000.0
2012-03-19 08:00:00	NVDA	Stock	0.3675	0.3675	0.3662	0.3672	670000.0
2012-03-19 09:00:00	NVDA	Stock	0.3672	0.3688	0.365	0.3684	61489720.0
2012-03-19 10:00:00	NVDA	Stock	0.3682	0.3685	0.3642	0.3668	53814880.0
2012-03-19 11:00:00	NVDA	Stock	0.3665	0.3675	0.3652	0.3668	40754320.0
2012-03-19 12:00:00	NVDA	Stock	0.3666	0.3668	0.3652	0.3662	26895560.0
2012-03-19 13:00:00	NVDA	Stock	0.3662	0.3688	0.3658	0.3678	66039960.0
2012-03-19 14:00:00	NVDA	Stock	0.3676	0.3688	0.3675	0.3678	39720800.0
2012-03-19 15:00:00	NVDA	Stock	0.3678	0.3682	0.3655	0.3658	104408000.0
2012-03-19 16:00:00	NVDA	Stock	0.3655	0.3675	0.365	0.367	8707880.0
2012-03-19 17:00:00	NVDA	Stock	0.3665	0.3675	0.3658	0.3675	67920.0
2012-03-19 19:00:00	NVDA	Stock	0.3675	0.3675	0.367	0.367	24000.0
2012-03-19 04:00:00	AMZN	Stock	9.234	9.234	9.234	9.234	12000.0
2012-03-19 05:00:00	AMZN	Stock	9.234	9.234	9.234	9.234	10000.0
2012-03-19 06:00:00	AMZN	Stock	9.234	9.234	9.234	9.234	18000.0
2012-03-19 07:00:00	AMZN	Stock	9.261	9.2625	9.213	9.213	26200.0
2012-03-19 08:00:00	AMZN	Stock	9.2245	9.235	9.179	9.179	291220.0
2012-03-19 09:00:00	AMZN	Stock	9.18	9.235	9.139	9.2325	17093000.0
2012-03-19 10:00:00	AMZN	Stock	9.2335	9.2725	9.1766	9.2135	14299420.0

> showing 50 of 44,946 rows — these rows as CSV

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