PREVIEW / stock_1hour / 2019-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-12.parquet
  size:    1.1 MB
  rows:    50,531
  symbols: 2,558

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
2019-09-12 04:00:00	AAPL	Stock	56.3275	56.3275	56.0	56.0	46120.0
2019-09-12 05:00:00	AAPL	Stock	55.97	56.075	55.95	55.975	58320.0
2019-09-12 06:00:00	AAPL	Stock	55.975	56.0475	55.95	55.99	22704.0
2019-09-12 07:00:00	AAPL	Stock	55.995	56.3	55.9875	56.1875	556880.0
2019-09-12 08:00:00	AAPL	Stock	56.12	56.2825	56.0275	56.22	638464.0
2019-09-12 09:00:00	AAPL	Stock	56.2125	56.4375	55.755	56.0625	23984964.0
2019-09-12 10:00:00	AAPL	Stock	56.0675	56.605	55.95	56.119	24742104.0
2019-09-12 11:00:00	AAPL	Stock	56.115	56.465	56.0875	56.4475	10629220.0
2019-09-12 12:00:00	AAPL	Stock	56.445	56.4512	56.265	56.3715	7073688.0
2019-09-12 13:00:00	AAPL	Stock	56.3725	56.4725	56.2275	56.2775	6843624.0
2019-09-12 14:00:00	AAPL	Stock	56.277	56.3325	56.1625	56.2462	5760792.0
2019-09-12 15:00:00	AAPL	Stock	56.2475	56.25	55.715	55.7725	14070780.0
2019-09-12 16:00:00	AAPL	Stock	55.79	56.1515	55.625	55.675	13956336.0
2019-09-12 17:00:00	AAPL	Stock	55.65	55.75	55.65	55.75	47472.0
2019-09-12 18:00:00	AAPL	Stock	55.75	55.915	55.75	55.85	126212.0
2019-09-12 19:00:00	AAPL	Stock	55.8375	55.8725	55.785	55.85	79684.0
2019-09-12 04:00:00	MSFT	Stock	136.88	136.88	136.65	136.7	1153.0
2019-09-12 05:00:00	MSFT	Stock	136.56	136.7	136.5	136.6	4059.0
2019-09-12 06:00:00	MSFT	Stock	136.65	136.65	136.4	136.52	1500.0
2019-09-12 07:00:00	MSFT	Stock	136.52	136.99	136.42	136.8	19978.0
2019-09-12 08:00:00	MSFT	Stock	136.75	137.17	136.49	137.001	40959.0
2019-09-12 09:00:00	MSFT	Stock	136.9	137.88	136.87	137.09	3763926.0
2019-09-12 10:00:00	MSFT	Stock	137.11	138.15	137.01	137.44	4422648.0
2019-09-12 11:00:00	MSFT	Stock	137.42	137.682	137.02	137.49	1567210.0
2019-09-12 12:00:00	MSFT	Stock	137.49	138.11	137.33	138.065	1970981.0
2019-09-12 13:00:00	MSFT	Stock	138.064	138.42	137.92	138.23	1787966.0
2019-09-12 14:00:00	MSFT	Stock	138.225	138.32	138.0	138.2	1294819.0
2019-09-12 15:00:00	MSFT	Stock	138.21	138.22	137.49	137.541	3281254.0
2019-09-12 16:00:00	MSFT	Stock	137.52	137.642	136.12	137.52	5208256.0
2019-09-12 17:00:00	MSFT	Stock	137.52	137.64	137.466	137.63	10656.0
2019-09-12 18:00:00	MSFT	Stock	137.64	137.8	137.64	137.7	6516.0
2019-09-12 19:00:00	MSFT	Stock	137.7	137.74	137.6	137.6	6751.0
2019-09-12 04:00:00	NVDA	Stock	4.6392	4.6392	4.6392	4.6392	4000.0
2019-09-12 05:00:00	NVDA	Stock	4.63	4.63	4.63	4.63	4000.0
2019-09-12 06:00:00	NVDA	Stock	4.63	4.63	4.6285	4.6285	18000.0
2019-09-12 07:00:00	NVDA	Stock	4.63	4.6697	4.63	4.66	1326520.0
2019-09-12 08:00:00	NVDA	Stock	4.65	4.6748	4.6428	4.6675	1617120.0
2019-09-12 09:00:00	NVDA	Stock	4.666	4.71	4.637	4.6694	85233400.0
2019-09-12 10:00:00	NVDA	Stock	4.6718	4.7088	4.6225	4.6405	70895520.0
2019-09-12 11:00:00	NVDA	Stock	4.6392	4.6648	4.6162	4.6532	28747560.0
2019-09-12 12:00:00	NVDA	Stock	4.653	4.6583	4.6242	4.6448	19997600.0
2019-09-12 13:00:00	NVDA	Stock	4.6452	4.6568	4.6332	4.642	14861160.0
2019-09-12 14:00:00	NVDA	Stock	4.6412	4.6458	4.6258	4.6408	19602760.0
2019-09-12 15:00:00	NVDA	Stock	4.641	4.641	4.5988	4.6065	46689800.0
2019-09-12 16:00:00	NVDA	Stock	4.6042	4.6083	4.589	4.5975	2326040.0
2019-09-12 17:00:00	NVDA	Stock	4.5975	4.6	4.5938	4.6	110240.0
2019-09-12 18:00:00	NVDA	Stock	4.61	4.6242	4.6088	4.6102	639440.0
2019-09-12 19:00:00	NVDA	Stock	4.611	4.6263	4.6062	4.6175	742240.0
2019-09-12 05:00:00	AMZN	Stock	91.65	91.65	91.6	91.6	11520.0
2019-09-12 06:00:00	AMZN	Stock	91.6255	91.725	91.6255	91.725	6680.0

> showing 50 of 50,531 rows — these rows as CSV

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