PREVIEW / stock_1hour / 2017-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-22.parquet
  size:    1.1 MB
  rows:    48,636
  symbols: 2,902

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-12-22 04:00:00	AAPL	Stock	43.795	43.795	43.7	43.7	1200.0
2017-12-22 06:00:00	AAPL	Stock	43.74	43.7425	43.7225	43.7225	8092.0
2017-12-22 07:00:00	AAPL	Stock	43.73	43.77	43.72	43.72	42588.0
2017-12-22 08:00:00	AAPL	Stock	43.73	43.7725	43.645	43.6625	194676.0
2017-12-22 09:00:00	AAPL	Stock	43.6875	43.856	43.625	43.8	9725952.0
2017-12-22 10:00:00	AAPL	Stock	43.7988	43.83	43.7125	43.8175	7389364.0
2017-12-22 11:00:00	AAPL	Stock	43.8175	43.835	43.725	43.7725	5456232.0
2017-12-22 12:00:00	AAPL	Stock	43.7725	43.775	43.71	43.7425	4656372.0
2017-12-22 13:00:00	AAPL	Stock	43.7425	43.79	43.73	43.76	4222544.0
2017-12-22 14:00:00	AAPL	Stock	43.7575	43.8013	43.735	43.79	4083952.0
2017-12-22 15:00:00	AAPL	Stock	43.7925	43.7925	43.7225	43.7625	9290108.0
2017-12-22 16:00:00	AAPL	Stock	43.7525	43.7775	43.73	43.7425	12605560.0
2017-12-22 17:00:00	AAPL	Stock	43.7425	43.7625	43.7425	43.7625	13264.0
2017-12-22 18:00:00	AAPL	Stock	43.755	43.755	43.745	43.75	7040.0
2017-12-22 19:00:00	AAPL	Stock	43.755	43.755	43.75	43.75	19252.0
2017-12-22 07:00:00	MSFT	Stock	85.75	85.79	85.7	85.7	800.0
2017-12-22 08:00:00	MSFT	Stock	85.74	85.74	85.53	85.7	4456.0
2017-12-22 09:00:00	MSFT	Stock	85.7	85.7	85.045	85.16	2581042.0
2017-12-22 10:00:00	MSFT	Stock	85.17	85.31	84.92	85.25	2210877.0
2017-12-22 11:00:00	MSFT	Stock	85.25	85.28	85.07	85.195	1211905.0
2017-12-22 12:00:00	MSFT	Stock	85.19	85.29	85.13	85.205	718402.0
2017-12-22 13:00:00	MSFT	Stock	85.205	85.33	85.2	85.3	843836.0
2017-12-22 14:00:00	MSFT	Stock	85.294	85.51	85.27	85.5	956009.0
2017-12-22 15:00:00	MSFT	Stock	85.5	85.63	85.46	85.58	1810610.0
2017-12-22 16:00:00	MSFT	Stock	85.51	85.7	85.5	85.55	2931091.0
2017-12-22 18:00:00	MSFT	Stock	85.57	85.57	85.57	85.57	172.0
2017-12-22 19:00:00	MSFT	Stock	85.59	85.59	85.59	85.59	385.0
2017-12-22 05:00:00	NVDA	Stock	4.8943	4.8943	4.8925	4.8925	40920.0
2017-12-22 06:00:00	NVDA	Stock	4.8825	4.8825	4.8825	4.8825	4000.0
2017-12-22 07:00:00	NVDA	Stock	4.8825	4.897	4.8825	4.8863	101480.0
2017-12-22 08:00:00	NVDA	Stock	4.888	4.895	4.8825	4.887	375200.0
2017-12-22 09:00:00	NVDA	Stock	4.886	4.886	4.7812	4.8078	100194120.0
2017-12-22 10:00:00	NVDA	Stock	4.8088	4.827	4.8003	4.8171	58653120.0
2017-12-22 11:00:00	NVDA	Stock	4.8158	4.82	4.8	4.8088	28800560.0
2017-12-22 12:00:00	NVDA	Stock	4.8085	4.816	4.7895	4.8142	51004080.0
2017-12-22 13:00:00	NVDA	Stock	4.8145	4.8725	4.8115	4.8699	72349400.0
2017-12-22 14:00:00	NVDA	Stock	4.8703	4.8768	4.8532	4.8704	34640000.0
2017-12-22 15:00:00	NVDA	Stock	4.8714	4.8912	4.8703	4.8815	56066280.0
2017-12-22 16:00:00	NVDA	Stock	4.8818	4.8818	4.875	4.875	10537280.0
2017-12-22 17:00:00	NVDA	Stock	4.8783	4.8785	4.8725	4.8785	252320.0
2017-12-22 18:00:00	NVDA	Stock	4.875	4.8795	4.875	4.8768	134440.0
2017-12-22 19:00:00	NVDA	Stock	4.875	4.875	4.8735	4.8738	124800.0
2017-12-22 07:00:00	AMZN	Stock	58.75	58.75	58.75	58.75	2480.0
2017-12-22 08:00:00	AMZN	Stock	58.75	58.75	58.65	58.65	21600.0
2017-12-22 09:00:00	AMZN	Stock	58.65	58.731	58.4175	58.593	5637520.0
2017-12-22 10:00:00	AMZN	Stock	58.579	58.6025	58.475	58.5224	3578540.0
2017-12-22 11:00:00	AMZN	Stock	58.515	58.584	58.4405	58.565	3643320.0
2017-12-22 12:00:00	AMZN	Stock	58.5595	58.5615	58.4345	58.469	2011900.0
2017-12-22 13:00:00	AMZN	Stock	58.476	58.562	58.476	58.5485	1980060.0
2017-12-22 14:00:00	AMZN	Stock	58.5475	58.5845	58.5	58.5185	1879560.0

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

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