PREVIEW / stock_1hour / 2018-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-04.parquet
  size:    1.1 MB
  rows:    48,535
  symbols: 2,842

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
2018-05-04 04:00:00	AAPL	Stock	44.375	44.545	44.3675	44.4375	51680.0
2018-05-04 05:00:00	AAPL	Stock	44.4125	44.475	44.405	44.4525	24688.0
2018-05-04 06:00:00	AAPL	Stock	44.4625	44.7375	44.4625	44.6775	165616.0
2018-05-04 07:00:00	AAPL	Stock	44.675	44.8175	44.6375	44.7	589688.0
2018-05-04 08:00:00	AAPL	Stock	44.7025	44.8175	44.625	44.7275	1317916.0
2018-05-04 09:00:00	AAPL	Stock	44.74	45.3025	44.5375	45.3	37177156.0
2018-05-04 10:00:00	AAPL	Stock	45.2975	45.9125	45.1425	45.7175	49796492.0
2018-05-04 11:00:00	AAPL	Stock	45.7188	45.805	45.63	45.675	22094984.0
2018-05-04 12:00:00	AAPL	Stock	45.6725	45.9675	45.64	45.84	19846480.0
2018-05-04 13:00:00	AAPL	Stock	45.845	45.92	45.6825	45.915	14270940.0
2018-05-04 14:00:00	AAPL	Stock	45.9125	46.0	45.82	45.925	16710088.0
2018-05-04 15:00:00	AAPL	Stock	45.925	46.0625	45.885	45.9575	31728316.0
2018-05-04 16:00:00	AAPL	Stock	45.9675	45.9975	45.9475	45.97	9533960.0
2018-05-04 17:00:00	AAPL	Stock	45.98	46.0225	45.9625	45.98	257432.0
2018-05-04 18:00:00	AAPL	Stock	45.985	46.0125	45.98	46.0125	76552.0
2018-05-04 19:00:00	AAPL	Stock	46.02	46.025	46.005	46.025	106680.0
2018-05-04 05:00:00	MSFT	Stock	94.16	94.16	94.16	94.16	200.0
2018-05-04 07:00:00	MSFT	Stock	94.08	94.08	93.91	94.0	2436.0
2018-05-04 08:00:00	MSFT	Stock	93.96	94.26	93.67	93.75	20507.0
2018-05-04 09:00:00	MSFT	Stock	93.75	93.93	92.92	93.57	2329928.0
2018-05-04 10:00:00	MSFT	Stock	93.56	94.9	93.37	94.8	3091961.0
2018-05-04 11:00:00	MSFT	Stock	94.795	95.12	94.65	94.86	2607616.0
2018-05-04 12:00:00	MSFT	Stock	94.87	95.12	94.79	94.9	1541103.0
2018-05-04 13:00:00	MSFT	Stock	94.905	95.09	94.78	95.02	1554839.0
2018-05-04 14:00:00	MSFT	Stock	95.02	95.37	94.96	95.13	2301253.0
2018-05-04 15:00:00	MSFT	Stock	95.14	95.34	94.88	95.16	3991031.0
2018-05-04 16:00:00	MSFT	Stock	95.2	95.32	95.0	95.32	2626614.0
2018-05-04 17:00:00	MSFT	Stock	95.3	95.3	95.16	95.16	9298.0
2018-05-04 18:00:00	MSFT	Stock	95.27	95.27	95.12	95.25	350.0
2018-05-04 19:00:00	MSFT	Stock	95.21	95.29	95.21	95.21	2803.0
2018-05-04 04:00:00	NVDA	Stock	5.8225	5.8225	5.8125	5.8125	15080.0
2018-05-04 05:00:00	NVDA	Stock	5.8125	5.815	5.8125	5.815	23520.0
2018-05-04 06:00:00	NVDA	Stock	5.815	5.815	5.8125	5.8125	40200.0
2018-05-04 07:00:00	NVDA	Stock	5.825	5.825	5.8125	5.8125	274720.0
2018-05-04 08:00:00	NVDA	Stock	5.8238	5.8345	5.8028	5.825	1306400.0
2018-05-04 09:00:00	NVDA	Stock	5.829	5.8338	5.7782	5.82	48033720.0
2018-05-04 10:00:00	NVDA	Stock	5.8185	5.8875	5.7943	5.8712	71565200.0
2018-05-04 11:00:00	NVDA	Stock	5.8722	5.936	5.8722	5.918	53154400.0
2018-05-04 12:00:00	NVDA	Stock	5.9188	5.949	5.9147	5.9348	30372120.0
2018-05-04 13:00:00	NVDA	Stock	5.936	5.946	5.9125	5.946	23883080.0
2018-05-04 14:00:00	NVDA	Stock	5.9459	5.9698	5.9415	5.9479	37733720.0
2018-05-04 15:00:00	NVDA	Stock	5.9473	5.9797	5.945	5.977	71280080.0
2018-05-04 16:00:00	NVDA	Stock	5.9765	5.9828	5.96	5.9782	5752600.0
2018-05-04 17:00:00	NVDA	Stock	5.9812	5.9828	5.9765	5.9825	346680.0
2018-05-04 18:00:00	NVDA	Stock	5.9805	6.0	5.9805	5.9925	675400.0
2018-05-04 19:00:00	NVDA	Stock	5.9962	5.9998	5.9913	5.9983	290280.0
2018-05-04 06:00:00	AMZN	Stock	78.742	78.7445	78.742	78.7445	14640.0
2018-05-04 07:00:00	AMZN	Stock	78.51	78.65	78.45	78.5145	85500.0
2018-05-04 08:00:00	AMZN	Stock	78.5654	78.65	78.25	78.45	597000.0
2018-05-04 09:00:00	AMZN	Stock	78.4485	78.639	78.1095	78.379	5726040.0

> showing 50 of 48,535 rows — these rows as CSV

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