PREVIEW / stock_1hour / 2017-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-25.parquet
  size:    1.0 MB
  rows:    47,096
  symbols: 2,963

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
2017-08-25 05:00:00	AAPL	Stock	39.875	39.875	39.875	39.875	4000.0
2017-08-25 06:00:00	AAPL	Stock	39.9225	39.9925	39.9225	39.9925	9872.0
2017-08-25 07:00:00	AAPL	Stock	39.965	40.0975	39.965	40.075	82800.0
2017-08-25 08:00:00	AAPL	Stock	40.0	40.075	39.9625	40.0075	272148.0
2017-08-25 09:00:00	AAPL	Stock	40.0	40.0975	39.88	40.0375	11532088.0
2017-08-25 10:00:00	AAPL	Stock	40.0375	40.14	39.935	39.9475	12928008.0
2017-08-25 11:00:00	AAPL	Stock	39.9475	39.981	39.8225	39.9125	10733392.0
2017-08-25 12:00:00	AAPL	Stock	39.9125	39.9725	39.8175	39.9575	6847616.0
2017-08-25 13:00:00	AAPL	Stock	39.96	40.03	39.95	40.0075	6670780.0
2017-08-25 14:00:00	AAPL	Stock	40.01	40.085	39.99	40.0132	5876576.0
2017-08-25 15:00:00	AAPL	Stock	40.015	40.0875	39.9475	39.965	13162208.0
2017-08-25 16:00:00	AAPL	Stock	39.965	39.985	39.9575	39.9625	5051964.0
2017-08-25 17:00:00	AAPL	Stock	39.96	39.975	39.9375	39.9375	65148.0
2017-08-25 18:00:00	AAPL	Stock	39.9375	39.9625	39.895	39.9125	17708.0
2017-08-25 19:00:00	AAPL	Stock	39.9075	39.9325	39.895	39.9	25160.0
2017-08-25 06:00:00	MSFT	Stock	72.9	72.91	72.9	72.91	2100.0
2017-08-25 07:00:00	MSFT	Stock	72.99	72.99	72.9	72.9	400.0
2017-08-25 08:00:00	MSFT	Stock	72.98	72.98	72.82	72.82	2830.0
2017-08-25 09:00:00	MSFT	Stock	72.94	73.275	72.78	73.16	1417662.0
2017-08-25 10:00:00	MSFT	Stock	73.165	73.35	72.77	72.79	1617812.0
2017-08-25 11:00:00	MSFT	Stock	72.78	72.79	72.48	72.564	1321572.0
2017-08-25 12:00:00	MSFT	Stock	72.56	72.715	72.555	72.644	844086.0
2017-08-25 13:00:00	MSFT	Stock	72.65	72.86	72.644	72.8	807494.0
2017-08-25 14:00:00	MSFT	Stock	72.79	72.94	72.79	72.89	1051711.0
2017-08-25 15:00:00	MSFT	Stock	72.89	73.05	72.76	72.83	3428717.0
2017-08-25 16:00:00	MSFT	Stock	72.82	72.83	72.75	72.75	1371022.0
2017-08-25 17:00:00	MSFT	Stock	72.75	72.75	72.68	72.68	1600.0
2017-08-25 18:00:00	MSFT	Stock	72.76	72.76	72.76	72.76	485.0
2017-08-25 19:00:00	MSFT	Stock	72.73	72.76	72.62	72.62	1691.0
2017-08-25 05:00:00	NVDA	Stock	4.1458	4.1462	4.1458	4.1462	60160.0
2017-08-25 06:00:00	NVDA	Stock	4.1475	4.1475	4.1425	4.1425	30000.0
2017-08-25 07:00:00	NVDA	Stock	4.1482	4.1553	4.147	4.155	202440.0
2017-08-25 08:00:00	NVDA	Stock	4.1512	4.154	4.1445	4.1462	876600.0
2017-08-25 09:00:00	NVDA	Stock	4.1443	4.1645	4.1275	4.149	61111880.0
2017-08-25 10:00:00	NVDA	Stock	4.1492	4.1605	4.1185	4.1215	60141280.0
2017-08-25 11:00:00	NVDA	Stock	4.1215	4.1244	4.0938	4.1042	59577120.0
2017-08-25 12:00:00	NVDA	Stock	4.1053	4.1118	4.0888	4.0948	32496880.0
2017-08-25 13:00:00	NVDA	Stock	4.0955	4.1118	4.0943	4.0991	26066200.0
2017-08-25 14:00:00	NVDA	Stock	4.0985	4.1153	4.0975	4.1108	27462680.0
2017-08-25 15:00:00	NVDA	Stock	4.1108	4.1145	4.0925	4.0952	55368920.0
2017-08-25 16:00:00	NVDA	Stock	4.0952	4.0995	4.0938	4.0958	16260040.0
2017-08-25 17:00:00	NVDA	Stock	4.0958	4.0975	4.0935	4.0935	141360.0
2017-08-25 18:00:00	NVDA	Stock	4.0902	4.0958	4.0875	4.0875	302000.0
2017-08-25 19:00:00	NVDA	Stock	4.0875	4.09	4.0862	4.09	323160.0
2017-08-25 07:00:00	AMZN	Stock	47.8575	47.8575	47.8575	47.8575	6760.0
2017-08-25 08:00:00	AMZN	Stock	47.84	47.84	47.7845	47.8	121780.0
2017-08-25 09:00:00	AMZN	Stock	47.8	47.881	47.5	47.7473	9968880.0
2017-08-25 10:00:00	AMZN	Stock	47.7295	47.852	47.5125	47.5125	8476240.0
2017-08-25 11:00:00	AMZN	Stock	47.5125	47.5965	47.3575	47.4884	10947820.0
2017-08-25 12:00:00	AMZN	Stock	47.481	47.5475	47.418	47.471	4109420.0

> showing 50 of 47,096 rows — these rows as CSV

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