PREVIEW / stock_30min / 2020-01-07

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-07.parquet
  size:    1.8 MB
  rows:    89,231
  symbols: 2,468

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-01-07 04:00:00	AAPL	Stock	75.1225	75.2	75.0875	75.1975	46552.0
2020-01-07 04:30:00	AAPL	Stock	75.225	75.225	75.03	75.125	20424.0
2020-01-07 05:00:00	AAPL	Stock	75.1225	75.1225	75.1225	75.1225	400.0
2020-01-07 05:30:00	AAPL	Stock	75.06	75.0825	75.05	75.08	61500.0
2020-01-07 06:00:00	AAPL	Stock	75.0825	75.1125	75.0275	75.05	61096.0
2020-01-07 06:30:00	AAPL	Stock	75.0275	75.05	74.96	74.9775	38280.0
2020-01-07 07:00:00	AAPL	Stock	75.0	75.165	74.975	75.165	293276.0
2020-01-07 07:30:00	AAPL	Stock	75.1475	75.15	75.0625	75.14	114368.0
2020-01-07 08:00:00	AAPL	Stock	74.9975	75.15	74.975	75.0225	406564.0
2020-01-07 08:30:00	AAPL	Stock	75.0025	75.015	74.8475	74.8912	316864.0
2020-01-07 09:00:00	AAPL	Stock	74.9	75.02	74.8575	74.9825	453864.0
2020-01-07 09:30:00	AAPL	Stock	74.9725	75.225	74.4375	74.706	19471308.0
2020-01-07 10:00:00	AAPL	Stock	74.7225	74.8408	74.37	74.5025	9239568.0
2020-01-07 10:30:00	AAPL	Stock	74.4925	74.8925	74.385	74.8508	7549652.0
2020-01-07 11:00:00	AAPL	Stock	74.845	74.9708	74.79	74.9375	4897448.0
2020-01-07 11:30:00	AAPL	Stock	74.94	74.955	74.6375	74.7325	5135296.0
2020-01-07 12:00:00	AAPL	Stock	74.7375	74.8325	74.6625	74.7775	3303972.0
2020-01-07 12:30:00	AAPL	Stock	74.775	74.9125	74.7125	74.8925	2994564.0
2020-01-07 13:00:00	AAPL	Stock	74.8935	75.1025	74.8935	74.97	4757928.0
2020-01-07 13:30:00	AAPL	Stock	74.97	75.02	74.9075	75.0175	2576600.0
2020-01-07 14:00:00	AAPL	Stock	75.0185	75.025	74.7625	74.8188	3245964.0
2020-01-07 14:30:00	AAPL	Stock	74.8188	74.8525	74.74	74.7505	3058456.0
2020-01-07 15:00:00	AAPL	Stock	74.7525	74.835	74.725	74.8325	3881180.0
2020-01-07 15:30:00	AAPL	Stock	74.8325	74.891	74.4875	74.5675	8890024.0
2020-01-07 16:00:00	AAPL	Stock	74.5975	74.5975	74.515	74.5475	8239552.0
2020-01-07 16:30:00	AAPL	Stock	74.5275	74.5975	74.3475	74.475	291292.0
2020-01-07 17:00:00	AAPL	Stock	74.4625	74.5975	74.425	74.455	29048.0
2020-01-07 17:30:00	AAPL	Stock	74.455	74.5975	74.4375	74.4625	27604.0
2020-01-07 18:00:00	AAPL	Stock	74.44	74.5	73.855	74.0	279276.0
2020-01-07 18:30:00	AAPL	Stock	74.05	74.05	73.425	73.65	663088.0
2020-01-07 19:00:00	AAPL	Stock	73.64	73.6725	73.2	73.22	526480.0
2020-01-07 19:30:00	AAPL	Stock	73.225	73.25	73.0	73.15	773224.0
2020-01-07 04:00:00	MSFT	Stock	159.28	159.31	159.15	159.26	1786.0
2020-01-07 04:30:00	MSFT	Stock	159.6	159.85	159.45	159.45	4674.0
2020-01-07 05:00:00	MSFT	Stock	159.45	159.69	159.45	159.53	4732.0
2020-01-07 05:30:00	MSFT	Stock	159.55	159.55	159.3	159.49	5140.0
2020-01-07 06:00:00	MSFT	Stock	159.36	159.5	159.24	159.48	3260.0
2020-01-07 06:30:00	MSFT	Stock	159.19	159.36	158.72	159.12	10409.0
2020-01-07 07:00:00	MSFT	Stock	159.13	159.31	159.1	159.28	7365.0
2020-01-07 07:30:00	MSFT	Stock	159.21	159.4	159.13	159.4	16125.0
2020-01-07 08:00:00	MSFT	Stock	159.25	159.457	159.0	159.16	13114.0
2020-01-07 08:30:00	MSFT	Stock	159.09	159.13	158.78	158.84	190407.0
2020-01-07 09:00:00	MSFT	Stock	158.75	159.4	158.69	159.4	39619.0
2020-01-07 09:30:00	MSFT	Stock	159.32	159.67	158.465	158.92	2692353.0
2020-01-07 10:00:00	MSFT	Stock	158.93	159.14	158.6	158.81	1073088.0
2020-01-07 10:30:00	MSFT	Stock	158.81	158.923	158.428	158.898	1132837.0
2020-01-07 11:00:00	MSFT	Stock	158.9	159.13	158.845	158.93	792269.0
2020-01-07 11:30:00	MSFT	Stock	158.935	158.94	158.49	158.656	812424.0
2020-01-07 12:00:00	MSFT	Stock	158.66	158.79	158.55	158.72	560869.0
2020-01-07 12:30:00	MSFT	Stock	158.71	158.71	158.34	158.39	787265.0

> showing 50 of 89,231 rows — these rows as CSV

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