PREVIEW / stock_1hour / 2020-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-17.parquet
  size:    1.2 MB
  rows:    57,059
  symbols: 2,437

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
2020-06-17 04:00:00	AAPL	Stock	88.445	88.7625	88.445	88.75	51032.0
2020-06-17 05:00:00	AAPL	Stock	88.75	88.8025	88.27	88.3	19024.0
2020-06-17 06:00:00	AAPL	Stock	88.265	88.72	88.265	88.6075	19236.0
2020-06-17 07:00:00	AAPL	Stock	88.625	89.0	88.5	88.9275	546356.0
2020-06-17 08:00:00	AAPL	Stock	88.8	89.0	88.4325	88.819	668132.0
2020-06-17 09:00:00	AAPL	Stock	88.8195	88.9625	88.205	88.4625	17016276.0
2020-06-17 10:00:00	AAPL	Stock	88.4675	88.6725	88.0825	88.5975	15382228.0
2020-06-17 11:00:00	AAPL	Stock	88.59	88.6425	88.239	88.617	9615800.0
2020-06-17 12:00:00	AAPL	Stock	88.62	88.7875	88.5525	88.705	8872544.0
2020-06-17 13:00:00	AAPL	Stock	88.71	88.8125	88.595	88.6	6881036.0
2020-06-17 14:00:00	AAPL	Stock	88.605	88.77	88.4912	88.52	7466540.0
2020-06-17 15:00:00	AAPL	Stock	88.5	88.5325	87.7725	87.811	17630060.0
2020-06-17 16:00:00	AAPL	Stock	87.8975	88.0225	87.8275	88.0225	6754296.0
2020-06-17 17:00:00	AAPL	Stock	88.02	88.02	87.855	87.855	85864.0
2020-06-17 18:00:00	AAPL	Stock	87.855	88.025	87.8175	87.9375	74192.0
2020-06-17 19:00:00	AAPL	Stock	87.9925	88.0	87.5	87.575	135896.0
2020-06-17 04:00:00	MSFT	Stock	194.07	195.17	194.07	195.17	2992.0
2020-06-17 05:00:00	MSFT	Stock	194.8	194.91	194.04	194.04	2423.0
2020-06-17 06:00:00	MSFT	Stock	194.11	195.36	194.11	195.0	9021.0
2020-06-17 07:00:00	MSFT	Stock	194.8	195.25	194.5	195.0	42657.0
2020-06-17 08:00:00	MSFT	Stock	194.81	195.23	194.512	194.8	43939.0
2020-06-17 09:00:00	MSFT	Stock	194.8	195.62	194.26	194.67	3278350.0
2020-06-17 10:00:00	MSFT	Stock	194.69	195.15	193.69	195.01	3480045.0
2020-06-17 11:00:00	MSFT	Stock	195.01	195.52	194.84	195.28	2241154.0
2020-06-17 12:00:00	MSFT	Stock	195.3	195.93	194.96	195.823	1942239.0
2020-06-17 13:00:00	MSFT	Stock	195.81	196.32	195.55	195.55	2058319.0
2020-06-17 14:00:00	MSFT	Stock	195.55	196.16	195.16	195.18	1964559.0
2020-06-17 15:00:00	MSFT	Stock	195.154	195.29	193.8	194.2	3978461.0
2020-06-17 16:00:00	MSFT	Stock	194.2	194.69	194.2	194.55	2572471.0
2020-06-17 17:00:00	MSFT	Stock	194.55	194.89	194.3	194.3	6324.0
2020-06-17 18:00:00	MSFT	Stock	194.3	194.9	194.0	194.55	13656.0
2020-06-17 19:00:00	MSFT	Stock	194.5	194.75	193.75	193.75	13603.0
2020-06-17 04:00:00	NVDA	Stock	9.1275	9.15	9.1275	9.15	32520.0
2020-06-17 05:00:00	NVDA	Stock	9.14	9.14	9.1	9.1093	58160.0
2020-06-17 06:00:00	NVDA	Stock	9.1232	9.1232	9.1232	9.1232	6280.0
2020-06-17 07:00:00	NVDA	Stock	9.125	9.1638	9.125	9.1375	642720.0
2020-06-17 08:00:00	NVDA	Stock	9.135	9.1736	9.13	9.135	928040.0
2020-06-17 09:00:00	NVDA	Stock	9.1325	9.2215	9.083	9.1326	73771680.0
2020-06-17 10:00:00	NVDA	Stock	9.1345	9.1763	9.0702	9.1638	56729160.0
2020-06-17 11:00:00	NVDA	Stock	9.164	9.1832	9.13	9.1667	30484760.0
2020-06-17 12:00:00	NVDA	Stock	9.168	9.2062	9.1548	9.1993	22083600.0
2020-06-17 13:00:00	NVDA	Stock	9.2002	9.2485	9.1862	9.2198	29764400.0
2020-06-17 14:00:00	NVDA	Stock	9.2204	9.299	9.205	9.2668	54950200.0
2020-06-17 15:00:00	NVDA	Stock	9.2652	9.266	9.1598	9.2368	79239040.0
2020-06-17 16:00:00	NVDA	Stock	9.236	9.247	9.2222	9.24	13057400.0
2020-06-17 17:00:00	NVDA	Stock	9.2378	9.2435	9.22	9.2373	145800.0
2020-06-17 18:00:00	NVDA	Stock	9.2362	9.2397	9.2062	9.237	237400.0
2020-06-17 19:00:00	NVDA	Stock	9.2362	9.2388	9.2002	9.2075	421880.0
2020-06-17 04:00:00	AMZN	Stock	131.5	131.605	131.5	131.55	10420.0
2020-06-17 05:00:00	AMZN	Stock	131.3245	131.3245	131.3245	131.3245	2400.0

> showing 50 of 57,059 rows — these rows as CSV

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