PREVIEW / stock_1hour / 2015-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-19.parquet
  size:    1.1 MB
  rows:    49,300
  symbols: 3,514

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
2015-06-19 04:00:00	AAPL	Stock	32.0	32.0375	32.0	32.01	2000.0
2015-06-19 05:00:00	AAPL	Stock	32.0325	32.0325	32.0075	32.0075	8800.0
2015-06-19 06:00:00	AAPL	Stock	32.03	32.0375	32.0125	32.0125	15212.0
2015-06-19 07:00:00	AAPL	Stock	32.035	32.0375	32.015	32.02	36192.0
2015-06-19 08:00:00	AAPL	Stock	32.0275	32.04	31.9125	32.005	372000.0
2015-06-19 09:00:00	AAPL	Stock	32.01	32.02	31.82	31.8825	54243912.0
2015-06-19 10:00:00	AAPL	Stock	31.8875	31.905	31.795	31.8425	19787492.0
2015-06-19 11:00:00	AAPL	Stock	31.8425	31.8475	31.7	31.7175	16146624.0
2015-06-19 12:00:00	AAPL	Stock	31.7125	31.7225	31.6675	31.7188	12310748.0
2015-06-19 13:00:00	AAPL	Stock	31.7188	31.79	31.7168	31.7625	10232816.0
2015-06-19 14:00:00	AAPL	Stock	31.765	31.7725	31.6875	31.7075	11112240.0
2015-06-19 15:00:00	AAPL	Stock	31.7075	31.725	31.6	31.605	28797160.0
2015-06-19 16:00:00	AAPL	Stock	31.65	31.67	31.605	31.665	29468132.0
2015-06-19 17:00:00	AAPL	Stock	31.6625	31.68	31.65	31.655	113260.0
2015-06-19 18:00:00	AAPL	Stock	31.6625	31.6625	31.65	31.6518	83332.0
2015-06-19 19:00:00	AAPL	Stock	31.6525	31.66	31.6375	31.655	588948.0
2015-06-19 06:00:00	MSFT	Stock	46.89	46.9	46.83	46.83	10308.0
2015-06-19 07:00:00	MSFT	Stock	46.84	46.85	46.84	46.85	550.0
2015-06-19 08:00:00	MSFT	Stock	46.89	46.9	46.8	46.87	10381.0
2015-06-19 09:00:00	MSFT	Stock	46.87	46.92	46.25	46.28	14962489.0
2015-06-19 10:00:00	MSFT	Stock	46.27	46.42	46.19	46.315	3106177.0
2015-06-19 11:00:00	MSFT	Stock	46.32	46.33	46.04	46.08	2432374.0
2015-06-19 12:00:00	MSFT	Stock	46.07	46.13	45.99	46.1	1909402.0
2015-06-19 13:00:00	MSFT	Stock	46.101	46.18	46.03	46.18	1849983.0
2015-06-19 14:00:00	MSFT	Stock	46.17	46.18	46.06	46.1	2646674.0
2015-06-19 15:00:00	MSFT	Stock	46.1	46.17	45.99	46.02	7441904.0
2015-06-19 16:00:00	MSFT	Stock	46.1	46.12	46.01	46.05	13078972.0
2015-06-19 17:00:00	MSFT	Stock	46.05	46.05	46.02	46.02	1800.0
2015-06-19 18:00:00	MSFT	Stock	46.0	46.05	46.0	46.05	5300.0
2015-06-19 19:00:00	MSFT	Stock	46.05	46.05	46.047	46.047	1100.0
2015-06-19 09:00:00	NVDA	Stock	0.5488	0.553	0.5468	0.5472	52535400.0
2015-06-19 10:00:00	NVDA	Stock	0.5472	0.5474	0.5438	0.5448	34483520.0
2015-06-19 11:00:00	NVDA	Stock	0.5448	0.5452	0.5426	0.5432	16442760.0
2015-06-19 12:00:00	NVDA	Stock	0.5435	0.544	0.542	0.5428	12153560.0
2015-06-19 13:00:00	NVDA	Stock	0.5426	0.5432	0.5418	0.5429	16100720.0
2015-06-19 14:00:00	NVDA	Stock	0.5429	0.5446	0.5426	0.5435	22629040.0
2015-06-19 15:00:00	NVDA	Stock	0.5435	0.5478	0.5432	0.5465	88314840.0
2015-06-19 16:00:00	NVDA	Stock	0.5468	0.5468	0.545	0.545	101195960.0
2015-06-19 06:00:00	AMZN	Stock	22.0485	22.056	22.0485	22.056	4300.0
2015-06-19 07:00:00	AMZN	Stock	22.0395	22.05	22.0375	22.0375	82620.0
2015-06-19 08:00:00	AMZN	Stock	22.049	22.055	22.025	22.05	180340.0
2015-06-19 09:00:00	AMZN	Stock	22.0252	22.2495	21.9095	21.928	28821620.0
2015-06-19 10:00:00	AMZN	Stock	21.947	21.9925	21.8005	21.881	9653400.0
2015-06-19 11:00:00	AMZN	Stock	21.8741	21.9625	21.856	21.873	3893200.0
2015-06-19 12:00:00	AMZN	Stock	21.8765	21.9075	21.7875	21.9	5211400.0
2015-06-19 13:00:00	AMZN	Stock	21.906	21.912	21.8135	21.828	3669420.0
2015-06-19 14:00:00	AMZN	Stock	21.829	21.839	21.7085	21.711	6061680.0
2015-06-19 15:00:00	AMZN	Stock	21.718	21.7855	21.662	21.7365	12283100.0
2015-06-19 16:00:00	AMZN	Stock	21.7345	21.752	21.7315	21.7355	2987780.0
2015-06-19 18:00:00	AMZN	Stock	21.752	21.752	21.752	21.752	21000.0

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

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