PREVIEW / stock_30min / 2007-03-26

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-26.parquet
  size:    1.0 MB
  rows:    56,652
  symbols: 2,565

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
2007-03-26 07:00:00	AAPL	Stock	3.3482	3.3482	3.3446	3.3446	5600.0
2007-03-26 07:30:00	AAPL	Stock	3.3496	3.4486	3.3496	3.3746	463400.0
2007-03-26 08:00:00	AAPL	Stock	3.3732	3.3732	3.3536	3.3604	1400812.0
2007-03-26 08:30:00	AAPL	Stock	3.3604	3.3696	3.3604	3.3643	1541400.0
2007-03-26 09:00:00	AAPL	Stock	3.3629	3.3654	3.355	3.3564	1357188.0
2007-03-26 09:30:00	AAPL	Stock	3.3568	3.3857	3.3489	3.375	112803684.0
2007-03-26 10:00:00	AAPL	Stock	3.375	3.375	3.3321	3.3396	113062040.0
2007-03-26 10:30:00	AAPL	Stock	3.34	3.3646	3.3375	3.3507	60876508.0
2007-03-26 11:00:00	AAPL	Stock	3.3511	3.3625	3.3461	3.36	44123100.0
2007-03-26 11:30:00	AAPL	Stock	3.3604	3.3696	3.3582	3.3696	49630168.0
2007-03-26 12:00:00	AAPL	Stock	3.369	3.3839	3.3671	3.3825	46010468.0
2007-03-26 12:30:00	AAPL	Stock	3.3825	3.385	3.3793	3.3811	38383492.0
2007-03-26 13:00:00	AAPL	Stock	3.3811	3.3843	3.3761	3.3843	31016188.0
2007-03-26 13:30:00	AAPL	Stock	3.3843	3.3929	3.3839	3.3925	55309520.0
2007-03-26 14:00:00	AAPL	Stock	3.3925	3.4071	3.3907	3.4032	78325492.0
2007-03-26 14:30:00	AAPL	Stock	3.4032	3.4096	3.3982	3.4096	39058096.0
2007-03-26 15:00:00	AAPL	Stock	3.4096	3.42	3.4089	3.4154	72645328.0
2007-03-26 15:30:00	AAPL	Stock	3.4157	3.425	3.4107	3.425	97455820.0
2007-03-26 16:00:00	AAPL	Stock	3.425	3.4268	3.3918	3.4243	6325648.0
2007-03-26 16:30:00	AAPL	Stock	3.4243	3.425	3.4204	3.425	699244.0
2007-03-26 17:00:00	AAPL	Stock	3.4246	3.4246	3.3678	3.4218	5566148.0
2007-03-26 17:30:00	AAPL	Stock	3.4232	3.425	3.4221	3.4232	139300.0
2007-03-26 18:00:00	AAPL	Stock	3.4246	3.4246	3.4218	3.4218	96544.0
2007-03-26 18:30:00	AAPL	Stock	3.4236	3.425	3.4221	3.425	118468.0
2007-03-26 19:00:00	AAPL	Stock	3.4246	3.425	3.4246	3.425	67200.0
2007-03-26 19:30:00	AAPL	Stock	3.4246	3.4246	3.4229	3.4232	418600.0
2007-03-26 07:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	1700.0
2007-03-26 07:30:00	MSFT	Stock	28.03	28.03	28.03	28.03	951.0
2007-03-26 08:00:00	MSFT	Stock	28.0	28.02	28.0	28.0	2980.0
2007-03-26 08:30:00	MSFT	Stock	27.98	27.99	27.98	27.99	1995.0
2007-03-26 09:00:00	MSFT	Stock	28.02	28.02	27.91	27.95	43690.0
2007-03-26 09:30:00	MSFT	Stock	27.94	27.99	27.85	27.922	3191522.0
2007-03-26 10:00:00	MSFT	Stock	27.92	27.92	27.7	27.76	5985963.0
2007-03-26 10:30:00	MSFT	Stock	27.76	27.92	27.75	27.78	2990195.0
2007-03-26 11:00:00	MSFT	Stock	27.78	27.82	27.7	27.77	2820966.0
2007-03-26 11:30:00	MSFT	Stock	27.77	27.8	27.72	27.749	2089964.0
2007-03-26 12:00:00	MSFT	Stock	27.75	27.8	27.73	27.79	1377274.0
2007-03-26 12:30:00	MSFT	Stock	27.79	27.82	27.74	27.74	2217205.0
2007-03-26 13:00:00	MSFT	Stock	27.74	27.76	27.72	27.76	1138787.0
2007-03-26 13:30:00	MSFT	Stock	27.76	27.87	27.75	27.86	3444549.0
2007-03-26 14:00:00	MSFT	Stock	27.86	28.03	27.85	28.03	3104695.0
2007-03-26 14:30:00	MSFT	Stock	28.03	28.06	27.99	28.04	2396437.0
2007-03-26 15:00:00	MSFT	Stock	28.05	28.14	28.04	28.13	4160582.0
2007-03-26 15:30:00	MSFT	Stock	28.13	28.22	28.08	28.22	7850699.0
2007-03-26 16:00:00	MSFT	Stock	28.22	28.23	27.82	28.21	1818212.0
2007-03-26 16:30:00	MSFT	Stock	28.22	28.22	28.1	28.15	816386.0
2007-03-26 17:00:00	MSFT	Stock	28.22	28.22	27.72	28.09	252273.0
2007-03-26 17:30:00	MSFT	Stock	28.15	28.22	28.15	28.22	72040.0
2007-03-26 18:00:00	MSFT	Stock	28.19	28.21	28.19	28.21	2900.0
2007-03-26 19:00:00	MSFT	Stock	28.15	28.15	28.15	28.15	100.0

> showing 50 of 56,652 rows — these rows as CSV

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