PREVIEW / stock_1hour / 2020-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-25.parquet
  size:    1.2 MB
  rows:    53,245
  symbols: 2,469

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-02-25 04:00:00	AAPL	Stock	75.5	75.625	75.12	75.135	76460.0
2020-02-25 05:00:00	AAPL	Stock	75.125	75.135	74.63	74.875	38788.0
2020-02-25 06:00:00	AAPL	Stock	74.875	75.2225	74.79	75.0525	28624.0
2020-02-25 07:00:00	AAPL	Stock	75.125	75.6225	75.0	75.6075	572168.0
2020-02-25 08:00:00	AAPL	Stock	75.225	75.617	75.025	75.35	766660.0
2020-02-25 09:00:00	AAPL	Stock	75.3875	75.6325	74.7125	75.0225	20774936.0
2020-02-25 10:00:00	AAPL	Stock	75.01	75.22	73.6125	73.8478	26119688.0
2020-02-25 11:00:00	AAPL	Stock	73.8375	74.02	72.5875	73.8125	30804596.0
2020-02-25 12:00:00	AAPL	Stock	73.8335	74.1532	73.3125	73.5225	14422044.0
2020-02-25 13:00:00	AAPL	Stock	73.515	73.855	73.1525	73.1675	15880440.0
2020-02-25 14:00:00	AAPL	Stock	73.1688	73.2125	72.21	72.705	26068072.0
2020-02-25 15:00:00	AAPL	Stock	72.7125	73.12	71.5325	72.02	35819080.0
2020-02-25 16:00:00	AAPL	Stock	72.02	72.425	71.8925	72.205	13254776.0
2020-02-25 17:00:00	AAPL	Stock	72.25	72.2875	71.8625	71.9375	3593068.0
2020-02-25 18:00:00	AAPL	Stock	72.0	72.4875	72.0	72.45	250908.0
2020-02-25 19:00:00	AAPL	Stock	72.4375	72.475	72.075	72.075	141760.0
2020-02-25 04:00:00	MSFT	Stock	172.86	173.5	172.32	172.45	23319.0
2020-02-25 05:00:00	MSFT	Stock	172.6	172.6	171.14	171.62	5309.0
2020-02-25 06:00:00	MSFT	Stock	171.63	172.68	171.31	172.46	4780.0
2020-02-25 07:00:00	MSFT	Stock	172.65	174.0	171.89	173.69	80019.0
2020-02-25 08:00:00	MSFT	Stock	172.93	174.25	171.31	173.67	194477.0
2020-02-25 09:00:00	MSFT	Stock	173.96	174.84	171.563	173.4	6495384.0
2020-02-25 10:00:00	MSFT	Stock	173.402	173.89	170.59	171.47	6859485.0
2020-02-25 11:00:00	MSFT	Stock	171.44	172.519	169.88	172.27	6988140.0
2020-02-25 12:00:00	MSFT	Stock	172.26	172.84	170.81	171.26	4655634.0
2020-02-25 13:00:00	MSFT	Stock	171.24	171.75	169.48	169.51	4861260.0
2020-02-25 14:00:00	MSFT	Stock	169.49	169.72	167.78	169.28	8715069.0
2020-02-25 15:00:00	MSFT	Stock	169.33	170.69	167.646	168.05	11110179.0
2020-02-25 16:00:00	MSFT	Stock	168.06	169.22	168.06	168.53	5622801.0
2020-02-25 17:00:00	MSFT	Stock	168.5	168.7	168.19	168.35	36179.0
2020-02-25 18:00:00	MSFT	Stock	168.34	170.24	168.34	169.7	69983.0
2020-02-25 19:00:00	MSFT	Stock	169.6	170.04	168.75	168.75	67619.0
2020-02-25 04:00:00	NVDA	Stock	6.8812	6.888	6.8175	6.8175	994120.0
2020-02-25 05:00:00	NVDA	Stock	6.8312	6.8463	6.7752	6.8125	438280.0
2020-02-25 06:00:00	NVDA	Stock	6.805	6.85	6.7875	6.8438	301880.0
2020-02-25 07:00:00	NVDA	Stock	6.8312	6.9215	6.8125	6.9158	3328120.0
2020-02-25 08:00:00	NVDA	Stock	6.8675	6.937	6.8125	6.925	6365800.0
2020-02-25 09:00:00	NVDA	Stock	6.9125	6.9698	6.7985	6.844	97393520.0
2020-02-25 10:00:00	NVDA	Stock	6.8434	6.8638	6.5263	6.5843	197908680.0
2020-02-25 11:00:00	NVDA	Stock	6.584	6.6005	6.449	6.5835	175796680.0
2020-02-25 12:00:00	NVDA	Stock	6.583	6.6198	6.5302	6.5565	88570000.0
2020-02-25 13:00:00	NVDA	Stock	6.5542	6.6097	6.525	6.54	88218080.0
2020-02-25 14:00:00	NVDA	Stock	6.5402	6.6232	6.5036	6.5963	111145400.0
2020-02-25 15:00:00	NVDA	Stock	6.5988	6.647	6.4858	6.5513	145272360.0
2020-02-25 16:00:00	NVDA	Stock	6.55	6.5805	6.55	6.5655	27977760.0
2020-02-25 17:00:00	NVDA	Stock	6.5675	6.571	6.5222	6.5275	554520.0
2020-02-25 18:00:00	NVDA	Stock	6.5625	6.5888	6.55	6.5875	1232440.0
2020-02-25 19:00:00	NVDA	Stock	6.5875	6.595	6.525	6.55	931200.0
2020-02-25 04:00:00	AMZN	Stock	101.15	101.15	101.0	101.0855	21300.0
2020-02-25 05:00:00	AMZN	Stock	100.7155	100.7155	100.7155	100.7155	5000.0

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

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