PREVIEW / stock_1hour / 2017-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-30.parquet
  size:    1.0 MB
  rows:    47,774
  symbols: 2,979

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
2017-08-30 04:00:00	AAPL	Stock	40.9525	40.9525	40.875	40.9	27852.0
2017-08-30 05:00:00	AAPL	Stock	40.8725	40.875	40.855	40.855	2324.0
2017-08-30 06:00:00	AAPL	Stock	40.8275	40.855	40.8275	40.855	19856.0
2017-08-30 07:00:00	AAPL	Stock	40.865	40.9125	40.7318	40.85	152432.0
2017-08-30 08:00:00	AAPL	Stock	40.83	40.935	40.825	40.9	895872.0
2017-08-30 09:00:00	AAPL	Stock	40.91	40.9725	40.7725	40.8488	18616604.0
2017-08-30 10:00:00	AAPL	Stock	40.8475	40.885	40.6725	40.83	16113108.0
2017-08-30 11:00:00	AAPL	Stock	40.8252	40.855	40.7025	40.8	11462916.0
2017-08-30 12:00:00	AAPL	Stock	40.7988	40.8075	40.6525	40.6975	10525004.0
2017-08-30 13:00:00	AAPL	Stock	40.6975	40.91	40.6875	40.8775	10019372.0
2017-08-30 14:00:00	AAPL	Stock	40.8775	40.8775	40.79	40.8375	7239056.0
2017-08-30 15:00:00	AAPL	Stock	40.84	40.8475	40.7122	40.8325	14383408.0
2017-08-30 16:00:00	AAPL	Stock	40.8375	40.8475	40.7855	40.83	7776220.0
2017-08-30 17:00:00	AAPL	Stock	40.825	40.83	40.815	40.825	59892.0
2017-08-30 18:00:00	AAPL	Stock	40.8175	40.845	40.8125	40.84	53448.0
2017-08-30 19:00:00	AAPL	Stock	40.84	40.845	40.8375	40.845	69516.0
2017-08-30 05:00:00	MSFT	Stock	73.3	73.3	73.3	73.3	243.0
2017-08-30 06:00:00	MSFT	Stock	73.3	73.3	73.2	73.2	575.0
2017-08-30 07:00:00	MSFT	Stock	73.25	73.26	73.2	73.2	2000.0
2017-08-30 08:00:00	MSFT	Stock	73.22	73.22	73.2	73.21	1993.0
2017-08-30 09:00:00	MSFT	Stock	73.2	73.24	72.829	73.21	1293706.0
2017-08-30 10:00:00	MSFT	Stock	73.21	73.44	73.02	73.43	1596473.0
2017-08-30 11:00:00	MSFT	Stock	73.425	73.72	73.41	73.6	1745855.0
2017-08-30 12:00:00	MSFT	Stock	73.61	73.76	73.53	73.73	990185.0
2017-08-30 13:00:00	MSFT	Stock	73.724	74.075	73.68	74.03	1545268.0
2017-08-30 14:00:00	MSFT	Stock	74.03	74.21	73.931	74.14	1674017.0
2017-08-30 15:00:00	MSFT	Stock	74.135	74.145	73.76	74.0	3301428.0
2017-08-30 16:00:00	MSFT	Stock	74.01	74.01	73.86	73.91	3570165.0
2017-08-30 17:00:00	MSFT	Stock	74.0	74.01	74.0	74.0	1175.0
2017-08-30 18:00:00	MSFT	Stock	74.0	74.0	73.96	73.96	200.0
2017-08-30 19:00:00	MSFT	Stock	73.99	74.24	73.94	74.15	3076.0
2017-08-30 05:00:00	NVDA	Stock	4.1405	4.1425	4.1362	4.1362	76800.0
2017-08-30 06:00:00	NVDA	Stock	4.1455	4.1475	4.1455	4.1475	40000.0
2017-08-30 07:00:00	NVDA	Stock	4.1412	4.1418	4.1365	4.1388	67480.0
2017-08-30 08:00:00	NVDA	Stock	4.1405	4.1438	4.13	4.1382	1587720.0
2017-08-30 09:00:00	NVDA	Stock	4.1358	4.1425	4.1225	4.1372	55415000.0
2017-08-30 10:00:00	NVDA	Stock	4.1355	4.1359	4.1068	4.1252	70366840.0
2017-08-30 11:00:00	NVDA	Stock	4.124	4.127	4.113	4.1162	23756680.0
2017-08-30 12:00:00	NVDA	Stock	4.1155	4.1322	4.107	4.1254	32992920.0
2017-08-30 13:00:00	NVDA	Stock	4.1263	4.1308	4.1198	4.1275	27178600.0
2017-08-30 14:00:00	NVDA	Stock	4.1274	4.1532	4.1245	4.1388	63876720.0
2017-08-30 15:00:00	NVDA	Stock	4.1392	4.1458	4.1258	4.1412	69122560.0
2017-08-30 16:00:00	NVDA	Stock	4.142	4.142	4.1275	4.135	10590200.0
2017-08-30 17:00:00	NVDA	Stock	4.1398	4.142	4.1358	4.1358	1153240.0
2017-08-30 18:00:00	NVDA	Stock	4.1352	4.1438	4.1352	4.1438	483200.0
2017-08-30 19:00:00	NVDA	Stock	4.1438	4.148	4.1425	4.1475	215960.0
2017-08-30 06:00:00	AMZN	Stock	47.83	47.83	47.83	47.83	2000.0
2017-08-30 07:00:00	AMZN	Stock	47.8775	47.987	47.833	47.8815	75560.0
2017-08-30 08:00:00	AMZN	Stock	47.875	47.95	47.813	47.813	111220.0
2017-08-30 09:00:00	AMZN	Stock	47.85	48.175	47.7815	48.133	8997000.0

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

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