PREVIEW / stock_1hour / 2019-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-24.parquet
  size:    1.1 MB
  rows:    50,599
  symbols: 2,607

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-06-24 04:00:00	AAPL	Stock	49.825	49.825	49.7675	49.8125	30080.0
2019-06-24 05:00:00	AAPL	Stock	49.8	49.825	49.79	49.825	11048.0
2019-06-24 06:00:00	AAPL	Stock	49.825	49.825	49.7625	49.7625	6632.0
2019-06-24 07:00:00	AAPL	Stock	49.7275	49.77	49.575	49.6875	106388.0
2019-06-24 08:00:00	AAPL	Stock	49.75	49.7875	49.5625	49.75	257236.0
2019-06-24 09:00:00	AAPL	Stock	49.75	50.0	49.5425	49.9025	8262496.0
2019-06-24 10:00:00	AAPL	Stock	49.91	50.04	49.815	49.9425	8410984.0
2019-06-24 11:00:00	AAPL	Stock	49.9438	49.9675	49.827	49.8725	6142660.0
2019-06-24 12:00:00	AAPL	Stock	49.875	49.8975	49.735	49.7925	4429168.0
2019-06-24 13:00:00	AAPL	Stock	49.795	49.85	49.7282	49.7537	3437180.0
2019-06-24 14:00:00	AAPL	Stock	49.7537	49.795	49.715	49.78	3746224.0
2019-06-24 15:00:00	AAPL	Stock	49.78	49.84	49.615	49.6375	9689364.0
2019-06-24 16:00:00	AAPL	Stock	49.6375	49.67	49.5975	49.645	11544828.0
2019-06-24 17:00:00	AAPL	Stock	49.645	49.665	49.64	49.665	381320.0
2019-06-24 18:00:00	AAPL	Stock	49.6675	49.6975	49.6525	49.6725	15684.0
2019-06-24 19:00:00	AAPL	Stock	49.675	49.6875	49.6525	49.67	40176.0
2019-06-24 04:00:00	MSFT	Stock	137.45	137.65	137.4	137.6	4238.0
2019-06-24 05:00:00	MSFT	Stock	137.6	137.65	137.55	137.65	2885.0
2019-06-24 06:00:00	MSFT	Stock	137.69	137.72	137.54	137.54	3529.0
2019-06-24 07:00:00	MSFT	Stock	137.5	137.58	137.32	137.42	4148.0
2019-06-24 08:00:00	MSFT	Stock	137.3	137.58	137.3	137.49	29849.0
2019-06-24 09:00:00	MSFT	Stock	137.49	137.88	137.0	137.18	1910361.0
2019-06-24 10:00:00	MSFT	Stock	137.18	137.79	137.13	137.685	1656504.0
2019-06-24 11:00:00	MSFT	Stock	137.681	138.15	137.67	138.12	1967398.0
2019-06-24 12:00:00	MSFT	Stock	138.13	138.4	138.08	138.255	1877125.0
2019-06-24 13:00:00	MSFT	Stock	138.262	138.35	137.681	137.755	1608491.0
2019-06-24 14:00:00	MSFT	Stock	137.76	137.88	137.59	137.815	1500776.0
2019-06-24 15:00:00	MSFT	Stock	137.82	138.0	137.63	137.79	2810476.0
2019-06-24 16:00:00	MSFT	Stock	137.78	137.9	137.75	137.9	2917972.0
2019-06-24 17:00:00	MSFT	Stock	137.79	137.85	137.78	137.8	154789.0
2019-06-24 18:00:00	MSFT	Stock	137.8	137.87	137.8	137.87	938.0
2019-06-24 19:00:00	MSFT	Stock	137.88	137.9	137.81	137.88	8281.0
2019-06-24 04:00:00	NVDA	Stock	3.825	3.825	3.8155	3.825	61200.0
2019-06-24 06:00:00	NVDA	Stock	3.8335	3.8335	3.8285	3.8285	22080.0
2019-06-24 07:00:00	NVDA	Stock	3.8215	3.8215	3.8072	3.818	115000.0
2019-06-24 08:00:00	NVDA	Stock	3.81	3.8225	3.8015	3.8132	535040.0
2019-06-24 09:00:00	NVDA	Stock	3.8128	3.8225	3.768	3.7785	39289880.0
2019-06-24 10:00:00	NVDA	Stock	3.7773	3.82	3.7758	3.8145	45000400.0
2019-06-24 11:00:00	NVDA	Stock	3.8152	3.8395	3.8148	3.8304	28544440.0
2019-06-24 12:00:00	NVDA	Stock	3.832	3.8462	3.8285	3.8426	16061000.0
2019-06-24 13:00:00	NVDA	Stock	3.8438	3.8443	3.832	3.8338	16893280.0
2019-06-24 14:00:00	NVDA	Stock	3.8348	3.845	3.819	3.8211	25015040.0
2019-06-24 15:00:00	NVDA	Stock	3.8202	3.8322	3.8142	3.8165	33810400.0
2019-06-24 16:00:00	NVDA	Stock	3.8165	3.8285	3.8165	3.8248	39660600.0
2019-06-24 17:00:00	NVDA	Stock	3.825	3.8272	3.8165	3.8225	773280.0
2019-06-24 18:00:00	NVDA	Stock	3.8202	3.8202	3.8168	3.8168	15800.0
2019-06-24 19:00:00	NVDA	Stock	3.8202	3.825	3.82	3.825	141560.0
2019-06-24 04:00:00	AMZN	Stock	95.77	95.95	95.77	95.95	4000.0
2019-06-24 05:00:00	AMZN	Stock	95.8345	95.8345	95.8345	95.8345	2000.0
2019-06-24 07:00:00	AMZN	Stock	95.805	95.805	95.6	95.7	71080.0

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

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