PREVIEW / stock_1hour / 2018-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-24.parquet
  size:    1.1 MB
  rows:    49,394
  symbols: 2,831

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-07-24 04:00:00	AAPL	Stock	48.025	48.1	48.025	48.09	11400.0
2018-07-24 05:00:00	AAPL	Stock	48.0975	48.1125	48.075	48.1125	2752.0
2018-07-24 06:00:00	AAPL	Stock	48.135	48.135	47.8775	47.9625	94188.0
2018-07-24 07:00:00	AAPL	Stock	48.0	48.0625	47.9375	48.0625	111368.0
2018-07-24 08:00:00	AAPL	Stock	47.9625	48.1525	47.9375	48.0875	303008.0
2018-07-24 09:00:00	AAPL	Stock	48.0875	48.415	48.0225	48.295	12733284.0
2018-07-24 10:00:00	AAPL	Stock	48.2938	48.37	48.2075	48.2275	8432584.0
2018-07-24 11:00:00	AAPL	Stock	48.225	48.2575	48.0125	48.105	7276816.0
2018-07-24 12:00:00	AAPL	Stock	48.1075	48.2325	48.0925	48.16	6046944.0
2018-07-24 13:00:00	AAPL	Stock	48.1575	48.235	48.0925	48.2125	5734508.0
2018-07-24 14:00:00	AAPL	Stock	48.2125	48.2275	48.115	48.2025	4593684.0
2018-07-24 15:00:00	AAPL	Stock	48.2025	48.25	48.1075	48.2475	8845008.0
2018-07-24 16:00:00	AAPL	Stock	48.25	48.265	48.22	48.2625	10997972.0
2018-07-24 17:00:00	AAPL	Stock	48.26	48.26	48.2175	48.2325	8408.0
2018-07-24 18:00:00	AAPL	Stock	48.25	48.25	48.22	48.23	6228.0
2018-07-24 19:00:00	AAPL	Stock	48.2425	48.2425	48.225	48.225	10064.0
2018-07-24 04:00:00	MSFT	Stock	108.5	108.5	108.47	108.5	1747.0
2018-07-24 05:00:00	MSFT	Stock	108.5	108.7	108.5	108.7	1866.0
2018-07-24 06:00:00	MSFT	Stock	108.74	108.79	108.5	108.5	9310.0
2018-07-24 07:00:00	MSFT	Stock	108.5	108.6	108.19	108.39	30122.0
2018-07-24 08:00:00	MSFT	Stock	108.3	108.67	108.2	108.5	31774.0
2018-07-24 09:00:00	MSFT	Stock	108.37	108.82	107.94	108.35	3764627.0
2018-07-24 10:00:00	MSFT	Stock	108.36	108.58	108.09	108.13	3500255.0
2018-07-24 11:00:00	MSFT	Stock	108.14	108.16	107.69	107.98	3846525.0
2018-07-24 12:00:00	MSFT	Stock	107.98	108.077	107.47	107.54	1801649.0
2018-07-24 13:00:00	MSFT	Stock	107.54	107.69	107.27	107.505	2408074.0
2018-07-24 14:00:00	MSFT	Stock	107.505	107.54	107.26	107.44	2033973.0
2018-07-24 15:00:00	MSFT	Stock	107.44	107.7	107.26	107.63	3841465.0
2018-07-24 16:00:00	MSFT	Stock	107.65	107.71	107.63	107.66	2617140.0
2018-07-24 17:00:00	MSFT	Stock	107.66	107.66	107.64	107.66	3255.0
2018-07-24 18:00:00	MSFT	Stock	107.7	107.7	107.63	107.63	2619.0
2018-07-24 19:00:00	MSFT	Stock	107.66	107.67	107.62	107.64	3802.0
2018-07-24 05:00:00	NVDA	Stock	6.2925	6.2925	6.2913	6.2925	41480.0
2018-07-24 06:00:00	NVDA	Stock	6.275	6.275	6.2688	6.2688	33000.0
2018-07-24 07:00:00	NVDA	Stock	6.2745	6.275	6.2625	6.275	107520.0
2018-07-24 08:00:00	NVDA	Stock	6.2725	6.2935	6.2478	6.285	612160.0
2018-07-24 09:00:00	NVDA	Stock	6.285	6.3283	6.2653	6.317	49621640.0
2018-07-24 10:00:00	NVDA	Stock	6.319	6.3712	6.312	6.3263	65689720.0
2018-07-24 11:00:00	NVDA	Stock	6.326	6.3342	6.255	6.2774	37580360.0
2018-07-24 12:00:00	NVDA	Stock	6.2776	6.287	6.2203	6.2238	28559320.0
2018-07-24 13:00:00	NVDA	Stock	6.2228	6.2559	6.2035	6.22	27727800.0
2018-07-24 14:00:00	NVDA	Stock	6.2195	6.2465	6.2083	6.2397	24852480.0
2018-07-24 15:00:00	NVDA	Stock	6.2399	6.2458	6.2035	6.2175	34552800.0
2018-07-24 16:00:00	NVDA	Stock	6.2	6.2182	6.2	6.2172	20551440.0
2018-07-24 17:00:00	NVDA	Stock	6.2108	6.2163	6.2108	6.213	76720.0
2018-07-24 18:00:00	NVDA	Stock	6.2108	6.2172	6.21	6.2172	57000.0
2018-07-24 19:00:00	NVDA	Stock	6.2175	6.2213	6.2175	6.2188	133000.0
2018-07-24 04:00:00	AMZN	Stock	91.1	91.245	91.1	91.1645	8180.0
2018-07-24 05:00:00	AMZN	Stock	91.4115	91.435	91.4115	91.435	10000.0
2018-07-24 06:00:00	AMZN	Stock	91.3615	91.386	91.279	91.386	18720.0

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

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