PREVIEW / stock_30min / 2020-04-07

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-07.parquet
  size:    1.9 MB
  rows:    94,993
  symbols: 2,392

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-04-07 04:00:00	AAPL	Stock	67.25	67.4625	66.7625	67.3725	110112.0
2020-04-07 04:30:00	AAPL	Stock	67.3825	67.3825	67.075	67.075	32884.0
2020-04-07 05:00:00	AAPL	Stock	67.125	67.2125	66.97	67.08	29736.0
2020-04-07 05:30:00	AAPL	Stock	67.11	67.16	67.05	67.1475	12924.0
2020-04-07 06:00:00	AAPL	Stock	67.1375	67.65	67.075	67.4625	59204.0
2020-04-07 06:30:00	AAPL	Stock	67.43	67.625	67.375	67.61	29460.0
2020-04-07 07:00:00	AAPL	Stock	67.54	67.625	66.9975	67.205	792900.0
2020-04-07 07:30:00	AAPL	Stock	67.2025	67.375	66.995	67.1	272564.0
2020-04-07 08:00:00	AAPL	Stock	67.4055	67.61	67.0	67.29	966388.0
2020-04-07 08:30:00	AAPL	Stock	67.265	67.6025	67.2525	67.575	643684.0
2020-04-07 09:00:00	AAPL	Stock	67.575	67.825	67.465	67.74	706924.0
2020-04-07 09:30:00	AAPL	Stock	67.7	67.925	66.575	67.335	29041220.0
2020-04-07 10:00:00	AAPL	Stock	67.3375	67.41	66.2	66.31	17407200.0
2020-04-07 10:30:00	AAPL	Stock	66.3205	66.6875	65.7525	66.0625	11725348.0
2020-04-07 11:00:00	AAPL	Stock	66.0475	66.3625	65.86	66.2825	7750452.0
2020-04-07 11:30:00	AAPL	Stock	66.2725	66.6975	66.2625	66.4625	7479504.0
2020-04-07 12:00:00	AAPL	Stock	66.47	66.9248	66.4375	66.6727	8727612.0
2020-04-07 12:30:00	AAPL	Stock	66.671	66.7555	66.235	66.4925	9112384.0
2020-04-07 13:00:00	AAPL	Stock	66.5075	66.5875	66.285	66.3575	5094812.0
2020-04-07 13:30:00	AAPL	Stock	66.365	66.375	65.7125	65.8412	9330928.0
2020-04-07 14:00:00	AAPL	Stock	65.8325	65.8675	65.3125	65.6715	9565304.0
2020-04-07 14:30:00	AAPL	Stock	65.6682	65.78	64.775	65.0035	8785828.0
2020-04-07 15:00:00	AAPL	Stock	65.01	65.7775	64.8975	65.0188	13220944.0
2020-04-07 15:30:00	AAPL	Stock	65.04	65.7575	64.75	64.8462	18721080.0
2020-04-07 16:00:00	AAPL	Stock	64.8575	64.925	64.2412	64.595	9306208.0
2020-04-07 16:30:00	AAPL	Stock	64.6125	65.895	64.5375	64.5625	69928.0
2020-04-07 17:00:00	AAPL	Stock	64.5975	64.6125	64.505	64.505	40244.0
2020-04-07 17:30:00	AAPL	Stock	64.525	64.6125	64.5	64.5475	40044.0
2020-04-07 18:00:00	AAPL	Stock	64.5275	64.625	64.445	64.5	71252.0
2020-04-07 18:30:00	AAPL	Stock	64.5075	64.6	64.4025	64.5475	66780.0
2020-04-07 19:00:00	AAPL	Stock	64.5025	64.8125	64.5	64.8125	56208.0
2020-04-07 19:30:00	AAPL	Stock	64.8225	65.0425	64.75	65.0	82792.0
2020-04-07 04:00:00	MSFT	Stock	169.01	169.84	168.69	169.8	14860.0
2020-04-07 04:30:00	MSFT	Stock	169.85	169.88	168.8	168.8	7761.0
2020-04-07 05:00:00	MSFT	Stock	168.8	169.25	168.71	169.25	5607.0
2020-04-07 05:30:00	MSFT	Stock	169.19	169.4	168.56	168.56	3733.0
2020-04-07 06:00:00	MSFT	Stock	168.88	170.5	168.88	169.99	9136.0
2020-04-07 06:30:00	MSFT	Stock	169.54	170.02	169.3	170.0	16576.0
2020-04-07 07:00:00	MSFT	Stock	169.58	170.2	169.13	169.92	76926.0
2020-04-07 07:30:00	MSFT	Stock	169.96	170.11	169.31	169.41	69586.0
2020-04-07 08:00:00	MSFT	Stock	169.6	170.15	169.34	169.8	165613.0
2020-04-07 08:30:00	MSFT	Stock	169.7	170.1	169.5	169.8	106895.0
2020-04-07 09:00:00	MSFT	Stock	169.9	170.5	169.59	169.65	125744.0
2020-04-07 09:30:00	MSFT	Stock	169.65	170.0	166.82	167.721	9292293.0
2020-04-07 10:00:00	MSFT	Stock	167.71	168.09	164.15	164.3	6271925.0
2020-04-07 10:30:00	MSFT	Stock	164.31	165.826	164.06	165.54	3488759.0
2020-04-07 11:00:00	MSFT	Stock	165.54	166.55	164.42	166.46	3330445.0
2020-04-07 11:30:00	MSFT	Stock	166.45	167.22	165.8	166.13	2567158.0
2020-04-07 12:00:00	MSFT	Stock	166.175	168.0	166.03	167.16	2511288.0
2020-04-07 12:30:00	MSFT	Stock	167.16	167.53	166.6	167.254	1900692.0

> showing 50 of 94,993 rows — these rows as CSV

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