PREVIEW / stock_30min / 2018-10-10

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-10.parquet
  size:    1.8 MB
  rows:    86,419
  symbols: 2,797

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
2018-10-10 04:00:00	AAPL	Stock	56.78	56.78	56.7125	56.7125	16320.0
2018-10-10 04:30:00	AAPL	Stock	56.7	56.7	56.7	56.7	1200.0
2018-10-10 05:00:00	AAPL	Stock	56.735	56.75	56.7	56.705	10104.0
2018-10-10 05:30:00	AAPL	Stock	56.705	56.705	56.705	56.705	400.0
2018-10-10 06:00:00	AAPL	Stock	56.7175	56.7175	56.7175	56.7175	6600.0
2018-10-10 07:00:00	AAPL	Stock	56.725	56.8575	56.655	56.8575	114840.0
2018-10-10 07:30:00	AAPL	Stock	56.855	56.855	56.575	56.625	75232.0
2018-10-10 08:00:00	AAPL	Stock	56.745	56.87	56.375	56.495	298072.0
2018-10-10 08:30:00	AAPL	Stock	56.5125	56.5125	56.375	56.47	142484.0
2018-10-10 09:00:00	AAPL	Stock	56.475	56.5	56.32	56.345	218792.0
2018-10-10 09:30:00	AAPL	Stock	56.3425	56.5875	55.72	55.8975	14339216.0
2018-10-10 10:00:00	AAPL	Stock	55.8975	56.0398	55.64	55.8575	10070968.0
2018-10-10 10:30:00	AAPL	Stock	55.8725	56.095	55.7625	55.9138	6588976.0
2018-10-10 11:00:00	AAPL	Stock	55.9125	56.0175	55.5425	55.8302	9668592.0
2018-10-10 11:30:00	AAPL	Stock	55.8388	56.1	55.7	55.8375	4979280.0
2018-10-10 12:00:00	AAPL	Stock	55.835	55.9925	55.6925	55.8375	4600952.0
2018-10-10 12:30:00	AAPL	Stock	55.8272	55.895	55.6375	55.655	3559328.0
2018-10-10 13:00:00	AAPL	Stock	55.65	55.955	55.5425	55.8175	5220516.0
2018-10-10 13:30:00	AAPL	Stock	55.8075	55.8325	55.5925	55.685	3695780.0
2018-10-10 14:00:00	AAPL	Stock	55.6775	55.71	55.375	55.44	6745956.0
2018-10-10 14:30:00	AAPL	Stock	55.4425	55.5	55.0375	55.3425	9394116.0
2018-10-10 15:00:00	AAPL	Stock	55.3412	55.3412	54.88	55.206	11678632.0
2018-10-10 15:30:00	AAPL	Stock	55.2125	55.225	54.0125	54.0975	28729820.0
2018-10-10 16:00:00	AAPL	Stock	54.0975	54.2975	53.825	53.855	16551784.0
2018-10-10 16:30:00	AAPL	Stock	53.875	54.09	53.625	53.65	353556.0
2018-10-10 17:00:00	AAPL	Stock	53.65	53.7625	53.625	53.7075	201784.0
2018-10-10 17:30:00	AAPL	Stock	53.6975	53.7875	53.675	53.78	190044.0
2018-10-10 18:00:00	AAPL	Stock	53.7475	53.8125	53.6675	53.7925	158612.0
2018-10-10 18:30:00	AAPL	Stock	53.7625	53.79	53.6875	53.725	106928.0
2018-10-10 19:00:00	AAPL	Stock	53.75	53.7875	53.675	53.6775	118500.0
2018-10-10 19:30:00	AAPL	Stock	53.6675	53.675	53.4275	53.5475	205460.0
2018-10-10 04:00:00	MSFT	Stock	112.3	112.3	112.26	112.26	300.0
2018-10-10 05:00:00	MSFT	Stock	112.4	112.4	112.4	112.4	100.0
2018-10-10 07:00:00	MSFT	Stock	112.35	112.4	112.35	112.4	1321.0
2018-10-10 07:30:00	MSFT	Stock	112.42	112.42	111.9	111.9	13568.0
2018-10-10 08:00:00	MSFT	Stock	112.17	112.45	111.81	111.94	5798.0
2018-10-10 08:30:00	MSFT	Stock	111.94	111.94	111.72	111.82	13470.0
2018-10-10 09:00:00	MSFT	Stock	111.82	111.99	111.23	111.23	38319.0
2018-10-10 09:30:00	MSFT	Stock	111.2	111.5	109.361	109.575	4639365.0
2018-10-10 10:00:00	MSFT	Stock	109.58	109.81	108.882	109.58	3801313.0
2018-10-10 10:30:00	MSFT	Stock	109.59	109.885	109.11	109.28	2983594.0
2018-10-10 11:00:00	MSFT	Stock	109.28	109.44	107.65	108.52	5525529.0
2018-10-10 11:30:00	MSFT	Stock	108.51	108.68	108.028	108.21	2402332.0
2018-10-10 12:00:00	MSFT	Stock	108.2	109.25	107.837	108.99	2695510.0
2018-10-10 12:30:00	MSFT	Stock	108.982	109.026	108.45	108.52	1437633.0
2018-10-10 13:00:00	MSFT	Stock	108.52	109.03	108.09	108.965	2112338.0
2018-10-10 13:30:00	MSFT	Stock	108.96	109.43	108.505	108.675	2232600.0
2018-10-10 14:00:00	MSFT	Stock	108.66	108.83	108.14	108.81	2368424.0
2018-10-10 14:30:00	MSFT	Stock	108.81	108.94	107.94	108.45	3218467.0
2018-10-10 15:00:00	MSFT	Stock	108.45	108.46	107.46	107.98	3498775.0

> showing 50 of 86,419 rows — these rows as CSV

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