PREVIEW / stock_30min / 2007-06-01

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-01.parquet
  size:    979 KB
  rows:    52,372
  symbols: 2,650

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-06-01 07:00:00	AAPL	Stock	4.3168	4.3168	4.3168	4.3168	9800.0
2007-06-01 07:30:00	AAPL	Stock	4.3196	4.3196	4.3107	4.3143	30520.0
2007-06-01 08:00:00	AAPL	Stock	4.3136	4.3457	4.3107	4.3329	3083668.0
2007-06-01 08:30:00	AAPL	Stock	4.3325	4.3457	4.3314	4.3368	3556308.0
2007-06-01 09:00:00	AAPL	Stock	4.3357	4.3357	4.3204	4.3268	3224172.0
2007-06-01 09:30:00	AAPL	Stock	4.3246	4.3282	4.2432	4.2743	173349792.0
2007-06-01 10:00:00	AAPL	Stock	4.2732	4.3246	4.2621	4.2782	102883956.0
2007-06-01 10:30:00	AAPL	Stock	4.2781	4.2843	4.2579	4.265	68959464.0
2007-06-01 11:00:00	AAPL	Stock	4.2657	4.2821	4.2571	4.2732	43861692.0
2007-06-01 11:30:00	AAPL	Stock	4.2732	4.2754	4.25	4.2579	51610188.0
2007-06-01 12:00:00	AAPL	Stock	4.2582	4.2654	4.2379	4.2446	58994936.0
2007-06-01 12:30:00	AAPL	Stock	4.2446	4.2568	4.2275	4.2443	54110112.0
2007-06-01 13:00:00	AAPL	Stock	4.2439	4.2536	4.2246	4.2518	56400484.0
2007-06-01 13:30:00	AAPL	Stock	4.2518	4.2636	4.2439	4.2475	46277756.0
2007-06-01 14:00:00	AAPL	Stock	4.2471	4.2631	4.2468	4.255	38065944.0
2007-06-01 14:30:00	AAPL	Stock	4.2554	4.2554	4.2393	4.2525	38495856.0
2007-06-01 15:00:00	AAPL	Stock	4.2529	4.2571	4.2379	4.2411	41519548.0
2007-06-01 15:30:00	AAPL	Stock	4.2414	4.2429	4.225	4.2268	83623624.0
2007-06-01 16:00:00	AAPL	Stock	4.2282	4.2571	4.2275	4.2318	2294628.0
2007-06-01 16:30:00	AAPL	Stock	4.2314	4.2361	4.2282	4.2329	1205372.0
2007-06-01 17:00:00	AAPL	Stock	4.2325	4.2361	4.2307	4.2361	88284.0
2007-06-01 17:30:00	AAPL	Stock	4.2375	4.2389	4.2343	4.2357	660436.0
2007-06-01 18:00:00	AAPL	Stock	4.2389	4.2389	4.2311	4.2311	95704.0
2007-06-01 18:30:00	AAPL	Stock	4.2329	4.2379	4.2329	4.2375	42084.0
2007-06-01 19:00:00	AAPL	Stock	4.2375	4.2439	4.2329	4.2429	481236.0
2007-06-01 19:30:00	AAPL	Stock	4.2393	4.2393	4.2321	4.2382	92120.0
2007-06-01 08:00:00	MSFT	Stock	30.78	30.78	30.75	30.78	6051.0
2007-06-01 08:30:00	MSFT	Stock	30.77	30.84	30.75	30.78	33033.0
2007-06-01 09:00:00	MSFT	Stock	30.77	30.8	30.77	30.79	11436.0
2007-06-01 09:30:00	MSFT	Stock	30.79	30.9	30.77	30.85	4342038.0
2007-06-01 10:00:00	MSFT	Stock	30.84	30.89	30.71	30.71	3775012.0
2007-06-01 10:30:00	MSFT	Stock	30.72	30.74	30.62	30.66	4093868.0
2007-06-01 11:00:00	MSFT	Stock	30.67	30.73	30.62	30.6275	2524182.0
2007-06-01 11:30:00	MSFT	Stock	30.62	30.64	30.59	30.6	2138681.0
2007-06-01 12:00:00	MSFT	Stock	30.6	30.62	30.55	30.6199	2418908.0
2007-06-01 12:30:00	MSFT	Stock	30.62	30.68	30.61	30.65	2040283.0
2007-06-01 13:00:00	MSFT	Stock	30.65	30.71	30.61	30.71	1708190.0
2007-06-01 13:30:00	MSFT	Stock	30.7	30.74	30.7	30.72	2264062.0
2007-06-01 14:00:00	MSFT	Stock	30.72	30.74	30.69	30.69	1579746.0
2007-06-01 14:30:00	MSFT	Stock	30.69	30.72	30.67	30.7	1892795.0
2007-06-01 15:00:00	MSFT	Stock	30.7	30.79	30.65	30.68	2556856.0
2007-06-01 15:30:00	MSFT	Stock	30.68	30.69	30.56	30.6	5046064.0
2007-06-01 16:00:00	MSFT	Stock	30.61	30.7628	30.6	30.62	552691.0
2007-06-01 16:30:00	MSFT	Stock	30.62	30.67	30.62	30.67	28520.0
2007-06-01 17:00:00	MSFT	Stock	30.65	30.67	30.65	30.65	6500.0
2007-06-01 17:30:00	MSFT	Stock	30.65	30.65	30.65	30.65	10000.0
2007-06-01 18:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	5322.0
2007-06-01 19:00:00	MSFT	Stock	30.63	30.63	30.6	30.6	2954.0
2007-06-01 19:30:00	MSFT	Stock	30.64	30.64	30.64	30.64	5000.0
2007-06-01 08:00:00	NVDA	Stock	0.5825	0.5833	0.5825	0.5833	628200.0

> showing 50 of 52,372 rows — these rows as CSV

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