PREVIEW / stock_1hour / 2015-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-25.parquet
  size:    1.1 MB
  rows:    51,135
  symbols: 3,497

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-25 04:00:00	AAPL	Stock	26.4575	27.0875	26.4575	27.05	163216.0
2015-08-25 05:00:00	AAPL	Stock	27.05	27.175	26.9625	27.025	178756.0
2015-08-25 06:00:00	AAPL	Stock	27.1125	27.5575	27.04	27.35	1136996.0
2015-08-25 07:00:00	AAPL	Stock	27.35	27.4375	27.2525	27.285	1120128.0
2015-08-25 08:00:00	AAPL	Stock	27.285	27.5	26.9875	27.0475	3881948.0
2015-08-25 09:00:00	AAPL	Stock	27.04	27.79	26.8325	26.9125	83792088.0
2015-08-25 10:00:00	AAPL	Stock	26.9075	27.2275	26.8675	27.1225	53720524.0
2015-08-25 11:00:00	AAPL	Stock	27.1225	27.3125	27.122	27.2325	39584320.0
2015-08-25 12:00:00	AAPL	Stock	27.2325	27.3175	27.125	27.1575	24711824.0
2015-08-25 13:00:00	AAPL	Stock	27.16	27.1975	26.75	27.0225	40832700.0
2015-08-25 14:00:00	AAPL	Stock	27.0212	27.1	26.785	27.0375	31027904.0
2015-08-25 15:00:00	AAPL	Stock	27.0375	27.1	25.875	25.9375	78222636.0
2015-08-25 16:00:00	AAPL	Stock	25.935	27.2638	25.8	25.82	22562032.0
2015-08-25 17:00:00	AAPL	Stock	25.8375	25.9	25.575	25.8925	1053100.0
2015-08-25 18:00:00	AAPL	Stock	25.895	25.9	25.69	25.7075	387404.0
2015-08-25 19:00:00	AAPL	Stock	25.7475	25.7875	25.525	25.545	292028.0
2015-08-25 04:00:00	MSFT	Stock	42.51	42.82	42.5	42.5	7300.0
2015-08-25 05:00:00	MSFT	Stock	42.51	42.7	42.5	42.57	2350.0
2015-08-25 06:00:00	MSFT	Stock	42.69	43.42	42.5	42.9	20159.0
2015-08-25 07:00:00	MSFT	Stock	42.65	43.06	42.65	43.02	20311.0
2015-08-25 08:00:00	MSFT	Stock	42.98	43.44	42.5	42.55	52381.0
2015-08-25 09:00:00	MSFT	Stock	42.59	42.94	41.62	42.62	9924295.0
2015-08-25 10:00:00	MSFT	Stock	42.62	42.89	42.47	42.7	7969246.0
2015-08-25 11:00:00	MSFT	Stock	42.7	43.24	42.67	42.68	5294423.0
2015-08-25 12:00:00	MSFT	Stock	42.69	42.78	42.48	42.5	4199635.0
2015-08-25 13:00:00	MSFT	Stock	42.505	42.59	41.84	42.045	6909538.0
2015-08-25 14:00:00	MSFT	Stock	42.04	42.37	41.88	42.27	6893982.0
2015-08-25 15:00:00	MSFT	Stock	42.26	42.345	40.39	40.47	21197962.0
2015-08-25 16:00:00	MSFT	Stock	40.47	43.005	40.47	40.647	4629089.0
2015-08-25 17:00:00	MSFT	Stock	40.55	40.64	40.5	40.64	4700.0
2015-08-25 18:00:00	MSFT	Stock	40.57	40.64	40.47	40.47	6103.0
2015-08-25 19:00:00	MSFT	Stock	40.55	40.55	40.47	40.47	9657.0
2015-08-25 07:00:00	NVDA	Stock	0.5445	0.5445	0.5445	0.5445	14200.0
2015-08-25 08:00:00	NVDA	Stock	0.55	0.55	0.5425	0.55	94200.0
2015-08-25 09:00:00	NVDA	Stock	0.5367	0.5425	0.5275	0.5285	42154320.0
2015-08-25 10:00:00	NVDA	Stock	0.5285	0.5302	0.524	0.5262	67777960.0
2015-08-25 11:00:00	NVDA	Stock	0.5262	0.5289	0.5258	0.5268	87854400.0
2015-08-25 12:00:00	NVDA	Stock	0.5268	0.528	0.5265	0.5275	51231120.0
2015-08-25 13:00:00	NVDA	Stock	0.5273	0.528	0.5185	0.522	48505040.0
2015-08-25 14:00:00	NVDA	Stock	0.522	0.5228	0.5182	0.5213	58734520.0
2015-08-25 15:00:00	NVDA	Stock	0.5213	0.5215	0.507	0.507	137141920.0
2015-08-25 16:00:00	NVDA	Stock	0.5072	0.5105	0.507	0.5105	1386040.0
2015-08-25 19:00:00	NVDA	Stock	0.5098	0.5098	0.5068	0.5068	22000.0
2015-08-25 04:00:00	AMZN	Stock	23.895	23.9185	23.856	23.8675	27960.0
2015-08-25 05:00:00	AMZN	Stock	23.85	23.9	23.744	23.9	25020.0
2015-08-25 06:00:00	AMZN	Stock	23.8505	24.2	23.8505	24.1	81520.0
2015-08-25 07:00:00	AMZN	Stock	24.106	24.3695	24.1	24.3	229920.0
2015-08-25 08:00:00	AMZN	Stock	24.3225	24.3695	24.058	24.1775	979380.0
2015-08-25 09:00:00	AMZN	Stock	24.1775	24.472	23.957	23.979	22340020.0
2015-08-25 10:00:00	AMZN	Stock	23.979	24.131	23.8625	24.1125	15398640.0

> showing 50 of 51,135 rows — these rows as CSV

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