PREVIEW / stock_1hour / 2015-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-24.parquet
  size:    1.1 MB
  rows:    52,637
  symbols: 3,517

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
2015-08-24 04:00:00	AAPL	Stock	26.36	26.36	25.25	25.33	631100.0
2015-08-24 05:00:00	AAPL	Stock	25.3875	25.6825	25.31	25.5625	395000.0
2015-08-24 06:00:00	AAPL	Stock	25.51	25.5875	25.175	25.5	796448.0
2015-08-24 07:00:00	AAPL	Stock	25.525	25.5775	24.94	25.0	4230776.0
2015-08-24 08:00:00	AAPL	Stock	25.0	25.5725	24.4975	24.9075	12014372.0
2015-08-24 09:00:00	AAPL	Stock	24.9075	25.8625	23.0	25.395	145544356.0
2015-08-24 10:00:00	AAPL	Stock	25.3975	26.45	25.25	26.1175	97391908.0
2015-08-24 11:00:00	AAPL	Stock	26.1138	27.055	25.8325	26.95	74968760.0
2015-08-24 12:00:00	AAPL	Stock	26.9525	27.2	26.6625	26.9475	62034424.0
2015-08-24 13:00:00	AAPL	Stock	26.935	27.11	26.285	26.3125	50820520.0
2015-08-24 14:00:00	AAPL	Stock	26.3128	26.455	25.5908	25.665	49130320.0
2015-08-24 15:00:00	AAPL	Stock	25.6675	26.42	25.34	25.7825	76944896.0
2015-08-24 16:00:00	AAPL	Stock	25.78	26.3025	24.9175	25.95	22049116.0
2015-08-24 17:00:00	AAPL	Stock	25.9375	25.9375	25.775	25.78	382172.0
2015-08-24 18:00:00	AAPL	Stock	25.7925	25.995	25.7892	25.975	347492.0
2015-08-24 19:00:00	AAPL	Stock	25.9625	26.07	25.9375	26.0625	309684.0
2015-08-24 04:00:00	MSFT	Stock	42.35	42.35	41.54	41.54	10282.0
2015-08-24 05:00:00	MSFT	Stock	41.65	41.85	41.65	41.8	8169.0
2015-08-24 06:00:00	MSFT	Stock	41.82	42.0	41.61	41.76	21194.0
2015-08-24 07:00:00	MSFT	Stock	41.72	41.74	41.32	41.4	132054.0
2015-08-24 08:00:00	MSFT	Stock	41.43	41.61	41.05	41.14	90911.0
2015-08-24 09:00:00	MSFT	Stock	41.14	42.69	39.72	42.4	11732744.0
2015-08-24 10:00:00	MSFT	Stock	42.4	43.07	41.56	42.47	17459080.0
2015-08-24 11:00:00	MSFT	Stock	42.47	43.14	41.96	43.04	8446494.0
2015-08-24 12:00:00	MSFT	Stock	43.03	43.31	42.69	42.93	7266991.0
2015-08-24 13:00:00	MSFT	Stock	42.93	43.2	42.1	42.12	5661440.0
2015-08-24 14:00:00	MSFT	Stock	42.13	42.28	41.44	41.51	8067654.0
2015-08-24 15:00:00	MSFT	Stock	41.51	42.96	41.17	41.72	17779935.0
2015-08-24 16:00:00	MSFT	Stock	41.68	41.72	41.5	41.677	7124468.0
2015-08-24 17:00:00	MSFT	Stock	41.57	41.7	41.55	41.647	8337.0
2015-08-24 18:00:00	MSFT	Stock	41.65	41.747	41.55	41.747	1927.0
2015-08-24 19:00:00	MSFT	Stock	41.75	41.75	41.67	41.7	3394.0
2015-08-24 07:00:00	NVDA	Stock	0.5125	0.5125	0.5125	0.5125	20000.0
2015-08-24 08:00:00	NVDA	Stock	0.5125	0.5125	0.5062	0.5062	295320.0
2015-08-24 09:00:00	NVDA	Stock	0.502	0.5238	0.5	0.5232	57987720.0
2015-08-24 10:00:00	NVDA	Stock	0.5232	0.534	0.5198	0.5314	107326640.0
2015-08-24 11:00:00	NVDA	Stock	0.5315	0.5395	0.526	0.5382	66339480.0
2015-08-24 12:00:00	NVDA	Stock	0.538	0.5458	0.535	0.5418	79147760.0
2015-08-24 13:00:00	NVDA	Stock	0.5418	0.5452	0.534	0.5348	77869520.0
2015-08-24 14:00:00	NVDA	Stock	0.535	0.5358	0.52	0.521	67468720.0
2015-08-24 15:00:00	NVDA	Stock	0.521	0.5298	0.5135	0.5178	156800360.0
2015-08-24 16:00:00	NVDA	Stock	0.5175	0.5188	0.5162	0.5188	533400.0
2015-08-24 18:00:00	NVDA	Stock	0.5175	0.5175	0.5175	0.5175	14000.0
2015-08-24 19:00:00	NVDA	Stock	0.5175	0.5175	0.514	0.5175	38000.0
2015-08-24 04:00:00	AMZN	Stock	23.9	24.1	23.85	23.95	47320.0
2015-08-24 05:00:00	AMZN	Stock	23.95	24.1	23.95	24.044	45000.0
2015-08-24 06:00:00	AMZN	Stock	24.05	24.05	23.85	23.915	164160.0
2015-08-24 07:00:00	AMZN	Stock	23.95	23.95	23.495	23.5495	342320.0
2015-08-24 08:00:00	AMZN	Stock	23.55	23.55	23.0	23.35	1929820.0
2015-08-24 09:00:00	AMZN	Stock	23.35	23.829	22.55	23.459	45906200.0

> showing 50 of 52,637 rows — these rows as CSV

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