PREVIEW / stock_1hour / 2019-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-20.parquet
  size:    1.1 MB
  rows:    51,036
  symbols: 2,605

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-06-20 04:00:00	AAPL	Stock	50.0	50.1375	50.0	50.075	19988.0
2019-06-20 05:00:00	AAPL	Stock	50.1	50.2075	49.97	49.97	43836.0
2019-06-20 06:00:00	AAPL	Stock	50.1	50.1125	49.9925	50.0875	43452.0
2019-06-20 07:00:00	AAPL	Stock	50.0625	50.1375	50.0	50.105	212180.0
2019-06-20 08:00:00	AAPL	Stock	50.1225	50.2475	50.0	50.1375	400472.0
2019-06-20 09:00:00	AAPL	Stock	50.1675	50.21	49.77	49.9225	12563840.0
2019-06-20 10:00:00	AAPL	Stock	49.9275	49.995	49.605	49.7125	12103852.0
2019-06-20 11:00:00	AAPL	Stock	49.7175	49.855	49.65	49.785	6989776.0
2019-06-20 12:00:00	AAPL	Stock	49.7875	49.805	49.5075	49.7675	7267764.0
2019-06-20 13:00:00	AAPL	Stock	49.77	49.8812	49.745	49.79	4405672.0
2019-06-20 14:00:00	AAPL	Stock	49.7825	49.8872	49.755	49.8625	4792520.0
2019-06-20 15:00:00	AAPL	Stock	49.8625	49.9975	49.745	49.8448	12652080.0
2019-06-20 16:00:00	AAPL	Stock	49.865	49.915	49.8325	49.8375	9118272.0
2019-06-20 17:00:00	AAPL	Stock	49.8325	49.835	49.755	49.7625	51508.0
2019-06-20 18:00:00	AAPL	Stock	49.775	49.8	49.7225	49.745	30244.0
2019-06-20 19:00:00	AAPL	Stock	49.7225	49.825	49.7225	49.8225	15000.0
2019-06-20 04:00:00	MSFT	Stock	136.83	137.46	136.83	137.46	2055.0
2019-06-20 05:00:00	MSFT	Stock	137.32	137.6	137.29	137.5	6420.0
2019-06-20 06:00:00	MSFT	Stock	137.51	137.75	137.38	137.61	5400.0
2019-06-20 07:00:00	MSFT	Stock	137.44	137.68	137.43	137.5	28885.0
2019-06-20 08:00:00	MSFT	Stock	137.59	138.1	137.42	137.69	67420.0
2019-06-20 09:00:00	MSFT	Stock	137.65	137.9	137.01	137.24	3387080.0
2019-06-20 10:00:00	MSFT	Stock	137.25	137.4	136.28	136.355	3449315.0
2019-06-20 11:00:00	MSFT	Stock	136.36	136.88	136.33	136.69	2253550.0
2019-06-20 12:00:00	MSFT	Stock	136.69	136.73	135.72	136.005	2714560.0
2019-06-20 13:00:00	MSFT	Stock	136.01	136.32	135.79	136.01	1631194.0
2019-06-20 14:00:00	MSFT	Stock	136.01	136.575	135.94	136.555	1617179.0
2019-06-20 15:00:00	MSFT	Stock	136.57	137.31	136.362	136.89	4612163.0
2019-06-20 16:00:00	MSFT	Stock	136.95	137.09	136.7	136.85	7806067.0
2019-06-20 17:00:00	MSFT	Stock	136.89	136.9	136.6	136.71	6568.0
2019-06-20 18:00:00	MSFT	Stock	136.71	136.85	136.67	136.76	3601.0
2019-06-20 19:00:00	MSFT	Stock	136.75	136.8	136.65	136.8	8970.0
2019-06-20 04:00:00	NVDA	Stock	3.85	3.904	3.85	3.9013	183080.0
2019-06-20 05:00:00	NVDA	Stock	3.9	3.9078	3.9	3.9075	123200.0
2019-06-20 06:00:00	NVDA	Stock	3.9075	3.9142	3.9075	3.9128	87040.0
2019-06-20 07:00:00	NVDA	Stock	3.9	3.9155	3.8868	3.91	1029480.0
2019-06-20 08:00:00	NVDA	Stock	3.8878	3.9248	3.8375	3.9183	2609240.0
2019-06-20 09:00:00	NVDA	Stock	3.9128	3.9333	3.868	3.91	65568960.0
2019-06-20 10:00:00	NVDA	Stock	3.9115	3.9242	3.878	3.8798	54965200.0
2019-06-20 11:00:00	NVDA	Stock	3.8788	3.8905	3.8542	3.8728	33559120.0
2019-06-20 12:00:00	NVDA	Stock	3.8728	3.8752	3.838	3.857	35330760.0
2019-06-20 13:00:00	NVDA	Stock	3.8578	3.8604	3.8418	3.851	17489920.0
2019-06-20 14:00:00	NVDA	Stock	3.8502	3.8668	3.8485	3.8509	19631880.0
2019-06-20 15:00:00	NVDA	Stock	3.8515	3.856	3.8443	3.8525	52829960.0
2019-06-20 16:00:00	NVDA	Stock	3.8525	3.8665	3.8505	3.8562	4515560.0
2019-06-20 17:00:00	NVDA	Stock	3.8525	3.8565	3.8525	3.8545	634480.0
2019-06-20 18:00:00	NVDA	Stock	3.8525	3.8525	3.8498	3.8498	339000.0
2019-06-20 19:00:00	NVDA	Stock	3.8462	3.8525	3.8462	3.8525	218920.0
2019-06-20 04:00:00	AMZN	Stock	96.6	96.6635	96.6	96.6635	9260.0
2019-06-20 05:00:00	AMZN	Stock	97.044	97.114	97.0	97.0	65800.0

> showing 50 of 51,036 rows — these rows as CSV

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