PREVIEW / stock_30min / 2007-08-01

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-01.parquet
  size:    1.2 MB
  rows:    67,583
  symbols: 3,100

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-08-01 09:30:00	AAPL	Stock	4.7729	4.7732	4.5632	4.6161	318072328.0
2007-08-01 10:00:00	AAPL	Stock	4.6168	4.7179	4.5979	4.6461	189178164.0
2007-08-01 10:30:00	AAPL	Stock	4.6414	4.6825	4.6207	4.6396	110260864.0
2007-08-01 11:00:00	AAPL	Stock	4.6396	4.7089	4.6214	4.6732	102356940.0
2007-08-01 11:30:00	AAPL	Stock	4.6739	4.7854	4.6739	4.7839	137946368.0
2007-08-01 12:00:00	AAPL	Stock	4.7846	4.835	4.7557	4.8193	140868252.0
2007-08-01 12:30:00	AAPL	Stock	4.8196	4.8268	4.7557	4.7596	82377820.0
2007-08-01 13:00:00	AAPL	Stock	4.7593	4.7604	4.7143	4.7361	91168868.0
2007-08-01 13:30:00	AAPL	Stock	4.735	4.7643	4.7304	4.75	70801584.0
2007-08-01 14:00:00	AAPL	Stock	4.7493	4.7918	4.7461	4.7811	86120972.0
2007-08-01 14:30:00	AAPL	Stock	4.7814	4.815	4.7404	4.7668	93732352.0
2007-08-01 15:00:00	AAPL	Stock	4.7664	4.7786	4.7154	4.7629	85142932.0
2007-08-01 15:30:00	AAPL	Stock	4.7625	4.83	4.7482	4.8243	107447704.0
2007-08-01 16:00:00	AAPL	Stock	4.8304	4.8304	4.8214	4.8214	9841748.0
2007-08-01 09:30:00	MSFT	Stock	28.95	29.5	28.95	29.31	7501141.0
2007-08-01 10:00:00	MSFT	Stock	29.31	29.55	28.98	29.42	7220264.0
2007-08-01 10:30:00	MSFT	Stock	29.43	29.53	29.1	29.11	5609923.0
2007-08-01 11:00:00	MSFT	Stock	29.11	29.2	29.05	29.07	6158299.0
2007-08-01 11:30:00	MSFT	Stock	29.08	29.21	29.07	29.163	4602499.0
2007-08-01 12:00:00	MSFT	Stock	29.17	29.25	29.12	29.18	3449105.0
2007-08-01 12:30:00	MSFT	Stock	29.18	29.2	29.13	29.18	3322497.0
2007-08-01 13:00:00	MSFT	Stock	29.17	29.18	29.01	29.1	3184778.0
2007-08-01 13:30:00	MSFT	Stock	29.1	29.17	29.04	29.13	3717518.0
2007-08-01 14:00:00	MSFT	Stock	29.13	29.18	29.08	29.12	3664853.0
2007-08-01 14:30:00	MSFT	Stock	29.13	29.15	28.87	28.94	4771559.0
2007-08-01 15:00:00	MSFT	Stock	28.94	29.01	28.82	29.01	5493195.0
2007-08-01 15:30:00	MSFT	Stock	29.01	29.34	28.83	29.34	11185028.0
2007-08-01 16:00:00	MSFT	Stock	29.31	29.34	29.3	29.3	1752292.0
2007-08-01 08:00:00	NVDA	Stock	0.762	0.7642	0.7522	0.753	257160.0
2007-08-01 08:30:00	NVDA	Stock	0.753	0.7565	0.753	0.7565	124800.0
2007-08-01 09:00:00	NVDA	Stock	0.7565	0.7565	0.752	0.7527	1537140.0
2007-08-01 09:30:00	NVDA	Stock	0.7517	0.7702	0.7495	0.7532	62000460.0
2007-08-01 10:00:00	NVDA	Stock	0.7533	0.7583	0.747	0.7478	64126680.0
2007-08-01 10:30:00	NVDA	Stock	0.748	0.7507	0.7253	0.7277	91419060.0
2007-08-01 11:00:00	NVDA	Stock	0.7273	0.7347	0.7217	0.7323	77067300.0
2007-08-01 11:30:00	NVDA	Stock	0.732	0.745	0.7313	0.7448	40904040.0
2007-08-01 12:00:00	NVDA	Stock	0.745	0.7532	0.7418	0.7507	42922920.0
2007-08-01 12:30:00	NVDA	Stock	0.7507	0.7527	0.7407	0.7425	28035180.0
2007-08-01 13:00:00	NVDA	Stock	0.7425	0.7425	0.733	0.7378	34728480.0
2007-08-01 13:30:00	NVDA	Stock	0.738	0.7472	0.738	0.746	31422300.0
2007-08-01 14:00:00	NVDA	Stock	0.7463	0.7483	0.7432	0.7465	37243260.0
2007-08-01 14:30:00	NVDA	Stock	0.7463	0.7502	0.7363	0.7398	38461080.0
2007-08-01 15:00:00	NVDA	Stock	0.7393	0.7427	0.7317	0.738	44948280.0
2007-08-01 15:30:00	NVDA	Stock	0.738	0.7597	0.7358	0.7595	69161940.0
2007-08-01 16:00:00	NVDA	Stock	0.7595	0.76	0.7567	0.7567	13652640.0
2007-08-01 16:30:00	NVDA	Stock	0.7565	0.7565	0.7535	0.7535	372000.0
2007-08-01 17:00:00	NVDA	Stock	0.7535	0.7535	0.7535	0.7535	18000.0
2007-08-01 19:30:00	NVDA	Stock	0.7582	0.7582	0.7582	0.7582	12000.0
2007-08-01 04:30:00	AMZN	Stock	3.9025	3.9025	3.9	3.9	4000.0
2007-08-01 06:00:00	AMZN	Stock	3.87	3.87	3.8625	3.8625	19000.0

> showing 50 of 67,583 rows — these rows as CSV

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