PREVIEW / stock_30min / 2007-01-10

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-10.parquet
  size:    976 KB
  rows:    53,022
  symbols: 2,483

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-10 04:30:00	AAPL	Stock	3.3018	3.3018	3.3018	3.3018	14000.0
2007-01-10 05:00:00	AAPL	Stock	3.2975	3.2975	3.2968	3.2968	25480.0
2007-01-10 05:30:00	AAPL	Stock	3.2975	3.2979	3.2971	3.2971	34860.0
2007-01-10 06:00:00	AAPL	Stock	3.2982	3.2993	3.2982	3.2989	11620.0
2007-01-10 06:30:00	AAPL	Stock	3.3	3.3211	3.3	3.3071	664104.0
2007-01-10 07:00:00	AAPL	Stock	3.3143	3.3468	3.3143	3.3414	3364200.0
2007-01-10 07:30:00	AAPL	Stock	3.3429	3.3429	3.3182	3.3304	4634308.0
2007-01-10 08:00:00	AAPL	Stock	3.3268	3.3636	3.3179	3.3586	25588528.0
2007-01-10 08:30:00	AAPL	Stock	3.3586	3.3664	3.3518	3.365	25450404.0
2007-01-10 09:00:00	AAPL	Stock	3.365	3.3839	3.3618	3.3839	44852276.0
2007-01-10 09:30:00	AAPL	Stock	3.3839	3.3943	3.3375	3.3871	476016380.0
2007-01-10 10:00:00	AAPL	Stock	3.3875	3.4061	3.3764	3.4035	284211788.0
2007-01-10 10:30:00	AAPL	Stock	3.4032	3.4446	3.4	3.4343	276507756.0
2007-01-10 11:00:00	AAPL	Stock	3.4345	3.4871	3.4321	3.4643	322320516.0
2007-01-10 11:30:00	AAPL	Stock	3.4646	3.4929	3.4536	3.4746	198223144.0
2007-01-10 12:00:00	AAPL	Stock	3.4746	3.4911	3.4643	3.4696	134426572.0
2007-01-10 12:30:00	AAPL	Stock	3.4696	3.4829	3.4632	3.4679	129050096.0
2007-01-10 13:00:00	AAPL	Stock	3.4679	3.4711	3.4339	3.4518	177708188.0
2007-01-10 13:30:00	AAPL	Stock	3.4518	3.4643	3.4179	3.4225	135782444.0
2007-01-10 14:00:00	AAPL	Stock	3.4225	3.4475	3.4204	3.4357	136107608.0
2007-01-10 14:30:00	AAPL	Stock	3.4357	3.4611	3.4286	3.4414	140959112.0
2007-01-10 15:00:00	AAPL	Stock	3.4411	3.455	3.4325	3.4396	123721332.0
2007-01-10 15:30:00	AAPL	Stock	3.4393	3.47	3.4329	3.4696	226495080.0
2007-01-10 16:00:00	AAPL	Stock	3.4696	3.4696	3.3907	3.4682	10637396.0
2007-01-10 16:30:00	AAPL	Stock	3.4679	3.4732	3.4671	3.4732	1851304.0
2007-01-10 17:00:00	AAPL	Stock	3.4732	3.4739	3.4643	3.4707	50265992.0
2007-01-10 17:30:00	AAPL	Stock	3.4707	3.475	3.4161	3.4393	8279068.0
2007-01-10 18:00:00	AAPL	Stock	3.4382	3.4539	3.4361	3.4429	3185672.0
2007-01-10 18:30:00	AAPL	Stock	3.4425	3.455	3.4411	3.4432	1568644.0
2007-01-10 19:00:00	AAPL	Stock	3.4432	3.4482	3.4382	3.4411	1504888.0
2007-01-10 19:30:00	AAPL	Stock	3.4414	3.45	3.4414	3.45	1098748.0
2007-01-10 05:30:00	MSFT	Stock	29.74	29.74	29.74	29.74	100.0
2007-01-10 06:30:00	MSFT	Stock	29.83	29.83	29.83	29.83	5000.0
2007-01-10 07:30:00	MSFT	Stock	29.76	29.76	29.76	29.76	1300.0
2007-01-10 08:00:00	MSFT	Stock	29.77	29.82	29.77	29.79	4701.0
2007-01-10 08:30:00	MSFT	Stock	29.76	29.96	29.76	29.8	193300.0
2007-01-10 09:00:00	MSFT	Stock	29.8	29.83	29.75	29.79	53020.0
2007-01-10 09:30:00	MSFT	Stock	29.8	29.89	29.65	29.79	5930006.0
2007-01-10 10:00:00	MSFT	Stock	29.78	29.79	29.59	29.6	5550212.0
2007-01-10 10:30:00	MSFT	Stock	29.59	29.73	29.56	29.71	3368747.0
2007-01-10 11:00:00	MSFT	Stock	29.71	29.72	29.52	29.54	3151485.0
2007-01-10 11:30:00	MSFT	Stock	29.54	29.63	29.53	29.628	2404500.0
2007-01-10 12:00:00	MSFT	Stock	29.622	29.63	29.51	29.52	2193158.0
2007-01-10 12:30:00	MSFT	Stock	29.52	29.59	29.43	29.54	3655713.0
2007-01-10 13:00:00	MSFT	Stock	29.54	29.65	29.53	29.65	3276102.0
2007-01-10 13:30:00	MSFT	Stock	29.66	29.73	29.62	29.728	8663743.0
2007-01-10 14:00:00	MSFT	Stock	29.73	29.74	29.64	29.663	2491948.0
2007-01-10 14:30:00	MSFT	Stock	29.67	29.72	29.64	29.651	2277239.0
2007-01-10 15:00:00	MSFT	Stock	29.659	29.7	29.64	29.67	2931722.0
2007-01-10 15:30:00	MSFT	Stock	29.67	29.68	29.63	29.67	6498476.0

> showing 50 of 53,022 rows — these rows as CSV

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