PREVIEW / stock_1hour / 2018-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-23.parquet
  size:    1.1 MB
  rows:    48,248
  symbols: 2,868

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-02-23 04:00:00	AAPL	Stock	43.325	43.4	43.325	43.395	13760.0
2018-02-23 05:00:00	AAPL	Stock	43.395	43.4	43.3125	43.3125	32200.0
2018-02-23 06:00:00	AAPL	Stock	43.335	43.45	43.325	43.42	73696.0
2018-02-23 07:00:00	AAPL	Stock	43.4125	43.45	43.38	43.395	187280.0
2018-02-23 08:00:00	AAPL	Stock	43.4062	43.47	43.3575	43.37	392020.0
2018-02-23 09:00:00	AAPL	Stock	43.3875	43.6575	43.3425	43.5225	19465424.0
2018-02-23 10:00:00	AAPL	Stock	43.5175	43.6125	43.385	43.5988	17815284.0
2018-02-23 11:00:00	AAPL	Stock	43.5988	43.6975	43.5325	43.6625	14070456.0
2018-02-23 12:00:00	AAPL	Stock	43.6675	43.6888	43.5675	43.6425	8881760.0
2018-02-23 13:00:00	AAPL	Stock	43.6425	43.645	43.545	43.635	8254848.0
2018-02-23 14:00:00	AAPL	Stock	43.6325	43.75	43.5675	43.745	13650044.0
2018-02-23 15:00:00	AAPL	Stock	43.745	43.9125	43.74	43.89	30475556.0
2018-02-23 16:00:00	AAPL	Stock	43.875	43.9375	43.8225	43.885	8662484.0
2018-02-23 17:00:00	AAPL	Stock	43.885	43.9075	43.85	43.8925	126452.0
2018-02-23 18:00:00	AAPL	Stock	43.8925	43.9075	43.87	43.9075	42288.0
2018-02-23 19:00:00	AAPL	Stock	43.875	43.8925	43.865	43.87	34540.0
2018-02-23 06:00:00	MSFT	Stock	92.3	92.43	92.1	92.43	3131.0
2018-02-23 07:00:00	MSFT	Stock	92.45	92.5	92.4	92.41	11709.0
2018-02-23 08:00:00	MSFT	Stock	92.48	92.7	92.36	92.4	27959.0
2018-02-23 09:00:00	MSFT	Stock	92.56	92.9	92.36	92.89	2389027.0
2018-02-23 10:00:00	MSFT	Stock	92.88	93.05	92.52	93.02	2870085.0
2018-02-23 11:00:00	MSFT	Stock	93.02	93.37	93.0	93.34	2341344.0
2018-02-23 12:00:00	MSFT	Stock	93.34	93.43	93.05	93.05	1994180.0
2018-02-23 13:00:00	MSFT	Stock	93.056	93.27	92.9	93.25	1675625.0
2018-02-23 14:00:00	MSFT	Stock	93.24	93.6	93.03	93.51	2215039.0
2018-02-23 15:00:00	MSFT	Stock	93.5	94.07	93.5	94.07	6357056.0
2018-02-23 16:00:00	MSFT	Stock	94.06	94.11	93.9	94.06	3951493.0
2018-02-23 17:00:00	MSFT	Stock	94.0	94.07	93.94	93.97	3658.0
2018-02-23 18:00:00	MSFT	Stock	94.03	94.03	93.99	94.0	12151.0
2018-02-23 19:00:00	MSFT	Stock	94.06	94.06	94.0	94.06	2506.0
2018-02-23 05:00:00	NVDA	Stock	6.0875	6.0875	6.0875	6.0875	4000.0
2018-02-23 06:00:00	NVDA	Stock	6.0945	6.11	6.0915	6.11	61200.0
2018-02-23 07:00:00	NVDA	Stock	6.11	6.1375	6.1083	6.115	640600.0
2018-02-23 08:00:00	NVDA	Stock	6.0938	6.1375	6.0938	6.1125	1195880.0
2018-02-23 09:00:00	NVDA	Stock	6.1125	6.147	6.0837	6.1117	59680080.0
2018-02-23 10:00:00	NVDA	Stock	6.1125	6.1318	6.0996	6.1112	48261880.0
2018-02-23 11:00:00	NVDA	Stock	6.112	6.131	6.0875	6.0952	41755080.0
2018-02-23 12:00:00	NVDA	Stock	6.0943	6.1085	6.0778	6.0917	33822160.0
2018-02-23 13:00:00	NVDA	Stock	6.0903	6.0908	6.063	6.0865	30756600.0
2018-02-23 14:00:00	NVDA	Stock	6.087	6.128	6.082	6.1222	39240800.0
2018-02-23 15:00:00	NVDA	Stock	6.1225	6.1483	6.1125	6.1483	76824400.0
2018-02-23 16:00:00	NVDA	Stock	6.1483	6.1565	6.1425	6.15	14552440.0
2018-02-23 17:00:00	NVDA	Stock	6.1485	6.155	6.1485	6.1513	127600.0
2018-02-23 18:00:00	NVDA	Stock	6.1515	6.1532	6.1478	6.1498	823160.0
2018-02-23 19:00:00	NVDA	Stock	6.1505	6.1525	6.1478	6.15	327920.0
2018-02-23 04:00:00	AMZN	Stock	74.75	74.7505	74.6755	74.7505	40900.0
2018-02-23 05:00:00	AMZN	Stock	74.7195	74.7195	74.692	74.692	6240.0
2018-02-23 06:00:00	AMZN	Stock	74.65	74.725	74.5805	74.697	49600.0
2018-02-23 07:00:00	AMZN	Stock	74.6575	74.889	74.651	74.7	516520.0
2018-02-23 08:00:00	AMZN	Stock	74.6625	74.894	74.6625	74.75	930140.0

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

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