PREVIEW / stock_1hour / 2018-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-11.parquet
  size:    1.1 MB
  rows:    49,684
  symbols: 2,781

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-09-11 04:00:00	AAPL	Stock	54.8425	54.8425	54.625	54.625	14984.0
2018-09-11 05:00:00	AAPL	Stock	54.65	54.65	54.525	54.625	24476.0
2018-09-11 06:00:00	AAPL	Stock	54.62	54.8125	54.6025	54.695	45916.0
2018-09-11 07:00:00	AAPL	Stock	54.7275	54.7275	54.55	54.63	145128.0
2018-09-11 08:00:00	AAPL	Stock	54.675	54.75	54.5	54.53	352888.0
2018-09-11 09:00:00	AAPL	Stock	54.5275	54.845	54.14	54.68	18553756.0
2018-09-11 10:00:00	AAPL	Stock	54.6825	55.155	54.6425	55.11	17689060.0
2018-09-11 11:00:00	AAPL	Stock	55.1125	55.7325	55.105	55.7225	15281388.0
2018-09-11 12:00:00	AAPL	Stock	55.7225	55.9825	55.705	55.919	20477816.0
2018-09-11 13:00:00	AAPL	Stock	55.9225	55.9475	55.7375	55.92	9304500.0
2018-09-11 14:00:00	AAPL	Stock	55.9175	56.0748	55.815	55.9825	10708748.0
2018-09-11 15:00:00	AAPL	Stock	55.9815	56.0125	55.765	55.965	19023884.0
2018-09-11 16:00:00	AAPL	Stock	55.9675	56.0425	55.9325	56.0175	8460344.0
2018-09-11 17:00:00	AAPL	Stock	56.0175	56.0625	55.9625	56.0625	356468.0
2018-09-11 18:00:00	AAPL	Stock	56.0775	56.0875	56.0625	56.0825	116704.0
2018-09-11 19:00:00	AAPL	Stock	56.0825	56.145	56.05	56.1125	93824.0
2018-09-11 04:00:00	MSFT	Stock	109.47	109.47	108.86	109.2	567.0
2018-09-11 05:00:00	MSFT	Stock	109.15	109.15	109.15	109.15	100.0
2018-09-11 06:00:00	MSFT	Stock	109.2	109.3	109.2	109.27	10186.0
2018-09-11 07:00:00	MSFT	Stock	109.13	109.15	108.81	108.97	13399.0
2018-09-11 08:00:00	MSFT	Stock	109.13	109.65	108.75	108.86	16239.0
2018-09-11 09:00:00	MSFT	Stock	108.88	110.39	108.7	110.17	2957997.0
2018-09-11 10:00:00	MSFT	Stock	110.17	110.73	110.148	110.3	2580101.0
2018-09-11 11:00:00	MSFT	Stock	110.3	111.29	110.25	111.25	2335786.0
2018-09-11 12:00:00	MSFT	Stock	111.25	111.44	110.975	111.15	2151736.0
2018-09-11 13:00:00	MSFT	Stock	111.15	111.23	110.62	110.93	1468618.0
2018-09-11 14:00:00	MSFT	Stock	110.92	111.28	110.84	111.21	1342519.0
2018-09-11 15:00:00	MSFT	Stock	111.2	111.59	111.15	111.26	4991195.0
2018-09-11 16:00:00	MSFT	Stock	111.24	111.38	111.108	111.29	3636879.0
2018-09-11 17:00:00	MSFT	Stock	111.24	111.39	111.24	111.3	71813.0
2018-09-11 18:00:00	MSFT	Stock	111.36	111.39	111.36	111.39	815.0
2018-09-11 19:00:00	MSFT	Stock	111.37	111.37	111.3	111.3	977.0
2018-09-11 05:00:00	NVDA	Stock	6.8375	6.8375	6.8118	6.825	104080.0
2018-09-11 06:00:00	NVDA	Stock	6.8468	6.8468	6.8468	6.8468	12000.0
2018-09-11 07:00:00	NVDA	Stock	6.8338	6.8338	6.8325	6.8325	26000.0
2018-09-11 08:00:00	NVDA	Stock	6.8258	6.8468	6.8155	6.8155	370800.0
2018-09-11 09:00:00	NVDA	Stock	6.8132	6.91	6.8038	6.88	26156280.0
2018-09-11 10:00:00	NVDA	Stock	6.8813	6.8865	6.8005	6.8174	37103760.0
2018-09-11 11:00:00	NVDA	Stock	6.8175	6.8935	6.8142	6.89	23248720.0
2018-09-11 12:00:00	NVDA	Stock	6.89	6.9002	6.8522	6.8635	18540600.0
2018-09-11 13:00:00	NVDA	Stock	6.865	6.868	6.8165	6.8202	19852760.0
2018-09-11 14:00:00	NVDA	Stock	6.8195	6.842	6.8128	6.832	20321960.0
2018-09-11 15:00:00	NVDA	Stock	6.832	6.8398	6.8065	6.82	31903320.0
2018-09-11 16:00:00	NVDA	Stock	6.82	6.82	6.8138	6.8175	2288840.0
2018-09-11 17:00:00	NVDA	Stock	6.82	6.8215	6.8162	6.82	254640.0
2018-09-11 18:00:00	NVDA	Stock	6.82	6.8215	6.8188	6.8213	140240.0
2018-09-11 19:00:00	NVDA	Stock	6.8218	6.825	6.8218	6.8225	101680.0
2018-09-11 04:00:00	AMZN	Stock	97.1475	97.15	97.1475	97.15	4000.0
2018-09-11 05:00:00	AMZN	Stock	96.9	96.9	96.5	96.65	17160.0
2018-09-11 07:00:00	AMZN	Stock	96.7	96.7	96.625	96.625	8000.0

> showing 50 of 49,684 rows — these rows as CSV

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