PREVIEW / stock_30min / 2021-07-28

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-28.parquet
  size:    2.2 MB
  rows:    108,051
  symbols: 2,813

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
2021-07-28 04:00:00	AAPL	Stock	144.54	145.53	144.4	145.4	96437.0
2021-07-28 04:30:00	AAPL	Stock	145.4	145.76	145.22	145.6	35069.0
2021-07-28 05:00:00	AAPL	Stock	145.68	145.88	145.03	145.34	40949.0
2021-07-28 05:30:00	AAPL	Stock	145.34	145.34	145.1	145.33	20975.0
2021-07-28 06:00:00	AAPL	Stock	145.31	145.32	144.57	144.75	35044.0
2021-07-28 06:30:00	AAPL	Stock	144.81	145.18	144.81	145.09	30304.0
2021-07-28 07:00:00	AAPL	Stock	144.92	146.0	144.32	145.17	291021.0
2021-07-28 07:30:00	AAPL	Stock	145.17	145.47	144.85	145.3	266893.0
2021-07-28 08:00:00	AAPL	Stock	145.33	146.02	144.28	145.97	784711.0
2021-07-28 08:30:00	AAPL	Stock	145.99	146.34	145.2	145.33	512022.0
2021-07-28 09:00:00	AAPL	Stock	145.33	146.7384	144.83	144.84	540004.0
2021-07-28 09:30:00	AAPL	Stock	144.82	144.86	142.54	144.5601	20521696.0
2021-07-28 10:00:00	AAPL	Stock	144.57	146.97	144.415	146.3799	12997832.0
2021-07-28 10:30:00	AAPL	Stock	146.38	146.7799	145.63	146.28	7282292.0
2021-07-28 11:00:00	AAPL	Stock	146.28	146.49	145.3202	145.34	4635499.0
2021-07-28 11:30:00	AAPL	Stock	145.3301	145.5211	144.42	144.755	6184153.0
2021-07-28 12:00:00	AAPL	Stock	144.76	145.37	144.62	145.32	4749612.0
2021-07-28 12:30:00	AAPL	Stock	145.33	145.44	144.69	144.895	3130016.0
2021-07-28 13:00:00	AAPL	Stock	144.91	145.0	143.93	144.2401	4128426.0
2021-07-28 13:30:00	AAPL	Stock	144.245	144.64	143.88	144.48	3518589.0
2021-07-28 14:00:00	AAPL	Stock	144.4999	145.3	143.94	145.0	5300479.0
2021-07-28 14:30:00	AAPL	Stock	145.0	145.44	144.4201	145.025	4791235.0
2021-07-28 15:00:00	AAPL	Stock	145.03	145.5099	144.91	145.3867	4079408.0
2021-07-28 15:30:00	AAPL	Stock	145.38	145.49	144.95	144.98	6102916.0
2021-07-28 16:00:00	AAPL	Stock	144.98	146.0	144.89	145.24	3834177.0
2021-07-28 16:30:00	AAPL	Stock	145.15	145.355	145.1	145.2	71058.0
2021-07-28 17:00:00	AAPL	Stock	145.2	145.26	145.02	145.18	38422.0
2021-07-28 17:30:00	AAPL	Stock	145.16	145.17	144.98	145.08	47912.0
2021-07-28 18:00:00	AAPL	Stock	145.1	145.29	145.08	145.2	33933.0
2021-07-28 18:30:00	AAPL	Stock	145.15	145.19	145.05	145.07	13627.0
2021-07-28 19:00:00	AAPL	Stock	145.08	145.11	145.0	145.1	23427.0
2021-07-28 19:30:00	AAPL	Stock	145.1099	145.15	145.05	145.14	29768.0
2021-07-28 04:00:00	MSFT	Stock	289.05	289.05	288.5	288.7	4292.0
2021-07-28 04:30:00	MSFT	Stock	288.8	288.85	288.0	288.0	4983.0
2021-07-28 05:00:00	MSFT	Stock	287.81	288.0	287.3	287.32	5034.0
2021-07-28 05:30:00	MSFT	Stock	287.55	287.8	287.53	287.79	2858.0
2021-07-28 06:00:00	MSFT	Stock	287.8	288.27	287.5	287.52	8068.0
2021-07-28 06:30:00	MSFT	Stock	287.52	288.13	287.02	287.75	8272.0
2021-07-28 07:00:00	MSFT	Stock	287.75	290.75	287.4	290.21	83595.0
2021-07-28 07:30:00	MSFT	Stock	290.24	291.4	289.31	290.1	225797.0
2021-07-28 08:00:00	MSFT	Stock	290.1	291.37	287.5101	291.2	219704.0
2021-07-28 08:30:00	MSFT	Stock	291.35	291.85	290.0	290.18	153781.0
2021-07-28 09:00:00	MSFT	Stock	290.1	290.55	288.78	288.85	158834.0
2021-07-28 09:30:00	MSFT	Stock	288.99	290.0	283.8303	287.825	6037871.0
2021-07-28 10:00:00	MSFT	Stock	287.8	289.805	286.8	289.43	2634408.0
2021-07-28 10:30:00	MSFT	Stock	289.4	290.15	287.77	288.93	2323469.0
2021-07-28 11:00:00	MSFT	Stock	288.93	289.37	287.85	287.92	1027111.0
2021-07-28 11:30:00	MSFT	Stock	287.91	288.45	286.875	287.4812	1271333.0
2021-07-28 12:00:00	MSFT	Stock	287.4801	287.68	286.91	287.0956	1070665.0
2021-07-28 12:30:00	MSFT	Stock	287.105	287.32	286.35	286.73	1010618.0

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

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