PREVIEW / stock_30min / 2007-03-06

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-06.parquet
  size:    1.1 MB
  rows:    56,547
  symbols: 2,527

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-03-06 06:00:00	AAPL	Stock	3.1136	3.1136	3.1136	3.1136	5600.0
2007-03-06 06:30:00	AAPL	Stock	3.1271	3.1289	3.1271	3.1289	55720.0
2007-03-06 07:00:00	AAPL	Stock	3.12	3.1321	3.1179	3.1321	585200.0
2007-03-06 07:30:00	AAPL	Stock	3.13	3.1364	3.1204	3.1204	723828.0
2007-03-06 08:00:00	AAPL	Stock	3.1282	3.1321	3.1196	3.13	2155944.0
2007-03-06 08:30:00	AAPL	Stock	3.1286	3.1314	3.1254	3.1304	1051652.0
2007-03-06 09:00:00	AAPL	Stock	3.13	3.1357	3.1286	3.1339	2928072.0
2007-03-06 09:30:00	AAPL	Stock	3.1357	3.1539	3.1293	3.1389	130790100.0
2007-03-06 10:00:00	AAPL	Stock	3.1386	3.1414	3.1214	3.1307	96348140.0
2007-03-06 10:30:00	AAPL	Stock	3.1304	3.1346	3.1225	3.1257	53143272.0
2007-03-06 11:00:00	AAPL	Stock	3.1254	3.1429	3.1254	3.1396	50840972.0
2007-03-06 11:30:00	AAPL	Stock	3.1396	3.1436	3.1354	3.1411	42065100.0
2007-03-06 12:00:00	AAPL	Stock	3.1407	3.1446	3.1321	3.1379	35743680.0
2007-03-06 12:30:00	AAPL	Stock	3.1379	3.14	3.1286	3.1329	29585556.0
2007-03-06 13:00:00	AAPL	Stock	3.1325	3.1386	3.1286	3.1379	29161888.0
2007-03-06 13:30:00	AAPL	Stock	3.1379	3.1446	3.1325	3.1411	42452284.0
2007-03-06 14:00:00	AAPL	Stock	3.1411	3.1436	3.1321	3.1382	28322308.0
2007-03-06 14:30:00	AAPL	Stock	3.1379	3.1396	3.1339	3.1368	22949836.0
2007-03-06 15:00:00	AAPL	Stock	3.1368	3.1411	3.1325	3.1407	51375324.0
2007-03-06 15:30:00	AAPL	Stock	3.1411	3.1518	3.1371	3.1496	93668120.0
2007-03-06 16:00:00	AAPL	Stock	3.1475	3.1532	3.1464	3.1496	4187680.0
2007-03-06 16:30:00	AAPL	Stock	3.1507	3.1518	3.1468	3.1507	1269352.0
2007-03-06 17:00:00	AAPL	Stock	3.1518	3.1536	3.1381	3.1381	1131900.0
2007-03-06 17:30:00	AAPL	Stock	3.1518	3.1536	3.15	3.1529	53564.0
2007-03-06 18:00:00	AAPL	Stock	3.1521	3.1532	3.1521	3.1532	52920.0
2007-03-06 18:30:00	AAPL	Stock	3.1532	3.1536	3.1507	3.1536	58772.0
2007-03-06 19:00:00	AAPL	Stock	3.1507	3.1536	3.15	3.1536	105000.0
2007-03-06 19:30:00	AAPL	Stock	3.1536	3.1536	3.15	3.1536	267512.0
2007-03-06 06:00:00	MSFT	Stock	27.75	27.76	27.75	27.75	2600.0
2007-03-06 07:30:00	MSFT	Stock	27.79	27.82	27.79	27.8	17540.0
2007-03-06 08:00:00	MSFT	Stock	27.8	27.86	27.77	27.86	23539.0
2007-03-06 08:30:00	MSFT	Stock	27.81	27.94	27.8	27.85	56420.0
2007-03-06 09:00:00	MSFT	Stock	27.87	27.9	27.76	27.83	194874.0
2007-03-06 09:30:00	MSFT	Stock	27.86	27.94	27.71	27.86	7534243.0
2007-03-06 10:00:00	MSFT	Stock	27.85	27.93	27.75	27.787	4649068.0
2007-03-06 10:30:00	MSFT	Stock	27.79	27.9	27.65	27.66	4134754.0
2007-03-06 11:00:00	MSFT	Stock	27.67	27.78	27.65	27.77	2354757.0
2007-03-06 11:30:00	MSFT	Stock	27.77	27.78	27.69	27.71	2175926.0
2007-03-06 12:00:00	MSFT	Stock	27.7	27.76	27.691	27.7	1828641.0
2007-03-06 12:30:00	MSFT	Stock	27.7	27.76	27.691	27.73	1732031.0
2007-03-06 13:00:00	MSFT	Stock	27.72	27.75	27.72	27.74	1526516.0
2007-03-06 13:30:00	MSFT	Stock	27.74	27.8	27.71	27.73	2779973.0
2007-03-06 14:00:00	MSFT	Stock	27.74	27.79	27.72	27.75	1706919.0
2007-03-06 14:30:00	MSFT	Stock	27.76	27.92	27.71	27.77	1830118.0
2007-03-06 15:00:00	MSFT	Stock	27.77	27.84	27.76	27.81	3464584.0
2007-03-06 15:30:00	MSFT	Stock	27.82	27.88	27.77	27.83	8536138.0
2007-03-06 16:00:00	MSFT	Stock	27.81	27.83	27.8	27.83	1009707.0
2007-03-06 16:30:00	MSFT	Stock	27.82	27.82	27.82	27.82	5900.0
2007-03-06 17:00:00	MSFT	Stock	27.82	27.82	27.731	27.731	7100.0
2007-03-06 17:30:00	MSFT	Stock	27.82	27.82	27.82	27.82	800.0

> showing 50 of 56,547 rows — these rows as CSV

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