PREVIEW / stock_30min / 2023-10-03

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-03.parquet
  size:    2.0 MB
  rows:    97,956
  symbols: 1,400

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
2023-10-03 04:00:00	AAPL	Stock	173.23	173.87	173.23	173.85	15947.0
2023-10-03 04:30:00	AAPL	Stock	173.86	173.87	173.65	173.8	4262.0
2023-10-03 05:00:00	AAPL	Stock	173.67	173.67	173.36	173.64	4198.0
2023-10-03 05:30:00	AAPL	Stock	173.36	173.41	173.23	173.34	1387.0
2023-10-03 06:00:00	AAPL	Stock	173.42	173.5	173.4	173.5	890.0
2023-10-03 06:30:00	AAPL	Stock	173.69	173.69	173.3	173.3	3701.0
2023-10-03 07:00:00	AAPL	Stock	173.33	173.37	172.63	172.75	38970.0
2023-10-03 07:30:00	AAPL	Stock	172.75	172.89	172.36	172.75	16570.0
2023-10-03 08:00:00	AAPL	Stock	173.34	173.76	172.4	172.77	76140.0
2023-10-03 08:30:00	AAPL	Stock	172.638	172.73	172.03	172.15	56630.0
2023-10-03 09:00:00	AAPL	Stock	172.15	172.5	170.6365	172.21	107332.0
2023-10-03 09:30:00	AAPL	Stock	172.29	173.63	172.21	173.27	4763568.0
2023-10-03 10:00:00	AAPL	Stock	173.27	173.3	170.82	171.1718	4951387.0
2023-10-03 10:30:00	AAPL	Stock	171.18	171.9	171.07	171.51	2987432.0
2023-10-03 11:00:00	AAPL	Stock	171.5	171.985	171.39	171.64	2820518.0
2023-10-03 11:30:00	AAPL	Stock	171.63	171.84	171.36	171.75	1762994.0
2023-10-03 12:00:00	AAPL	Stock	171.7482	172.365	171.69	172.264	2060134.0
2023-10-03 12:30:00	AAPL	Stock	172.28	172.69	172.24	172.56	2241997.0
2023-10-03 13:00:00	AAPL	Stock	172.55	172.805	171.9649	172.0018	1993998.0
2023-10-03 13:30:00	AAPL	Stock	172.01	172.0948	171.75	171.97	1485085.0
2023-10-03 14:00:00	AAPL	Stock	171.97	172.13	171.551	171.85	1821699.0
2023-10-03 14:30:00	AAPL	Stock	171.85	172.4	171.815	172.27	1844111.0
2023-10-03 15:00:00	AAPL	Stock	172.26	172.3	171.79	171.86	2427837.0
2023-10-03 15:30:00	AAPL	Stock	171.855	172.52	171.78	172.46	5522711.0
2023-10-03 16:00:00	AAPL	Stock	172.47	172.55	172.32	172.36	5440890.0
2023-10-03 16:30:00	AAPL	Stock	172.33	172.4	172.09	172.13	78676.0
2023-10-03 17:00:00	AAPL	Stock	172.13	172.2078	172.04	172.06	22053.0
2023-10-03 17:30:00	AAPL	Stock	172.0599	172.06	172.0	172.05	16317.0
2023-10-03 18:00:00	AAPL	Stock	172.05	172.19	171.94	171.95	28073.0
2023-10-03 18:30:00	AAPL	Stock	171.97	172.16	171.97	172.08	2709.0
2023-10-03 19:00:00	AAPL	Stock	172.01	172.01	171.02	171.25	83332.0
2023-10-03 19:30:00	AAPL	Stock	171.25	171.5	170.85	170.88	73124.0
2023-10-03 04:00:00	MSFT	Stock	321.5	322.4	321.5	322.0	700.0
2023-10-03 04:30:00	MSFT	Stock	322.16	322.16	322.1	322.1	300.0
2023-10-03 05:30:00	MSFT	Stock	321.1	321.6	321.1	321.6	557.0
2023-10-03 06:00:00	MSFT	Stock	321.6	321.8	321.44	321.8	1155.0
2023-10-03 06:30:00	MSFT	Stock	321.55	321.55	321.55	321.55	959.0
2023-10-03 07:00:00	MSFT	Stock	321.25	321.25	319.79	319.79	7568.0
2023-10-03 07:30:00	MSFT	Stock	320.06	320.25	319.07	319.6	6303.0
2023-10-03 08:00:00	MSFT	Stock	321.15	321.44	319.05	319.55	19306.0
2023-10-03 08:30:00	MSFT	Stock	319.5	319.67	318.3026	319.09	17579.0
2023-10-03 09:00:00	MSFT	Stock	319.07	320.94	318.77	320.94	25891.0
2023-10-03 09:30:00	MSFT	Stock	320.83	321.39	319.15	320.66	1268699.0
2023-10-03 10:00:00	MSFT	Stock	320.645	320.73	315.65	315.69	1333017.0
2023-10-03 10:30:00	MSFT	Stock	315.7	316.4995	314.21	314.36	1019751.0
2023-10-03 11:00:00	MSFT	Stock	314.34	314.74	313.08	313.9328	1177229.0
2023-10-03 11:30:00	MSFT	Stock	313.9	314.665	313.63	314.3	1045084.0
2023-10-03 12:00:00	MSFT	Stock	314.32	314.5563	313.5	313.7448	618731.0
2023-10-03 12:30:00	MSFT	Stock	313.77	314.1	313.18	313.7	656761.0
2023-10-03 13:00:00	MSFT	Stock	313.71	314.21	312.53	312.75	569282.0

> showing 50 of 97,956 rows — these rows as CSV

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