PREVIEW / stock_30min / 2022-04-28

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-28.parquet
  size:    2.2 MB
  rows:    108,495
  symbols: 2,498

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
2022-04-28 04:00:00	AAPL	Stock	159.31	160.87	159.12	160.5	82240.0
2022-04-28 04:30:00	AAPL	Stock	160.5	160.8	160.33	160.8	7413.0
2022-04-28 05:00:00	AAPL	Stock	160.8	160.89	160.1	160.13	8831.0
2022-04-28 05:30:00	AAPL	Stock	160.17	160.3	159.95	160.05	14967.0
2022-04-28 06:00:00	AAPL	Stock	160.05	160.5	159.72	160.01	20893.0
2022-04-28 06:30:00	AAPL	Stock	160.05	160.28	159.95	159.96	11133.0
2022-04-28 07:00:00	AAPL	Stock	160.12	160.9	160.0	160.5	103333.0
2022-04-28 07:30:00	AAPL	Stock	160.54	160.54	160.0	160.2	57761.0
2022-04-28 08:00:00	AAPL	Stock	160.1999	160.9	159.31	159.69	530966.0
2022-04-28 08:30:00	AAPL	Stock	159.67	159.99	158.8012	159.38	474409.0
2022-04-28 09:00:00	AAPL	Stock	159.38	159.58	159.05	159.16	265864.0
2022-04-28 09:30:00	AAPL	Stock	159.25	161.11	159.15	159.71	10716455.0
2022-04-28 10:00:00	AAPL	Stock	159.715	161.3238	158.93	159.525	8554296.0
2022-04-28 10:30:00	AAPL	Stock	159.52	160.82	159.13	160.72	5829451.0
2022-04-28 11:00:00	AAPL	Stock	160.73	162.51	160.5	161.4181	7366365.0
2022-04-28 11:30:00	AAPL	Stock	161.42	161.72	160.07	160.51	5382855.0
2022-04-28 12:00:00	AAPL	Stock	160.5	162.34	160.47	162.2801	4837345.0
2022-04-28 12:30:00	AAPL	Stock	162.29	163.27	162.13	162.7692	4624531.0
2022-04-28 13:00:00	AAPL	Stock	162.77	163.69	162.49	163.46	4900364.0
2022-04-28 13:30:00	AAPL	Stock	163.475	163.99	163.215	163.65	4552865.0
2022-04-28 14:00:00	AAPL	Stock	163.65	163.81	162.94	163.0931	4653507.0
2022-04-28 14:30:00	AAPL	Stock	163.1	163.9	162.88	163.355	4245924.0
2022-04-28 15:00:00	AAPL	Stock	163.35	164.515	163.11	163.92	6628347.0
2022-04-28 15:30:00	AAPL	Stock	163.93	164.12	162.55	164.01	11505922.0
2022-04-28 16:00:00	AAPL	Stock	164.01	164.89	160.2	163.6387	8630639.0
2022-04-28 16:30:00	AAPL	Stock	163.66	169.99	163.44	163.77	4966622.0
2022-04-28 17:00:00	AAPL	Stock	163.95	165.0	153.5	158.29	4006895.0
2022-04-28 17:30:00	AAPL	Stock	158.08	158.8	155.55	157.15	1662556.0
2022-04-28 18:00:00	AAPL	Stock	157.15	160.34	156.65	160.3	1172072.0
2022-04-28 18:30:00	AAPL	Stock	160.32	160.44	159.5	160.38	584783.0
2022-04-28 19:00:00	AAPL	Stock	160.2	160.5	160.0	160.09	240790.0
2022-04-28 19:30:00	AAPL	Stock	160.08	160.15	159.8	160.01	331362.0
2022-04-28 04:00:00	MSFT	Stock	287.06	288.01	286.7	287.75	19885.0
2022-04-28 04:30:00	MSFT	Stock	287.71	288.2	287.49	288.2	3137.0
2022-04-28 05:00:00	MSFT	Stock	288.0	288.02	287.6	287.65	1563.0
2022-04-28 05:30:00	MSFT	Stock	287.42	287.42	287.4	287.4	246.0
2022-04-28 06:00:00	MSFT	Stock	287.5	287.5	287.03	287.06	800.0
2022-04-28 06:30:00	MSFT	Stock	287.1	287.54	287.03	287.16	2260.0
2022-04-28 07:00:00	MSFT	Stock	287.0	288.25	287.0	287.95	20158.0
2022-04-28 07:30:00	MSFT	Stock	287.8	287.86	287.0	287.0	12823.0
2022-04-28 08:00:00	MSFT	Stock	287.5	288.2977	286.0	286.59	41490.0
2022-04-28 08:30:00	MSFT	Stock	286.54	287.8	284.8001	285.64	80883.0
2022-04-28 09:00:00	MSFT	Stock	285.85	286.6	284.54	285.0	35505.0
2022-04-28 09:30:00	MSFT	Stock	285.185	287.61	281.4562	282.86	2917062.0
2022-04-28 10:00:00	MSFT	Stock	282.79	285.75	281.7001	283.36	2078757.0
2022-04-28 10:30:00	MSFT	Stock	283.33	284.38	282.47	282.985	1587048.0
2022-04-28 11:00:00	MSFT	Stock	282.99	284.975	282.41	284.29	1257295.0
2022-04-28 11:30:00	MSFT	Stock	284.36	285.61	283.055	283.595	1051699.0
2022-04-28 12:00:00	MSFT	Stock	283.59	286.03	282.92	286.0	963513.0
2022-04-28 12:30:00	MSFT	Stock	286.0	288.09	285.89	288.0715	1161544.0

> showing 50 of 108,495 rows — these rows as CSV

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