PREVIEW / stock_1hour / 2015-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-30.parquet
  size:    1.0 MB
  rows:    48,994
  symbols: 3,460

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-09-30 04:00:00	AAPL	Stock	27.5	27.62	27.5	27.5925	38944.0
2015-09-30 05:00:00	AAPL	Stock	27.5925	27.6225	27.525	27.5925	167176.0
2015-09-30 06:00:00	AAPL	Stock	27.59	27.5975	27.5625	27.5825	103012.0
2015-09-30 07:00:00	AAPL	Stock	27.575	27.595	27.48	27.5825	481128.0
2015-09-30 08:00:00	AAPL	Stock	27.5825	27.6575	27.485	27.55	1190408.0
2015-09-30 09:00:00	AAPL	Stock	27.55	27.675	27.45	27.5225	35969896.0
2015-09-30 10:00:00	AAPL	Stock	27.5225	27.885	27.515	27.79	36275500.0
2015-09-30 11:00:00	AAPL	Stock	27.7875	27.81	27.455	27.5175	26937000.0
2015-09-30 12:00:00	AAPL	Stock	27.52	27.54	27.25	27.3022	34069712.0
2015-09-30 13:00:00	AAPL	Stock	27.3012	27.4875	27.295	27.4175	21994636.0
2015-09-30 14:00:00	AAPL	Stock	27.4162	27.4338	27.1825	27.3975	30874232.0
2015-09-30 15:00:00	AAPL	Stock	27.3975	27.5725	27.3275	27.5725	39039172.0
2015-09-30 16:00:00	AAPL	Stock	27.575	27.5755	27.395	27.415	19145196.0
2015-09-30 17:00:00	AAPL	Stock	27.4225	27.4625	27.415	27.4425	110244.0
2015-09-30 18:00:00	AAPL	Stock	27.4375	27.4625	27.4225	27.46	60728.0
2015-09-30 19:00:00	AAPL	Stock	27.455	27.4825	27.45	27.4575	88336.0
2015-09-30 04:00:00	MSFT	Stock	43.8	43.8	43.8	43.8	250.0
2015-09-30 06:00:00	MSFT	Stock	43.97	44.0	43.97	44.0	1380.0
2015-09-30 07:00:00	MSFT	Stock	43.94	44.18	43.92	44.09	28762.0
2015-09-30 08:00:00	MSFT	Stock	44.02	44.1	43.81	43.89	36905.0
2015-09-30 09:00:00	MSFT	Stock	43.89	44.02	43.72	43.79	3124981.0
2015-09-30 10:00:00	MSFT	Stock	43.795	43.98	43.76	43.86	2865457.0
2015-09-30 11:00:00	MSFT	Stock	43.85	43.98	43.78	43.86	2596438.0
2015-09-30 12:00:00	MSFT	Stock	43.855	43.875	43.66	43.73	2775285.0
2015-09-30 13:00:00	MSFT	Stock	43.73	44.2	43.73	44.195	2336697.0
2015-09-30 14:00:00	MSFT	Stock	44.192	44.3	44.04	44.24	2359636.0
2015-09-30 15:00:00	MSFT	Stock	44.255	44.29	44.05	44.21	9341923.0
2015-09-30 16:00:00	MSFT	Stock	44.26	44.29	43.83	44.0	6942196.0
2015-09-30 17:00:00	MSFT	Stock	44.05	44.05	43.94	44.0	4195.0
2015-09-30 18:00:00	MSFT	Stock	44.0	44.0	44.0	44.0	800.0
2015-09-30 19:00:00	MSFT	Stock	44.0	44.09	44.0	44.09	1400.0
2015-09-30 08:00:00	NVDA	Stock	0.599	0.599	0.5983	0.599	636000.0
2015-09-30 09:00:00	NVDA	Stock	0.6045	0.6108	0.5948	0.6055	99538560.0
2015-09-30 10:00:00	NVDA	Stock	0.6055	0.6139	0.605	0.6082	86954400.0
2015-09-30 11:00:00	NVDA	Stock	0.6081	0.6122	0.6059	0.6108	99671040.0
2015-09-30 12:00:00	NVDA	Stock	0.6108	0.6115	0.6088	0.6093	44737320.0
2015-09-30 13:00:00	NVDA	Stock	0.6095	0.6145	0.6095	0.6138	39608480.0
2015-09-30 14:00:00	NVDA	Stock	0.6138	0.6145	0.611	0.6145	35944200.0
2015-09-30 15:00:00	NVDA	Stock	0.6145	0.617	0.6131	0.616	111296760.0
2015-09-30 16:00:00	NVDA	Stock	0.6162	0.6163	0.613	0.615	2653520.0
2015-09-30 17:00:00	NVDA	Stock	0.6162	0.6162	0.6162	0.6162	28000.0
2015-09-30 18:00:00	NVDA	Stock	0.6162	0.6162	0.6162	0.6162	7000.0
2015-09-30 04:00:00	AMZN	Stock	25.2675	25.318	25.141	25.141	28900.0
2015-09-30 05:00:00	AMZN	Stock	25.111	25.149	25.111	25.149	13720.0
2015-09-30 06:00:00	AMZN	Stock	25.149	25.152	25.149	25.152	4000.0
2015-09-30 07:00:00	AMZN	Stock	25.147	25.2	25.147	25.163	52480.0
2015-09-30 08:00:00	AMZN	Stock	25.196	25.2965	25.1745	25.2	463400.0
2015-09-30 09:00:00	AMZN	Stock	25.1785	25.5	25.175	25.346	12421660.0
2015-09-30 10:00:00	AMZN	Stock	25.348	25.575	25.2792	25.4535	12627560.0
2015-09-30 11:00:00	AMZN	Stock	25.449	25.51	25.308	25.3825	8418900.0

> showing 50 of 48,994 rows — these rows as CSV

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