PREVIEW / stock_1hour / 2021-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-03.parquet
  size:    1.5 MB
  rows:    67,760
  symbols: 2,752

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
2021-02-03 04:00:00	AAPL	Stock	135.6	135.7	135.4	135.65	33117.0
2021-02-03 05:00:00	AAPL	Stock	135.61	135.88	135.5	135.88	10716.0
2021-02-03 06:00:00	AAPL	Stock	135.88	135.88	135.5	135.69	45514.0
2021-02-03 07:00:00	AAPL	Stock	135.64	135.72	135.0	135.17	311064.0
2021-02-03 08:00:00	AAPL	Stock	135.47	135.69	135.02	135.3	470488.0
2021-02-03 09:00:00	AAPL	Stock	135.32	135.8	134.34	135.348	10661602.0
2021-02-03 10:00:00	AAPL	Stock	135.36	135.4	133.61	134.1	13953322.0
2021-02-03 11:00:00	AAPL	Stock	134.11	134.76	133.87	134.585	7087370.0
2021-02-03 12:00:00	AAPL	Stock	134.585	135.47	134.54	135.445	7115129.0
2021-02-03 13:00:00	AAPL	Stock	135.45	135.55	134.82	134.993	6311913.0
2021-02-03 14:00:00	AAPL	Stock	135.0	135.08	134.31	134.385	6110264.0
2021-02-03 15:00:00	AAPL	Stock	134.38	134.59	133.9	133.9	10251302.0
2021-02-03 16:00:00	AAPL	Stock	133.92	134.954	133.67	134.1	6973388.0
2021-02-03 17:00:00	AAPL	Stock	134.12	137.3	133.95	136.14	1073086.0
2021-02-03 18:00:00	AAPL	Stock	136.14	138.02	135.75	136.72	2647754.0
2021-02-03 19:00:00	AAPL	Stock	136.7	137.08	136.55	136.56	598609.0
2021-02-03 04:00:00	MSFT	Stock	241.8	241.8	240.1	240.1	4590.0
2021-02-03 05:00:00	MSFT	Stock	240.23	240.45	239.84	240.45	3408.0
2021-02-03 06:00:00	MSFT	Stock	240.44	240.75	240.23	240.75	13831.0
2021-02-03 07:00:00	MSFT	Stock	240.3	240.59	238.8	239.15	34438.0
2021-02-03 08:00:00	MSFT	Stock	240.37	240.4	238.92	239.6	68510.0
2021-02-03 09:00:00	MSFT	Stock	239.64	242.56	239.02	242.53	3075412.0
2021-02-03 10:00:00	MSFT	Stock	242.56	242.96	240.21	241.53	2987235.0
2021-02-03 11:00:00	MSFT	Stock	241.57	243.4	241.52	243.117	2725004.0
2021-02-03 12:00:00	MSFT	Stock	243.12	243.65	242.85	243.49	1573713.0
2021-02-03 13:00:00	MSFT	Stock	243.485	243.97	242.865	243.94	1330105.0
2021-02-03 14:00:00	MSFT	Stock	243.935	245.09	243.68	243.69	2804568.0
2021-02-03 15:00:00	MSFT	Stock	243.69	244.2	242.94	242.94	3682302.0
2021-02-03 16:00:00	MSFT	Stock	243.0	243.97	243.0	243.5	3697544.0
2021-02-03 17:00:00	MSFT	Stock	243.5	243.5	243.2	243.2	3562.0
2021-02-03 18:00:00	MSFT	Stock	243.12	243.4	243.0	243.16	71282.0
2021-02-03 19:00:00	MSFT	Stock	243.28	243.47	242.64	243.1	13432.0
2021-02-03 06:00:00	NVDA	Stock	13.58	13.5938	13.58	13.5938	15400.0
2021-02-03 07:00:00	NVDA	Stock	13.5902	13.6998	13.5598	13.633	1275080.0
2021-02-03 08:00:00	NVDA	Stock	13.6262	13.6628	13.5902	13.6628	582200.0
2021-02-03 09:00:00	NVDA	Stock	13.65	13.9202	13.5625	13.9162	52235280.0
2021-02-03 10:00:00	NVDA	Stock	13.9195	13.9318	13.6524	13.7322	35978560.0
2021-02-03 11:00:00	NVDA	Stock	13.7328	13.75	13.5825	13.6174	20390000.0
2021-02-03 12:00:00	NVDA	Stock	13.6225	13.6522	13.5798	13.6213	15093000.0
2021-02-03 13:00:00	NVDA	Stock	13.62	13.6385	13.5555	13.609	14307560.0
2021-02-03 14:00:00	NVDA	Stock	13.6148	13.6591	13.5985	13.6312	11672560.0
2021-02-03 15:00:00	NVDA	Stock	13.6303	13.648	13.5165	13.528	28107480.0
2021-02-03 16:00:00	NVDA	Stock	13.5305	13.5375	13.5	13.525	6223200.0
2021-02-03 17:00:00	NVDA	Stock	13.5348	13.5475	13.525	13.5475	182920.0
2021-02-03 18:00:00	NVDA	Stock	13.5388	13.5472	13.5258	13.5425	86440.0
2021-02-03 19:00:00	NVDA	Stock	13.5355	13.5375	13.5255	13.5325	118880.0
2021-02-03 04:00:00	AMZN	Stock	169.15	169.15	167.946	168.4	275420.0
2021-02-03 05:00:00	AMZN	Stock	168.6	168.75	168.189	168.75	216280.0
2021-02-03 06:00:00	AMZN	Stock	168.8505	170.699	168.8505	170.699	310860.0
2021-02-03 07:00:00	AMZN	Stock	170.101	173.5025	170.101	173.3	2248360.0

> showing 50 of 67,760 rows — these rows as CSV

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