PREVIEW / stock_1hour / 2018-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-10.parquet
  size:    1.1 MB
  rows:    50,996
  symbols: 2,797

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-10-10 04:00:00	AAPL	Stock	56.78	56.78	56.7	56.7	17520.0
2018-10-10 05:00:00	AAPL	Stock	56.735	56.75	56.7	56.705	10504.0
2018-10-10 06:00:00	AAPL	Stock	56.7175	56.7175	56.7175	56.7175	6600.0
2018-10-10 07:00:00	AAPL	Stock	56.725	56.8575	56.575	56.625	190072.0
2018-10-10 08:00:00	AAPL	Stock	56.745	56.87	56.375	56.47	440556.0
2018-10-10 09:00:00	AAPL	Stock	56.475	56.5875	55.72	55.8975	14558008.0
2018-10-10 10:00:00	AAPL	Stock	55.8975	56.095	55.64	55.9138	16659944.0
2018-10-10 11:00:00	AAPL	Stock	55.9125	56.1	55.5425	55.8375	14647872.0
2018-10-10 12:00:00	AAPL	Stock	55.835	55.9925	55.6375	55.655	8160280.0
2018-10-10 13:00:00	AAPL	Stock	55.65	55.955	55.5425	55.685	8916296.0
2018-10-10 14:00:00	AAPL	Stock	55.6775	55.71	55.0375	55.3425	16140072.0
2018-10-10 15:00:00	AAPL	Stock	55.3412	55.3412	54.0125	54.0975	40408452.0
2018-10-10 16:00:00	AAPL	Stock	54.0975	54.2975	53.625	53.65	16905340.0
2018-10-10 17:00:00	AAPL	Stock	53.65	53.7875	53.625	53.78	391828.0
2018-10-10 18:00:00	AAPL	Stock	53.7475	53.8125	53.6675	53.725	265540.0
2018-10-10 19:00:00	AAPL	Stock	53.75	53.7875	53.4275	53.5475	323960.0
2018-10-10 04:00:00	MSFT	Stock	112.3	112.3	112.26	112.26	300.0
2018-10-10 05:00:00	MSFT	Stock	112.4	112.4	112.4	112.4	100.0
2018-10-10 07:00:00	MSFT	Stock	112.35	112.42	111.9	111.9	14889.0
2018-10-10 08:00:00	MSFT	Stock	112.17	112.45	111.72	111.82	19268.0
2018-10-10 09:00:00	MSFT	Stock	111.82	111.99	109.361	109.575	4677684.0
2018-10-10 10:00:00	MSFT	Stock	109.58	109.885	108.882	109.28	6784907.0
2018-10-10 11:00:00	MSFT	Stock	109.28	109.44	107.65	108.21	7927861.0
2018-10-10 12:00:00	MSFT	Stock	108.2	109.25	107.837	108.52	4133143.0
2018-10-10 13:00:00	MSFT	Stock	108.52	109.43	108.09	108.675	4344938.0
2018-10-10 14:00:00	MSFT	Stock	108.66	108.94	107.94	108.45	5586891.0
2018-10-10 15:00:00	MSFT	Stock	108.45	108.46	105.79	106.26	13965279.0
2018-10-10 16:00:00	MSFT	Stock	106.16	106.39	104.91	105.02	6778723.0
2018-10-10 17:00:00	MSFT	Stock	105.0	105.34	104.77	105.29	44461.0
2018-10-10 18:00:00	MSFT	Stock	105.28	105.65	105.1	105.65	27677.0
2018-10-10 19:00:00	MSFT	Stock	105.65	105.87	105.1	105.38	21832.0
2018-10-10 04:00:00	NVDA	Stock	6.6165	6.6175	6.6165	6.6175	10040.0
2018-10-10 06:00:00	NVDA	Stock	6.625	6.625	6.625	6.625	8600.0
2018-10-10 07:00:00	NVDA	Stock	6.625	6.6375	6.55	6.5508	621640.0
2018-10-10 08:00:00	NVDA	Stock	6.6125	6.6125	6.531	6.5438	783880.0
2018-10-10 09:00:00	NVDA	Stock	6.5438	6.5778	6.331	6.3443	90163240.0
2018-10-10 10:00:00	NVDA	Stock	6.3452	6.4101	6.3179	6.3546	106985200.0
2018-10-10 11:00:00	NVDA	Stock	6.354	6.3672	6.2765	6.2774	78431840.0
2018-10-10 12:00:00	NVDA	Stock	6.2755	6.3511	6.2575	6.3182	57389160.0
2018-10-10 13:00:00	NVDA	Stock	6.3165	6.3972	6.2922	6.3556	44241600.0
2018-10-10 14:00:00	NVDA	Stock	6.3573	6.363	6.276	6.294	43106160.0
2018-10-10 15:00:00	NVDA	Stock	6.2933	6.2933	6.14	6.1428	113181000.0
2018-10-10 16:00:00	NVDA	Stock	6.1423	6.1578	6.0362	6.06	33826440.0
2018-10-10 17:00:00	NVDA	Stock	6.0513	6.059	6.0263	6.0418	2172120.0
2018-10-10 18:00:00	NVDA	Stock	6.0475	6.0688	6.0392	6.056	2007760.0
2018-10-10 19:00:00	NVDA	Stock	6.0605	6.0753	6.025	6.05	1406280.0
2018-10-10 07:00:00	AMZN	Stock	93.585	93.8495	93.35	93.3765	86380.0
2018-10-10 08:00:00	AMZN	Stock	93.664	93.9375	93.0065	93.05	687560.0
2018-10-10 09:00:00	AMZN	Stock	93.1	93.17	90.861	91.1673	27012460.0
2018-10-10 10:00:00	AMZN	Stock	91.1666	92.0895	90.7005	91.235	29259500.0

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

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