PREVIEW / stock_1hour / 2020-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-11.parquet
  size:    1.2 MB
  rows:    53,949
  symbols: 2,449

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
2020-03-11 04:00:00	AAPL	Stock	69.565	70.0	68.95	69.9475	83208.0
2020-03-11 05:00:00	AAPL	Stock	69.805	69.875	69.3925	69.5	37700.0
2020-03-11 06:00:00	AAPL	Stock	69.475	69.6875	69.2175	69.485	50832.0
2020-03-11 07:00:00	AAPL	Stock	69.5	69.8	68.875	69.375	430980.0
2020-03-11 08:00:00	AAPL	Stock	69.7	69.8248	68.88	68.965	657008.0
2020-03-11 09:00:00	AAPL	Stock	69.0365	69.8078	68.8945	69.36	26288672.0
2020-03-11 10:00:00	AAPL	Stock	69.35	69.8375	68.6875	69.0875	26975724.0
2020-03-11 11:00:00	AAPL	Stock	69.095	69.4275	68.765	69.235	22077728.0
2020-03-11 12:00:00	AAPL	Stock	69.26	70.305	68.9112	69.0975	27207000.0
2020-03-11 13:00:00	AAPL	Stock	69.0962	69.325	68.61	69.091	21742720.0
2020-03-11 14:00:00	AAPL	Stock	69.0875	69.4925	68.5275	68.9675	23490800.0
2020-03-11 15:00:00	AAPL	Stock	68.965	69.5825	67.965	68.825	46750820.0
2020-03-11 16:00:00	AAPL	Stock	68.8275	69.345	68.6875	69.1275	17135828.0
2020-03-11 17:00:00	AAPL	Stock	69.13	69.175	68.65	68.6775	443672.0
2020-03-11 18:00:00	AAPL	Stock	68.75	69.59	68.72	69.465	530668.0
2020-03-11 19:00:00	AAPL	Stock	69.475	69.475	68.69	68.85	351620.0
2020-03-11 04:00:00	MSFT	Stock	157.74	158.4	156.01	158.0	15600.0
2020-03-11 05:00:00	MSFT	Stock	157.8	158.0	157.25	157.75	14836.0
2020-03-11 06:00:00	MSFT	Stock	157.77	157.93	156.99	157.9	8275.0
2020-03-11 07:00:00	MSFT	Stock	157.34	157.76	155.8	156.8	54223.0
2020-03-11 08:00:00	MSFT	Stock	157.57	157.79	155.39	155.9	80499.0
2020-03-11 09:00:00	MSFT	Stock	155.85	157.7	155.01	156.64	5452040.0
2020-03-11 10:00:00	MSFT	Stock	156.63	157.24	154.55	155.2	5579158.0
2020-03-11 11:00:00	MSFT	Stock	155.19	155.69	153.94	154.86	4236135.0
2020-03-11 12:00:00	MSFT	Stock	154.89	156.715	153.65	154.023	4584354.0
2020-03-11 13:00:00	MSFT	Stock	154.03	154.466	152.93	154.18	4091727.0
2020-03-11 14:00:00	MSFT	Stock	154.21	154.6	152.32	152.72	5830619.0
2020-03-11 15:00:00	MSFT	Stock	152.76	155.72	151.15	153.56	11968999.0
2020-03-11 16:00:00	MSFT	Stock	153.63	154.4	153.1	153.7	6283071.0
2020-03-11 17:00:00	MSFT	Stock	153.7	153.99	153.0	153.25	54247.0
2020-03-11 18:00:00	MSFT	Stock	153.46	155.5	153.4	155.2	63929.0
2020-03-11 19:00:00	MSFT	Stock	155.2	155.2	153.31	153.5	56158.0
2020-03-11 04:00:00	NVDA	Stock	6.3733	6.401	6.325	6.401	205800.0
2020-03-11 05:00:00	NVDA	Stock	6.4138	6.4138	6.3852	6.3852	57880.0
2020-03-11 06:00:00	NVDA	Stock	6.3848	6.3848	6.3295	6.376	73400.0
2020-03-11 07:00:00	NVDA	Stock	6.3742	6.377	6.3123	6.3313	786320.0
2020-03-11 08:00:00	NVDA	Stock	6.3621	6.375	6.307	6.3078	1517080.0
2020-03-11 09:00:00	NVDA	Stock	6.325	6.403	6.2674	6.3398	52715320.0
2020-03-11 10:00:00	NVDA	Stock	6.3362	6.415	6.2818	6.3138	58923080.0
2020-03-11 11:00:00	NVDA	Stock	6.3165	6.3445	6.2695	6.3083	33887800.0
2020-03-11 12:00:00	NVDA	Stock	6.306	6.4073	6.2312	6.2518	62754680.0
2020-03-11 13:00:00	NVDA	Stock	6.253	6.2728	6.2015	6.246	43120360.0
2020-03-11 14:00:00	NVDA	Stock	6.2455	6.255	6.1578	6.1648	54427800.0
2020-03-11 15:00:00	NVDA	Stock	6.1612	6.2198	6.0642	6.154	119586960.0
2020-03-11 16:00:00	NVDA	Stock	6.1618	6.1875	6.1288	6.176	3144440.0
2020-03-11 17:00:00	NVDA	Stock	6.1618	6.1625	6.126	6.139	565560.0
2020-03-11 18:00:00	NVDA	Stock	6.145	6.2248	6.1388	6.2088	1388840.0
2020-03-11 19:00:00	NVDA	Stock	6.209	6.2095	6.1425	6.1562	739000.0
2020-03-11 04:00:00	AMZN	Stock	92.8505	92.8505	92.45	92.5	9440.0
2020-03-11 05:00:00	AMZN	Stock	92.65	92.65	92.5	92.599	24320.0

> showing 50 of 53,949 rows — these rows as CSV

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