PREVIEW / stock_1hour / 2014-02-19

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-19.parquet
  size:    1.0 MB
  rows:    49,321
  symbols: 3,542

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
2014-02-19 04:00:00	AAPL	Stock	19.5	19.5089	19.5	19.5089	16520.0
2014-02-19 05:00:00	AAPL	Stock	19.4925	19.4925	19.4911	19.4911	8400.0
2014-02-19 06:00:00	AAPL	Stock	19.4521	19.4521	19.4136	19.4171	20132.0
2014-02-19 07:00:00	AAPL	Stock	19.4196	19.4625	19.4196	19.4589	197484.0
2014-02-19 08:00:00	AAPL	Stock	19.4643	19.4821	19.4286	19.4796	479948.0
2014-02-19 09:00:00	AAPL	Stock	19.4682	19.5318	19.3579	19.4475	37720480.0
2014-02-19 10:00:00	AAPL	Stock	19.4493	19.4564	19.3411	19.3607	39909856.0
2014-02-19 11:00:00	AAPL	Stock	19.3589	19.365	19.2339	19.2339	38793720.0
2014-02-19 12:00:00	AAPL	Stock	19.2339	19.2411	19.0839	19.1964	49013356.0
2014-02-19 13:00:00	AAPL	Stock	19.1982	19.2657	19.1557	19.1943	23454256.0
2014-02-19 14:00:00	AAPL	Stock	19.197	19.265	19.1486	19.1668	23051532.0
2014-02-19 15:00:00	AAPL	Stock	19.1714	19.2004	19.1357	19.1925	37070768.0
2014-02-19 16:00:00	AAPL	Stock	19.1918	19.3493	19.1677	19.2321	11725980.0
2014-02-19 17:00:00	AAPL	Stock	19.2321	19.2368	19.1918	19.2071	1850968.0
2014-02-19 18:00:00	AAPL	Stock	19.2168	19.2232	19.1918	19.2079	294056.0
2014-02-19 19:00:00	AAPL	Stock	19.2143	19.2204	19.2071	19.2168	77280.0
2014-02-19 07:00:00	MSFT	Stock	37.28	37.28	37.28	37.28	200.0
2014-02-19 08:00:00	MSFT	Stock	37.3	37.3	37.2	37.3	8515.0
2014-02-19 09:00:00	MSFT	Stock	37.32	37.49	37.15	37.37	3724983.0
2014-02-19 10:00:00	MSFT	Stock	37.37	37.68	37.22	37.61	5149577.0
2014-02-19 11:00:00	MSFT	Stock	37.615	37.75	37.61	37.64	3262555.0
2014-02-19 12:00:00	MSFT	Stock	37.64	37.645	37.42	37.48	3831183.0
2014-02-19 13:00:00	MSFT	Stock	37.48	37.69	37.48	37.59	2659307.0
2014-02-19 14:00:00	MSFT	Stock	37.593	37.72	37.49	37.525	2924241.0
2014-02-19 15:00:00	MSFT	Stock	37.525	37.56	37.412	37.51	5611346.0
2014-02-19 16:00:00	MSFT	Stock	37.51	37.785	37.45	37.51	1441250.0
2014-02-19 17:00:00	MSFT	Stock	37.51	37.55	37.49	37.55	4550.0
2014-02-19 18:00:00	MSFT	Stock	37.51	37.51	37.51	37.51	41242.0
2014-02-19 19:00:00	MSFT	Stock	37.51	37.51	37.5	37.5	2450.0
2014-02-19 05:00:00	NVDA	Stock	0.4498	0.4498	0.4498	0.4498	4000.0
2014-02-19 06:00:00	NVDA	Stock	0.4498	0.4498	0.4475	0.4475	44000.0
2014-02-19 07:00:00	NVDA	Stock	0.4462	0.4485	0.4462	0.448	80000.0
2014-02-19 08:00:00	NVDA	Stock	0.4485	0.4485	0.4462	0.4462	40000.0
2014-02-19 09:00:00	NVDA	Stock	0.4472	0.4495	0.4455	0.4482	41000760.0
2014-02-19 10:00:00	NVDA	Stock	0.4482	0.4545	0.447	0.454	72193800.0
2014-02-19 11:00:00	NVDA	Stock	0.454	0.4552	0.4529	0.4532	58821360.0
2014-02-19 12:00:00	NVDA	Stock	0.4532	0.4545	0.4528	0.4536	44080320.0
2014-02-19 13:00:00	NVDA	Stock	0.4536	0.457	0.4535	0.456	75274960.0
2014-02-19 14:00:00	NVDA	Stock	0.456	0.4575	0.4552	0.4555	58409680.0
2014-02-19 15:00:00	NVDA	Stock	0.4556	0.456	0.4528	0.4536	79548280.0
2014-02-19 16:00:00	NVDA	Stock	0.4535	0.4542	0.4528	0.4535	2563800.0
2014-02-19 18:00:00	NVDA	Stock	0.4535	0.4535	0.4535	0.4535	118720.0
2014-02-19 08:00:00	AMZN	Stock	17.6825	17.6825	17.5505	17.6	88560.0
2014-02-19 09:00:00	AMZN	Stock	17.5935	17.727	17.55	17.607	10138900.0
2014-02-19 10:00:00	AMZN	Stock	17.607	17.623	17.4175	17.4175	18061260.0
2014-02-19 11:00:00	AMZN	Stock	17.4165	17.4669	17.326	17.326	17389260.0
2014-02-19 12:00:00	AMZN	Stock	17.3295	17.41	17.305	17.399	7493040.0
2014-02-19 13:00:00	AMZN	Stock	17.4035	17.4555	17.3845	17.41	4227620.0
2014-02-19 14:00:00	AMZN	Stock	17.415	17.495	17.361	17.3915	6249100.0
2014-02-19 15:00:00	AMZN	Stock	17.379	17.407	17.306	17.369	11012900.0

> showing 50 of 49,321 rows — these rows as CSV

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