PREVIEW / stock_30min / 2007-01-26

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-26.parquet
  size:    955 KB
  rows:    51,911
  symbols: 2,496

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-01-26 07:30:00	AAPL	Stock	3.0879	3.0989	3.0879	3.0989	78400.0
2007-01-26 08:00:00	AAPL	Stock	3.1004	3.1018	3.0921	3.0979	977536.0
2007-01-26 08:30:00	AAPL	Stock	3.0957	3.1111	3.0939	3.1093	2809128.0
2007-01-26 09:00:00	AAPL	Stock	3.1093	3.1118	3.1	3.1114	1663368.0
2007-01-26 09:30:00	AAPL	Stock	3.1112	3.1204	3.0629	3.0679	144218452.0
2007-01-26 10:00:00	AAPL	Stock	3.0671	3.1093	3.0454	3.0857	162178464.0
2007-01-26 10:30:00	AAPL	Stock	3.0857	3.0929	3.0682	3.0735	82829684.0
2007-01-26 11:00:00	AAPL	Stock	3.0732	3.0764	3.0625	3.0707	55766284.0
2007-01-26 11:30:00	AAPL	Stock	3.0707	3.0729	3.0536	3.0604	56981316.0
2007-01-26 12:00:00	AAPL	Stock	3.06	3.0714	3.0582	3.06	50317484.0
2007-01-26 12:30:00	AAPL	Stock	3.06	3.0643	3.0486	3.0518	50119888.0
2007-01-26 13:00:00	AAPL	Stock	3.0518	3.0568	3.0354	3.0425	86103192.0
2007-01-26 13:30:00	AAPL	Stock	3.0421	3.0564	3.0418	3.0529	48252344.0
2007-01-26 14:00:00	AAPL	Stock	3.0529	3.0568	3.0393	3.0518	60901876.0
2007-01-26 14:30:00	AAPL	Stock	3.0521	3.0621	3.0479	3.0611	39823308.0
2007-01-26 15:00:00	AAPL	Stock	3.0614	3.0743	3.0589	3.0632	66602620.0
2007-01-26 15:30:00	AAPL	Stock	3.0632	3.065	3.0493	3.0493	65426116.0
2007-01-26 16:00:00	AAPL	Stock	3.0507	3.0514	3.0446	3.0482	1878212.0
2007-01-26 16:30:00	AAPL	Stock	3.0482	3.0493	3.0468	3.0479	293132.0
2007-01-26 17:00:00	AAPL	Stock	3.0479	3.0493	3.0479	3.0493	106708.0
2007-01-26 17:30:00	AAPL	Stock	3.0486	3.0486	3.0457	3.0461	390740.0
2007-01-26 18:00:00	AAPL	Stock	3.0454	3.0475	3.045	3.0475	67200.0
2007-01-26 18:30:00	AAPL	Stock	3.0464	3.0475	3.0464	3.0471	58716.0
2007-01-26 19:00:00	AAPL	Stock	3.0464	3.0471	3.0464	3.0468	68880.0
2007-01-26 19:30:00	AAPL	Stock	3.0471	3.0482	3.0471	3.0482	76860.0
2007-01-26 05:30:00	MSFT	Stock	31.0	31.0	31.0	31.0	800.0
2007-01-26 06:30:00	MSFT	Stock	31.03	31.03	31.03	31.03	100.0
2007-01-26 07:00:00	MSFT	Stock	31.06	31.06	31.05	31.05	3700.0
2007-01-26 07:30:00	MSFT	Stock	31.06	31.06	30.98	31.0	38600.0
2007-01-26 08:00:00	MSFT	Stock	31.04	31.2	30.95	31.04	214565.0
2007-01-26 08:30:00	MSFT	Stock	31.05	31.06	30.78	31.02	249341.0
2007-01-26 09:00:00	MSFT	Stock	31.01	31.23	30.98	31.22	543317.0
2007-01-26 09:30:00	MSFT	Stock	31.22	31.23	30.69	30.84	17148886.0
2007-01-26 10:00:00	MSFT	Stock	30.84	31.19	30.67	30.8	11207894.0
2007-01-26 10:30:00	MSFT	Stock	30.79	30.89	30.75	30.82	8714044.0
2007-01-26 11:00:00	MSFT	Stock	30.82	31.03	30.79	31.0	9898536.0
2007-01-26 11:30:00	MSFT	Stock	30.99	31.16	30.95	31.072	7233721.0
2007-01-26 12:00:00	MSFT	Stock	31.07	31.16	31.05	31.06	4109159.0
2007-01-26 12:30:00	MSFT	Stock	31.06	31.06	30.91	30.92	3470419.0
2007-01-26 13:00:00	MSFT	Stock	30.922	30.95	30.72	30.73	5037906.0
2007-01-26 13:30:00	MSFT	Stock	30.73	30.91	30.72	30.9	3818274.0
2007-01-26 14:00:00	MSFT	Stock	30.9	31.0	30.81	30.95	4100735.0
2007-01-26 14:30:00	MSFT	Stock	30.95	31.22	30.84	30.88	3187261.0
2007-01-26 15:00:00	MSFT	Stock	30.88	30.91	30.84	30.87	4387775.0
2007-01-26 15:30:00	MSFT	Stock	30.877	30.9	30.6	30.6	9446705.0
2007-01-26 16:00:00	MSFT	Stock	30.62	31.02	30.58	30.62	1539843.0
2007-01-26 16:30:00	MSFT	Stock	30.62	30.64	30.61	30.64	14198.0
2007-01-26 17:00:00	MSFT	Stock	30.63	30.64	30.63	30.63	8900.0
2007-01-26 17:30:00	MSFT	Stock	30.63	30.65	30.62	30.64	3969.0
2007-01-26 18:00:00	MSFT	Stock	30.63	30.63	30.61	30.63	12746.0

> showing 50 of 51,911 rows — these rows as CSV

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