PREVIEW / stock_30min / 2006-01-12

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-01-12.parquet
  size:    879 KB
  rows:    47,073
  symbols: 2,160

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
2006-01-12 04:00:00	AAPL	Stock	3.0143	3.0143	3.0143	3.0143	2800.0
2006-01-12 04:30:00	AAPL	Stock	3.0286	3.0286	3.0286	3.0286	5600.0
2006-01-12 05:00:00	AAPL	Stock	3.0268	3.0286	3.0268	3.0286	75600.0
2006-01-12 05:30:00	AAPL	Stock	3.0354	3.0357	3.0286	3.0357	92400.0
2006-01-12 06:00:00	AAPL	Stock	3.0375	3.0625	3.0375	3.0621	117600.0
2006-01-12 06:30:00	AAPL	Stock	3.0482	3.0571	3.0446	3.0446	100800.0
2006-01-12 07:00:00	AAPL	Stock	3.0379	3.0446	3.0286	3.0357	865816.0
2006-01-12 07:30:00	AAPL	Stock	3.03	3.0332	3.0232	3.0321	390236.0
2006-01-12 08:00:00	AAPL	Stock	3.0339	3.0607	3.0321	3.0457	15468488.0
2006-01-12 08:30:00	AAPL	Stock	3.0464	3.0464	3.0275	3.0304	7815416.0
2006-01-12 09:00:00	AAPL	Stock	3.0307	3.0361	3.0182	3.0346	13027504.0
2006-01-12 09:30:00	AAPL	Stock	3.0346	3.0496	3.0125	3.0496	183412236.0
2006-01-12 10:00:00	AAPL	Stock	3.0493	3.0593	3.0446	3.0568	114757832.0
2006-01-12 10:30:00	AAPL	Stock	3.0568	3.0804	3.0425	3.0729	118920592.0
2006-01-12 11:00:00	AAPL	Stock	3.0725	3.08	3.0586	3.0714	78998836.0
2006-01-12 11:30:00	AAPL	Stock	3.0718	3.0768	3.0629	3.0732	51542092.0
2006-01-12 12:00:00	AAPL	Stock	3.0732	3.0857	3.0646	3.0664	59910060.0
2006-01-12 12:30:00	AAPL	Stock	3.0668	3.0689	3.0511	3.06	60146884.0
2006-01-12 13:00:00	AAPL	Stock	3.0604	3.0604	3.0357	3.0461	80746232.0
2006-01-12 13:30:00	AAPL	Stock	3.0464	3.0475	3.0179	3.0239	74444412.0
2006-01-12 14:00:00	AAPL	Stock	3.0243	3.0429	2.9996	3.0	114587396.0
2006-01-12 14:30:00	AAPL	Stock	3.0	3.0257	2.9864	3.0089	122445904.0
2006-01-12 15:00:00	AAPL	Stock	3.0094	3.015	3.0014	3.0143	61701724.0
2006-01-12 15:30:00	AAPL	Stock	3.015	3.0268	2.9986	3.0132	104519352.0
2006-01-12 16:00:00	AAPL	Stock	3.0129	3.0143	3.0082	3.0096	3766420.0
2006-01-12 16:30:00	AAPL	Stock	3.0104	3.0121	3.0071	3.0089	875896.0
2006-01-12 17:00:00	AAPL	Stock	3.0089	3.01	3.0007	3.0079	796348.0
2006-01-12 17:30:00	AAPL	Stock	3.0089	3.0129	3.0079	3.0118	274540.0
2006-01-12 18:00:00	AAPL	Stock	3.0136	3.0161	3.0096	3.0129	414736.0
2006-01-12 04:30:00	MSFT	Stock	27.22	27.22	27.22	27.22	100.0
2006-01-12 07:00:00	MSFT	Stock	27.05	27.11	27.05	27.11	3900.0
2006-01-12 07:30:00	MSFT	Stock	27.24	27.24	27.24	27.24	2300.0
2006-01-12 08:00:00	MSFT	Stock	27.14	27.25	27.14	27.25	24144.0
2006-01-12 08:30:00	MSFT	Stock	27.2	27.2	27.2	27.2	2160.0
2006-01-12 09:00:00	MSFT	Stock	27.2	27.28	27.2	27.25	32725.0
2006-01-12 09:30:00	MSFT	Stock	27.25	27.26	27.09	27.15	5617836.0
2006-01-12 10:00:00	MSFT	Stock	27.15	27.18	27.08	27.12	2930979.0
2006-01-12 10:30:00	MSFT	Stock	27.12	27.2	27.11	27.14	2813090.0
2006-01-12 11:00:00	MSFT	Stock	27.16	27.16	27.01	27.06	3735774.0
2006-01-12 11:30:00	MSFT	Stock	27.06	27.12	27.05	27.06	2084795.0
2006-01-12 12:00:00	MSFT	Stock	27.06	27.15	27.0	27.02	2848503.0
2006-01-12 12:30:00	MSFT	Stock	27.01	27.06	27.0	27.018	2573448.0
2006-01-12 13:00:00	MSFT	Stock	27.01	27.07	26.98	27.02	2960608.0
2006-01-12 13:30:00	MSFT	Stock	27.03	27.04	26.97	27.002	2234559.0
2006-01-12 14:00:00	MSFT	Stock	27.0	27.05	26.97	27.01	3538418.0
2006-01-12 14:30:00	MSFT	Stock	27.019	27.04	26.99	27.02	2587649.0
2006-01-12 15:00:00	MSFT	Stock	27.01	27.03	26.99	27.0	2628261.0
2006-01-12 15:30:00	MSFT	Stock	27.01	27.14	26.98	27.14	6657363.0
2006-01-12 16:00:00	MSFT	Stock	27.14	27.16	27.1	27.11	349340.0
2006-01-12 16:30:00	MSFT	Stock	27.12	27.12	27.1	27.1	9384.0

> showing 50 of 47,073 rows — these rows as CSV

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