PREVIEW / stock_1hour / 2018-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-26.parquet
  size:    1.1 MB
  rows:    50,646
  symbols: 2,745

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
2018-11-26 04:00:00	AAPL	Stock	43.6375	43.8975	43.6375	43.875	84892.0
2018-11-26 05:00:00	AAPL	Stock	43.9	43.9975	43.7525	43.85	60804.0
2018-11-26 06:00:00	AAPL	Stock	43.9	43.95	43.8375	43.9125	35228.0
2018-11-26 07:00:00	AAPL	Stock	43.88	43.9	43.525	43.625	637852.0
2018-11-26 08:00:00	AAPL	Stock	43.64	43.875	43.4625	43.5625	871304.0
2018-11-26 09:00:00	AAPL	Stock	43.5625	43.7375	43.1938	43.6725	23372576.0
2018-11-26 10:00:00	AAPL	Stock	43.6688	43.6775	43.195	43.5075	21191840.0
2018-11-26 11:00:00	AAPL	Stock	43.505	43.5155	42.835	42.9342	25869788.0
2018-11-26 12:00:00	AAPL	Stock	42.93	43.1475	42.565	42.84	21575388.0
2018-11-26 13:00:00	AAPL	Stock	42.842	43.233	42.7075	43.22	16940436.0
2018-11-26 14:00:00	AAPL	Stock	43.2218	43.3825	43.2025	43.34	14554020.0
2018-11-26 15:00:00	AAPL	Stock	43.3425	43.6575	43.295	43.655	20989224.0
2018-11-26 16:00:00	AAPL	Stock	43.6575	43.6575	42.775	42.9075	14428508.0
2018-11-26 17:00:00	AAPL	Stock	42.8825	43.075	42.8325	42.9125	776320.0
2018-11-26 18:00:00	AAPL	Stock	42.915	43.0025	42.795	42.8	330440.0
2018-11-26 19:00:00	AAPL	Stock	42.8025	42.825	42.7125	42.7325	507196.0
2018-11-26 04:00:00	MSFT	Stock	104.3	105.3	104.3	105.3	3356.0
2018-11-26 05:00:00	MSFT	Stock	105.0	105.0	104.49	104.49	1043.0
2018-11-26 06:00:00	MSFT	Stock	104.74	104.74	104.74	104.74	100.0
2018-11-26 07:00:00	MSFT	Stock	104.7	104.85	104.31	104.6	10676.0
2018-11-26 08:00:00	MSFT	Stock	104.5	104.77	104.35	104.52	39260.0
2018-11-26 09:00:00	MSFT	Stock	104.52	105.43	104.52	105.41	4061063.0
2018-11-26 10:00:00	MSFT	Stock	105.405	105.92	105.312	105.745	4364085.0
2018-11-26 11:00:00	MSFT	Stock	105.74	105.94	105.18	105.395	3494591.0
2018-11-26 12:00:00	MSFT	Stock	105.4	105.72	104.65	105.15	2748378.0
2018-11-26 13:00:00	MSFT	Stock	105.14	105.87	105.06	105.82	1815025.0
2018-11-26 14:00:00	MSFT	Stock	105.81	106.515	105.73	106.515	3048768.0
2018-11-26 15:00:00	MSFT	Stock	106.515	106.63	106.25	106.47	4852349.0
2018-11-26 16:00:00	MSFT	Stock	106.47	106.63	106.08	106.15	3138979.0
2018-11-26 17:00:00	MSFT	Stock	106.1	106.17	106.0	106.05	22741.0
2018-11-26 18:00:00	MSFT	Stock	106.1	106.14	106.02	106.02	9577.0
2018-11-26 19:00:00	MSFT	Stock	106.02	106.06	105.82	106.0	13823.0
2018-11-26 04:00:00	NVDA	Stock	3.715	3.7708	3.715	3.7608	190560.0
2018-11-26 05:00:00	NVDA	Stock	3.7622	3.775	3.7612	3.7748	183200.0
2018-11-26 06:00:00	NVDA	Stock	3.7748	3.7748	3.75	3.75	146520.0
2018-11-26 07:00:00	NVDA	Stock	3.75	3.75	3.7102	3.7392	3466280.0
2018-11-26 08:00:00	NVDA	Stock	3.7403	3.7525	3.7125	3.7305	6530280.0
2018-11-26 09:00:00	NVDA	Stock	3.7272	3.796	3.6812	3.75	133891560.0
2018-11-26 10:00:00	NVDA	Stock	3.75	3.7605	3.664	3.6934	115690000.0
2018-11-26 11:00:00	NVDA	Stock	3.694	3.7432	3.6715	3.7018	95604920.0
2018-11-26 12:00:00	NVDA	Stock	3.702	3.7155	3.6712	3.7008	58644360.0
2018-11-26 13:00:00	NVDA	Stock	3.7018	3.7565	3.6952	3.7534	57710000.0
2018-11-26 14:00:00	NVDA	Stock	3.7533	3.7745	3.7418	3.774	57205080.0
2018-11-26 15:00:00	NVDA	Stock	3.7745	3.8368	3.7722	3.8263	164458240.0
2018-11-26 16:00:00	NVDA	Stock	3.8263	3.835	3.7545	3.7622	10410440.0
2018-11-26 17:00:00	NVDA	Stock	3.7622	3.8263	3.7575	3.785	3551920.0
2018-11-26 18:00:00	NVDA	Stock	3.7825	3.7865	3.7672	3.7795	773520.0
2018-11-26 19:00:00	NVDA	Stock	3.775	3.7795	3.7702	3.7795	673720.0
2018-11-26 04:00:00	AMZN	Stock	76.5	77.2215	76.5	77.15	17160.0
2018-11-26 05:00:00	AMZN	Stock	76.972	76.972	76.972	76.972	4240.0

> showing 50 of 50,646 rows — these rows as CSV

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