PREVIEW / stock_30min / 2005-06-20

all stock 30-min files

  file:    by_date/stock_30min/2005/2005-06-20.parquet
  size:    824 KB
  rows:    44,611
  symbols: 1,987

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
2005-06-20 08:00:00	AAPL	Stock	1.3571	1.3571	1.3393	1.3493	729428.0
2005-06-20 08:30:00	AAPL	Stock	1.3493	1.3525	1.3482	1.35	346752.0
2005-06-20 09:00:00	AAPL	Stock	1.35	1.3536	1.35	1.3525	899920.0
2005-06-20 09:30:00	AAPL	Stock	1.3518	1.3604	1.3482	1.3496	48421128.0
2005-06-20 10:00:00	AAPL	Stock	1.3496	1.3521	1.3375	1.3418	49911120.0
2005-06-20 10:30:00	AAPL	Stock	1.3418	1.3461	1.34	1.3429	25926180.0
2005-06-20 11:00:00	AAPL	Stock	1.3425	1.3464	1.3411	1.3454	19131168.0
2005-06-20 11:30:00	AAPL	Stock	1.345	1.3464	1.3411	1.3461	15773800.0
2005-06-20 12:00:00	AAPL	Stock	1.3461	1.3518	1.3432	1.3453	15376144.0
2005-06-20 12:30:00	AAPL	Stock	1.3454	1.3464	1.3432	1.3435	10209724.0
2005-06-20 13:00:00	AAPL	Stock	1.3432	1.3446	1.3411	1.3418	12330388.0
2005-06-20 13:30:00	AAPL	Stock	1.3421	1.3439	1.3407	1.3425	12309164.0
2005-06-20 14:00:00	AAPL	Stock	1.3429	1.3521	1.3404	1.3446	10562636.0
2005-06-20 14:30:00	AAPL	Stock	1.3446	1.3518	1.3436	1.3482	27658512.0
2005-06-20 15:00:00	AAPL	Stock	1.3482	1.3543	1.3471	1.3525	28316400.0
2005-06-20 15:30:00	AAPL	Stock	1.3525	1.3529	1.3432	1.3432	31291988.0
2005-06-20 16:00:00	AAPL	Stock	1.3439	1.3554	1.3432	1.3489	11216492.0
2005-06-20 16:30:00	AAPL	Stock	1.3486	1.35	1.3432	1.3464	462924.0
2005-06-20 17:00:00	AAPL	Stock	1.3454	1.3464	1.3454	1.3464	11200.0
2005-06-20 18:00:00	AAPL	Stock	1.3471	1.3471	1.3439	1.3464	131964.0
2005-06-20 07:30:00	MSFT	Stock	25.04	25.04	25.04	25.04	400.0
2005-06-20 08:00:00	MSFT	Stock	25.0	25.0	24.96	24.96	5455.0
2005-06-20 08:30:00	MSFT	Stock	24.96	24.99	24.96	24.99	5442.0
2005-06-20 09:00:00	MSFT	Stock	24.99	25.07	24.94	24.97	165118.0
2005-06-20 09:30:00	MSFT	Stock	24.98	25.1	24.93	25.1	5300831.0
2005-06-20 10:00:00	MSFT	Stock	25.1	25.13	25.03	25.05	3946188.0
2005-06-20 10:30:00	MSFT	Stock	25.05	25.13	25.03	25.08	3250992.0
2005-06-20 11:00:00	MSFT	Stock	25.08	25.13	25.06	25.06	3347568.0
2005-06-20 11:30:00	MSFT	Stock	25.07	25.2	25.06	25.192	4514653.0
2005-06-20 12:00:00	MSFT	Stock	25.19	25.23	25.13	25.14	2884852.0
2005-06-20 12:30:00	MSFT	Stock	25.14	25.16	25.1	25.102	1212125.0
2005-06-20 13:00:00	MSFT	Stock	25.1	25.11	25.07	25.08	1343179.0
2005-06-20 13:30:00	MSFT	Stock	25.08	25.14	25.06	25.11	2254935.0
2005-06-20 14:00:00	MSFT	Stock	25.12	25.15	25.04	25.141	2462730.0
2005-06-20 14:30:00	MSFT	Stock	25.15	25.24	25.13	25.22	3666853.0
2005-06-20 15:00:00	MSFT	Stock	25.22	25.28	25.14	25.22	4567155.0
2005-06-20 15:30:00	MSFT	Stock	25.22	25.23	25.11	25.11	7567143.0
2005-06-20 16:00:00	MSFT	Stock	25.11	25.26	25.1	25.16	522510.0
2005-06-20 16:30:00	MSFT	Stock	25.12	25.12	25.08	25.11	259390.0
2005-06-20 17:00:00	MSFT	Stock	25.11	25.11	25.11	25.11	191500.0
2005-06-20 17:30:00	MSFT	Stock	25.13	25.15	25.1	25.1	20867.0
2005-06-20 18:00:00	MSFT	Stock	25.1	25.11	25.05	25.07	12635.0
2005-06-20 08:00:00	NVDA	Stock	0.2237	0.2237	0.2237	0.2237	22320.0
2005-06-20 09:00:00	NVDA	Stock	0.2234	0.2246	0.2234	0.2246	431760.0
2005-06-20 09:30:00	NVDA	Stock	0.2242	0.2246	0.2208	0.2212	55726320.0
2005-06-20 10:00:00	NVDA	Stock	0.2214	0.2221	0.2206	0.2218	35673480.0
2005-06-20 10:30:00	NVDA	Stock	0.2217	0.2237	0.2217	0.2233	25886520.0
2005-06-20 11:00:00	NVDA	Stock	0.2234	0.2248	0.2232	0.2246	31645320.0
2005-06-20 11:30:00	NVDA	Stock	0.2245	0.2259	0.2242	0.2256	32965680.0
2005-06-20 12:00:00	NVDA	Stock	0.2256	0.2262	0.225	0.2257	44989200.0

> showing 50 of 44,611 rows — these rows as CSV

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