PREVIEW / stock_1hour / 2021-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-16.parquet
  size:    1.4 MB
  rows:    65,248
  symbols: 2,936

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-06-16 04:00:00	AAPL	Stock	129.43	129.74	129.33	129.73	10775.0
2021-06-16 05:00:00	AAPL	Stock	129.74	129.74	129.53	129.6	4205.0
2021-06-16 06:00:00	AAPL	Stock	129.55	129.7	129.5	129.65	3539.0
2021-06-16 07:00:00	AAPL	Stock	129.62	129.94	129.52	129.86	56729.0
2021-06-16 08:00:00	AAPL	Stock	129.5126	130.0	129.51	129.92	217413.0
2021-06-16 09:00:00	AAPL	Stock	129.91	130.8281	129.64	130.53	10186481.0
2021-06-16 10:00:00	AAPL	Stock	130.54	130.89	130.28	130.625	9943372.0
2021-06-16 11:00:00	AAPL	Stock	130.62	130.67	130.11	130.1278	5503002.0
2021-06-16 12:00:00	AAPL	Stock	130.1201	130.45	129.76	130.42	6402315.0
2021-06-16 13:00:00	AAPL	Stock	130.416	130.52	130.18	130.39	5532080.0
2021-06-16 14:00:00	AAPL	Stock	130.38	130.38	128.461	129.18	17592094.0
2021-06-16 15:00:00	AAPL	Stock	129.18	130.48	129.1	130.14	15725631.0
2021-06-16 16:00:00	AAPL	Stock	130.14	130.23	129.77	129.8	8836904.0
2021-06-16 17:00:00	AAPL	Stock	129.78	129.9	129.76	129.84	31960.0
2021-06-16 18:00:00	AAPL	Stock	129.7901	129.86	129.6	129.65	40525.0
2021-06-16 19:00:00	AAPL	Stock	129.64	129.69	129.1	129.21	103311.0
2021-06-16 04:00:00	MSFT	Stock	258.55	259.0	258.55	258.75	3676.0
2021-06-16 05:00:00	MSFT	Stock	258.62	258.88	258.6	258.88	830.0
2021-06-16 07:00:00	MSFT	Stock	258.13	258.73	258.11	258.4	5995.0
2021-06-16 08:00:00	MSFT	Stock	258.4	258.53	257.73	258.4	5630.0
2021-06-16 09:00:00	MSFT	Stock	258.55	260.56	258.5	260.05	2215836.0
2021-06-16 10:00:00	MSFT	Stock	260.06	260.58	259.1601	259.66	2088520.0
2021-06-16 11:00:00	MSFT	Stock	259.66	259.88	258.7099	258.79	1195853.0
2021-06-16 12:00:00	MSFT	Stock	258.79	258.94	258.03	258.94	1505157.0
2021-06-16 13:00:00	MSFT	Stock	258.95	259.12	258.38	258.516	1017331.0
2021-06-16 14:00:00	MSFT	Stock	258.52	258.52	254.42	256.595	4516390.0
2021-06-16 15:00:00	MSFT	Stock	256.6	258.48	256.4096	257.51	3752924.0
2021-06-16 16:00:00	MSFT	Stock	257.44	257.5	256.62	256.67	3430415.0
2021-06-16 17:00:00	MSFT	Stock	256.74	256.85	256.7	256.85	7025.0
2021-06-16 18:00:00	MSFT	Stock	256.9	256.9	256.21	256.23	15800.0
2021-06-16 19:00:00	MSFT	Stock	256.24	256.3	255.555	255.555	23425.0
2021-06-16 06:00:00	NVDA	Stock	17.7518	17.7518	17.7518	17.7518	9000.0
2021-06-16 07:00:00	NVDA	Stock	17.738	17.738	17.7088	17.715	257200.0
2021-06-16 08:00:00	NVDA	Stock	17.749	17.833	17.7029	17.7498	289680.0
2021-06-16 09:00:00	NVDA	Stock	17.755	17.925	17.755	17.9113	28782760.0
2021-06-16 10:00:00	NVDA	Stock	17.9161	17.9547	17.7666	17.7982	29259280.0
2021-06-16 11:00:00	NVDA	Stock	17.7962	17.8748	17.7938	17.8503	15017320.0
2021-06-16 12:00:00	NVDA	Stock	17.85	17.8532	17.735	17.7975	13730560.0
2021-06-16 13:00:00	NVDA	Stock	17.7965	17.8663	17.7895	17.8378	10292040.0
2021-06-16 14:00:00	NVDA	Stock	17.8335	17.8335	17.5844	17.6982	36209880.0
2021-06-16 15:00:00	NVDA	Stock	17.6972	17.931	17.675	17.8045	39848520.0
2021-06-16 16:00:00	NVDA	Stock	17.8102	17.8102	17.7438	17.745	15138400.0
2021-06-16 17:00:00	NVDA	Stock	17.767	17.775	17.7575	17.7575	133680.0
2021-06-16 18:00:00	NVDA	Stock	17.765	17.765	17.7375	17.7393	174920.0
2021-06-16 19:00:00	NVDA	Stock	17.7315	17.7315	17.7	17.7	149960.0
2021-06-16 04:00:00	AMZN	Stock	169.1	169.1	168.8	168.8	7460.0
2021-06-16 06:00:00	AMZN	Stock	168.9795	169.1	168.9795	169.1	9060.0
2021-06-16 07:00:00	AMZN	Stock	169.139	169.3555	169.139	169.27	32320.0
2021-06-16 08:00:00	AMZN	Stock	168.907	169.72	168.907	169.5505	62080.0
2021-06-16 09:00:00	AMZN	Stock	169.6	170.4495	169.448	170.2922	6884100.0

> showing 50 of 65,248 rows — these rows as CSV

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