PREVIEW / stock_1hour / 2019-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-14.parquet
  size:    1.1 MB
  rows:    49,534
  symbols: 2,624

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
2019-05-14 04:00:00	AAPL	Stock	46.565	46.735	46.565	46.65	38304.0
2019-05-14 05:00:00	AAPL	Stock	46.7	46.825	46.69	46.8	34800.0
2019-05-14 06:00:00	AAPL	Stock	46.7875	46.9425	46.7625	46.8625	63260.0
2019-05-14 07:00:00	AAPL	Stock	46.825	47.075	46.7275	46.8125	545752.0
2019-05-14 08:00:00	AAPL	Stock	46.8375	47.075	46.625	46.775	757344.0
2019-05-14 09:00:00	AAPL	Stock	46.7975	46.8875	46.3525	46.45	23665188.0
2019-05-14 10:00:00	AAPL	Stock	46.4452	46.9192	46.4452	46.605	18944272.0
2019-05-14 11:00:00	AAPL	Stock	46.6075	47.225	46.54	47.1575	16886528.0
2019-05-14 12:00:00	AAPL	Stock	47.1525	47.285	46.9825	47.1525	12250368.0
2019-05-14 13:00:00	AAPL	Stock	47.155	47.415	47.1535	47.3725	9848340.0
2019-05-14 14:00:00	AAPL	Stock	47.375	47.425	47.1725	47.245	10997344.0
2019-05-14 15:00:00	AAPL	Stock	47.2425	47.4075	47.13	47.1625	16838676.0
2019-05-14 16:00:00	AAPL	Stock	47.18	47.2125	46.9702	47.125	11208580.0
2019-05-14 17:00:00	AAPL	Stock	47.125	47.125	47.05	47.1	62456.0
2019-05-14 18:00:00	AAPL	Stock	47.115	47.22	47.08	47.22	62752.0
2019-05-14 19:00:00	AAPL	Stock	47.22	47.25	47.21	47.2375	56644.0
2019-05-14 04:00:00	MSFT	Stock	124.01	124.1	123.88	124.1	4831.0
2019-05-14 05:00:00	MSFT	Stock	124.06	124.2	124.05	124.2	840.0
2019-05-14 06:00:00	MSFT	Stock	124.19	124.46	124.19	124.4	3750.0
2019-05-14 07:00:00	MSFT	Stock	124.38	124.47	124.11	124.25	20921.0
2019-05-14 08:00:00	MSFT	Stock	124.3	124.48	123.65	124.4	67453.0
2019-05-14 09:00:00	MSFT	Stock	124.3	124.59	123.7	123.93	2774808.0
2019-05-14 10:00:00	MSFT	Stock	123.93	125.16	123.9	125.1	3365876.0
2019-05-14 11:00:00	MSFT	Stock	125.11	125.71	124.8	125.546	3142066.0
2019-05-14 12:00:00	MSFT	Stock	125.55	125.88	125.25	125.325	2165066.0
2019-05-14 13:00:00	MSFT	Stock	125.32	125.7	125.3	125.524	1349884.0
2019-05-14 14:00:00	MSFT	Stock	125.52	125.55	125.02	125.18	1724528.0
2019-05-14 15:00:00	MSFT	Stock	125.17	125.39	124.67	124.72	3956352.0
2019-05-14 16:00:00	MSFT	Stock	124.72	124.92	124.72	124.91	3629322.0
2019-05-14 17:00:00	MSFT	Stock	124.89	124.89	124.78	124.85	4314.0
2019-05-14 18:00:00	MSFT	Stock	124.85	125.05	124.85	125.0	3743.0
2019-05-14 19:00:00	MSFT	Stock	124.92	125.05	124.92	125.0	9004.0
2019-05-14 04:00:00	NVDA	Stock	4.0065	4.0228	4.0022	4.0228	102120.0
2019-05-14 05:00:00	NVDA	Stock	4.0292	4.0428	4.0292	4.0325	68440.0
2019-05-14 06:00:00	NVDA	Stock	4.025	4.044	4.025	4.044	206640.0
2019-05-14 07:00:00	NVDA	Stock	4.0305	4.0375	4.005	4.0188	1616480.0
2019-05-14 08:00:00	NVDA	Stock	4.036	4.0395	4.003	4.0155	2861200.0
2019-05-14 09:00:00	NVDA	Stock	4.0155	4.025	3.9623	3.9922	95467600.0
2019-05-14 10:00:00	NVDA	Stock	3.993	4.0395	3.993	4.0203	84959640.0
2019-05-14 11:00:00	NVDA	Stock	4.0215	4.0638	4.0038	4.05	69529000.0
2019-05-14 12:00:00	NVDA	Stock	4.0508	4.0734	4.0408	4.0628	56258960.0
2019-05-14 13:00:00	NVDA	Stock	4.0642	4.0865	4.064	4.0818	46052560.0
2019-05-14 14:00:00	NVDA	Stock	4.0818	4.085	4.0571	4.0658	44871600.0
2019-05-14 15:00:00	NVDA	Stock	4.0653	4.0755	4.0488	4.0508	80662880.0
2019-05-14 16:00:00	NVDA	Stock	4.051	4.0562	4.045	4.0562	2255120.0
2019-05-14 17:00:00	NVDA	Stock	4.0513	4.0513	4.045	4.05	155440.0
2019-05-14 18:00:00	NVDA	Stock	4.0513	4.065	4.0513	4.0638	185680.0
2019-05-14 19:00:00	NVDA	Stock	4.0612	4.065	4.0588	4.062	180120.0
2019-05-14 04:00:00	AMZN	Stock	91.8555	91.9885	91.7395	91.75	18060.0
2019-05-14 05:00:00	AMZN	Stock	91.875	92.1095	91.875	92.1095	11000.0

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

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