PREVIEW / stock_1hour / 2014-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-24.parquet
  size:    1.0 MB
  rows:    47,736
  symbols: 3,537

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
2014-10-24 04:00:00	AAPL	Stock	26.2025	26.2175	26.175	26.175	10480.0
2014-10-24 05:00:00	AAPL	Stock	26.1925	26.1925	26.15	26.15	22492.0
2014-10-24 06:00:00	AAPL	Stock	26.17	26.1875	26.15	26.18	40576.0
2014-10-24 07:00:00	AAPL	Stock	26.1925	26.235	26.1625	26.2	192700.0
2014-10-24 08:00:00	AAPL	Stock	26.195	26.3625	26.15	26.33	1686340.0
2014-10-24 09:00:00	AAPL	Stock	26.33	26.3725	26.14	26.16	32661132.0
2014-10-24 10:00:00	AAPL	Stock	26.1575	26.2725	26.1325	26.2325	27403312.0
2014-10-24 11:00:00	AAPL	Stock	26.2325	26.27	26.15	26.2568	20619840.0
2014-10-24 12:00:00	AAPL	Stock	26.255	26.26	26.2	26.2025	12836664.0
2014-10-24 13:00:00	AAPL	Stock	26.2038	26.2475	26.1875	26.235	11666320.0
2014-10-24 14:00:00	AAPL	Stock	26.2355	26.2525	26.1925	26.2412	14370316.0
2014-10-24 15:00:00	AAPL	Stock	26.2408	26.3175	26.22	26.305	33333580.0
2014-10-24 16:00:00	AAPL	Stock	26.305	26.3225	26.214	26.3075	9540044.0
2014-10-24 17:00:00	AAPL	Stock	26.29	26.32	26.29	26.3	139256.0
2014-10-24 18:00:00	AAPL	Stock	26.3075	26.3175	26.295	26.3075	142556.0
2014-10-24 19:00:00	AAPL	Stock	26.3075	26.315	26.2925	26.3125	209556.0
2014-10-24 04:00:00	MSFT	Stock	46.45	46.45	46.41	46.45	1800.0
2014-10-24 05:00:00	MSFT	Stock	46.44	46.44	46.3	46.39	6622.0
2014-10-24 06:00:00	MSFT	Stock	46.42	46.48	46.37	46.37	7862.0
2014-10-24 07:00:00	MSFT	Stock	46.37	46.48	46.15	46.25	60697.0
2014-10-24 08:00:00	MSFT	Stock	46.25	47.4	46.15	47.26	651702.0
2014-10-24 09:00:00	MSFT	Stock	47.28	47.35	45.41	45.59	16935960.0
2014-10-24 10:00:00	MSFT	Stock	45.59	45.91	45.18	45.69	11842043.0
2014-10-24 11:00:00	MSFT	Stock	45.68	45.85	45.44	45.735	5254587.0
2014-10-24 12:00:00	MSFT	Stock	45.745	45.96	45.71	45.84	4429156.0
2014-10-24 13:00:00	MSFT	Stock	45.83	45.95	45.72	45.89	3754823.0
2014-10-24 14:00:00	MSFT	Stock	45.88	46.04	45.88	45.99	4534424.0
2014-10-24 15:00:00	MSFT	Stock	45.99	46.25	45.9	46.13	8683513.0
2014-10-24 16:00:00	MSFT	Stock	46.13	46.18	44.935	46.15	2265840.0
2014-10-24 17:00:00	MSFT	Stock	46.15	46.19	46.1	46.19	14539.0
2014-10-24 18:00:00	MSFT	Stock	46.17	46.17	46.13	46.14	25085.0
2014-10-24 19:00:00	MSFT	Stock	46.13	46.14	46.03	46.03	2577.0
2014-10-24 09:00:00	NVDA	Stock	0.4575	0.4625	0.4571	0.4615	26146040.0
2014-10-24 10:00:00	NVDA	Stock	0.4615	0.4648	0.46	0.463	48640320.0
2014-10-24 11:00:00	NVDA	Stock	0.4629	0.4633	0.4595	0.4608	24445480.0
2014-10-24 12:00:00	NVDA	Stock	0.4608	0.4633	0.46	0.4615	15933280.0
2014-10-24 13:00:00	NVDA	Stock	0.4615	0.4618	0.4598	0.461	16659640.0
2014-10-24 14:00:00	NVDA	Stock	0.4609	0.461	0.4593	0.4594	16275800.0
2014-10-24 15:00:00	NVDA	Stock	0.4595	0.4622	0.4591	0.4619	41552080.0
2014-10-24 16:00:00	NVDA	Stock	0.462	0.462	0.4563	0.462	1919760.0
2014-10-24 19:00:00	NVDA	Stock	0.4618	0.4618	0.4618	0.4618	12000.0
2014-10-24 04:00:00	AMZN	Stock	14.0265	14.11	14.0265	14.065	357380.0
2014-10-24 05:00:00	AMZN	Stock	14.075	14.075	13.99	14.05	103100.0
2014-10-24 06:00:00	AMZN	Stock	14.05	14.05	13.916	13.916	300640.0
2014-10-24 07:00:00	AMZN	Stock	13.92	14.19	13.92	14.1085	1831980.0
2014-10-24 08:00:00	AMZN	Stock	14.109	14.245	13.9745	14.181	7740920.0
2014-10-24 09:00:00	AMZN	Stock	14.1975	14.6905	14.155	14.5142	93398420.0
2014-10-24 10:00:00	AMZN	Stock	14.517	14.6405	14.43	14.4995	62912820.0
2014-10-24 11:00:00	AMZN	Stock	14.4995	14.593	14.4175	14.5649	39503240.0
2014-10-24 12:00:00	AMZN	Stock	14.5645	14.587	14.3825	14.4035	30678880.0

> showing 50 of 47,736 rows — these rows as CSV

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